Chapter 14

Building loan formulas

In this chapter, you will:

  • Understand the concept of the time value of money

  • Calculate loan payments, interest costs, and cumulative principal and interest payments

  • Building fixed-rate and dynamic loan amortization schedules

  • Determine the term of a loan given the interest rate, the regular payment, and the loan principal amount

  • Calculate the interest rate required for a loan given the loan term, the loan payment, and the loan principal

  • Figure out how much you can borrow given the interest rate, loan payment, and loan term

Excel is loaded with financial features that give you powerful tools for building worksheets that manage both business and personal finances. You can use these functions to calculate such ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

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