10. Financial Functions
Calculating cosines and analyzing statistical trends may seem like a great way to tap Excel's brainpower. But what if you want help tracking the movement of small pieces of green paper from one bank account to another? Fortunately, Excel's no slouch when it comes to dealing with money. In fact, it comes with a slew of financial functions that can help you figure out the bottom line like a pro.
Microsoft designed the majority of Excel's financial functions to help you determine how numbers change over time. You can use them to track soaring assets or mounting debts . In this chapter, you'll start by learning the basic concepts, such as present value and payment period, which Excel bases all of its financial functions on. Afterwards, you'll take a close look at some of the most useful financial functions, complete with examples that answer common questions about mortgages, loans, and investments.