How to calculate Mortage with Extra Payments in Excel

We recently took a mortgage on our house. As I am self-employed, there is a lot of variability in my income. So I wanted to see the impact of occasional top-up 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/mortgage-calcu...

⏱ 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 🤣

Break-even analysis and What-if modeling -    • Breakeven analysis and what-if 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