Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you show me how to calculate that in excel !!! with formulas to put in Thank you An insurance company is offering a new

can you show me how to calculate that in excel !!! with formulas to put in Thank you image text in transcribed
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 child's birth. For this policy, the purchaser, say, the parent, makes the following six payments to the insurance company: First birthday Second birthday Third birthday Fourth birthday Fifth birthday Sixth birthday $ 760 $ 760 $ 860 $ 850 $ 960 $ 950 After the child's sixth birthday, no more payments are made. When the child reaches age 65, he or she receives $260,000. If the relevant interest rate is 10 percent for the first six years and 7 percent for all subsequent years, what would the value of the deposits be when the policy matures? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Future value

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

Makers And Takers The Rise Of Finance And The Fall Of American Business

Authors: Rana Foroohar

1st Edition

0553447238, 978-0553447231

More Books

Students also viewed these Finance questions

Question

6-23. Marketing brochureyour opinion

Answered: 1 week ago

Question

6-26. No prob; happy2help!

Answered: 1 week ago

Question

6-25. IMHO, our quad turbo sprayer is best model 4U.

Answered: 1 week ago