Complete the attached Microsoft Excel Spreadsheet to construct a mortgage amortization solver for a 30 year $300,000 loan at 3.25% interest

Input the annual interest rate and solve for monthly interest rate. Show the Effective Rate of interest (just so I know you know the formula - you won't use it after)

Calculate the number of months that this loan will be paid

Use the correct Excel formula (from the slides) to compute the monthly mortgage payment.

It goes down to 360. Please show all the work and formulas that you need to put into excel too. Thank you

Week 2 Excel Assignment - Excel Mitch Meleedy Ga File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share 16 X = Calibri - 11 - - A d! Wrap Text General WE 49 B Insert Delete Format Paste BIU A = Merge & Center & $ %) 6.000 .00.0 Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing E3 fx A D E F G H 1 1 2 3 B C Amount borrowed? $300,000.00 Interest Rate? Annual (C2) and Monthly (D2) 3.2500% Effective Rate of Interest? Number of payment Years (C4) and Months (D4) 30 Solved for Amount of PMT? Crossover Payment # (when you pay more principal than interest)? 4 Payment Starting Balance Interest Principal Ending Balance Total Interest Paid to Date 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 47 17 18 19 20 21 4 5 6 7 1 8 9 9 10 11 12 13 4 11 F Mortgage Amortizer Ready tAccessibility: Good to go Type here to search al 100% O 21F 3:05 PM 1/26/2022