for charandry only
PROFESSOR CALLEN
AB104_Financial_Plan_Workbook_Master.xlsxU1 1.1 Daily Spending Log
| Daily Spending Log- Unit 1 | |||||||||||||
| Directions: Please record every penny you spend each day, beginning no later than Thursday (the second day of this class) and ending Monday (the day before the unit ends). Your daily spending log for week two will begin the following day (Tuesday). Place the amount you have spent in the categories provided below. Additional categories can be added in columns J and K. Make sure you record cash spent and credit card charges. If you have more than one transaction for the same category, total the amounts spent and add it to the appropriate cell in this worksheet. The total expenditures in column M will automatically compute for each day. Explain daily expenditures in the comments section in column N. If your entire comment does not appear in column N, double-click on the row dividing line to automatically enlarge the cell to fit the text. Provide a brief summary of your expenditures for week one in row 16. Identify categories within your daily spending log that could be reduced to decrease the total amount of your spending. Please save this spreadsheet each time you add information. When you are ready to submit, save your workbook by clicking the Office button at the top of your spreadsheet then click Save As. Name the file Username-AB104 Financial Plan Workbook Unit#.xlsx (Example: TAllen- AB104 Financial Plan Workbook Unit1.xlsx). | |||||||||||||
| Week 1: Enter the spending log dates below. | |||||||||||||
| (Enter date started here) | |||||||||||||
| Date | Day of week | Auto | Food (H) Home (S) Self | Health, Personal Care | Education | Recreation Leisure | Donations | Laundry | Add Category | Add Category | Other | Total Spent | Comments: |
| Wednesday | $0.00 | ||||||||||||
| Thursday | $0.00 | ||||||||||||
| Friday | $0.00 | ||||||||||||
| Saturday | $0.00 | ||||||||||||
| Sunday | $0.00 | ||||||||||||
| Monday | $0.00 | ||||||||||||
| Running Total: | $0.00 | ||||||||||||
| Summary - Answer the two summary questions below. | |||||||||||||
| 1. Provide a brief summary of your expenditures for week one. | |||||||||||||
| 2. Identify categories within your daily spending log that could be reduced to decrease the total amount of your spending. | |||||||||||||
U2 1.2 Daily Spending Log
| Daily Spending Log- Unit 2 | |||||||||||||
| Directions: Please record every penny you spend each day, beginning Tuesday (the last day of Unit 1) and ending Monday (the day before the unit ends). Your daily spending log for week three will begin the following day (Tuesday). Place the amount you have spent in the categories provided below. Additional categories can be added in columns J and K. Make sure you record cash spent and credit card charges. If you have more than one transaction for the same category, total the amounts spent and add it to the appropriate cell in this worksheet. The total expenditures in column M will automatically compute for each day. Explain daily expenditures in the comments section in column N. If your entire comment does not appear in column N, double-click on the row dividing line to automatically enlarge the cell to fit the text. Provide a brief summary of your expenditures for week two and answer each question posted below. Please save this spreadsheet each time you add information. When you are ready to submit, save your workbook by clicking the Office button at the top of your spreadsheet then click Save As. Name the file Username-AB104 Financial Plan Workbook Unit#.xlsx (Example: TAllen- AB104 Financial Plan Workbook Unit1.xlsx) | |||||||||||||
| Week 2: Enter the spending log dates below. | |||||||||||||
| (Enter date started here) | |||||||||||||
| Date | Day of week | Auto | Food (H) Home (S) Self | Health, Personal Care | Education | Recreation Leisure | Donations | Laundry | Add Category | Add Category | Other | Total Spent | Comments: |
| Tuesday | $0.00 | ||||||||||||
| Wednesday | $0.00 | ||||||||||||
| Thursday | $0.00 | ||||||||||||
| Friday | $0.00 | ||||||||||||
| Saturday | $0.00 | ||||||||||||
| Sunday | $0.00 | ||||||||||||
| Monday | $0.00 | ||||||||||||
| Running Total: | $0.00 | ||||||||||||
| Summary - Answer the three summary questions below. | |||||||||||||
| 1. Provide a brief summary of your expenditures for week two. | |||||||||||||
| 2. What information from your daily spending log might encourage you to reconsider various money management actions? | |||||||||||||
| 3. How can your daily spending log assist you when planning and implementing a budget? | |||||||||||||
U2 2.1 Personal Financial Goals
| Unit 2: Worksheet 2.1 Personal Financial Goals | ||||||
| Setting goals for your financial future is an important step in the financial planning process. This sheet can be used to help you plan for your financial success. This worksheet is divided into three separate areas: * Short-term goals are goals to be obtained in one year or less. * Intermediate goals are goals which are obtainable in two to five years. * Long-term goals are goals which is obtainable after five years. Steps: 1. Place each goal in the appropriate area and indicate the priority, expected date of completion, and the estimate of cost each week. Provide goal comments in column G. 2. Once completed, make sure you carry over the monthly costs for your investments to your U2 2.2 Personal Annual Budget worksheet. | ||||||
| Worksheet 2.1 Personal Financial Goals Worksheet AB104 | ||||||
| Name: | ||||||
| Date: | ||||||
| Short-Term Goals (1 year or less) | ||||||
| Goal | Priority | Expected Date of Completion | Estimate of Cost/Week | Estimate of Cost/Month | Estimate of Cost/Year | Comments |
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| Intermediate-Term Goals (2 to 5 years) | ||||||
| Goal | Priority | Expected Date of Completion | Estimate of Cost/Week | Estimate of Cost/Month | Estimate of Cost/Year | Comments |
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| Long-Term Goals (6 + years) | ||||||
| Goal | Priority | Expected Date of Completion | Estimate of Cost/Week | Estimate of Cost/Month | Estimate of Cost/Year | Comments |
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
| $0.00 | $0.00 | |||||
U2 2.2 Personal Annual Budget
| Unit 2: Worksheet 2: Personal Annual Budget | |||||||||||||
| A budget is a forecast of your income and expenses and is very important to insure a secure financial future. A budget is a specific plan for spending income which is also called a spending plan. Steps: 1. Enter your estimated income for each month in rows 5 through 8. 2. Navigate through the categories and enter any expenses you think you may have in the upcoming year. Please remember to include the auto or life insurance premiums. 3. The totals category (row 8, 19, 28, 37, 44, 54, 63, 70, 80, 88, 96, 104) will indicate how much money you will spend in each category by month. 4. Your total expenses will display in row 106. 5. Your surplus or deficit of money available will be displayed in row 107. This is computed by deducting your total expenses from your total income. 6. Once you have completed your budget for the year, go to worksheet "U2 2.3 Questions" and answer the questions. | |||||||||||||
| Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | Year | |
| INCOME | |||||||||||||
| Wages | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Interest/dividends | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Miscellaneous | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Income totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| EXPENSES | |||||||||||||
| Home | |||||||||||||
| Mortgage/rent | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Utilities | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Home telephone | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Cellular telephone | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Home repairs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Home improvement | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Home security | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Garden supplies | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Home totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Daily living | |||||||||||||
| Groceries | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Child care | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Dry cleaning | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Dining out | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Housecleaning service | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Dog walker | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Daily living totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Transportation | |||||||||||||
| Gas/fuel | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Insurance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Repairs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Car wash/detailing services | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Parking | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Public transportation | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Transportation totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Entertainment | |||||||||||||
| Cable TV | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Video/DVD rentals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Movies/plays | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Concerts/clubs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Entertainment totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Health | |||||||||||||
| Health club dues | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Insurance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Prescriptions | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Over-the-counter drugs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Co-payments/out-of-pocket | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Veterinarians/pet medicines | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Life insurance | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Health totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Vacations | |||||||||||||
| Plane fare | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Accommodations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Food | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Souvenirs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Pet boarding | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Rental car | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Vacations totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Recreation | |||||||||||||
| Gym fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Sports equipment | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Team dues | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Toys/child gear | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Recreation totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Dues/subscriptions | |||||||||||||
| Magazines | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Newspapers | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Internet connection | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Public radio | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Public television | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Religious organizations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Charity | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Dues/subscription totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Personal | |||||||||||||
| Clothing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Gifts | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Salon/barber | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Books | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Music (CDs, etc.) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Personal totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Financial obligations | |||||||||||||
| Long-term savings | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Retirement (401k, Roth IRA) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Credit card payments | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Income tax (additional) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other obligations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Financial obligation totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Misc. payments | |||||||||||||
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Misc. payments totals | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total expenses | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Cash short/extra | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
U2 2.3 Questions
| Unit 2: Worksheet 3: Questions |
| Sometimes unexpected events happen in our lives, and our cash flow is affected. Do you have a plan in place? Answer the following questions. |
| 1. What would you do if you suddely lost your job and had no income? |
| 2. How long would you be able to survive finacially? |
| 3. Discuss the importance of having a financial plan. |
| 4. What could be the long-term effects from this situation? |
U3 1.3 Daily Spending Log
| Daily Spending Log- Unit 3 | |||||||||||||
| Directions: Please record every penny you spend each day, beginning Tuesday (the last day of Unit 2) and ending Monday (the day before the unit ends). At the end of this unit ,your daily spending log will provide a summary of three weeks of total expenditures. Place the amount you have spent in the categories provided below. Additional categories can be added in columns J and K. Make sure you record cash spent and credit card charges. If you have more than one transaction for the same category, total the amounts spent and add it to the appropriate cell in this worksheet. The total expenditures in column M will automatically compute each day. Explain daily expenditures in the comments section in column N. If your entire comment does not appear in column N, double-click on the row dividing line to automatically enlarge the cell to fit the text. Provide a brief summary of your expenditures for week three and answer each question posted below. Please save this spreadsheet each time you add information. When you are ready to submit, save your workbook by clicking the Office button at the top of your spreadsheet then click Save As. Name the file Username-AB104 Financial Plan Workbook Unit#.xlsx (Example: TAllen- AB104 Financial Plan Workbook Unit1.xlsx) | |||||||||||||
| Week 3: Enter the spending log dates below. | |||||||||||||
| (Enter date started here) | |||||||||||||
| Date | Day of week | Auto | Food (H) Home (S) Self | Health, Personal Care | Education | Recreation Leisure | Donations | Laundry | Add Category | Add Category | Other | Total Spent | Comments: |
| Tuesday | $0.00 | ||||||||||||
| Wednesday | $0.00 | ||||||||||||
| Thursday | $0.00 | ||||||||||||
| Friday | $0.00 | ||||||||||||
| Saturday | $0.00 | ||||||||||||
| Sunday | $0.00 | ||||||||||||
| Monday | $0.00 | ||||||||||||
| Running total: | $0.00 | ||||||||||||
| Summary - Answer the three summary questions below. | |||||||||||||
| 1. Provide a brief summary of your expenditures for week three. | |||||||||||||
| 2. Are there any banking fees that you encounter each month? What actions might be taken to reduce or eliminate these cash outflows? | |||||||||||||
| 3. What other areas of your daily spending might be reduced or revised? | |||||||||||||
U3 3.1 Balance Sheet
| Unit 3: Worksheet 1: Balance Sheet | ||||
| The personal balance sheet is a summary of your assets (what you own), your liabilities (what you owe), and your net worth (assets minus liabilities). Steps: 1. List the value of your assets according to the categories in column B of the worksheet. 2. List the value of your liabilities according to the categories in column E of the worksheet. 3. The net worth is calculated and displayed in cell E34. *Net worth = total assets (B37) minus total liabilities (E32) *Total assets = total liabilities (E32) + net worth (E34) | ||||
| Balance Sheet | ||||
| Liquid Assets | Current Liabilities | |||
| Cash on hand | $0.00 | Utlities | $0.00 | |
| Checking accounts | $0.00 | Rent | $0.00 | |
| Savings account | $0.00 | Insurance premiums | $0.00 | |
| Money market accounts | $0.00 | Taxes | $0.00 | |
| Certificate of deposit | $0.00 | Medical/dental bills | $0.00 | |
| Short term investments | $0.00 | Repair bills | $0.00 | |
| Total Liquid Assets | $0.00 | Bank Credit Card bills | $0.00 | |
| Store Credit Card bills | $0.00 | |||
| Real Property | Travel/entertainment bills | $0.00 | ||
| Primary Residence | $0.00 | Gas credit cards | $0.00 | |
| Second Home | $0.00 | Bank line of credit | $0.00 | |
| Other | $0.00 | Other liabilities | $0.00 | |
| Total Real Property | $0.00 | Other liabilities | $0.00 | |
| Total Current Liabilities | $0.00 | |||
| Investments | ||||
| Stocks | $0.00 | Long-term Liabilities | ||
| Bonds | $0.00 | Mortgage | $0.00 | |
| Mutual Funds | $0.00 | Second Mortgage | $0.00 | |
| Retirement Fund, IRA | $0.00 | Investment mortgage | $0.00 | |
| Other | $0.00 | Auto Loans | $0.00 | |
| Total investment Assets | $0.00 | Home improvement loan | $0.00 | |
| Single-payment loans | $0.00 | |||
| Personal Property | Student loans | $0.00 | ||
| Auto | $0.00 | Other long term loans | $0.00 | |
| Auto | $0.00 | Other long term loans | $0.00 | |
| Recreation Vehicles | $0.00 | Total Long- term Liabilities | $0.00 | |
| Household furnishings | $0.00 | |||
| Jewelry and artwork | $0.00 | Total Liabilities | $0.00 | |
| Other | $0.00 | |||
| Other | $0.00 | Net Worth | $0.00 | |
| Total Personal Property | $0.00 | |||
| Total Assets | $0.00 | Total Liablities & Net Worth | $0.00 | |
U3 3.2Personal Income & Expense
| Unit 3: Worksheet 2: Personal Income and Expense Statement | |||
| A Personal Income and Expense Statement is a cash basis statement that shows the actual cash receipts and actual expenditures for a certain period of time. This statement includes all income and expenses for the month. Total income minus total expenses will provide you with your cash surplus or cash deficit. If your total income is greater than your total expenses, you will have a cash surplus. If your total income is less than your total expenses, you will have a cash deficit. Steps: 1. List all of your income. 2. List all of your expenses according to each category. 3. The cash surplus or cash deficit is automatically calculated in cell D59. Cash surplus/deficit formula: total Income (D20) minus total expenses (D57). | |||
| Name | |||
| For the period of | |||
| Income | |||
| Wages and Salaries | Name of Earner: | $0.00 | |
| Name of Earner: | $0.00 | ||
| Name of Earner: | $0.00 | ||
| Self-employment Income | $0.00 | ||
| Bonuses and Commissions | $0.00 | ||
| Investment Income | Interest received | $0.00 | |
| Dividend received | $0.00 | ||
| Rents received | $0.00 | ||
| Sale of Securities | $0.00 | ||
| Other | $0.00 | ||
| Other | $0.00 | ||
| Pensions and Annuities | $0.00 | ||
| Other Income | $0.00 | ||
| TOTAL INCOME | $0.00 | ||
| Expenses | |||
| Housing | Rent/Mortgage payment | $0.00 | |
| Repairs, maintnenace, improvements | $0.00 | ||
| Utilities | Gas | $0.00 | |
| Electric | $0.00 | ||
| Water | $0.00 | ||
| Phone | $0.00 | ||
| Cable | $0.00 | ||
| Other | $0.00 | ||
| Food | Groceries | $0.00 | |
| Dining Out | $0.00 | ||
| Transportation | Auto Loan Payments | $0.00 | |
| Licenses plates, fees | $0.00 | ||
| Gas, oil, tires, repairs | $0.00 | ||
| Medical | Health major medical, insurance | $0.00 | |
| Doctor | $0.00 | ||
| Dentist | $0.00 | ||
| Medicines | $0.00 | ||
| Clothing | Clothes shoes, accessories | $0.00 | |
| Insurance | Homeowner's | ||
| Life Insurance | $0.00 | ||
| Auto Insurance | $0.00 | ||
| Taxes | Income and Social Security | $0.00 | |
| Property (if not included in mortgage) | $0.00 | ||
| Credit Cards | Loan payments | $0.00 | |
| Major purchases | Loan payments | $0.00 | |
| Repairs & maintnenance | $0.00 | ||
| Personal Care | cosmetics, hair care etc. | $0.00 | |
| Other | $0.00 | ||
| Entertainment | Vacations | $0.00 | |
| other | $0.00 | ||
| Other Items | student loan payments | $0.00 | |
| Gifts | $0.00 | ||
| Charitable contributions | $0.00 | ||
| TOTAL EXPENSES | $0.00 | ||
| Cash Surplus (or Deficit) | $0.00 | ||
U4 4.1 Mortgage Refinance
| Unit 4: Worksheet 1: Mortgage Refinance Analysis | |||||||
| This worksheet will assist you in making the decision to re-finance your current mortgage or not. It will look at the savings you may receive if you refinance you existing mortgage. Steps: | |||||||
| 1. Enter your current monthly payment. | |||||||
| 2. To find out what the new payment amount will be go to http://www.bankrate.com. Click on “mortgage rates” and enter your state and your city. Enter amount to be refinanced and the length of loan. This will give you different banks in the area with their rates and the payment amount. Enter the payment amount on line 2. | |||||||
| 3. Pre-tax savings on monthly payment will be automatically calculated (H12 - H13). | |||||||
| 4. Calculate the taxes on your monthly savings. Even though you may be saving money with the refinance, it will result in more taxable income. Determine your income tax bracket in cell H16. If you do not know your income tax bracket go to: https://www.efile.com/tax-service/tax-calculator/tax-brackets/ : Enter the year and your filing status. Then locate your gross income amount and your income tax bracket. | |||||||
| 5. The monthly savings after tax will be automatically calculated in cell H17. | |||||||
| 6. Enter the costs to refinance your mortgage. Check your mortgage papers or lender’s policy to find the prepayment penalty. | |||||||
| 7. The months to breakeven are automatically calculated in cell H22. This is calculated by taking the total refinancing costs (H21) and dividing it by your monthly savings after tax (H17). | |||||||
| Item | Description | Amount | |||||
| 1 | Current monthly payment | $0.00 | |||||
| 2 | New monthly payment | $0.00 | |||||
| 3 | Monthly savings, pretax (Item 1 - Item 2) | $0.00 | |||||
| 4 | Income Tax Bracket (Enter as decimal) | 0% | |||||
| Tax on monthly savings (Item 3 x Item 4) | $0.00 | ||||||
| 5 | Monthly savings, after-tax (Item 3 - Item 4) | $0.00 | |||||
| 6 | Costs to refinance: | ||||||
| a. | Prepayment penalty | $0.00 | |||||
| b. | Total closing costs (after tax) | $0.00 | |||||
| c. | Total refinancing costs (Item 6a + 6b) | $0.00 | |||||
| 7 | Months to breakeven (Item 6c/Item 5) | ERROR:#DIV/0! | |||||
U4 4.2 Home Affordability
| Unit 4: Worksheet 2: Home Affordability Analysis | |||
| Directions: There are nine items to fill in on this sheet. Item 1 (Include all income) Item 3 (An average lender's affordability ratio has been provided. This can range from 28 to 33 percent depending on lender.) Item 5 (Do some research on houses in your area to determine the combined monthly tax and insurance payment.) Item 7 (research for current interest rates) Item 8 (determine the number of years for loan. This is usually 15 or 30). Item 9 (Find this value by using Item 7 and Item 8 and Table of Monthly Mortgage Payments (below).) Item 11 (How much do you have available for a downpayment?) | |||
| Name: | Date: | ||
| Item | Description | Amount | |
| 1 | Amount of annual income | ||
| 2 | Monthly income (Item 1 divided by 12) | ||
| 3 | Average lender's affordabilitiy ratio | 30% | |
| 4 | Maximum monthly mortgage payment (PITI) | $0.00 | |
| 5 | Estimated monthly property tax and homeowner's insurance payment | $0.00 | |
| 6 | Maximum monthly loan payment (Item 4-Item 5) | $0.00 | |
| 7 | Approximate average interest rate on loan | ||
| 8 | Planned loan maturity (years) | ||
| 9 | Mortgage payment per $1000 | ||
| 10 | Maximum loan based on monthly income $10,000 x (Item 6 divided by Item 9) | ERROR:#DIV/0! | |
| 11 | Funds available for making a down payment (Note: Closing costs are separate from down payment and should be considered when purchasing a home) | ||
| 12 | Maximum purchase price based on available monthly income | ERROR:#DIV/0! | |
| Table of Monthly Mortgage Payments | |||
| Using the Table of Monthly Mortgage Payment (left side) | |||
| Instructions: 1. Find the interest rate in the first column for your loan. 2. Locate the value that corresponds to the length of your loan. 3. Place this number in Line 9 of this worksheet. | |||
U5 5.1 How's My Credit
| Unit 5: Worksheet 1: How's My Credit? | ||||||||||
| This worksheet will help you to determine your debt safety ratios. It indicates the amount of debt you have compared to your income. The debt safety ratio will indicate the percentage of your monthly income that is attributed to debt (what you owe). When completing this worksheet, you will use your monthly income and your total monthly debt to calculate your debt ratio. Steps: -Enter your monthly loan payments and take home pay. -The debt safety ratio will automatically calculated by taking your total monthly payments and dividing it by your total monthly take home pay. That amount will be multiplied by 100. We use 100 because we are looking for a percentage. - Example: $1500 (total Monthly payments / $4,500 (monthly take-home pay) x 100 = 33.33% this will be your debt ratio. - This example indicates that you spend 33% of your income for debt each month. If you want to lower your debt follow these steps: - Determine the rate you would like your debt ratio to be. - If you want this calculated on your current income use that figure then multiply this amount by the new target debt ratio. This will give you the new monthly amount you must pay to reduce your ratio. **Note: The final figure will tell you how much you will need to pay additionally on your debt each month to achieve your desired debt ratio. | ||||||||||
| Monthly Consumer Loan Payments & Debt Safety Ratio | ||||||||||
| Name: | Date: | |||||||||
| Type of Loan | Lender | Current monthly or minimum payment | ||||||||
| Auto and personal Loans | 1 | $0.00 | Note: Only use those loans that require regular montly payments | |||||||
| 2 | $0.00 | |||||||||
| 3 | $0.00 | |||||||||
| Education loans | 1 | $0.00 | ||||||||
| 2 | $0.00 | |||||||||
| 3 | $0.00 | |||||||||
| Overdraft protection line | 1 | $0.00 | ||||||||
| 2 | $0.00 | |||||||||
| Personal line of credit | $0.00 | |||||||||
| Credit cards | 1 | $0.00 | ||||||||
| 2 | $0.00 | |||||||||
| 3 | $0.00 | |||||||||
| 4 | $0.00 | |||||||||
| Home equity line of credit | 1 | $0.00 | ||||||||
| TOTAL MONTHLY PAYMENTS | $0.00 | |||||||||
| Monthly take home pay | 1 | $0.00 | ||||||||
| 2 | $0.00 | |||||||||
| TOTAL MONTHLY TAKE-HOME PAY | $0.00 | |||||||||
| Debt Safety Ratio: | ||||||||||
| Total monthly payments/Total monthly take-home pay x 100 | ERROR:#DIV/0! | |||||||||
| Changes needed to reach a new debt safety ratio | ||||||||||
| 1. New (target) debt safety ratio: | 0% | |||||||||
| 2.Use monthly take-home pay x Target debt ratio** | $0.00 | |||||||||
U5 5.2 Tracking Consumer Debt
| Unit 5: Worksheet 2: Tracking Your Consumer Debt | ||||||||
| This worksheet will keep you updated on how much debt you currently have. You will list all your debts (money you owe) and their current balances. This will be a good tracking tool for your debt and will need to be updated frequently. | ||||||||
| Date: | ||||||||
| Current Monthly Payment* | Latest Balance Due | |||||||
| Type of Consumer Debt | Creditor | Creditor Name | ||||||
| Auto Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| 3 | $0.00 | $0.00 | ||||||
| Education Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| Personal Installment Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| Home Improvement Loan | $0.00 | $0.00 | ||||||
| Other Installment Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| Single Payment Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| Credit Cards (retail charge cards, bank cards, etc) | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| 3 | $0.00 | $0.00 | ||||||
| 4 | $0.00 | $0.00 | ||||||
| 5 | $0.00 | $0.00 | ||||||
| 6 | $0.00 | $0.00 | ||||||
| 7 | $0.00 | $0.00 | ||||||
| Overdraft protection Line | $0.00 | $0.00 | ||||||
| Personal Line of Credit | $0.00 | $0.00 | ||||||
| Home equity creditline | $0.00 | $0.00 | ||||||
| loan on life insurance | $0.00 | $0.00 | ||||||
| Margin loan from broker | $0.00 | $0.00 | ||||||
| Other Loans | 1 | $0.00 | $0.00 | |||||
| 2 | $0.00 | $0.00 | ||||||
| TOTALS | $0.00 | $0.00 |
U6 6.1 Life Insurance Needs
| Unit 6: Worksheet 1: Life Insurance Needs | |||||||||
| This worksheet will assist you to determine the amount of life insurance coverage you will need to help your family financially upon your death. It uses the money which will be available, as well as the total expenses incurred at your time of death, and the debt you will owe. | |||||||||
| Yourself | Your Spouse | ||||||||
| A. Costs at death | |||||||||
| 1. Uninsured medical expenses (deductible and copay) | $0.00 | $0.00 | |||||||
| 2. Funeral expense (average $10,000, but less for cremation) | $0.00 | $0.00 | |||||||
| 3. Settlement of estate (estimate 4% of assets) | $0.00 | $0.00 | |||||||
| 4. State inheritance taxes (if any) | $0.00 | $0.00 | |||||||
| 5. Counseling costs for adjustment to loss | $0.00 | $0.00 | |||||||
| Total costs at death | $0.00 | $0.00 | |||||||
| B. Lump Sums | |||||||||
| 6. Outstanding debts | |||||||||
| a. Mortgage | $0.00 | $0.00 | |||||||
| b. Car loan(s) | $0.00 | $0.00 | |||||||
| c. Credit cards and other loans | $0.00 | $0.00 | |||||||
| Total outstanding debt to repay | $0.00 | $0.00 | |||||||
| 7. Education costs for children or spouse | $0.00 | $0.00 | |||||||
| 8. Spouse retirement fund | $0.00 | $0.00 | |||||||
| 9. Household emergency fund (Monthly household expenses X 3) | $0.00 | $0.00 | |||||||
| Total lump sum needs | $0.00 | $0.00 | |||||||
| C. Cost of Household Maintenance | |||||||||
| 10. Deceased annual after-tax income | $0.00 | $0.00 | |||||||
| 11. Annual cost of lost support services (child care, eldercare, housekeeping) | $0.00 | $0.00 | |||||||
| 12. Reduction in family expenses due to death (estimated 20–25%) | $0.00 | $0.00 | |||||||
| 13. Annual Social Security survivor benefits | $0.00 | $0.00 | |||||||
| 14. Net income shortfall | $0.00 | $0.00 | |||||||
| Total household maintenance fund needs | |||||||||
| Line 14 x Number of years to replace | Years = | 0 | $0.00 | $0.00 | |||||
| 15. Total fund needed values) | $0.00 | $0.00 | |||||||
| D. Available Resources to Meet Needs | |||||||||
| 16. Total savings and investments | $0.00 | $0.00 | |||||||
| 17. Group life insurance | $0.00 | $0.00 | |||||||
| 18. Social security lump sum benefit | $0.00 | $0.00 | |||||||
| 19. Total resources to meet needs | $0.00 | $0.00 | |||||||
| Total life insurance needs | $0.00 | $0.00 | |||||||
U7 7.1 Stock Trader
| Unit 7: Worksheet 7.1 Stock Trader | |||||
| Directions: You are given $10,000 to invest in the stock market. You are to pick stock of your choice. No more than three different stocks and you must invest the whole $10,000. You will enter your stock name, symbol, the date, the price and the total number of shares purchased. Each week you will check your stock and record the current market value. In the comment section you will note any changes and the possible reasons for the change. You will do this during all units between starting with Unit 2 and ending with Unit 7. | |||||
| Section A: In this area you will record your initial Purchase of the stock. | |||||
| Stock name | Stock 1 | Stock 2 | Stock 3 | ||
| Date | |||||
| Symbol | |||||
| Purchase Price | |||||
| # of shares | |||||
| Total Investment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Section B: In this area you will record your weekly market value of your stock. | |||||
| Date | Current Price Stock 1 | Current Price Stock 2 | Current Price Stock 3 | ||
| Unit 3 | |||||
| Unit 4 | |||||
| Unit 5 | |||||
| Unit 6 | |||||
| Unit 7 | |||||
| Section C: This calculates the amount of investment per week based on current week stock price and number of shares. | |||||
| Date | Current Price Stock 1 | Current Price Stock 2 | Current Price Stock 3 | Total Investment Each Week | |
| Unit 3 | 12/31/99 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Unit 4 | 12/31/99 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Unit 5 | 12/31/99 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Unit 6 | 12/31/99 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Unit 7 | 12/31/99 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Gain or loss | $ - 0 | ||||
| Section D: In this section you will record comments from each unit and answer the 4 questions below. | |||||
| Comments: | |||||
| Unit 2 | |||||
| Unit 3 | |||||
| Unit 4 | |||||
| Unit 5 | |||||
| Unit 6 | |||||
| Unit 7 | |||||
| 1. What economic issues affected your decisions to purchase the stock? | |||||
| 2. How will the current market value of your stock affect your finances? | |||||
| 3. How can any furutre investment you make affect your financial plan? | |||||
| 4. How will your financial plan help your with any future investments for your personal wealth? | |||||
U8 8.1 Retirement Needs
| Unit 8: Worksheet 1: Retirement Needs | ||
| Directions: It is important for you to understand and know what your current financial needs and your future needs at retirement. To complete this worksheet you will fill in the various categories that pertain to your situation for now and later. You will need to include all income and expenses for both now and at retirement. You will use your monthly averages for both income and expenses. For your monthly income at retirement you will use the 5% inflation factor from worksheet 8.2 based on your number of years until retirement. Enter the factor in cell F3 to see the calculations of income categories needed at retirement based on this 5% inflation factor. | ||
| MONTHLY INCOME | ||
| NOW | RETIREMENT | |
| Salary (including spouse) | $ - 0 | |
| Commissions, Bonuses, Tips | $ - 0 | |
| Interest, Dividends | $ - 0 | |
| Social Security | $ - 0 | |
| Rental Income | $ - 0 | |
| Pensions | $ - 0 | |
| Annuities | $ - 0 | |
| Veterans Benefits | $ - 0 | |
| Other Income | $ - 0 | |
| TOTAL INCOME (A) | $ - 0 | $ - 0 |
| MONTHLY EXPENSES | ||
| NOW | RETIREMENT | |
| Housing | ||
| Mortgage | $ - 0 | |
| Property Tax | $ - 0 | |
| Homeowner’s Insurance | $ - 0 | |
| Rent | $ - 0 | |
| Utilities | $ - 0 | |
| Maintenance Fees | $ - 0 | |
| Food | ||
| Groceries | $ - 0 | |
| Dining Out | $ - 0 | |
| Transportation | ||
| Vehicle Maintenance | $ - 0 | |
| Fuel | $ - 0 | |
| Auto Insurance | $ - 0 | |
| Public Transportation | $ - 0 | |
| Health Care | ||
| Medical Services | $ - 0 | |
| Medications and supplies | $ - 0 | |
| Health Insurance | $ - 0 | |
| Personal Insurance | ||
| Life Insurance | $ - 0 | |
| Disability Insurance | $ - 0 | |
| Long-term insurance | $ - 0 | |
| Other insurance | $ - 0 | |
| Personal expenses | ||
| Clothing | $ - 0 | |
| Products and services | $ - 0 | |
| Miscellaneous Expenses | ||
| Loans and Credit cards | $ - 0 | |
| Travel or vacation | $ - 0 | |
| Hobbies | $ - 0 | |
| Gifts | $ - 0 | |
| Education | $ - 0 | |
| Charitable Contributions | $ - 0 | |
| Other | $ - 0 | |
| TOTAL MONTHLY EXPENSES (B) | $ - 0 | $ - 0 |
| Retirement Needs: | ||
| NOW: A - B =surplus or (deficit) | $ - 0 | |
| Retirement: A - B =Surplus or (deficit) | $ - 0 | |
| Answer the following questions regarding your calculations: | ||
| 1. What have you learned from completing your retirment calculations? | ||
| 2. Are there adjustments you need to make now? Or later? | ||
| 3. What changes will you have to make in order to retire comfortably? | ||
| 4. Has there been a change in your financial outlook for the future? | ||
U8 8.2 Inflation Table
| Unit 8: Worksheet 8.2 Inflation Table | |
| Directions: To determine future income (in dollars) you go to the number of years before retirement and locate the factor. Mulitiply the factor times the income amount in your 8.1 Retirement Needs Calculator worksheet. | |
| Years until Retirement | 5% Inflation Factor |
| 10 | 1.63 |
| 11 | 1.71 |
| 12 | 1.8 |
| 13 | 1.89 |
| 14 | 1.98 |
| 15 | 2.08 |
| 16 | 2.18 |
| 17 | 2.29 |
| 18 | 2.41 |
| 19 | 2.53 |
| 20 | 2.65 |
| 21 | 2.79 |
| 22 | 2.93 |
| 23 | 3.07 |
| 24 | 3.23 |
| 25 | 3.39 |
| 26 | 3.56 |
| 27 | 3.73 |
| 28 | 3.92 |
| 29 | 4.12 |
| 30 | 4.32 |
