Download Our Free Software
Thank you for registering with the CFO Connection. To get started with our software please follow the instructions below.
- To download, right click on the “Download Free Software” link below and select “Save Target As” (Internet Explorer) or “Save Link As” (Netscape) and save the file to your computer.
- To open the downloaded file you must have MS Excel version 5.0 or higher.
- Print the following instructions to assist in using software.
- Enter your information in the white boxes on the spreadsheet.
- Does your company provide goods or services? If your response is for goods then there will be inventory on the balance sheet. If your company provides both then you have two choices: 1) run the model separately for each business or 2) play with the inventory turns to reflect the proper balance.
- Cost of Money – use only if you have debt on your balance and indicate what the cost of money for that debt is.
- Gross Profit – sales minus variable cost of sales. Therefore Gross Profit percentage is gross profit divided by sales.
- Tax Rate – the number in the model is 40% this assumes 10% for state and 30% for federal. You can change this percentage.
- Average Fixed Asset Life – This is used to calculate depreciation. If you do not know the average life, divide the net fixed assets on your balance by the annual depreciation.
- Accounts Receivable Days – A quick way to calculate this is to take your average monthly receivables divided by annual sales times 365. Of course if your terms are net 30 and your customers pay you on time then your days are 30. The days have been preset at 45 but may be changed.
- Accounts Payable Days – Similar to accounts receivable days. The average time before you pay your bills. On this abbreviated balance sheet all non debt liabilities are in this category. Keep in mind that payroll expenses are generally paid immediately. The days have been preset at 30, but may be changed.
- Inventory Turns – used to determine the inventory value on the balance sheet. If the turns are 2 then on average you carry 6 months of inventory if 3 then four months. If your business provides a combination of goods and services, then you might want to increase the number of turns to show the appropriate inventory level.
- Year 0 Balance Sheet – You will need to enter the opening balance sheets numbers in order for cash flow to be calculated. If you do not enter any, the assumption is that operations start-up in Year 1.