Consolidating balance sheets template
You will need to know the principle and interest you will pay for each loan for over the course of several months.
For example, it can't figure out the dollar amount of interest that is allocated in each loan payment.
Debt Tracker is not quite as elegant as the other spreadsheets on this list, but it has a great sort/views feature and is definitely very useful.
Once all your debts are entered into the Debt Tracker, you can change the view by sorting debts by type (credit card, mortgage, various types of loans), interest rate, minimum payment, and other sort options.
These line items are also driven largely by the company’s operations.
In other words, the more revenue, the more capital spending and purchases of intangibles we expect to see.