đ Welcome to Your Mortgage Insights Dashboard!
Whether youâre just starting to explore or digging into advanced strategies, weâve got you covered. The slicers and chart in this BI Tool will cement your understanding of how Prinicipal and Interest payments develop over time, no matter whether you are looking at standard loans, loans with lump sum repayments or refinancing options.
Here's what you'll find in the annotated report:
đ Introduction & Dashboard Tour
A high-level roadmap of whatâs aheadâlearn how to navigate sliders, charts, and info icons to uncover exactly how your choices shape every dollar you pay.
đ Standard Principal & Interest
See the classic amortisation story:
Monthly Breakdown of interest vs. principal vs. total payment
Cumulative Cash-Flow to date
Balance vs. Equity over time
Perfect for understanding the core mechanics of your loan.
đĽ Lump-Sum Repayments
Explore the dramatic impact of one-off payments:
Inject extra cash at any point and watch interest dive & principal accelerate
Compare âno-lumpâ vs. âwith-lumpâ scenarios wtih the flick of a dial.
See how a single repayment can shave years (and thousands in interest!) off your loan.
đ Refinancing Simulations
Test the power of switching rates mid-term:
Choose your refinance date and new rate
Observe the sharp changes that develop in your payment, interest, and equity curves
Analyse total savings (or extra costs) from your new terms.
đ How to Get Started
Adjust Sliders at the top of each page to set your Deposit, Loan Amount, Rate(s), Term, Lump-Sum or Refi timing.
Watch Charts Update in real timeâevery slider move instantly refreshes your repayment story.
Hover for Details on any point to see exact dollar and percentage values.
Click the âšď¸ Icons for quick legends and pro-tips tailored to each visual.
Dive in and experiment freelyâ whether you are just learning about mortgages or promoting them to client, these visuals get everyone up to speed quickly. đ