Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve the three in excell, they already have answers Question 1 O out of 10 points X Andrew wants to retire with $952,000.00. How

Please solve the three in excell, they already have answers

image text in transcribed

Question 1 O out of 10 points X Andrew wants to retire with $952,000.00. How much does Andrew need to save each year for 9 years if he wants to retire in exactly 9 years, can earn 8.62 percent on his savings, makes his first contribution to savings later today, and saves an equal amount each year?(ROUND THE VALUE TO O DECIMAL AND ENTER THE POSITIVE VALUE) Selected Answer: [None Given) Correct Answer: 68,390 Answer range +/- 136.78 (68253.22-68526.78) Question 2 0 out of 10 points Samuel wants to retire with $951,000.00. How much does Samuel need to save each year for 10 years if he wants to retire in exactly 10 years, can earn 12.79 percent on his savings, x starts saving in exactly 1 year, saves an equal amount each year, and has $40,000.00 in his account today? (Round the value to 0 decimal and enter the positive value) Selected Answer: [None Given] Correct Answer: 44,848 Answer range +/- 89.696 (44758.304 - 44937.696 ) Question 3 O out of 10 points How much does Gary need to save each year for 9 years as a regular savings payment if he wants to retire in exactly 9 years with $993,000.00, can earn 13.67 percent on his savings, starts making regular savings payments in exactly 1 year, and saves an equal amount each year with one exception, which is that in 3 years, he plans to make an extra contribution of $29,300.00 to savings?(ROUND THE VALUE TO O DECIMAL AND ENTER THE POSITIVE VALUE) Activate Windows Selected Answer: [None Given] Go to Settings to activate Windows, Correct Answer: 58,621 Answer range +/- 117.242 (58503.758 - 58738.242 )

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

More Books

Students also viewed these Finance questions

Question

Prepare an ID card of the continent Antarctica?

Answered: 1 week ago