QUESTION 18 From: Principles of Finance with Excel 3rded, Benninga and Mofkadf, 2018, 2011, 2006 You just bought the first floor of the famous"Egg-Plant. Buiding for $250,000. You Plan to rent the space to d you a mortgage wih the following terms PART A Mortgage Principal: Solve for he Monthly Payments: Term in Months: APR: nitiaion Foo: Points: Points as a % 250,000.00 Use PMT SunctionNIA 36 800% 1,500.00 1.00% What is the EAIR of the Mortgage? Monthly Rate Using Rate Funtetion: EAIR Complete the Amortization Table USE THE IPMT and PPMT Functions 0.00% BEG. PRINC. BAL PAYMENT IPNT PPMT Check your EAIR by Filling in the C.F.Table and Caiculating the IRREAIR