Chapter 16. Functions for Financial Analysis

Calculating Investments

Calculating Depreciation

Analyzing Securities

Using the Euro Currency Tools Add-In

WITH the financial functions provided with Microsoft Excel 2010, you can perform common business calculations, such as net present value and future value, without building long and complex formulas. These functions are the heart of spreadsheets—the word spreadsheet itself refers to the seemingly antiquated system of using special grid paper to track financial information. Functions have taken the place of the old 10-key calculator sequences (algorithms) used by accounting professionals before computers revolutionized the discipline.

The financial functions built into Excel fall into three major categories: ...

Get Microsoft® Excel® 2010 Inside Out 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.