Finance Kit (in Excel)

Description
This spreadsheet contains all relevant metrics needed to keep under control the functioning of the company starting from assets in the balance sheets and adding the dynamic elements of the functioning of the company that affects profitability and cash flow, including projections at 3 years based on current year performance.

In the various tab of the file you can include payroll charges, sales, forecast, expenses, accounts receivable and accounts payable, assets depreciations, taxes, operating expenses, cash flow.

All templates are interconnected so that they finally result in a comprehensive income statement and final balance sheet statement of the company.

Additional tabs include break even analysis (number of units that must be sold in order to break even once included the operating expenses and gp margin) so that it is possible to evaluate the minimum sales required to generate positive PTI.  Additional calculations show some common financial ratios that can be compared to industry average or standards.

A diagnostic dashboard performs a few tests on your numbers to see if they seem within certain reasonable ranges and can be used to look for values that are critically out of range.