.Your client wants to have $2 million in her retirement account in 20 years. How much should the client deposit in the account at the end of each year to achieve her goal if we assume an annual return of 8%?

.Your client wants to have $2 million in her retirement account in 20 years. How much should the client deposit in the account at the end of each year to achieve her goal if we assume an annual return of 8%?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 23P

See similar textbooks

Related questions

Q: Marie, an employee at McCormick, has determined that she will need $5500 per month in retirement…

A: An annuity is a series of cash flows with an equal amount occurring at equal time intervals for a…

Q: Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40…

A: Calculate Value of the amount at age of 65 as below: Resultant table: Hence, plan has value of…

Q: When you retire, you plan to draw $50,000 per year from your retirement accounts, which will be…

A: Here, Annual payment = $50,000 Interest rate = 6% Number of periods = 10 years To Find: PV of…

Q: money should he have

A: A retirement plan refers to the financial strategies of saving, investments, or distributing money…

Q: Using the Time Value of Money for Retirement Planning. Carla Lopez deposits $3,400 a year into her…

A: Given: Annual deposit = $3,400 Interest rate = 9% Number of years = 40 Value of the retirement…

Q: When you retire, you plan to draw $50,000 per year from your retirement accounts, which will be…

A: Annuity is the no. of payments which are equal in size and made in equal interval of time. Person…

Q: How much (in $) would the account be worth after 10 years?

A: Note: Since you have posted a question with multiple sub-parts, we will solve the first three…

Q: You will need to deposit $_______ each quarter.

A: Future Value of Annuity: It is computed by compounding the present stream of annuity cash flows…

Q: Upon retirement, your goal is to spend 6 years traveling around the world. To travel in the style to…

A: Given Information: Periodic payment = $225,000 Rate of interest = 9% compound annually Period = 24…

Q: (a) She wants her first payout to have the same purchasing power as does $17,000 today. How big…

A: Note: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts…

Q: Peter has opened a retirement investment account and plan to contribute $6,000 at the end of each…

A: Expected return is calculated by excel function RATE. For RATE function, future value FV is the…

Q: You want to receive $8,000 per month in retirement. If you can earn 0.6% return per month and you…

A: You want to receive $8,000 per month in retirement. If you can earn 0.6% return per month and you…

Q: You have decided that in order to have a comfortable retirement you will need to replace $65,000 in…

A: Using excel PV function

Q: How much does your client need to contribute to a fund each month for the next 25 years (first…

A: Annuity refers to an amount or stream of equal cash flows (CF) paid or received periodically.…

Q: Please provide working to the solution for the question below: Suppose you are 40 years old and…

A: Solution:- When an equal amount is deposited each period, it is called annuity. We know, Present…

Q: When you retire 40 years from now you plan to make 10 withdrawals from your savings account. You…

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

Q: As part of your financial planning and to supplement your retirement, you decided to save $3000 at…

A: Future value is the expected value of the current amount at a future date at a given specific rate…

Q: Suppose you wish to retire 30 years from today .You have determined that you would need $75,000…

A: The question is to find the present value of expected cash flow made at regular intervals. The…

Q: Linda expects to receive P35,569.22 , 9 years from now. How much should she invests for three…

A: Annuity is the series of payment made by an investor over the period of time to accumulate future…

Q: Suppose that you’d like to retire in 40 years and you want to have a future value of $ 1000000 in a…

A: Annuity(monthly instalment) is calculated by annuity from future value formula: Annuity from future…

Q: hat effective annual rate of return (EAR) would Rayne need to earn if she deposits R1,000 per month…

A: Solution:- When an equal amount is paid each period at end of period, it is called ordinary annuity.…

Q: You want to be able to withdraw $40,000 from your account each year for 25 years after you retire.…

A: Hi, since you have posted a question with multiple sub-parts, we will answer the first three, as per…

Q: Without using Excel and using the formula, Cheryl is setting up a payout annuity and wishes to…

A: Present Value of annuity refers to the present value of all the future payments of and series of…

Q: Alejandra Marrufo wants to know how much she should deposit today, so that in 10 years she will have…

A: Time value of money (TVM) refers to the concept which proves that the value of money today is higher…

Q: How much will Bill Rodgers need to invest today so that he may withdraw $7,000 each year for the…

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

Q: How much should you invest each quarter if you can earn a rate of 4.8% compounded quarterly? How…

A: To find the payment per quarter one can use “ pmt function “ in excel. To find the total money we…

Q: deposits

A: Introduction: The term annuity refers to series of payments which are made at intervals. Examples of…

Q: In planning for your retirement, you have decided that you would like to be able to withdraw $60,000…

A: When a payment is done repeatedly for a specific period of time it is referred to as Annuity.…

Q: You have finished your time at Kelley and need to start thinking about retirement. You plan on…

A: Given: amount required after retirement at every six months = $75,000 Period of service = 30 years…

Q: You are offered the opportunity to put some money away for retirement. You will receive four annual…

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

Q: You estimate that by the time you retire in 35 years, you will have accumulated savings of $2…

A: This is typical problem of present value of growing ANNUITY.

Q: what effective annual rate of return would rayne need to earn if she deposits 1,000 per month into…

A: Monthly deposit (PMT) of $1000 is made for a period of 36 (12*30) with a future value of the deposit…

Q: Suppose you are 30 years old and would like to retire at age 60. Moreover, you would like to have a…

A: Present Value of annuity = P* [{(1+r)^n-1}/r] Where, Present Value of annuity = 350000 P = Annuity…

Q: Considering inflation, Joanna is advised that she will need $4,500 a month for living expense once…

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

Q: Polin needs to accumulate$10,000. To do so she plans to make deposits of $1250 per year with the…

A: Annuity refers to series of equalized payments that are either made at start or end of specific…

Q: Suppose Jennifer deposits $500 in an account at the end of this year. $400 at the end of the next…

A: We need to use compound interest formula to solve this problem A =P(1+i)n Where A= final payment…

Q: want to be able to withdraw $40,000 from my account each year for 30 years after I retire. I expect…

A: The present value method is an important concept of the time value of money. It can determine the…

Q: You now know the power of compound starting to save for your retirement as early as possible. You…

A: In arithmetic growing annuity amount each year increase by fixed amount but this amount grow much…

Q: Suppose you have estimated that you will need $2,500 per month in your retirement to meet your…

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

Q: Suppose that you just turned 25, plan to retire at 65, and estimate that you will need $9,049 per…

A: Annuity means no. of finite payments which are same in size and made in equal intervals. Person gets…

Q: Suppose that you earn $45,600 per year. What is your monthly salary? Assume that you deposit 10% of…

A: Future value of annuity The future value of annuity refers to the total value of the investment at…

Q: You want to supplement your retirement income through a retirement account. You have 15 years left…

A: First withdrawl amount is $15,000 Growth rate is 5% Starting year of Withdrawal is 16th Ending Year…

Q: Carlo Aldric wants to have P40,000 per year for 15 years during his retirement. What amount would…

A: Annual amount (P) = 40,000 Interest rate (r) = 5% Period (n) = 15 Years

Q: You want to begin saving for your retirement. You plan to contribute $12,000 to the account at the…

A: Since you have asked multiple questions, we will solve the first question for you. Please resubmit…

Q: As an engineer, you plan to put aside 20% of your yearly income. You expect to make Php1 million in…

A: The question is based on the concept of future value of money which says that future value of money…

Q: You expect to retire in 25 years. After you retire, you want to be able to withdraw $3000 dollars…

A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at…

Concept explainers

Amortized Loans

The term "amortization" refers to spreading the value of a loan or a debt over a series of regular payments or installments comprising of both the principal and interest amount. It generally involves the process where in the value of a loan or an intangible asset is written down over its maturity period.

Question

I need help solving the probelm below in excel

8.Your client wants to have $2 million in her retirement account in 20 years. How much should the client deposit in the account at the end of each year to achieve her goal if we assume an annual return of 8%?

Expert Solution

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!

SEE SOLUTION Check out a sample Q&A here

Step 1 given data

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 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

Suppose you are 30 years old and would like to retire at age 60. Furthermore, you would like to have a retirement fund which you can draw an income of $1250,00 per year- forever! How much would you need to deposit each month to do this? Assume a constant APR of 6% and that compounding and payment periods are the same. To draw $125000 per year there must be $____ in your saving account when you retire.
Suppose you wish to retire 30 years from today .You have determined that you would need $75,000 annually once you retire, which you will withdraw at the end of each year. You estimate that you will earn 6% on your retirement funds, compounded annually, and that you will live for 20 years after retirement. how much funds would you need on retirement to fullfill your goals above.?
Suppose that in retirement I want to have an account that will pay me $3,850 per month. I expect this account will earn 4.25% while I am drawing income from it, and I want the payments to last for 30 years. How much money would I need to achieve this?
You want to be able to withdraw $35,000 from your account each year for 20 years after you retire. If you expect to retire in 30 years and your account earns 7.9% interest while saving for retirement and 7.7% interest while retired:Round your answers to the nearest cent as needed.a) How much will you need to have when you retire?$b) How much will you need to deposit each month until retirement to achieve your retirement goals?$c) How much did you deposit into you retirement account?$d) How much did you receive in payments during retirement?$e) How much of the money you received was interest?
Suppose you have estimated that you will need $2,500 per month in your retirement to meet your expenses and live comfortably, and that you have found or chosen a fund (account) which pays monthly interest 4% APR . What principal, or balance, will your account need to maintain in order to be able to pay you this amount each month? Round/take your answer to the nearest cent.
You want to be able to withdraw $25,000 from your account each year for 30 years after you retire. You expect to retire in 20 years. If your account earns 8% interest, how much will you need to deposit each year until retirement to achieve your retirement goals?
Suppose you are 35 years old and would like to retire at age 65. Furthermore, you would like to have a retirement fund from which you can draw an income of $50,000 per year–forever!How much would you need to deposit each month to dothis? Assume a constant APR of 8% and that the compounding and payment periods are the same. To draw $50,000 per year, there must be $ in your savings account when you retire. You can reach your goal by making monthly deposits of $
You want to be able to withdraw $35,000 from your account each year for 15 years after you retire.You expect to retire in 25 years.If your account earns 10% interest, how much will you need to deposit each year until retirement to achieve your retirement goals?
using excel: How much money must you invest today in order to withdraw the following monthly payments in retirement, $1,000 per month from Year 1 through Year 5, $750 per month from Year 6 through 10? Assume you can earn a rate of return of 8.60%.
Please provide working to the solution for the question below: Suppose you are 40 years old and plan to retire in exactly 20 years. 21 years from now you will need to withdraw RM5,000 per year from a retirement fund to supplement your social security payments. You expect to live to the age of 85. How much money should you place in the retirement fund each year for the next 20 years to reach your retirement goal if you can earn 12% interest per year from the fund?
You have just made your first $5,000 contribution to your retirement account. Assume you earn a return of 10 percent per year and make no additional contributions. What will your account be worth when you retire in 45 years? What if you wait 35 years before contributing? (show answer using function feature in excel)
Suppose you wish to retire forty years from today. You determine that you need RM50,000 per year once you retire, with the first retirement funds withdrawn one year from the day you retire. You estimate that you will earn 6% per year on your retirement funds and that you will need funds up to 25 years after retirement. a) Calculate the amount you must deposit in an account today so that you have enough funds for retirement b) Calculate the amount you must deposit each year, starting one year from today, so that you have enough funds for retirement.