Question

ERS Ltd is considering the launch of a new product after an extensive market research whose...

ERS Ltd is considering the launch of a new product after an extensive market research whose costs were K20,000. The research cost is due for payment in a months’ time. The management accountant has prepared the following forecasts for the product.
Year 1234
Sales
Material cost.
Variable overheads.
Fixed overheads.
Market research cost expensed. Net profit/(loss).
215,000 (115,000)
(27,000) (25,000) (20,000)
(7,000)
200,000 (140,000)
(30,000) (25,000)
5,000
150,000 (110,000)
(24,000) (25,000)
1,000
120,000 (85,000) (18,000) (25,000)
(8,000)
KKKK
The CEO pointed out that the product achieved profits in only two years of its four-year life and that over the four-year period as a whole, a net loss was expected. However, before a meeting that had been arranged to decide formally the future of the product, the following additional information became available:
i. The new product will require the use of an existing machine. This machine was acquired some time back for K400,000 and has since been depreciated down value to a book value of K80,000. The machine can be sold for K90,000 immediately if the new product is not launched. If the product is launched, it will be sold at the end of the four-year period for K15,000.
ii. If the product is launched, a marketing cost of K1,000 per year will be incurred due to social media adverts expected to be used. This cost is included in the projected fixed overhead value reported each year.
iii. Additional working capital of 10% of sales revenue each year will be required through- out the four-year period. It will be released at the end of the investment period.
iv. The fixed overheads include a figure of K15,000 per year for depreciation of the machine and K5,000 per year for the re-allocation of existing overheads of the business.
v. All the values above are in money terms except for variable overheads which are in current price terms. Variable overhead inflation is 2% per year.
vi. The money cost of capital is 11%. Ignore taxation.
2
Required:
a) Identify the relevant cash flows associated with the decision to launch the new
product and determine the net cash flows for each year (year 0 to 4).
b) Calculate the Net present value (NPV).
c) Determine the approximate internal rate of return (IRR).
d) Comment on the proposal to launch the new product.
e) Briefly discuss why you have omitted specific figures in (a) above (if any).

0 0
Add a comment Improve this question Transcribed image text
Answer #1
ERS
Schedule of Profit / Loss on the product for the year 1-4
Amount in K
Year 1 2 3 4
Sales          215,000          200,000          150,000             120,000
Material cost.          115,000          140,000          110,000               85,000
Variable overheads.            27,000            30,000            24,000               18,000
Fixed overheads.            25,000            25,000            25,000               25,000
Market research cost expensed.            20,000                     -                       -                          -  
Total costs          187,000          195,000          159,000             128,000
Net profit/(loss).            28,000              5,000            (9,000)               (8,000)
TOTAL PROFIT               16,000
The net profit loss given for the Year 1 and 3 have been wrongly computed in the question. Hence calcaulations are made after rectifying the same .
a & b
Computation of relevant cash flows associated with the decision to launch the new product
Year 1 2 3 4
Estimated profit/ loss ( From Table above)            28,000              5,000            (9,000)               (8,000)
Add: Research costs            20,000
Less: Additional working capital required ( 10% of sales revenue )            21,500            20,000            15,000               12,000
Add: Depreciation ( Non cash )            15,000            15,000            15,000               15,000
Add: Reallocated Overheads              5,000              5,000              5,000                 5,000
Less: Inflation @ 2% pa on Variable OH                     -                    600                  480                     360
Net Cash profits            46,500              4,400            (4,480)                   (360)
Add: Release of WC               68,500
Add: Sale of Equipment               15,000
Total Cash flow/outflow            46,500              4,400            (4,480)               83,140
PVF @ 11%            0.9009            0.8116            0.7312               0.6587
DCF - NPV            41,892              3,571            (3,276)               54,767
NET PRESENT VALUE OF CASH FLOWS               96,954
If Machine is sold immediately
Sale value received immediately 90,000
So it is better to launch the product as the project gives a higher positive NPV
The assumptions for calculations have been mentioned in (e ) below.
b)Calculation of IRR :
IRR is the internal rate of return I,e the rate at which if the discounting of cash flows is done , the NPV is equal to 0.
It is the minimum rate required to make the project a no profit no loss .
The NPV is positive when we use the cost of capital as a discounting factor . So for the NPV to be zero or negative , a lower rate of return is required. The same can be done by trial or error , method or by using formula
Year 1 2 3 4
Cash flows            46,500              4,400            (4,480)               83,140
PVF @ 14.2%                 0.88                 0.77                 0.67                    0.59
     40,748.37        3,378.84      (3,012.50)         48,954.47
The value without launch is 90,000 and with launch is 96,954 , hence we need to find the IRR in between .
The approximate IRR will be 14.2%
d) The proposal should be launched .
e)
Notes :
1. Incremental approach has been used and hence the profits calculated above have been adjusted .
2. The marketing costs have been excluded as they have to be paid irrespective of launch of product .
3. Depreciation has been added back as it is a non cash item.
4 The total of additional working capital has been released at the end of the 4th year.
5 The book value of Equipment is            80,000
Depreciation charged in 4 years
= 15000 x 4
           60,000
Thus Book value at the end of 4th year            20,000
Less: Residual value at the end of 4th year            15,000
Loss on sale              5,000
5. Loss on sale has been ignored as the tax has to be ignored .
Know the answer?
Add Answer to:
ERS Ltd is considering the launch of a new product after an extensive market research whose...
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
  • 8 pt X Company is planning to launch a new product. A market research study, costing...

    8 pt X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $152.000 in each of the first two years and $106,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $83.000 New manufacturing equipment will have to be...

  • X Company is planning to launch a new product. A market research study, costing $150,000, was...

    X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $154,000 in each of the first two years and $100,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $87,000. New manufacturing equipment will have to be purchased for...

  • 6LTZSy 8 pt X Company is planning to launch a new product. A market research study,...

    6LTZSy 8 pt X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $152.000 in each of the first two years and $106,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $83,000. New manufacturing equipment will have to...

  • X Company is planning to launch a new product. A market research study, costing $120,000, was...

    X Company is planning to launch a new product. A market research study, costing $120,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $164,000 in each of the first two years and $101,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $76,000. New manufacturing equipment will have to be purchased for...

  • X Company is planning to launch a new product. A market research study, costing $150,000, was...

    X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $163,000 in each of the first two years and $ 105,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $77,000. New manufacturing equipment will have to be purchased...

  • X Company is planning to launch a new product. A market research study, costing $150,000, was...

    X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $151,000 in each of the first two years and $107,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $78,000. New manufacturing equipment will have to be purchased for...

  • X Company is planning to launch a new product. A market research study, costing $190,000, was...

    X Company is planning to launch a new product. A market research study, costing $190,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $151,000 in each of the first two years and $117,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $88,000. New manufacturing equipment will have to be purchased for...

  • X Company is planning to launch a new product. A market research study, costing $100,000, was...

    X Company is planning to launch a new product. A market research study, costing $100,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $163,000 in each of the first two years and $103,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $90,000. New manufacturing equipment will have to be purchased for...

  • X Company is planning to launch a new product. A market research study, costing $100,000, was...

    X Company is planning to launch a new product. A market research study, costing $100,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $174,000 in each of the first two years and $120,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $88,000. New manufacturing equipment will have to be purchased for...

  • X Company is planning to launch a new product. A market research study, costing $150,000, was...

    X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $152,000 in each of the first two years and $114,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $85,000. New manufacturing equipment will have to be purchased for...

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