Using the principles from Sidebar 16-3, prepare an amortization schedule for a 30-year loan with monthly payments. The amortization schedule should be set up as shown in Figure 16-2 and allow the user...

Using the principles from Sidebar 16-3, prepare an amortization schedule for a 30-year loan with monthly payments. The amortization schedule should be set up as shown in Figure 16-2 and allow the user to change the schedule by changing the APR and the loan amount (the ending principal for month 0). The spreadsheet should calculate the monthly payment. Be sure to round the monthly payment and monthly interest to whole pennies. Test your spreadsheet by entering the data from Appendix E and compare your spreadsheet’s solution to the appendix. Hint: The last payment needs to be adjusted to bring the balance to zero at the end of 30 years.