Question: hi is the table i inputted correct? if not how would it look like in the annual payments. thanks! H Please complete the following amortization
H Please complete the following amortization schedule for this fully amortizing loan (assume annual payments). Loan Principal Loan Term Interest Rate $4,000,000 15 10.00% Interest Principal 1 O Nm 4 5 6 7 8 Begin $4,000,000 $4,000,000 $3,874,105 $3,748,210 $3,622,315 $3,496,420 $3,370,524 $3,244,629 $3,118,734 $2,992,839 $2,866,944 $2,741,049 $2,615,154 $2489,259 $2,363,364 $2,237468 PMT $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $525,895 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 $125,895.11 End $4,000,000 $3,874,105 $3,748,210 $3,622,315 $3,496,420 $3,370,524 $3,244,629 $3,118,734 $2,992,839 $2,866,944 $2,741,049 $2,615,154 $2,489,259 $2,363,364 $2,237468 $2,111,573 9 10 11 12 13 14 15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
