Extra Credit #1

Take the program “loan2.py” that you wrote for Homework #1 and add 3 more columns:

1. The amount of principle in each payment;
2. The amount of interest in each payment (so this and the previous should total to the payment); and
3. The total interest paid so far.

Input. This program takes the same input as the program “loan2.py”.

Output. Your program’s output should look exactly like this:

The payment schedule for a loan of $5000.00 at 6.5% interest, repaid over 1 years:
month payment principle interest total int remaining
   1   431.48    404.40    27.08     27.08   4595.60
   2   431.48    406.59    24.89     51.97   4189.01
   3   431.48    408.79    22.69     74.66   3780.22
   4   431.48    411.01    20.47     95.13   3369.21
   5   431.48    413.23    18.25    113.38   2955.98
   6   431.48    415.47    16.01    129.39   2540.51
   7   431.48    417.72    13.76    143.15   2122.79
   8   431.48    419.98    11.50    154.65   1702.81
   9   431.48    422.26     9.22    163.87   1280.55
  10   431.48    424.55     6.93    170.80    856.00
  11   431.48    426.84     4.64    175.44    429.16
  12   431.48    429.16     2.32    177.76      0.00

Submit. Name your program “loanex1.py” and submit it to the Extra Credit #1 area for this class on SmartSite.