In: Finance
A borrower and lender agree that a 9,000,000 loan made at 12% interest for 30years will have a 600,000 balance on the maturity date if the loan will be on constant amortization mortgage (CAM) terms. Determine how much will be paid monthly and prepare a loan payment schedule for the first 4 months.
| Loan amount | 9,000,000 | ||||||
| Loan Balance after 30year | 600,000 | ||||||
| Total principal payment | 8,400,000 | (9000000-600000) | |||||
| Number of months of payment | 360 | (30*12) | |||||
| Constant amortization per month | 23,333.33 | (8400000/360) | |||||
| Monthly interest =(12/12)=1% | |||||||
| LOAN AMORTIZATION SCHEDULE | |||||||
| A | B=A*1% | C | D | E=A-C | |||
| Month | Beginning Balance | Interest | Principal | Total Payment | Ending Balance | ||
| 1 | 9,000,000 | 90,000 | 23,333.33 | 113,333.33 | 8,976,666.67 | ||
| 2 | 8,976,666.67 | 89,767 | 23,333.33 | 113,100.00 | 8,953,333.33 | ||
| 3 | 8,953,333.33 | 89,533 | 23,333.33 | 112,866.67 | 8,930,000.00 | ||
| 4 | 8,930,000.00 | 89,300 | 23,333.33 | 112,633.33 | 8,906,666.67 | ||