Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR of 6.5% on a $230,000 loan. She has been
Exactly six years ago, Cathy bought her dream home using a 30-year mortgage with an APR of 6.5% on a $230,000 loan. She has been making her monthly payments. Today, she came to know that her bank is offering a special mortgage refinance offer at an APR of 4.25% on 20-year mortgages. How much will Cathys monthly payment change, if she decides to refinance today?
Original loan | |||
Years Ago (N) | 6.00 | years | |
Term (years, N0) | 30.00 | years | |
APR (R0) | 6.50% | annual | |
Loan Amt (PV0) | $ 230,000.00 | ||
($17,612.81) | |||
New Loan | |||
Term (years, N1) | 20.00 | years | |
APR (R1) | 4.25% | annual | |
($17,300.56) | |||
Monthly savings (Excel) | increase/decrease by | ???? | |
Monthly savings (VBA) | increase/decrease by | ???? | |
Monthly savings (Math, Extra Credit)) | increase/decrease by | ???? |
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