The CFO Connection
Financial Model
CLIENT INPUT
Does your company provide goods (1) or services (2) Sales by Year Gross Profit Percentage Fixed Expenses by Year (excluding interest expense) Cost of Money Tax Rate Investment in Fixed Assets Average Fixed Asset Life in Years Accounts Receivable Days Other Current Assets (calculated as a percentage of sales) Accounts Payable Days Inventory Turns Year 1 0 0% Year 1 0 9% 40% Year 1 0 Year 2 0 5 45 10% 20 2 Year 3 0 Year 4 0 Year 5 0 Year 2 0 Year 2 0 Year 3 0 Year 3 0 1 Year 4 0 Year 4 0 Year 5 0 Year 5 0
Financial Statements
Year 0 Profit & Loss Statement Sales Gross Profit Fixed Expenses Depreciation Net Income Before Taxes Tax Net Income Break Even Point Balance Sheet Assets Cash Accounts Receivable Inventory Other Current Assets Net Fixed Assets Total Assets Liabilities & Equity Current Liabilities Debt Year 1 0 0 0 0 (0) 0 (0) 0 Year 2 0 0 0 0 (0) 0 (0) 0 Year 3 0 0 0 0 (0) 0 (0) 0 Year 4 0 0 0 0 (0) 0 (0) 0 Year 5 0 0 0 0 (0) 0 (0) 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0
0 0
0 0
0 0
0 0
0 0
Additional Debt/Equity
Equity Total Liabilities & Equity Cash Flow Beginning Cash Cash from Operations Paydown Debt Debt/Equity Required Ending Cash
0
0 0
0
0 0
0
0 0
0
0 0
0
0 0
0
0 0
0 0 (0) 0 0
0 (0) 0 0 0
0 (0) 0 0 0
0 (0) 0 0 0
0 (0) 0 0 0
Compliments of The CFO Connection - for information or help visit thecfoconnection.com