Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. lindsay is 27 years old and has a new job in web d

Lindsay is 27 years old and has a new job in web development. She wants to...

60.1K

Verified Solution

Question

Statistics

Lindsay is 27 years old and has a new job in web development.She wants to make sure that she is financially sound by the age of55, so she plans to invest the same amount into a retirementaccount at the end of every year for the next 28 years.

(a)Construct a data table in Excel that will show Lindsay thebalance of her retirement account for various levels of annualinvestment and return. If Lindsay invests $10,000 at return of 6%,what would be the balance at the end of the 28th year?Note that because Lindsay invests at the end of the year, there isno interest earned on the contribution for the year in which shecontributes. Round your answer to a whole dollar amount.
$
(b)Develop a two-way table for annual investment amounts of $5,000to $20,000 in increments of $1,000 and for returns of 0% to 12% inincrements of 1%. From the 2-way table, what are the minimum annualinvestments Lindsay’s must contribute for annual rates ranging from6% to 11%, if she wants to accrue a final payout of at least $1million? Note that because Lindsay invests at the end of the year,there is no interest earned on the contribution for the year inwhich she contributes.
Annual ReturnMinimum Annual Investment
6%$
7%$
8%$
9%$
10%$
11%$

Answer & Explanation Solved by verified expert
4.1 Ratings (496 Votes)
ANSWERNOTE I HOPR THIS ANSWER    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Although rare, tied swimming races occur with some frequency. In fact, at the 2016 Olympics...

Algebra
Q

Evaluating Reports MC The dot plot below shows the number of hours of sleep preferred...

Statistics
Q

1. If viruses were to be c;classified in manner similar to the classification of organisms, the...

Biology
Q

Why have cultures around the world historically tended to permit the recreational use of caffeine, alcohol...

Psychology
Q

What is “duty”? How do we distinguish duties from other acts that we think we should...

Psychology
Q

Strategic Plan Discussion Budgeting is very important to any business as the budget serves as the financial “roadmap”...

Finance
Q

In the figure the ball A is released from rest when the spring is at...

Physics
Q

Therefore we need to differentiate each side of our area equation with respect to t...

Calculus
Q

Let P 3 4 and Q 2 6 be two points in the coordinate plane...

Algebra
Q

ZOOM + 1. Calculate the actual and budget department profit margins (remember profit margins are...

Accounting
Q

Show Attempt History Current Attempt in Progress The following information pertains to Tamarisk, Inc.. 1....

Accounting
Q

A department had 12,500 units which were 20% complete in beginning Goods in Process Inventory....

Accounting