1. Review the information on the Smith family's current savings provided on their balance sheet on page 499 of your textbook,Biblical Financial Planning: A Biblical Worldview of Personal Finance.Please note:
2. "Taxable Investments" represent their existing college savings, and the IRA and 401K accounts together represent their retirement savings.
3. Bob's stated goal is to retire after only working one more year.
4. Read and consider the Case Study Analysis presented at the end of Chapter 15 in your textbook,(page 383).
5. Using the5.5 Retirement Income and College Savings Spreadsheet Template,create analysis of the Smith family's projected retirement income and an analysis of their ability to meet their college savings goals.
6. Using the5.5 Long-Term Financial Goal Analysis Template, provide your evaluation of the Smith family's ability to meet these two goals, and then recommend actions they can take or options they may want to consider to better meet these goals.

Case Study Analysis Dropbox 5.5 Long-Term Financial Goal Analysis Template BUS-150 Personal Finance Student Name: Type name here Submission Date: Type date here Instructions: Provide a thoughtful 50-100 word response to each of the questions below. Can the Smith family and its members reach their retirement account income goal, using their current plan? Why or why not? What actions would you recommend the Smith family and its members take in order to better meet their retirement savings goals? Can the Smith family and its members reach their college savings goals, using their current plan? Why or why not? What actions would you recommend the Smith family and its members take in order to better meet their college savings goals? Instructions: 1. Save a copy of this file! Include your last name and the assignment in the file name, like "Kendall_D 2. Using the information from your analysis of the case study, complete all the Start at the top of the Retirement worksheet tab and complete each section Input cells are highlighted in green. Like this! You should input inform Also, do not try to modify cells that are not input cells. Modifying cells Green means "go"... You should input your information in the green cells. Titles and calculated cells are highlighted in aqua. Like this! The calculated annual retirment account income will be highlighted in orang 3. Using the information from your analysis of the case study, complete all the The ending balance of the college savings account will be highlighted in ora There should be no need to modify any of the worksheets included in this sp 4. Once complete, submit this file, along with your Word document responses ame, like "Kendall_Dropbox5-5.xls" udy, complete all the input fields shown on the Retirement worksheet tab below. mplete each section sequentially. u should input information only in the green cells. lls. Modifying cells that are not input cells may corrupt the spreadsheet's formulas and pr in the green cells. However, depending on your analysis, you may not need to fill in every input c highlighted in orange. Like this! This number should be compared to the target income. udy, complete all the input fields shown on the College worksheet tab. be highlighted in orange. Like this! A negative number indicates a failed savings plan. ets included in this spreadsheet. Simply fill in the input cells appropriately. ocument responses to the Case Study questions, to your instructor using the Dropbox by the end et's formulas and prevent you from completing your analysis. d to fill in every input cell. o the target income. d savings plan. e Dropbox by the end of the Workshop. Retirement Account Income Planner Existing Retirement Account Balances Account Balance ($) IRA 401k Other Total $0.00 Expected annual return of retirement accounts: Savings Rates Annual Salary Annual Savings ($) Monthly Savings ($) Cap on Employer Match (%) Employer Monthly Match ($) Total Monthly Savings ($) $0.00 of Annual Salary #DIV/0! #DIV/0! Years Until Retirement: Retirement Account Balance at Retirement: #DIV/0! Expected Years in Retirement: Income from Retirement Accounts: Monthly Income Annual Income #DIV/0! #DIV/0! *Note this is only retirement account income. It does not include Social Security or any other *Note these numbers are not inflation adjusted. ial Security or any other sources of retirement income. College Savings Planner Data on Children Name Years until College Total Scholarships (all years) Savings Data Existing Savings Balance: Monthly College Savings: Investment Rate of Return: Assumed Rate of Tuition Inflation: Savings Analysis.... Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Beginning Account Balance $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 $0.00 $0.00 22 23 24 25 $0.00 $0.00 $0.00 $0.00 Annual Tuition (per year) 0 $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 $0.00 $0.00 Planned Years in College 0 $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 $0.00 $0.00 0 $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 $0.00 $0.00 0 $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 $0.00 $0.00 0 $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 $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 $0.00 $0.00 Total Withdrawals $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 $0.00 $0.00 Ending Account Balance $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00