CHAPTER 4 MATLAB Programming 4.12 Home loans are usually made for 15- or 30-year periods, with payments made monthly. An amortization table is often useful for a borrower to see how much interest is being paid each month, and the remaining balance of the loan each month. Consider a 30-year $200,000 loan at an annual inter- est rate of 6.0% (360 payment periods, interest = 0.5% per month). From economic formulas, 1199.10. Write a MATLAB program to create a text file containing an amortization table for this loan. For each month, show the balance before the payment is made (the previous balance times 1.005), the payment, and the new balance after the payment is subtracted. Format the table similar to Figure P4.12A (only 12 of 360 lines shown). Use a while loop to determine when the balance goes of the file to show the overpayment that will be refunded to the borrower, as shown in Figure P4.12B. (Note: The $1,199.11 payment was rounded up to the nearest cent, resulting in a slight overpayment over the 360 months. If the payment had been rounded down to $1,199.10, then there would be a small balance remaining after 360 payments.) we can calculate that the monthly payment should be below zero and add a formatted statement at the end Beginning Balance Ending Balance Month 201000.00 00799.89 200598-79 200396.68 200193.S5 99989.42 99784.26 99578.0 99370.86 99162-6 198953.32 198742.98 1199.11 1199.11 1199.11 199.11 1199.11 1199.11 1199.11 1199.11 1199.11 1199.11 1199.11 1199.11 199800.89 19900-78 99399.68 99197.57 98994-44 198790.31 198585.15 98378.98 98171-75 97963.50 197754.21 97543.87 10 12 Figure P4.12A 359 3 60 383.31 190.12 199-11 199.11 1104.20 -8.99 Final balance to be refunded8.99 Figure P4.12B