Question
Charm Co, a software company has developed a game, Fingo, which plans to launch in the near future. Sales of Fingo are expected to be
Charm Co, a software company has developed a game, Fingo, which plans to launch in the near future. Sales of Fingo are expected to be very strong, following a favourable review by a popular PC magazine which gave it a best buy recommendation. Information: Year 1 2 3 4 Sales and production (units) 150,000 70,000 60,000 60,000 Selling price $25 $24 $23 $22 Financial information for the 1st year of production: Direct material cost $5.4 per game Other variable production cost $6 per game Fixed costs $4 per game Advertising costs to stimulate demand are expected to be $650,000 in the 1st year of production and $100,000 in the 2nd year. No advertising costs are expected in the 3rd and 4th years of production. Fixed costs represent incremental cash fixed production overheads. Fingo will be produced on a new production machine costing $800,000. Although this production machine is expected to have a useful life of up to ten years, government legislation allows the company to claim the capital cost of the machine against the manufacture of a single product. Capital allowances will therefore be claimed on a straight-line basis over 4 years. The company pays tax on profit at a rate of 30% per year and tax liabilities are settled in the year in which they arise. The company uses an after-tax discount rate of 10% when appraising new capital investments. Required: a) Below we have the NPV that is 13,96,708.20 $. Calculate the Internal Rate of Return (IRR) and comment. b) Discuss why the NPV method is preferred to other investment appraisal methods such as payback, return on capital employed and IRR.
How to find the NPV:
Year2 | Year3 | Year4 | ||
Sales & Production (Units) | 150000 | 70000 | 60000 | 60000 |
Selling Price | 25 | 24 | 23 | 22 |
Sales Value (Sales unit*Selling Price) | $ 37,50,000 | $ 16,80,000 | $ 13,80,000 | $ 13,20,000 |
Expenses: | ||||
Direct material Cost @$5.40 (Sales unit*5.4) | $ 8,10,000 | $ 3,78,000 | $ 3,24,000 | $ 3,24,000 |
Other Variable Cost @$6 (Sales unit*6) | $ 9,00,000 | $ 4,20,000 | $ 3,60,000 | $ 3,60,000 |
Advertising Cost | $ 6,50,000 | $ 1,00,000 | $ - | $ - |
Depreciation | $ 2,00,000 | $ 2,00,000 | $ 2,00,000 | $ 2,00,000 |
Total Expenses | $ 25,60,000 | $ 10,98,000 | $ 8,84,000 | $ 8,84,000 |
Net Income before tax | $ 11,90,000 | $ 5,82,000 | $ 4,96,000 | $ 4,36,000 |
Tax (30%) - (Net Income*30%) | $ 3,57,000 | $ 1,74,600 | $ 1,48,800 | $ 1,30,800 |
Net Income after tax | $ 8,33,000 | $ 4,07,400 | $ 3,47,200 | $ 3,05,200 |
Add: | ||||
Depreciation | $ 2,00,000 | $ 2,00,000 | $ 2,00,000 | $ 2,00,000 |
Annual Free Cash Flow | $ 10,33,000 | $ 6,07,400 | $ 5,47,200 | $ 5,05,200 |
-
Depreciation (Straight line Method) | |
Production Cost (Initial Outlay) | $ 8,00,000 |
Salvage Value | Nil |
Useful Life | 4 |
Depreciation | $ 2,00,000 |
(800000/4) |
-
Net Present Value
Year | Annual cash flows | PV Factor @10% | Present Value of cash flows |
0 | -8,00,000 | 1 | $ -8,00,000.00 |
1 | 10,33,000 | 0.909 | $ 9,38,997.00 |
2 | 6,07,400 | 0.826 | $ 5,01,712.40 |
3 | 5,47,200 | 0.751 | $ 4,10,947.20 |
4 | 5,05,200 | 0.683 | $ 3,45,051.60 |
NPV | $ 13,96,708.20 |
Since Net Present Value is Positive , so the Investment plan is feasible .
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started