Question

1. Find the accumulated value of a 12-year annuity-immediate of $500 per year, if the effective...

1. Find the accumulated value of a 12-year annuity-immediate of $500 per year, if the effective rate of interest (for all money) is 8% for the first 3 years, 6% for the following 5 years, and 4% for the last 4 years.

The answer is $7,961.71.

Excel solution is preferred.

Homework Answers

Answer #1

Ans:- we will use the FV function of excel to find the answer.

For first the first 3 years Rate = 8%, Nper = 3, Pmt = -$500, PV = 0.

For next 5 years Rate = 6%, Nper = 5, Pmt = -$500, PV = -$1623.20 ( Since at the end of 3rd year $1623.20 has been accumulated in the account)

For last 4 years Rate = 4%, Nper = 4, Pmt = -$500. PV = -$4990.75. ( Since at the end of 8th year $4990.75 has been accumulated in the account)

Therefore, the accumulated value of 12 years annuity is $7961.71.

Note:- If this answer helps you pls give thumbs up.

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
Find the accumulated value of a 10-year annuity-immediate of 100 per year if the first 6...
Find the accumulated value of a 10-year annuity-immediate of 100 per year if the first 6 payments are invested at an effective rate of interest of 5% and the final 4 payments are invested at an effective rate of interest of 4%. (Yield curve method)
You inherited a 15-year annuity-immediate with level annual payments. You are told that the accumulated value...
You inherited a 15-year annuity-immediate with level annual payments. You are told that the accumulated value of this annuity at the end of 15 years is 38,000. You are also told that the present value at the time of inheritance is $ 15,000. Determine the level of annual payments. Also, determine the annual effective interest rate earned by this trust.
Find the accumulated value of an ordinary simple annuity where you save $3,000 per year for...
Find the accumulated value of an ordinary simple annuity where you save $3,000 per year for 8 years at an interest rate of 7% compounded annually.
An annuity-immediate has 20 annual payments starting at 5 and increasing by 10 every year. The...
An annuity-immediate has 20 annual payments starting at 5 and increasing by 10 every year. The annual effective rate of interest is 7%. Calculate the present value of this annuity. not a excel solution
Calculate the accumulated value of an annuity immediate that pays 1000 at the end of each...
Calculate the accumulated value of an annuity immediate that pays 1000 at the end of each quarter for 20 years. The interest rate is 7% compounded quarterly.
An annuity immediate pays 200 every month for 10 years. Calculate the present value at the...
An annuity immediate pays 200 every month for 10 years. Calculate the present value at the following rates of interest: Annual effective interest rate of 6% Nominal interest rate convertible monthly of 8% Nominal rate of discount convertible once every two years of 4%
An annuity-due has 29 payments of $800 per period. The effective rate of interest per period...
An annuity-due has 29 payments of $800 per period. The effective rate of interest per period is 7% for the first 9 periods and 3% for the following 20 periods. (A) Find the accumulated value of the annuity using the portfolio method. Round your answer to 2 decimal places. (B) Find the accumulated value of the annuity using the yield-curve method. Round your answer to 2 decimal places.
Problem 1 Find the future value of $100 in 5 years at 5%. The answer is:...
Problem 1 Find the future value of $100 in 5 years at 5%. The answer is: Problem 2 Find the future value of $1,800 in 3 years at 8%. The answer is:   Problem 3 Find the future value of $500 in 6 years at 9%. The answer is:   Problem 4 Find the future value of a 3-year, $300 per year annuity at 6%. The answer is:   Problem 5 Find the future value of a 15-year, $300 per year annuity at...
1. Find the present value of a 30-year annuity-due with semiannual payments in which the first...
1. Find the present value of a 30-year annuity-due with semiannual payments in which the first payment is $20,000, the second payment is $21,600, the third payment is $23,328, the fourth payment is $25,194.24, etc., assuming an annual effective rate of interest of 16%. 2. Find the present value of a varying perpetuity-DUE in which payments are made every two years with the first payment being $245, and each payment thereafter is $150 larger than the previous payment. Assume the...
13. You own an ordinary annuity contract that will pay you RM3,000 per year for 12...
13. You own an ordinary annuity contract that will pay you RM3,000 per year for 12 years. You need money to pay back a loan in 6 years, and you are afraid if you get the annuity payments annually you will spend the money and not be able to pay back your loan. You decide to sell your annuity for a lump sum of cash to be paid to you five years from today. If the interest rate is 8%,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT