In: Accounting
Please fill out chat. What is forecast for netincome in 2016 ? | |||||
ASSUMPTIONS | |||||
Sales Price per Unit | $49.99 | ||||
Gross Margin = (Revenues - cost of goods sold) / Revenues | 25% | ||||
Depreciation & amortization as a % of capital expenditures | 25% | ||||
Tax Rate | 35% | ||||
Year | 2014 | 2015 | 2016 | 2017 | 2018 |
Units Sold | 200,000 | ||||
Growth Rate Of Unit Sold | 5% | 13% | 15% | 9% | |
Operating Expenses as % of Sales (2014 Only) | 10% | ||||
Operating Expense Growth Rate | 4% | 4% | 4% | 4% | |
Capital Expenditures | $1,750,000 | $1,775,000 | $1,800,000 | $1,825,000 | $1,850,000 |
Interest Expense | $0 | $10,000 | $10,000 | $10,000 | $12,500 |
Income Statement | |||||
Year | 2014 | 2015 | 2016 | 2017 | 2018 |
Units Sold | 200,000 | 210,000 | 237,300 | 272,895 | 297,456 |
Price per Unit | $49.99 | $49.99 | $49.99 | $49.99 | $49.99 |
Revenue | 9,998,000 | 10,497,900 | 11,862,627 | 13,642,021 | 14,869,803 |
Cost of goods sold | |||||
Gross Profit (defined as Revenue - COGS) | |||||
Operating Expenses | |||||
Earnings Before Interest Taxes Depreciation And Amortization (Ebitda) | |||||
EBITDA / Revenue (%) | |||||
Depreciation and Amortization | |||||
Operating Income (defined as EBITDA - Depreciation and Amortization) | |||||
Interest Expense | |||||
Pre-tax Net Income (Operating Income - Interest Expense) | |||||
Income Taxes | |||||
Net Income (Pret-tax Net Income - Income Taxes) |
Income Statement :-
Particulars | 2014 | 2015 | 2016 | 2017 | 2018 |
Units Sold | 200000 | 210000 | 237300 | 272895 | 297456 |
Price Per Unit | $49.99 | $49.99 | $49.99 | $49.99 | $49.99 |
Revenue | $9998000 | $10497900 | $11862627 | $13642021 | $14869825 |
Less : Cost of Goods sold | $7498500 | $7873425 | $8896970 | $10231516 | $11152369 |
Gross Profit @25% | $2499500 | $2624475 | $2965657 | $3410505 | $3717456 |
Less : Operating Expenses | $999800 | $1039792 | $1081384 | $1124639 | $1169625 |
EBITDA | $1499700 | $1584683 | $1884273 | $2285866 | $2547831 |
EBITDA/Revenue(%) | 15% | 15.095% | 15.88% | 16.76% | 17.13% |
Less : Depreciation | $437500 | $443750 | $450000 | $456250 | $462500 |
Operating Income | $1062200 | $1140933 | $1434273 | $1829616 | $2085331 |
Less : Interest Expense | $0 | $10000 | $10000 | $10000 | $12500 |
Pre Tax Net Income | $1062200 | $1130933 | $1424273 | $1819616 | $2072831 |
Less : Tax @ 35% | $371770 | $395827 | $498496 | $636866 | $725491 |
Net Income | $690430 | $735106 | $925777 | $1182750 | $1347340 |