We recently took a mortgage on our house. As I am selfemployed, there is a lot of variability in my income. So I wanted to see the impact of occasional topup payments. Most online calculators couldn't tell me how it would impact my loan term. So I went ahead and built an Excel calculator to give me the answer.
In this video, let me tell you the story of that and walk you thru the process of building such a calculator yourself.
Download the calculator
=========================
Don't care how this is built? Just want the calculator? Get it from here https://chandoo.org/wp/mortgagecalcu...
⏱ In the video:
=============
0:00 Why I couldn't use the existing mortgage calculators
1:00 Quick demo of my calculator
2:00 How to build such a mortgage calculator yourself
3:36 How the "extra payments" work
4:19 Setting up the loan amortization table
10:34 Adding the bells & whistles (chart & conditional formatting)
WATCH NEXT
==============
I got a mortgage to pay, so why not watch a few more videos on my channel
Breakeven analysis and Whatif modeling • Breakeven analysis and whatif modeli...
Which power plan is best for me • Which power plan is best for me? Mode...
3 Essential date formulas for financial analysis • 3 Powerful & Essential DATE formulas ...
What if modeling in Power BI • How to create a dynamic KPI Dashboard...
Like Finance Videos? Want me to make more?
========================================
Do you want to learn about financial analysis, modeling concepts here on the channel? Let me know and I can add videos on this topic too. Post a comment with your suggestions.
FOLLLOW ME:
==============
Apart from YouTube, I regularly share content on below places. Feel free to check them out and give a follow.
WEBSITE https://chandoo.org/wp/
WEEKLY NEWSLETTER https://chandoo.org/wp/subscribe/
INSTAGRAM / chandoo.xlsx
TWITTER / r1c1
~
Where do fish keep their money?
In the river bank
#mortgagecalculator #finances