Question

In: Finance

An account had $840,000 in it at n=0 the account paid 6% annual interest. Each year...

An account had $840,000 in it at n=0 the account paid 6% annual interest. Each year for 20 years $12000 was withdrawn from the account. What is the amount at n=20, just after the last $12000 withdrawal?

Solutions

Expert Solution

$ 2,252,566.70

Year Beginning Value Interest Withdrawal Ending Value
a b=a*6% c d=a+b-c
1     8,40,000.00      50,400.00 12,000.00     8,78,400.00
2     8,78,400.00      52,704.00 12,000.00     9,19,104.00
3     9,19,104.00      55,146.24 12,000.00     9,62,250.24
4     9,62,250.24      57,735.01 12,000.00 10,07,985.25
5 10,07,985.25      60,479.12 12,000.00 10,56,464.37
6 10,56,464.37      63,387.86 12,000.00 11,07,852.23
7 11,07,852.23      66,471.13 12,000.00 11,62,323.37
8 11,62,323.37      69,739.40 12,000.00 12,20,062.77
9 12,20,062.77      73,203.77 12,000.00 12,81,266.53
10 12,81,266.53      76,875.99 12,000.00 13,46,142.53
11 13,46,142.53      80,768.55 12,000.00 14,14,911.08
12 14,14,911.08      84,894.66 12,000.00 14,87,805.74
13 14,87,805.74      89,268.34 12,000.00 15,65,074.09
14 15,65,074.09      93,904.45 12,000.00 16,46,978.53
15 16,46,978.53      98,818.71 12,000.00 17,33,797.24
16 17,33,797.24 1,04,027.83 12,000.00 18,25,825.08
17 18,25,825.08 1,09,549.50 12,000.00 19,23,374.58
18 19,23,374.58 1,15,402.47 12,000.00 20,26,777.06
19 20,26,777.06 1,21,606.62 12,000.00 21,36,383.68
20 21,36,383.68 1,28,183.02 12,000.00 22,52,566.70

Related Solutions

You made an investment of $8,000 into an account that paid you an annual interest rate...
You made an investment of $8,000 into an account that paid you an annual interest rate of 3.1 percent for the first 5 years and 7.5 percent for the next 10 years. What was your annual rate of return over the entire 15 years?
A 10-year bond pays 8% annual interest (paid semiannually). If similar bonds are currently yielding 6%...
A 10-year bond pays 8% annual interest (paid semiannually). If similar bonds are currently yielding 6% annually, what is the market value of the bond? A. $1,000.00 B. $1,147.20 C. $1,148.77 D. $1,080.00
Suppose you open today (year 0) a savings account with $5,000; the account earns an interest...
Suppose you open today (year 0) a savings account with $5,000; the account earns an interest of 3% APR annually. At the end of year 2 you deposit an additional $5,000 in the savings account, and then at the end of year 7 you deposit another $5,000 in the account. There is a total of 3 deposits made so far. If you did not make any withdrawals or additional deposits, then approximately what is the balance (FV) in the account...
11. An investor places $5,000 in an account. The stated annual interest rate is 6% compounded...
11. An investor places $5,000 in an account. The stated annual interest rate is 6% compounded monthly. The value of the account at the end of three years is closest to: * A. $5,970. B. $5,978. C. $5,983. D. $5,980. E. None of the above. 12. If an investment of $4,000 will grow to $6,250 in four years with monthly compounding, the annual interest rate will be closest to: * A. 11.2%. B. 12.3%. C. 13.0%. D. 14.0%. E. None...
6.Suppose that you had savings deposited in an account at an interest rate of 5 percent...
6.Suppose that you had savings deposited in an account at an interest rate of 5 percent and your father told you that he earned 10 percent interest 20 years ago. Which of you was getting the better return? How would your answer change if you were told that the inflation rate in the United States was 12 percent 20 years ago and is 3 percent now? 7.Suppose you have $1,000, which you can put in two different types of accounts...
Compute the interest paid on a 3-year lease for a $29,767 car if the annual rate...
Compute the interest paid on a 3-year lease for a $29,767 car if the annual rate of depreciation is 19% and the lease's annual interest rate is 3.6%. Round your answer to the nearest dollar.
Jason and Sarah Allen invested $7,200 in a savings account paying 6% annual interest when their...
Jason and Sarah Allen invested $7,200 in a savings account paying 6% annual interest when their daughter, Angela, was born. They also deposited $1,100 on each of her birthdays until she was 16 (including her 16th birthday). Click here to view the factor table 1. Table 2 Table 3 Table 4 How much was in the savings account on her 16th birthday (after the last deposit)? (For calculation purposes, use 5 decimal places as displayed in the factor table provided,...
At the end of every year you deposit $2,000 into an account that earns 6% interest...
At the end of every year you deposit $2,000 into an account that earns 6% interest per year. What will be the balance in your account immediately after the 30th deposit?
Suppose you are invested in an (excellent) account that pays 50% interest per year, paid monthly....
Suppose you are invested in an (excellent) account that pays 50% interest per year, paid monthly. The account is closed to new investment, so you cannot reinvest the interest. Do you prefer this account to one that pays a single payment of 50% at the end of the year, rather than monthly? Why or why not? Explain your reasoning (you may wish to reference ideas like compounding, NPV, IRR, etc.)
ABC Company deposits $25,000.00 with First National Bank in an account earning 6% annual interest, compounded...
ABC Company deposits $25,000.00 with First National Bank in an account earning 6% annual interest, compounded semi-annually.   How much will ABC have in the account after 5 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT