Question

In: Finance

Nataya makes monthly deposits into Fund A at the beginning of each month for 25 years....

Nataya makes monthly deposits into Fund A at the beginning of each month for 25 years. Her first deposit is
$40, and each subsequent deposit increases by $10. Aarif contributes $250,000 once, today, into Fund B. The
nominal rate that both of these funds earn is 6% per year. However, Fund A compounds interest monthly
and Fund B compounds interest quarterly. What is the difference in the balance between these two funds at
the end of 25 years?

Solutions

Expert Solution

Fund A:
Stream can be broken into two streams
First stream is constant payment of 40 per month i.e., annuity due of 40

Present Value=40/(6%/12)*(1-1/(1+6%/12)^(12*25))*(1+6%/12)=6239.32

Second stream is arithmetic gradient annuity of 10 per month

The above formula is for ordinary annuity but we have annuity due hence multiplied by (1+periodic rate)

Present Value=10/(6%/12*(1+6%/12)^(12*25))*(((1+6%/12)^(12*25)-1)/(6%/12)-12*25)*(1+6%/12)=176914.49

Total Present Value=6239.32+176914.49=183153.81

Total Future Value=Present value*(1+periodic rate)^number of periods=183153.81*(1+6%/12)^(12*25)=817776.23

Future Value in Fund B=Future value of lump sum=Present Value*(1+r/m)^(m*n)=250000*(1+6%/4)^(4*25)=1108011.412

Difference in the balance=1108011.412-817776.23=290235.182


Related Solutions

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
Raj deposits 50 into a fund at the end of each month for 5 years. The...
Raj deposits 50 into a fund at the end of each month for 5 years. The fund pays interest at an annual effective rate of i. The total amount of interest earned during the last month of year 5 is 13. Calculate the accumulated amount in Raj's account at the end of year 5 A) 3325 B) 3350 C) 3375 D) 3400 E) 3425
Bob deposits $1,500 at the beginning of each quarter for sixteen years in a fund earning...
Bob deposits $1,500 at the beginning of each quarter for sixteen years in a fund earning a nominal rate of interest of 6% convertible monthly. The interest from this fund is paid out monthly and can only be reinvested at an effective annual rate of 5.2%. Find Bob’s yield rate for the twenty-year period.
Bob deposits $11000 at the beginning of each year for six years in a fund earning...
Bob deposits $11000 at the beginning of each year for six years in a fund earning an effective annual rate of 6.7%. The interest from this fund can only be reinvested at an effective annual rate of 2.1%. Find the accumulated value of Bob’s investment at the end of thirteen years. Round your answer to the nearest cent.
14. John deposits $500 at the beginning of each year for 2 years into a fund...
14. John 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 John's pocket which will earn 0% interest. Calculate the accumulated value in all accounts after 10 years has passed.
You plan to make monthly deposits of $1,000 into an account at the beginning of each...
You plan to make monthly deposits of $1,000 into an account at the beginning of each month for the next 12 years. If you can earn 3.0% interest, what will your final balance be by the end of 12 years? Round to the nearest cent. ​[Hint: Beginning of period monthly cash flows!]
You plan to make monthly deposits of $1,000 into an account at the beginning of each...
You plan to make monthly deposits of $1,000 into an account at the beginning of each month for the next 11 years. If you can earn 3.4% interest, what will your final balance be by the end of 11 years? Round to the nearest cent. ​[Hint: Beginning of period monthly cash flows!]
Quarterly deposits are made into a fund at the beginning of each quarter starting today for...
Quarterly deposits are made into a fund at the beginning of each quarter starting today for 5 years. The first 8 deposits are $1000 each and deposits increase by 1% per quarter thereafter. If the fund earns 8% effective annually, find the accumulated value at the end of 5 years. Please explain which equations you used and do not use excel.
Emily deposits $150 at the beginning of each quarter into an account earning 6.7% for 25...
Emily deposits $150 at the beginning of each quarter into an account earning 6.7% for 25 years. How much money will she have at the end of those 25 years?
At the beginning of the month, the household deposits $3,000 in its checking account and the other $6,000 in a bond fund. Assume the bond fund pays 3% interest per month.
  At the beginning of the month, the household deposits $3,000 in its checking account and the other $6,000 in a bond fund. Assume the bond fund pays 3% interest per month. After 10 days, the money in the checking account is exhausted, and the household withdraws another $3,000 from the bond fund for the next 10 days. On the 20th day, the final $3,000 from the bond fund goes into the checking account. Which approach should the household use?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT