Question: Hi , pls help me to do question d and e. answer provided for a b and c i did it by myself! Question !

Hi , pls help me to do question d and e. answer provided for a b and c
Hi , pls help me to do question d and e. answer
provided for a b and c i did it by myself! Question
! Setia Bersama Berhad is a midsized plastic molding manufacturer located in
i did it by myself!

Question ! Setia Bersama Berhad is a midsized plastic molding manufacturer located in Tjok, Selangor. The CEO is Encik Asfan, 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 Berhad 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 cach 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 cach. 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 I with the first year's sales. Setia Bersama Berhad has a 35% corporate tax rate and a 12% required return. Answer the questions below and make sure to show all work that led up to your answer. What is Setia Bersama Berhads' net investment outlay on this project? Calculation of Net Investment Outlay of the project for Setia Bersama Berhads' is: Net Investment Outlay = capital expenditure - depreciation = 38.5-(38.5 x 25%) = RM 28.875 million Construct incremental operating cash flow statements for the project's 5 years of operations. Payback period is the period of recovery of total initial outlay of a project. In the given case total initial outlay can be calculated as RM 750,000 + RM 200,000 + RM 38.5 million (i.e. RM 39.5 million) As per the information provided, the project will create a sale of RM 35.52 million in the first year and RM 10. 6155 million of disposable cash out of the sale proceeds after deducting the variable cost of RM13.69 million, fixed cost of RM 5.3 million and tax expense of RM 7.1695 million and interest cost of RM 3.16 million. Likewise in the 2nd year, the project will produce a cash flow of RM 15.03225 million. In the 3rd year, the project will produce a cash flow of RM 21.43 million. Hence the payback period of the project is 3 years. Y VS Sales 35 520,000 45.900.000 60.000.000 50.400.000 28.400,000 Sales Variables 21.830,000 28,025.000 38.875.000 30.975.00022 800.000 Fred depreciation 5.300.000 5.300.000 5.300.000 5.300.000 5.300.000 2.100.000 2,563,560 1.566,064 71 13 Y1 Y2 Y YE Depreciation 5.500.000 5.500.000 5.500.000 5500.000 5500.000 Nel prolt before 7.870.000 1.06.440 24,50.988 20.175.000 13.500.000 TEX 2.754.500 6,131,504 3.578,128 7061250 4.400,000 ut profiter tax 5,115.500 9.520.936 15.930.906 13.113.750 8.320.000 Profitable Index 14.40 20:50 26.550 What is the net non-operating cash flow at the time the project is terminated? IRR of the project of Setia Bersama Berhads': YI Ch 10.615.00 2250 2140,000 News 14.5 15.02.2014.06.2010 IRR = 47% d. Based on these cash flows, what is the project's NPV? Do these indicators suggest that the project should be undertaken? c. Suppose Setia Bersama Berhad loses sales on other models because of the introduction of the new model. How would this affect your analysis? Question ! Setia Bersama Berhad is a midsized plastic molding manufacturer located in Tjok, Selangor. The CEO is Encik Asfan, 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 Berhad 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 cach 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 cach. 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 I with the first year's sales. Setia Bersama Berhad has a 35% corporate tax rate and a 12% required return. Answer the questions below and make sure to show all work that led up to your answer. What is Setia Bersama Berhads' net investment outlay on this project? Calculation of Net Investment Outlay of the project for Setia Bersama Berhads' is: Net Investment Outlay = capital expenditure - depreciation = 38.5-(38.5 x 25%) = RM 28.875 million Construct incremental operating cash flow statements for the project's 5 years of operations. Payback period is the period of recovery of total initial outlay of a project. In the given case total initial outlay can be calculated as RM 750,000 + RM 200,000 + RM 38.5 million (i.e. RM 39.5 million) As per the information provided, the project will create a sale of RM 35.52 million in the first year and RM 10. 6155 million of disposable cash out of the sale proceeds after deducting the variable cost of RM13.69 million, fixed cost of RM 5.3 million and tax expense of RM 7.1695 million and interest cost of RM 3.16 million. Likewise in the 2nd year, the project will produce a cash flow of RM 15.03225 million. In the 3rd year, the project will produce a cash flow of RM 21.43 million. Hence the payback period of the project is 3 years. Y VS Sales 35 520,000 45.900.000 60.000.000 50.400.000 28.400,000 Sales Variables 21.830,000 28,025.000 38.875.000 30.975.00022 800.000 Fred depreciation 5.300.000 5.300.000 5.300.000 5.300.000 5.300.000 2.100.000 2,563,560 1.566,064 71 13 Y1 Y2 Y YE Depreciation 5.500.000 5.500.000 5.500.000 5500.000 5500.000 Nel prolt before 7.870.000 1.06.440 24,50.988 20.175.000 13.500.000 TEX 2.754.500 6,131,504 3.578,128 7061250 4.400,000 ut profiter tax 5,115.500 9.520.936 15.930.906 13.113.750 8.320.000 Profitable Index 14.40 20:50 26.550 What is the net non-operating cash flow at the time the project is terminated? IRR of the project of Setia Bersama Berhads': YI Ch 10.615.00 2250 2140,000 News 14.5 15.02.2014.06.2010 IRR = 47% d. Based on these cash flows, what is the project's NPV? Do these indicators suggest that the project should be undertaken? c. Suppose Setia Bersama Berhad loses sales on other models because of the introduction of the new model. How would this affect your analysis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!