Refer to the Retirement Planning case. Review the problem statement and influence chart that were generated for
Fantastic news! We've Found the answer you've been seeking!
Question:
Refer to the Retirement Planning case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercise in Chapter 2. (If this has not yet been done, develop the problem statement and influence chart as preliminary steps.) Design a spreadsheet to estimate the impact on Davidson’s retirement of increasing his annual retirement savings by 10 percent.
Transcribed Image Text:
RETIREMENT PLANNING Bob's TIAA-CREF holdings currently amount to $137,000. These are invested in the TIAA long-term bond Bob Davidson is a 46-year-old tenured professor of market- ing at a small New England business school. He has a daughter, Sue, age 6, and a wife, Margaret, age 40. Margaret fund (20 percent) and the Global Equity Fund (80 per- is a potter, a vocation from which she earns no appreciable cent). The Global Equity Fund is invested roughly 40 income. Before she was married and for the first few years of percent in U.S. equities and 60 percent in non-U.S. her marriage to Bob (she was married once previously), she equities. New contributions are also allocated in these worked at a variety of jobs, mostly involving software programming and customer support. Bob's grandfather died at age 42; Bob's father died in 1980 at the age of 58. Both died from cancer, although current equity is $40,000); $50,000 in a rainy-day fund unrelated instances of that disease. Bob's health has been same proportions. In addition to his retirement assets, Bob's net worth consists of his home (purchase price $140,000 in 1987; Bob's (invested in a short-term money market mutual fund with Fidelity Investments); and $24,000 in a Fidelity Growth and excellent; he is an active runner and skier. There are no inherited diseases in the family with the exception of glau- Income Fund for his daughter's college tuition. He has a coma. Bob's most recent serum cholesterol count was 190. term life insurance policy with a value of $580,000; this Bob's salary from the school where he works consists of a policy has no asset value but pays its face value (plus nine-month salary (currently $95,000), on which the school inflation) as long as Bob continues to pay the premiums. pays an additional 10 percent into a retirement fund. He also regularly receives support for his research, which consists of other than monthly credit-card charges. an additional two-ninths of his regular salary, although the college does not pay retirement benefits on that portion of his income. (Research support is additional income; it is not intended to cover the costs of research.) Over the 12 years he has been at the college his salary has increased by 4 to 15 without any immediate taxation; the monthly income from percent per year, although faculty salaries are subject to the annuities is then taxed as ordinary income. severe compression, so he does not expect to receive such generous increases into the future. In addition to his salary, living in a co-op apartment in Manhattan. Her net worth is Bob typically earns $10,000 to 20,000 per year from con- sulting, executive education, and other activities. In addition to the 10 percent regular contribution the school makes to Bob's retirement savings, Bob also con- tributes a substantial amount. He is currently setting aside $7,500 per year (before taxes). The maximum tax-deferred Newton, Massachusetts, as well as one-third of his estate amount he can contribute is currently $10,000; this limit (the remaining two-thirds will go to his two children). Her rises with inflation. If he were to increase his savings toward retirement above the limit, he would have to invest after-tax He has no outstanding debts in addition to his mortgage, Should Bob die while insured, the proceeds on his life insurance are tax free to his wife. Similarly, if he dies before retirement, his retirement assets go to his wife tax free. Either one of them can convert retirement assets into annuities Bob's mother is 72 and in good health. She is retired and on the order of $300,000. His mother-in-law, who is 70, lives with her second husband. Her husband is 87 and has suffi- cient assets to pay for nursing home care, if needed, for his likely remaining lifetime. Upon her husband's death, Bob's mother-in-law will receive ownership of their house in net worth at that point is expected to be in the $300,000- 400,000 range. Bob's goal is to work until he is 60 or 65. He would like to save enough to pay for his daughter's college expenses, but not for her expenses beyond that point. He and his wife would like to travel, and do so now as much as his job dollars. All of Bob's retirement savings are invested with TIAA-CREF (Teachers Insurance and Annuity Associa- tion-College Retirement Equities Fund; home page: www. tiaa-cref.org), which provides various retirement, invest- ment, and insurance services to university professors and and their family responsibilities permit. Upon retirement researchers. Bob has contributed to Social Security for he would like to many years as required by law, but in light of the problems would be able to live quite modestly otherwise. He does with the Social Security trust fund he is uncertain as to the e able to travel extensively, although he not foresee moving from the small town where he now level of benefits that he will actually receive upon retire- lives. ment. (The Social Security Administration's website is www.ssa.gov.) Bob has a number of questions about how he should plan for his retirement. Will the amount he is accumulating at his current rate of savings be adequate? How much should he be setting aside each year? How much will he have to live on when he retires? How long after retirement will he be able to live comfortably? What are the risks he faces, and how should his retirement planning take these risks into account? RETIREMENT PLANNING Bob's TIAA-CREF holdings currently amount to $137,000. These are invested in the TIAA long-term bond Bob Davidson is a 46-year-old tenured professor of market- ing at a small New England business school. He has a daughter, Sue, age 6, and a wife, Margaret, age 40. Margaret fund (20 percent) and the Global Equity Fund (80 per- is a potter, a vocation from which she earns no appreciable cent). The Global Equity Fund is invested roughly 40 income. Before she was married and for the first few years of percent in U.S. equities and 60 percent in non-U.S. her marriage to Bob (she was married once previously), she equities. New contributions are also allocated in these worked at a variety of jobs, mostly involving software programming and customer support. Bob's grandfather died at age 42; Bob's father died in 1980 at the age of 58. Both died from cancer, although current equity is $40,000); $50,000 in a rainy-day fund unrelated instances of that disease. Bob's health has been same proportions. In addition to his retirement assets, Bob's net worth consists of his home (purchase price $140,000 in 1987; Bob's (invested in a short-term money market mutual fund with Fidelity Investments); and $24,000 in a Fidelity Growth and excellent; he is an active runner and skier. There are no inherited diseases in the family with the exception of glau- Income Fund for his daughter's college tuition. He has a coma. Bob's most recent serum cholesterol count was 190. term life insurance policy with a value of $580,000; this Bob's salary from the school where he works consists of a policy has no asset value but pays its face value (plus nine-month salary (currently $95,000), on which the school inflation) as long as Bob continues to pay the premiums. pays an additional 10 percent into a retirement fund. He also regularly receives support for his research, which consists of other than monthly credit-card charges. an additional two-ninths of his regular salary, although the college does not pay retirement benefits on that portion of his income. (Research support is additional income; it is not intended to cover the costs of research.) Over the 12 years he has been at the college his salary has increased by 4 to 15 without any immediate taxation; the monthly income from percent per year, although faculty salaries are subject to the annuities is then taxed as ordinary income. severe compression, so he does not expect to receive such generous increases into the future. In addition to his salary, living in a co-op apartment in Manhattan. Her net worth is Bob typically earns $10,000 to 20,000 per year from con- sulting, executive education, and other activities. In addition to the 10 percent regular contribution the school makes to Bob's retirement savings, Bob also con- tributes a substantial amount. He is currently setting aside $7,500 per year (before taxes). The maximum tax-deferred Newton, Massachusetts, as well as one-third of his estate amount he can contribute is currently $10,000; this limit (the remaining two-thirds will go to his two children). Her rises with inflation. If he were to increase his savings toward retirement above the limit, he would have to invest after-tax He has no outstanding debts in addition to his mortgage, Should Bob die while insured, the proceeds on his life insurance are tax free to his wife. Similarly, if he dies before retirement, his retirement assets go to his wife tax free. Either one of them can convert retirement assets into annuities Bob's mother is 72 and in good health. She is retired and on the order of $300,000. His mother-in-law, who is 70, lives with her second husband. Her husband is 87 and has suffi- cient assets to pay for nursing home care, if needed, for his likely remaining lifetime. Upon her husband's death, Bob's mother-in-law will receive ownership of their house in net worth at that point is expected to be in the $300,000- 400,000 range. Bob's goal is to work until he is 60 or 65. He would like to save enough to pay for his daughter's college expenses, but not for her expenses beyond that point. He and his wife would like to travel, and do so now as much as his job dollars. All of Bob's retirement savings are invested with TIAA-CREF (Teachers Insurance and Annuity Associa- tion-College Retirement Equities Fund; home page: www. tiaa-cref.org), which provides various retirement, invest- ment, and insurance services to university professors and and their family responsibilities permit. Upon retirement researchers. Bob has contributed to Social Security for he would like to many years as required by law, but in light of the problems would be able to live quite modestly otherwise. He does with the Social Security trust fund he is uncertain as to the e able to travel extensively, although he not foresee moving from the small town where he now level of benefits that he will actually receive upon retire- lives. ment. (The Social Security Administration's website is www.ssa.gov.) Bob has a number of questions about how he should plan for his retirement. Will the amount he is accumulating at his current rate of savings be adequate? How much should he be setting aside each year? How much will he have to live on when he retires? How long after retirement will he be able to live comfortably? What are the risks he faces, and how should his retirement planning take these risks into account?
Expert Answer:
Related Book For
Business Analytics The Art of Modeling with Spreadsheets
ISBN: 9781119386490
5th edition
Authors: Stephen G. Powell , Kenneth R. Baker.
Posted Date:
Students also viewed these computer network questions
-
Refer to the Retirement Planning case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercise in Chapter 2. (If this has not...
-
Refer to the Retirement Planning case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
K. The account balances appearing on the trial balance (below) were taken from the general ledger of Speedy Copy Shop at September 30. Additional information for the month of September which has not...
-
Find the lengths of the curves. x = (y 3 /12) + (1/y), 1 y 2
-
Suppose Mark Sanchez, quarterback of the New York Jets, increased his annual income 20 percent by endorsing Kellogg's Com Flakes. If his demand for hair shampoo didn't change, what can we say about...
-
What is the zero point energy and what are the energies of the lowest seven energy levels in a three-dimensional box with a = b = c? What is the degeneracy of each level?
-
Presented below are summary financial data from the General Electric Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following liquidity and solvency ratios:...
-
Should a different set of schedules and charts be maintained for out-of-house as well as in-house reporting? Should separate schedules be made for each level of management? Is there a more effective...
-
K Sheridan Service has a line of credit loan with the bank. The initial loan balance was $6000.00. Payments of $2000.00 and $3000.00 were made after five months and six months respectively. At the...
-
Crane Medical manufactures hospital beds and other institutional furniture. The company's comparative balance sheet and income statement for 2019 and 2020 follow. Assets Current assets Crane Medical...
-
Problem 11-22 (Algo) [LO 11-5) Callen Incorporated has accumulated minimum tax credits of $1.36 million from tax years prior to 2018. The following are Callen's regular tax before credits for 2018...
-
Journalize these entries in a basic bookkeeping spreadsheet ( cash basis AIS with no accruals ) and include the chart of accounts affected? L - r As of January 1, 2024 the petty cash was $200.00 and...
-
Find two articles from trade periodicals containing information about statistics, data, measurement of any marketing concept, consumers, surveys, or inventory management. summarize each article...
-
1. Write down the organizational hiercay level of any company (from website of that company and please mention the company name) and provide level of managers for that specific manufacturing or...
-
Sandia Corporation manufactures metal toolboxes. It adds all materials at the beginning of the manufacturing process. The company has provided the following information: Beginning work in process...
-
Bosco corporation uses a process costing system. Beginning inventory for January consisted of 1000 unites that were 60% completed. During january, 10,500 units were completed. On January 31, the...
-
Part 3 of 6-Step 3 The equation for the pressure P of an incompressible, static fluid on the Earth as a function of depth y below the surface. is also called the equation for hydrostatic equilibrium....
-
Provide a draft/outline of legal research involving an indigenous Canadian woman charged with assault causing bodily harm under (Sec 267b) of the Criminal Code, where the crown wants a 12-month jail...
-
What are the decisions, outcomes, and relationships in the problem? The four short cases we have analyzed in this chapter (Retirement Planning, Draft TV Commercials, Icebergs for Kuwait, and...
-
Refer to the Racquetball Racket case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
The dataset German Credit.xlsx contains data on prior applicants for credit, including whether they proved to have good or bad credit. a. How many records are in this dataset? b. How many fields are...
-
Paulson Manufacturing Company uses the perpetual inventory system to account for its manufacturing inventories. The following are Paulsons transactions during July 2019: July 5 Received materials...
-
The following amounts are available for 2019 for Bishop Manufacturing Company: Required Using the above data, prepare a schedule of cost of goods manufactured and sold. Administrative salaries...
-
You are consulted by Investors, Inc., a group of investors planning a new product. They have estimates of the costs of materials, labor, overhead, and other expenses for 2019 but need to know how...
Study smarter with the SolutionInn App