QUESTION 1 J. Smythe, Inc., manufactures fine furniture. The com¬pany is decidin
ID: 2803684 • Letter: Q
Question
QUESTION 1 J. Smythe, Inc., manufactures fine furniture. The com¬pany is deciding whether to introduce a new mahogany dining room table set. The set will sell for RM25,000, including a set of eight chairs. The company feels that global sales of the set will be 1,800, 1,950, 2,500, 2,350, and 2,100 sets per year for the next five years, respectively. Variable costs will amount to 45 percent of sales, and fixed costs are RM8.5 million per year. The new tables will require inventory amounting to 10 percent of sales, pro¬duced and stockpiled in the year prior to sales. It is believed that the addition of the new table will cause a loss of 250 tables per year of the oak tables the company pro¬duces. These tables sell for RM20,000 and have variable costs of 40 percent of sales. The inventory for this oak table is also 10 percent of sales. J. Smythe currently has excess production capacity. If the company buys the necessary equipment today, it will cost RM72 million. However, the excess production capacity means the company can pro¬duce the new table without buying the new equipment. The company controller has said that the current excess capacity will end in two years with current production. This means that if the company uses the current excess capacity for the new table, it will be forced to spend the RM72million in two years to accommodate the increased sales of its current products. In five years, the new equipment will have a market value of RM14 million if purchased today, and RM33 million if purchased in two years. The equipment is depreciated on a seven-year MACRS schedule. The company has a tax rate of 40 percent, and the required return for the project is 14 percent.
1. Should J. Smythe undertake the new project?
2. Can you perform an IRR analysis on this project? How many IRRs would you expect to find?
3. How would you interpret the profitability index?
Explanation / Answer
1. Computation of NPV:
Calculation of Revenue: Sale of sets for the next 5 years, believed that by this additional sale there will be a loss of 250 tables at RM20,000 per table.
Year
1
2
3
4
5
Sales in sets
1,800
1,950
2,500
2,350
2,100
Price per set
25,000
25,000
25,000
25,000
25,000
Total sales
45,000,000
48,750,000
62,500,000
58,750,000
52,500,000
Less: Loss of tables (250*RM20,000)
(5,000,000)
(5,000,000)
(5,000,000)
(5,000,000)
(5,000,000)
revenue
40,000,000
43,750,000
57,500,000
53,750,000
47,500,000
Calculation of variable cost:
Variable cost at 45% of sales
20,250,000
21,937,500
28,125,000
26,437,500
23,625,000
Less: Lost sales 40% of sales
(2,000,000)
(2,000,000)
(2,000,000)
(2,000,000)
(2,000,000)
Variable cost
18,250,000
19,937,500
26,125,000
24,437,500
21,625,000
Computation of NPV:
Year
1
2
3
4
5
Sales
40,000,000
43,750,000
57,500,000
53,750,000
47,500,000
Less: Variable cost
(18,250,000)
(19,937,500)
(26,125,000)
(24,437,500)
(21,625,000)
Less: Fixed cost
-8500000
-8500000
-8500000
-8500000
-8500000
Less: depreciation
-10288800
-17632800
-12592800
EBT
13,250,000
15,312,500
12,586,200
3,179,700
4,782,200
Less: tax at 40%
-5300000
-6125000
-5034480
-1271880
-1912880
Net income
7,950,000
9,187,500
7,551,720
1,907,820
2,869,320
Add: Depreciation
10288800
17632800
12592800
OCF
7,950,000
9,187,500
17,840,520
19,540,620
15,462,120
Purcahse of equipment and sale of equipment
0
-72000000
0
0
32,394,240.0
Inventory changes
(375,000.0)
(1,375,000.0)
375,000.0
625,000.0
5,250,000.0
Net cash flows
7,575,000
(64,187,500)
18,215,520
20,165,620
53,106,360
Discounting factor at 14%
0.877192982
0.769467528
0.674971516
0.592080277
0.519368664
Present value of cash flows
6,644,736.84
(49,390,196.98)
12,294,957.15
11,939,665.88
27,581,779.26
Sum of Present value of cash flows
9,070,942.16
NPV = initial investment + Sum of Present value of cash flows
= (-4,500,000+500,000) + 9,070,942.16
= -4,000,000 + 9,070,942.16
Therefore, NPV = 5,070,942.16.
b. IRR = 19%
c. Profitability index = present value of future cash flows / initial investment
= 9,070,942.16 / 4,000,000 = 2.27
Year
1
2
3
4
5
Sales in sets
1,800
1,950
2,500
2,350
2,100
Price per set
25,000
25,000
25,000
25,000
25,000
Total sales
45,000,000
48,750,000
62,500,000
58,750,000
52,500,000
Less: Loss of tables (250*RM20,000)
(5,000,000)
(5,000,000)
(5,000,000)
(5,000,000)
(5,000,000)
revenue
40,000,000
43,750,000
57,500,000
53,750,000
47,500,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.