Please show me the formulas I need to put in to get each number Thank you)

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

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 & $ %) 4.000 .00 7.0 Conditional Format as Cell Formatting Table Styles Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing E3 - A D E F G H 1 1 2 2 3 B 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 (04) 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 11 Mortgage Amortizer Select destination and press ENTER or choose Paste la al 100% H Type here to search O 21F 3:03 PM 1/26/2022