Question

Mike is scheduled to receive payments of $1,200 each month for the next 2 years, with...

Mike is scheduled to receive payments of $1,200 each month for the next 2 years, with the first payment beginning today. How much can Mike expect to have at the end of year 2 if he is able to invest these cash flows at a rate of 8% assuming monthly compounding?

A.

$31,327.29

B.

$31,119.83

C.

$2,496.00

D.

$80,117.71

Homework Answers

Answer #1

Monthly Payments (PMT) = $ 1200

Tenure (NPER) = 2 years or 24 months (since this is monthly compounding)

Nature = Monthly compounding

Rate of Investment (RATE) = 8% per annum

Payment pattern = Beginning of the month (1); If the payment is at end of the month, then the value should be "0" as last factor in the below given formula.

Using Excel, the Future value (FV) of this investment can be computed,

FV = (RATE/12,NPER,-PMT,,1) = (8%/12,24,-1200,,1) = $ 31.327.29 Answer (A)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are scheduled to receive annual payments of $4,000 for each of the next 8 years....
You are scheduled to receive annual payments of $4,000 for each of the next 8 years. The discount rate is 8 percent What is the theoretical relation between the present value if you receive these payments at the beginning of each year and the present value if you receive these payments at the end of each year? (Write the equation)
You are scheduled to receive annual payments of $21,400 for each of the next 23 years....
You are scheduled to receive annual payments of $21,400 for each of the next 23 years. Your discount rate is 8 percent. What is the difference in the present value if you receive these payments at the beginning of each year rather than at the end of each year?
You are scheduled to receive annual payments of $9,400 for each of the next 27 years....
You are scheduled to receive annual payments of $9,400 for each of the next 27 years. The discount rate is 7.0 percent. What is the difference in the present value if you receive these payments at the beginning of each year rather than at the end of each year?   $9,400.00 $7,887.25 $8,288.63 $9,001.91 $10,058.00
Mike wants to receive $40,000 per year pretax from his investments for the next 30 years....
Mike wants to receive $40,000 per year pretax from his investments for the next 30 years. He is concerned about inflation, which he expects to average 3 percent. He can earn a pretax rate of 6 percent on his money. How much does he need in an account to generate $40,000 in annual inflation-adjusted income (payments at the end of each year)?  
Christina will receive annuity payments of $1,200 a year for five years, with the first payment...
Christina will receive annuity payments of $1,200 a year for five years, with the first payment occurring at Year 4. What is the value of this annuity to her today at a discount rate of 7.25 percent? Please solve using steps for financial calculator. I understand how to solve using formula on paper but need help with the calculator.
If you invest $96 per month (starting next month) every month for 36 years, and you...
If you invest $96 per month (starting next month) every month for 36 years, and you can earn 11% per year (compounded monthly), how much will you have at the end of 36 years? Round to the nearest cent. If the most you can afford each month on a car payment is $393, the applicable discount rate is 4.1% per year, and an auto-loan is for 5 years paid monthly, what's the most expensive car you should purchase today assuming...
You receive $200 a month for 8 years beginning one month from today and an additional...
You receive $200 a month for 8 years beginning one month from today and an additional $6000 8 years from today.If the interest rate is 6% APR,what is the value today of this stream of cash flows?(round to the nearest dollar)
Daniel expects to receive $4,500 at the beginning of each month for the next 10 years...
Daniel expects to receive $4,500 at the beginning of each month for the next 10 years from the Lucy Trust. Assuming Daniel reinvests those funds the day she receives them in an investment returning 6.5%, what will she have at the end of 10 years?
Mr. Dawson wants to receive payments of $1,320.00 at the beginning of every month for 19...
Mr. Dawson wants to receive payments of $1,320.00 at the beginning of every month for 19 years starting on the date of the retirement. If he retires in 21 years, how much must he deposit in an account at the beginning of every month if interest on the account is 6.84% compounded monthly? A. $222.41 B. $242.81 C. $228.81 D. $280.21 E. $284.21
J. Johnson receives a defined retirement benefit, which commences in 15 years. At that time, Johnson...
J. Johnson receives a defined retirement benefit, which commences in 15 years. At that time, Johnson is to receive monthly cash payments of $900 for 10 years with the first payment scheduled for the end of the initial month of benefit. Assume an interest rate of 9%. Required What is the value of the deferred annuity as of today? Assume annual compounding during the deferral period. Round your answer to the nearest whole number. Do not use a negative sign...