1. Conduct a SWOT analysis for Grant and Julie. Be sure to explain fully the specific strengths and weaknesses and why these are categorized this way as well as the opportunities and threats you predict could show up in their financial planning/life journey.
2. Currently, Julie is volunteering, but not working outside the home for pay. Discuss whether you see this as a strength or weakness for the family and be sure to offer clear reasoning for your answer.
3. How do you see the Scotts being affected by inflation? How will their income needs and spending change over the next 12 years projected until retirement as a result of the projected CPI?
4. Calculate the actual retirement income needed to keep the Scotts' on target with their goals? Do they currently make enough? Based on the expected changes in costs, will they be able to continue to meet their goals?
5. What changes would you suggest for the Scotts' to make in order to ensure they reach their goals?

Case Study: Grant and Julie Scott Today is January 1, 2016. Grant and Julie Scott have come to you, a financial planner, for help in developing a plan to accomplish their financial goals. From your initial meeting with the Scotts, you have gathered the following information. sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m PERSONAL BACKGROUND AND INFORMATION Grant Scott (Age 50) Grant is an executive with the Pelican Development Company (PDC), a closely held corporation. He has been employed by the company for 12 years and has a current annual salary of $100,000. Julie Scott (Age 47) Julie is a stay-at-home mom. She volunteers each afternoon at Meals-2-You, a charitable organization delivering dinners to the elderly in her community. The Scotts Grant and Julie have been married for 10 years. Grant has two children from a previous marriage, Sam and Justine; Grant and Julie have two children of their own, Abby and Katelyn. They have always lived in this community and expect to remain in their current residence indefinitely. Th Children and Grandchildren Sam is 24 years old. His date of birth is 1/1/1992. He and his wife, Cheryl, have a one-year old son, Stephen. Sam is an engineer for an international oil company. Justine is 18 years old. Her date of birth is 7/1/1997. She will be graduating from high school this year and attending State University in the fall. Justine lives with her mother, Sandra. Grant provided child support until Justine attained age 18. The $3,600 paid in 2015will not be an expense for 2016. Abby is 10 years old. Her date of birth is 10/1/2005. She attends Oak Tree Middle School and is cared for by her grandmother, Rose, after school. Katelyn is 4 years old and is developmentally disabled. Her date of birth is 9/10/2011. She is also cared for by Rose when Grant is at work and Julie is volunteering. PERSONAL AND FINANCIAL GOALS Pay for Justine's college education and save for Abby's college tuition and other expenses. Pay off all consumer debt by retirement and travel extensively afterwards. Review both Grant's and Julie's life insurance coverage. Prepare a proper estate plan, including any necessary documents. https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ 1 2 Case Study: Grant and Julie Scott Pay off the mortgage by retirement. Retire at age 62 with 75% of preretirement salary. ECONOMIC INFORMATION sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m The Scotts expect medical inflation to be 6% annually and the annual CPI to average 3% over both the short and long terms. The average annual interest rate on their credit cards is approximately 16%. Current mortgage rates are 6.0% for 30-year fixed mortgages and 5.5% for 15-year fixed mortgages. Closing costs will be approximately 3% of any mortgage refinanced and will be included as part of any new mortgage. Grant expects annual salary increases of 5% for the foreseeable future. INSURANCE INFORMATION Health Insurance The entire family is insured under Grant's company plan (an indemnity plan). The plan features a $500 deductible per family member with 80/20 major medical coverage and a $5,000 stop-loss limit. The plan does not have a lifetime coverage limit and provides preventive services without charging deductibles, co-payments, or coinsurance. Grant's employer pays the entire premium. Life Insurance Grant has a group term life insurance policy with a face amount of $50,000 provided by his employer. Julie is the sole beneficiary. Grant and Julie know that neither of them have adequate life insurance coverage, especially Grant as the family's main source of income. Disability Insurance Grant has a private own-occupation disability insurance policy with a 30-day elimination period. In the event Grant is disabled as defined under the policy, the benefit is $3,500 per month until age 65. Premiums are paid entirely by Grant's employer. Homeowners Insurance Th The Scotts have an HO-3 policy with dwelling extension and replacement cost on contents. The policy has a $500 deductible and an annual premium of $2,500. Automobile Insurance The Scotts have automobile bodily injury/property damage liability coverage with limits of $100,000/$300,000/$100,000. They have both comprehensive (other than collision) and collision coverage. The deductibles are $250 for comprehensive and $500 for collision. The annual premium is $1,400. INVESTMENT INFORMATION PDC offers a Section 401(k) plan in which Grant is an active participant. The company matches contributions dollar for dollar up to 3% of salary. Grant currently contributes 3% of his salary. The maximum contribution allowed by the plan is 16%. https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ Case Study: Grant and Julie Scott 3 INCOME TAX INFORMATION Grant and Julie tell you that they are in the 25% federal income tax bracket. They most recently paid $1,172 in state and city income taxes. RETIREMENT INFORMATION sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m Grant wants to retire at age 62 with an amount equal to 75% of his preretirement income. He expects to receive Social Security benefits of $30,000 (today's dollars) for himself and $15,000 (today's dollars) for Julie at full retirement age 67. They will receive 70% of the full retirement benefit at age 62. EDUCATION INFORMATION Justine attends a public high school and will be attending State University next fall. She has received a four-year academic scholarship that will pay full tuition but not expenses for room, board, and books, which will be about $12,000 for Justine's freshman year. The only funds saved for Justine's college education is a UTMA account with a value of $15,000. Abby is 10 years old and in the fifth grade at a private school. She will attend private school through high school. Grant and Julie have $1,450 in a savings account to which they contribute $750 each year for Abby. This account will be used for high school and is in Julie's name. Katelyn is four years old. Next year, she will attend a private elementary school for developmentally challenged children. Tuition will be paid by Rose, who invested the proceeds of her husband's $250,000 life insurance policy when he passed away five years ago. Due to Katelyn's disability, her parents are uncertain what type of education she will receive after elementary school. The current cost of college (including room, board, tuition, and books) is $20,000 per year per child. Grant and Julie expect Abby to start college at age 18. The Scotts expect an educational inflation rate of 5%. Th GIFTS, ESTATES, TRUSTS, AND WILL INFORMATION Grant's will, drafted six years ago, leaves everything to Julie conditioned on a six-month survivorship clause, otherwise, equally in separate trusts for Sam, Justine, and Abby. Julie does not have a will. https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ 4 Case Study: Grant and Julie Scott STATEMENT OF CASH FLOWS Grant and Julie Scott Statement of Cash Flows (Expected) for 2016 CASH INFLOWS SalaryGrant $100,000 Investment income Interest (taxable) $ 1,800 Dividends 300 Total investment income $ 2,100 Total cash inflows $102,100 CASH OUTFLOWS Planned savings Section 401(k) plan High school fund Total savings $ 1,500 sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m Partial reinvestment of interest/dividends 3,000 750 $ 5,250 Ordinary living expenses Food $ 6,500 Utilities 4,200 Travel and Entertainment 5,200 Auto maintenance 1,800 Clothing 3,000 Church contributions 7,000 Total ordinary living expenses Other payments Mortgage Automobile loan Credit cards Personal loan $27,700 $28,540 3,840 4,000 2,010 Total payments Insurance premiums Automobile Homeowners $38,390 $ 1,400 2,500 $ 3,900 Th Total insurance premiums Tuition and education expenses - Abby Child support for Justine to Taxes $ 2,700 Sandra1 $ 3,600 Federal income tax (w/h) $10,715 State and city income tax 1,172 FICA 7,650 Property tax for real estate (principal residence) 1,000 Total taxes $20,537 TOTAL CASH OUTFLOWS $102,077 NET CASH FLOW (DEFICIT) $ 1Child support of $3,600 will not be an outflow in 2016; therefore, net cash flow will be increased by that amount https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ 23 Case Study: Grant and Julie Scott STATEMENT OF FINANCIAL POSITION Grant and Julie Scott Balance Sheet as of January 1, 2016 ASSETS1 Liquid assets Checking account Savings account $ 2,150 1,450 Total liquid assets $ 3,600 Investments XYZ stock2 Section 401(k) plan vested balance $18,000 60,000 Total investments $ 78,000 Personal real estateresidence $350,000 sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m Other personal assets Automobile 1 $10,000 Automobile 2 11,500 Antiques 21,500 China and crystal 20,000 Furniture/household 83,500 Total other personal assets $146,500 TOTAL ASSETS LIABILITIES3 $578,100 AND NET WORTH Current liabilitiescredit cards $5,200 Long-term liabilities Mortgage on residence Personal loan Total long-term liabilities $252,100 8,965 $261,065 TOTAL LIABILITIES $266,265 NET WORTH $311,835 TOTAL LIABILITIES AND NET WORTH $578,100 Notes to Statement of Financial Position: 1Assets are stated at fair market value. 2\u0007The Th XYZ stock was a gift to Grant from his father on October 1, 2008. His father originally paid $15,000 for it on April 1, 2007. The fair market value on October 1, 2009, was $16,000. 3Liabilities are stated at principal amount only. https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ 5 sh is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m Th https://www.coursehero.com/file/15870803/AccFP101CaseStudyFacts/ Powered by TCPDF (www.tcpdf.org)