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
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Sorry I sent you the wrong excel file. Here it is. NPV IRR PV.xlsx
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.