Chapter 15

Ten Ways to Analyze Financial Data

IN THIS CHAPTER

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 O’Reilly online learning.

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