How to calculate this using Excel?

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

How to calculate this using Excel?

Post by answerhappygod »

How to calculate this using Excel?
How To Calculate This Using Excel 1
How To Calculate This Using Excel 1 (66.26 KiB) Viewed 69 times
David obtained a fully amortizing loan 8 years ago for $120,000 at 8% for 30 years. Mortgage rates have dropped in such a manner so as to provide a loan for 22 years at 6.5%. There is no prepayment penalty on the mortgage balance of the original loan, but 2 points will be charged on the new loan and other closing cost will be $3000. All payments are monthly. How much does David need to borrow if he decides to borrow only outstanding loan balance? Is refinancing a good option if David decides to repay the full amount of loan in 5 more years? How would your answer for part 2a change if David decides to borrow outstanding loan balance and other refinancing costs? Would your answer for part 2b change if David decides to keep the loan for full term of the loan?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply