Question

In: Finance

The following are the cash flows of two projects: Year Project A Project B 0 $...

The following are the cash flows of two projects:

Year Project A Project B
0 $ (330 ) $ (330 )
1 160 230
2 160 230
3 160 230
4 160

a. If the opportunity cost of capital is 12%, calculate the NPV for both projects. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

b. Which of these projects is worth pursuing?

****NOTE**** You are finding the NPV, NOT the Profitability index!

Solutions

Expert Solution

a. Calculating NPV of Project A

NPV of Project A = Cash flow in year 0 + Present value of cash flow for year 1 to year 4

NPV of Project A = -330 + 160 / (1+12%)1 + 160 / (1+12%)2 + 160 / (1+12%)3 + 160 / (1+12%)4

We can find the present value of cash flow for year 1 to year 4 using PV function in excel

Formula to be used in excel: =PV(rate,nper,-pmt)

Using PV function in excel, we get present value of cash flow for year 1 to year 4 = 485.9758

NPV of Project A = -330 + 485.9758 = 155.9758 = $155.98 (rounded to two decimal places)

Calculating NPV of Project B

NPV of Project B = Cash flow in year 0 + Present value of cash flow for year 1 to year 3

NPV of Project A = -330 + 230 / (1+12%)1 + 230 / (1+12%)2 + 230 / (1+12%)3

We can find the present value of cash flow for year 1 to year 3 using PV function in excel

Formula to be used in excel: =PV(rate,nper,-pmt)

Using PV function in excel, we get Present value of cash flows for year 1 to year 3 = 552.4211

NPV of Project B = -330 + 552.4211 = 222.4211 = $222.42 (rounded to two decimal places)

Hence NPV of the Project =$222.42

b. As projects have unequal lives therefore to find which of these projects is worth pursuing, we need to calculate the equivalent annual annuity of both the Projects. The project with higher equivalent annual annuity should be pursued

Finding Equivalent annual annuity of Project A

We can find the equivalent annual annuity of project A by using PMT function in excel

Formula to be used in excel: =PMT(rate,nper,-pv)

Using PMT function in excel, we get equivalent annual annuity of Project A = $51.35

Finding Equivalent annual annuity of Project B

We can find the equivalent annual annuity of project B by using PMT function in excel

Formula to be used in excel: =PMT(rate,nper,-pv)

Using PMT function in excel, we get equivalent annual annuity of Project B = 92.60

Since Project B has higher Equivalent annual annuity as compared to Project A, therefore Project B is Worth Pursuing.

Answer: Project B


Related Solutions

The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 380 ?$ 380 1 210 280 2 210 280 3 210 280 4 210 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 280 ?$ 280 1 160 180 2 160 180 3 160 180 4 160 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project A Profitability Index Project B
The following are the cash flows of two projects: Year Project A Project B 0 −$...
The following are the cash flows of two projects: Year Project A Project B 0 −$ 290 −$ 290 1 170 190 2 170 190 3 170 190 4 170 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (330) $ (330) 1 160 230 2 160 230 3 160 230 4 160 If the opportunity cost of capital is 12%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project Profitability Index: A B
The following are the cash flows of two projects: Year Project A Project B 0 ?$...
The following are the cash flows of two projects: Year Project A Project B 0 ?$ 220 ?$ 220 1 100 120 2 100 120 3 100 120 4 100 If the opportunity cost of capital is 10%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.)
The following are the cash flows of two projects: Year Project A Project B 0 $...
The following are the cash flows of two projects: Year Project A Project B 0 $ (260 ) $ (260 ) 1 140 160 2 140 160 3 140 160 4 140 a. Calculate the NPV for both projects if the opportunity cost of capital is 16%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project A Project B b. Suppose that you can choose only one of these projects. Which would you choose? Project A...
The following are the cash flows of two projects: Year Project A Project B 0 $(340)...
The following are the cash flows of two projects: Year Project A Project B 0 $(340) $(340) 1 170 240 2 170 240 3 170 240 4 170 A.) Calculate the NPV for both projects if the opportunity costs of capital is 15%. *(2 decimal places, do not round intermediate calculations) B.) Suppose you can choose one one of these projects, which would you choose?
The following are the cash flows of two projects: Year Project A Project B 0 −$330...
The following are the cash flows of two projects: Year Project A Project B 0 −$330        −$330        1 160        230        2 160        230        3 160        230        4 160        a. Calculate the NPV for both projects if the opportunity cost of capital is 17%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project NPV         A $    B    b. Suppose that you can choose only one of...
The following are the cash flows of two projects: Year Project A Project B 0 -290...
The following are the cash flows of two projects: Year Project A Project B 0 -290 -290 1 170 190 2 170 190 3 170 190 4 170 If the opportunity cost of capital is 11%, what is the profitability index for each project? (Do not round intermediate calculations. Round your answers to 4 decimal places.) Project Profitability Index a b
Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0...
Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0   –$ 68,000   –$ 83,000 1 48,000 47,000 2 43,000 56,000 3 38,000 59,000 The cash flows of Project A are expressed in real terms, whereas those of Project B are expressed in nominal terms. The appropriate nominal discount rate is 11 percent and the inflation rate is 5 percent. Calculate the NPV for each project. (Do not round intermediate calculations and round your answers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT