You are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five years before the plaintiff is able to return to work. The jury has already decided in favor of the plaintiff. You are the foreperson of the jury and propose that the jury give the plaintiff an award to cover the following: (1) The present value of two years back pay. The plaintiffs annual salary for the last two years would have been $31,000 and $34,000, respectively. (2) The present value of five years future salary. You assume the salary will be $38,000 per year. (3) $100,000 for pain and suffering. (4) $10,000 for court costs. Assume that the salary payments are equal amounts paid at the end of each month. If the interest rate you choose is an EAR of 7 percent, what is the size of the settlement?

Can Someone Please Show Either Financial Calculator or Excel Process for this problem