Q15.2 A loan of $500,000, with an annual interest rate of 4%. Amortization period is 30 years. Payment period is monthly. Calculate

1. monthly payment, interest paid, principal paid at each payment period (360 intotal)

2. the first year total principal paid, and total interest paid.

Solution: 19839.73 8805.18

3. the last year total principal paid, and total interest paid. Compare with 2, think about they are so different.

Solution: 611.10 28033.81

4. The total interest paid at the end of term.

Solution: 359347.53

5. If people made a pre-payment of $50000 at the end of 5th year (i.e. the principal at the beginning of 61th month decreases $50000) . Calculate the total interest paid at the end of term (assume the total loan term is still 30 years). Compare with 4.

Solution: 330683.56

I need help with this in matlab programming please...