You are offered an annuity that will pay you 10,000 at the end of each year for 20 years, with the first payment being in 10 years from today. If the interest rate is 12% annually, what is this annuity worth to you today?

Martha receives $1000 on the first of each year. Stewart receives $100 on the last day of each year. Both Martha and Stewart will receive payments for 11 years. At an 8% discount rate, what is the difference in the present value of these two sets of payments?

What is the present value of a perpetuity that will pay $10,000 in one year and grow at 3% annually, if the discount rate is 10%. (first payment at the end of this year).

Ben invested $5,000 twenty years ago in an account that has paid him 5% with semiannual compounding. How much does Ben have in his account today.?

You plan on investing $10,000 at the end of each year for the next 20 years. You found an investment that will pay you 8% annual percentage rate with daily compounding. How much will you end up in your investment account at the end of 20 years?

please showing working in excel.. i want to learn how you arrived the answer