Question: the chart goes to 72! please include all excel formulas. F D 3. Calculate the lender's yield on a constant amortization mortgage loan for $950,000

the chart goes to 72! please include all excel formulas.

F D 3. Calculate the lender's yield on a constant amortization mortgage loan for $950,000 with monthly payments over 15 years at 6% interest with 1.75 points assuming the borrower prepays the loan at the end of year 6. Using IRR Function Yield to Lender Loan Amount Animal Interest Rate Discount Points Maturity (in years) Periods per year Prepayment Month Monthly Amortization Balance at EOY6 $950,000.00 6,00% 1.75% 15 12 72 $8,01664 $667,73339 Month Payment CAM Loan Amortization Schedule Interest Principal Balance Cash Flows 0 1 2 3

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 Finance Questions!

Please show all excel formulas The months payment interest principle balance and cash flows table goes down to 72. Please complete the table and fill in all pink and green tabs. 3. Calculate the...

Calculate the lender's yield on a constant amortization mortgage loan for $450,000 with monthly payments over 15 years at 6% interest with 1.75 points assuming the borrower prepays the loan at the...

G WNUMI Cash Flows G483 ex fx B D E F 477 3. Calculate the lender's yield on a constant amortization mortgage loan for S950,000 with monthly payments over 478 15 years at 6% Interest with 1.75 points...

Ans for the red box please 3. Calculate the lender's yield on a constant amortization mortgage loan for $950,000 with monthly payments over 15 years at 6% interest with 1.75 points assuming the...

4 7 7 3 . Calculate the lender's yield on a constant amortization mortgage loan for $ 9 5 0 , 0 0 0 with monthly payments over 1 5 years at 6 % interest with 1 . 7 5 points assuming the borrower...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

You are a computer programmer working for a small business that provides specialized financial services to local, mostly small businesses. You have been working for company X for about six months....

Determine elastic positive bending-moment capacities around the horizontal axes for beam having the cross section shown in the figure (Dimensions are in mm and diameter of the circle is 60 mm). The...

1 Tu Fu was a Chinese poet who lived more than 2500 years ago. Listen to the podcast about Tu Fu. As you listen, make notes about the poet's life. Divide your notes into main points, covering the...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...