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

60.1K

Verified Solution

Question

Statistics

Lindsay is 30 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 25 years. (a)Construct a data table in Excel that will show Lindsay the balanceof her retirement account for various levels of annual investmentand return. If Lindsay invests $10,000 at return of 6%, what wouldbe the balance at the end of the 25th year? Note that becauseLindsay invests at the end of the year, there is no interest earnedon the contribution for the year in which she contributes. Roundyour answer to a whole dollar amount. $ (b) Develop a two-way tablefor annual investment amounts of $5,000 to $20,000 in increments of$1,000 and for returns of 0% to 12% in increments of 1%. From the2-way table, what are the minimum annual investments Lindsay’s mustcontribute for annual rates ranging from 6% to 11%, if she wants toaccrue a final payout of at least $1 million? Note that becauseLindsay invests at the end of the year, there is no interest earnedon the contribution for the year in which she contributes. AnnualReturn Minimum Annual Investment 6% $ 7% $ 8% $ 9% $ 10% $ 11%$

***Please use excel and upload excel screenshotwith formula

Answer & Explanation Solved by verified expert
3.8 Ratings (509 Votes)
    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