Answered step by step
Verified Expert Solution
Question
1 Approved Answer
cash flow goes to 72! please include all excel formulas. 2. Origination Fees and Discount Points with Prepayment at EOY 6 A lender is offering
cash flow goes to 72! please include all excel formulas.
2. Origination Fees and Discount Points with Prepayment at EOY 6 A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 2.5 discount points. A borrower wants a loan for $538.000. What is the yield to the lender, the effective borrowing cost to the borrower, and the APR assuming the borrower prepays the loan balance at the end of year 6? Use both the IRR function in the green highlighted cell as indicated. Using IRR Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful) Loan Amount Annual Interest Rate Origination Fee Discount Points 5 Maturity (in years) Periods per year Prepayment Month 8 Monthly Payment 9 Balance at EOY 6 20 1 Using RATE Function Yield to Lender Effective borrowing cost to borrower APR (this is tricky, be careful Month Cash Flow Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started