Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1: Answer the questions below and make sure to show all work that led up to your answer. a. What is Setia Bersama Berhads

Question 1:

image text in transcribed

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?

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

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:

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

c. 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

d. 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 Incremental Cash Flows.

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 check all the answers, 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 return

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions