Chapter 25. Using Financial Functions
In this chapter
Examples of Common Household Loan and Investment Functions 592
Examples of Functions for Financial Professionals 598
Examples of Depreciation Functions 603
Functions for Investment Analysis 609
Examples of Functions for Bond Investors 615
Examples of Miscellaneous Financial Functions 627
While the bulk of Excel’s financial functions are for professional financiers and investors, there are a few functions that are useful for anyone planning to use a loan to purchase a car or house. The examples in this chapter represent a small subset of the calculations possible with Excel’s financial functions.
Table 25.1 provides an alphabetical list of all of Excel 2007’s financial functions. Detailed examples ...
Get Special Edition Using Microsoft® Office Excel® 2007 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.
