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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Use synthetic division to divide 24 9 10x 4x 3 by z 1 The quotient...

Finance
1.2K views

Why do we, as consumers, prefer the prices found in competitive markets? How are the prices...

Accounting
1.2K views

JY investment Ltd holds a well-diversified portfolio of shares that has a market value of $1.5...

Biology
1.2K views

Which of the following is NOT a belief of Transcendentalists O Everything in the world...

Basic Math
1.2K views

An open-top box is to be made from a square piece of cardboard that measures...

Accounting
1.2K views

Antaean Company set the following standard costs for one unit of its product. Direct materials...

Accounting
1.2K views

Birken Company manufactures shopping bags made of recycled plastic that it plans to sell for...

Accounting
1.2K views

8. A Government of Canada V121780 issue 364-day T-bill achieved its highest rate of return...

Accounting
1.2K views

On January 1, 2019, ABC Company leased office equipment from ZZ, Inc. The lease terms...

Accounting
1.2K views

HiLi Corporation had the following bond issue: Date of issue/sale: May 1, 20-A Principal: $500,000...

Accounting
1.2K views

The names of the employees of Hogan Thrift Shop are listed on the following payroll...

Finance
1.2K views

Below is list of companies and their stock prices, and the amount of their outstanding...