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
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
ADVERTISEMENT