Question: Please show formulas. not excel. 3) Five years ago you borrowed $120,000 to finance the purchase of a $150,000 home. The interest rate on the

Please show formulas. not excel.
Please show formulas. not excel. 3) Five years ago you borrowed $120,000

3) Five years ago you borrowed $120,000 to finance the purchase of a $150,000 home. The interest rate on the old mortgage loan is 8 percent. Payments are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 5.5 percent with monthly payments for 30 years. The new lender will charge three discount points on the loan. Other refinancing costs will equal $4,000. There are no prepayment penalties associated with either loan. You feel the appropriate opportunity cost to apply to this refinancing decision is 7 percent. What is the payment on the old loan? I b. What is the current loan balance on the old loan (five years after origination)? What would be the monthly payment on the new loan? Should you refinance today i the new loan is expected to be outstanding for five years? Show calculations. a c. d

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!