Question: PLEASE FIND ONLY THE ONES IN RED, USING THE EXCEL FORMULAS. THANK YOU! A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM)

PLEASE FIND ONLY THE ONES IN RED, USING THE EXCEL FORMULAS. THANK YOU!

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. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please provide the excel function formula with the answer (answer is in the green highlight cell) A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800...

provide the answer in the green highlight cell with the excel function explanation, please A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800...

Additional Mortgage Concepts Excel Assignment: Module 7 1. Origination Fees and Discount Points without Prepayment A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at...

provide the answer in the green highlight cells with the right excel function explanation, please A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800...

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 $358,000. What is the yield to...

3 2. Origination Fees and Discount Points with Prepayment at EOY 6 1 5 A lender is offering a 30-year, monthly payment fixed rate mortgage (FRM) loan at 4.5% with an $800 origination fee and 6 2.5...

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)...

please post excel formulas! thanks = = - 11 050 Formatting as G 1 K 012 X fx B D E 1 Additional Mortgage Concepts Excel Assignment: Module 7 2 31. Origination Fees and Decount Polnts without...

You expect XYZ stock to pay a $4.50 dividend at the end of the year. The stock price is expected to be $12 at that time. If you require a 15% rate of return, what would you pay for the stock now? a....

What is medical waste?

Auditors are required to reference consistency in their report when there are changes in Multiple Choice the classification of financlal statement amounts. the format of the Statement of Cash Flows....

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Question How can an employer provide retirement benefits to replace 401(k) benefits lost by an executive as a result of the $245,000 (in 2011, as indexed) compensation cap?

Question Can any type of business organization have an ESOP or stock bonus plan?

Question How can an employer increase employee participation in its 401(k) plan?