Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes. (a) Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return. If Lindsay invests $13,000 at an annual return of 7%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.) $ (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 0% to 12% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for annual rates ranging from 7% to 9% to accrue a final value of $1,100,000 after 30 years? (Round your answers up to the nearest thousand dollars.) Annual Return Minimum Annual Investment 7% $ 8% $ 9% $
Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes. (a) Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return. If Lindsay invests $13,000 at an annual return of 7%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.) $ (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 0% to 12% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for annual rates ranging from 7% to 9% to accrue a final value of $1,100,000 after 30 years? (Round your answers up to the nearest thousand dollars.) Annual Return Minimum Annual Investment 7% $ 8% $ 9% $
Chapter12: Tax Credits And Payments
Section: Chapter Questions
Problem 35P
Related questions
Question
Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes.
(a)
Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return . If Lindsay invests $13,000 at an annual return of 7%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.)
$
(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 0% to 12% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for annual rates ranging from 7% to 9% to accrue a final value of $1,100,000 after 30 years? (Round your answers up to the nearest thousand dollars.)
Annual |
Minimum Annual Investment |
---|---|
7% | $ |
8% | $ |
9% | $ |
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT