This tab forecasts your annual debt amortization schedule over the selected holding period. If the maturity of your loan is longer than your holding period, the spreadsheet will automatically repay any debt outstanding at exit.
By breaking down total debt service into individual components, it helps understand what you’re really paying for each year. Indeed, although your monthly payment will be the same in aggregate over the life of the mortgage, what you’re funding changes over time. In the first few years of your mortgage, you will pay more in interests than you are repaying principal. After a few years, things will start to change and the balance will shift more and more towards principal repayment .