Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. help lindsay is 27 years old and has a new job

help Lindsay is 27 years old and has a new job...

80.2K

Verified Solution

Question

Accounting

help
image
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 of 55 , so she plans to invest the same amount into a retirement account at the end of every year for the next 28 years. (a) Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $10,000 at return of 6%, what would be the balance at the end of the 28 th year? Note that because Lindsay invests at the end of the yeac, there is no interest earned on the contribution for the year in which she contributes. Round your answer to a whole dollar amount. (b) Develop a two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of o\% to 12% in increments of 1%5. From the 2-way table, what are the minimum annual investments Lindsay must contribute for annual rates ranging from 6% to 114%, if she wants to accrue a final payout of at least $1 million? Note that because Lindsay invests at the end of the year, there is no interest eamed on the contribution for the year in which she contributes

Answer & Explanation Solved by verified expert
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

Biology
1.2K views

Please answer ALL parts of the question fully with detailed explanations. #Q5 a)Looking at the rat’s heart, how...

Physics
1.2K views

True/False: Because hot water cools down faster than cold water, an ice cube tray filled with...

Biology
1.2K views

Bacteria have organelles membrane bound structures in the cytoplasm O True O False

Geometry
1.2K views

ind the translation rule and the scale factor of the dilation that transforms Ol to...

Basic Math
1.2K views

2 Bir tabelada 3 biletin fiyat n n 22 50 dolar 7 biletin fiyat n...

Basic Math
1.2K views

Question 8 Study the graph below and answer the question which follows 8 7 6...

Calculus
1.2K views

29 Find the second derivative of g x e ln 4x

Algebra
1.2K views

Use the given functions fand g to find f g f g fg and f...

Accounting
1.2K views

G3 Companys cash budget for March shows cash available of $60,000 and cash payments of...

Accounting
1.2K views

Waterways Corporation is preparing its budget for the comingyear, 2022. The first step is to...

Accounting
1.2K views

Problem 22-3A Manufacturing: Preparation and analysis of budgeted income statements LO P3 Merline Manufacturing makes...

Accounting
1.2K views

Moss Co. issued $37,000,000 of four-year, 12% bonds with interest payable semiannually, at a market...