Information tech
tchngw1
assignment.zipassignment/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
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 |
assignment/Week1Quiz.docx
Week 1 Quiz
Instructions: Mark the correct answer by highlighting, bold, or changing the answer to a red font. Save the document as “Your Name Week 2 Quiz” and upload the document to the Week 1 Quiz section.
1. Which of the following appears on a cash flow statement?
a. Loan payment
b. Net worth
c. Mortgage balance
d. Home value
2. Money management refers to
a. Preparing personal financial statements
b. Day-to-day financial activities
c. Storing financial records for easy access
d. Trade-offs that occur with financial decisions
3. Which of the following intermediate goals is stated most clearly?
a. Buy a car for less than $17,000 within six months.
b. Retire in ten years at age 65 with $2,000,00 in my 401(k) account.
c. Purchase a home with a mortgage no greater than $150,000 within three years.
d. Set up an emergency fund
4. Fran has a goal of “saving $25 per month for a TV.” Fran’s goal lacks
a. Measurable terms
b. A realistic perspective
c. A specific objective
d. A time frame
5. Attempts to increase income are part of the __________ component of financial planning.
a. Obtaining
b. Planning
c. Saving
d. Spending
6. The Rule of 72 is
a. A tool to determine the number of years until retirement for an employee
b. Used to estimate how long it takes for prices to double using a given annual inflation rate
c. The legal code for requiring companies to provide a match on retirement savings
d. Used to calculate interest rates for savings
7. The stages that an individual goes through based on stages in the family and financial needs is called the
a. Financial planning process
b. Budgeting procedure
c. Adult life cycle
d. Personal economic cycle
8. What are the three types of checking accounts?
a. Interest earning accounts
b. Regular checking accounts
c. Activity accounts
d. All of the above
9. Opportunity cost can be defined as
a. A trade-off of a decision
b. Failing at goals
c. Creating financial wisdom
d. The amount paid for taxes when a purchase is made
10. A family with $50,000 in assets and $30,000 of liabilities would have a net worth of
a. $10,000
b. $20,000
c. $50,000
d. $80,000
assignment/What are the three types of bank accounts.docx
•What are the three types of bank accounts?
•What are two factors that you would consider when opening a bank account? Please explain why you think these are important.
•What are some benefits of opening a student checking account?
•What type of fraud protection might be on a debit card agreement?
•What documents are needed to start building a budget?
•What are the two types of expenses?
•What would student loans debt be classified as?
•Give an example of a personal discretionary expense that you might have and how you will prepare for it.
Bankrate: Budgeting 101: Budget Calculator and consider the following:
Please do not disclose any personal financial data in the discussion.
•The Bankrate calculator compared your budget to the national average. What are two expenses you would like to decrease and how?
•Will you consider the red check mark under "Tips" recommendations? Why?
•Would you use this calculator in the future or recommend it to others?
University of Phoenix Material
Time Value of Money
Refer: to Chapter 1 “Time Value of Money” section of Personal Finance.
In 50 to 100 words please respond to the following questions.
1. What is the definition of Time Value of Money? Please define present and future value?
Complete the Personal Cash Flow Statement.
Reflect on the money you have spent over the past month, and look back at less frequent expenses by reviewing your spending for the year. Then enter the amount you pay and how frequently you pay it (select frequency from the drop-down). If you do not have any expenses for this category, skip it. If you have an expense but do not see a line for it, enter it in one of the rows labeled Additional Items. The Monthly Payment is the result of a calculation. If it seems incorrect, edit the $ Amount or Frequency.
Submit Microsoft® Excel® document to the Assignment Files tab.
2. How does compounding interest differ from present and future value?
For questions 3 – 5, use the Bankrate Compound Interest Calculator http://www.bankrate.com/calculators/savings/compound-savings-calculator-tool.aspx and input provided figures, changing the interest rate and the compounding of the interest rate (annually, semiannually, and quarterly) as delineated below:
3. You place $1,500 in a savings account earning 3% interest compounded annually. How much will you have at the end of four years? How much would you have at the end of four years if interest is compounded quarterly?
4. Change the interest rate to a higher rate. How much will you have at the end of four years if interest is compounded annually at a rate of 5%? How much would you have at the end of four years if interest is compounded quarterly?
5. Now change the interest rate to a lower rate. How much will you have at the end of four years if interest is compounded annually at a rate of 2.5%? How much would you have at the end of four years if interest is compounded quarterly?
Submit your responses in a Microsoft Word document.
