%% function [monPay tPayToYear] = MonthlyPayment(totalLoan, downPayment, loanYears, annualInterest, flagPrintMonthly, monPayGuess) %The following example is a 15-year loan of $150,000 (=200k-50k) at a fixed annual interest of 4.5%: Monthly Payment = $1,148; Total Payment to Bank (over 15 years) = $206,549 >> MonthlyPayment_Zheng(200000, 50000, 15, 4.5); Summary: Monthly Payment = 1147.49; Total Payment = 206548.88; Total Interest = 56548.88 Year pLoan pItst tPay Debt 1 7167 6603 13770 142833 2 14662 12878 27540 135338 3 22502 18807 41310 127498 4 30703 24377 55080 119297 5 39280 29570 68850 110720 6 48251 34369 82620 101749 7 57634 38756 96389 92366 8 67448 42711 110159 82552 9 77713 46216 123929 72287 10 88450 49249 137699 61550 11 99680 51789 151469 50320 12 111426 53813 165239 38574 13 123711 55298 179009 26289 14 136561 56218 192779 13439 15 150001 56548 206549 -1 >> _______________________________________________________________________________ %%Print out a detailed list month-by-month when set flagPrintMonthly = 1 >> MonthlyPayment(200000, 50000, 15, 4.5, 1); Summary: Monthly Payment = 1147.49; Total Payment = 206548.88; Total Interest = 56548.88 Year pLoan pItst tPay Debt M1 585 563 1147 149415 M2 1172 1123 2295 148828 M3 1762 1681 3442 148238 M4 2353 2237 4590 147647 M5 2947 2790 5737 147053 M6 3543 3342 6885 146457 M7 4141 3891 8032 145859 M8 4742 4438 9180 145258 M9 5345 4983 10327 144655 M10 5950 5525 11475 144050 M11 6557 6065 12622 143443 M12 7167 6603 13770 142833 _Y1 7167 6603 13770 142833 M1 7778 7139 14917 142222 M2 8393 7672 16065 141607 M3 9009 8203 17212 140991 M4 9628 8732 18360 140372 M5 10249 9258 19507 139751 M6 10872 9783 20655 139128 M7 11498 10304 21802 138502 M8 12126 10824 22950 137874 M9 12757 11341 24097 137243 M10 13390 11855 25245 136610 M11 14025 12368 26392 135975 M12 14662 12878 27540 135338 _Y2 14662 12878 27540 135338 M1 15302 13385 28687 134698 M2 15945 13890 29835 134055 M3 16589 14393 30982 133411 M4 17237 14893 32130 132763 M5 17886 15391 33277 132114 M6 18538 15886 34425 131462 M7 19193 16379 35572 130807 M8 19850 16870 36720 130150 M9 20509 17358 37867 129491 M10 21171 17844 39015 128829 M11 21836 18327 40162 128164 M12 22502 18807 41310 127498 _Y3 22502 18807 41310 127498 M1 23172 19285 42457 126828 M2 23844 19761 43605 126156 M3 24518 20234 44752 125482 M4 25195 20705 45900 124805 M5 25875 21173 47047 124125 M6 26557 21638 48195 123443 M7 27241 22101 49342 122759 M8 27928 22561 50490 122072 M9 28618 23019 51637 121382 M10 29310 23474 52785 120690 M11 30005 23927 53932 119995 M12 30703 24377 55080 119297 _Y4 30703 24377 55080 119297 M1 31403 24824 56227 118597 M2 32106 25269 57375 117894 M3 32811 25711 58522 117189 M4 33519 26151 59670 116481 M5 34230 26587 60817 115770 M6 34943 27022 61965 115057 M7 35659 27453 63112 114341 M8 36378 27882 64260 113622 M9 37099 28308 65407 112901 M10 37823 28731 66555 112177 M11 38550 29152 67702 111450 M12 39280 29570 68850 110720 _Y5 39280 29570 68850 110720 M1 40012 29985 69997 109988 M2 40747 30398 71145 109253 M3 41485 30807 72292 108515 M4 42225 31214 73440 107775 M5 42969 31618 74587 107031 M6 43715 32020 75735 106285 M7 44464 32418 76882 105536 M8 45216 32814 78030 104784 M9 45970 33207 79177 104030 M10 46727 33597 80325 103273 M11 47488 33984 81472 102512 M12 48251 34369 82620 101749 _Y6 48251 34369 82620 101749 M1 49017 34750 83767 100983 M2 49786 35129 84915 100214 M3 50557 35505 86062 99443 M4 51332 35878 87210 98668 M5 52109 36248 88357 97891 M6 52890 36615 89505 97110 M7 53673 36979 90652 96327 M8 54459 37340 91800 95541 M9 55248 37699 92947 94752 M10 56041 38054 94094 93959 M11 56836 38406 95242 93164 M12 57634 38756 96389 92366 _Y7 57634 38756 96389 92366 M1 58435 39102 97537 91565 M2 59239 39445 98684 90761 M3 60046 39786 99832 89954 M4 60856 40123 100979 89144 M5 61670 40457 102127 88330 M6 62486 40788 103274 87514 M7 63305 41117 104422 86695 M8 64128 41442 105569 85872 M9 64953 41764 106717 85047 M10 65782 42083 107864 84218 M11 66613 42399 109012 83387 M12 67448 42711 110159 82552 _Y8 67448 42711 110159 82552 M1 68286 43021 111307 81714 M2 69127 43327 112454 80873 M3 69971 43631 113602 80029 M4 70819 43931 114749 79181 M5 71669 44228 115897 78331 M6 72523 44521 117044 77477 M7 73380 44812 118192 76620 M8 74240 45099 119339 75760 M9 75104 45383 120487 74896 M10 75970 45664 121634 74030 M11 76840 45942 122782 73160 M12 77713 46216 123929 72287 _Y9 77713 46216 123929 72287 M1 78590 46487 125077 71410 M2 79469 46755 126224 70531 M3 80352 47019 127372 69648 M4 81239 47281 128519 68761 M5 82128 47538 129667 67872 M6 83021 47793 130814 66979 M7 83918 48044 131962 66082 M8 84817 48292 133109 65183 M9 85720 48536 134257 64280 M10 86627 48777 135404 63373 M11 87537 49015 136552 62463 M12 88450 49249 137699 61550 _Y10 88450 49249 137699 61550 M1 89367 49480 138847 60633 M2 90287 49708 139994 59713 M3 91210 49931 141142 58790 M4 92137 50152 142289 57863 M5 93068 50369 143437 56932 M6 94002 50582 144584 55998 M7 94939 50792 145732 55061 M8 95880 50999 146879 54120 M9 96825 51202 148027 53175 M10 97773 51401 149174 52227 M11 98725 51597 150322 51275 M12 99680 51789 151469 50320 _Y11 99680 51789 151469 50320 M1 100639 51978 152617 49361 M2 101601 52163 153764 48399 M3 102567 52345 154912 47433 M4 103537 52523 156059 46463 M5 104510 52697 157207 45490 M6 105487 52867 158354 44513 M7 106467 53034 159502 43533 M8 107452 53198 160649 42548 M9 108440 53357 161797 41560 M10 109431 53513 162944 40569 M11 110427 53665 164092 39573 M12 111426 53813 165239 38574 _Y12 111426 53813 165239 38574 M1 112428 53958 166387 37572 M2 113435 54099 167534 36565 M3 114445 54236 168682 35555 M4 115460 54369 169829 34540 M5 116478 54499 170977 33522 M6 117499 54625 172124 32501 M7 118525 54747 173272 31475 M8 119554 54865 174419 30446 M9 120588 54979 175567 29412 M10 121625 55089 176714 28375 M11 122666 55195 177862 27334 M12 123711 55298 179009 26289 _Y13 123711 55298 179009 26289 M1 124760 55397 180157 25240 M2 125813 55491 181304 24187 M3 126870 55582 182452 23130 M4 127930 55669 183599 22070 M5 128995 55751 184747 21005 M6 130064 55830 185894 19936 M7 131137 55905 187041 18863 M8 132213 55976 188189 17787 M9 133294 56042 189336 16706 M10 134379 56105 190484 15621 M11 135468 56164 191631 14532 M12 136561 56218 192779 13439 _Y14 136561 56218 192779 13439 M1 137658 56268 193926 12342 M2 138759 56315 195074 11241 M3 139865 56357 196221 10135 M4 140974 56395 197369 9026 M5 142088 56429 198516 7912 M6 143205 56458 199664 6795 M7 144327 56484 200811 5673 M8 145454 56505 201959 4546 M9 146584 56522 203106 3416 M10 147719 56535 204254 2281 M11 148858 56544 205401 1142 M12 150001 56548 206549 -1 _Y15 150001 56548 206549 -1 >>