SOLUTION: Marie who is a business woman seeks to invest her money in any of two projects X and Y whose estimated cash flows are as follows: Project X will yield uniform cash flows of Ksh. 20

Question 1135985: Marie who is a business woman seeks to invest her money in any of two projects X and Y whose estimated cash flows are as follows: Project X will yield uniform cash flows of Ksh. 20,000 Per year for four years. Project Y cash flows are Ksh.30,000 in year 1, Ksh.22, 000 in year 2, Ksh.18,000 in year 3 and Ksh.15,000 in the fourth year. Advice the business woman on which project to invest in on using the net present value (NPV).
Answer by Theo(13342) (Show Source): You can put this solution on YOUR website!
if you're doing a net present value analysis, you need to know what the required rate of return is.

that wasn't mentioned.

without knowing that, you can probably make an estimation at different rates of return to see where the break even point would be.

you can take the npv of plan x and the npv of plan y and determine which one is greater by comparing them.

you can also take the npv of (plan x minus plan y) and look for when the npv becomes positive.

a positive npv in a plan x minus plan y analysis means that the npv of plan x is greater than the npv of plan y.

a negative npv in a plan x minus plan y analysis means that the npv of plan x is less than the npv of plan y.

the woman is more than likely looking for a rate of return that is positive.

i therefore looked at different rates of return greater than or equal to 0.

in all cases, plan y gave a greater npv than plan x.

as the rate of return requirement got higher, the difference between plan x and plan y became greater in favor of plan x.

this indicates that there is no positive rate of return requirement where plan x will have a higher npv than plan y.

since plan y has a greater npv at all rates of return greater than or equal to 0, the woman is advised to go with plan y.

here's my excel spreadsheet analysis.

$$$

RELATED QUESTIONS
Below are the estimated cash flows for two projects: S and L. The WACC is 10%. Time (answered by ikleyn)

A woman has $27,000. Part of this money is invested for 1 year in a certificate of... (answered by ewatrrr)

Any help with this problem would be greatly appreciated. (Risk-adjusted discount rates (answered by help314)

marie is going to celebrate her 18th birthday with a big party which will be held in a... (answered by checkley71)

23. [Cash flows] Using the cash flow data in #22, assume that you require a return of at (answered by lynnlo)

Ms. Edwards and three other students decided to invest part of their college fund in to... (answered by bucky)

Linda williams has just begun a nursery business and seeks your advice.She has limited... (answered by josgarithmetic)

Excel spreadsheet The Acme Company has its European subsidiary based in the Euro zone.... (answered by tklashawnda)

The sum of N1200 is invested in three project X,Y,Z at the ratio of 4,5,6 respectively.... (answered by Theo)