File Home Insert Page Layout Formulas Data Review View Automate Help Nitro PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in F40 v XV fx A B C D E F G H 1 Your Name(s): 2 3 4 Sales Growth % 5 Average price per item 6 Cost of Goods Sold % of Sales 7 SG&A % of Sales 8 Tax Rate % of Earnings before taxes 9 AIR days 10 Inventory Days 11 Net Fixed Assets % of Sales 12 Days Payable 13 Accrued Liability % of Sales 14 15 INCOME STATEMENT 16 17 Net Sales Assumptions (use these to drive projected IS and BS) 0 26 0.44 0.33 Actual < < < < < Forecast -->>>>>>>>>> 2022 2023 15000 18900 2024 25137 2025 36197 18 Cost of Goods Sold 10500 19 Gross Profit 4500 20 SG&A expenses 2500 21 Interest 400 22 Earnings Before Taxes 1600 23 Taxes (40%) 640 24 Net Income 960 25 26 BALANCE SHEET 27 28 Required Cash 1000 29 AR 2000 30 Inventories 2200 31 Total Current Assets 5200 32 Net Fixed Assets 6800 33 Total Assets 12000 34 35 Accounts Payable 1600 36 Bank Loan 1800 37 Accured Liability 1200 38 Total Current Liability 4600 39 Long Terrn Debt 2200 40 Common Stock 2400 41 Retained Earnings 2800 42 Additional Funds Needed (A 0 12000 43 Total Liability & Equity 44 45 BREAKEVEN CALCULATION 46 Fixed Costs 47 Gross margin 48 BREAKEVEN REVENUES BREAKEVEN UNITS 49 Price per unit 50 51 52 53 54 EF Ready forecast Type here to search II K W >