Premium Dynamic Mortgage System (USA)
💎 From Clarity to Abundance
Canadian Mortgage Calculator — Fixed, Open, or Closed Mortgages.
Compatible with Excel 2024 and Microsoft 365 Â
• Not compatible with Excel 2021 or earlier versions
• Not compatible with Google Sheets
Manage your full Canadian mortgage history in one powerful, structured Excel workbook.
Designed for fixed, open, or closed mortgages, this system lets you track your mortgage evolution — from your first payment to future renewals — with a clear dashboard showing where every penny goes.
✨ Features include
• Up to 10 mortgage terms Â
• Calendar extends to 2086 Â
• Visual mortgage dashboard
• Detailed amortization schedule
• Principal, interest, and total payment tracking
• Prepayment calculator
• Interest‑savings estimates
• Early renewal or refinance options
• Recast option after prepayment
• Extra payment tracking
• Lender‑method calculation options
• Statement balance reconciliation Â
• French–English mortgage terminology glossary
Important note
This workbook provides a close estimate. Mortgage lenders may calculate interest slightly differently due to rounding, payment timing, daily interest accrual, statement dates, and internal lender methods.
The Statement Match feature allows users to enter their actual statement date and balance to help align the workbook with their real mortgage statement.
No formulas to learn. No manual updates. Just results.