Question

In: Accounting

Please fill out chat. What is forecast for netincome in 2016 ? ASSUMPTIONS Sales Price per...

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)

Solutions

Expert Solution

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

Related Solutions

Please fill out a general journal for the transactions. Customers are charged $87 per hour for...
Please fill out a general journal for the transactions. Customers are charged $87 per hour for services Customers are charged $75 for each unit of retail product purchased Inventory is purchased by the company for $36 per unit Trans. Date Description 1 Dec. 1 Borrow $115,000 from the local bank and signed a six-year installment note with payments of $1,905 at the end of each month. The annual interest rate is 6%. Current portion of Note at year end after...
Please fill out the Internal structures of the heart
Please fill out the Internal structures of the heart
Forecast Sales Volume and Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016:...
Forecast Sales Volume and Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016: Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 18,800 $23 $432,400 Central 4,900 23 112,700 West 4,500 23 103,500 Total 28,200 $648,600 12" × 16" Frame: East 12,500 $24 $300,000 Central 2,900 24 69,600 West 1,900 24 45,600 Total 17,300 $415,200 Total revenue from...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016:...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016: Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 8,500 $16 $136,000 Central 6,200 16 99,200 West 12,600 16 201,600     Total 27,300 $436,800 12" × 16" Frame: East 3,800 $30 $114,000 Central 3,000 30 90,000 West 5,400 30 162,000     Total 12,200 $366,000 Total revenue from...
**Please fill out the chart post at the bottom and please do not copy and paste...
**Please fill out the chart post at the bottom and please do not copy and paste a previous answer that has been used on CHegg. Lehighton Chalk Company manufactures sidewalk chalk, which it sells online by the box at $24 per unit. Lehighton uses an actual costing system, which means that the actual costs of direct material, direct labor, and manufacturing overhead are entered into work-in-process inventory. The actual application rate for manufacturing overhead is computed each year; actual manufacturing...
The price index from 2016 to 2018 is : 200, 210, 220. Derive a forecast for...
The price index from 2016 to 2018 is : 200, 210, 220. Derive a forecast for 2019 on the basis of adaptive expectations using 0.2, 0.3 and 0.5 as weights in 2016, 2017 and 2018 respectively. The optimal forecast for 2019 is 225 using all available information. What is the expected price index in 2019 based on rational expectations? The actual value in 2019 is 223. Based on this, Paul concluded that the expected value in (b) derived using rational...
The Caribbean Industrial Producers manufactures two products, “Zinc” and” “Ply”. The following sales forecast for 2016...
The Caribbean Industrial Producers manufactures two products, “Zinc” and” “Ply”. The following sales forecast for 2016 was decided on by the budget committee and presented to you the management accountant.                                                      Sales forecast Details Zinc/units Ply /units December 2015 6,000 3,700 January 2016 5,500 4,000 February 2016 6,200 4,500 March 2016 5,000 5,200 April 2016 4,900 5,400 May 2016 6,400 4,800 Notes: (i) During 2016 the company sold one unit of Zinc for $1,200 while one unit of Ply was...
The negative result for acetylcholine receptor antibodies rules out ____________ ___________ as a diagnosis. please fill...
The negative result for acetylcholine receptor antibodies rules out ____________ ___________ as a diagnosis. please fill in the two blanks as well
Please make a sales forecast for an all in one washer and dryer that costs $1020...
Please make a sales forecast for an all in one washer and dryer that costs $1020 I have no idea how to do this. Im supposed to create my own numbers because I "made" the product. You can make the numbers up just label it please. It says to put it in a table
PLEASE USING THIS INFORMATION FILL OUT ALL COLUMNS COMPLETELY IN THE TABLE MARKED AS (*******) 1)...
PLEASE USING THIS INFORMATION FILL OUT ALL COLUMNS COMPLETELY IN THE TABLE MARKED AS (*******) 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $    200,000 2) New equipment cost $        (200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $          (35,000) 10) Operating cost: $   (120,000) 4) Related start up cost $             (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $            25,000 11) Depreciation (Straight Line)/YR $    ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT