Amortization

$2,388.00 2.20% $225.00 Jan-05 Monthly Periodic Rate: $1,000.00 Total Monthly Payment: $141.00 Balance New Pay # Month After Payment Interest Balance 1 Jan-05 $1,022.00 $4.38 $1,026.38 2 Feb-05 $660.38 $1.88 $662.26 3 Mar-05 $296.26 $1.21 $297.47 4 Apr-05 $0.00 Total Interest Paid: Total Paid (incl Int.): Payoff Month: Current Month (e.g., Aug-02): Total Balance Owed: Annual Periodic Rate (APR): Monthly Scheduled Payment: One-Time Add'l Payment, If Any: Add'l Monthly Payments, If Any:$7.47$7.47 $2,395.47 April-05 0.1833% $366.00Step 1 Step 2 Step 3 Step 4 Step 5 Enter any one-time additional payment (such as a down payment). Step 6 Enter any additional monthly payment (above the amount in Step 3). Once this info is typed in, the spreadsheet will compute the total amount of interest paid over the remainder of the loan (cell I2), the total dollars paid over the remainder of the loan (cell I3), and the month & year in which the loan will be paid in full (cell I4). Insert total balance owed on the credit card or loan. (Cell E2) Insert APR (annual) interest rate. (Cell E3) Insert the amount of monthly payment you wish to use. (Cell E5) Enter the current month, using the following format: 07-02 (for July 2002)