Question

You are evaluating the HomeNet project under the following​ assumptions: new tax laws allow​ 100% bonus depreciation​ (all the depreciation​ expense, $ 7.5 million, occurs when the asset is put into​ use, in this case​ immediately). Research and development expenditures total $ 15 million in year 0 and​ selling, general, and administrative expenses are $ 2.8 million per year​ (assuming there is no​ cannibalization). Also assume HomeNet will have no incremental cash or inventory requirements​ (products will be shipped directly from the contract manufacturer to​ customers). However, receivables related to HomeNet are expected to account for 15 % of annual​ sales, and payables are expected to be 15 % of the annual cost of goods sold. Under these assumptions and assuming a cost of capital of 14 %​, calculate:

a. The​ break-even annual sales price decline​ if: sales of 50,000 units in year 1 increase by 48,000 units per year over the life of the​ project, the year 1 sales price is $260​/unit, and the year 1 cost of $120​/unit decreases by 18 % annually. See the data table

b. The​ break-even annual unit sales increase​ if: sales are 50,000 units in year​ 1, the year 1 sales price of $260​/unit, decreases by 11 % annually and the year 1 cost of $120​/unit decreases by 18 %annually. See the data table

04/11/2019 Data Table Year 0 1 2 3 4 5 48 . 11% 18% 50 260 120 98 231.40 98.40 146 205.95 80.69 194 183.30 66.17 · HomeNet Un

0 0
Add a comment Improve this question Transcribed image text
Answer #1

This can be solved using Solver by calculating the annual sales price decline/annual unit sales increase at which NPV becomes 0.

a). Annual sales price decline for break-even NPV = 19.29%

0 - Assumptions 48.00 19.29% 18.00% 1 50.00 260.00 120.00 2 98.00 209.84 98.40 146.00 169.35 80.69 4 194.00 136.68 66.16 Year

Incremental earnings forecast ($000) Year (n) Formula 1 2 5 Sales 13000.00 20564.11 24725.63 26515.93 0.00 COGS COGS -6000.00

b). Annual unit sales increase for break-even NPV = 25,921.8 or 25,922 units or 25.92 thousand units

- 3 Assumptions 25.92 11.00% 18.00% 1 50.00 260.00 120.00 2 75.92 2 31.40 98.40 101.84 205.95 80.69 4 127.77 183.29 66.16 Yea

13000.00 -6000.00 7000.00 -2800.00 17568.32 20974.30 -7470.71 -8217.56 10097.61 12756.74 -2800.00 -2800.00 23418.39 -8453.50

Add a comment
Know the answer?
Add Answer to:
You are evaluating the HomeNet project under the following​ assumptions: new tax laws allow​ 100% bonus...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • After looking at the projections of the HomeNet project, you decide that they are not realistic....

    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...

  • After looking at the projections of the HomeNet project, you decide that they are not realistic. ...

    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...

  • Need some assistance with this tricky excel case! Here is an updated info screenshot! Mini-case study...

    Need some assistance with this tricky excel case! Here is an updated info screenshot! Mini-case study 3 Capital budgeting- using incremental cash flow Suppose you recently got an offer from Cisco. You work as a financial manager of the router division of Cisco Systems. On your first day, your boss talks about a project that Cisco is considering now: the development of a wireless home networking appliance, called HomeNet. He asks you to value this project, and then submit a...

  • Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany plans on us...

    Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany plans on using a cost of capital of 12% to evaluate this project. Based on extensive research, it has prepared the following incremental cash flow projections: Year 0 1 2 3 Sales (Revenues) 100,000 100,000 100,000 - Cost of Goods Sold (50% of Sales) 50,000 50,000 50,000 - Depreciation 30,000 30,000 30,000 = EBIT 20,000 20,000 20,000 - Taxes (35%) 7000 7000 7000 =...

  • uul liaie h the exam paper and each of your answer sheets. Epiphany Industries is considering a new capital budgeting project that will last for three I. (10 pts.) years. Epiphany plans on using a...

    uul liaie h the exam paper and each of your answer sheets. Epiphany Industries is considering a new capital budgeting project that will last for three I. (10 pts.) years. Epiphany plans on using a cost of capital of 12% to evaluate this project. Based on extensive research, it has prepared the following incremental cash flow projections: Year Sales (Revenues) 100,000 100,000 100,000 50,000 50,000 50,000 30,000 30,000 30,000 20,000 20,000 20,000 Cost of Goods Sold (50% of Sales) -Depreciation...

  • St. Blues Technologies' expected (next year) EBIT is $292.00, its tax rate is 40%, depreciation is...

    St. Blues Technologies' expected (next year) EBIT is $292.00, its tax rate is 40%, depreciation is $18.00, planned capital expenditures are $80.00, and planned INCREASES in net working capital is $24.00. What is the free cash flow to the firm (FCFF)? $ The firm's interest expense is $24.00. Assume the tax rate is 40% and the net debt of the firm DECREASES by $5.00. What is the free cash flow to equity (FCFE)? $ What is the market value of...

  • You are analyzing a project and have established the following estimates for the first year of a project: Tax rate: 33%...

    You are analyzing a project and have established the following estimates for the first year of a project: Tax rate: 33% Annual Interest: $3,500 Annual Depreciation Expense: 3,128 Annual Sales in units: 1,854 Price per unit: $17 Variable cost per unit: $9 Fixed costs: $7,194 Calculate the year 1 operating cash flow. Enter your answer in dollars and cents (i.e. 12.34) Do not enter the dollar sign or commas. Precede negative answers with the minus sign.

  • P10-20 (similar to) Question Help Project cash flow and NPV. The managers of Classic Autos Incorporated...

    P10-20 (similar to) Question Help Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $3,900,000 and will be depreciated using a five-year MACRS life, . The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 260 Year two: 300 Year three: 360 Year four: 380 Year five: 330 If...

  • ​It's been 2 months since you took a position as an assistant financial analyst at Caledonia...

    ​It's been 2 months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been pleased with your​ work, he is still a bit hesitant about unleashing you without supervision. Your next assignment involves both the calculation of the cash flows associated with a new investment under consideration and the evaluation of several mutually exclusive projects. Given your lack of tenure at​ Caledonia, you have been asked not only to provide a recommendation...

  • Bayside Industries lnc. is evaluating an expansion project to establish its presence in a key market...

    Bayside Industries lnc. is evaluating an expansion project to establish its presence in a key market for its products. you have collected the following data on the proposed project. 1. The project requires $25 million in initial capital investment, and will have an economic life of 5 years. The investment will be straight-line depreciated down to a book value of zero at the end of 5 years. The investment is expected to be salvaged for $5 million at the end...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT