Debt Schedules For Several Loans With Different Terms

Description
Suppose you have several loans with different terms such as amount, tenor, interest rates, and acquired on different dates and you would like to know how much you expect to pay at any particular time and the outstanding balances?

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 at any particular time to their lenders 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 tenor, 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.