Need an assignment done for my Finance college class. Need good work and free from plagiarism. Need the Worksheet done by January 27, 2020 which is a Monday.
Please look at Week 1 Excel file attachment and fill in the financial excel worksheet. Make whatever numbers up. Then after the week 1 assignment excel sheet is complete, open the Week 3 Assignment attachment and use the week 1 excel to fill in the week 3 assignment.
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2 |
>Week
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1 |
-Personal
Monthly |
Budget
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Household |
|
|
|
|
|
|
|
|
|
|
| $
| Amount |
|
|
|
|
|
|
|
|
|
| Frequency |
|
|
|
|
|
|
|
|
| Monthly Payment |
|
| Rent |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
|
|
|
|
|
|
|
|
|
|
| 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…. |
Breakdown of Monthly Expenses
Home Transportation Insurance Entertainment Personal/Family Care Child Expenses Miscellaneous Debt Payments Savings Contributions 0 0 0 0 0 0 0 0 0
Week 3-Education Funding
| Where an amount is requested, enter only dollar amounts to allow calculations to occur. |
1
patrickg: Tip: If you don’t know this year’s tuition costs, use the tuition calculator at www.phoenix.edu/financialplanassignment. You can also find this in your student Account. |
This year’s total tuition costs |
2
patrickg: Tip: If you’re not sure how much you’ve borrowed, log in to www.nslds.ed.gov to see all your federal student loan. You can also find a total loan balance in your account Repayment tab. You can also contact a University of Phoenix finance advisor. |
How much of this year’s tuition is currently funded through loans? |
3
| How much of this year’s tuition is currently funded through personal savings or salary? |
4
| How much of this year’s tuition is currently funded through scholarships, grants (including Pell Grants), military benefits, employer reimbursement, and/or other sources? |
|
|
| 5 |
Unfunded tuition costs |
$0
| Excess funding |
$0
| These options are best suited to address my unfunded tuition: |
$ Covered |
1
2
3
4
5
Total $0
|
| 6 |
How much student loan debt do you expect to have at graduation? |
|
| 7 |
What is the average annual starting salary you expect after graduation? |
|
| 8 |
Do your student loans exceed your expected annual starting salary? |
NO |
|
| 9 |
What can you do to reduce the amount you borrow? |
Potential |
| If you do not have any loans, what would you suggest to another student? |
Savings
1
2
3
4
Total $0
|
| 10 |
What is the standard monthly payment for the total amount you expect to borrow? |
11
| What federal repayment plans are available to help students lower the standard monthly payment? |
12
| Explain your return on educational investment. Consider what you will pay for your program, how much you’ll borrow, and estimated future salary over the length of your career. |
13
| After completing this assignment, how do you feel about your plan to pay for college? Will you try to lower the amount you borrow? Will you try to find ways to pay some tuition without using loans? What changes might you make to your educational financial plan? |
Week 3-Job Expenses
| Added expenses when working in chosen job |
$ Amount Frequency Monthly Payment
| Moving costs (if applicable, choose the time period you would have these costs paid within- no more than
| Yearly |
)
$0.00
Childcare $0.00
| Public transportation to/from work |
$0.00
| Gas to/from work |
$0.00
Parking $0.00
| Additional meals (ex. lunch, group events) |
$0.00
| Clothing |
$0.00
| Work-related materials/supplies (ex. classroom supplies) |
$0.00
| Conference or organization membership |
$0.00
| Union dues |
$0.00
Health insurance payment
Chris Conway : For insurance payment amounts, consider whether you expect your insurance payments to increase or decrease once working in your chosen field. If you think you will save money, you can enter a negative number in this cell. |
$0.00
| Dental insurance payment |
$0.00
| Vision insurance payment |
$0.00
| Disability insurance payment |
$0.00
| Life insurance payment |
$0.00
| Retirement plan contribution |
$0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
| Total Additional Monthly Job Expenses |
$0.00
Estimated gross monthly salary first year after graduation
Chris Conway: This amount is calculated from the annual starting salary estimate in Question 7 f the Week 3 Education Funding assignment. That amount is then divided by 12 to reach your gross monthly income (before tax). |
$0.00
| Estimated monthly take-home salary first year after graduation (assumes
| 19 |
.2% tax rate)
Chris Conway: This is an estimate of taxes that would be withdrawn from your future income. This assumes 10.5% federal, 3% state, 6.2% Social Security, and 1.5% Medicare. 19.2% total estimated tax.
$0.00
Estimated increase (decrease) to monthly take-home pay
Chris Conway: This field is an estimate of your monthly income increase (or decrease) once you are working in your chosen field after graduation. |
Chris Conway : For insurance payment amounts, consider whether you expect your insurance payments to increase or decrease once working in your chosen field. If you think you will save money, you can enter a negative number in this cell. |
$0.00
| Total Additional Monthly Household Income |
$0.00
| Original Monthly Budget from Week 1: |
Total Monthly After-Tax Income
|
|
|
|
|
|
|
|
|
| $ – 0 |
| Total Monthly Household Expenses |
$ – 0
Total Monthly Transportation Expenses $ – 0
Total Monthly Insurance Expenses $ – 0
Total Monthly Entertainment Expenses $ – 0
Total Monthly Personal Care Expenses $ – 0
Total Monthly Family Expenses $ – 0
Total Monthly Miscellaneous Expenses $ – 0
| Total Monthly Debt Payments |
$ – 0
Total Monthly Savings Payments $ – 0
| Monthly Excess/Deficit |
$0.00
| Estimated increase (decrease) to monthly take-home pay |
$0.00
| Less Additional Monthly Job Expenses |
$0.00
| Less Estimated Monthly Student Loan Payment |
$0.00
| Estimated Future Montly Excess/Deficit |
$0.00
| In this assignment you have considered the most common expenses you may see as a result of working in your chosen career. Lines
| 45 |
–
48 |
on this worksheet show how your future monthly income and expenses may change. How does this activity affect your thinking about future jobs? Enter your response here:
References
| Pivot Table Data |
Category
| Sub-Category |
Amount
Age List |
Frequency List |
Home Rent
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ERROR:#N/A |
1
Daily |
| 30 |
.
41 |
Home Mortgage ERROR:#N/A 2
| Weekly |
4.
| 33 |
33333333
Home
| HELOC or Home Eq Loan |
ERROR:#N/A 3
Every 2 weeks |
2.
| 16 |
66 |
6666
67 |
Home
| Additional Loans? |
ERROR:#N/A 4 Monthly
1.00 |
Home
| Maintenance Fee |
ERROR:#N/A 5
Every 2 months |
0.
| 50 |
Home HOA Fee ERROR:#N/A 6
| Every 3 months |
0.33 |
Home Property Tax ERROR:#N/A 7
| Every 6 Months |
0.1666666667 |
Home
| Home Insurance |
ERROR:#N/A 8 Yearly
0.0
| 83 |
3333333
Home Telephone ERROR:#N/A 9
Home
| Cell Phone, including estimated overages |
ERROR:#N/A 10
Home Internet ERROR:#N/A 11
Home Cable 0 12
Home Electricity ERROR:#N/A 13
Home
| Heating Oil |
ERROR:#N/A 14
Home Coal ERROR:#N/A
| 15 |
Home Water ERROR:#N/A 16
Home Garden ERROR:#N/A
| 17 |
Home
|
| Firewood |
ERROR:#N/A
18 |
Home
| Repairs |
ERROR:#N/A 19
Home
| Lawn Care |
ERROR:#N/A
20 |
Home
| Snow Care |
ERROR:#N/A 21
Home Alarm System 0 22
Home Firewood ERROR:#N/A 23
Home
| Pool/Hot Tub |
ERROR:#N/A 24
Home
| Maintenance and Repair, including purchases |
0
25 |
Car
| Monthly Car 1 Payment |
ERROR:#N/A
26 |
Car
| Monthly Car 2 Payment |
ERROR:#N/A
27 |
Car
| Monthly Car 3 Payment |
ERROR:#N/A
28 |
Car
| Monthly Car 4 Payment |
ERROR:#N/A
29 |
Car
| Gas for ALL cars |
ERROR:#N/A 30
Car Car Maintenance ERROR:#N/A 31
Car
| Parking Lots |
ERROR:#N/A 32
Car
| Car Tolls |
ERROR:#N/A 33
Car
| Car EZ PASS |
ERROR:#N/A
34 |
Car
| Car Parking Tickets |
ERROR:#N/A
35 |
Car
| Car Sat Radio |
ERROR:#N/A
36 |
Car
| Car Emergency Service |
ERROR:#N/A
37 |
Insurance
| Health Insurance |
ERROR:#N/A
38 |
Insurance
| Life Insurance |
ERROR:#N/A
39 |
Insurance
| Disability Insurance |
ERROR:#N/A
40 |
Insurance
| Long Term Care Ins |
ERROR:#N/A 41
Insurance
| Dental Insurance |
ERROR:#N/A
42 |
Insurance
| Car Insurance |
ERROR:#N/A
43 |
Miscellaneous Food/Groceries ERROR:#N/A
| 44 |
Miscellaneous
| Eating out |
ERROR:#N/A 45
Miscellaneous Pet Food 0
| 46 |
Miscellaneous Child Support ERROR:#N/A
| 47 |
Miscellaneous
| Private School |
ERROR:#N/A 48
Miscellaneous
| Child Care |
ERROR:#N/A
49 |
Miscellaneous Public Transportation ERROR:#N/A 50
Miscellaneous Vet Bills 0
| 51 |
Miscellaneous Video Rentals ERROR:#N/A
| 52 |
Miscellaneous Movies ERROR:#N/A
| 53 |
Miscellaneous
| Sports games |
ERROR:#N/A
54 |
Miscellaneous Computer ERROR:#N/A
| 55 |
Miscellaneous
| Cleaning Supplies/Services |
ERROR:#N/A
56 |
Miscellaneous
| Membership Dues |
ERROR:#N/A
57 |
Miscellaneous Hair ERROR:#N/A
| 58 |
Miscellaneous Makeup ERROR:#N/A
| 59 |
Miscellaneous Clothes ERROR:#N/A
| 60 |
Miscellaneous Dry Cleaning/Laundry ERROR:#N/A
| 61 |
Miscellaneous
| Massage |
ERROR:#N/A
62 |
Miscellaneous
| Manicure |
ERROR:#N/A
63 |
Miscellaneous Gifts ERROR:#N/A
| 64 |
Miscellaneous
| Vacations |
ERROR:#N/A
65 |
Miscellaneous Donations 0 66
Miscellaneous Books ERROR:#N/A 67
Miscellaneous
| Magazines |
ERROR:#N/A
68 |
Miscellaneous Newspaper ERROR:#N/A
| 69 |
Miscellaneous
| Health Club |
ERROR:#N/A
70 |
Miscellaneous Dentist ERROR:#N/A
| 71 |
Miscellaneous Eye Doctor ERROR:#N/A
| 72 |
Miscellaneous Medication ERROR:#N/A
| 73 |
Miscellaneous Toiletries ERROR:#N/A
| 74 |
Miscellaneous
| Jewelery |
ERROR:#N/A
75 |
Miscellaneous Hobby 0
| 76 |
Miscellaneous Holiday/Seasonal Items 0
| 77 |
Miscellaneous
| Family Travel |
ERROR:#N/A
78 |
Miscellaneous Additional Item 1 0
| 79 |
Miscellaneous Additional Item 2 0
| 80 |
Miscellaneous Additional Item 3 0
| 81 |
Debt Payments
| Credit Cards |
ERROR:#N/A
82 |
Debt Payments
| 401k Loan |
ERROR:#N/A 83
Debt Payments
| Personal Loan |
ERROR:#N/A
84 |
Debt Payments Bank Loan ERROR:#N/A
| 85 |
Debt Payments Student Loan ERROR:#N/A
| 86 |
Debt Payments
| Bankruptcy payment |
ERROR:#N/A
87 |
Debt Payments
| Quarterly Taxes |
ERROR:#N/A
88 |
Debt Payments
| IRS debt payment |
ERROR:#N/A
89 |
| 90 |
| 91 |
| 92 |
| 93 |
| 94 |
| 95 |
| 96 |
| 97 |
| 98 |
| 99 |
| 100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2 |
>Week
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1 |
-Personal
Monthly |
Budget
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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…. |
Breakdown of Monthly Expenses
Home Transportation Insurance Entertainment Personal/Family Care Child Expenses Miscellaneous Debt Payments Savings Contributions 0 0 0 0 0 0 0 0 0
Week 3-Education Funding
| Where an amount is requested, enter only dollar amounts to allow calculations to occur. |
1
patrickg: Tip: If you don’t know this year’s tuition costs, use the tuition calculator at www.phoenix.edu/financialplanassignment. You can also find this in your student Account. |
This year’s total tuition costs |
2
patrickg: Tip: If you’re not sure how much you’ve borrowed, log in to www.nslds.ed.gov to see all your federal student loan. You can also find a total loan balance in your account Repayment tab. You can also contact a University of Phoenix finance advisor. |
How much of this year’s tuition is currently funded through loans? |
3
| How much of this year’s tuition is currently funded through personal savings or salary? |
4
| How much of this year’s tuition is currently funded through scholarships, grants (including Pell Grants), military benefits, employer reimbursement, and/or other sources? |
|
|
| 5 |
Unfunded tuition costs |
$0
| Excess funding |
$0
| These options are best suited to address my unfunded tuition: |
$ Covered |
1
2
3
4
5
Total $0
|
| 6 |
How much student loan debt do you expect to have at graduation? |
|
| 7 |
What is the average annual starting salary you expect after graduation? |
|
| 8 |
Do your student loans exceed your expected annual starting salary? |
NO |
|
| 9 |
What can you do to reduce the amount you borrow? |
Potential |
| If you do not have any loans, what would you suggest to another student? |
Savings
1
2
3
4
Total $0
|
| 10 |
What is the standard monthly payment for the total amount you expect to borrow? |
11
| What federal repayment plans are available to help students lower the standard monthly payment? |
12
| Explain your return on educational investment. Consider what you will pay for your program, how much you’ll borrow, and estimated future salary over the length of your career. |
13
| After completing this assignment, how do you feel about your plan to pay for college? Will you try to lower the amount you borrow? Will you try to find ways to pay some tuition without using loans? What changes might you make to your educational financial plan? |
Week 3-Job Expenses
| Added expenses when working in chosen job |
$ Amount Frequency Monthly Payment
| Moving costs (if applicable, choose the time period you would have these costs paid within- no more than
| Yearly |
)
$0.00
Childcare $0.00
| Public transportation to/from work |
$0.00
| Gas to/from work |
$0.00
Parking $0.00
| Additional meals (ex. lunch, group events) |
$0.00
| Clothing |
$0.00
| Work-related materials/supplies (ex. classroom supplies) |
$0.00
| Conference or organization membership |
$0.00
| Union dues |
$0.00
Health insurance payment
Chris Conway : For insurance payment amounts, consider whether you expect your insurance payments to increase or decrease once working in your chosen field. If you think you will save money, you can enter a negative number in this cell. |
$0.00
| Dental insurance payment |
$0.00
| Vision insurance payment |
$0.00
| Disability insurance payment |
$0.00
| Life insurance payment |
$0.00
| Retirement plan contribution |
$0.00
Additional Item 1 $0.00
Additional Item 2 $0.00
Additional Item 3 $0.00
| Total Additional Monthly Job Expenses |
$0.00
Estimated gross monthly salary first year after graduation
Chris Conway: This amount is calculated from the annual starting salary estimate in Question 7 f the Week 3 Education Funding assignment. That amount is then divided by 12 to reach your gross monthly income (before tax). |
$0.00
| Estimated monthly take-home salary first year after graduation (assumes
| 19 |
.2% tax rate)
Chris Conway: This is an estimate of taxes that would be withdrawn from your future income. This assumes 10.5% federal, 3% state, 6.2% Social Security, and 1.5% Medicare. 19.2% total estimated tax.
$0.00
Estimated increase (decrease) to monthly take-home pay
Chris Conway: This field is an estimate of your monthly income increase (or decrease) once you are working in your chosen field after graduation. |
Chris Conway : For insurance payment amounts, consider whether you expect your insurance payments to increase or decrease once working in your chosen field. If you think you will save money, you can enter a negative number in this cell. |
$0.00
| Total Additional Monthly Household Income |
$0.00
| Original Monthly Budget from Week 1: |
Total Monthly After-Tax Income
|
|
|
|
|
|
|
|
|
| $ – 0 |
| Total Monthly Household Expenses |
$ – 0
Total Monthly Transportation Expenses $ – 0
Total Monthly Insurance Expenses $ – 0
Total Monthly Entertainment Expenses $ – 0
Total Monthly Personal Care Expenses $ – 0
Total Monthly Family Expenses $ – 0
Total Monthly Miscellaneous Expenses $ – 0
| Total Monthly Debt Payments |
$ – 0
Total Monthly Savings Payments $ – 0
| Monthly Excess/Deficit |
$0.00
| Estimated increase (decrease) to monthly take-home pay |
$0.00
| Less Additional Monthly Job Expenses |
$0.00
| Less Estimated Monthly Student Loan Payment |
$0.00
| Estimated Future Montly Excess/Deficit |
$0.00
| In this assignment you have considered the most common expenses you may see as a result of working in your chosen career. Lines
| 45 |
–
48 |
on this worksheet show how your future monthly income and expenses may change. How does this activity affect your thinking about future jobs? Enter your response here:
References
| Pivot Table Data |
Category
| Sub-Category |
Amount
Age List |
Frequency List |
Home Rent
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ERROR:#N/A |
1
Daily |
| 30 |
.
41 |
Home Mortgage ERROR:#N/A 2
| Weekly |
4.
| 33 |
33333333
Home
| HELOC or Home Eq Loan |
ERROR:#N/A 3
Every 2 weeks |
2.
| 16 |
66 |
6666
67 |
Home
| Additional Loans? |
ERROR:#N/A 4 Monthly
1.00 |
Home
| Maintenance Fee |
ERROR:#N/A 5
Every 2 months |
0.
| 50 |
Home HOA Fee ERROR:#N/A 6
| Every 3 months |
0.33 |
Home Property Tax ERROR:#N/A 7
| Every 6 Months |
0.1666666667 |
Home
| Home Insurance |
ERROR:#N/A 8 Yearly
0.0
| 83 |
3333333
Home Telephone ERROR:#N/A 9
Home
| Cell Phone, including estimated overages |
ERROR:#N/A 10
Home Internet ERROR:#N/A 11
Home Cable 0 12
Home Electricity ERROR:#N/A 13
Home
| Heating Oil |
ERROR:#N/A 14
Home Coal ERROR:#N/A
| 15 |
Home Water ERROR:#N/A 16
Home Garden ERROR:#N/A
| 17 |
Home
|
| Firewood |
ERROR:#N/A
18 |
Home
| Repairs |
ERROR:#N/A 19
Home
| Lawn Care |
ERROR:#N/A
20 |
Home
| Snow Care |
ERROR:#N/A 21
Home Alarm System 0 22
Home Firewood ERROR:#N/A 23
Home
| Pool/Hot Tub |
ERROR:#N/A 24
Home
| Maintenance and Repair, including purchases |
0
25 |
Car
| Monthly Car 1 Payment |
ERROR:#N/A
26 |
Car
| Monthly Car 2 Payment |
ERROR:#N/A
27 |
Car
| Monthly Car 3 Payment |
ERROR:#N/A
28 |
Car
| Monthly Car 4 Payment |
ERROR:#N/A
29 |
Car
| Gas for ALL cars |
ERROR:#N/A 30
Car Car Maintenance ERROR:#N/A 31
Car
| Parking Lots |
ERROR:#N/A 32
Car
| Car Tolls |
ERROR:#N/A 33
Car
| Car EZ PASS |
ERROR:#N/A
34 |
Car
| Car Parking Tickets |
ERROR:#N/A
35 |
Car
| Car Sat Radio |
ERROR:#N/A
36 |
Car
| Car Emergency Service |
ERROR:#N/A
37 |
Insurance
| Health Insurance |
ERROR:#N/A
38 |
Insurance
| Life Insurance |
ERROR:#N/A
39 |
Insurance
| Disability Insurance |
ERROR:#N/A
40 |
Insurance
| Long Term Care Ins |
ERROR:#N/A 41
Insurance
| Dental Insurance |
ERROR:#N/A
42 |
Insurance
| Car Insurance |
ERROR:#N/A
43 |
Miscellaneous Food/Groceries ERROR:#N/A
| 44 |
Miscellaneous
| Eating out |
ERROR:#N/A 45
Miscellaneous Pet Food 0
| 46 |
Miscellaneous Child Support ERROR:#N/A
| 47 |
Miscellaneous
| Private School |
ERROR:#N/A 48
Miscellaneous
| Child Care |
ERROR:#N/A
49 |
Miscellaneous Public Transportation ERROR:#N/A 50
Miscellaneous Vet Bills 0
| 51 |
Miscellaneous Video Rentals ERROR:#N/A
| 52 |
Miscellaneous Movies ERROR:#N/A
| 53 |
Miscellaneous
| Sports games |
ERROR:#N/A
54 |
Miscellaneous Computer ERROR:#N/A
| 55 |
Miscellaneous
| Cleaning Supplies/Services |
ERROR:#N/A
56 |
Miscellaneous
| Membership Dues |
ERROR:#N/A
57 |
Miscellaneous Hair ERROR:#N/A
| 58 |
Miscellaneous Makeup ERROR:#N/A
| 59 |
Miscellaneous Clothes ERROR:#N/A
| 60 |
Miscellaneous Dry Cleaning/Laundry ERROR:#N/A
| 61 |
Miscellaneous
| Massage |
ERROR:#N/A
62 |
Miscellaneous
| Manicure |
ERROR:#N/A
63 |
Miscellaneous Gifts ERROR:#N/A
| 64 |
Miscellaneous
| Vacations |
ERROR:#N/A
65 |
Miscellaneous Donations 0 66
Miscellaneous Books ERROR:#N/A 67
Miscellaneous
| Magazines |
ERROR:#N/A
68 |
Miscellaneous Newspaper ERROR:#N/A
| 69 |
Miscellaneous
| Health Club |
ERROR:#N/A
70 |
Miscellaneous Dentist ERROR:#N/A
| 71 |
Miscellaneous Eye Doctor ERROR:#N/A
| 72 |
Miscellaneous Medication ERROR:#N/A
| 73 |
Miscellaneous Toiletries ERROR:#N/A
| 74 |
Miscellaneous
| Jewelery |
ERROR:#N/A
75 |
Miscellaneous Hobby 0
| 76 |
Miscellaneous Holiday/Seasonal Items 0
| 77 |
Miscellaneous
| Family Travel |
ERROR:#N/A
78 |
Miscellaneous Additional Item 1 0
| 79 |
Miscellaneous Additional Item 2 0
| 80 |
Miscellaneous Additional Item 3 0
| 81 |
Debt Payments
| Credit Cards |
ERROR:#N/A
82 |
Debt Payments
| 401k Loan |
ERROR:#N/A 83
Debt Payments
| Personal Loan |
ERROR:#N/A
84 |
Debt Payments Bank Loan ERROR:#N/A
| 85 |
Debt Payments Student Loan ERROR:#N/A
| 86 |
Debt Payments
| Bankruptcy payment |
ERROR:#N/A
87 |
Debt Payments
| Quarterly Taxes |
ERROR:#N/A
88 |
Debt Payments
| IRS debt payment |
ERROR:#N/A
89 |
| 90 |
| 91 |
| 92 |
| 93 |
| 94 |
| 95 |
| 96 |
| 97 |
| 98 |
| 99 |
| 100 |
Turn in your highest-quality paper
Get a qualified writer to help you with
“ Need an assignment done for my Finance college class. Need good work and free from plagiarism. Need the Worksheet done by January 27, 2020 which is a Monday. ”
Get high-quality paper
NEW! AI matching with writer
