Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

The Financial Services Marketing Handbook

Authors: Evelyn Ehrlich

2nd Edition

1118065719, 978-1118065716

More Books

Students also viewed these Finance questions

Question

Describe the Freudian myth, and show how it was promoted?

Answered: 1 week ago