Create An Amortization Schedule

An amortization schedule, in general, is a record of loanapplied towards the principal and the balance owed to
or mortgage payments. This record includes thethe Lender. This is done immediately after the
payment number, date, amount, breakdown of principalborrower gives the lender the $350 payment and
and interest and the remaining balance owed after thebalanced owed is $9,750.00.
payment. Here is an example on how an amortizationThe interest for the borrowed money is calculated and
schedule is calculated.taken first whenever any payment is made. The
Let's say a person has been loaned $10,000 from aremaining amount goes towards reducing the principal.
lender. The annual interest rate (AIR) is 12% with aA negative amortization schedule is produced and the
payment of $350 each month to the lender. Twelveprincipal owing starts to increase if the payment
percent per year is one percent per month. The lenderdoesn't to cover the interest. The interest shortfall is
gives him the $10,000 on June 15th - the advance date;added to the balance.
and one month later (July 15th), the first monthlyThe next monthly payment is due on August 15th, the
payment is due.balance owed is $9,750 and the interest owed for the
The lender multiplies the monthly interest factor timesuse of the money for the second month is 0.01 x 9,750
the outstanding balance and the interest owed for the= 97.50. $252.50, hence, is applied against the loan or
first month is $100.00 (.12 x 10,000/12), which is done atmortgage. The balance owing immediately after that
the end of the month. $250 of the monthly payment issecond payment is $9,497.50.