Question

In: Finance

Unknown to you, your grandmother started depositing $25 (out of her social security checks) each month,...

Unknown to you, your grandmother started depositing $25 (out of her social security checks) each month, beginning the day you were born. Your grandmother died on your twentieth birthday, but left you the passbook. You found out that the bank maintained monthly compounding for all 20 years, but the interest rate had changed as follows: (a) Date of your birth to fifth birthday = 0.04; (b) Beginning fifth birthday to fifteenth birthday = 0.08; (c) Beginning fifteenth birthday to present = 0.12. How much money can you withdraw from the account on your twentieth birthday? Round your final answer to two decimal places. See Example 6.5 if you haven't already.

Solutions

Expert Solution

Solution:

(i) Calculation of Maturity amount of the savings from your birth to fifth birthday

Following are the steps to be followed on Microsoft Excel:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.04/12 Nper =5*12 PMT = -25 Type = 1

FV = $1663.00

Calculation of Future value of $1663.00 from your fifth birthday to fifteenth birthday

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.08/12 Nper =10*12 PV = -1663.00 Type = 1

FV = $3691.26

Calculation of Future value of $3691.26 from your fifteenth birthday till present

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.12/12 Nper =5*12 PV = -$3691.26 Type = 1

FV = $6705.90 ----------------------------- A

(ii) Calculation of Maturity amount of the savings from your fifth birthday to fifteenth birthday

Following are the steps to be followed on Microsoft Excel:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.08/12 Nper =10*12 PMT = -25 Type = 1

FV = $4604.14

Calculation of Future value of $4604.14 from your fifteenth birthday till present

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.12/12 Nper =5*12 PV = -$4604.14 Type = 1

FV = $8364.33 ----------------------------- B

(iii) Calculation of Maturity amount of the savings from your fifteenth birthday till present

Following are the steps to be followed on Microsoft Excel:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.12/12 Nper = 5*12 PMT = -25 Type = 1

FV = $2062.16 ------------------------------- C

Hence, the money that you can withdraw from your bank account on your twentieth birthday

= $6705.90 + $8364.33 + $2062.16

= $17,132.39


Related Solutions

You know you will receive $1,450 each month in Social Security payments in retirement. Assuming you...
You know you will receive $1,450 each month in Social Security payments in retirement. Assuming you will get benefits for 30 years and a real interest rate of 3%, what are those payments worth to you today?
Every worker sees a Social Security (FICA) tax taken out of his or her paycheck. The...
Every worker sees a Social Security (FICA) tax taken out of his or her paycheck. The nominal tax rate on workers is 7.65 percent. But there's a catch: only wages below a legislated ceiling are taxable. In 2014, the table wage ceiling was $117,000. What percentage of income is paid in Social Security taxes by a worker in 2014 earning Instructions: Enter your responses as a percent rounded to two decimal places. (a) $40,000? ____% (b) $80,000? ______% (c) $200,000____%?...
Every worker sees a Social Security (FICA) tax taken out of his or her paycheck. The...
Every worker sees a Social Security (FICA) tax taken out of his or her paycheck. The nominal tax rate on workers is 7.65 percent. But there's a catch: only wages below a legislated ceiling are taxable. In 2014, the table wage ceiling was $117,000. What percentage of income is paid in Social Security taxes by a worker in 2014 earning Instructions: Enter your responses as a percent rounded to two decimal places. (a) $40,000? ____% (b) $80,000? ______% (c) $200,000____%?...
Social Security system is a pay as you go retirement plan. Money taken from workers checks...
Social Security system is a pay as you go retirement plan. Money taken from workers checks is transferred to retirees. At one time there were 42 workers per retiree; today the ratio is now under 3 to 1. By 2030, the ratio is expected to fall to 2 to 1. The only way to keep the current system solvent is to raise taxes on those currently working or cut benefits to those already retired. Neither of these options is particularly...
(real and nominal rates) You have been depositing $250 per month in your 401k account for...
(real and nominal rates) You have been depositing $250 per month in your 401k account for exactly 10 years. The current value is $65,000. What is the annualized nominal return (effective annual rate) on your investment? If the inflation rate has averaged 6% over that time period, what is your annual real rate of return.
You have just started to deposit $250 at the end of each month into a bank...
You have just started to deposit $250 at the end of each month into a bank account. The bank manager states that you can receive $20,000 after 6 years from that account, if there is no transaction other than monthly deposits. What is interest rate provided by the bank for this account?
1. You earn $8,000 a month. After taxes, social security contributions, and living expenses you have...
1. You earn $8,000 a month. After taxes, social security contributions, and living expenses you have $400 per month that you can and will save. What is the future value of $200 saved every month for 30 years if the annual rate is of return is 12%. Interest is compounded monthly. Your first deposit is made at the end of month 1. We are looking for the value of your savings 30 years from the time you stated saving. 2....
1) You earn $8,000 a month. After taxes, social security contributions, and living expenses you have...
1) You earn $8,000 a month. After taxes, social security contributions, and living expenses you have $400 per month that you can and will save. What is the future value of $400 saved every month for 30 years if the annual rate is of return is 12%. Interest is compounded monthly. Your first deposit is made at the end of month 1. We are looking for the value of your savings 30 years from the time you stated saving. 2)...
You just started your first full time job out of college. You recall from your finance...
You just started your first full time job out of college. You recall from your finance course the importance of starting to save early for retirement. You plan on making deposits of $215 per pay check into a stock account and $130 per pay check into a bond account. You are paid every two weeks (26 pay checks per year). It is your plan to make these deposits for the next thirty-years. You expect that you will earn 8.75% per...
You just started your first full time job out of college. You recall from your finance...
You just started your first full time job out of college. You recall from your finance course the importance of starting to save early for retirement. You plan on making deposits of $215 per pay check into a stock account and $130 per pay check into a bond account. You are paid every two weeks (26 pay checks per year). It is your plan to make these deposits for the next thirty-years. You expect that you will earn 8.75% per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT