Computer science excel hw

profilehideinbush
CS201-PA4-EX2016-ChallengeYourself-4-3.xlsx
Home>Computer Science homework help>Computer science excel hw

Sheet1

Truck Loan
Borrowed $ 15,000.00 Cost of Borrowing
Years 3 Total Interest
APR 4.90% $ 997.61
Payment $448.89
Payment # Payment Date Payment Amount Interest Extra Paid Balance Total Paid
$ 15,000.00
1 January 1, 2016 $ 448.89 $ 61.25 $ 14,612.36 $ 448.89
2 February 1, 2016 $ 448.89 $ 59.67 $ 14,223.14 $ 897.78
3 March 1, 2016 $ 448.89 $ 58.08 $ 13,832.32 $ 1,346.67
4 April 1, 2016 $ 448.89 $ 56.48 $ 13,439.92 $ 1,795.56
5 May 1, 2016 $ 448.89 $ 54.88 $ 13,045.91 $ 2,244.45
6 June 1, 2016 $ 448.89 $ 53.27 $ 500.00 $ 12,150.29 $ 3,193.34
7 July 1, 2016 $ 448.89 $ 49.61 $ 11,751.01 $ 3,642.23
8 August 1, 2016 $ 448.89 $ 47.98 $ 11,350.10 $ 4,091.12
9 September 1, 2016 $ 448.89 $ 46.35 $ 10,947.56 $ 4,540.01
10 October 1, 2016 $ 448.89 $ 44.70 $ 10,543.37 $ 4,988.90
11 November 1, 2016 $ 448.89 $ 43.05 $ 10,137.53 $ 5,437.79
12 December 1, 2016 $ 448.89 $ 41.39 $ 500.00 $ 9,230.04 $ 6,386.68
13 January 1, 2017 $ 448.89 $ 37.69 $ 8,818.84 $ 6,835.57
14 February 1, 2017 $ 448.89 $ 36.01 $ 8,405.96 $ 7,284.46
15 March 1, 2017 $ 448.89 $ 34.32 $ 7,991.39 $ 7,733.35
16 April 1, 2017 $ 448.89 $ 32.63 $ 7,575.13 $ 8,182.24
17 May 1, 2017 $ 448.89 $ 30.93 $ 7,157.17 $ 8,631.14
18 June 1, 2017 $ 448.89 $ 29.23 $ 500.00 $ 6,237.51 $ 9,580.03
19 July 1, 2017 $ 448.89 $ 25.47 $ 5,814.09 $ 10,028.92
20 August 1, 2017 $ 448.89 $ 23.74 $ 5,388.94 $ 10,477.81
21 September 1, 2017 $ 448.89 $ 22.00 $ 4,962.05 $ 10,926.70
22 October 1, 2017 $ 448.89 $ 20.26 $ 4,533.42 $ 11,375.59
23 November 1, 2017 $ 448.89 $ 18.51 $ 4,103.04 $ 11,824.48
24 December 1, 2017 $ 448.89 $ 16.75 $ 500.00 $ 3,170.91 $ 12,773.37
25 January 1, 2018 $ 448.89 $ 12.95 $ 2,734.97 $ 13,222.26
26 February 1, 2018 $ 448.89 $ 11.17 $ 2,297.24 $ 13,671.15
27 March 1, 2018 $ 448.89 $ 9.38 $ 1,857.73 $ 14,120.04
28 April 1, 2018 $ 448.89 $ 7.59 $ 1,416.43 $ 14,568.93
29 May 1, 2018 $ 448.89 $ 5.78 $ 973.32 $ 15,017.82
30 June 1, 2018 $ 448.89 $ 3.97 $ 528.41 $ 15,466.71
31 July 1, 2018 $ 448.89 $ 2.16 $ 81.67 $ 15,915.60
32 August 1, 2018 $ 82.01 $ 0.33 $ 0.00 $ 15,997.61

Temp

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