O'Reilly logo

Formulas and Functions with Microsoft® Excel 2003 by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

17. Building Loan Formulas

IN THIS CHAPTER

Understanding the Time Value of Money

Calculating the Loan Payment

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

Case Study

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required