Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the break-even point for the first loan, assuming that the original loan length is 30 Years? what is the excel formula to find

What is the break-even point for the first loan, assuming that the original loan length is 30 Years? what is the excel formula to find the break-even point?


Loan Amount Intrest Number of Payments Made Mortgage Payment Monthly Payment Savings Total Savings for Refinance Total Paid 'Old Payment' Paid to Date on 'Old Payment' (P+1) Total Paid 'New Payment' Difference $970,800.00 4.50% 0 $1,770,804.36 $1,770,804.36 $0.00 Loan Amount Cost of New Loan to Rolled Interest Mortgage Payment New Payment $0.00 3.75%

Step by Step Solution

3.33 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Breakeven point on refinance What is the breakeven point for the first loan assuming that the origin... 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

Step: 3

blur-text-image

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

Cost Management Measuring, Monitoring And Motivating Performance

Authors: Leslie G. Eldenburg, Susan K. Wolcott, Liang Hsuan Chen, Gail Cook

3rd Canadian Edition

978-1-119-1856, 978-1119185697

More Books

Students also viewed these Accounting questions

Question

Prove Equation 3.29. vvg = c 2 ,

Answered: 1 week ago

Question

What are some of the features of the Unified Process (UP)?

Answered: 1 week ago

Question

Explain how to adjust the re-order point to consider safety stock.

Answered: 1 week ago