Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
2/23/2011 1:06:53 PM EDT
I have a problem I am doing, and I need to see if I am doing this correct.

Question is as follows;

A four year financial project is forecast to have net cash inflows of $20,000, $25,000, $30, 000, and $35,000 in the next four years. It will cost $75,000 to implement the project payable at the beginning of the project. The required rate of return is 0.2, conduct a discounted cash flow calculation to determine the NPV.

I am coming up with $6,732

Does this sound correct?

Thanks

Aviator
2/23/2011 2:11:10 PM EDT
[#1]
Your instincts are right.  That sounds way too low.

ETA: Oh, wait, you're doing NET cash flow, 75K out, and 85K back in over a few years.  In that case, your number could be close.  Just remember to get your Beginning Of Year and End Of Year calcs sorted out.  The down payment is at the beginning of the year; all the others are presumed to be at the end of the year.
What tool are you using?  Pocket calculator?  HP12?  Excel?
2/23/2011 3:15:53 PM EDT
[#2]
Excel

Aviator
2/23/2011 3:32:26 PM EDT
[#3]
NPV = -75000+(20000/1.20)+(25000/1.20^2)+(30000/1.20^3)+(35000/1.20^4) = -6732.25
2/23/2011 3:32:45 PM EDT
[#4]
I got the present value of cash inflows to be 104,241. So that would give you 29,241.





ETA: Doh, 0.2, not 0.02



ETA2: I got $-6,732



 
2/23/2011 3:37:34 PM EDT
[#5]
Quoted:
I have a problem I am doing, and I need to see if I am doing this correct.

Question is as follows;

A four year financial project is forecast to have net cash inflows of $20,000, $25,000, $30, 000, and $35,000 in the next four years. It will cost $75,000 to implement the project payable at the beginning of the project. The required rate of return is 0.2, conduct a discounted cash flow calculation to determine the NPV.

I am coming up with $6,732

Does this sound correct?

Thanks



Aviator


Actually, the answer is negative $6,732.65

Remember it's Net, so it is the value of the discouted stream less the initial investment.

2/23/2011 4:32:21 PM EDT
[#6]
Yep, my bad, I had a negative number.

Thanks!

Aviator