Sales Growth % of Current Sales Average pricer per item Cost of Goods Sold % of Sales Operating Expense % of Forecast Sales Tax Rate % of EBT Dividend Rate % of NI Required Cash % of Forecast Sales A/R days Inventory Days Net Fixed Assets % of Forecast Sales Days Payable Accrued Liability % of Forecast Sales Assumptions (use these to drive projected IS and BS) 0.2 0.25 0.3 Actual ` < < < < < < < -- Forecast -->>>>>> >>>> 2017 2018 2019 2020 Net Sales Cost of Goods Sold Gross Profit 15000 18000 22500 29250 10500 4500 Operating exp -2500 Interest EBT -400 1600 Taxes (40%) -640 Net Income 960 Cash Dividends (0% of NI) 0 Added Retained Earnings 960 Balance Sheet Required Cash 1000 A/R 2000 Inventories 2200 Total Current Assets 5200 Net Fixed Assets 6800 Total Assets 12000 Accounts Payable 1600 Bank Loan 1800 Accured Liability 1200 Total Current Liability 4600 Long Term Debt 2200 Common Stock 2400 Retained Earnings 2800 Additional Funds Needed (AFN) 0 Total Liability & Equity 12000 BREAKEVEN CALCULATION Fixed Costs Gross margin BREAKEVEN REVENUES Price per unit Cost per unit Contribution per unit BREAKEVEN UNITS