Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please show all work and excel formulas 7 b 9 0 1

please show all work and excel formulas 7 B 9 0 11 2 You...

50.1K

Verified Solution

Question

Finance

image

please show all work and excel formulas

7 B 9 0 11 2 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 plaintiff's annual salary for the last two years would have been $35,000 and $38,000, respectively. (2) The present value of five years' future salary. You assume the salary will be $42,000 per year. (3) $100,000 for pain and suffering. (4) $14,000 for court costs. 14 15 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 9 percent, what is the size of the settlement? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Size of the settlement 17 18 19 20 21 22 23 24 25 26 27 28 29 30 If you were the plaintiff, would you like to see a higher or lower Interest rate? Higher interest rate O Lower interest rate

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Is the function described in the table below concave up or concave down X g...

Finance
1.2K views

1. Which of the following statements is most CORRECT regarding sunk costs? A) An example of a...

Physics
1.2K views

A shot-putter throws the shot with an initial speed of 11.2 m/s from a height of...

Basic Math
1.2K views

assume a normal distribution with a mean of 65 and standard deviation of 14 find P(56

Biology
1.2K views

Which features are synapomorphies of primates Select all that apply they have grasping hands they...

Physics
1.2K views

2 b Solve for i t in circuit as shown in Fig 4 in which...

Statistics
1.2K views

I toss a penny and observe whether it lands heads up or tails up. Suppose...

Statistics
1.2K views

You are measuring the length of squirrels from different sides of the Grand Canyon, to...

Accounting
1.2K views

Lexa, a single taxpayer, worked as an employee during the first half of the year,...

Accounting
1.2K views

Journalize the following transactions, using the allowance method of accounting for uncollectible receivables. Journalize the...

Accounting
1.2K views

in excel, create a One-Variable Data Table that will take the ODD numbers from 1...

Accounting
1.2K views

Kubin Company's relevant range of production is 20,000 to 23,000 units. When it produces and...