Amortization Schedule worksheet

1. Monthly payment: $1,498.88

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=30\times 12$$=360$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{6\%}}{12}$$=0.005$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$250,000.00}\times 0.005}{1-{\left(1+0.005\right)}^{\mathrm{-360}}}$$=\mathrm{\$1,498.88}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$1,498.88}-\mathrm{\$250,000.00}\times 0.005$$=\mathrm{\$248.88}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$539,595.47}-\mathrm{\$250,000.00}$$=\mathrm{\$289,595.47}$

2. Monthly payment: $1,502.51

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=15\times 12$$=180$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{5\%}}{12}$$=0.00416667$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$190,000.00}\times 0.00416667}{1-{\left(1+0.00416667\right)}^{\mathrm{-180}}}$$=\mathrm{\$1,502.51}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$1,502.51}-\mathrm{\$190,000.00}\times 0.00416667$$=\mathrm{\$710.84}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$270,451.42}-\mathrm{\$190,000.00}$$=\mathrm{\$80,451.42}$

3. Monthly payment: $3,108.57

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=10\times 12$$=120$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{6\%}}{12}$$=0.005$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$280,000.00}\times 0.005}{1-{\left(1+0.005\right)}^{\mathrm{-120}}}$$=\mathrm{\$3,108.57}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$3,108.57}-\mathrm{\$280,000.00}\times 0.005$$=\mathrm{\$1,708.57}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$373,028.89}-\mathrm{\$280,000.00}$$=\mathrm{\$93,028.89}$

4. Monthly payment: $3,181.97

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=10\times 12$$=120$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{5\%}}{12}$$=0.00416667$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$300,000.00}\times 0.00416667}{1-{\left(1+0.00416667\right)}^{\mathrm{-120}}}$$=\mathrm{\$3,181.97}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$3,181.97}-\mathrm{\$300,000.00}\times 0.00416667$$=\mathrm{\$1,931.97}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$381,835.85}-\mathrm{\$300,000.00}$$=\mathrm{\$81,835.85}$

5. Monthly payment: $1,438.13

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=15\times 12$$=180$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{7\%}}{12}$$=0.00583333$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$160,000.00}\times 0.00583333}{1-{\left(1+0.00583333\right)}^{\mathrm{-180}}}$$=\mathrm{\$1,438.13}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$1,438.13}-\mathrm{\$160,000.00}\times 0.00583333$$=\mathrm{\$504.79}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$258,862.54}-\mathrm{\$160,000.00}$$=\mathrm{\$98,862.54}$

6. Monthly payment: $2,328.56

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=30\times 12$$=360$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{7\%}}{12}$$=0.00583333$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$350,000.00}\times 0.00583333}{1-{\left(1+0.00583333\right)}^{\mathrm{-360}}}$$=\mathrm{\$2,328.56}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$2,328.56}-\mathrm{\$350,000.00}\times 0.00583333$$=\mathrm{\$286.89}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$838,281.14}-\mathrm{\$350,000.00}$$=\mathrm{\$488,281.14}$

7. Monthly payment: $3,715.47

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=10\times 12$$=120$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{7\%}}{12}$$=0.00583333$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$320,000.00}\times 0.00583333}{1-{\left(1+0.00583333\right)}^{\mathrm{-120}}}$$=\mathrm{\$3,715.47}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$3,715.47}-\mathrm{\$320,000.00}\times 0.00583333$$=\mathrm{\$1,848.80}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$445,856.56}-\mathrm{\$320,000.00}$$=\mathrm{\$125,856.56}$

8. Monthly payment: $2,025.26

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=15\times 12$$=180$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{6\%}}{12}$$=0.005$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$240,000.00}\times 0.005}{1-{\left(1+0.005\right)}^{\mathrm{-180}}}$$=\mathrm{\$2,025.26}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$2,025.26}-\mathrm{\$240,000.00}\times 0.005$$=\mathrm{\$825.26}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$364,546.15}-\mathrm{\$240,000.00}$$=\mathrm{\$124,546.15}$

9. Monthly payment: $2,386.47

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=10\times 12$$=120$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{5\%}}{12}$$=0.00416667$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$225,000.00}\times 0.00416667}{1-{\left(1+0.00416667\right)}^{\mathrm{-120}}}$$=\mathrm{\$2,386.47}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$2,386.47}-\mathrm{\$225,000.00}\times 0.00416667$$=\mathrm{\$1,448.97}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$286,376.89}-\mathrm{\$225,000.00}$$=\mathrm{\$61,376.89}$

10. Monthly payment: $1,438.92

1. Count the monthly payments (n): years × 12, since you pay once a month

   $n$$=30\times 12$$=360$

2. Turn the yearly rate into a monthly rate (i) by dividing by 12, because interest is charged every month

   $i$$=\frac{\mathrm{6\%}}{12}$$=0.005$

3. Find the monthly payment. A standard formula gives the one amount that pays off the loan, with interest, in n months

   $\frac{\mathrm{\$240,000.00}\times 0.005}{1-{\left(1+0.005\right)}^{\mathrm{-360}}}$$=\mathrm{\$1,438.92}$

4. Split the first payment: interest is what you owe times the monthly rate, and the rest pays down the loan

   $\mathrm{\$1,438.92}-\mathrm{\$240,000.00}\times 0.005$$=\mathrm{\$238.92}$

5. Each later row does the same on the smaller balance. Total interest is everything you pay minus what you borrowed

   $\mathrm{\$518,011.65}-\mathrm{\$240,000.00}$$=\mathrm{\$278,011.65}$