Useful Spreadsheets and Calculators
I’ll upload some useful spreadsheets and calculators that you can download. When I mention each spreadsheet or calculator in a post I will also upload it here for easy access.
Subscribe to Weekly Newsletter for updates on downloads added:
Loan Amortization Table
This Loan amortization table can be used to calculate loan payments and amortization. It is a great visual for understanding your principal and interest breakdown. Please keep in mind that if you are on a floating rate this table may not be the best resource.
Coming soon…
Cash Flow Forecast Template
A template for creating a cash flow projection model. These models are used in finance for several reasons. Mainly to project the trajectory of the company and to show how both revenues and expenses will respond to these changes.
Coming soon…
Working Capital Worksheet
This worksheet is for calculating and understanding your working capital. It highlights the changes in your cash balance that will happen with changes to specific accounting line items.
Coming soon…
Cost of Capital – Debt and Equity Cost Calculator
This spreadsheet is for calculating and understanding your cost of capital. It can be used to assess the cost of each method of financing a company.
Coming soon…
Subscribe to Weekly Newsletter for updates on downloads added: