Laura wants to accumulate $150,000 in her bank account by depositing $1000 at the beginning of each month. If interest on the account is 5% compounded quarterly, for how long does Laura have to deposit the money? Please include the cashflow diagram and what kind of annuity formula can we use on this question aside from the excel format?

Q: A person plans to make equal monthly deposits into this account for 20 years at the rate of 6%…

A: Present Value of annuity refers to the value of regular cash flows or payments at equal intervals at…

Q: suppose that you would like to save $20,000 over 5 years to use as a down payment for a house by…

A: Computation of monthly deposit:Hence, the monthly deposit into the account is $301.66 per month.

Q: anny is saving towards his vacation. He has determined that the total cost including airfare and…

A: Given:   Cost of vacation 5000 Monthly savings  400 Time of deposit Month-end Annual…

Q: Holly Krech is planning for her retirement, so she is setting up a payout annuity with her bank. She…

A: Given: Holly Krech is planning for her retirement, so she is setting up a pay-out annuity with her…

Q: Suppose that a person deposits $2500 in a savings account at the end of each year for the next 15…

A: Here, Annual Deposits is $2,500 Interest Rate is 8% Compounding Period is Daily i.e. 365 Payment…

Q: Suppose Mrs. Aquino would like to save Php 400 at the end of each month, for six months in a fund…

A: In the given question Php 400 will be deposited at the end of each month for 6 months. The amount…

Q: Connie wants to have an annuity payment of $2000 at the end of every three months. How much should…

A: Given information: Annuity payment is $2,000 Interest rate is 6% compounded quarterly Number of…

Q: James and Kate would like to have $30,000 in 6 years in order to purchase anew mini van. What amount…

A: Annuity refers to series of annual payment which is paid or received at start or ending of specific…

Q: A student wants to save up for a car, assuming that he/she would be able to save up a certain sum…

A: Given information: Future value of car : 255000 Time period : 4 years Interest rate : 14%

Q: Dean Gooch is planning for his retirement, so he is setting up a payout annuity with his bank. He…

A: Payout annuity is the amount that an investor receives at a regular interval after a certain period…

Q: Jean-Rene wants to make a lump-sum deposit today such that at the end of every three months for the…

A: Given Information: Interest rate = 8.75% compounded semi-annually Lump-sum payment = $10,000 Payment…

Q: Bob and Pat want to purchase a vacation home in ten years and need $45,000 for a down payment. How…

A: Time value tells that money received today has more value than that of receiving exact value later…

Q: If I would like to have $250,000 in my savings account after making contributions for 30 years, what…

A: Present Value = Monthly Contributions * PVAF ( Monthly Rate, number of Months )

Q: Cecilia wants to pay for her daughter's college for four years by banking 20,000 dollars per year.…

A:

Q: An engineer who is saving for her retirement plans to deposit $500 every semiannually, starting…

A: Semi Annual Deposit = 500 End of period deposits Nominal Rate = 12℅ Quarterly Compounding N = 25…

Q: You plan to deposit $500 in a bank account now and $600 at the end of the year. If the account…

A: Solution: The amount in account after second deposit will be the future value of first deposit and…

Q: You estimate you need to supplement your social security payments with monthly withdrawals of…

A: Given: Monthly withdrawal = $3,420 Interest rate = 6.9% So, monthly interest rate = 0.069/12 = 0.58%…

Q: You want to accumulate $500,000 in a savings account in20 years. If the bank pays 6% compounded…

A: Future value: It can be defined as the value of an investment or any asset at a specified future…

Q: You estimate you need to supplement your social security payments with monthly withdrawals of…

A: The question is based on the concept present value of annuity payment Formula as, Pv=pmt*1-(1+r)-nr

Q: Suppose that you place $1,000 in a bank account each year for the next 20 years. How much would be…

A: Future value of annuity due can be calculated by using this equation Future value of annuity due…

Q: The Weidmans want to save $45,000 in 4 years for a down payment on a house. If they make monthly…

A: Computation:

Q: You would like to have $59,000 in 5 years for the down payment on a new house following graduation…

A: Future Value= $59,000; No. of periods= 5*4= 20 years, Interest rate per period = 4.24/4=…

Q: How much will you have to save each year (to the nearest dollar)?

A: Time value of money (TVM) means that the amount of money received in the present period will have…

Q: how much money will have accumulated at the end of the 10-year period

A: Future Value of Annuity: It is the future worth of a series of cashflows/payments compounded over a…

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: How much money does she need to pay into the annuity each quarter for the annuity to have a total…

A: Ordinary Annuity: These are payments made at the period end regularly for a period of time. The size…

Q: Christine would like to know the value of their savings, assuming that they deposit $750 each month…

A: Monthly deposit (P) = $750 Growth rate (g) = 3% Period = 25 Years Number of deposits (n) = 25*12 =…

Q: A civil engineer who is about to retire has accumulated 750 000 in a savings account that pays 6%…

A: The question is based on the concept of Financial Management. Annuity refers to the series of equal…

Q: When you were born, your parents started to deposit monthly $2,000 in the bank. The bank offers a…

A: Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: You deposit $1,000 in an account at the Lifelong Trust Savings and Loan that pays 2% interest…

A: Future value (FV) refers to a means of estimating how much an asset or cash's present value (PV)…

Q: Salem wishes to withdraw AED 30,000 at the end of each year of the next 6 years from his bank…

A: Annual withdrawal amount (A) = AED 30000 n = 6 years r = 10%

Q: Connie wants to have an annuity payment of $2,150 at the END of every three months. How much should…

A: The amount required to deposit now can be calculated as the present value of ordinary annuity.

Q: Anna is buying ​$16,000 worth of rare coins as an investment. The dealer is charging her an annual…

A: Principal = $16,000 rate = 7.2% Interest for 48 months = $16,000*7.2%*4 = $4608

Q: Determine the kind of annuity used in the following situations. Then, solve the problem. Show your…

A: Future value of an annuity: = Annuity amount * Future value of annuity of $1 (rate per compounding…

Q: Suppose that P400 is deposited each year into a bank account that pays 8% interest annually. If 12…

A: Future value of annuity is regular deposit of fixed sum into a bank account, that will give certain…

Q: Morgan has $500,000 accumulated in her RRSP and intends to use the amount to purchase a 20-year…

A: Nominal rate of return is the stated rate of return on investment without considering expenses like…

Q: Patricia French received $500,000 from aninsurance company after her husband’s death. Patricia wants…

A: Monthly payment: It can be defined as the payment made by the borrower on a monthly basis.

Q: a) Parents wish to provide $40,000 for their child to assist with her education. They deposit $200…

A: Future Value Required = 40,000 Deposit = 200  End of month deposits Monthly Compounding, Number of…

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: It is estimated that you will pay about $80,000 into the Social Security system (FICA) over your…

A: The future value is the value of the equal deposits at the end of the deposit period. The…

Q: a) Liliana makes the following deposits into her savings account. $7,400 in 2 years, $4,800 in 3…

A: " Hi, Thanks for the Question. Since you posted multiple question, we will answer the first question…

Q: Tom wants to put aside $120 at the end of each month into an account earning 6% compounded monthly,…

A: Here we have to use the concept of annuity and concept of time value of money to find the present…

Q: If you desire to have $10,000 for a down payment for a house in five years, what amount would you…

A: Calculation of Amount to Deposit Today:The amount to deposit today is $7,835.26.Excel Spreadsheet:

Q: A student plans to deposit $1,500 in the bank now and another $3,000 for the next 2 years. If he or…

A: Deposit now = $ 1500 Deposit after 2 years = $ 3000 Withdraw after 5 years = $ 5000 Future value…

Q: I need help working this problem out. Figuring out what table to use, whether to use: compound…

A: Hi, this is an example of simple interest. Hence no table ca be used, as the interests are neither…

Q: Suppose that you would like to have $25,000 to use as a down payment for a home in five years by…

A: An Annuity is a continuous flow of systematic timely cash flows made or received for a stipulated…

Q: Mrs Sam has deposited $ 18,000 in a bank at the rate of 7% per annum. Find out how much she will…

A: Given: Deposit = $18,000 Period 12 years Interest rate = 7% or 10%