Question

In: Finance

A 5-year deferred annuity makes quarterly payments beginning 2¼ years from now. If the present value...

A 5-year deferred annuity makes quarterly payments beginning 2¼ years from now. If the present value of the annuity is $5,900,000 and the discount rate is 3.17 percent compounded quarterly, what are the quarterly payments? using excel worksheet

Solutions

Expert Solution

Annuity makes quarterly payments after 2 years 3 months. Till then compounded interest will be added and after 2 years and 3 months payments will be done after every 3 months and interest will also be added.

Now Calculating the value of annuity after 2 years 3 months (using excel)

So after 2 years 3 months, the value of the annuity will be $6,332,993.15

Payments will be done after this for the next 11 quarters, and interest will also be added.

Using Excel to Calculate it.

So the quarterly payment will be $603,373.95


Related Solutions

Find the present value of a deferred annuity of $500 a year for 6 years that...
Find the present value of a deferred annuity of $500 a year for 6 years that is deferred 5 years if money is worth 6% Please show work!
You wish to purchase a 15-year deferred annuity (payments start now) that will last 20 years...
You wish to purchase a 15-year deferred annuity (payments start now) that will last 20 years and generate $3000 per month for those 20 years while growing in value at 3% during the 20-year payout period. Assuming the discount rate for all cash flows is 7% What is the price you should pay for this 15-year deferred, 3% growing 20-year annuity? in creating your answer, place a spinner on all key rates (growth and discount)
A 5-year annuity of 10 $10,000 semiannual payments will begin 9 years from now, with the...
A 5-year annuity of 10 $10,000 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. Requirement 1: If the discount rate is 9 percent compounded semiannually, what is the value of this annuity five years and three years from now? (Enter rounded answers as directed, but do not use rounded numbers in intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) Value of the annuity Five years $ Three years...
A 5-year annuity of ten $4500 semiannual payments will begin 9 years from now, with the...
A 5-year annuity of ten $4500 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. If the discount rate is 12% compounded monthly, what is the value of this annuity five years from now? What is the value three years from now? What is the current value of the annuity? I have calculate the PVa at t=9 is 73073.68, but I don't know how to do the next steps... Please explain as...
Computing the Value of Deferred Annuity What is the present value of 6 years of annual...
Computing the Value of Deferred Annuity What is the present value of 6 years of annual cash receipts of $40,800 at the end of each year that begins two years from today, assuming a 4% interest rate? Please show work and formula(s)!
What is the present value of an annuity due that makes 5 payments of $6,000 each if the interest rate is 7%?
What is the present value of an annuity due that makes 5 payments of $6,000 each if the interest rate is 7%?a. $20,323.27b. $24,601.18c. $26,323.27d. $28,001.22e. $28,599.24
An annuity makes payments of 2400 at the beginning of every 6 years over 54 years...
An annuity makes payments of 2400 at the beginning of every 6 years over 54 years at an effective annual interest rate of 4 % . Find the present value of this annuity. Possible Answers 8125 8711 9807 10,069 11,325
What is the present value of an annuity consisting of 5 annual payments of $200 with...
What is the present value of an annuity consisting of 5 annual payments of $200 with an interest rate of 8% p.a. compounded annually and the first payment made immediatel a $889.68 B) $643.77 C) $862.43 D) $798.54
What is the present value of an annuity consisting of 5 annual payments of $200 with...
What is the present value of an annuity consisting of 5 annual payments of $200 with an interest rate of 8% p.a. compounded annually and the first payment made immediatel a $889.68 B) $643.77 C) $862.43 D) $798.54
A 5-year annuity making quarterly payments of 2250 will make its first payment 11 years and 3 months from today
A 5-year annuity making quarterly payments of 2250 will make its first payment 11 years and 3 months from today. You would like to purchase this annuity 2 years from today. If you want to earn an effective annual rate of 6.5% what should you be willing to pay 2 years from now? Your answer below to the nearest dollar.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT