Please show Excel Formulas used

2. (15 points) Using excel file to create the amortization schedule for a mortgage of $450,000.00 with a rate of 1.85% (APR) for 15 years. Your excel file must contain the following information. Payment Schedule Payment Date Interest Due No. Interest Rate Principal Paid Year Payment Due 1 2 3 4 5 6 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 2022-07-01 2022-08-01 2022-09-01 2022-10-01 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 693.82 690.48 687.13 683.77 680.40 677.04 673.66 670.28 666.90 663.51 660.12 656.72 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,171.03 2,174.37 2,177.72 2,181.08 2,184.45 2,187.81 2,191.19 2,194.57 2,197.95 2,201.34 2,204.73 2,208.13 Balance $450,000.00 447,828.97 445,654.60 443,476.88 441,295.80 439,111.35 436,923.54 434,732.35 432,537.78 430,339.83 428,138.49 425,933.76 423,725.63 7 8 9 10 11 12 1 2. (15 points) Using excel file to create the amortization schedule for a mortgage of $450,000.00 with a rate of 1.85% (APR) for 15 years. Your excel file must contain the following information. Payment Schedule Payment Date Interest Due No. Interest Rate Principal Paid Year Payment Due 1 2 3 4 5 6 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 2022-07-01 2022-08-01 2022-09-01 2022-10-01 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 1.850% 693.82 690.48 687.13 683.77 680.40 677.04 673.66 670.28 666.90 663.51 660.12 656.72 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,864.85 2,171.03 2,174.37 2,177.72 2,181.08 2,184.45 2,187.81 2,191.19 2,194.57 2,197.95 2,201.34 2,204.73 2,208.13 Balance $450,000.00 447,828.97 445,654.60 443,476.88 441,295.80 439,111.35 436,923.54 434,732.35 432,537.78 430,339.83 428,138.49 425,933.76 423,725.63 7 8 9 10 11 12 1