Question: HELP ME SOLVE PROBLEM 5 ONLY AND GIVE ME THE ANSWER IN EXCEL FORMULAS. YOU HAVE TO GET YEAR 1 = 6 . 6 %
HELP ME SOLVE PROBLEM ONLY AND GIVE ME THE ANSWER IN EXCEL FORMULAS. YOU HAVE TO GET YEAR I WILL MARK IT WRONG IF YOU DONT
Five years ago, you purchase a house of $ You borrow a mortgage with of LTV loan to value ratio The interest rate on the mortgage is Payment terms are being made monthly to amortize the loan over years. You have found another lender who will refinance the current outstanding loan balance at with monthly payments for years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $
What is your monthly payment for the current loan?
N I PV PMT FV
What is the new loan amount if you choose to refinance?
$
What is your monthly payment for the new loan?
$
What is the effective cost of your new loan if you hold the loan for years?
If you want to refinance today, at least how many years should you stay in the house do not prepay At least years.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
