ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Solving for discount rate in present value calculation (https://www.excelbanter.com/excel-worksheet-functions/92218-solving-discount-rate-present-value-calculation.html)

[email protected]

Solving for discount rate in present value calculation
 
Hello,

Is there a function, similar to 'rate' but for an uneven cash flow. I
have an uneven cash flow and am trying to work backwards to solve for
what discount rate would give me a particular present value? 'rate'
only works for an annuity?

thanks,
Scott



All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com