Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would you solve this using excel formulas, step by step? An insurance company is offering a new policy to its customers. Typically, the policy

How would you solve this using excel formulas, step by step?

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: $ 790 Second birthday: $ 790 Third birthday: $ 890 Fourth birthday: $ 890 Fifth birthday: $ 990 Sixth birthday: $ 990 After the childs sixth birthday, no more payments are made. When the child reaches age 65, he or she receives $370,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? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Stability Website Fraud Confidence And The Wealth Of Nations

Authors: Frederick L. Feldkamp, R. Christopher Whalen

2nd Edition

1118935799, 978-1118935798

More Books

Students also viewed these Finance questions

Question

=+ What about the use of language and the tone of the text?

Answered: 1 week ago