This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

The time value of money (TVM) is a core financial principle also known as the present discounted value (PDV). It states that money today is worth more than the same amount in the future.

Without considering the time value of money, it is difficult or impossible to determine which project is worth considering. Also, the payback period does not assess the riskiness of the project.

This ‘doubling of investment’ is an illusion as people fail to factor in the time value of money – the concept that a certain sum of money has greater value now than it will in the future ...

Learn the importance of the time value of money (TVM) & how to calculate it. See examples showing how TVM builds wealth faster than cash sitting in the bank.

Valeria Martinez, Time Value of Money Made Simple: A Graphic Teaching Method, Journal of Financial Education, Vol. 39, No. 1/2 (SPRING/SUMMER 2013), pp. 96-117 ...

Excel is powerful, but it’s also unforgiving. A single oversight can spiral into a major problem, especially when money or sensitive data is involved. And you know what they say, prevention is ...