Ten Ways to Analyze Financial Data
IN THIS CHAPTER
Calculating the future value and present value of an investment
Determining a loan’s payments, principal, and interest
Calculating the required interest rate for a loan
Figuring out the internal rate of return for an investment
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 ...