Link to home
Start Free TrialLog in
Avatar of easycapital
easycapitalFlag for Macao

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
Avatar of byundt
byundt
Flag of United States of America image

The years on your sample workbook are all 2021. Did you mean them to be different?

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.
Avatar of easycapital

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.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry I sent you the wrong excel file. Here it is. NPV IRR PV.xlsx