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 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.