AMORTIZATION CALCULATOR

📘 How to Use the Amortization Calculator

1. Enter Loan Details

• 💰 Loan Amount – Type the total amount of money you are borrowing or investing.
  Example: $4’350,000
• 📈 Annual Interest Rate (%) – Enter the yearly interest rate as a percentage.
  Example: 12%
• 📅 Loan Term (Years) – Enter how many years the loan will last.
  Example: 6

2. Click “Calculate Amortization”

Once you’ve entered all the values, click the “Calculate Amortization” button. The calculator will:

✅ Compute your fixed yearly payment
✅ Generate a table showing, year-by-year:

• Total Payment
• Interest paid
• Principal paid
• Remaining balance

3. Review Your Amortization Table

After calculation, you’ll see a full table showing how your loan balance decreases over time. This table updates automatically when you change the inputs and click the button again.

4. Download Your Amortization Table

When you’re ready, click “Download Excel” to save the full amortization table to your device in .xlsx format.

You can open this file using Excel, Google Sheets, or any spreadsheet program.

✅ Tips for Best Use

• Use whole numbers (no commas) for cleaner inputs.
• You can run the calculator as many times as you like — just change the values and click again.
• If the download doesn’t start, make sure your browser allows pop-ups/downloads.