Question

help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill,...

help me solve this?

EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company in the finance department. One of the major revenue-producing items manufactured by Emu Electronics is a smart phone. Emu Electronics currently has one smart phone model on the market and sales have been excellent. The smart phone is a unique item in that it comes in a variety of colours and is pre-programmed to play Jimmy Barnes’s music. However, as with any electronic item, technology changes rapidly, and the current smart phone has limited features in comparison with newer models. Emu Electronics has spent £750 000 developing a prototype for a new smart phone that has all the features of the existing one, but adds new features, such as Wifi Tethering. The company has spent a further £200 000 for a marketing study to determine the expected sales figures for the new smart phone. Emu Electronics’ production manager has produced estimates of the costs associated with manufacture of the new smart phone. Variable costs are estimated at £205 per unit and fixed costs for the operation are expected to run at £5.1 million per year. The estimated sales volume is 64 000 units in Year 1; 106 000 units in Year 2; 87 000 units in Year 3; 78 000 units in Year 4; and 54 000 units in the final year. The unit price of the new smart phone will be £485. The necessary manufacturing equipment can be purchased for £34.5 million and will be depreciated for tax purposes over a seven-year life (straight-line to zero). It is believed the value of the manufacturing equipment in five years’ time will be £5.5 million. Net working capital for the smart phones will be 20% of sales and will have to be purchased at the end of the year. The cost of the raw materials is reflected in the variable unit cost. Changes in NWC will first occur at the end of Year 1 based on the first year’s sales. Emu Electronics has a 30% corporate tax rate and a 12% required return. Required: Shelly has asked Robert to prepare a report that answers the following questions: How sensitive is the NPV to changes in the price of the new smart phone?

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

Answer:

Base NPV = £14,813,791.60

Workings:

Year Unit sales Unit price Sales Value (unit sales Unit Price Net working capital required (20% of sales) Increase in net working capital 0 64,000 106,000 87,000 78,000 54,000 £485 £31,040,000£51,410,000£42,195,000£37,830,000£26,190,000 £5,238,000 £7,566,000 £485 £485 £485 £485 E6,208,000 E6,208,000 £10,282,000 £4,074,000 £8,439,000 £1,843,000 E7,566,000 E873,000 Year Installed cost of equipment Increase in net working capital Sales Value Variable cost (unit sales205 Fixed cost Depreciation Earnings before tax Tax at 30% Earnings after tax Add back depreciation Operating cash flow 0 4 £34,500,000.00 £6,208,000.00-£4,074,000.00£1,843,000.00 £873,000.00£7,566,000.00 £31,040,000.00 £51,410,000.0042,195,000.00 £37,830,000.00£26,190,000.00 £13,120,000.00 -£21,730,000.00 -£17,835,000.00 -£15,990,000.00-£11,070,000.00 E5,100,000.00-£5,100,000.00 -£5,100,000.00-£5,100,000.00£5,100,000.00 -£4,928,571.434,928,571.43£4,928,571.43£4,928,571.43-£4,928,571.43 £7,891,428.57| £19,651,428.57| £14,331,428.57| £11,811,428.57| £5,091,428.57 -£2,367,428.57-£5,895,428.57£4,299,428.57-£3,543,428.57£1,527,428.57 E5,524,000.00 £13,756,000.00 £10,032,000.00£8,268,000.00 £3,564,000.00 £4,928,571.43 £4,928,571.43£4,928,571.43£4,928,571.43 £4,928,571.43 £10,452,571.43 £18,684,571.43 £14,960,571.43 £13,196,571.43£8,492,571.43 Book value of equipment at end of year 5 Salvage value Tax (30%) on loss on sale Salvage value net of tax Annual Cash flow PV factor [1/(1+12%)^year] Discounted cash flow NPV £9,857,142.86 E5,500,000.00 E1,307,142.86 £6,807,142.86 E4,244,571.43 £14,610,571.43 £16,803,571.43£14,069,571.43 £22,865,714.29 0.567427 £3,789,795.92£11,647,458.09£11,960,450.24£8,941,467.00 12,974,620.36 E34,500,000.00 1 E34,500,000.00 £14,813,791.60 0.892857 0.797194 0.711780 0.635518

To get sensitivity of NPV to changes in the price of the new smart phone:

We increase the price of smart phone by £1 to  £486 and find NPV:

Workings with price of smart phone = £486

Year Unit sales Unit price Sales Value (unit salesUnit Price Net working capital required (20% of sales Increase in net working capital 2 64,000 106,000 87,000 78,000 £486 E31,104,000 E6,220,800 E6,220,800 £486 £51,516,000 £10,303,200 £4,082,400 £486 £42,282,000 £8,456,400 £1,846,800 £486 E37,908,000 £7,581,600 £874,800 54,000 £486 £26,244,000 £5,248,800 £7,581,600 Year Installed cost of equipment Increase in net working capital Sales Value Variable cost (unit sales205 Fixed cost Depreciation Earnings before tax Tax at 30% Earnings after tax Add back depreciation Operating cash flow 0 4 £34,500,000.00 £6,220,800.00-£4,082,400.00£1,846,800.00 £874,800.00£7,581,600.00 E31,104,000.00 £51,516,000.00 £42,282,000.00£37,908,000.00 £26,244,000.00 £13,120,000.00 -£21,730,000.00 -£17,835,000.00 -£15,990,000.00 -£11,070,000.00 E5,100,000.00-£5,100,000.00 -£5,100,000.00-£5,100,000.00£5,100,000.00 £4,928,571.43 -£4,928,571.43 -£4,928,571.434,928,571.43£4,928,571.43 £7,955,428.57| £19,757,428.57| £14,418,428.57| £11,889,428.57| £5,145,428.57 £2,386,628.57 -£5,927,228.57£4,325,528.57-£3,566,828.57-£1,543,628.57 £5,568,800.00 £13,830,200.00 £10,092,900.00 £8,322,600.00£3,601,800.00 £4,928,571.43 £4,928,571.43£4,928,571.43£4,928,571.43 £4,928,571.43 £10,497,371.43 £18,758,771.43£15,021,471.43 £13,251,171.43£8,530,371.43 Book value of equipment at end of vear 5 Salvage value Tax (30%) on loss on sale Salvage value net of tax Annual Cash flow PV factor [1/(1+12%)year] Discounted cash flow NPV £9,857,142.86 E5,500,000.00 E1,307,142.86 £6,807,142.86 £4,276,571.43 £14,676,371.43 £16,868,271.43 £14,125,971.43 £22,919,114.29 0.567427 £3,818,367.35 £11,699,913.45£12,006,502.42£8,977,310.22£13,004,920.95 E34,500,000.00 1 E34,500,000.00 £15,007,014.38 0.892857 0.797194 0.711780 0.635518

Change in NPV = 15007014.38 - 14813791.60 = 193222.78

Sensitivity of NPV to per £ change in price = £193,222.78

Add a comment
Know the answer?
Add Answer to:
help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill,...
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
  • help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill,...

    help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company in...

  • help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill,...

    help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company in...

  • help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill,...

    help me solve this? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company in...

  • help me solve this ? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box...

    help me solve this ? EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company...

  • EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing...

    EMU ELECTRONICS Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent graduate, has been hired by the company in the finance department. One...

  • EMU Electronics

    Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Robert McCanless, a recent MBA graduate, has been hired by the company in the finance department.One of the...

  • Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president...

    Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company in its finance department. One of the major revenue-producing...

  • CHAPTER CASE CONCH REPUBLIC ELECTRONICS C onch Republic Electronics is a midsizad olectron- los manufacturer located...

    CHAPTER CASE CONCH REPUBLIC ELECTRONICS C onch Republic Electronics is a midsizad olectron- los manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by the com- pany in...

  • CAPITAL BUDGETING Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The...

    CAPITAL BUDGETING Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company in its finance department One of the...

  • Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. When it was founded over 70 years ago,...

    Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, the company expanded into manufacturing and is now a reputable manufacturer of various electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company's finance department. One of the major revenue-producing items manufactured by...

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
ADVERTISEMENT