Question

In: Finance

An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000...

An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000 each. If the required rate of return is 12%:

a. What decision should be made using NPV? (5%)

b. How would the IRR decision rule be used for this project? What decision would be reached? (10%)

c. How are the above two decisions related? (10%)

Expert Solution

A. Net Present Value (NPV) = Present value of Cash Inflow - Present Value of Cash Outflow.

NPV = 2,00,000 * PVAF ( 12% , 8Year) - 10,00,000

NPV = 2,00,000 * 4.968 - 10,00,000

NPV = 9,93,527.95 - 10,00,000

NPV = -6,472.05

It is advised to the company is not to accept the project because it gives loss of amounting to -6472.05

Note -

PVAF stands for Present value Annuity Factor and it is calculated by using calculator.

B. IRR -

Let r = 10%

Then,

Net Present Value (NPV) = Present value of Cash Inflow - Present Value of Cash Outflow.

NPV = 2,00,000 * PVAF ( 10% , 8Year) - 10,00,000

NPV = 2,00,000 * 5.335 - 10,00,000

NPV = 10,66,985.24 - 10,00,000

NPV = 66,985.24

Let R = 15%,

Then,

Net Present Value (NPV) = Present value of Cash Inflow - Present Value of Cash Outflow.

NPV = 2,00,000 * PVAF ( 15% , 8Year) - 10,00,000

NPV = 2,00,000 * 4.487 - 10,00,000

NPV = 8,97,464.30 - 10,00,000

NPV = -1,02,535.70

IRR = Lower Rate + (Lower Rate NPV / Lower Rate NPV - Higher Rate NPV)* (Higher Rate - Lower Rate)

IRR = 10% + (66,985.24 / 66,985.24 + 1,02,535.70)* (15% - 10%)

IRR = 11.976%

C. It is advised to not accept the project that gives negative NPV i.e. Losses during the year. And IRR @ 11.976% is the rate where the NPV of this Project is zero i.e. The project if return is 11.976% gives 0 return.

If you have any query related to above question, Then you can ask me in a comment.

My priority is yours sartisfaction.

Thanks

jeff jeffy answered 2 years ago

There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2...

There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2 =320; CF3 = 340; CF4 = 360. If the appropriate discount rate is 10%, what is the project's MIRR? (Assume the same reinvestment rate) 14.08% 15.65% 17.21% 18.29% 19.15%

A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2...

A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2 = $200, CF3 = $150. WACC = 6%. Compute the following: A. Payback Period B. NPV C. IRR

An investment project has the following cash flows: CFO = -1,000,000; C01 - C08 = 200,000...

An investment project has the following cash flows: CFO = -1,000,000; C01 - C08 = 200,000 each • If the required rate of return is 12%, what decision should be made using NPV? • How would the IRR decision rule be used for this project, and what decision would be reached? • How are the above two decisions related? NOTE: do it on exal

Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...

Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...

An investment project has the following cash flows: CF0 = -1,200,000; C01 – C05 = 300,000...

An investment project has the following cash flows: CF0 = -1,200,000; C01 – C05 = 300,000 each If the required rate of return is 12%, calculate IRR= ( )%.

a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1...

a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1 = 300; CF2 = 560; CF3 = -90; CF4 = 250. b. What is the future value of these cash flows?

Match up the payback period with the cash flows. CF0: -1800 CF1: 930 CF2: 130...

Match up the payback period with the cash flows. CF0: -1800 CF1: 930 CF2: 130 CF3: 830 CF4: 420 CF0: -1900 CF1: 800 CF2: 350 CF3: 720 CF4: 120 CF0: -2000 CF1: 820 CF2: 170 CF3: 830 CF4: 320 CF0: -1750 CF1: 700 CF2: 350 CF3: 520 CF4: 450 CF0: -1550 CF1: 500 CF2: 170 CF3: 840 CF4: 320 A. About 3.56 years B. About 3.40 years C. About 3.13 years D. About 2.89 years E. About 3.25...

There are two projects: Project A and Project B a. Project A: CF0 = -6000; CF1-5...

There are two projects: Project A and Project B a. Project A: CF0 = -6000; CF1-5 = 2000; I/YR = 14. Calculate NPV, IRR, MIRR, Payback period, and discounted payback period for Project A. Project B: CF0 = -18000; CF1-5 = 5600; I/YR = 14. Calculate NPV, IRR, MIRR, Payback period, and discounted payback period for Project B. b. If the two projects are independent, which project(s) would be accepted? c. If the two projects are mutually exclusive, which project...

QUESTION Match up the payback period with the cash flows. CF0: -1360 CF1: 560 CF2: 330...

QUESTION Match up the payback period with the cash flows. CF0: -1360 CF1: 560 CF2: 330 CF3: 820 CF4: 200 CF0: -530 CF1: 500 CF2: 100 CF3: 970 CF4: 130 CF0: -900 CF1: 680 CF2: 110 CF3: 950 CF4: 180 CF0: -1675 CF1: 580 CF2: 240 CF3: 700 CF4: 180 CF0: -1230 CF1: 590 CF2: 240 CF3: 550 CF4: 410 A. About 2.73 years B. About 2.12 years C. About 3.86 years D. About 2.57 years E. About 1.30 years

You have the chance to participate in a project that produces the following cash flows. CF0=?...

You have the chance to participate in a project that produces the following cash flows. CF0=? CF1=$0 CF2=$11,000 The NPV of the project is $4,090.91. If the opportunity cost of capital is 10%, a) you would accept the project, if the IRR is greater than the required return. b) you would not accept the project, as the largest cash inflow occurs at the end of the project. c) you would not be able to decide whether to accept the project,...