Raul.Burgueno-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 |
adrian77
