please do it on excel

Home Insert Draw Page Layout Formulas Data Review View Tell me Calibrl (Body) 11 A A Wrap Text General Fineart Dalene B a.A. Merge Center S% , Corential format Cal Formatting Tastys Format 15 Xf A B D E F G H 1 J You want to buy a $300,000 house. You plan to make a down payment of 20% of the purchase price and finance the rest with a 30-year fixed rate mortgage loan. The loan is fully amortizing, and requires monthly payments at the end of each month. The annual interest for the loan is 5%, compounded monthly 1) How much of the purchase price will you finance with the mortgage loan? 2) What is your anticipated monthly mortgage payment? 1 Answer Answer Use the appropriate formulas and Excel function to solve the problem (typed in solutions receive o credit) 2 3 4 1) Loan amount 5 6 2) Monthly payment 7 8 N 9 10 PV 11 PMT 12 FV 13 14 15 16 17 18 19 20 21 22 23 24 25 Question Question Question 4 Questions +