O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Future Value, Present Value, and Net Present Value

This analysis so far has not taken into account the time value of money. One dollar received today is worth more than one dollar received five years from today. But how much more? That would depend on how much the recipient thinks he could earn on that dollar: in other words, what's an adequate rate of return?

Calculating Future Value

A dollar received today and invested in a financial instrument that yields 10% would be worth $1.10 after one year. $1.10 is the future value of your dollar given the time period for investment (one year) and the rate of return (10%). After five years, the future value of your dollar would be $1.61. This value is

or

Calculating Present Value

Conversely, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required