Is there a formula to determine the rate at which the NPV would equal 0 of a stream of payments?
已回覆I am trying to back into a discount rate that would set a the NPV of a stream = 0. Has anyone had experience with this?
0
-
IRR() should do that for you. 0
Is there an equivalent to the "Goal Seek" function under the "What if Analysis" Data function in Excel for forecasting in Wdesk?0
Hi Phyllis,
At this time there are not any 'What-If Analysis' functions, such as 'Goal Seek' built into Wdesk Spreadsheets. You could, of course, build out such a calculation within the Spreadsheet itself, but there's nothing pre-built for Spreadsheets that matches these functions in Excel.
Our Product Team has looked into this in the past and are certainly be open to considering it further as more functions are added to Spreadsheets. I've shared your interest in this feature with the team and will keep you apprised with any new info. Thanks for your feedback and let me know if I can answer any other questions you might have. Cheers!0請登入寫評論。
評論
3 條評論