EX2019-ChallengeYourself-4-3.xlsx
Sheet1
| Hybrid Car Loan |
| Borrowed |
$ 22,000.00 |
|
| Cost of Borrowing |
| Years |
3 |
|
| Total Interest |
| APR |
2.90% |
|
| $ 898.02 |
| Payment |
$638.82 |
|
| Payment # |
Payment Date |
Payment Amount |
Interest |
Extra Paid |
Balance |
| Total Paid |
|
|
|
|
|
|
| $ 22,000.00 |
|
| 1 |
January 1, 2020 |
$ 638.82 |
$ 53.17 |
| $ 21,414.35 |
| $ 638.82 |
|
| 2 |
February 1, 2020 |
$ 638.82 |
$ 51.75 |
| $ 20,827.28 |
| $ 1,277.64 |
|
| 3 |
March 1, 2020 |
$ 638.82 |
$ 50.33 |
| $ 20,238.80 |
| $ 1,916.45 |
|
| 4 |
April 1, 2020 |
$ 638.82 |
$ 48.91 |
| $ 19,648.89 |
| $ 2,555.27 |
|
| 5 |
May 1, 2020 |
$ 638.82 |
$ 47.48 |
| $ 19,057.56 |
| $ 3,194.09 |
|
| 6 |
June 1, 2020 |
$ 638.82 |
$ 46.06 |
$ 500.00 |
$ 17,964.80 |
| $ 4,332.91 |
|
| 7 |
July 1, 2020 |
$ 638.82 |
$ 43.41 |
| $ 17,369.39 |
| $ 4,971.72 |
|
| 8 |
August 1, 2020 |
$ 638.82 |
$ 41.98 |
| $ 16,772.55 |
| $ 5,610.54 |
|
| 9 |
September 1, 2020 |
$ 638.82 |
$ 40.53 |
| $ 16,174.27 |
| $ 6,249.36 |
|
| 10 |
October 1, 2020 |
$ 638.82 |
$ 39.09 |
| $ 15,574.54 |
| $ 6,888.18 |
|
| 11 |
November 1, 2020 |
$ 638.82 |
$ 37.64 |
| $ 14,973.36 |
| $ 7,526.99 |
|
| 12 |
December 1, 2020 |
$ 638.82 |
$ 36.19 |
$ 500.00 |
$ 13,870.73 |
| $ 8,665.81 |
|
| 13 |
January 1, 2017 |
$ 638.82 |
$ 33.52 |
| $ 13,265.43 |
| $ 9,304.63 |
|
| 14 |
February 1, 2017 |
$ 638.82 |
$ 32.06 |
| $ 12,658.67 |
| $ 9,943.45 |
|
| 15 |
March 1, 2017 |
$ 638.82 |
$ 30.59 |
| $ 12,050.45 |
| $ 10,582.26 |
|
| 16 |
April 1, 2017 |
$ 638.82 |
$ 29.12 |
| $ 11,440.75 |
| $ 11,221.08 |
|
| 17 |
May 1, 2017 |
$ 638.82 |
$ 27.65 |
| $ 10,829.58 |
| $ 11,859.90 |
|
| 18 |
June 1, 2017 |
$ 638.82 |
$ 26.17 |
$ 500.00 |
$ 9,716.94 |
| $ 12,998.72 |
|
| 19 |
July 1, 2017 |
$ 638.82 |
$ 23.48 |
| $ 9,101.60 |
| $ 13,637.53 |
|
| 20 |
August 1, 2017 |
$ 638.82 |
$ 22.00 |
| $ 8,484.78 |
| $ 14,276.35 |
|
| 21 |
September 1, 2017 |
$ 638.82 |
$ 20.50 |
| $ 7,866.47 |
| $ 14,915.17 |
|
| 22 |
October 1, 2017 |
$ 638.82 |
$ 19.01 |
| $ 7,246.66 |
| $ 15,553.99 |
|
| 23 |
November 1, 2017 |
$ 638.82 |
$ 17.51 |
| $ 6,625.35 |
| $ 16,192.80 |
|
| 24 |
December 1, 2017 |
$ 638.82 |
$ 16.01 |
$ 500.00 |
$ 5,502.55 |
| $ 17,331.62 |
|
| 25 |
January 1, 2018 |
$ 638.82 |
$ 13.30 |
| $ 4,877.03 |
| $ 17,970.44 |
|
| 26 |
February 1, 2018 |
$ 638.82 |
$ 11.79 |
| $ 4,250.00 |
| $ 18,609.26 |
|
| 27 |
March 1, 2018 |
$ 638.82 |
$ 10.27 |
| $ 3,621.45 |
| $ 19,248.07 |
|
| 28 |
April 1, 2018 |
$ 638.82 |
$ 8.75 |
| $ 2,991.38 |
| $ 19,886.89 |
|
| 29 |
May 1, 2018 |
$ 638.82 |
$ 7.23 |
| $ 2,359.80 |
| $ 20,525.71 |
|
| 30 |
June 1, 2018 |
$ 638.82 |
$ 5.70 |
| $ 1,726.68 |
| $ 21,164.53 |
|
| 31 |
July 1, 2018 |
$ 638.82 |
$ 4.17 |
| $ 1,092.04 |
| $ 21,803.34 |
|
| 32 |
August 1, 2018 |
$ 638.82 |
$ 2.64 |
| $ 455.86 |
| $ 22,442.16 |
Working
| Borrowed |
$ 12,000.00 |
| Years |
3 |
| APR |
4.90% |
| Payment |
$359.11 |
|
| $359.11 |
3 |
4 |
5 |
|
| 4.90% |
$ 359.11 |
$ 275.81 |
$ 225.91 |
|
| 3.90% |
$ 353.75 |
$ 270.41 |
$ 220.46 |
|
| 2.90% |
$ 348.45 |
$ 265.08 |
$ 215.09 |
QueenQuanna
