O'Reilly logo

Excel® 2010 Workbook for Dummies® by Greg Harvey

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

Chapter 9. Financial Formulas and Functions

In This Chapter

  • Understanding how the basic financial functions work

  • Using the basic investment accumulation, discounting, and amortization functions

  • Using the program's depreciation functions

As the old song says, "Money makes the world go round." To that end, Excel supplies you with plenty of built-in functions for getting the latest spin on how much you're making and spending. In this chapter, you get the chance to practice using some of the basic investment, depreciation, and currency conversion functions that make up a part of the program's financial group.

Working with Financial Functions

Excel offers a fair number of sophisticated financial functions for determining such things as the present, future, or net present value of an investment; the payment, number of periods, or the principal or interest part of a payment on an amortized loan; the rate of return on an investment; and the depreciation of your favorite assets.

The key to using many of Excel's financial functions is in understanding the terminology used by their arguments. Many of the most common financial functions such as PV (Present Value), NPV (Net Present Value), FV (Future Value), and PMT (Payment) take similar arguments:

  • Pv is the present value that is the principal amount of the annuity.

  • Fv is the future value that represents the principal plus interest on the annuity.

  • Pmt is the payment made each period in the annuity. Normally, the payment is set over the life of the annuity ...

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