17. Building Loan Formulas
IN THIS CHAPTER
Understanding the Time Value of Money
Building a Loan Amortization Schedule
Calculating the Term of the Loan
Calculating the Interest Rate Required for a Loan
Calculating How Much You Can Borrow
Excel is loaded with financial features that give you powerful tools for building models that manage both business and personal finances. You can use these functions to calculate such things as the monthly payment on a loan, the future value of an annuity, the internal rate of return of an investment, or the yearly depreciation of an asset. The final four chapters of this book cover these and many other uses for Excel’s financial formulas.
This chapter begins with formulas ...
Get Formulas and Functions with Microsoft® Excel 2003 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.
