Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started