Chapter 16. Functions for financial analysis

WITH THE financial functions provided with Microsoft Excel, 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 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.