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 ...
Get Excel Workbook For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
