Amortization Table - Breaking Down Your Payment - No video

This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references.

Initial Balance

$ 10,000.00

Annual Interest Rate

10%

$C$11 4 0 30000 1 10 26

Years

10

Annual Payemnt

$1,627.45

Summary loan data for year

4

Balance at start of year

$ 10,000.00

Balance at end of year

=

Interest paid during the year

Principle paid during the year