Mortgage & Loan Amortization Tracker: Fixed, Variable, Interest-Only & Debt Snowball

[Chere Grunion]

Mortgage, Loan, and HELOC Amortization Spreadsheet

This comprehensive Excel sheet is essential for real estate investors and homeowners seeking a detailed understanding of their mortgage, HELOC, and loan payments. It goes beyond basic calculations, providing flexible options and detailed insights to help you make informed financial decisions. Track both interest-only and principal-plus-interest payments for HELOCs and loans. Visualize the impact of Debt Payoff with extra monthly prepayments in real time, helping you reduce debt faster and save on interest.


🛒 Available on Etsy: at assetafc.etsy.com and on our website: AssetAFC.com

Key Features:

Mortgage Amortization

• Tracks principal and interest payments over the life of a mortgage.
• Supports fixed, variable adjustable, and variable static interest rate options:
• Fixed Rate: Consistent payments throughout the term.
• Variable Adjustable Rate: Payments adjust with interest rate changes, reflecting increased or decreased costs.
• Variable Static Rate: Payments remain constant; changes in rates affect the principal-interest split.

HELOC Tracking

• Includes an interest-only payment option, perfect for flexible borrowing and repayment strategies.
• Analyze the balance and interest paid over time with adjustable rates.

Loan Table

• Supports both interest-only and principal-plus-interest payments.
• Customizable to fit any loan type and term duration.

Customization Options:

• Choose your currency—works in all countries, including the USA, Canada, Australia, UK, Europe, Japan, China, India, UAE, Philippines, and more.
• Input loan details such as starting amounts, terms, and rates.
• Calculate the impact of extra monthly prepayments.
• Supports interest calculations with Actual/365 monthly periods, offering precise results tailored to professional-grade standards.
• Visualize how different rates and payment strategies affect balances and total interest paid.

Additional Benefits:

• Includes a starting date feature to align calculations with your financial timeline.
• Outputs detailed summaries for total payments, interest vs. principal breakdowns, and outstanding balances at term.
• Helps strategize early payments to save on interest and pay down debt faster.

This spreadsheet is more than just numbers—it’s a versatile planning tool to optimize your financial future. Perfect for homeowners, real estate investors, or anyone managing multiple debts.



🛒 Available on Etsy: at assetafc.etsy.com and on our website: AssetAFC.com