Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

After looking at the projections of the HomeNet project, you decide that they are not realistic. It is unlikely that sales will be constant over

image text in transcribedimage text in transcribed

After looking at the projections of the HomeNet project, you decide that they are not realistic. It is unlikely that sales will be constant over the four-year life of the project. Furthermore, other companies are likely to offer competing products, so the assumption that the sales price will remain constant is also likely to be optimistic. Finally, as production ramps up, you anticipate lower per unit production costs resulting from economies of scale. Therefore, you decide to redo the projections under the following assumptions: Sales of 50,000 units in year 1 increasing by 50,000 units per year over the life of the project, a year 1 sales price of $260/unit, decreasing by 10% annually and a year 1 cost of $120/unit decreasing by 20% annually. In addition, new tax laws allow 100% bonus depreciation (all the depreciation expense occurs when the asset is put into use, in this case immediately). a. Keeping the other assumptions that underlie Table 8.1 ( ) the same, recalculate unlevered net income (that is, reproduce Table 8.1 under the new assumptions, and note that we are ignoring cannibalization and lost rent). b. Recalculate unlevered net income including lost rent and assuming that each year 20% of sales comes from customers who would have purchased an existing Cisco router for $100/unit and that this router costs $60/unit to manufacture. .. a. Keeping the other assumptions that underlie Table 8.1(E) the same, recalculate unlevered net income (that is, reproduce Table 8.1 under the new assumptions, and note that we are ignoring cannibalization and lost rent). Calculate the yearly unlevered net income below: (Round to the nearest dollar.) OX Data table Year o Incremental Earnings Forecast ($000) Sales Cost of Goods Sold $ 5 Gross Profits $ $ $ Selling, General, and Admin. Research and Development Depreciation EBIT (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 0 1 2 3 4 Incremental Earnings Forecast ($000) 1 Sales 26,000 26,000 26,000 26,000 2 Cost of Goods Sold (11,000) (11,000) (11,000) (11,000) 3 Gross Profits 15,000 15,000 15,000 15,000 4 Selling, General, and Administrative (2,800) (2,800) (2,800) (2,800) 5 Research and Development (15,000) 6 Depreciation (1,500) (1,500) (1,500) (1,500) 7 EBIT (15,000) 10,700 10,700 10,700 10,700 8 Income Tax at 20% 3,000 (2,140) (2,140) (2,140) (2,140) 9 Unlevered Net Income (12,000) 8,560 8,560 8,560 8,560 $ $ Income Tax at 20% $ $ (1,500) (1,500) 300 (1,200) Unlevered Net Income $ (Round to the nearest dollar.) Year 1 Incremental Earnings Forecast ($000) Print Done Year 1 S Incremental Earnings Forecast (5000) Sales Cost of Goods Sold Gross Profits Selling, General, and Admin. Research and Development Depreciation EBIT Income Tax at 20% S S Unlevered Net Income Round to the nearest dollar.) Year 2 Incremental Earnings Forecast (5000) Sales S S S Cost of Goods Sold Gross Profits Selling, General, and Admin Research and Development Depreciation EBIT S S S Income Tax at 20% S Unlevered Net Income Round to the nearest dollar.) Year 3 Incremental Earnings Forecast (5000) Sales Cost of Goods Sold S Gross Profits S Selling, General, and Admin Research and Development Depreciation S EBIT S Income Tax at 20%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Adult Personal Finance For The Real World

Authors: Jake Cousineau

1st Edition

8581084830, 979-8581084830

Students also viewed these Finance questions

Question

How effective is the tone? Would you suggest any changes?

Answered: 1 week ago