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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
