John said:
Sedan,
It sounds like you really need to use Excel. Project is a scheduling
application, not a financial application even though it can show a
myriad of cost related information. There are no built in functions for
NPV or ROI in Project so if you want to show it, you will need to use
one of the spare fields and customize it with the appropriate formula.
Another option is to export whatever Project data you need for the
formulas into Excel. I know Excel has an NPV function but I'm not so
sure about ROI.
Hope this helps.
John
John is right. You can calculate NPV in project, but it would require coding
the entire function from scratch in VBA. Further, you would have to find a
way to model things like revenue and depreciation which Project does not
deal with by default. I'd just use excel. The financial functions are
already predefined there.
With a little work, you can have both a schedule and financial calcs in
excel. See my excel schedule page for a starting point.
http://masamiki.com/project/Excel.htm
You could use that to model your tasks and then do some work to add costs to
it. Summing the columns would give you your monthly cash flows.
-Jack
