Hello! I am trying to remake the Zillow refinance calculator in
Excel and I have everything done except for one section. I can't
seem to figure out how to make the graph that contains the
cost and the lifetime savings between 10-30 years, and I also can't
figure out how to make the Total Savings/Break Even graph. I'm not
entirely sure what functions to use to incorporate the Origination
Year and Refinance Fees, or how to calculate Total Savings. Any
help would be greatly appreciated.
Hello I Am Trying To Remake The Zillow Refinance Calculator In Excel And I Have Everything Done Except For One Section 1 (60.78 KiB) Viewed 63 times
program or saving on interest. Current loan amount * ? Full report Share v $ 200,000 Interest rate * Refinancing could save you $117 /month 3.774 % MONTHLY SAVINGS $117 /mo Current term * ? NEW PAYMENT $812 Costs 1yr 10yrs 20yrs 30yrs 360 months BREAK EVEN 52 months O COSTS $6,000 LIFETIME SAVINGS -$91,151 Origination year * ? $0 $2K $4K $6K SSK 2010 Total Savings / Break Even New loan amount * ? Total Savings -$1,203 $ 192,000 This is your break even point. After 52 months, your total savings will be greater than any costs to refinance your loan. 40 months $20K New interest rate * 3.024 % -S-20K New term * ? $-40K 360 months S-60K Refinance fees * ? S-SOK 100 mo 200 mo 300 mo $ 6,000 Advanced V
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!