If you are buying a condo for $800,000, you have made a down payment of $160,000, and you will pay the rest on a 30-year mortgage at 6% annual interest. Make a loan amortization table of schedule and calculate ‘P&I’ and the ‘truth of lending. 

Future Value Tabl 1% 2% 1 1.010 1.020 3% 1.030 1.061 1.093 1.243 1.268 1.294 4% 1.040 1.082 1.125 1.170 1.217 1.265 1.316 1.369 2 1.020 1.040 3 1.030 1.061 4 1.041 1.082 1.126 5 1.051 1.104 1.159 6 1.062 1.126 1.194 7 1.072 1.149 1.230 8 1.083 1.172 9 1.094 1.195 10 1.105 1.218 11 1.116 12 1.127 1.267 1.423 1.305 1.344 1.384 1.426 13 1.138 1.469 14 1.149 1.319 1.513 15 1.161 1.346 1.558 16 1.173 1.373 1.605 2.183 17 1.184 1.400 1.653 2.292 2.693 18 1.196 1.428 1.702 2.026 2.407 19 1.208 1.457 1.754 2.107 2.527 1.806 2.191 2.653 20 1.220 1.486 21 1.232 2.279 1.516 2.786 1.860 22 1.245 1.916 2.370 2.925 1.546 23 1.257 1.577 1.974 2.465 2.033 2.563 2.094 2.666 2.157 2.772 2.221 2.883 2.288 2.999 2.357 2.427 2.500 2.575 1.551 1.480 1.629 1.539 1.601 1.801 1.873 1.948 5% 1.050 1.103 1.158 1.216 1.276 1.340 1.419 1.407 1.504 1.477 1.594 1.689 6% 7% 1.060 1.070 1.124 1.191 3.119 3.243 3.373 1.665 1.980 1.732 2.079 3.508 3.648 1.791 1.710 1.898 2.012 1.262 1.338 3.072 3.225 1.145 1.225 1.311 1.403 1.501 1.606 1.718 1.838 1.967 2.105 2.252 1.796 2.133 1.886 2.261 2.397 2.540 24 1.270 1.608 25 1.282 1.641 3.386 26 1.295 1.673 3.556 27 1.308 1.707 3.733 28 1.321 1.741 3.920 29 1.335 1.776 4.116 30 1.348 1.811 4.322 31 1.361 1.848 4.538 6.088 32 1.375 1.885 4.765 6.453 1.922 2.652 33 1.389 34 1.403 3.794 2.732 5.003 5.253 1.961 35 1.417 2.000 2.814 5.516 3.946 5.792 2,898 4.104 36 1.431 2.040 6.081 4.268 37 1.445 2.081 2.985 4.439 6.385 3.075 3.167 6.705 4.616 1.489 2.208 3.262 4.801 7.040 10.286 14.947 38 1,460 2.122 9.154 13.079 39 1.474 2.165 9.704 13.995 40 8% 9% 1.080 1.090 1.166 1.188 1.295 1.412 1.539 1.260 1.360 1.469 1.587 2.518 2.410 2.720 2.579 2.937 2.759 3.172 2.952 3.426 3.159 3.700 3.996 4.316 3.870 4.661 4.141 5.034 3.604 4.430 5.437 3.820 4.741 5.871 4.049 5.072 4.292 5.427 4.549 5,807 6.214 4.822 5.112 6.649 5.418 7.114 5.743 7.612 8.145 8.715 9.325 3.380 2.854 3.617 3.026 3.207 3.400 1.714 1.851 1.999 2.159 2.332 6.341 6.848 7.396 7.988 6.627 9.317 10.063 10.868 11.737 12.676 6.841 7.251 9.978 13.690 7.686 10.677 8.147 11.424 8.636 12.224 14.785 15.968 17.246 18.625 20.115 21.725 1.611 1.677 1.772 1.828 1.949 1.993 2.144 2.358 2.172 2.367 2.580 2.813 3.066 3.342 3.642 3.970 10% 1.100 1.210 7.258 7.911 16% 17% 1.160 1.170 1.346 1.369 1.561 1.811 2,100 2.436 2.826 2.660 3.059 3.278 3.511 3.759 4.108 3.518 3.803 4.435 3.707 4.046 4.411 4.807 5.234 4.226 4.652 5.117 5.624 6.176 5.936 6.580 7.288 4.818 5.350 5.492 6.153 6.886 7.699 5.535 6.261 7.076 7.988 9.007 8.599 10.147 11.974 6.254 7.138 9.266 10.539 13.590 6.130 7.067 8.137 14.129 16.172 5.311 5.895 6.866 7.986 9.276 6.544 9.024 7.690 10.197 8.613 8.137 9.358 10,748 12.330 12.468 10.761 16.672 14.426 12.375 14.463 19.673 16.879 19.748 23.214 16.777 19.461 23.106 27.393 22.574 27.034 7.263 8.062 9.646 8.949 10.804 32.429 32.324 38.591 9.934 12,100 26.186 31.629 38.142 45.923 8.954 11.026 13.552 45.008 54.649 9.850 12.239 15.179 65.032 10.835 13.585 17,000 11.918 15.080 53.109 62.669 77.388 92.092 73.949 87.260 109.589 130.411 155.189 10.575 14.232 12.056 16.367 11.523 13.743 18.822 13.021 15.668 21.645 14.714 17.861 16.627 24.891 30.376 37.006 20.362 28.625 35.236 43.297 18.788 23.212 40.874 26,462 50.658 32.919 21.231 47.414 59.270 37.857 30.167 19.040 23.991 27.109 34,390 43.535 55.000 69.345 21.325 81.134 102.967 $0.066 63.800 23.884 30.633 39.204 26.750 $7.575 74.009 94.927 121.501 34.616 44.693 66.212 39.116 50.950 29.960 76.144 219.764 44.201 99.586 129.946 169.177 58.083 33.555 261.519 37.582 49.947 66.215 87.565 115.520 152.036 199.629 21.114 28.206 15.763 311.207 56.440 42.092 75.485 100.700 134.003 177.883 235.563 17.182 23.225 31.308 370.337 86.053 115.805 155.443 208.123 277.964 63.777 47.143 25.548 34.752 18.728 440.701 72.069 28.102 38.575 $2.800 98.100 133.176 180.314 243.503 327.997 20.414 524.434 81.437 111.834 153.152 209.164 284.899 387.037 59.136 22.251 30.913 42.818 624.076 34.004 47.528 92.024 127.491 176.125 242.631 333.332 456.703 24.254 66.232 1020.675 742.651 74.180 103.987 145.340 202.543 281.452 389.998 $38.910 37.404 52.756 26.437 1224.810 883.754 117.505 165.687 232.925 326.484 456.298 635.914 28.816 83.081 41.145 58.559 132.782 188.884 267.864 378.721 $33.869 750.378 1051.668 1469.772 31.409 45.259 65.001 93.051 13.110 16.739 18.580 14.421 15.863 20.624 17.449 22.892 85.850 111.065 143.371 184.675 13.268 19.194 25.410 14.462 708.802 850.562 8.623 9.399 1.331 1.464 2.558 2.594 2.839 3.106 2.853 3.152 3.138 3.498 3.896 3.883 4.363 3.452 3.797 4.887 4.310 4.177 4.785 5.474 4.595 4.328 5.054 4.717 5.560 5.142 6.116 5.604 6.727 6.109 7.400 6.659 8.140 10.245 11.167 12.172 12% 1.120 1.254 11% 1.110 1.232 1.368 1.405 1.518 1.574 1.685 1.762 1.870 1.974 2.076 2.211 2.305 2.476 2.773 13% 1.130 14% 1.140 1.277 1.300 1.443 1.482 1.630 1.689 1.842 1.925 2.082 2.195 2.353 2.502 2.658 2.853 3.004 3.252 3.395 15% 1.150 1.323 1.521 1.749 3.479 3.836 4.335 4.898 18% 1.180 1.392 1.643 1.602 1.874 1.939 2.192 2.288 2.700 3.185 3.001 2.565 2.011 2.313 19% 1.190 1.416 1.685 2.005 2.386 2.840 3.379 4.021 4.785 5.695 6.777 8.064 9.596 11.420 20% 1.200 1.440 19.244 22.901 27.252 1.728 2.074 2.488 2.986 3.583 4.300 5.160 6.192 7.430 8.916 10.669 12.839 15.407 18.488 22.186 26.623 31.948 38.338 46.005 55.206 66.247 79.497 95.396 114.475 137.371 164.845 197.814 237.376 284.852 341.822 410.186 492.224 590.668