Question

After he was injured in a car accident, the insurance company promised to pay Fred $2,000...

After he was injured in a car accident, the insurance company promised to pay Fred $2,000 per month for 8 years. Assuming Fred's opportunity cost is 10.5 percent annually, what is the present value of Fred's settlement?

Solve using excel cell functions

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Period (in years) 8
Monthly payment $2,000
Opportunity cost 10.5%
Future value $0
Present value $129,533.54

Calculations

А 2 3 Period (in years) Monthly payment Opportunity cost Future value 2000 0.105 4 5 =PV(B4/12,B2*12,-B3,B5)

Payment is monthly. so opportunity cost will be monthly and period will also be in months.

monthly payment is entered as negative value so that formula gives present value as positive value.

Add a comment
Know the answer?
Add Answer to:
After he was injured in a car accident, the insurance company promised to pay Fred $2,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. Fred was on the seven year plan at the University of South Carolina and racked...

    1. Fred was on the seven year plan at the University of South Carolina and racked up $98,000 in student loans, which carry an annual interest rate of 10.8 percent and require monthly payments. His mom has offered to help him pay them off, but she wants to see him become responsible (good luck on that). She has said that if he pays off half of the debt within three years, she will pay the rest. How much would Fred...

  • Due to a car accident you receive a settlement from insurance of $50 a month for...

    Due to a car accident you receive a settlement from insurance of $50 a month for the next ten years. What is that worth to you today, assuming a 3% inflation rate? Show equations and work.

  • Due to a car accident you receive a settlement from insurance of $50 a month for...

    Due to a car accident you receive a settlement from insurance of $50 a month for the next ten years. What is that worth to you today, assuming a 3% inflation rate? Show equation and work.

  • Due to a car accident you receive a settlement from insurance of $50 a month for...

    Due to a car accident you receive a settlement from insurance of $50 a month for the next ten years. What is that worth to you today, assuming a 3% inflation rate? Show all work.

  • 3. Joe Smo was recently involved in an accident. Based on the settlement he will receive...

    3. Joe Smo was recently involved in an accident. Based on the settlement he will receive $1,000,000. According to the settlement, the insurance company will pay him $500,000 today of which three hundred thousand will go to the lawyer. Joe Smo will receive $50,000 for eight years. At the end of the eighth year, he will receive the remaining $100,000. Assuming the discount rate is 8 percent, what is the present value of the funds Joe Smo will receive? (She...

  • Stephanie was injured in a car accident and was rushed to the emergency room. She received...

    Stephanie was injured in a car accident and was rushed to the emergency room. She received stitches for a facial wound and treatment for a broken finger. Under Stephanie’s PPO plan, emergency room care at a network hospital is 70 percent covered after the member has met a $300 annual deductible. Assume that Stephanie went to a hospital within her PPO network. Her total emergency room bill was $840. (a) What amount did Stephanie have to pay? (Do not round...

  • 3. You are deciding between leasing or purchasing a car and you need the car for...

    3. You are deciding between leasing or purchasing a car and you need the car for the next four years. The details of these two alternatives are discussed below. Buy The initial cost will be $35,000. There will be major maintenance every two years, costing $2,000. The annual insurance on the car will cost $3,200 annual and the gas will cost $1,800 annually. You expect to sell the car for $8,000 dollars at the end of the four years. Lease...

  • 475 Fred is evalaating whether a more efficient monon with a life of 5 years should...

    475 Fred is evalaating whether a more efficient monon with a life of 5 years should be insalled on an assembly line. If the interest rate is 10%. what is the present value of the energy savings (a) Energy savings are estimated at $4000 for the first year,then increasing by 7%-anually (b) What if the energy savings are increasing by 12% annually? 438 An engineering student bought acar ata local wed car lot. Including tax and insurance, the sotaill price...

  • Please solve using a BA II Plus calculator and not using NPV. Fred is looking at...

    Please solve using a BA II Plus calculator and not using NPV. Fred is looking at an investment that would pay him nothing until five years from today and then he would receive $40,000 every six months for ten years (20 payments) with the first payment coming five years from today. He then would receive $100,000 every year for ten years with the first of these coming six months after the last payment of $40,000. Finally he would receive two...

  • An engineering student bought a car at a local used car lot. Including tax and insurance,...

    An engineering student bought a car at a local used car lot. Including tax and insurance, the total price was $15,000. He is to pay for the car in 13 equal monthly payments, beginning with the first pay- ment immediately (the first payment is the down payment). Nominal interest on the loan is 12%, com- 4-38 monthly. After six payments he decides to sell the car. A buyer agrees to pay off the loan in full and to pay the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT