You have a choice of two investments accounts. Investment A is a 10-year annuity that features...

You have a choice of two investments accounts. Investment A is a 10-year annuity that features end-of-month $1,525 payments and has an interest rate of 7% compounded monthly. Investment B is an annually compounded lump-sum investment with an interest rate of 9 percent, also good for 10 years. How much money would you need to invest in Investment B today for it to be worth as much as Investment A 10 years from now? Use Excel and provide formula

Solutions

Expert Solution

To calculate the present value of the amount to be invested in investment B:-

We first need to calculate the Future value of investment B which will come from investment A
Then calculate the present value of investment B

Future value of Annuity = Annuity * [(1+r)ⁿ - 1) / r ]

where,

r = discount rate

n= number of compounding periods

Annuity = $1525

Now the interest rate is compounded monthly so r= 7%/12 = 0.00583

n= 10 years * 12 = 120

We can use this above formula in excel or also use the FV function

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You have your choice of two investment accounts. Investment A is a 15-year annuity that features...

You have your choice of two investment accounts. Investment A is a 15-year annuity that features end-of-month $500 payments and has an interest rate of 8.1 percent compounded monthly. Investment B is an 6.1 percent continuously compounded lump-sum investment, also good for 15 years. You would need to invest $ in B today for it to be worth as much as investment A 15 years from now. (Do not include the dollar sign ($). Round your answer to 2 decimal places....

You have your choice of two investment accounts. Investment A is a 12-year annuity that features...

You have your choice of two investment accounts. Investment A is a 12-year annuity that features end-of-month $3,400 payments and has an interest rate of 6 percent compounded monthly. Investment B is an annually compounded lump-sum investment with an interest rate of 7 percent, also good for 12 years. How much money would you need to invest in B today for it to be worth as much as Investment A 12 years from now? (Do not round intermediate calculations and...

You are choosing between two investments. Investment A is a 10 year annuity that features $18,000...

You are choosing between two investments. Investment A is a 10 year annuity that features $18,000 semi-annual payments and has interest rate of 12% compounded semi-annually. Investment B is quarterly compounded lump-sum investment with an interest rate of 8 percent also good for 10 years. How much money would you need to invest in B today for it to be worth as much as Investment A 10 years from now?

You are offered an annuity investment that will pay you $ 25,000 per year for 10...

You are offered an annuity investment that will pay you $ 25,000 per year for 10 years beginning in 20 years. These payments will be made at the beginning of each year and your discount rate is expected to be 8%. You will need to make payments at the end of each year for the next 20 years (also at 8%) in order to receive the annuity investment. What is the present value of the annuity investment as of...

You are searching the internet for investment opportunities and identify a 15-year annuity. The annuity will...

You are searching the internet for investment opportunities and identify a 15-year annuity. The annuity will cost $42,000 today in exchange for 5.5 percent annual payments. What will the annual cash flow be? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Multiple Choice $4,870.54 $4,466.82 $4,184.28 $4,811.74 $3,984.16

You purchase a 10 year annuity with payments at the end of each year for $10,...

You purchase a 10 year annuity with payments at the end of each year for $10, 000 (where for this annuity effective annual interest is 4%). Immediately after you receive payments, you deposit the payment into an account earning 5% effective annual interest. How much is in this account at the end of 10 years? Use this to find the equivalent effective annual interest rate for this $10, 000 investment over this 10 year period.

At the end of two consecutive investments you have $18,510.10. Investment one was 4% (SA) for...

At the end of two consecutive investments you have $18,510.10. Investment one was 4% (SA) for 30 months Investment two was 9% (Q) for 15 months What was the original amount deposited? Round to the nearest WHOLE dollar, NO dollar ($) signs, Use commas (,) when and where needed

When considering the two investments rules how do they effect the investment choice when considering a...

When considering the two investments rules how do they effect the investment choice when considering a pair of potential investments? Would you consider a higher risk in your investment choice or a lower risk to be safe?

18. You are comparing two investments, both of which provide annuity payments in exchange for a...

18. You are comparing two investments, both of which provide annuity payments in exchange for a lump sum investment today. Each annuity is for a period of 25 years and each pays $500 a month. You require a 7 percent return on these investments. Annuity A pays at the beginning of each month and annuity B pays at the end of each month. Given this information, which one of the following statements is correct? a. Both annuities are equally valuable...

Joe can purchase one of two annuities. Annuity 1: A 10 year decreasing annuity immediate with...

Joe can purchase one of two annuities. Annuity 1: A 10 year decreasing annuity immediate with annual payments of 10, 9, 8, ..., 2, 1. Annuity 2: A perpetuity immediate with annual payments: the perpetuity pays 1 in year 1, 2 in year 2, 3 in year 3, ...., 11 in year 11. After year 11, the payments remain constant at 11. At an annual e§ective interest rate of i, the present value of Annuity 2 is twice the present...

Subjects