In: Finance
An amount of $3,000 is deposited into Fund X, which earns an annual effective rate of 8%. At the end of each year, the interest earned plus an additional $150 is withdrawn from the fund. At the end of the twentieth year, the fund is depleted. The annual withdrawals of interest and principal are deposited into Fund Y, which earns an annual effective rate of 10%.
Determine the accumulated value of Fund Y at the end of year 20. Justify your answer
This can be better shown using the below table.
Year | Opening Balance of fund X | Amount Deposited In fund X | Interest Earned @ 8% | Fixed Withdrawl Amount from Fund X | Total Withdrawl From Fund X | Closing balance of fund X | Opening Balance of Fund Y | Withdrawl Reinvested | Interest earned @ 10% | Closing balance |
1 | - | 3,000.0 | 240.0 | 150.0 | 390.0 | 2,850.0 | - | - | - | - |
2 | 2,850.0 | - | 228.0 | 150.0 | 378.0 | 2,700.0 | - | 390.0 | 39.0 | 429.0 |
3 | 2,700.0 | - | 216.0 | 150.0 | 366.0 | 2,550.0 | 429.0 | 378.0 | 80.7 | 887.7 |
4 | 2,550.0 | - | 204.0 | 150.0 | 354.0 | 2,400.0 | 887.7 | 366.0 | 125.4 | 1,379.1 |
5 | 2,400.0 | - | 192.0 | 150.0 | 342.0 | 2,250.0 | 1,379.1 | 354.0 | 173.3 | 1,906.4 |
6 | 2,250.0 | - | 180.0 | 150.0 | 330.0 | 2,100.0 | 1,906.4 | 342.0 | 224.8 | 2,473.2 |
7 | 2,100.0 | - | 168.0 | 150.0 | 318.0 | 1,950.0 | 2,473.2 | 330.0 | 280.3 | 3,083.5 |
8 | 1,950.0 | - | 156.0 | 150.0 | 306.0 | 1,800.0 | 3,083.5 | 318.0 | 340.2 | 3,741.7 |
9 | 1,800.0 | - | 144.0 | 150.0 | 294.0 | 1,650.0 | 3,741.7 | 306.0 | 404.8 | 4,452.5 |
10 | 1,650.0 | - | 132.0 | 150.0 | 282.0 | 1,500.0 | 4,452.5 | 294.0 | 474.6 | 5,221.1 |
11 | 1,500.0 | - | 120.0 | 150.0 | 270.0 | 1,350.0 | 5,221.1 | 282.0 | 550.3 | 6,053.4 |
12 | 1,350.0 | - | 108.0 | 150.0 | 258.0 | 1,200.0 | 6,053.4 | 270.0 | 632.3 | 6,955.8 |
13 | 1,200.0 | - | 96.0 | 150.0 | 246.0 | 1,050.0 | 6,955.8 | 258.0 | 721.4 | 7,935.1 |
14 | 1,050.0 | - | 84.0 | 150.0 | 234.0 | 900.0 | 7,935.1 | 246.0 | 818.1 | 8,999.2 |
15 | 900.0 | - | 72.0 | 150.0 | 222.0 | 750.0 | 8,999.2 | 234.0 | 923.3 | 10,156.6 |
16 | 750.0 | - | 60.0 | 150.0 | 210.0 | 600.0 | 10,156.6 | 222.0 | 1,037.9 | 11,416.4 |
17 | 600.0 | - | 48.0 | 150.0 | 198.0 | 450.0 | 11,416.4 | 210.0 | 1,162.6 | 12,789.1 |
18 | 450.0 | - | 36.0 | 150.0 | 186.0 | 300.0 | 12,789.1 | 198.0 | 1,298.7 | 14,285.8 |
19 | 300.0 | - | 24.0 |
&
Related SolutionsFund X earns 5% effective annual interest, while Fund Y earns 7% effective annual interest (and...
Fund X earns 5% effective annual interest, while Fund Y earns 7%
effective annual interest (and both start off with no money in
them). You invest $500 into fund X at the end of each year for 20
years and at the end of each year, withdraw the year’s interest and
deposit it into Fund Y . Find the accumulated value in Fund Y at
the end of the 20 years. please dont use excel to solve
A deposit of X is made into a fund which pays an annual effective interest rate...A deposit of X is made into a fund which pays an annual
effective interest rate of 8% for 5 years. At the same time, 2X is
deposited into another fund which pays an annual effective rate of
discount of d for 3 years. The amounts of interest earned over the
10 past years are equal for both funds. Calculate d.
Find the amount of each payment to be made into a sinking fund which earns 7%...Find the amount of each payment to be made into a sinking fund
which earns 7% compounded quarterly and produces $57000 at the end
of 2.5 years. Payments are made at the end of each period.
The payment size is $___?
Round to the nearest cent.
What amount must be deposited in an account that earns 10% on January 1, 2017 if...What amount must be deposited in an account that earns 10% on
January 1, 2017 if an investor wants to withdraw $5,000 January 1
of each year beginning on January 1, 2018 with the last withdrawal
being made on January 1, 2021? What if the withdrawals take place
on December 31 of each year starting on December 31, 2017 until
December 31, 2020? What if withdrawals of $2,500 occur every six
months on June 30 and Dec 31 of each...
An amount of P 250,000 is now deposited into a savings account that earns 12% compounded...An amount of P 250,000 is now deposited into a savings
account that earns 12% compounded continuously for the school
requirements of a civil engineering student on the succeeding 5
years from now. If the every year the student will withdraw P
51,651 from this account, how many years would the deposit
lasts?
What is an effective annual rate? Select one: a. It is a rate which is per...What is an effective annual rate?
Select one:
a. It is a rate which is per annum rate compounded annually
b. None of the above
c. It is a rate which is per annum rate continuously
compounded
d. It is a rate which is per annum rate compounded
semi-annually
The effective annual interest rate (EAR) for a Fed Fund whose interest rate, iff,spy = .352%...The effective annual interest rate (EAR) for a Fed Fund whose
interest rate, iff,spy = .352% for an overnight transaction is
a. 0.3569%
b. 0.3575%
c. 0.3520%
d. data are missing to determine EAR
Ryan borrows X at an effective annual rate of 11.5% and makeslevel payments at the...Ryan borrows X at an effective annual rate of 11.5% and makes
level payments at the end of each year for n years. The interest
portion of the final payment is 180.04. The total principal repaid
as of time n-1 is 6185.47. The principal repaid in the first
payment is Y. calculate Y.
1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective...1.a The annual interest rate is 8% with annual compounding.
Please calculate effective annual rate, effective semi-annual rate,
effective quarterly rate, effective monthly rate, effective weekly
rate (1 year = 52 weeks), effective daily rate (1 year = 365
days).
1.b The annual interest rate is 8% with monthly compounding.
Please calculate effective monthly rate, effective annual rate,
effective semi-annual rate, effective quarterly rate.
What is the definition of an APR? What is the effective annual rate? Which rate should...What is the definition of an APR?
What is the effective annual rate?
Which rate should you use to compare alternative investments or
loans?
Which rate do you need to use in the time value of
money calculations
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|