O'Reilly logo

Excel 2010: The Missing Manual by Matthew MacDonald

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

Financial Functions

Excel includes several dozen financial formulas, but non-accountants use only a handful of these regularly. These all-purpose functions, described in the following sections, are remarkably flexible. You can use them to make projections about how investments or loans will change over time, or to answer hypothetical questions about investments or loans. Perhaps you want to determine the interest rate or length of time you need to reach an investment goal or pay off a loan.

FV(): Future Value

The FV() function lets you calculate the future value of an investment, assuming a fixed interest rate. Perhaps the FV() function's most convenient feature is that it lets you factor in regular payments, which makes it perfect for calculating how money's accumulating in a retirement or savings account.

To understand how FV() works, it helps to start out by considering what life would be like without FV(). Imagine that you've invested $10,000 that's earning a fixed interest rate of 5 percent over one year. You want to know how much your investment's going to be worth at the end of the year. You can tackle this problem quite easily with the following formula:

=10000*105%

This calculation provides you with the future value—that is, the initial 100 percent of the principal plus an additional 5 percent interest.

It's just as easy to determine what happens if you keep your money invested for two years, reinvesting the 5 percent interest payment for an additional year. Here's the formula ...

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