We win a judgement of $200,000 now for pain and suffering. The defendant will have to pay

Fantastic news! We've Found the answer you've been seeking!

Question:

We win a judgement of $200,000 now for pain and suffering. The defendant will have to pay us next year. Additionally, he will have to pay us our salaries for 5 years. The salary 2 years ago was $100,000. The increase is 4% yearly. We deserve 3 more salaries for the next 3 years. Derive the payment he will have to give us next year, if the discount rate is 5%. Assume all data occur at the end of the year.

Can someone show the math not using excel for everything? Using formulas.

amount of salary 2 years ago	$100,000
amount of salary at the end of today's time	$100,000 (1 + 0.04)2	$108,160

Future Value (FV) of payment			calculations related to salary of next 3 years
lum sum amount next year	200,000		year 3	112486.4	107129.9
salary payment for next 3 years	$318,338.58		year 4	116985.856	106109.6
amount to be received in next	518338.5769		year 5	351137.5462	318338.6
			sum of next 3 years salary	351137.5462	318338.6
Present Value of the next year cash flow	518,338.5769		Present Value of future salary payment	318338.6