Question 1:

Setia Bersama Berhad is a midsized plastic molding manufacturer located in Ijok, 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 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.

Answer the questions below and make sure to show all work that led up to your answer.

a. What is Setia Bersama Berhads net investment outlay on this project?

Net investment Outlay= Capital Expenditure-Depreciation

=38.5-(38.5*25%)

=RM28.875 million

b. Construct incremental operating cash flow statements for the project's 5 years of operations.

Incremental Operating Cash Flow of the new project is as follows:

Year	1	2	3	4	5
Amount in (RM)
(A) Quantity	74,000	95,000	125,000	105,000	80,000
(B) Sales Revenue (Quantity X RM 480)	35,520,000	45,600,000	60,000,000	50,400,000	38,400,000
(C) Variable Cost (Quantity X RM 185)	13,690,000	17,575,000	23,125,000	19,425,000	14,800,000
(D) Depreciation	5,501,650	9,428,650	6,733,650	4,808,650	3,438,050
(E) Fixed Cost	5,300,000	5,300,000	5,300,000	5,300,000	5,300,000
(F) Profit before tax (B-C-D-E)	11,028,350	13,296,350	24,841,350	20,866,350	14,861,950
(G) Tax @ 35% (F x 35%)	3,859,923	4,653,723	8,694,473	7,303,223	5,201,683
(H) Profit after tax (F-G)	7,168,428	8,642,628	16,146,878	13,563,128	9,660,268
(I) Depreciation (Note)	5,501,650	9,428,650	6,733,650	4,808,650	3,438,050
(J) Net Working Capital (Sales X 20%)	7,104,000	9,120,000	12,000,000	10,080,000	-
(K) Operating Cash Flow (H+I-J)	5,566,078	8,951,278	10,880,528	8,291,778	13,098,318

Note : Cost of Equipment = RM 38.5 million

Depreciation as per 7-years MACRS

Year	Depreciation Rate	Depreciation Amount (RM)
1	14.29%	(38,500,000 X 14.29%) 5,501,650
2	24.49%	(38,500,000 X 24.49%) 9,428,650
3	17.49%	(38,500,000 X 17.49%) 6,733,650
4	12.49%	(38,500,000 X 12.49%) 4,808,650
5	8.93%	(38,500,000 X 8.93%) 3,438,050

c. What is the net non-operating cash flow at the time the project is terminated?

Sale Proceeds of the Equipment = RM 5.4 million

hence, non-operating cash flow at the time the project is terminated = RM 5.4 million

d. Based on these cash flows, what is the project's NPV? Do these indicators suggest that the project should be undertaken?

(iii) Computation of NPV of the project:

Year	1	2	3	4	5
Operating Cash Flow	5,566,078	8,951,278	10,880,528	8,291,778	13,098,318
PVIF @ 12%	0.8928	0.7972	0.7118	0.6355	0.5674
PV of Operating Cash Flows	4,969,394	7,135,959	7,744,760	5,269,425	7,431,986

PV of Operating Cash Flows = 4,969,394 + 7,135,959 + 7,744,760 + 5,269,425 + 7,431,986

= RM 32,551,524

PV of Cash Inflows = PV of Operating Cash Flows + PV of non-operating cash flow at the end

= 32,551,524 + (0.5674 X 5,400,000)

= 32,551,524 + 3,063,960

= RM 35,615,484

NPV = PV of Cash Inflows - Initial Investment*

= RM 35,615,484 - RM 38,500,000

= (RM 2,884,516)

PV of Cash Outflow, for determining whether the project should be undertaken or not, has been taken as equipment cost only and not the cost of development of prototype and market study since thses costs are sunk cost which have already been incurred and will not affect the profitability of the project any more.

PLEASE HELP ME TO CHECK THE ANSWER IS IT CORRECT, IF WRONG PLEASE LET ME KNOW.