Ian Martinez Debt Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJK
1
HTMCV Stewarsdhip Project - Credit Card Spreadsheet
2
The purpose of this form is to display a student's credit card activity.
3
4
Students may borrow money with a credit card for:rent, taxes, life cycle
5
NOTES:Interest is compounded weekly to simulate the effects of compound interest.luxury chair or other government items
6
Students who want to borrow for Koteach University or a mortgage, will not be able to use a credit card.buying something from a business
7
The intereset rate will be 16.1% (The national rate as of August 2016, according to Bankrate.com) and will stay constant throughout the year.
8
9
Date
Week
Last week's balance+Any new
debt
-Any
payments
x1 +
interest rate
=Balance
10
ExampleA$0.00+$800.00-0.00x1.161=$928.80
11
ExampleB$928.80+$0.00-350.00x1.161=$671.99
12
ExampleC$671.99+$0.00-0.00x1.161=$780.18
13
ExampleD$780.18+$0.00-75.00x1.161=$818.71
14
DateWeekLast week's balance+Any new
debt
-Any
payments
x1 +
interest rate
=Balance
15
OCT. 21st1+-x1.161=$0.00
16
OCT. 28th2+-x1.161=$0.00
17
NOV. 4th3+-x1.161=$0.00
18
NOV. 11th*4+-x1.161=$0.00
19
NOV. 18th5+-x1.161=$0.00
20
NOV. 25th*6+-x1.161=$0.00
21
DEC. 2nd7+-x1.161=$0.00
22
DEC. 9th8+-x1.161=$0.00
23
DEC. 16th9+-x1.161=$0.00
24
DEC. 23rd*10+-x1.161=$0.00
25
DEC. 30th*11+-x1.161=$0.00
26
JAN. 6th12+-x1.161=$0.00
27
JAN. 13th13+-x1.161=$0.00
28
JAN. 20th14+-x1.161=$0.00
29
JAN. 27th15+-x1.161=$0.00
30
FEB. 3rd16+-x1.161=$0.00
31
FEB. 10th17+-x1.161=$0.00
32
FEB. 17th*18+-x1.161=$0.00
33
FEB. 24th19+-x1.161=$0.00
34
MAR. 3rd20+-x1.161=$0.00
35
MAR. 10th21+-x1.161=$0.00
36
MAR. 17th22+-x1.161=$0.00
37
MAR. 24th23+-x1.161=$0.00
38
MAR. 31st*24+-x1.161=$0.00
39
APR. 7th*25+-x1.161=$0.00
40
APR. 14th26+-x1.161=$0.00
41
APR. 21st27+-x1.161=$0.00
42
APR. 28th28+-x1.161=$0.00
43
MAY 5th*29+-x1.161=$0.00
44
MAY 12th30+-x1.161=$0.00
45
MAY 19th31+-x1.161=$0.00
46
MAY 26th32+-x1.161=$0.00
47
JUN. 2nd33+-x1.161=$0.00
48
JUN. 9th34+-x1.161=$0.00
49
JUN. 16th35+-x1.161=$0.00
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...