Your financial planner offers you two different investment plans. Plan X is a $22,000 annual perpetuity. Plan Y is an annuity lasting 20 years and an annual payment, $30,000. Both plans will make their first payment one year from today. At what discount rate would you be indifferent between these two plans

use excel and explain why

You are looking at two investment options, A and B. Investment A is a 15-year annuity that needs an end-of-month payment of $1,100 and has an APR of 9% compounded monthly. Investment B is also a 15-year investment, but a lump sum investment that has as an APR of 8% compounded daily. How much money do you need to invest in B today as a single lump sum amount if you wish to have the same wealth as in Investment A in 15 years? If Investment B, with 8% APR compounded daily, gave you the option of investing a constant amount at the end of every six months, what would this amount be in order to give you the same wealth as in A at the end of 15 years?

You manage an investment fund that sells annuities. You sell a 6-year ordinary level annuity that makes monthly payments of $2,115 per month, starting next month. If interest rates are 3.46% APR (compounded monthly) what is the current price of this annuity?

You would like to have enough money saved to receive a $90,000 per year perpetuity after retirement. The annual interest rate is 8 percent. Required: How much would you need to have saved in your retirement fund to achieve this goal? a) Assume that the perpetuity payments start on the day of your retirement. b) Assume that the perpetuity payments start one year from the date of your retirement.

What's the future value of a 12%, 5-year ordinary annuity that pays $700 each year? If this was an annuity due, what would its future value be? Round your answers to the nearest cent.

You have your choice of two investment accounts. Investment A is a 7-year annuity that features end-of-month $2,900 payments and has an APR of 6 percent compounded monthly. Investment B is an annually compounded lump-sum investment with an APR of 6 percent, also good for 7 years. How much money would you need to invest in B today for it to be worth as much as Investment A 7 years from now? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Present value

You buy an annuity, which will pay you $22,000 a year for twenty years. The payments are paid on the first day of each year. What is the value of this annuity today at a 8% discount rate?

Assume that Social Security promises you $43,000 per year starting when you retire 45 years from today (the first $43,000 will get paid 45 years from now). If your discount rate is 5%, compounded annually, and you plan to live for 17 years after retiring (so that you will receive a total of 18 payments including the first one), what is the value today of Social Security's promise? ... The value today of Social Security's promise is $ the nearest cent.) (Round to

Future value of an ordinary annuity: Robert Hobbes plans to invest $25,000 a year at the end of each year for the next seven years in an investment that will pay him a rate of return of 11.4 percent. How much money will Robert have at the end of seven years? Could you please show the formula that would be used if using excel is for either FV or however it is set up.  Thanks