Question

In: Finance

Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...

Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years.

Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent.

Project S: $  

Project L: $  

Which project would be selected, assuming they are mutually exclusive?

Based on the NPV values, -Select-Project SProject L would be selected.

Calculate the two projects' IRRs. Do not round intermediate calculations. Round your answers to two decimal places.

Project S: %

Project L: %

Which project would be selected, assuming they are mutually exclusive?

Based on the IRR values, -Select-Project SProject L would be selected.

Calculate the two projects' MIRRs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to two decimal places.

Project S: %

Project L: %

Which project would be selected, assuming they are mutually exclusive?

Based on the MIRR values, -Select-Project SProject L would be selected.

Calculate the two projects' PIs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to three decimal places.

Project S:

Project L:

Which project would be selected, assuming they are mutually exclusive?

Based on the PI values, -Select-Project SProject L would be selected.

Which project should actually be selected?

-Select-Project SProject L should actually be selected.

Solutions

Expert Solution

As we know NPV is the sum of present value of cash inflow(Positive) and out flow (Negative).

r = Cost of Capital = 12%

n = no years

Project S Present Value of Project S
Present Value = Cash Flow/(1+r)^n
Project L Present Value of Project L
Year 0 n=0 -10,000 -10000 -25000 -25000

Year 1

n=1

3000 3000/(1+0.12)^1 = 2,678.57 7400 7400/(1+0.12)^1 = 6,607.14

Year 2

n=2

3000 3000/(1+0.12)^2 = 2,391.58 7400 7400/(1+0.12)^2 = 5,899.23

Year 3

n=3

3000 3000/(1+0.12)^3 = 2,135.34 7400 7400/(1+0.12)^3 = 5,267.17

Year 4

n=4

3000 3000/(1+0.12)^4 = 1,906.55 7400 7400/(1+0.12)^4 = 4,702.83

Year 5

n = 5

3000 3000/(1+0.12)^5 = 1,702.28 7400 7400/(1+0.12)^5= 4,198.96
NPV Sum of all the Present Values 814.32 1,675.33

As NPV of Project L is higher we will choose Project L

2. IRR As we know IRR is found by keeping NPV zero and finding the rate at which the NPV is zero.

IRR cannot be found directly but we need to estimate it by trail and error.

The best way is to consider the Cash flows occuring in future are constant thus formula for present value of annuity can be applied and initial cost is available to us thus we try to put i such that we get the NPV zero.(You can also use annuity table to estimate it)

For Project s

C = 3000 (Net cash flow every year)

n = 5

i(IRR) = x(unknown)

PV annuity =

NPV = - initial cash flow

0 = C* X - 10000 (Here X = )

10000 = 3000 * X

X = 3.3333

Now from table we know that the value of i at which the PV of annuity is 3.333 lies between 15% and 16%

Now with trail and error in X we get value of i = 15.238% So our IRR = 15.238%

Similarly for Project L

C = 7400 (Net cash flow every year)

n = 5

i(IRR) = x(unknown)

NPV = - initial cash flow

0 = C* X - 25000 (Here X = )

X = 25000/7400

X = 3.3783

From table we get a value between 14-15%

After trail and error we get i = 14.672%

Thus by IRR method we choose Project S over Project L


Related Solutions

Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they are mutually exclusive?...
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $4,000 per year for 5 years. Project L costs $21,000 and is expected to produce cash flows of $8,000 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, PIs, and Pay Back Period assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' PIs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to three decimal places. Project S:   Project L:  
8. Project R has a cost of $ 10,000 and in expected to produce cash flows...
8. Project R has a cost of $ 10,000 and in expected to produce cash flows per year of $ 4,000 for 3 years. Project S has a cost of $20,000 and in expected to produce cash flows of $ 7,000 per year for 4 years. Calculate the 2 projects' NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 11%. Which project should be selected ?
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,500 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $8,000 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 14%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,300 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Round your answers to the nearest cent. Project S $ Project L $ Which project would be selected, assuming they are mutually exclusive? Calculate the...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,300 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Round your answers to the nearest cent. Project S $     Project L $     Which project would be selected, assuming they are mutually exclusive? -Select-Project SProject...
10-10. Project A has a cost of $22,000 and is expected to produce benefits (cash flows)...
10-10. Project A has a cost of $22,000 and is expected to produce benefits (cash flows) of $7,000 per year for 5 years. Project B costs $70,000 and is expected to produce cash flows of $20,000 per year for 5 years. Calculate the two projects' NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 10%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
If a project has a cost of $10,000, expected net cash flows of $1500 a year...
If a project has a cost of $10,000, expected net cash flows of $1500 a year for 12 years and you use a discount rate of 6%, what is the following: Payback period (no application of discount rate) Payback period (using discount rate) NPV IRR Should the project be accepted? If another project has a cost of $10,000 and has expected life of 8 years and it will generate $3000 a year should you accept the project if your boss...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT