ࡱ> q` (bjbjqPqP 1::\;;;8:;,f;O:<="==<>???KOMOMOMOMOMOMO$QhnSxqOA??AAqO=<>ODDDAp=<>KODAKODD?FgF=< z;*I;mBWFFO0O_FS=CSgFSgF@?h?JD?<@???qOqOCX???OAAAA6;;  Retirement Readiness? FINA 7397 Behavioral Finance Instructor: Dale Rude Blair Arterbury Elisa Meadows Liqing Jing Jason Simmons Summer Session I, 2006 EXECUTIVE SUMMARY Our team interviewed four people of varying ages and professions. All four are currently employed and have enjoyed successful careers. However, we found that some were better prepared for retirement than others. Our goal was not to determine what could have been done in the past to be better prepared, but, rather, to assess their lifestyle and spending habits in conjunction with their current financial situation in order to recommend a plan, if need be, to enjoy a retirement consistent with their desires. Our first interviewee is a young, single woman, currently employed as a chemical engineer for a large corporation. She is thirty-five years old, lives a lifestyle that is consistent with her earnings, and is in great shape to retire with a level of income allowing her to live the lifestyle she currently lives, perhaps even better. She has done everything she can do to plan for retirement. The only threats to her plan come from forces outside of her control, such as job loss and a father who is not as prepared for retirement as she is. We recommended she discuss retirement with her father so that she is not unexpectedly forced to sacrifice her retirement for his. Further, we recommended she reassess her stock allocation; we discovered her allocation to be too conservative. Our second interviewee is a married couple. The husband, Jack, is a safety inspector at a refinery and his wife, Corliss, is a teachers aide. We discovered that they should take some extra steps to be better prepared for retirement. At their current savings rate, they will not meet their goal of being able to retire at 55. To do so, Jack would need to find part-time work to make up for their shortfall; however, one option that we recommended is for Jack to work until he is 59, saving a large percentage of his income during this time. If he does this, while at the same time exerting more effort to take care of his health, Jack and Corliss should be able to retire and live at the standard of living they desire. The third interviewee was a married couple nearing conventional retirement age. Roger is 58 years old and his wife is 57. However, Roger is unique in that he said he does not want to, and does not plan to, retire. Most people do not want to work their entire lives, and even fewer have such an option, but that is Rogers desire. He is self-employed, so he does have the ability to work for as long as he is able to keep his business going. Luckily, he is also in good financial shape to retire in his late 60s if that is what he chooses to do later. His assets include a 401(k) account, Social Security, and real estate holdings that are fully paid for. In our examination, we found that these assets are sufficient to provide him a comfortable retirement. Our only suggestion was that, perhaps, he should increase his level of disability insurance because he and his wife are particularly exposed to hardship if something were to happen to him, which would negatively impact his business. Our final interviewee was a 46-year-old father of three. He is employed as an engineer. He admitted to us that his expenses are out of control. Though he drives an old car and does not spend too much on himself, providing his family with simply the essentials eats up 75% of his income. The increase in utility bills lately is driving this percentage up even higher. Even though he has invested his savings aggressively, we recommended Mike start saving more of his take-home pay so that he is able to reach his goals at retirement; his current level of savings will not provide him the standard of living he desires. One other alternative suggested by him is moving overseas where the cost of living is lower; this would allow him to live as he hopes, but with less money saved. Introduction The question isn't at what age I want to retire, it's at what income. George Foreman George Foreman states it best. Retirement is no longer automatic at the age of 65. Some plan to retire at 55 and others plan to never fully retire. But, the main determinant of when a person retires is no longer a question of when? Now, it is a question of how much? The income a person will need at retirement is the chief factor in determining a retirement age. The Center for Retirement Research recently published a study that said 43% of working age households are likely to fall short of having enough money in retirement to replicate their current standard of living1. With all the financial education, mutual funds, financial calculators, financial advisors, and easily accessed online information available to us, how is this happening? The answer lies at the root of the problem: ourselves. Retirement preparation requires the knowledge of a few key concepts, but most importantly, planning and action. In our study, we attempted to come up with a few key questions that will lead us to answers on a persons retirement readiness. We also offered alternative methods to reaching ones retirement goals. Planning and taking action on your retirement are critical to an individuals post-working life. Accumulating enough wealth in retirement could be the difference between enjoying ones retirement in quiet leisure or having to work well beyond the age originally planned. Description of Procedures and Results Procedure This study consisted of asking four different working-age individuals a list of predetermined questions (Appendix A) about their retirement plans and current living standards. Based on those responses, we used different instruments (Excel, financial calculators) to determine if the individual will meet their retirement goal. The study consisted of estimated inflation rates and rates of return. Results Sally The first interviewee, Sally is a 35 year old female who currently works as a Chemical Engineer for The Dow Chemical Company. Sally is single and has no children. She has no plans to marry or have children in the future. Sally leads a comfortable but modest lifestyle with respect to spending. A little less than half of Sallys pre-tax income goes towards essential items such as mortgage, healthcare/auto/home insurance, food, gas and utilities. Sally owns a home worth $140,000 with a mortgage of $130,000. She typically drives the same car until it becomes a maintenance problem. Her last car was a 1996 Jeep Grand Cherokee with over 200,000 miles. She currently drives a 2005 Jeep Grand Cherokee. She buys clothes when she needs them, but not frequently. Her entertainment is dinner at an expensive restaurant a few times a month and a vacation once or twice a year. Typically, she has fairly frugal spending habits and lives within her means. Aside from a mortgage, Sallys debts include a student loan and car loan. Both loans will be paid off within the next 4 years. She does not carry credit card debt. Sally is comfortable and happy with her lifestyle and income. At this time, her intentions are to remain on a course of low debt and living within her means throughout her life and into retirement. She plans to remain working for Dow Chemical or a similarly large corporation (with healthcare and pension benefits) until retirement. When asked about her personal vision of retirement, Sally sees it as a continuation of her lifestyle before retirement. She would like her retirement income to remain the same as her salary at the time of retirement. We estimated her salary at retirement to be $250,000. This estimate assumes annual salary raises of 4% for the next 30 years. Therefore, Sally would like to have an annual retirement income of at least $250,000. This is her goal. Lets take a look at her plan to get there. Sally plans to retire at age 65 and uses a life expectancy of 90 for planning purposes. Her retirement plan consists of three parts: 401k savings, company pension, and social security. Lets start with her 401k plan. She is 100% vested and her company matches 4% of her contributions. Sally has $105,000 accumulated to date. Her contribution rate is 15% of her salary or $1,000 per month. Since she still has 30 years until retirement, Sally is comfortable with an aggressive portfolio. Her portfolio allocation is as follows:  If Sally continues to save 15 percent of her salary with 4 percent matching from her company, she will have accumulated $3.5 million by age 65. This assumes an average annual return of 8 percent on her investment, and it also assumes that Sally will receive an average 4 percent raise in salary each year. This will allow her an annual retirement income of $140,000 until the age of 90. The Social Security Administration estimates Sallys retirement benefits to be $2,073 per month if she retires at age 67. This amount will be adjusted for inflation at the time of retirement. If inflation rises 3 percent each year, Sally will receive an annual retirement income of $60,000 from Social Security beginning at age 67. Sallys earned pension from her company (assuming 4% annual raises) is estimated to be $10,112 in the form of a monthly lifetime annuity. This equates to an annual retirement income of $120,000 at age 65 and continuing for the remainder of her life. After the interview, we sat down to chat with Sally and assess her plan. If she continues on her current path, Sally will be able to retire with an annual income of $320,000 ($140,000 from 401k, $120,000 from pension, $60,000 from Social Security). This is 27% above her desired retirement income of $250,000. She appears to be ahead of the game. We discussed a discrepancy in her expressed desire for an aggressive portfolio and her actual portfolio. She has 50 percent of her portfolio in large cap funds, 7 percent in small cap and only 5 percent in international funds. An aggressive portfolio typically has up to 30 percent allocated to small cap and 10 percent to international funds. Sally is already aware of the need to decrease risk as retirement approaches. We discussed some of the potential risks that could keep Sally from meeting her retirement goals. She has a nice cushion of $70,000 above her desired annual retirement income. This would cover the loss of Social Security income that could occur if the government decides to reduce or eliminate this program before she retires. However, it would not cover the loss of the expected income from her company pension. If Dow were to eliminate their pension program, Sally could be $50,000 short. This would hurt, but she would survive since her essential expenses make up only 50 percent of her income. A third risk that could keep Sally from reaching her retirement goals is health problems. If she were to become sick or disabled, she could not work and may rack up expensive medical bills. Sally hedges this risk with health insurance provided by her company and carries additional disability insurance. In addition, Sally can decrease this risk in obvious ways such as exercise, good nutrition and regular medical check-ups. A fourth risk is the threat of lay-offs in the chemical/oil/gas industry or the threat of forced early retirement. A downturn in Sallys industry could force her to find employment at another company that does not have comparable benefits such as a pension plan or 401k matching program. It is not uncommon for companies to lay-off older workers or to force them into early retirement. This is a risk that Sally must take into consideration. She is closing the gap on this risk by committing to life-long learning to broaden her skill set. She will graduate with a Masters Degree in Business this year. This business education combined with engineering and production experience will allow her other job opportunities with firms outside of chemical production. A final risk is her father. This is probably the most likely and imminent risk because her father and his wife are self employed. They have incredible debt, no retirement, no health insurance and failing health due to diabetes and years of smoking. Sally will surely be expected to provide financial support for them when they can no longer work. Sally agreed that she needs to confront this situation, and with the help of her siblings, sit down with her father and develop a plan of action. In conclusion, Sally is on track to meet her retirement goals. She has a plan that will provide her with a comfortable retirement, and she has some cushion for any unplanned or unexpected events that may pop up in the meantime. Our recommendation is for Sally to reassess her portfolio contents to match an aggressive strategy. We also recommend that she take a look at her contingency plan and take measures now to decrease the likelihood of unexpected events that could keep her from reaching her retirement goals. Roger The next interviewee is a 58 year old male who is the president of an oil and gas service company. He is, for practical purposes, self-employed; only a bankruptcy could cause him to lose his job, but as with any business, bankruptcy is a possibility. The company he works for also employs his wife, who is 57 years old, as an accountant. Thus, the couple is in a somewhat risky situation, where if one were to lose his or her job, it would likely mean the other had lost his or her job, too. However, the company has existed for close to sixty years, and it has never been as successful as it has been lately; the future for the business is bright, and so is their job security. He says that he worries that the oil and gas service business could enter into a downturn, but he is confident he could weather it again, as he did in the 1980s when the energy industry suffered a downturn after a remarkable period of success. Roger and his wife live an upper-middle class lifestyle, but it is within the couples means. Roger himself is a fairly frugal person; most of his expenses are actually expenses directed toward his family. He drives a company car, a 2003 Chevy Suburban, and will continue to drive a company car into the near future. He spends very little on clothing and entertainment. His main non-essential expenses go towards golf and eating out. However, when he does both, he tends not to overdo it. He does not belong to a golf club; instead, he often plays at inexpensive public courses. He says that his spending habits are quirky: usually, he spends very little money, but every now and then he will splurge on a big ticket item. For example, he bought a fishing boat three years ago. Such expenses are unusual, and he never goes into debt when making the purchases. Thus, these expenses, too, can be classified as within his means. Roger is at a turning point in his financial life. He has three children, ages 26, 24, and 21. For the past quarter-century, most of Rogers disposable income has gone toward supporting his family. He was able to save very little of his income while his children were being raised, but now his children are all grown. His youngest has one year left of college, but other than that year of tuition, the only expenses he will likely spend on his children in the future will be for Christmas presents. Thus, Roger is at a time in his life when he can start saving more and spending more money on himself if he chooses to do so, but he says he does not expect his spending habits to change. He will likely just save more for retirement. Rogers plans for retirement are different than most. He does not want to, and does not plan to, retire. He enjoys his job, and though he does need a break from time to time, he has the luxury of being able to take those breaks when needed. He says he would be very bored if he did not have a job, and since he really enjoys the job he has, why quit? Any retirement would likely take the form of a partial withdrawal from his job; he would stay on as a consultant or some similar capacity. For planning purposes, though, I told him I thought it would be good to plan on retiring at age 68 because history shows us that most people start to lose some of their ability to function starting around that time. So, just in case he were to no longer have the energy or capacity to work, all the while remaining healthy and in need of an income to live on, he needs to have a plan in place. This is new to Roger; although he is 58, he says he has never thought too hard about planning for retirement. He has always saved for an emergency, but not because he wants to retire. Rogers retirement plan consists of three parts: a 401(k) savings plan, real estate holdings, and social security. Roger is 100% vested in the plan, and his company matches his contributions, which are currently $3600 per month. So, when considering the companys contributions, he has been contributing $7200 into the account. Currently, he has $897,000 saved in his 401(k) account. He has a fairly conservative allocation structure, but one that is appropriate for a man his age. About 20% is invested in a money-market account, another 40% in an intermediate bond fund, and the remaining 40% in a core equity fund consisting of a broad range of stocks. Upon retirement or termination from the company, he may elect to withdraw in lump sum or annuity fashion. If he dies before retirement, the entire sum would pass to his named beneficiary. If he retires at age 68, in todays dollars, the value in the account will amount to approximately $1,100,000 in todays dollars. After ordinary and capital gains taxes are deducted, the value will amount to about $800,000. All these figures assume his savings rate stays the same and he earns a 6% return on his account. If he were to withdraw this amount at age 68, he could invest the lump sum in safe government securities earning 5%, and his annual income would be $40,000, with no draw down on the sum. The Social Security Administration estimates Rogers retirement benefits to be $26,400 annually, in todays dollars, if he retires at age 68. If he works until hes 70, he will receive $33,216 annually. Besides his 401(k) plan and social security a benefit, Rogers other major asset available to be used for retirement is his real estate holdings other than his principal residence. Roger owns three properties with an appraised value of $500,000 and an approximate market value of $700,000. These properties are fully paid for two are currently being leased and the other is used as a second home. Conservatively assuming that over the next ten years these properties appreciate at the rate of inflation, he can, if need be, sell these properties for $945,000, convert to safe US government securities earning 5% a year, and enjoy an annual income of $35,000. When added together, the 401(k) savings, Social Security benefits, and real estate can provide Roger with $101,000 of annual income, in todays dollars. He says this is more than sufficient to keep him and his wife happy if neither of them were working. His principal residence is 93% paid for; he expects to have it paid off within five years, so he and his wifes major expenses in retirement will be property taxes, food, entertainment, and utilities. He believes $101,000 is more than enough to cover such things. Further, he says he and his wife plan to downsize their home sometime in the future he is not sure when. They are happy where they are now, but with all their kids gone, there is no reason for the two of them to continue to live in a large house and pay the high property taxes. This will be another source of income for them, for when they sell their current residence and buy a less expensive house; they will have some excess money which can be added to their retirement savings. The amount that would be added would depend on the value of the house they move into next. When asked about possible risks to any retirement, Roger said he is not worried about too much. He says that all major expenses, namely his childrens college and wedding expenses have passed and are paid for. Neither he nor his wife, have parents that will need care, and all his children have received a great education, are healthy, and their employment prospects seem bright. Thus, all he has to worry about are he and his wife. Both have health insurance and he has long-term disability insurance in case something was to happen to him. His room for error is also large. He has saved enough currently to live comfortably in retirement. The only risk is him not being able to work until age 68, but his health insurance and disability insurance would likely provide assistance in that situation. Plus, he has plenty of cushion. He plans to dramatically increase his savings in the next few years, as he will not have anything else to do with his income, and he can always move out of his principal residence and use the proceeds to fund any shortfall in his retirement plan. Roger and his wife are in great position to live a comfortable retirement. Their risks are small, as both are in wonderful health and their business is functioning better than ever, and they have some room for error should any business or health problems materialize. Jack and Corliss The next interviewee is a married couple, Jack and Corliss. Jack and Corliss have been married for 32 years and have two children who do not live at home, aged 27 and 30 years old. Jack, 51, is safety inspector at Lyondell-Citgo refinery. He has worked there for 28 years and has an annual salary of $70,000. Corliss, 52, works part-time as a teachers aide in the La Porte Independent School District. She has an annual salary of $12,000. Jack and Corliss live comfortably in a $100,000 house with a $20,000 mortgage. They also owe $3,000 for a car loan. The married couple has other debts beside the car and their mortgage. They currently owe $15,000 in student loans they acquired while paying for their children to attend college. They also have $10,000 in credit card debt. Jack and Corliss believe they will need approximately $4,000 per month, or $48,000 per year, when they retire. They plan and have budgeted to pay off all remaining debt within the next 4 years. For planning purposes, Jack expects to live until the age of 77 while Corliss expects to live to age 90. Since they will have no debt upon retirement, most of their expenses will come from healthcare costs. Jack has diabetes, coronary heart disease, asthma, and high blood pressure. Corliss is in perfect health. Jack estimates that he will need about $400/month for health related issues, including health insurance and prescription drugs. Jack plans to retire at age 55, partially because of health reasons. Jacks retirement plan consists of three items: 401k, company pension, and social security. He is 100% vested in his 401k and has a total of $150,000 to date. If he retires at age 55, his company pension will be $1,800 per month, or $21,600 per year. His monthly social security payments will be $1,800 per month, or $21,600 per year, but he will not begin receiving those payments until he turns 62 years of age. Corliss retirement plan consists only of one item: teachers pension plan. When she retires at age 59, she will begin receiving approximately $600 per month, or $7,200 per year. Jacks company currently matches 8% of his 401K contributions. Jack currently places 8% of his salary into his 401k for a total of 16%. Jacks 401k is in an extremely conservative Intermediate-Term Bond. If he continues at this rate for the next 4 years before retirement, he will have an estimated $200,000 when he retires at the age of 55 assuming an annual return of 4.66%. If he starts drawing on his 401k immediately at the age of 55, he will receive approximately $12,761 per year until the age of 90 (assuming 5.82% long term growth rate). The table below illustrates what the annual yearly income will be for Corliss and Jack for three different ages: 55, 59, and 62. Age555962Jack Pension$21,600$21,600$21,600Jack 410K$12,761$12,761$12,761Corliss Salary$12,000$0$0Corliss Pension$0$7,200$7,200Social Security$0$0$21,600Total Yearly Income$46,361$41,561$63,161 Between the ages of 55 to 62, Jack and Corliss do not meet their goal of $48,000 per year. When questioned, Jack said he hopes to make up the difference in those years by working part-time and receiving an estimated salary of $12,000, which would then put them over their goal of $48,000 in the questioned years. After discussing the current status of their retirement plan, we discussed their potential risks of retiring at the early age of 55. One risk is illustrated in the table above. Jack and Corliss simply might not have enough money to retire at 55 and 59, respectively. If Jack insists on retiring at 55, he has two options. 1) He could move his 401k out of the bond fund and into a more risky fund with the hopes of a higher return over the next 4 years. This would not be ideal. Both consider themselves to only limited financial knowledge and they are both close to retirement. They should leave their money in the conservative bond fund rather than risk losing any of the 401k. 2) Jack could put more money into his 401k. Jack hopes to increase his portion to almost 20% of his salary (with 8% match). At age 55, he would have a total of $231,201 in his 401k, which would give him annual payments of $14,752 (assuming 5.82% growth rate). This leads to an additional $2,000 per year, but still falls short of their retirement goal between the ages of 59-62. One of the main risks associated with their retirement is health problems. Jack is currently experiencing health problems and those could escalate in his retirement years. The most obvious method to help alleviate some of this risk is to exercise regularly and to incorporate a proper diet into their lives. If Jack was to place more influence on his health, he may be able to work longer than planned and will decrease the likelihood of needing long term medical care. If Jack were to retire at 59 instead of 55, his pension would grow to $2,500 per month and his 401k would grow to an estimated $268,257. The 410k would allow him annual payouts of $20,864. This allows Jack and Corliss to meet their goals between the ages of 59-62. After the age of 62, they would have a comfortable cushion for any unexpected health problems. Age5962Jack Pension$30,000$30,000Jack 410K$20,864$20,864Corliss Pension$7,200$7,200Social Security$0$21,600Total Yearly Income$58,064$79,664 In conclusion, at their current rate, Jack and Corliss are on track to miss their retirement goals. If Jack retires at the age of 55, he will almost surely need to work part-time to make up the difference. However, their best option would be for Jack to continue working until 59 while saving a large portion of his salary. This would help them to meet their retirement goal and have enough left over as a safety net for any future health problems. Mike The fourth interviewee is a 46 year old male named Mike. Mike currently works at Rohm & Haas, Texas Incorporated Company, as an engineer. Mike is the sole bread winner for his family of six: a wife, three children and his mother-in-law. Mike lives a frugal lifestyle. He drives an older model Mazda with over 200,000 miles which was purchased 17 years ago. Approximately 75% of his monthly take home household income is used to pay for essential expenses such as rent, mortgage, food, utilities, and healthcare. Mike states that his spending is out-of-control, especially in light of the increasing cost of electricity, natural gas, and gasoline. His disposable income due to these three items has incurred almost $400 per month decline. Mike owns a house which worth 160 thousand with mortgage of 120 thousand. His family rarely eats at restaurants, and vacations only once every two years. When talking Mike about his retirement plan, he informed us that he often thinks about retirement and whether or not hell have enough to retire at age 65. However, with 3 children that will attend college and get married, he knows that his retirement is under-funded at this point in his life. He is uncertain at times about where his money is spent, but he is making sure his spouse in on the same page budget-wise. He plans to have separate checking accounts to monitor expenses and ensure his spouse doesnt overspend. Its too easy to pull out a credit card and buy things without thinking about the amount of debt piling up. He is considering to eliminate movie channels on and other unnecessary expenses that make his family likely more comfortable. His primary goal is to pay off credit card debt in 3-5 years. Mike plans to retire at 65 years old, and live to 80 years old. His current company has a good pension today. It is likely that he will continue working in the chemical company until his retirement. To achieve his retirement goals, he would like to maintain the income level now (which will be adjusted for inflation at retirement date). We estimate that he should need $140,000 annually at the time of retirement given an inflation rate of 3 percent. His retirement plan includes three parts (401K, Social Security and Company pension). Mike estimates his social security retirement benefits to be $1,300 per month if he retires at age 67. If adjusted by 3 percent inflation each year, Mike will receive an annual retirement income of $27,000 from Social Security after age 67. Mikes earned pension from his company (assuming 4% annual increases) is projected to be a $1000 monthly lifetime annuity, giving an annual retirement income of about $120,000 after age 65. His 401k is currently $80,000, which he began when he was 28 years old. He plan to save 6% of salary in 401k from now until retirement, and also plan to increase his savings account when his home is paid off and kids are married. We estimated if Mike continues to save 6 percent of his salary with 4 percent matching from his company, he will receive $830,000 by age 65, based on an average annual return of 8 percent on his investment, and also given 4 percent increase in salary each year. This comes to an annual retirement income of $55,000 until the age of 80. This gives him a large deficiency ($46,000) between his expectation and actual number. The discrepancy is as follows: Table1: Living up to age 80 and saving 6% to 401K 401KSocial SecurityCompany PensionTotalMike's goal140,000Estimates55,00027,00012,000940,000Discrepancy-46,000If he lives up to age 90, the discrepancy is up to $68,000 annually, referred as follows: Table2: Living up to age 90 and saving 6% to 401K 401KSocial SecurityCompany PensionTotalMike's goal140,000Estimates33,00027,00012,000720,000Discrepancy -68,000 We suggest two options: he could cut down his living level after retirement or he could increase his saving to 401K. Alternative solution 1: cut down his living level after retirement. Mike would survive because his expected essential expenses is 50% of his income (about $70,000), but he would not be comfortable. He will live a frugal life and cut off many of his retirement objectives. As Mike told us, he could be prepared to retire in a South American country should he not have sufficient funds to live in the U.S. Alternative solution 2: Invest more into his 401K annual to cover the deficiency. We suggest that Mike invest 20% savings into 401K, which leads to $102,000 annual income from the 401k contribution after his retirement. The table is as follows: Table 3: Living up to age 80 and saving 20% to 401K 401KSocial SecurityCompany PensionTotalMike's goal140,000Estimates102,00027,00012,000141,000Discrepancy +1,000 This would allow Mike have a comfortable retirement life. Moreover, it is worthwhile to make an after tax contribution for investing more to 401K. However, Mike told us he is difficult to invest more until his 15-year mortgage is paid off and kids are married. We also discuss the portfolio allocation. His portfolio allocation is as follows:  EMBED Excel.Chart.8 \s  His portfolio allocation is very aggressive. Mike invested all his funds in the stock market. He has no bonds and treasury bills to diversify the risk. We recommend him balanced portfolio to diversify his risk and get steady return (Treasury bills 15%, Intermediate bonds 30%, Long-term bonds 5%, Large-cap stocks 20%, Small-cap stocks 20%, Non-US stocks10%). We also suggest that as he approaches retirement, Mike should become a more conservative investor. A balanced portfolio is consistent with his current financial goals and tolerance for taking investment risk. We discussed other potential risks that might keep Mike from his desired goal. If his company eliminates the company pension program, he will get only a small portion of his expected pension because he has been with the company for 10 years. He could somehow decrease his living level after retirement. However, he doesnt need to support his parents, because they saved enough and are already retired with good benefits. The third risk is health problems or disability. Mike has a $300,000 policy for disability. And he is exercising regularly and takes annual physicals. He has good health habits to cut his healthcare costs now and in the future while adding to his quality and quantity of life as well. The fourth risk is threat of lay off because of possible downturn of his industry. He is prepared for his risk by getting more education and increasing his skill set. Mike will soon receive a Masters Degree in Business. We recommend Mike set aside an emergency fund, which amounts to three to six months living expenses in easily accessible liquid savings. Mike told us that he did not plan to have an emergency fund due to the amount of monthly expenses incurred. Mike is not prepared to meet his retirement goals. However, he has some cushion for unplanned or unexpected events that may occur in the future. Our recommendation is for Mike to diversify his portfolio contents to match a balance strategy. We also recommend that he should increase his savings for 401K as much as possible, and reconsider his contingency plan again to satisfy his retirement goals better. Conclusion In conclusion, our team has interviewed four people to assess their readiness for retirement and identify any risks or gaps that may keep them from meeting their retirement goals. The interviewees include a 35 year old single female (Sally), two married couples in their 50s with no dependents (Jack & Corliss, Roger & wife), and a 46 year old male (Mike) who supports his wife, three kids and mother-in-law. All of the interviewed households include a 401k savings and social security in their retirement plan. Three of the households will rely on a company pension and the remaining household has real estate holdings included in his retirement plan. Two interviewees are well on their way to a comfortable retirement, and the other two are not quite on track, but have other options to close the gap by increasing savings rate or working longer than expected. See the Table below for a summary of each interviewee. SallyJack & CorlissRoger & wifeMikeCurrent Age3551/5258/5746Age to Retire6555/59n/a or maybe 6865Desired Retirement Income250,000/yr48,000/yr70,000/yr140,000/yrEstimated Retirement Income320,000/yr41,500/yr101,400/yr plus94,000/yrGap/Cushion+70,000-6,500+31,400-46,000Pension at Retirement120,000/yr28,800/yrn/a12,000/yr401K at Retirement140,000/yr12,800/yr40,000/yr interest only55,000/yrSocial Security at Retirement60,000/yr22,000/yr at 6226,400/yr27,000/yrReal Estaten/an/a35,000/yr interestn/a The major risks that could keep the interviewees from reaching retirement include: health problems, downturn in the economy (especially in the oil & gas industry), debt or bankruptcy, loss or reduction in Social Security benefits, loss or reduction in pension benefits, and their current portfolio allocation. Roger fares the best with very few worries about retirement that he could not easily overcome. Ironically, Roger is the only one who does not want to retire. Sally has 30 years until retirement so much could happen between now and then. She faces the largest risk of losing Social Security and pension benefits as there are signs today that indicate these may be cut or eliminated altogether in the future. Sally must also plan for financial assistance for her father. This may be an unavoidable drain on her savings. Luckily, she is ahead of the game and on the right track. With proper planning and a good contingency plan, she will be set for retirement. Jack and Corliss may not be able to retire as planned. They have a plan to pay off their debt in 4 years, but they will fall short of their goal if Jack retires at 55. Jack may want to increase the risk in his 401K savings plan; however, we do not recommend he take this chance at his age. His health problems pose a large risk to their retirement plan. This poses a catch-22 situation. Jack needs to work longer to obtain his retirement goals, but due to health concerns, he would be better off with less stress by retiring at 55. Jack and Corliss best option is to try to save as much money as possible in the next few years. In addition, Jack needs to take measures to preserve his health. Mike and is family are not currently on track to meet their retirement goals. However, Mike still has time to redirect his retirement portfolio since he does not plan to retire for another 20 years. He knows that he needs to reduce his debt and increase his savings. Mike has a good job with excellent benefits and he is taking steps to improve his market appeal in the event of lay-off or a downturn in the market. Mike also has an advantage in not having to pay for his kids college. This will allow him to save more. As far as current portfolio allocation, Sally could increase her risk if she truly wants an aggressive approach. Mike may consider reducing his risk slightly by adding a mix of bonds. Jack should not think about increasing his risk since he is so close to retirement. Limitations Your team will have to create these for your project. Appendix A Questionnaire Age, Gender Include a spouse in your retirement planning? Married, single, divorced? Years married? Number of times divorced? Planning to retire at what age? Life expectancy? Desired annual income after retirement ($$ amount or as a percent of pre-retirement income)? Retirement income from...percent from pension, savings, social security, trust, other? Do you feel that you areon track for retirement? (currently ready, on track, some reservations, not ready) Age you began saving for retirement? Not sure this will tell anything?? Number of kids? Do you expect to assist adult children financially? Other dependents? Pension? 401k? IRA? Social Security? Other sources? Asset allocation in percent. Retirement percent in stocks, bonds, other? Individual stocks, mutual funds? Asset allocation? Stocks...domestic, foreign? Large cap, small cap, mid cap, real estate, growth? Funds professionally managed or personally? Risk tolerance? Short term, conservative, balanced, growth, aggressive growth, most aggressive Are you the primary "bread winner" in your household?Other contributions, retirement or savings from spouse? Do you plan to work after retirement? Begin drawing pension only? Begin drawing from savings immediately? Will you be able to work if needed? How will healthcare plan be administered? Insurance, medicare, company provided? How is your health? Annual income, annual contributions to retirement? Emergency fund, how long would it last if you lost your primary source of income? Describe your household's overall financial situation, secure, somewhat secure, not secure, deteriorating? How much of your monthly take home household income is used to pay for essential expenses? (rent, mortgage, food, utilities), For healthcare? Likelihood of major expenses in the next10 years such as medical, elder care, new car, tuition, home remodeling? Investment knowledge, which best describes your level of investment knowledge? Novice, average, experienced? How do you plan tospend your free time once retired? Prepared for mental/emotional changes? Pick a portfolio that most resembles your portfolio type? Portfolio typeTreasury billsIntermediate bondsLong-term bondsLarge-cap stocksSmall-cap stocksNon-US stocks stocks HTMLCONTROL Forms.HTML:Option.1 Very conservative80%10%2%3%3%2% HTMLCONTROL Forms.HTML:Option.1 Conservative50%20%5%10%10%5% HTMLCONTROL Forms.HTML:Option.1 Passive25%30%5%15%15%10% HTMLCONTROL Forms.HTML:Option.1 Balanced15%30%5%20%20%10% HTMLCONTROL Forms.HTML:Option.1 Active10%20%10%25%25%10% HTMLCONTROL Forms.HTML:Option.1 Aggressive5%15%10%30%30%10% HTMLCONTROL Forms.HTML:Option.1 Very aggressive0%5%10%30%40%15% References 1 - http://money.cnn.com/2006/06/06/retirement/risk_index/index.htm?cnn=yes     PAGE  UNRESTRICTED - May be shared with anyonePAGE 23 UNRESTRICTED - May be shared with anyone UNRESTRICTED - May be shared with anyone DOW RESTRICTED - For internal use only <=.6=>)):2RRRSS[uff+gWgXgppppor v*v)y &CDPV^_¸¸¸zh25B*CJ\aJphh2CJaJh25CJ\aJh25CJ\aJh2CJaJh25CJaJh\}OJQJ^Jh2OJQJ^Jjh2U h26>* hl,h2hl,h2>*hl, h2H* h26h\}h20'(;<=>TUVWghvw$`a$\' k^n.6> $da$gdl,dgdl,$d`a$gdl,d` $d`a$$da$$`a$>#&))*+,/92368::>-B E8IKNNOQ+VhZt[[M]` $d`a$M]*acufyf|fff $$If`a$ $d`a$ffffffVIIII $$If`a$kdZ $$Ifl\ +] ' ''' ````(644 la_p(ffffffyyyy $$If`a$xkd$$Ifl\ +] ' '''644 la_ffffffyyyy $$If`a$xkd{$$Ifl\ +] ' '''644 la_ffffg gyyyy $$If`a$xkd[$$Ifl\ +] ' '''644 la_ g ggg"g*gyyyy $$If`a$xkd;$$Ifl\ +] ' '''644 la_*g+g?gGgOgWgyyyy $$If`a$xkd$$Ifl\ +] ' '''644 la_WgXgYghlp pVJJJJ= $$If`a$ $d`a$kd$$Ifl\ +] ' ''' ````(644 la_p( p pppp&p.pgkd<$$IflF +' '' ```T6    44 la_p $$If`a$.p/p9pApIp $$If`a$ekd_$$IflF +' ''T6    44 la_IpJpZpaphp $$If`a$ekd$$IflF +' ''T6    44 la_hpipyp|pp $$If`a$ekd$$IflF +' ''T6    44 la_ppppp $$If`a$ekd$$IflF +' ''T6    44 la_ppporvru)yy+thhf``hhhh` $d`a$kd$$IflF +' '' ```T6    44 la_p  $$Ifa$ $$If`a$ C=000 $$If`a$$Ifkd$$Ifr| HA'@'''' `````264ap2&-4;Cbkd$$Ifr| HA##### ` 64ap $$If`a$CDPRTV^obbbbb $$If`a$kd$$Ifr| HA##### ` 64ap ^_occVVVVV $$If`a$ $d`a$kd$$Ifr| HA##### ` 64ap _%34>[\iowx؄ل*078ÒeiǓʓ˓ғӓړۓ顅h\}5B*CJaJphh25B*CJaJphh25B*CJaJphh\}CJaJj%h2UjsJFH h2UVjh2Uh25B*CJ\aJphh2CJaJh2CJaJh25CJ\aJh21%')+3C66666 $$If`a$kd$$Ifr RK'@'''' `````264ap234>ELS[obbbbb $$If`a$kd$$Ifr RK##### ` 64ap [\ikmowobbbbb $$If`a$kd $$Ifr RK##### ` 64ap wxzx„occcccVVV $$If`a$ $d`a$kd $$Ifr RK##### ` 64ap „҄؄ل6) $$If`a$kd!$$Ifr RK'@'''' `````264ap2 $$If`a$ bkd4#$$Ifr RK##### ` 64ap $$If`a$ *,.07obbbbb $$If`a$kd $$$Ifr RK##### ` 64ap 78:?occccccccc $d`a$kd %$$Ifr RK##### ` 64ap 'ÒĒʒْ$If $If` $d`a$ $d`a$ KEEEEE$Ifkd)$$Iflr ,"D Tp t0644 la "25KEEEEE$Ifkd*$$Iflr ,"D Tp t0644 la56P[eozKEEEEE$Ifkd+$$Iflr ,"D Tp t0644 laz{ƓKEEEEE$Ifkd[,$$Iflr ,"D Tp t0644 laƓǓӓۓKEEEEE$Ifkd/-$$Iflr ,"D Tp t0644 laKEEEEE$Ifkd.$$Iflr ,"D Tp t0644 la$(2KEEEEE$Ifkd.$$Iflr ,"D Tp t0644 la23FQ[s}KEEEEE$Ifkd/$$Iflr ,"D Tp t0644 la}~ʔKEEEEE$Ifkd0$$Iflr ,"D Tp t0644 laʔ˔ה۔ߔKEEEEE$IfkdS1$$Iflr ,"D Tp t0644 la0і̘K?333 $d`a$ $d`a$kd'2$$Iflr ,"D Tp t0644 la&'()QRstuv()JºkcjGhl,U)jJH hl,CJPJUVaJnH tH jAhl,U)jKH hl,CJPJUVaJnH tH j*<hl,U)jLH hl,CJPJUVaJnH tH j^6hl,U)jMH hl,CJPJUVaJnH tH jh2U h25\hl,hl,>*hl,h2h26CJaJ"̘ w/+ & F dd[$\$^d`dgdl, $da$gdl, $d`a${ ~M̧ݧ*<@DGFfZ4 $$Ifa$$Ifdd[$\$ & F dd[$\$^GJMPQwɨͨѨԨبܨFfEFf?$IfFf9 $$Ifa$#'(NUY]aeimnݩFfVFfQ$IfFfNK $$Ifa$JKLMno٩ک۩ܩ\]_`bcefhiopqs֤֗֏{{wococjhL)0JCJUhL)0JCJhL) hL)0JjhL)0JUhFjhFU h2H*j&Yhl,U)jGH hl,CJPJUVaJnH tH jZShl,U)jHH hl,CJPJUVaJnH tH h2jh2UjMhl,U)jIH hl,CJPJUVaJnH tH #\^_abdeghqrsth]h &`#$gd\} $d`a$d`Ff\ $$Ifa$&'(h2hFhL) hL)CJhL)0JCJjhL)0JCJUhL)0JCJmHnHu%&'(d`/ 01h/ =!"#$% Z Dd 0   # A" nUI"RvNĽAo. D @= nUI"RvNĽAo.Xa m@'x x]}pUG?K )MRka0ZJSa,i 4 $8Ea5akg2*ic[8buX$sfs޻7nfgݳw{΋w3w9=&- V|[2K~ٞ<5lfc4SUj +X))F&s<=MH'SӖu,ӣMpϯa$yxӛ5PooHWnAhP-Hr0~06A?Bhi7?,obO0?3z.v0oMU9\?n&;N_WXk~$+WG=|&'85[/Bo\v=:!aw쾗nu7TT*GCd/3N=w/a:O2|Sn.>nca_})0xꚛM?YY.uY.m^ [{Ux@L5ho &?QkXx cXSi8ʓe^GC[/ҷ ; "E|` Ӆt۝wGq{sk{ \b9tUA3J~z- N\,#,8c9/eE2;9=K$j-*1My+T[gRK)8O{634?,).JߟvW" 4 IYBX_>ɂy5) ^P%FWk^ϫlTxuȓ{YO!Io}/jjkDՖ֦5 iSToi HlXMM?\װuI6!Zj*~N漺X\tx5<77LwS{jrYjRkYj uAP1 .YY9oD8.qyʱyy C]%󽫫ח|T/Țj p 1zi?K]Ē%G1NK'TO!t@@:|j9_ }tǿ tP=UtЗL'$TO7d:`}0~P=UbX&5PF{0%5G+L9cI[Wtdy7ȃ/x=7:Ҝ=/-^e.QЖU#V=|?+S#lCC%f"&J`huV#lw F.Ņ` yyo(@d5{$;A>Ar(5sZ+ŴYc'cXX7XXk%z7Zp$6t;jL)&Ҙc5]d/G6;g[5u(H mx#8y(#3Xc1 !-R\Q{!:ZG|ƚ^^K+׹]s6̀c '4gO>356[19oC,$]K)[¢G 1[%K3WPR3b)e<.fߝ0  tP4 (/=; ->:ʀgq>3o k1M\DgZDbLW~l_-jt9<[(3x8_bxk<--¼0HKhz/D< c1{?JxXVF'Me?_K_KZO)7y涊:ˏg ^iqmKRx0dmML Y{a[R=IRؾ2y,WKaY-Y,w-!8vjg)4~й_^i_Ex4Y Lnzÿl,_k߮V>;s3 a%S] h&}^}yڈ˵L6얏 {` %Xr~h'wN+Z v|37ONt.sk@vc2̕\Ep˫޾S>sS=c }|}1.j#_֪*i *Q_ }iAf }g)xh+dG3`( i   %9 ؊*:r0Ut3`+gP+π8gU@6rF^[3`ȗ+:GoɫpB>CLF4 8O>AP>a1̱ޕJn>ʼn<;|cַKkzy-\F3@ؤv}ڭ3zkpX뾞/|dx@u}<; ->:ʀ(}@ 2[p t|:>3}e#(S1n]煦ya>Wp3%3PrLYˣ > Q^}Hr3A%E8ݩwΰYטmo`#[ oLP7U<~ Ѝ?$$If_!vh5 525252#v #v2:V l ````(6,5 59/ /  / /  / / / a_p($$If_!vh5 525252#v #v2:V l6,5 59/ / / / / / / a_$$If_!vh5 525252#v #v2:V l6,5 59/ / / / / / / a_$$If_!vh5 525252#v #v2:V l6,5 59/ / / / / / / a_$$If_!vh5 525252#v #v2:V l6,5 59/ / / / / / / a_$$If_!vh5 525252#v #v2:V l6,5 59/ / / / / / / a_?$$If_!vh5 525252#v #v2:V l ````(6,5 59/ /  / /  / / / a_p(!$$If_!vh5 5252#v #v2:V l ```T6,5 59/ /  / /  / / / a_p$$If_!vh5 5252#v #v2:V lT6,5 59/ / / / / a_$$If_!vh5 5252#v #v2:V lT6,5 59/ / / / / a_$$If_!vh5 5252#v #v2:V lT6,5 59/ / / / / / / a_$$If_!vh5 5252#v #v2:V lT6,5 59/ / / / / / / a_!$$If_!vh5 5252#v #v2:V l ```T6,5 59/ /  / /  / / / a_pT$$If!vh55555-#v#v#v#v#v-:V  `````26,5@55559/ /  / 4 ap2$$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap T$$If!vh55555-#v#v#v#v#v-:V  `````26,5@55559/ /  / 4 ap2$$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap T$$If!vh55555-#v#v#v#v#v-:V  `````26,5@55559/ /  / 4 ap2$$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap $$If!vh55555-#v#v#v#v#v-:V  ` 6,59/ / / /  4 ap Dd  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry6 F\@*IFData ^WordDocument51ObjectPool09*I\@*I_1212566131/!F09*I09*IOle CompObjrObjInfo  !$%&'()*+,-./01367:;<=>?@ABCDEFGILMPQRSTUVWXYZ[\]_bcfghijklmnopqrsuxy|}~ !FBiff8Excel.Chart.89q&Microsoft Excel VhOh+'0@H\p  Jingliqing JingliqingMicrosoft Excel@E@IߖWorkbook ?SummaryInformation( DocumentSummaryInformation80_1221297741 U\g09*I09*I @Ba=E  =x8X1[SO1[SO1[SO1[SO1 Arial1.Times New Roman1.Times New Roman1[SO1[SO1.Times New Roman1[SO1[SO"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "/f";"/f";"&T" "w";"w";"GP" "_";"_";"sQ"                + )  , * ! IVh3 Sheet1e7Sheet2>Sheet3V`i`(  3  @@  4large cap value(80%)company stock(20%)    @" ??3` /, ` /, ` /, ((  (^ ( c $ @7 ;b]`P?3d23 M NM4 3QQ ;Q ;Q3_4E4D$% MP3O& Q4$% MP3O& Q4FAB 3OB 3"  3O h,% M&3O&Q423 M NM4444% c|DM 3O+s& Q 0Mike's 401K Allocation'44e1large cap value(80%)-company stock(20%)eT@4@e>  @  dMbP?_*+%MFHP Deskjet 3740 Series0 Series!@h߀ odBeRLdEXCELdHBeںں\\SAKURA\HP Deskjet 3740 Series,LocalOnly,DrvConvert *XX"d??U} } * } U } }                                  -ǡn@(Ap= ף?šn@%;@DRQ?!V8g=@ DD~ @~ @%@@D?! |@ D D ~ @ %A^پ@Dp= ף?%p6^@DRQ?+zADHzG?D %A^پ@Dp= ף?%%6}1—@D?+ b#|-@ D HzG?D   - wtA @{Gz?%2c @Dp= ף?%uW6@DRQ?+k$ADHzG?D %2c @Dp= ף?%km@D?+ 0z>@ D HzG?D ' nϡ@ {Gz? %%S[@Dp= ף?%s#*;@DRQ?+'lHADHzG?D %%S[@Dp= ף?%^ @D?+ @A D HzG?D  S&q@ D   %s6@Dp= ף?%:_@DRQ?+ ADHzG?D %s6@Dp= ף?%U)q@D?+  QA D HzG?D   %"(_u@Dp= ף?%b|:@DRQ?+ږADHzG?D %"(_u@Dp= ף?%Lz@D?+ > 2A D HzG?D   %B0@Dp= ף?%UbA@DRQ?+_!$ADHzG?D %B0@Dp= ף?% Z7@D?+ th۫A D HzG?D   %0?(@Dp= ף?%ܖ@DRQ?+ 0ADHzG?D %0?(@Dp= ף?%Z3 @D?+ /Ȧ; A D HzG?D   %)@ Dp= ף?%LSe@ DRQ?+qA DHzG?D %)@ Dp= ף?%ϻ|!x@ D?+ $A D HzG?D    % ZU@ Dp= ף?% $œ@ D RQ?+ ɸA DHzG?D  % ZU@ Dp= ף?%  S@ D ?+ =hA D HzG?D    % t?m^@ D p= ף?% N4[@ D RQ?+ ݛ6JA D HzG?D  % t?m^@ D p= ף?% ]̽~{@ D ?+  s,A D HzG?D    % ߼Wi:@ D p= ף?% $),6@ D RQ?+ =l!A D HzG?D  % ߼Wi:@ D p= ף?% a@ D ?+  +LA D HzG?D    % *@DRQ?+HFr(AD HzG?D %{YpAD p= ף?%G4[M@D?+ #~W5A D HzG?D   %Hf{ADp= ף?%+U@DRQ?+mի+ADHzG?D %Hf{ADp= ף?% rqŰZ@D?+ -k A D HzG?D   %UADp= ף?%%@DRQ?+ڠ>.ADHzG?D %UADp= ף?%uRr@D?+ ft"A D HzG?D%}ADp= ף?%ng@DRQ?+x1ADHzG?D %}ADp= ף?%g,@D?+ <"^z$A D HzG?D%g+;ADp= ף?%^G8;@DRQ?+f[<2ADHzG?D %g+;ADp= ף?%- @D?+ 'y&A D HzG?D%a0ADp= ף?%%rf@DRQ?+9C4ADHzG?D %a0ADp= ף?%&@D?+ *+ll<8)A D HzG?D%B wADp= ף?%/ٝ@DRQ?+Dd6ADHzG?D %qADp= ף?%vp@DRQ?+ϋY9ADHzG?D %ljADp= ף?%3'@DRQ?+aw;ADHzG?D# 6@ `T)A%{eADp= ף?%Uɶ=@DRQ?+L4)x>ADHzG?D  ڦ@ D %fIaUADp= ף?%/T~@DRQ?+2W^@ADHzG?D %SюN ADp= ף?%g8;@DRQ?+}wBADHzG?D %i@Q ADp= ף?%F@DRQ?+ 6ODADHzG?D %L5_ ADp= ף?%ϥmz@DRQ?+BFADHzG?D %w ADp= ף?%HPS@DRQ?+oZaHADHzG?D % ; ADp= ף?%؉ @DRQ?+ЧJADHzG?D %'ADp= ף?%Qpf@DRQ?+Y b.MADHzG?D B X1[[S,,,,,,,,,,,,>@  7 @  dMbP?_*+%" ??HU} large cap value(80%)~ T@company stock(20%)~ 4@/(  p  6NMM?7 w w]` P  @" ??3` /,` /,` /,  (  ^  c $ @t :f]`P+3d23 M NM4 3QQ ;Q ;Q3_4E4D$% MP3O& Q4$% MP3O&Q4FA>,' 3O,t( 3"  "W3O h,% M&3O&Q423 M NM4444% g?M 3O+x&Q 0Mike's 401K Allocation'44eee >@  7 @  dMbP?_*+%" ??AU>@7 ՜.+,0 PXh px Sakuraa Sheet1Sheet2Sheet3图表3  工作表图表{ #  - !- !   .- !PRINT CompObj qObjInfoOCXDATA =@ ( 4xx#@ ( cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="very_conservative|4.7|2.8">DefaultOcxName6{ #  - !- !   .- ! =@ ( 4xOCXNAME""_1221297740 U\g09*I09*IPRINT#CompObj2qx#@ ( cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="conservative|6.5|4.9">ObjInfo4OCXDATA5OCXNAME8"_1221297739U\g09*I09*IDefaultOcxName5{ #  - !- !   .- ! =@ ( 4xx#@ ( PRINT9CompObjHqObjInfoJOCXDATAKcmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="passive|8.4|7.6">DefaultOcxName4{ #  OCXNAMEN"_1221297738)U\g09*I09*IPRINTOCompObj!^q- !- !   .- ! =@ ( 4xx#@ ( cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19qObjInfo`OCXDATA "aOCXNAMEd"_1221297737%U\g09*I09*I2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="balanced|9.3|9.1">DefaultOcxName3{ #  - !- !   .- !PRINTeCompObj$'tqObjInfovOCXDATA&(w =@ ( 4xx#@ ( cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="active|10.1|10.4">DefaultOcxName2{ #  - !- !   .- ! =@ ( 4xOCXNAMEz"_1221297736#+U\g09*I09*IPRINT{CompObj*-qx#@ ( cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="aggressive|11.4|12.5">ObjInfoOCXDATA,.OCXNAME"_12212977351U\g09*I09*IDefaultOcxName1{ #  - !- !   .- ! =@ ( 4xx#@ ( PRINTCompObj03qObjInfoOCXDATA24cmscmscmscmscmscmscmscmscmscmscmscmscmscms' U\gForms.HTML:Option.1Embedded ControlForms.HTML:Option.19q2U\g<INPUT TYPE="radio" NAME="portfolio" VALUE="very_aggressive|12.7|14.7">DefaultOcxNameOh+'0pOCXNAME 1Table@SSummaryInformation(7DocumentSummaryInformation8     A !"#$%&'()*+,-./0123456789:;<=>?@ 0  # A2c-hZDcMK?<& `!7-hZDcMK PH:)xڽWkA3n*QZZ ेQKJh E,"ࡇoտ[D`WMv톘03og缝%H[,-I5E(cLP9(W @j c'Εhrޏّ#ѹФ"lBs `ww8vLL=pi\yfGg Rzǝ6BmhZV40#p28nbuŲWuxun/؜A}+.%=JxV}/-(, N[ּ2 0 WaCB[٫o@X1[[!9F*Utι(,DO>&/IJ4,J`QQת wXxn#݃xdy3d&>Gakdg8$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/n< `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kd3>$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/:B `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kdC$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/H `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kdI$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/M `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kdO$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/S `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kdcU$$IfKִ .{!$ ````````P6    34K` apP Dd hb  c $A? ?3"`?2Sy,'X/{m/jY `!'y,'X/{m|xŒ 0ƿKӢZqE'Wwqvrqt'|'1BKlikk.~]ށBg"+J*DG-ysFkYj !&S-))р"r֪U2X3u)!&=uDs;YuaK?tMW}"N[2zMk2(sLX{q#rh0؜?KZ{ LG*$$If!vh5M5555555#vM#v#v#v#v#v#v#v:V K ````````P6,534K` pP>kd/[$$IfKִ .{!$ ````````P6    34K` apP   , 8 DPX`hRetirement ReadinessJason SimmonsNormalD Rude2Microsoft Office Word@@:I@:I;!՜.+,D՜.+,P  px   &R  Retirement Readiness Title P$,H|Content_StewardProprietary_ClassificationRetention_PeriodRetention_Period_Start_DateRetention_Period_TriggerReason_Document_FrozenExpiration_DateMeadows E u648748,UNRESTRICTED - May be shared with anyone3 6/28/2006Dec. 31, 20090* pHdProjectQ(@= l : F J< rstdole>stdoleP h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\e2.tlb#OLE Automation`ENormalENCrmaQF  * \C 3 F!OfficgOficg!G{2DF8D04C-5BFA-101@B-BDE5gAjAeMacros=z;*Iz;*IVBA;z;*Iz;*IdirThisDocument:<42ggram Files\CommonMicrosoft Shared\@10\MSO.DLL# 10.0 Ob Library%xMSF!As>MSFBs3@dD452EE1-E08F0A-8-02608C4D0BB 4dsdFM20L'B p&/;"1D|~ C00}#@8@# 50 A171400E8-9AB0-45CF-849F-D163F7B5C6DOCUME~1\Jason\LOCALSTemp\W`ord8.bB7.xexdcU<".E .`M "CThisDocumentG T@is"Dlcuen@ 2 ` H1x@",t""+%# CCtx)DefaultOcxName, 6, 0, MSForms, HTMLOption*DefaultOcxName1, 5, 1, MSForms, HTMLOption*DefaultOcxName2, 4, 2, MSForms, HTMLOption*DefaultOcxName3, 3, 3, MSForms, HTMLOption*DefaultOcxName4, 2, 4, MSForms, HTMLOption*DefaultOcxName5, 1, 5, MSForms, HTMLOption*DefaultOcxName6, 0, 6, MSForms, HTMLOptionME(S"SS"s(1Normal.ThisDocument(% %*'h0 %*%` %*# %*! %*( %*X  %*Px8X *\R8005*#81xAttribute VB_Name = "ThisDocument" Bas1Normal.VGlobal!SpaclFalse CreatablPre declaIdTru BExposeTemplateDeriv$Custom izC1ControlDefa@ultOcxm, 6, 0, MSFs, HTMLOption !1, 5, 9"2, 4, 9"3, 9!@9D@9f@as  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020905-0000-0000-C000-000000000046}#_VBA_PROJECT PROJECT9>PROJECTlk?PROJECTwm)     8.2#0#C:\Program Files\Microsoft Office\Office10\MSWORD.OLB#Microsoft Word 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\CNormal*\CNormal3 F(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 10.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{171400E8-9AB0-45CF-849F-D163F7204B5C}#2.0#0#C:\DOCUME~1\Jason\LOCALS~1\Temp\Word8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M   : FCThisDocument0R460d3e09ThisDocumentt (0hqz:LG%|`&WordkVBAWin16~Win32MacVBA6#Project-stdole`NormalOfficeuMSFormsC ThisDocument< _EvaluateDefaultOcxNameDefaultOcxName1#DefaultOcxName2$DefaultOcxName3%DefaultOcxName4&DefaultOcxName5'DefaultOcxName6(Documentj`  ID="{580F4B16-0275-48FE-AA5D-B174A68D556F}" Document=ThisDocument/&H00000000 Name="Project" HelpContextID="0" VersionCompatible32="393222000" CMG="1113F2F2F6F2F6F2F6F2F6" DPB="999B7A7F7B7F7B7F" GC="2123C207C307C3F8" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={000209F2-0000-0000-C000-000000000046};Word8.0;&H00000000 U\gThisDocumentThisDocument  FMicrosoft Office Word Document MSWordDocWord.Document.89qH@H Normal CJPJ_HaJmH nHsH tHP@P Heading 1$$@&`a$5CJ\aJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k(No List JB@J Body Text$d1$a$ OJQJ^J4 @4 Footer  !.)@!. Page Number4@24 Header  !( '(;<=>TUVWghvw k^n.6>!!"#$'9*+.0226-: =8ACFNGI+NhRtSSMU*Y[u^y^|^^^^^^^^^^^^^^^^^^^^^_ _ ___"_*_+_?_G_O_W_X_Y_`dh h hhhh&h.h/h9hAhIhJhZhahhhihyh|hhhhhhhhojvjm)qq+wwwwwwwxx xxxxxx&x-x4x;xCxDxPxRxTxVx^x_xxxxxyyyy%y'y)y+y3y4y>yEyLySy[y\yiykymyoywyxyzyy{x|||||||||||||||} }}}}*},}.}0}7}8}:}?~~~'ÊĊʊي "256P[eoz{ƋNjӋۋ$(23FQ[s}~ʌˌ׌یߌ0ю̐ w/+{ ~M̟ݟ*<@DGJMPQwɠ͠ѠԠؠܠ#'(NUY]aeimnݡ\^_abehqrst%)080000000000000000000000000000000000000000000000000000000000000000000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000000000 0 0 0 0 0 0 0 0 0 0  0  0  0  0  0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000I00'I00I00'I00I00I00I00'I00I00@0@0@0I00'@aJ0ityt`hI00 OO_J(Vn>M]ffff g*gWg p.pIphpppC^3[w„7 5zƓ2}ʔ̘G(WYZ[\]^_`abcdefghijklmopqrstuvwxyz{|}~'X~~~&(Qsu(JLn١ۡ(:[[[[[[[ AHK!!  8@0(  B S  ?: ĉ":m: U: : U:?:/TTTUU~{~{Ʉ)UU#U#U{{Մ)Z*urn:schemas-microsoft-com:office:smarttags PlaceNamehttp://www.5iantlavalamp.com/Z*urn:schemas-microsoft-com:office:smarttags PlaceTypehttp://www.5iantlavalamp.com/8*urn:schemas-microsoft-com:office:smarttagstimeB*urn:schemas-microsoft-com:office:smarttagscountry-regionV*urn:schemas-microsoft-com:office:smarttagsplacehttp://www.5iantlavalamp.com/ $ 1757HourMinuteSSU]\\^^__abdegh&) 46eQlQmm~{{kx؝ܝ\\^^__abdegh&)3333333333Ζ[\\^^__abdegh&)\\^^__abdegh&)qNEDƌB-^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.  ^ `.qNED  t>)L)l,FyEyLySy[y\yiykymyoywyxy||||||||||||||} }}}}*},}.}0}7}8}ÊĊʊي "256P[eoz{ƋNjӋۋ$(23FQ[s}~ʌˌ׌یߌ̟ݟ*<@DGJMPQwɠ͠ѠԠؠܠ#'(NUY]aeimnݡ)@ (@UnknownGz Times New Roman5Symbol3& z Arial;SimSun[SOG5  hMS Mincho-3 fg"1h#&#&;!R&;!R&4d ga2QHX?\}2Retirement Readiness Jason SimmonsD Rude CompObj8q