Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 18. Building Loan Formulas

IN THIS CHAPTER

• Understanding the Time Value of Money 449

• Calculating the Loan Payment 450

• Building a Loan Amortization Schedule 456

• Calculating the Term of the Loan 459

• Calculating the Interest Rate Required for a Loan 461

• Calculating How Much You Can Borrow 462

• Working with Morrtgages 463

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 three chapters of this book cover these and many other uses for Excel’s financial ...