|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Household |
|
|
|
|
|
|
|
|
|
|
| $
| Amount |
|
|
|
|
|
|
|
|
|
| Frequency |
|
|
|
|
|
|
|
|
| Monthly Payment |
|
| Rent |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $
|
|
|
|
|
|
|
|
|
|
| 0 |
.00
Instructions: Enter the payment amount as a number, then select the frequency from the drop-down. The Monthly Payment Amount will automatically calculate, and will sum throughout the spreadsheet. |
|
| 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
|
| Vacation |
s
$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
|
| Hair |
care 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
|
| 23 |
| 11 |
2 3 1 1
Congratulations! You are saving on a monthly basis, don’t have any debt and have an emergency fund. |
| 23
|
| 12 |
2 3 1 2
Keep doing what you’re doing and try when possible to invest and save more! |
| 23
|
| 13 |
2 3 1 3
| Here you will see the total funds you have remaining each month in black, or the amount you are short in red. |
2
| 31 |
|
|
|
|
|
|
|
|
|
|
|
|
| 4 |
2 3 1 4
| 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. |
2
| 32 |
1
2 3 2 1
You’re living within your means and have some money stashed away for a rainy day. |
| 23
| 22 |
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. |
| 23
| 24 |
2 3 2 4
| 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. |
| 13
| 14 |
1 3 1 4
|
| 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
| TOTAL MONTHLY EXCESS OR DEFICIT |
$0.00
| 1211 |
1 2 1 1
| 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
|
|
|
|
|
|
|
|
| ERROR:#DIV/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 ERROR:#DIV/0!
| 1224 |
1 2 2 4
What can you do to start building an emergency savings fund? |
Insurance $0 ERROR:#DIV/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 ERROR:#DIV/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 ERROR:#DIV/0!
2113 |
2 1 1 3
Child Expenses $0 ERROR:#DIV/0!
| 2114 |
2 1 1 4
Miscellaneous $0 ERROR:#DIV/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 ERROR:#DIV/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 ERROR:#DIV/0!
1113 |
1 1 1 3
Use the extra money to start building an emergency savings fund. |
Total $0
| 1114 |
1 1 1 4
| 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: |
|
| Goal2: |
| 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:
Goal2:
| Look at your excess or deficit (above in yellow rows). What are some steps you can take to bring this amount to zero? List at least two actions you could take. |
|
| ERROR:#REF! |
2 1 2 ERROR:#REF! You need to find ways to reduce your spending each month so that you’re spending less than you earn.
| 2214 |
2 2 1 4
| 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
| the instructions could make the numeracy case by saying something like “math is part of our everyday lives as we decide what we can and can’t spend, how much to save, etc…. |
