FinancialStatements.gsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Type Your Name HereCash Flow Statement
2
INCOMEMonthlyAnnually
3
Employment $ 2,500 $ 30,000
4
Other Income 500 6,000
5
Gross Income $ 3,000 $ 36,000
6
7
EXPENSES
Note: There are two required sheets, this sheet,
8
the cash flow statement, and the next sheet, the
9
Income Taxes (Fed & CA) $ 350 $ 4,200
net worth statement. Do not just submit the cash
10
cash flow statement! Look at the bottom of the
11
Householdpage. Do you see the tab marked [NetWorth]?
12
Rent/Mortgage 650 7,800 Click on it after you are done with the cash flow
13
Gas/Electric 35 420 statement on this sheet. Submit both the cash
14
Phone 65 780 statement and the net worth statement.
15
Cable 35 420
16
Food 400 4,800
Please watch the presentation. It is common for
17
Clothing 50 600 many students to simply submit the cash flow
18
Medical 25 300 statement without the net worth statement.
19
Other 1 (overwrite name) 25 300
20
Miscellaneous 100 1,200
The [Monthly] and [Yearly] sheets are for your own
21
Total Household $ 1,385 $ 16,620
usage. They are not required. Again, please watch
22
the presentation as it will explain everything about
23
Automobilehow to use this spreadsheet.
24
Car 175 2,100
25
Gas 125 1,500
26
Insurance 80 960
27
Maintenance 100 1,200
28
Other 1 10 120
29
Registration 15 180
30
Total Automobile $ 505 $ 6,060
31
32
Liabilities
33
Loan 1 Payment (overwrite name of loan) 50 600
34
Credit Card 1 Payment (overwrite name) 30 360
35
Other Loan 1 Payment (overwrite name) 50 600
36
Total Liabilities $ 130 $ 1,560
37
38
Personal
39
Personal 1 (example: Gym, overwrite name)
25 300
40
Personal 2 (overwrite name) 25 300
41
Hair Care 20 240
42
Beauty 20 240
43
Entertainment 80 960
44
Total Personal 170 2,040
45
46
Insurance
47
Life 25 300
48
Disability 25 300
49
Medical 25 300
50
Renter's / Homeowner's 25 300
51
Total Insurance $ 100 $ 1,200
52
53
Savings $ 25 $ 300
54
55
Retirement
56
Social Security / Medicare 230 2,754
57
Retirement 1 (example: 401k, overwrite name)
50 600
58
Retirement 2 (example: Roth IRA, overwrite name)
50 600
59
Total Retirement $ 330 $ 3,954
60
61
Total Income $ 3,000 $ 36,000
62
Total Expenses 2,995 35,934
63
Discretionary / (Shortfall) $ 6 $ 66
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...
 
 
 
CashFlow
NetWorth
Monthly
Yearly
 
 
Main menu