1. What is Setia Bersama Berhads net investment outlay on this project? Initial Investment Year 0 RM Price of equipment 38,500,000 Add : Develop a
1. What is Setia Bersama Berhads net investment outlay on this project?
Initial Investment | |
Year 0 | RM |
Price of equipment | 38,500,000 |
Add : Develop a prototype Marketing study |
750,000 200,000 |
Initial Outlay | 39,450,000 |
2. Construct incremental operating cash flow statements for the project's 5 years of operations.
Operating Cash Flow[if introduce new disposal bin] | ||||||
Yearly cash flow | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total |
Revenue | 39,645,000 | 45,600,000 | 60,000,000 | 50,400,000 | 38,400,000 |
|
Variable cost | (15,565,000) | (17,575,000) | (23,125,000) | (19,425,000) | (14,800,000) |
|
Fixed cost | (5,300,000) | (5,300,000) | (5,300,000) | (5,300,000) | (5,300,000) |
|
Operation cash flow | (7,929,000) | - | - | - | - |
|
Depreciation | (7,700,000) | (7,700,000) | (7,700,000) | (7,700,000) | (7,700,000) |
|
Profit before tax | 3,151,000 | 15,025,000 | 23,875,000 | 17,975,000 | 10,600,000 |
|
Tax payable - 35% | (1,102,850) | (5,258,750) | (8,356,250) | 6,291,250) | (3,710,000) |
|
Profit After tax | 2,048,150 | 9,766,250 | 15,518,750 | 11,683,750 | 6,890,000 |
|
Add:Depreciation | 7,700,000 | 7,700,000 | 7,700,000 | 7,700,000 | 7,700,000 |
|
Cash Flow | 9,748,150 | 17,466,250 | 23,218,750 | 19,383,750 | 14,590,000 |
|
PV Factor Lump Sum 12% | 0.8929 | 0.7972 | 0.7118 | 0.6355 | 0.5674 |
|
PV of cash flow | 8,704,123.135 | 13,924,094.5 | 16,527,106.25 | 12,318,373.13 | 8,278,366 | 59,752,063.02 |
3. What is the net non-operating cash flow at the time the project is terminated?
Non-operating cash flow at 5th years end = 5400000+1116273 = 6516273
4. Based on these cash flows, what is the project's NPV? Do these indicators suggest that the project should be undertaken?
NPV of Cash Flows | =NPV(12%,Year 1:Year 5)
|
| RM56,565,292.94 |
|
|
Operating Incremantal CashFlows | |
Year 1 | 2,283,578 |
Year 2 | 13,227,778 |
Year 3 | 20,000,528 |
Year 4 | 20,291,778 |
Year 5 | 29,694,590 |
= RM56,565,292.94
The company should take the project because the NPV is greater than the capital invested.
^ Please help me to check, if the answer is wrong, please show me the correct calculation. Thanks.
Setia Bersama Berhad is a midsized plastic molding manufacturer located in liok, Selangor. The CEO is Encik Astan, who inherited the company from his grandfather. Over the years, the company expanded its business and is now a reputable manufacturer of various plastics items. One of the major revenue-producing items manufactured by Setia Bersama Berhad is a Hospital Disposable Bin. Setia Bersama Berhad currently has one disposable bin model, and sales have been excellent. Setia Bersama Berbad spent RM750,000 to develop a prototype for a new hospital disposable bin that is lighter and more user friendly compared with the current model. The company has spent a further RM200,000 for a marketing study to determine the expected sales figures for the new hospital disposable bin. Setia Bersama Berhad can manufacture the new hospital disposable bin for RM185 each in variable costs. Fixed costs for the operation are estimated to run RM5.3 million per year. The estimated sales volume is 74,000,95,000,125,000, 105,000 , and 80,000 per year for the next five years, respectively. The unit price of the new hospital disposable bin will be RM480. The necessary equipment can be purchased for RM38.5 million and will be depreciated on a seven-year MACRS schedule. It is believed the disposal value of the equipment in five years will be RM5.4 million As previously stated, Setia Bersama Berhad currently manufactures a hospital disposable bin. Production for the existing model is expected to be terminated in two years. If Setia Bersama Berhad does not introduce the new hospital disposable bin, sales will be 80,000 units and 60,000 units for the next two years, respectively. The price of the existing hospital disposable bin is RM310 per unit, with variable costs of RM125 each and fixed costs of RM1.8 million per year. If Setia Bersama Berhad does introduce the new hospital disposable bin, sales of the existing hospital disposable bin will fall by 15,000 units per year, and the price of the existing units will have to be lowered to RM275 each. Net working capital for the hospital disposable bin will be 20% of sales and will occur with the timing of the cash flows for the year; for example, there is no initial outlay for NWC, but changes in NWC will first occur in year 1 with the first year's sales. Setia Bersama Berhad has a 35% corporate tax rate and a 12% required return. Setia Bersama Berhad is a midsized plastic molding manufacturer located in liok, Selangor. The CEO is Encik Astan, who inherited the company from his grandfather. Over the years, the company expanded its business and is now a reputable manufacturer of various plastics items. One of the major revenue-producing items manufactured by Setia Bersama Berhad is a Hospital Disposable Bin. Setia Bersama Berhad currently has one disposable bin model, and sales have been excellent. Setia Bersama Berbad spent RM750,000 to develop a prototype for a new hospital disposable bin that is lighter and more user friendly compared with the current model. The company has spent a further RM200,000 for a marketing study to determine the expected sales figures for the new hospital disposable bin. Setia Bersama Berhad can manufacture the new hospital disposable bin for RM185 each in variable costs. Fixed costs for the operation are estimated to run RM5.3 million per year. The estimated sales volume is 74,000,95,000,125,000, 105,000 , and 80,000 per year for the next five years, respectively. The unit price of the new hospital disposable bin will be RM480. The necessary equipment can be purchased for RM38.5 million and will be depreciated on a seven-year MACRS schedule. It is believed the disposal value of the equipment in five years will be RM5.4 million As previously stated, Setia Bersama Berhad currently manufactures a hospital disposable bin. Production for the existing model is expected to be terminated in two years. If Setia Bersama Berhad does not introduce the new hospital disposable bin, sales will be 80,000 units and 60,000 units for the next two years, respectively. The price of the existing hospital disposable bin is RM310 per unit, with variable costs of RM125 each and fixed costs of RM1.8 million per year. If Setia Bersama Berhad does introduce the new hospital disposable bin, sales of the existing hospital disposable bin will fall by 15,000 units per year, and the price of the existing units will have to be lowered to RM275 each. Net working capital for the hospital disposable bin will be 20% of sales and will occur with the timing of the cash flows for the year; for example, there is no initial outlay for NWC, but changes in NWC will first occur in year 1 with the first year's sales. Setia Bersama Berhad has a 35% corporate tax rate and a 12% required returnStep by Step Solution
There are 3 Steps involved in it
Step: 1
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