easycapital
asked on
How to calculate NPV, IRR, PV
Please advise how to apply excel NPV, IRR, PV in excel to the following table.NPV IRR PV.xlsx
ASKER
Hi Byundt,
Yes - it is for different years.
Could you please support NPV10 v2.xlsxthe corresponding sign and application of the Excel function?
Thank you.
Yes - it is for different years.
Could you please support NPV10 v2.xlsxthe corresponding sign and application of the Excel function?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry I sent you the wrong excel file. Here it is. NPV IRR PV.xlsx
In any event, the way to solve the problem is to build a table showing the cash flows on a month by month basis for the entire duration of the opportunity. NPV, IRR and PV require equal time intervals. Make sure that the initial investment has a different sign than the potential returns. And because you are tabulating the cash flows on a monthly basis, use 10%/12 as the interest rate.