Question

In: Finance

Sigma Pty. Ltd. is evaluating whether to buy pieces of medical equipment each of which requires...

Sigma Pty. Ltd. is evaluating whether to buy pieces of medical equipment each of which requires an up-front expenditure of $1.5 million. The projects are expected to produce the following net cash inflows:

Year Equipment A Equipment B

1 $500,000 $2,000,000

2 $1,000,000 $1,000,000

3   $2,000,000 $600,000

a. What is the internal rate of return for each piece of equipment?

b. What is the payback period for each machine?

c. What is the net present value of each machine if the cost of capital is 10 per cent? 5 per cent? 15 per cent?

d. Should Better Health buy both machines, only one, or none? Explain your answer

Solutions

Expert Solution

a)

Equipment A:

Internal rate of return is the rate that makes NPV equal to 0

NPV = -1,500,000 + 500,000 / (1 + R)1 + 1,000,000 / (1 + R)2 + 2,000,000 / (1 + R)3

Using trial and error method, i.e., after trying various values for R, lets try R as 43.97%

NPV = -1,500,000 + 500,000 / (1 + 0.4397)1 + 1,000,000 / (1 + 0.4397)2 + 2,000,000 / (1 + 0.4397)3

NPV = = 0

Therefore, IRR of equipment A is 43.97%

Equipment B:

Internal rate of return is the rate that makes NPV equal to 0

NPV = -1,500,000 + 2,000,000 / (1 + R)1 + 1,000,000 / (1 + R)2 + 600,000 / (1 + R)3

Using trial and error method, i.e., after trying various values for R, lets try R as 82.03%

NPV = -1,500,000 + 2,000,000 / (1 + 0.8203)1 + 1,000,000 / (1 + 0.8203)2 + 600,000 / (1 + 0.8203)3

NPV = = 0

Therefore, IRR of equipment B is 82.03%

b)

Equipment A:

Cumulative cash flow for year 0 = -1,500,000

Cumulative cash flow for year 1 = -1,500,000 + 500,000 = -1,000,000

Cumulative cash flow for year 2 = -1,000,000 + 1,000,000 = 0

Payback period of equipment A is 2 years

Equipment B:

Cumulative cash flow for year 0 = -1,500,000

Cumulative cash flow for year 1 = -1,500,000 + 2,000,000 = 500,000

Payback period of equipment B is 1 year

c)

Equipment A:

net present value = Present value of cash inflows - present value of cash outflows

Net present value = -1,500,000 + 500,000 / (1 + 0.1)1 + 1,000,000 / (1 + 0.1)2 + 2,000,000 / (1 + 0.1)3

Net present value = $1,283,621.34

Net present value = -1,500,000 + 500,000 / (1 + 0.05)1 + 1,000,000 / (1 + 0.05)2 + 2,000,000 / (1 + 0.05)3

Net present value = $1,610,895.15

Net present value = -1,500,000 + 500,000 / (1 + 0.15)1 + 1,000,000 / (1 + 0.15)2 + 2,000,000 / (1 + 0.15)3

Net present value = $1,005,958.74

Equipment B:

net present value = Present value of cash inflows - present value of cash outflows

Net present value = -1,500,000 + 2,000,000 / (1 + 0.1)1 + 1,000,000 / (1 + 0.1)2 + 600,000 / (1 + 0.1)3

Net present value = $1,595,416.98

Net present value = -1,500,000 + 2,000,000 / (1 + 0.05)1 + 1,000,000 / (1 + 0.05)2 + 600,000 / (1 + 0.05)3

Net present value = $1,830,093.94

Net present value = -1,500,000 + 2,000,000 / (1 + 0.15)1 + 1,000,000 / (1 + 0.15)2 + 600,000 / (1 + 0.15)3

Net present value = $1,389,783.84

d)

Health should buy both machines as it has IRRs greater than cost of capital and NPV for both the projects are positive. Positive NPV will add value to the firm.


Related Solutions

Aruma Ltd. evaluating an investment project which requires the importation of a new machine at a...
Aruma Ltd. evaluating an investment project which requires the importation of a new machine at a cost of Shs. 2,700,000. The machine has a useful life of six years. Additional information: The following additional costs would be incurred in relation to the 1. machine: Shs. Freight 225,000 Installation and Pre-production 375,000 Import Duty 900.000 The machine is expected to increase the company’s annual cash flows (before tax) as shown below: Year 1 2 3 4 4 6 Increase in Cash...
Lisa Limited Pty Ltd purchases a new equipment on 1 January 2015. The equipment cost was...
Lisa Limited Pty Ltd purchases a new equipment on 1 January 2015. The equipment cost was $200,000 and useful life was 10 years with zero residual value. On January 1, 2019, the company decides that the equipment will last total 20 years rather than 10 years. The company uses straight-line method of depreciation and the fiscal year end is 31 December. Required: Calculate depreciate for 2015, 2016, 2017 and 2018. How will the equipment be reported on the balance sheet...
Sefalana (Pty) Ltd is evaluating two projects that have an expected life of five years and...
Sefalana (Pty) Ltd is evaluating two projects that have an expected life of five years and an initial investment outlay of P1 million. Below are the estimated net cash inflows for each project: Year Cash flows - Project A (Pula) Cash flows -Project B (Pula) 1 300,000 400,000 2 320,000 400,000 3 370,000 400,000 4 430,000 400,000 5 550,000 400,000 The cost of capital for both projects is 10 per cent. Required: Advise management on the project that they can...
Sonoco Inc is evaluating a 4-year project that requires $118,000 of new equipment. This equipment will...
Sonoco Inc is evaluating a 4-year project that requires $118,000 of new equipment. This equipment will be depreciated straight-line to a zero-book value over the life of the project. This project is expected to generate operating cash flows of $39,000 per year for four years. At the beginning of the project, inventory will be lowered by $9,000, accounts receivable will increase by $14,000, and accounts payable will increase by $11,000. At the end of the project, net working capital will...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment.
                                                                                             HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning of the year 2020, H&S expanded its retail business by adding over 50 shops in order to meet...
Question 9 The Director of Edinam Ltd are considering whether to replace the company’s equipment which...
Question 9 The Director of Edinam Ltd are considering whether to replace the company’s equipment which cost GHS20,000 14 years ago. The equipment is used for the manufacture of tyres. The equipment’s remaining useful life is estimated to be 6 years and the net receipt from manufacturing tyres can be assumed to continue at GHS12,000 per year for that period. The net receipt comprises sales minus cost of production but no deduction has been made for depreciation or tax. A...
Heavy Duty Gym Equipment Pty Ltd sells gym equipment and personal trainer lessons. On 1 June...
Heavy Duty Gym Equipment Pty Ltd sells gym equipment and personal trainer lessons. On 1 June 2020, Heavy Duty Gym Equipment Pty Ltd signs an agreement with Burwood Fitness Club to provide 2 personal training sessions for 10 weeks and 5 items of gym equipment. The contract price amounted to $44,000 (GST inclusive), on credit terms n/30 for the equipment and the personal training lessons. This amount also includes one free service for the equipment to be performed twelve months...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning of the year 2020, H&S expanded its retail business by adding over 50 shops in order to meet the demand for protective gear. The following information has been extracted from the comparative financial statements included in the company's 2019 annual report (all amounts are in thousands of Rands): Dec. 31, 2019 Dec. 31, 2018 Total liabilities R26 000   R18 000   Total shareholders' equity 34...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning of the year 2020, H&S expanded its retail business by adding over 50 shops in order to meet the demand for protective gear. The following information has been extracted from the comparative financial statements included in the company's 2019 annual report (all amounts are in thousands of Rands): Dec. 31, 2019 Dec. 31, 2018 Total liabilities R26 000   R18 000   Total shareholders' equity 34...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning...
HEALTH and SAFETY (PTY) LTD (H&S) is a wholesaler of Personal Protective Equipment. At the Beginning of the year 2020, H&S expanded its retail business by adding over 50 shops in order to meet the demand for protective gear. The following information has been extracted from the comparative financial statements included in the company's 2019 annual report (all amounts are in thousands of Rands): Dec. 31, 2019 Dec. 31, 2018 Total liabilities R26 000   R18 000   Total shareholders' equity 34...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT