Question

Say a bank has a scheme where you can deposit $5,000 a year starting on the...

Say a bank has a scheme where you can deposit $5,000 a year starting on the day your granddaughter is born till the day she turns 21 years old (22 deposits). For doing this the bank is ready to pay your grand daughter $3,000 on her 22nd birthday, and increase the amount by $2,000 every year till she turns 60. What rate of return per year compounded yearly did the bank pay for the deposits?

Around 2%

Around 5%

Around 8%

Around 11%

please show work in excel

Homework Answers

Answer #1
time Cashflow
0 5000
1 5000
2 5000
3 5000
4 5000
5 5000
6 5000
7 5000
8 5000
9 5000
10 5000
11 5000
12 5000
13 5000
14 5000
15 5000
16 5000
17 5000
18 5000
19 5000
20 5000
21 5000
22 -3000
23 -5000
24 -7000
25 -9000
26 -11000
27 -13000
28 -15000
29 -17000
30 -19000
31 -21000
32 -23000
33 -25000
34 -27000
35 -29000
36 -31000
37 -33000
38 -35000
39 -37000
40 -39000
41 -41000
42 -43000
43 -45000
44 -47000
45 -49000
46 -51000
47 -53000
48 -55000
49 -57000
50 -59000
51 -61000
52 -63000
53 -65000
54 -67000
55 -69000
56 -71000
57 -73000
58 -75000
59 -77000
60 -79000
IRR 8%

The answer is around 8%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bill and Martha open a savings account for their granddaughter, Ariel on the day she is...
Bill and Martha open a savings account for their granddaughter, Ariel on the day she is born.  They make annual deposits of $2,000 into this account each year on her birthday.  Assume the account earns an interest 5% compounded annually. How much money will be in the account when Ariel turns 18? Bill and Martha are travelling the year Ariel turns 12 and are unable to make the $2,000 deposit.  How much money will have Ariel have in her account when she turns...
Suppose you deposit $2,688.00 into an account today. In 14.00 years the account is worth $3,748.00....
Suppose you deposit $2,688.00 into an account today. In 14.00 years the account is worth $3,748.00. The account earned ____% per year. Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,656,763.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 10.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 28.00th birthday and...
1. Jackie and Joe have just had their first baby and they wish to insure that...
1. Jackie and Joe have just had their first baby and they wish to insure that enough money will be available to pay for their daughter's college education. Assume that the educational savings account will return a constant APR of 9%. They have initial savings of $4358 deposited into the account right away (on the day the child was born) and plan to make further deposits into the educational savings account on each of their daughter's birthdays, starting with her...
Solve the following: 1. You want to be a millionaire in 25 years. If you can...
Solve the following: 1. You want to be a millionaire in 25 years. If you can earn 10% on your investments, how much do you have to save each year to hit that $1,000,000 mark? Table______________________ 2. Amy is 65 and has $350,000 in her retirement account. An actuary has determined that if her investments earn 7%, she can withdraw $32,300 annually. How many more years does the actuary expect Amy to live? Table______________________ 3. Karla sued her landlord 5...
52. Comprehensive Problem (Tax Return Problem). Mr. and Mrs. Sam Morris retired on February 10, 2018,...
52. Comprehensive Problem (Tax Return Problem). Mr. and Mrs. Sam Morris retired on February 10, 2018, and call you in for tax advice. Both Sam and his wife Sarah have worked for many years. Sam is 65 years of age and his wife is 63. Facts: Dependent child: Age 21 Social Security Benefits $9,900 Salaries: Sam (January 1—February 10) $7,000 Sarah (January 1—February 10) $5,500 Interest Income: Port Authority of N.Y. Bonds $300 Interest from Bank Deposits $11,100 Corporate Bonds...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers,...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers, Inc. 2001 Income Statement (OMR in millions) Net sales 9,625 Less: Cost of goods sold 5,225 Less: Depreciation 1,890 Earnings before interest and taxes 2,510 Less: Interest paid 850 Taxable income 1,660 Less: Taxes 581 Net income 1,079 Addition to retained earnings 679 Dividends paid 400 Kuipers, Inc. 12/31/00 and 12/31/01 Balance Sheet (in OMR, in millions) 2000 2001 2000 2001 Cash 1,455 260...
In narrative essay format, I want you to address a business/organization case study using multiple concepts...
In narrative essay format, I want you to address a business/organization case study using multiple concepts from class. The case question and case text begin on page 5 of this document. You need to demonstrate their best understanding of management and organizational behavior theory, and the application of those ideas to improve the understanding of various issues. You need to clearly identify at least 3 distinct, substantive issues. For each issue you need to 1), identify evidence from the case...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT