Chapter 15

Ten Ways to Analyze Financial Data


Bullet Calculating the future value and present value of an investment

Bullet Determining a loan’s payments, principal, and interest

Bullet Calculating the required interest rate for a loan

Bullet Figuring out the internal rate of return for an investment

Bullet Learning various ways to calculate depreciation

All kinds of people use Excel, including scientists, engineers, mathematicians, statisticians, and pollsters. But if you could somehow survey all the world’s Excel users, I bet the typical user would have something to do with the financial industry. Whether they’re accountants or adjusters, bankers or borrowers, or money managers or money lenders, financial types rely on Excel every day to analyze budgets, loans, investments, and other monetary minutiae.

But it’s not just the financial pros who count on Excel (sometimes literally). Financial amateurs can also use Excel to analyze mortgages, car payments, college funds, savings accounts, and other workaday ...

Get Excel Data Analysis For Dummies, 4th Edition 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.