Answered: Daniel is only 20 years old. He wants…

Daniel is only 20 years old. He wants to retire as a millionaire by the time he turns 70. How much will he have to save at the end of each month at 6% compounded annually, to have 1,000,000 by age 70

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 8E

See similar textbooks

Related questions

Q: Matthew, age 37, currently makes $90,000. His wage replacement ratio is determined to be 85 percent.…

A: The amount of capital needed to be accumulated today for the retirement age of 70 will be calculated…

Q: How much money will there be in the account?

A: solution A= R(1+i)n+1/i R= Contribution half year=$425 n= number of periods=48 years - 33 years =15…

Q: Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he…

A: Annuity refers to a certain no. of payments of the same quantity made at regular intervals over a…

Q: Daniel Jackson is 30 years and wants to retire when he is 65. So far he has saved (1) $6,730 in an…

A: (1) Balance in IRA account=$6,730 Interest rate in IRA account=0.083 (2) Balance in money market…

Q: Beverly is considering starting her small family business in five years’ time. She has decided to…

A: Annuity is a stream of equal cash flows(deposits) over specified time. Where cash flow is due at the…

Q: Marilyn wishes to retire at age 65 with $2,000,000 in the bank. At the age 21, she decides to begin…

A: Calculate the monthly payments as follows:MS-Excel --> Formulas --> Financials -->PMT

Q: Sandra Jones intends to retire in 20 years at the age of 65. As yet, she has not provided for…

A: Present Value: The present value (PV) is the present sum of a series of fixed payments. The series…

Q: Evan would like to have $2,000,000 saved by the time he retires in 40 years. How much does he need…

A: Given details are : Future value of savings = $2000000 Time period = 40 years Interest rate = 110%…

Q: John, 38, makes $125,000 per year. He has a 35 year old wife, Nancy, and a daughter who just turned…

A: The disparity between the current value of currency inflows and outflows over a span of time is…

Q: Donald Trumptobe predicts that in 100 years, he will have four generations of offspring (that is,…

A: There are four generations with 2 children each, which makes a total of 16 children. Generation 1:…

Q: Jack and Jill decide each invest $5,000 in the same stock this year. However, Jack invests directly,…

A: Investment is done in various instruments to earn a return in order to have a higher amount in the…

Q: . His wage replacement ratio has been determined to be 72%. He expects inflation will average…

A: *Answer:

Q: Joanna is making a financial plan for her retirement. Today is her 35th birthday, and she receives…

A: Present Value(PV) is value of amount of series of amount that is paid or received at future date. It…

Q: Myrna is 50 years old now. She plans to retire at age 65. She wants to have half a million pesos at…

A: Future value of annuity is the recurring cashflow at regular interval compounded to future date at…

Q: Janice is hoping to save $200,000 by the time she retires in 20 years. How much must Janice deposit…

A: Future value is::$200000.. Contribution annually.. Rate of Interest is:::4%.... Required Deposit…

Q: John Adams plans to retire at the age of 62. He wants an annual income of $60,000 per year. John is…

A: Years to Retirement = 62-45 years = 17 years He expects to live another (87-62) = 25 year after…

Q: Fred is an employee of a company that specializes in repossessing aircrafts owned by private…

A: The amount required today to reach the target can be calculated as the future value of the sum.

Q: Abdulrahman is 60 years of age and has a life expectancy of 15 more years. He wishes to invest…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: A 40-year-old woman decides to put funds into a retirement plan. She can save $1,000 a year and earn…

A: We need to calculate the persent value of annuity by using this formula. PV of annuity =CF*…

Q: f Danny plans to retire at age 65, and will therefore make 45 payments into the fund, how much is…

A: Time value of money: Time value of money refers to the concept that the value of money available at…

Q: Sam is currently 30 years of age. He owns his own business and wants to retire at the age of 60.…

A: Working note for part a to c as follows:

Q: J'Mal wishes to retire at age 65. At the age of 21, he begins depositing $35 per month into an…

A: A deposit of $35 is made each month for 44 years (65 years – 21 years) at a rate of 8.5%…

Q: John is currently 25 years old. He has $10,000 saved up and wishes to deposit this into a savings…

A: John age = 25 years he saved up to = $10000 annual interest rate = 6% 0.06/12 = 0.005 every…

Q: A 45-year-old woman decides to put funds into a retirement plan. She can save $2,000 a…

A: Here, To Find: Future value of annual savings (FV) =? Annual withdrawals made for 20 years after…

Q: Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he…

A: Annuity refers to a certain no. of payments of the same quantity made at regular intervals over a…

Q: Munira Al Falasi is 40 years old. She wants to begin saving for retirement with the first payment to…

A: Future Value is the amount in future at a specified date which is equal to the value of the…

Q: Frank buys a house at age 48 for $600,000 by making a $170,000 down payment and securing a 30-year…

A: Annuity refers to series of equalized payments that are paid or received at start or ending of…

Q: Alexandra is 30 years old today, and she is planning to retire at age 65. Her current salary is…

A: The payment for retirement funds is 10% of income but because the income is increasing by 5%, the…

Q: John is currently 25 years old. He has $10,000 saved up and wishes to deposit this into a savings…

A: Present Value: The present value is the value of the sum received at time 0 or the current period.…

Q: Matt Christopher is a 30-year-old mechanical engineer, and his salary next year will be $80,000.…

A: Computation of the amount that will be saved by Matt Christopher at the age of 60 years is shown:

Q: How much should Jenson deposit today

A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…

Q: Arvin Marlacher is 25 years old today. Marlacher wants to be prepared for his retirement, and so is…

A: The question is based on the concept of Financial Management.

Q: James invests $20,000 on his 25th birthday and plans to add $2,000 to his investment each year until…

A: Investment means engaging your funds to generate income in the future. Interest is a return which is…

Q: ert is planning for his retirement in the years to come when he will reach 55. He wants to spend…

A: There is need of proper planning on proper timing so that the there would be no problem while…

Q: Your father is 50 years old and will retire in 10 years. Heexpects to live for 25 years after he…

A: An Annuity is a stream of regular periodic payments made or received for a specified period of time…

Q: Tina is exactly 25 years old and has already accumulated $18,000 of retirement savings. Her goal is…

A: Present Value of savings = 18,000 Future Value Required = Current Requirement × (1+Inflation Rate)N…

Q: Adele is planning for retirement. She would like to have $75,000 in her hand at the beginning of her…

A: Retirement means quite simple end of a phase of working for a time of years.This span of retirement…

Q: Benjamin wants to have $12,000 in 15 years after investing in an account that earns 4.2% compounded…

A: Future Value or Amount that Benjamin wants is $12,000 Time period is 15 years Interest rate is 4.2%…

Q: Justin is twenty years old and has saved 50,000. He can invest it in a real estate venture that will…

Q: On his 21st birthday, Silver put P300,000 into a retirement fund account that pays 10% interest per…

A: we need to use compound interest formula to calculate value of retainment fund at the age of 65…

Q: Leon and Heidi decided to invest $3,000 annually for only the first eight years of their marriage.…

A: The future value of a cash flow is the future worth of a cash flow at a certain rate of interest and…

Q: Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he…

Q: 20-year old woman wants to retire as a millionaire by the time she turns 50. How much will she have…

A: this is the case of the simple annuity where you pay a certain amount at the end of the year to have…

Q: Leonard wants to have $400,000 in his RRSP when he retires in 31 years. How much must he deposit at…

A: Here, Required Amount (FV) is $400,000 Time Period (n) is 31 years Interest Rate (r) is 4.8%…

Question

Daniel is only 20 years old. He wants to retire as a millionaire by the time he turns 70. How much will he have to save at the end of each month at 6% compounded annually, to have 1,000,000 by age 70

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Anthony is 30 years old and just received an inheritance from his parents' estate. He wants to invest an amount of money today such that he can receive P50,000 at the end of every month for 15 years when he retires at age 65. If money earns at 9% compounded monthly, how much money must he invest today?
Jack is 23 years old. He earns $1,800 fortnightly after tax from his full-time job. He estimates that he will need to have $4.5 million by the time he retires at 65 years old in order to live comfortably. So, he starts planning for his retirement by saving a third of his income and investing it fortnightly in a pension plan that yields a return of 7.5% per year. Assuming his fortnightly income and the pension plan’s return stay the same until he retires, can he reach his retirement goal? (Note: there are 52 weeks in a year). You must show your calculations or your inputs to Excel or financial calculator.
John graduates from college at the age of 25. He places $5,000 in a 401k at the beginning of year one, $8,000 at the beginning of year two, $11,000 at the beginning of year three, $14,000 at the beginning of year four, andthen $15,000 per year until he retires at the age of 60. If money earns 8 percent per year, how much will John have in his retirement account at age 60?
Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. a) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. b) Alternatively, how much would she have to invest in equal monthly amounts starting at the end of the current year or month respectively.
Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. A) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. B) Alteratively, how much would she have to invest in equal monthly amounts starting at the end of the current year or monthly respectively.
Jordan is 55 and wants to retire in 12 years. His family has a history of living well into their 90s. Therefore, he estimates that he will live to age 97. He currently has a salary of $100,000 and expects that he will need about 82% of that amount annually if he were retired. He can earn 9 percent in his portfolio and expects inflation to continue at 3 percent. Jordan currently has $325,000 invested for his retirement. His Social Security benefit in today’s dollars is $30,000 per year at normal age retirement of age 67. How much does he need to save each year at year end to meet his retirement goals? 1. $6,245. 2. $7,659. 3. $8,432. 4. $9,252.
John is currently 25 years old. He has $10,000 saved up and wishes to deposit this into a savings account which pays him J12 = 6% p.a. He also wishes to deposit $X every month into that account so that when he retires at 55, he can withdraw $2000 every month end to support his retirement. He expects to live up till 70 years. How much should he deposit every month into his account?
Sam is currently 30 years of age. He owns his own business and wants to retire at the age of 60. He has little confidence in the Social Security system. He wants to retire with an annual income of $72,000. a. If Sam believes he will live to age 90, how much does he have to accumulate by the time he reaches age 60 to receive $72,000 at the end of each year for the rest of his life? Sam believes he can earn 8 percent on his money in a stock mutual fund. $810,560.40 b. How much does he have to accumulate if he wants the payment of $72,000 at the beginning of each year? $875,405.23 c. What dollar amount of interest will Sam have earned during retirement if he receives his $72,000 at the beginning of each year?
A 20-year old woman wants to retire as a millionaire by the time she turns 50. How much will she have to save at the end of each year if she can earn 5% compounded annually, to have $100,000 by the time she is 50?
Jamie wants to have $1,000,000 for her retirement in 25 years. How much should she save annually if she thinks she can earn 10% on her investments?
Sam is currently 30 years of age. He owns his own business and wantsto retire at the age of 60. He has little confidence in the current SocialSecurity system. He wants to retire with an annual income of $72,000a year.a. If Sam believes he will live to age 90, how much does he have to accumulateby the time he reaches age 60 to receive $72,000 at the end of each yearfor the rest of his life? Sam believes he can earn 8 percent on his money in astock mutual fund.b. How much does he have to accumulate if he wants the payment of $72,000at the beginning of each year?c. What dollar amount of interest will Sam have earned during retirement if hereceives his $72,000 at the beginning of each year?
Colin is 40 years old and wants to retire in 27 years. His family has a history of living well into their 90s. Therefore, he estimates that he will live to age 95. He currently has a salary of $150,000 and expects that he will need about 75% of that amount annually if he were retired. He can earn 8 percent from his portfolio and expects inflation to continue at 3 percent. Some years ago, he worked for the government and expects to receive an annuity that will pay him $20,000 in today's dollars per year beginning at age 67. The annuity includes a cost of living adjustment, which is equal to inflation. Colin currently has $200,000 invested for his retirement. His Social Security benefit in today's dollars is $30,000 per year at normal age retirement of age 67. How much does he need to accumulate at age 67 exclusive of his pension and Social Security benefits? ANSWER CHOICES: $2.2 million $2.1 million $2.8 million $2.9 million