8.28 You are buying a new home for $416 000. You have an agreement with the savings and loan company to borrow the needed money if you pay 20 percent in cash and monthly payments for 30 years at an interest rate of 4.15 percent compounded monthly. (a) What monthly payments will be required? A: (6) How much principal reduction will occur in the first payment? A: (C) Prepare a spreadsheet that will show each payment, how much of each will go to principal and how much to interest, the current balance, and the cumulative interest paid. 8.28 You are buying a new home for $416 000. You have an agreement with the savings and loan company to borrow the needed money if you pay 20 percent in cash and monthly payments for 30 years at an interest rate of 4.15 percent compounded monthly. (a) What monthly payments will be required? A: (6) How much principal reduction will occur in the first payment? A: (C) Prepare a spreadsheet that will show each payment, how much of each will go to principal and how much to interest, the current balance, and the cumulative interest paid