Question

Bob Davidson is a 46-year-old tenured professor of marketing at a small New England business school. He has a daughter, Sue, age 6, and a wife, Margaret, age 40. Margaret is a potter, a vocation from which she earns no appreciable income. Before she was married and for the first few years of her marriage to Bob (she was married once previously), she 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 unrelated instances of that disease. Bob’s health has been excellent; he is an active runner and skier. There are no inherited diseases in the family with the exception of glaucoma. Bob’s most recent serum cholesterol count was 190. Bob’s salary from the school where he works consists of a nine-month salary (currently $95,000), on which the school pays an additional 10 percent into a retirement fund. He also regularly receives support for his research, which consists of 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 percent per year, although faculty salaries are subject to severe compression, so he does not expect to receive such generous increases into the future. In addition to his salary, Bob typically earns $10,000 to 20,000 per year from consulting, executive education, and other activities. In addition to the 10 percent regular contribution the school makes to Bob’s retirement savings, Bob also contributes a substantial amount. He is currently setting aside $7,500 per year (before taxes). The maximum tax-deferred amount he can contribute is currently $10,000; this limit rises with inflation. If he were to increase his savings toward retirement above the limit, he would have to invest after-tax dollars. All of Bob’s retirement savings are invested with TIAA–CREF (Teachers Insurance and Annuity Association-College Retirement Equities Fund; home page: www.tiaa-cref.org), which provides various retirement, investment, and insurance services to university professors and researchers. Bob has contributed to Social Security for many years as required by law, but in light of the problems with the Social Security trust fund he is uncertain as to the level of benefits that he will actually receive upon retirement. (The Social Security Administration’s website is www.ssa.gov.) Bob’s TIAA-CREF holdings currently amount to $137,000. These are invested in the TIAA long-term bond fund (20 percent) and the Global Equity Fund (80 percent). The Global Equity Fund is invested roughly 40 percent in U.S. equities and 60 percent in non-U.S. equities. New contributions are also allocated in these same proportions. In addition to his retirement assets, Bob’s net worth consists of his home (purchase price $140,000 in 1987; Bob’s current equity is $40,000); $50,000 in a rainy-day fund (invested in a short-term money market mutual fund with Fidelity Investments); and $24,000 in a Fidelity Growth and Income Fund for his daughter’s college tuition. He has a term life insurance policy with a value of $580,000; this policy has no asset value but pays its face value (plus inflation) as long as Bob continues to pay the premiums. He has no outstanding debts in addition to his mortgage, other than monthly credit-card charges. 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 without any immediate taxation; the monthly income from the annuities is then taxed as ordinary income. Bob’s mother is 72 and in good health. She is retired and living in a co-op apartment in Manhattan. Her net worth is on the order of $300,000. His mother-in-law, who is 70, lives with her second husband. Her husband is 87 and has sufficient 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 Newton, Massachusetts, as well as one-third of his estate (the remaining two-thirds will go to his two children). Her 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 and their family responsibilities permit. Upon retirement he would like to be able to travel extensively, although he would be able to live quite modestly otherwise. He does not foresee moving from the small town where he now lives. 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?

Answer 1

Annual	per year
Current Salary	$    95,000.00
Retirement Fund	$      9,500.00
Research	$    21,111.00
Consulting	10000-20000
RETIREMENT FUND LIMIT	7500-10000
Current Retirement	$ 137,000.00
assets	$ 140,000.00
Equity	$    40,000.00
Rainy day fund	$    50,000.00
Daughter	$    24,000.00
LIP	$ 580,000.00
Current Income	$ 131,111.11
Current Fund value	$ 137,000.00
Assets	$ 254,000.00
Retirement Age	65 year	Guess
Return on Saving & Assets	5%	Guess
Income Needs	75%	Out of currrent income
Salary Increase	4%	Guess

working hint

Salary Increase by 4% per year eg (95000+4%)+95000

Interest on Assets 5% consider it include Eq,assets,rainy fund

Income Needs 75% of 95000 for 66th year

income needs compounded 1% every year after 66th year

Age	Salary	Retirement Fund	Personal Retirement	Interest on Assets	Income Needs	Balance	Int on Assets
46	$    98,800.00	$               9,880.00	$                       7,500.00	$                    11,500.0
47	$ 102,752.00	$            10,275.20	$                       7,500.00	$                    12,075.0
48	$ 106,862.08	$            10,686.21	$                       7,500.00	$                    12,678.8
49	$ 111,136.56	$            11,113.66	$                       7,500.00	$                    13,312.7
50	$ 115,582.03	$            11,558.20	$                       7,500.00	$                    13,978.3
51	$ 120,205.31	$            12,020.53	$                       7,500.00	$                    14,677.2
52	$ 125,013.52	$            12,501.35	$                       7,500.00	$                    15,411.1
53	$ 130,014.06	$            13,001.41	$                       7,500.00	$                    16,181.7
54	$ 135,214.62	$            13,521.46	$                       7,500.00	$                    16,990.7
55	$ 140,623.21	$            14,062.32	$                       7,500.00	$                    17,840.3
56	$ 146,248.14	$            14,624.81	$                       7,500.00	$                    18,732.3
57	$ 152,098.06	$            15,209.81	$                       7,500.00	$                    19,668.9
58	$ 158,181.98	$            15,818.20	$                       7,500.00	$                    20,652.3
59	$ 164,509.26	$            16,450.93	$                       7,500.00	$                    21,685.0
60	$ 171,089.63	$            17,108.96	$                       7,500.00	$                    22,769.2
61	$ 177,933.22	$            17,793.32	$                       7,500.00	$                    23,907.7
62	$ 185,050.55	$            18,505.05	$                       7,500.00	$                    25,103.1
63	$ 192,452.57	$            19,245.26	$                       7,500.00	$                    26,358.2
64	$ 200,150.67	$            20,015.07	$                       7,500.00	$                    27,676.1
65	$ 208,156.70	$            20,815.67	$                       7,500.00	$                    29,059.9
		$          294,207.42	$                  150,000.00	$                  380,258.5		$    824,465.89	$       41,223.29
66					$                71,250	$    794,439.18	$       39,721.96
67					$                71,963	$    762,198.64	$       38,109.93
68					$                72,682	$    727,626.45	$       36,381.32
69					$                73,409	$    690,598.83	$       34,529.94
70					$                74,143	$    650,985.73	$       32,549.29
71					$                74,884	$    608,650.55	$       30,432.53
72					$                75,633	$    563,449.77	$       28,172.49
73					$                76,390	$    515,232.61	$       25,761.63
74					$                77,154	$    463,840.70	$       23,192.04
75					$                77,925	$    409,107.66	$       20,455.38
76					$                78,704	$    350,858.72	$       17,542.94
77					$                79,491	$    288,910.29	$       14,445.51
78					$                80,286	$    223,069.52	$       11,153.48
79					$                81,089	$    153,133.85	$         7,656.69
80					$                81,900	$      78,890.50	$         3,944.53
81					$                82,719	$            115.99	$                  5.80
82					$                83,546	$    (83,424.44)	$       (4,171.22)
83					$                84,382	$ (171,977.35)	$       (8,598.87)
84					$                85,226	$ (265,801.73)	$     (13,290.09)
85					$                86,078	$ (365,169.58)	$     (18,258.48)
86					$                86,939	$ (470,366.60)	$     (23,518.33)
87					$                87,808	$ (581,692.85)	$     (29,084.64)
88					$                88,686	$ (699,463.50)	$     (34,973.18)
89					$                89,573	$ (824,009.54)	$     (41,200.48)
90					$                90,469	$ (955,678.61)	$     (47,783.93)

Hence, based on the assumptions and the calculation made the following are the explanation or the clarification to bob.

1. 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?

It would be sufficient up to 15 year after retirement.

1. How much should he be setting aside each year?

Aprox 7,80,000

1. How much will he have to live on when he retires? How long after retirement will he be able to live comfortably?

Till 81 year age he has no problem of fund deficiency.

1. What are the risks he faces, and how should his retirement planning take these risks into account?

All types of risk already considered in this case.