Create a 30-year (maximum), monthly amortization schedule using Excel (or some other spreadsheet program). Assume a fixed rate of interest and monthly payments that occur at the end of the month. The spreadsheet you create should have three input fields (loan amount, years, and interest rate). All other calculations in the spreadsheet should be based on these cells and should not need to be changed when one of these cells changes. In other words, the amortization schedule should automatically recalculate when either the loan amount or the interest rate changes. See the attached for an example of what the spreadsheet should look like. Hints: 1. Use the PMT function to determine monthly payments. 2. Use dollar signs in your cell references to freeze references. For example, if you are going to be copying a formula down a column, and you want each formula in that column to reference cell C1 then enter C$1 in the first formula. When you copy this formula down, the reference will not change to C2 but stay