Excel offers a few simple formulas for determining the value of projects over time. In this article, I will cover PV and FV. For most financial applications, some subset of the formulas listed above will be more than enough to determine the value or rate of return of a particular project. In short, the PV and FV formulas save time and effort when using spreadsheets that require many calculations for present and future values.
Comments are closed.