Question

In: Finance

4) Nandana invests $500 at the start of each year for 20 years in a bank...

4) Nandana invests $500 at the start of each year for 20 years in a bank account paying interest at the effective annual rate i. She takes the interest paid at the end of each year and invests it in a different account paying an effective annual rate i/2. The effective annual rate she earns on her combined investments is 6%.

a) How much money does she have at the end of 20 years? (Total of both accounts.)

b) What is i?

Solutions

Expert Solution

This question can be easily solved using MS-Excel.

We have been given the following information:

Nandana invests $500 at the start of each year for 20 years paying effective annual rate (EAR) 'i' and the interest is then invested in different account with EAR of 'i/2'.

Now we have been given that the EAR she earns on the combined investments is 6%, which means that at the end of 20 years, the total value of her investment ($500 yearly) can be calculated using the time value of money concept. (FV formula in excel)

Using FV formula in excel:

=FV(rate,nper,pmt,[pv],[type])

here,

rate = 6%

nper = number of periods = 20

pmt = payment every period = 500

pv = present value = 0

type = 1 = amount invested at the start of each period (year)

this gives the value of FV as 19,496.36

Hence, the money she has at the end of 20 years is $19,496.36

Now, for part b:

We can build a time line in excel stating the position of amount in both options at the end of each period.

The same is as below:

For investment 1, $500 is added every year.

For investment 2, interest of amount accumulated and interest from investment 1 is added.

We have taken the interest as 'i' in cell F2.

The total is the amount added for both the investments at the end of year 20.

We know from answer of part a that the total should be $19,496.3633, we apply goal seek function and set the value of cell B24 to 19,496.3633 by changing the value of cell F2 (i.e., i).

And we get the value of 'i' as 7.1373%.

Please refer to the below image for the position at the end of each year:

Hence, the answers are as:

a) $19,496.36

b) 7.1373%


Related Solutions

Victor invests 300 into a bank account at the beginning of each year for 20 years....
Victor invests 300 into a bank account at the beginning of each year for 20 years. The account pays out interest at the end of every year at an annual effective interest rate of i% . The interest is reinvested at an annual effective rate of i / 2 %. The yield rate on the entire investment over the 20 year period, if he would only make deposits of 300 due is 8% annual effective. Determine i.
Susan invests 500 at the end of each year for 7 years at an effective annual...
Susan invests 500 at the end of each year for 7 years at an effective annual interest rate of 5%. The interest credited at the end of each year is reinvested at an effective annual interest rate of 6%. The accumulated value (in both funds) at the end of 7 years is X. Mary invests 100 now at an effective annual interest rate of 6%. The interest credited at the end of each year is reinvested at an effective annual...
Given 4% Interest PV = $500 received each year for 4 years FV = $500 invested...
Given 4% Interest PV = $500 received each year for 4 years FV = $500 invested each year for 4 years Consider that a 10-year UST offers 4.5% return, but a 10-year AAA Corporate Bond offers 5.6% => what causes the difference of 1.1%? Consider that a 1-year UST offers 1.2%, but a five-year UST offers 2.1% => what two influences could be causing the 0.9% difference?
Meagan invests $1,200 each year in an IRA for 12 years in an account that earned...
Meagan invests $1,200 each year in an IRA for 12 years in an account that earned 5% compounded annually. At the end of 12 years, she stopped making payments to the account, but continued to invest her accumulated amount at 5% compounded annualy for the next 11 years. a.) What was the value of the IRA at the end of 12 years? b.) What was the value of the investment at the end of the next 11 years?
4. Alpha Insurance has investment horizon of 3 years. If it invests in a 5 year,...
4. Alpha Insurance has investment horizon of 3 years. If it invests in a 5 year, 6% annual coupon bond with YTM of 8%, what will be its realized rate of return If interest rates don’t change If interest rate increases by 100 bps immediately after buying the bond If interest rate decreases by 100 bps immediately after buying the bond Is the difference between (a) and (b) the same as the difference between (a) and (c)? why or why...
Bryan invests $500 in an account earning 4% interest that compounds annually. If he makes no...
Bryan invests $500 in an account earning 4% interest that compounds annually. If he makes no additional deposits or withdrawals, how much will be in the account: How much will be in the account after 25 years using simple interest?
At the end of each year for 5 years, $500 is deposited into a credit union...
At the end of each year for 5 years, $500 is deposited into a credit union account. The credit union pays 5% interest compounded annually. At the end of 5 years, how much will be in the account?
Milo deposits $500 at the beginning of each year for 2 years into a fund that...
Milo deposits $500 at the beginning of each year for 2 years into a fund that earns 8% annual effective. Half of the interest is reinvested at 10% annual effective and the remaining half is reinvested in Milo’s pocket (at 0%). Calculate the accumulated value in all three accounts in 10 years. No excel solution please
An investor invests $500. The investment pays $100 at the end of year 2, $200 at...
An investor invests $500. The investment pays $100 at the end of year 2, $200 at the end of year 3 and $300 at the end of year 4. Calculate the net present value (NPV) of the investment using interest preference rate of 5.7%. ---------------------------------------------- I got v = 1/1.12 So would it just be NPV = -500 + 100(v)^2 + 200v^3 + 300v^4?
You plan to open a bank account by depositing $500 today and end of each year...
You plan to open a bank account by depositing $500 today and end of each year for the next nine years (year 1, year 2, ……. year 9). If the interest rate is 2%, what will be your balance in ten years? show workings in excel file
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT