Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me with Question 5 and 6 to make sure i get the right answer and give me the excel formula. If you dont i

Help me with Question 5 and 6 to make sure i get the right answer and give me the excel formula. If you dont i will mark it wrong and report it
Five years ago, you purchase a house of $500,000. You borrow a mortgage with 80% of LTV (loan to value ratio), monthly payments and the interest rate of 5% for 30 years. You have found a new lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 3.5% with monthly payments for 30 years. Suppose that the new lender will charge 3.5 discount points on the new loan and other refinancing costs will equal $2,000.
1. What is your monthly payment for the current loan?
a.($2,147.29)
2. What is the current outstanding loan balance?
a. $367,314.93
3. What is the new loan amount if you choose to refinance?
a. $ 382,170.95
4. What is your monthly payment for the new loan?
a.($1,649.41)
5. What is the effective cost of your new loan if you hold the loan for 30 years? Do you refinance?
a.3.84%
6. If you want to refinance today, at least how many years should you stay in the house (do not prepay)? Why?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Corporate Finance

Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates

5th Edition

1119795435, 978-1119795438

More Books

Students also viewed these Finance questions