Financial Model, General Excel Financial Models, Personal Finance

Amortization, Bad Debt, Debt Amortization, Debt Schedule, Financial Debt

This template allows you to input different loan amounts, each with its own terms, and automatically creates a schedule showing how much you will be paying as interest and principal for each loan based on their terms.

In addition to that, the totals to be repaid as interest, principals, and outstanding balances are shown in a summary.

This helps you know the amount you expect to pay at any one time, and this is critical when tracking your cash flow.

Businesses and individuals find themselves not knowing how much they expect to pay to their lenders at any particular time, especially when they have more than one loan.

This tool will be helpful in that you only need to input the loan amount, interest rate, loan tenure, and when the loan was/will be acquired.

This is repeated for each loan, and the outcome is the amounts to be repaid and outstanding balances. This can also be used to forecast the impact of an additional loan on your cash outflow. Thank you.

You must log in to submit a review.