I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

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

Con risposta
Richiedi una demo
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

Commenti

3 commenti

Data Voti
  • 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
    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

Accedi per aggiungere un commento.