You want to receive $5000 per month for 20 years in real dollars in an account when you retire in 35 years. The first monthly payment to be received 1 month after you retire. The nominal return on your investment is 9.94 percent and the inflation rate is 3.2 percent. What is the real amount you must deposit each year for 35 years to achieve your goal? Pls do using Excel

Q: Suppose you want to have $300,000 for retirement in 20 years. Your account earns 10% interest. How…

A: The amount to be deposited monthly is an annuity and the final amount of $300,000 is the future…

Q: What is the value today of $1,500 per year, at a discount rate of 9 percent, if the first payment is…

A: The concept of money's time value reveals that any sum of money is worth more currently, than what…

Q: You would like to receive $6000 per month for 30 years after you retire in 40 years from now. The…

A: This pertains to time value of money. The monthly amount that you will deposit will grow in future…

Q: Solve each of the following questions using both pricing formulas and Excel.  1. If you wish to…

A: Present value refers to the current value of money which is required to put for a certain amount in…

Q: Expecting to retire in 20 years, you invest $5000 today in your retirement account which pays an…

A: Future value is an estimate of future cash flows ​​that may be received at a future date, discounted…

Q: You want to have $2 million in real dollars in an account when you retire in 30 years. The nominal…

A: Future value = fv = $2 million Time = t = 30 years Nominal rate = 11% Inflation rate = 5.5%

Q: Future Value is calculated in Excel using the following function and pa Future Value = -FV(APR/12,…

A: Future Value refers to an investment's worth to be received in the upcoming time at a constant…

Q: Question: compounded You have $1,000,000 saved for retirement in an investment account which pays…

A: Solution: An equal amount saved each period is known as annuity. Present value of annuity = PMT x…

Q: bjective is to save $500,000 for preparing your retirement, assuming 30 years from now. If you…

A: Future value=$500000Period=n=30 yearsInterest rate=r=10%

Q: If you invest $8,300 per period for the following number of periods, how much would you have…

A: Future value, which is dependent on the assumption of compound interest or investment growth, is the…

Q: 4. What will you pay today for an infinite annuity that will pay $3,000 each year, if the first…

A: The concept of the time value of money determines that the worth of money gets depreciated over the…

Q: 8) Special Retirement PlanYou set up a retirement plan where you will invest $20,000 per year in an…

A: Annuity is the payment series which are made at equal time intervals.

Q: Quantitative Problem 1: You plan to deposit $1,800 per year for 5 years into a money market account…

A: According to bartleby guidelines , if multiple questions are asked , then 1st question needs to be…

Q: An investment account returns 6.29% annually. You want to withdraw $ 10,000 each year for the next…

A: The present value of an annuity is the value today of a series of equal payments made at fixed…

Q: your initial investment. (Let B be the account balance in dollars and investment.) 8(t)= dollars (b)…

A: The value of money grow with time and interest rate due to accumulation of interest over the period…

Q: Your insurance agent is trying to sell you an annuity that costs $80,000 today. By buying this…

A: Present value is an estimate of the present value of future cash values ​​that may be received at a…

Q: In this project, you will use a graphing calculator to compare savings plans. For instance, suppose…

A: The objective of this question is to compare the final amount of money you would have after one year…

Q: How many year and how many days

A: The formula for calculation of future value is as under FV = P (1+ RT) P= Principal R = Rate of…

Q: If you invest $9,700 per period for the following number of periods, how much would you have…

A: aWe can solve this using Future value of annuity formula Future value is = P*((1+r)^n-1)/r "P" is…

Q: You expect to receive two cash flows: $41,000 paid in 5 years and $61,500 paid in 10 years. You'll…

A: Future value is an estimate of future cash values ​​that may be received at a future date,…

Q: You have just received a windfall from an investment you made in a friend's business. He will be…

A: As per the concept of time value of money the worth of money changes with passage of time. This is…

Q: You plan to invest $19,000 per year into a retirement account. If you earn a compound annual rate of…

A: Future value (FV) is the value of an investment or cash flow at a specific point in the future,…

Q: Use Excel to solve the following problem. Assume that you are 39 years old planning for your future…

A: Let's say we save an amount M every month. Interest rate = 6% per annumHere, a period is a monthR =…

Q: Assume you currently have $220,000 that you are ready to invest for retirement. In addition, you…

A: Compounding is a technique which is used to find the FV of present amount by using appropriate…

Q: Suppose you want to have $500,000 for retirement in 30 years. Your account earns 9% interest. How…

A: Compound = monthly = 12 Future value = fv = $500,000 Time = t = 30 *  12 = 360 months Interest rate…

Q: You want to have $67,000 in your savings account 10 years from now, and you're prepared to make…

A: Payment per period is the regular payments made or received of an investment, while future value is…

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

A: The following information has been provided,10 annual payments of $5,000 beginning in 26 years will…

Q: In planning for your retirement, you would like to withdraw $40,000 per year for 18 years. The first…

A: Retirement planning should be done based on future requirement and should be done based on time…

Q: Required information You just deposited $5,500 in an investment account and will deposit $5000 more…

A: Investment today = $5500Investment 4 years from now = $5000Time = 10 yearsRate of return = 10%To…

Q: If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much…

A: PV=FV/(1+i)^n (PV= present value FV= Future value i= discount rate  n= Number of period ) FV=…

Q: You would like to have $700,000 when you retire in 40 years. How much should you invest each quarter…

A: Required future Value "FV" is $700,000 Time period of retirement = 40 years Interest rate is 4%…

Q: You want to have $3.5 million in real dollars in an account when you retire in 50 years. The nominal…

A: The formula used to compute real rate of return as follows: Real rate of return=1+Nominal…