Please show your work using Excel to solve the following problems step by step. Homework that doesnt use excel and doesnt show detailed work and uses formulas will not be graded. Problem 3.) Consider a $200,000 mortgage loan with an annual interest rate of 7 percent. The loan term is 8 years but the monthly payment is based on a 25-year amortization period. Find the monthly payment and the balloon payment at the end of the loan term.

Problem 4.) Consider a 25-year loan with an annual interest rate of 7 percent and monthly payments of $1,201.53. The discount points charged by the lender at origination are 3 percent and the cost of borrower title insurance and mortgage insurance are, respectively, 0.5 percent and 2.0 percent of the loan amount. Additional fees paid to other third parties (i.e., not the lender) will equal $4,000. What is the loan amount? What is the lenders yield/IRR? What is the effective borrowing cost (EBC)?