E F A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at...

 

Transcribed Image Text:

E F 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 loan is held to maturity? Use both the IRR and RATE functions in the green highlighted cells as indicated. Loan Amount $538,000.00 Annual Interest Rate 4.50% Origination Fee $800.00 Discount Points 2.50% Maturity (in years) 30 Periods per year 12 Month 0 1 Cash Flow -$523,750.00 $2,725.97 2 $2,725.97 3 $2,725.97 4 $2,725.97 5 $2,725.97 6 $2,725.97 7 $2,725.97 B 8 $2,725.97 9 $2,725.97 10 $2.725.97 1 11 $2,725.97 12 $2,725.97 3 13 $2,725.97 14 $2,725.97 Using IRR Function Yield to Lender 4.73% Effective borrowing cost to borrower 4.73% APR 4.73% Using RATE Function Yield to Lender 5.04% Effective borrowing cost to borrower 5,04% APR 5.04% H E F 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 loan is held to maturity? Use both the IRR and RATE functions in the green highlighted cells as indicated. Loan Amount $538,000.00 Annual Interest Rate 4.50% Origination Fee $800.00 Discount Points 2.50% Maturity (in years) 30 Periods per year 12 Month 0 1 Cash Flow -$523,750.00 $2,725.97 2 $2,725.97 3 $2,725.97 4 $2,725.97 5 $2,725.97 6 $2,725.97 7 $2,725.97 B 8 $2,725.97 9 $2,725.97 10 $2.725.97 1 11 $2,725.97 12 $2,725.97 3 13 $2,725.97 14 $2,725.97 Using IRR Function Yield to Lender 4.73% Effective borrowing cost to borrower 4.73% APR 4.73% Using RATE Function Yield to Lender 5.04% Effective borrowing cost to borrower 5,04% APR 5.04% H

Answer rating: 100% (QA)

To calculate the yield to the lender effective borrowing cost to the borrower and the APR for the gi... View the full answer