Simple Interest Amortization Schedule - Excel by Richard_Cataman

VIEWS: 147 PAGES: 1

More Info
									Simple Interest Loan Amortization Schedule
   Principal Amount:        $124,250           Yearly Payment
       Interest Rate:          3.0%                  $12,596.48
      Term in Years:              10

           Beginning                                 Remaining
 Year      Principal       Interest     Principal     Principal
            Balance          Paid         Paid        Amount

  1        124,250.00         310.63     12,285.86   111,964.14
  2        111,964.14         279.91     12,316.57    99,647.57
  3         99,647.57         249.12     12,347.36    87,300.20
  4         87,300.20         218.25     12,378.23    74,921.97
  5         74,921.97         187.30     12,409.18    62,512.79
  6         62,512.79         156.28     12,440.20    50,072.59
  7         50,072.59         125.18     12,471.30    37,601.29
  8         37,601.29          94.00     12,502.48    25,098.81
  9         25,098.81          62.75     12,533.74    12,565.07
 10         12,565.07          31.41     12,565.07        (0.00)
 11             (0.00)          0.00          0.00         0.00
 12              0.00           0.00          0.00         0.00
 13              0.00           0.00          0.00         0.00
 14              0.00           0.00          0.00         0.00
 15              0.00           0.00          0.00         0.00
 16              0.00           0.00          0.00         0.00
 17              0.00           0.00          0.00         0.00
 18              0.00           0.00          0.00         0.00
 19              0.00           0.00          0.00         0.00
 20              0.00           0.00          0.00         0.00
 21              0.00           0.00          0.00         0.00
 22              0.00           0.00          0.00         0.00
 23              0.00           0.00          0.00         0.00
 24              0.00           0.00          0.00         0.00
 25              0.00           0.00          0.00         0.00
 26              0.00           0.00          0.00         0.00
 27              0.00           0.00          0.00         0.00
 28              0.00           0.00          0.00         0.00
 29              0.00           0.00          0.00         0.00
 30              0.00           0.00          0.00         0.00

                Totals:    $1,714.84 $124,250.00

 Total Principal & Interest Paid:      $125,964.84

								
To top