Complete the Personal Cash Flow Statement.

profilePmnguyen1989
fp120_r8_cash-flow_statement.xls

Cash-Flow Statement

Household $ Amount Frequency Monthly Payment
Rent $0.00
Mortgage $0.00
HELOC or Home Equity Loan $0.00
Maintenance/HOA Fee $0.00
Property Tax (if not included in mortgage) $0.00
Home Insurance * $0.00
Telephone/ Cellphone $0.00
Internet $0.00
Cable $0.00
Electricity $0.00
Heating/Cooling (Coal, Oil, AC) $0.00
Water $0.00
Garden/Lawn care $0.00
Alarm System $0.00
Maintenance and Repair, Including Purchases $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Household Expenses $0.00
Transportation $ Amount Frequency Monthly Payment
Monthly Car Payment 1 $0.00
Monthly Car Payment 2 $0.00
Monthly Car Payment 3 $0.00
Gas for ALL Cars $0.00
Car Maintenance $0.00
Parking $0.00
Tolls $0.00
Emergency Service $0.00
Public Transportation $0.00
Taxis/Car Service $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Transportation Expenses $0.00
Insurance $ Amount Frequency Monthly Payment
Home $0.00
Renters $0.00
Mortgage * $0.00
Health $0.00
Life $0.00
Disability $0.00
Long-Term Care $0.00
Dental $0.00
Car $0.00
Motorcycle $0.00
Vision Care $0.00
Personal Liability $0.00
Pet Health $0.00
Flood/Earthquake/Hurricane $0.00
Miscellaneous Insurance 1 $0.00
Miscellaneous Insurance 2 $0.00
Miscellaneous Insurance 3 $0.00
Total Monthly Insurance Expenses $0.00
Entertainment $ Amount Frequency Monthly Payment
Eating Out $0.00
Video Rentals $0.00
Movies $0.00
Magazine & Newspaper $0.00
Computer/Video Game/Software $0.00
Music $0.00
Sports Tickets $0.00
Concert Tickets $0.00
Vacations $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Entertainment Expenses $0.00
Personal Care $ Amount Frequency Monthly Payment
Food/Groceries $0.00
Clothes $0.00
Dry Cleaning/Laundry $0.00
Family Travel $0.00
Haircare Products $0.00
Hair Cuts, Coloring, etc. $0.00
Cosmetics/Makeup/Perfume $0.00
Dentist/Orthodontist $0.00
Oral Hygiene Products $0.00
Eye Doctor $0.00
Contacts/Glasses $0.00
Doctors $0.00
Medication $0.00
Toiletries $0.00
Gym Membership/Dues $0.00
Personal Grooming (manicure, pedicure, etc.) $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Personal Care Expenses $0.00
Child Expenses $ Amount Frequency Monthly Payment
Childcare $0.00
Child Support Payments $0.00
School Books/Supplies $0.00
Enrollment/School Fees $0.00
Tuition $0.00
Lunch $0.00
School Uniforms $0.00
Sports Team Fees $0.00
Sporting Equipment $0.00
After-school Lessons (dancing, music, etc.) $0.00
Extracurricular Activity $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Family Expenses $0.00
Miscellaneous $ Amount Frequency Monthly Payment
Pet Food $0.00
Vet Bills $0.00
Pet Care (litter, toys, sitter) $0.00
Donations $0.00
Books/Downloads $0.00
Jewelry $0.00
Hobby $0.00
Vacation $0.00
Parties $0.00
Gifts (birthdays, holidays, etc.) $0.00
Holiday/Seasonal Items $0.00
Other Miscellaneous Items $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Miscellaneous Expenses $0.00
Debt Payments $ Amount Frequency Monthly Payment
Credit Card 1 $0.00
Credit Card 2 $0.00
Credit Card 3 $0.00
Personal/Bank Loan $0.00
Student Loan $0.00
Miscellaneous Debt 1 $0.00
Miscellaneous Debt 2 $0.00
Miscellaneous Debt 3 $0.00
Total Monthly Debt Payments $0.00
Savings Contributions $ Amount Frequency Monthly Payment
Emergency Fund $0.00
Educational Accounts $0.00
Retirement Accounts $0.00
Savings Account $0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
Total Monthly Savings Payments $0.00
Now that you've entered all your expenses, let's look at the totals. Below you'll see your total monthly living expenses and the portion of those that Suze considers to be essential (those marked with an asterisk in the expense tables you filled out). Are you surprised by how much you're spending every month?
Total Monthly Expenses $0.00
Income $ Amount Frequency Monthly Income
After-tax Income $0.00
Spouse/Partners' After-tax Income $0.00
Alimony $0.00
Unemployment $0.00
Social Security $0.00
Other income $0.00
Other income $0.00
Other income $0.00
Total Monthly Income $0.00
Income 2
Totals Debt 1
Lookup 21 Lookup Savings Income Debt Text Line Text
2311 2 3 1 1 Congratulations! You are saving on a monthly basis, don't have any debt and have an emergency fund.
2312 2 3 1 2 Keep doing what you're doing and try when possible to invest and save more!
2313 2 3 1 3 0
Here you will see the total funds you have remaining each month in black, or the amount you are short in red. 2314 2 3 1 4 0
You’ll also see a pie chart with the breakdown of how you spend your money each month.
If you’re like many of us, you may see more than a few surprises. That’s okay. No beating yourself up. 2321 2 3 2 1 You're living within your means and have some money stashed away for a rainy day.
2322 2 3 2 2 Congratulations! But to achieve true financial freedom, you need get out from under your debt burden as quickly as possible.
You have just done the most amazing thing. You are now standing in the truth of your financial life. 2323 2 3 2 3 Take that extra income you're not spending each month and use it to increase your debt payments.
2324 2 3 2 4 0
This cash-flow statement is a valuable tool—one that you can return to over and over again to help you stay focused on your financial goals. 2211 2 2 1 1 You have savings and no debt. Congratulations! But you're currently spending all the money you earn.
Later in the course, you will learn how to get yourself out of any deficit hole or what to do with any excess funds you may have at the end of each month. This is just the beginning. Feels good, doesn’t it? 2212 2 2 1 2 If you want your savings to grow without incurring debt, you need to find some places to cut back on your expenses to free up a little
2213 2 2 1 3 cash to put away each month.
1314 1 3 1 4 0
Total Monthly After-Tax Income $0.00 1321 1 3 2 1 You're currently living within your means. Congratulations!
1322 1 3 2 2 But to achieve true financial freedom, you need to take that extra cash you have left over each month and use it to increase
Total Monthly Expenses $0.00 1323 1 3 2 3 your debt payments.
1324 1 3 2 4 0
TOTAL MONTHLY EXCESS OR DEFICIT $0.00 1211 1 2 1 1 You're currently living within your means and don't have any debt. Congratulations!
1212 1 2 1 2 But you need to start saving for a rainy day. See if you can find ways to reduce your spending each month and free up some cash
1213 1 2 1 3 that you can use to start building an emergency fund.
1214 1 2 1 4 0
1221 1 2 2 1 You're currently living within your means, which is good. But to achieve true financial freedom, you need get out from under your debt
Category $ Amount % of Total Expenses 1222 1 2 2 2 burden as quickly as possible. See if you can find ways to reduce your spending each month and free up some cash that you can use to
Home $0 0% 1223 1 2 2 3 increase your debt payments. At the same time, you need to start planning for a rainy day.
Transportation $0 0% 1224 1 2 2 4 What can you do to start building an emergency savings fund?
Insurance $0 0% 2111 2 1 1 1 You've put some money away for a rainy day and don't have any debt, which is good. But you're currently living beyond your means.
Entertainment $0 0% 2112 2 1 1 2 See if you can find ways to reduce your spending each month to the point that you're not spending more than you earn.
Personal/Family Care $0 0% 2113 2 1 1 3 0
Child Expenses $0 0% 2114 2 1 1 4 0
Miscellaneous $0 0% 1111 1 1 1 1 You have no debt, which is great. But you're currently living beyond your means and don't have anything put away for a rainy day.
Debt Payments $0 0% 1112 1 1 1 2 See if you can find ways to reduce your spending each month so that you're spending less than you earn.
Savings Contributions $0 0% 1113 1 1 1 3 Use the extra money to start building an emergency savings fund.
Total $0 1114 1 1 1 4 0
1121 1 1 2 1 You're currently living beyond your means, your debt threatens to drag you down even further, and you don't have anything put away
1122 1 1 2 2 for a rainy day. You need to find ways to reduce your spending each month so that you're spending less than you earn.
1123 1 1 2 3 Use the extra money to increase your debt payments so you can get out from under your debt burden as quickly as possible.
1124 1 1 2 4 Then you need to use the extra cash to start building an emergency savings fund.
Based on your current financial situation, what are two short-term (in the next 12 months) goals you might set for yourself?
Goal 1:
Goal 2:
Based on your current financial situation, what are two long-term (more than one year in the future) goals you might set for yourself?
Goal 1:
Goal 2:
2121 2 1 2 1 You're currently living beyond your means and your debt threatens to drag you down even further.
2122 2 1 2 2 You need to find ways to reduce your spending each month so that you're spending less than you earn.
Congratulations! You have completed this episode. Click in the upper-right corner of the screen to submit your work to your faculty. 2123 2 1 2 3 Use the extra money to increase your debt payments so you can get out from under your debt burden as quickly as possible.
2124 2 1 2 4 0
2214 2 2 1 4 0
1311 1 3 1 1 You're living within your means and are debt free! Congratulations!
1312 1 3 1 2 But you need to start saving for a rainy day.
1313 1 3 1 3 Take some of that extra income you're not spending each month and start building an emergency fund.
2221 2 2 2 1 You've managed to put some money away for a rainy day: congratulations!
2222 2 2 2 2 But to achieve true financial freedom, you need get out from under your debt burden as quickly as possible.
2223 2 2 2 3 See if you can find ways to reduce your spending each month and free up some cash that you can use to increase your debt payments.
2224 2 2 2 4
1322 1 3 2 2 But to achieve true financial freedom, you need to take that extra cash you have left over each month and use it to increase
Savings 0
Income 0
Debt 1
Lookup 0 Lookup Savings Income Debt Text Line Text
2311 2 3 1 1 Congratulations! You are saving on a monthly basis, don't have any debt and have an emergency fund.
2312 2 3 1 2 Keep doing what you're doing and try when possible to invest and save more!
2313 2 3 1 3 0
2314 2 3 1 4 0
2321 2 3 2 1 You're living within your means and have some money stashed away for a rainy day.
2322 2 3 2 2 Congratulations! But to achieve true financial freedom, you need get out from under your debt burden as quickly as possible.
2323 2 3 2 3 Take that extra income you're not spending each month and use it to increase your debt payments.
2324 2 3 2 4 0
2211 2 2 1 1 You have savings and no debt. Congratulations! But you're currently spending all the money you earn.
2212 2 2 1 2 If you want your savings to grow without incurring debt, you need to find some places to cut back on your expenses to free up a little
2213 2 2 1 3 cash to put away each month.
2214 2 2 1 4 0
2221 2 2 2 1 You've managed to put some money away for a rainy day: congratulations!
2222 2 2 2 2 But to achieve true financial freedom, you need get out from under your debt burden as quickly as possible.
2223 2 2 2 3 See if you can find ways to reduce your spending each month and free up some cash that you can use to increase your debt payments.
2224 2 2 2 4 0
1311 1 3 1 1 You're living within your means and are debt free! Congratulations!
1312 1 3 1 2 But you need to start saving for a rainy day.
1313 1 3 1 3 Take some of that extra income you're not spending each month and start building an emergency fund.
1314 1 3 1 4 0
1321 1 3 2 1 You're currently living within your means. Congratulations!
1322 1 3 2 2 But to achieve true financial freedom, you need to take that extra cash you have left over each month and use it to increase
1323 1 3 2 3 your debt payments.
1324 1 3 2 4 0
1211 1 2 1 1 You're currently living within your means and don't have any debt. Congratulations!
1212 1 2 1 2 But you need to start saving for a rainy day. See if you can find ways to reduce your spending each month and free up some cash
1213 1 2 1 3 that you can use to start building an emergency fund.
1214 1 2 1 4 0
1221 1 2 2 1 You're currently living within your means, which is good. But to achieve true financial freedom, you need get out from under your debt
1222 1 2 2 2 burden as quickly as possible. See if you can find ways to reduce your spending each month and free up some cash that you can use to

Cash-Flow Statement

Breakdown of Monthly Expenses

References

Pivot Table Data
Category Sub-Category Amount Age List Frequency List
Home Rent 0 1 Daily 30.41
Home Mortgage 0 2 Weekly 4.3333333333
Home HELOC or Home Eq Loan 0 3 Monthly 1.00
Home Additional Loans? 0 4 Quarterly 0.33
Home Maintenance Fee 0 5 Every 3 months 0.33
Home HOA Fee 0 6 Every 6 Months 0.1666666667
Home Property Tax 0 7 Yearly 0.0833333333
Home Home Insurance 0 8
Home Telephone 0 9
Home Cell Phone, including estimated overages 0 10
Home Internet 0 11
Home Cable 0 12
Home Electricity 0 13
Home Heating Oil 0 14
Home Coal 0 15
Home Water 0 16
Home Garden 0 17
Home Firewood 0 18
Home Repairs 0 19
Home Lawn Care 0 20
Home Snow Care 0 21
Home Alarm System 0 22
Home Firewood 0 23
Home Pool/Hot Tub 0 24
Home Maintenance and Repair, including purchases 0 25
Car Monthly Car 1 Payment 0 26
Car Monthly Car 2 Payment 0 27
Car Monthly Car 3 Payment 0 28
Car Monthly Car 4 Payment 0 29
Car Gas for ALL cars 0 30
Car Car Maintenance 0 31
Car Parking Lots 0 32
Car Car Tolls 0 33
Car Car EZ PASS 0 34
Car Car Parking Tickets 0 35
Car Car Sat Radio 0 36
Car Car Emergency Service 0 37
Insurance Health Insurance 0 38
Insurance Life Insurance 0 39
Insurance Disability Insurance 0 40
Insurance Long Term Care Ins 0 41
Insurance Dental Insurance 0 42
Insurance Car Insurance 0 43
Miscellaneous Food/Groceries 0 44
Miscellaneous Eating out 0 45
Miscellaneous Pet Food 0 46
Miscellaneous Child Support 0 47
Miscellaneous Private School 0 48
Miscellaneous Child Care 0 49
Miscellaneous Public Transportation 0 50
Miscellaneous Vet Bills 0 51
Miscellaneous Video Rentals 0 52
Miscellaneous Movies 0 53
Miscellaneous Sports games 0 54
Miscellaneous Computer 0 55
Miscellaneous Cleaning Supplies/Services 0 56
Miscellaneous Membership Dues 0 57
Miscellaneous Hair 0 58
Miscellaneous Makeup 0 59
Miscellaneous Clothes 0 60
Miscellaneous Dry Cleaning/Laundry 0 61
Miscellaneous Massage 0 62
Miscellaneous Manicure 0 63
Miscellaneous Gifts 0 64
Miscellaneous Vacations 0 65
Miscellaneous Donations 0 66
Miscellaneous Books 0 67
Miscellaneous Magazines 0 68
Miscellaneous Newspaper 0 69
Miscellaneous Health Club 0 70
Miscellaneous Dentist 0 71
Miscellaneous Eye Doctor 0 72
Miscellaneous Medication 0 73
Miscellaneous Toiletries 0 74
Miscellaneous Jewelery 0 75
Miscellaneous Hobby 0 76
Miscellaneous Holiday/Seasonal Items 0 77
Miscellaneous Family Travel 0 78
Miscellaneous Additional Item 1 0 79
Miscellaneous Additional Item 2 0 80
Miscellaneous Additional Item 3 0 81
Debt Payments Credit Cards 0 82
Debt Payments 401k Loan 0 83
Debt Payments Personal Loan 0 84
Debt Payments Bank Loan 0 85
Debt Payments Student Loan 0 86
Debt Payments Bankruptcy payment 0 87
Debt Payments Quarterly Taxes 0 88
Debt Payments IRS debt payment 0 89
90
91
92
93
94
95
96
97
98
99
100