Question

Problema 1 (Please Solve with Excel)

The Time Value of Money

Jackson L. Brown
Valuation of Expected Earnings

Dr. Michael Niesvwiadomy
(Legal Consultant and an Assistant Professor at the University of North Texas).

Jackson L. Brown was born on January 15, 1960 in Austin, Texas. He was raised in Plano, Texas, where his family moved a few years after his birth. There he attended and graduated from Plano High School. Jackson had planned to go to college but due to an early marriage had to seek a job to support his family In August of 1978 Jackson started working for Weststar Cleaning as a window washer. Jackson enjoyed his job and qualified for yearly raises. By August of 1988 he was making $25,000 a Year with an average yearly raise of 5.34%. Jackson and his wife Mary seemed to have everything going for them. On the 9th of September 1988, tragedy struck. Jackson was working on the 37th floor of a 75 story skyscraper when a detective rope broke and caused him to fall to his death.

Mary Brown was devastated with the tragedy. Not only was the loss of her husband hard on her but she was put in a position of finding a job to support her young family.

Mrs. Brown contacted Mr. A.(Always) Wright, a local attorney, and requested a wrongful death suit against the rope manufacturer to recover her husband's expected future earnings and benefits. Mary was a little apprehensive at first about the law suit because of the expense of hiring an attorney. Wright assured Mrs. Brown, however, that she would not have to pay any legal fees unless the case was settled in her favor. Mary decided that a law suit would be better than living in poverty the rest of her life and besides it would be a low cost alternative since she would not be responsible for any of the costs unless the case was settled in he,. favor. Mr. Wright was positive   that he could prove negligence on the part of the rope manufacturer but was unsure as to the full value of the damages caused by the accident.

Dr. Michael L.(Loves) Money, a professional economist, was retained by Mr. Wright to prepare a report and give testimony (if needed) in the wrongful death case. Mr. Wright hired Dr. Money to calculate estimates of the expected lost earnings of the deceased Jackson L. Brown. Based upon information Provided to Dr. Money, he constructed the (actual basis of the case which is shown in Table 1.1.

The growth rate in wages and the earnings at the time of death were taken from Mr. Brown's past tax returns. Dr. Money found that the growth rate of Mr. Brown's actual wages corresponded with averages for the growth in private non-agricultural wages, which he found in Employment, Hours and Earmings United States, 1909-84, Volumes I and II (Bulletin 1312-12) and in current issues of Employment and Earnings (published by the U.S. Department of Commerce, Bureau of Labor Statistics). Dr. Money believed that the correlation of the actual growth rate of Mr. Brown's wages to industry averages implied that the industry averages could be used. Dr. Money used the average 3 year Treasury note rate as the discount factor since this is a generally accepted indicator of market interest rates, the source of this data is the Slatistical Abstract of the United States, 1988 (published by the U.S. Department of Commerce, Bureau of the Census).

TABLE 1.1: Factual Basis for Evaluating the Economic Losses of Jackson L Brown
------------------------------------------------------------------------------------------------------------------------
1. Date of Birth:                                        2/15/60
2. Date of Death:                                       9/6/88
3. Age at time of death:                              28.66 years
4. Worklife Expectancy as of 9/6/88:           31 years
5. Life Expectancy as of 9/6/88:                 44.54 years
6. Marital Status:                                       Married, no children
7. Sex:                                                      Male
8. Race:                                                    White
9. Education:                                             High School Graduate
10. Occupation:                                         Window Washer
11. Expected Trial Date:                             12/l/89
12. Earnings at time of death:                      $25,000 / year
13. Benefits:                                              28.00% of earnings
14. Expected annual growth in wages:          5.34%
15. Discount rate (3 yr. T-Note):                 6.82%

* The life and worklife expectancy information (shown above) is obtained from VVorklife Estimates: Effects of Race and Education, U.S. Department of Labor. Bureau of Labor Statistics. February 1986. Bulletin 2254. Table A-6.

QUESTIONS

1. Calculate the present value, at the time of Jackson's death, of his lost earnings (including fringes) over his expected worklife using the present value of an annuity formula.

2. Check your answer to question 1 by calculating the Individual present values at each age and summing them. (Calculate the undiscounted and discounted streams of income separately.)

3. Discuss possible alternative approaches and problems associated with Your economic evaluation of lost wages.

4. Include a discussion of the analysis, as well as your recommendation, for this situation.

Answer 1

present value, at the time of Jackson's death, of his lost earnings
REMAING YEARS OF SERVICE	OPENING SALARY A	INCREASE B=A*5.34%	SALARY AFTER INCREASC=A+B	BENEFITS 28% OF SALARYD=(C*28%)	FINAL YEARLY SALARY AFTER INCREMENT AND BENEFITS E=(C+D)	PRESENT VALUE OF 1 @ 6.82% F =(1/1.0682)^N	PRESENT VALUE OF SALARY G=E*F
0	25000	-	-	0	25000
1	25000	1335	26335	7373.8	33708.8	0.9362	23403.86
2	33708.80	1800.0499	35508.85	9942.48	45451.33	0.8764	29541.88
3	45451.33	2427.1009	47878.43	13405.96	61284.39	0.8204	37289.70
4	61284.39	3272.5864	64556.98	18075.95	82632.93	0.7681	47069.50
5	82632.93	4412.5984	87045.53	24372.75	111418.27	0.7190	59414.20
6	111418.27	5949.7358	117368.01	32863.04	150231.05	0.6731	74996.50
7	150231.05	8022.3382	158253.39	44310.95	202564.34	0.6301	94665.49
8	202564.34	10816.936	213381.28	59746.76	273128.03	0.5899	119492.98
9	273128.03	14585.037	287713.07	80559.66	368272.73	0.5522	150831.87
10	368272.73	19665.764	387938.49	108622.78	496561.27	0.5170	190389.86
11	496561.27	26516.372	523077.64	146461.74	669539.38	0.4840	240322.56
12	669539.38	35753.403	705292.79	197481.98	902774.77	0.4531	303350.87
13	902774.77	48208.173	950982.94	266275.22	1217258.17	0.4241	382909.34
14	1217258.17	65001.586	1282259.75	359032.73	1641292.48	0.3971	483333.24
15	1641292.48	87645.019	1728937.50	484102.50	2213040.00	0.3717	610094.87
16	2213040.00	118176.34	2331216.34	652740.57	2983956.91	0.3480	770101.71
17	2983956.91	159343.3	3143300.21	880124.06	4023424.27	0.3258	972072.81
18	4023424.27	214850.86	4238275.12	1186717.03	5424992.16	0.3050	1227013.97
19	5424992.16	289694.58	5714686.74	1600112.29	7314799.03	0.2855	1548817.39
20	7314799.03	390610.27	7705409.29	2157514.60	9862923.90	0.2673	1955018.74
21	9862923.90	526680.14	10389604.03	2909089.13	13298693.16	0.2502	2467752.70
22	13298693.16	710150.21	14008843.38	3922476.15	17931319.52	0.2342	3114959.08
23	17931319.52	957532.46	18888851.98	5288878.56	24177730.54	0.2193	3931905.36
24	24177730.54	1291090.8	25468821.35	7131269.98	32600091.33	0.2053	4963108.46
25	32600091.33	1740844.9	34340936.21	9615462.14	43956398.34	0.1922	6264760.55
26	43956398.34	2347271.7	46303670.01	12965027.60	59268697.62	0.1799	7907791.06
27	59268697.62	3164948.5	62433646.07	17481420.90	79915066.97	0.1684	9981731.79
28	79915066.97	4267464.6	84182531.55	23571108.83	107753640.38	0.1577	12599595.60
29	107753640.38	5754044.4	113507684.78	31782151.74	145289836.51	0.1476	15904034.75
30	145289836.51	7758477.3	153048313.78	42853527.86	195901841.64	0.1382	20075114.27
31	195901841.64	10461158	206362999.99	57781640.00	264144639.98	0.1294	25340124.02
TOTAL PRESENT VALUE OF SAALARY					121871008.97