rate positively ..
i | ii | iii | iv=i*iii | v=ii*iii | vi | vii | |||
Year | Cash flow S | Cash flow L | PVIF @ 14% | Present value S | Present value L | Cumulative PV S | Cumulative PV L | ||
0 | -10000 | -25000 | 1.0000 | (10,000.00) | (25,000.00) | (10,000.00) | (25,000.00) | ||
1 | 3500 | 8000 | 0.8772 | 3,070.18 | 7,017.54 | (6,929.82) | (17,982.46) | ||
2 | 3500 | 8000 | 0.7695 | 2,693.14 | 6,155.74 | (4,236.69) | (11,826.72) | ||
3 | 3500 | 8000 | 0.6750 | 2,362.40 | 5,399.77 | (1,874.29) | (6,426.94) | ||
4 | 3500 | 8000 | 0.5921 | 2,072.28 | 4,736.64 | 197.99 | (1,690.30) | ||
5 | 3500 | 8000 | 0.5194 | 1,817.79 | 4,154.95 | 2,015.78 | 2,464.65 | ||
2,015.78 | 2,464.65 | 4,031.57 | 4,929.30 | ||||||
ans a) | NPV S | 2,015.78 | Based on NPV project L should be selected | ||||||
NPV L | 2,464.65 | ||||||||
Formula | |||||||||
ans b) | IRR S | 22.11% | Based on IRR project S should be selected | =IRR(D5:D10) | |||||
IRR L | 18.03% | =IRR(E5:E10) | |||||||
Ans c) | MIRR S | 18.26% | Based on MIRR project S should be selected | ||||||
MIRR L | 16.16% | ||||||||
Ans d) | PI S | 3.90 | year | ||||||
PI L | 4.41 | year | |||||||
Project L should be selected. | |||||||||
> > This answer provided is only partially correct. The PI calculation is incorrect. It should be: 1 + (NPV/Initial cost) for both Project S and Project L. The answer is 1.20 for Project S and 1.10 for Project L
Frank Abagnale Sun, Dec 5, 2021 5:30 PM
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...
Capital Budgeting Methods Project S has a cost of $9,000 and is expected to produce benefits (cash flows) of $2,700 per year for 5 years. Project L costs $26,000 and is expected to produce cash flows of $7,100 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 10%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $ Project L: $ Which project would be selected, assuming they...
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 the produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, IRRs, MIRRs and Pls assuming a cost of capital of 12%? Which project would be selected assuming they are mutually exclusive, using each ranking method? Which project should actually be selected?
4. Project S has a cost of $10,000 and is expected to produce cash flows of $3000 per year for 5 years. Project L has a cost of $25,000 and is expected to produce cash flows of $7400 for 5 years. Calculate the NPV and IRR of the two projects assuming a cost of capital of 12%. Which project would you select, assuming they are mutually exclusive, using each ranking method?
Project S has a cost of $10,000 and is expected to produce benefits (cash flow) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flow of $7,400 per year for 5 years. Calculate the two projects’ NPV, IRR, and MIRR, assuming a cost of capital of 12%. If these are two mutually exclusive projects, which project would be selected? Justify your answer(s). HAND WRITE WORK PLEASE :)
1. A project has an initial cost of $45,725, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 14%. What is the project's MIRR? 2. Your division is considering two investment projects, each of which requires an up-front expenditure of $17 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $ 6,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 7,000,000 What are the two...
s NPV Your division is considering two projects with the following cash flows (in millions): o 1 2 3 + Project -$35 $4 $14 $20 A Project -$15 $a $5 $1 B a. What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus...
Your division is considering two projects with the following cash flows (in millions): $4 s14 Project A Project B -$35 -$15 $20 $4 $5 a. What are the projects' NPVs assuming the WACC is 5%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places. Project A: $ million Project B:...
Your division is considering two projects with the following cash flows (in millions): Iw $4 Project A Project B -$11 - $20 $12 $5 a. What are the projects' NPVs assuming the WACC is 5%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places. Project A: $ million Project B:...
Your division is considering two projects with the following cash flows (in millions): $5 $12 Project A Project B -$20 -$13 a. What are the projects' NPVs assuming the WACC is 5%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places. Project A: $ million Project B: $ million What...
NPV Your division is considering two projects with the following cash flows millions): Project A 19 Project B 17 a. what are the wojects' Nns assuming the wACC is 5%? Round your answer to two decimal places Do not round your intermediate oalculatio s Enter your ans w $8 $11 $15 $8 s6 maons. .。 example, an answer of $10,50,000 should be entered as 10.5s. Negative value should be indicated by a minus sign Project A Project 8s what are...
> This answer provided is only partially correct. The PI calculation is incorrect. It should be: 1 + (NPV/Initial cost) for both Project S and Project L. The answer is 1.20 for Project S and 1.10 for Project L
Frank Abagnale Sun, Dec 5, 2021 5:30 PM