a) Approximately how long (approximate years) would it take if you put in a lump sum to double at the rate above? b) How much will you have after 43 years if you deposit $5,214 at the end of each year? c) How much will you have after 43 years if instead, you deposit $100 at the end of each week instead (forget about the leap years, pretend there are 52.14 weeks per year for the next 43 years) at the same growth rate?

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...
icon
Related questions
Question

Please show excel formulas

Let's say you are 27 years old and planning on retiring when you are 70. You plan on saving and
depositing into an account that yields, on average, 5% per year. You do not intend to take out any
principle or interest until you retire.
a) Approximately how long (approximate years) would it take if you put in a lump sum to double at
the rate above?
b) How much will you have after 43 years if you deposit $5,214 at the end of each year?
c) How much will you have after 43 years if instead, you deposit $100 at the end of each week
instead (forget about the leap years, pretend there are 52.14 weeks per year for the next 43 years)
at the same growth rate?
d) How long (in years) would you need to save in order to save $1,000,000 if you deposited $100
weekly and there are still only 52.14 weeks in the year at the growth rate above?
e) What rate would you need to receive if you started to save at age 35 for 35 years, if you deposit
$5,214 at the end of each year (forget about the leap years) to have $1,000,000?
f) After retirement, you expect an average return of 2%. If you expect to live another 20 years,
how much can you take out monthly for 20 years to totally exhaust your funds from your answer
in part b (no money left over)?
Transcribed Image Text:Let's say you are 27 years old and planning on retiring when you are 70. You plan on saving and depositing into an account that yields, on average, 5% per year. You do not intend to take out any principle or interest until you retire. a) Approximately how long (approximate years) would it take if you put in a lump sum to double at the rate above? b) How much will you have after 43 years if you deposit $5,214 at the end of each year? c) How much will you have after 43 years if instead, you deposit $100 at the end of each week instead (forget about the leap years, pretend there are 52.14 weeks per year for the next 43 years) at the same growth rate? d) How long (in years) would you need to save in order to save $1,000,000 if you deposited $100 weekly and there are still only 52.14 weeks in the year at the growth rate above? e) What rate would you need to receive if you started to save at age 35 for 35 years, if you deposit $5,214 at the end of each year (forget about the leap years) to have $1,000,000? f) After retirement, you expect an average return of 2%. If you expect to live another 20 years, how much can you take out monthly for 20 years to totally exhaust your funds from your answer in part b (no money left over)?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage