Question
Please answer ASAP An insurance company is offering a new policy to its customers. Typically, the policy is bought by a parent or grandparent for
Please answer ASAP
An insurance company is offering a new policy to its customers. Typically, the policy is bought by a parent or grandparent for a child at the childs birth. The details of the policy are as follows: The purchaser (say, the parent) makes the following six payments to the insurance company:
First birthday: | $ 770 |
---|---|
Second birthday: | $ 770 |
Third birthday: | $ 870 |
Fourth birthday: | $ 870 |
Fifth birthday: | $ 970 |
Sixth birthday: | $ 970 |
After the childs sixth birthday, no more payments are made. When the child reaches age 65, he or she receives $361,000.
If the relevant interest rate is 11 percent for the first six years and 7 percent for all subsequent years, what is the value of the policy at the child's 65th birthday?
Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
Please make sure all answers are correct.
Please answer by showing how to complete it in Excel.
Please answer ASAP
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started