Purchase Solution

Insurance Policy Value

Not what you're looking for?

Ask Custom Question

A well-known insurance company offers a policy for children. Typically, a parent or grandparent buys a policy for a child at the child's birth. the details of the policy are as follows. The purchaser makes the following six payments to the insurance company:

1st birthday: $750
2nd birthday: $750
3rd birthday: $750
4th birthday: $800
5th birthday: $800
6th birthday: $800

No more payments are made after the child's sixth birthday. When the child reaches the age of 65, he or she receives $250,000. If the relevant interest rate is 6% for the first 6 years and 7% for all subsequent years, is the policy worth buying? (Must use Microsoft Excel)

Purchase this Solution

Solution Summary

This solution uses Microsoft Excel to derive at the value of an insurance policy.

Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.