|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Is there a formula to determine the rate at which the NPV would equal 0 of a stream of payments?

Répondu
Demande de démonstration
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

Commentaires

3 commentaires

Date Votes
  • Ben Andrews
    IRR() should do that for you.
    0
  • Phyllis Collins

    Is there an equivalent to the "Goal Seek" function under the "What if Analysis" Data function in Excel for forecasting in Wdesk?
    0
  • Mike Davis
    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

Vous devez vous connecter pour laisser un commentaire.