Q4. You have obtained a $135,000, 6.5%, 30-year mortgage? What is your monthly payment? PMT(N=360, I/y = 8.90, PV=-135,000, Fv=0) 2000 Worksheet $853.29 How much will you pay into principal the 3rd month of this mortgage? PI=3 PRN 123.37 P2=3 How much interest will you pay in the 3rd month of this mortgage? INT: 729.92 How much will you pay into principal the 3rd year of this mortgage? PI= 25 PZ = 36 PRN 1717.79 How much will you pay into interest in the 3rd year of this mortgage? INT: 85 21.69 AZTU What will your balance be at the end of year 3? BAL- 13 1389163188 138,163.35 P.EPO 002-P.8824 000,21 oodsal If your bank charged you 2.5 points to obtain this loan, and you keep it for 30 years, what yield (APR) will the bank earn? olg 249 38 volopen What will the Federal Truth in Lending APR be (Hint: Round to the nearest 1/8%)? If you must pay $850 in other fees to close this loan, what is the cost to you of this loan (expressed as an APR), assuming you keep the loan for 30 years? If you keep the loan only 3 years, what will the lender yield be (APR)? If you keep the loan 3 years, what will your Effective Borrowing Cost be (APR)?