Part-A |
(i) | Present value at 30th year of 20 years cashflows after 30 years : | Computation of Deposits for 30 years : | |||||||||
Year | CF | PV (@8%) | year of Deposit | Compounded for Years | CF | FV Factor (8%) | FV | ||||
1 | 31 | 50000 | 46296.3 | 1 | 29 | 4372.05 | 9.32 | 40735.55 | |||
2 | 32 | 50000 | 42866.94 | 2 | 28 | 4372.05 | 8.63 | 37718.11 | |||
3 | 33 | 50000 | 39691.61 | 3 | 27 | 4372.05 | 7.99 | 34924.17 | |||
4 | 34 | 50000 | 36751.49 | 4 | 26 | 4372.05 | 7.40 | 32337.20 | |||
5 | 35 | 50000 | 34029.16 | 5 | 25 | 4372.05 | 6.85 | 29941.85 | |||
6 | 36 | 50000 | 31508.48 | 6 | 24 | 4372.05 | 6.34 | 27723.93 | |||
7 | 37 | 50000 | 29174.52 | 7 | 23 | 4372.05 | 5.87 | 25670.31 | |||
8 | 38 | 50000 | 27013.44 | 8 | 22 | 4372.05 | 5.44 | 23768.81 | |||
9 | 39 | 50000 | 25012.45 | 9 | 21 | 4372.05 | 5.03 | 22008.15 | |||
10 | 40 | 50000 | 23159.67 | 10 | 20 | 4372.05 | 4.66 | 20377.92 | |||
11 | 41 | 50000 | 21444.14 | 11 | 19 | 4372.05 | 4.32 | 18868.44 | |||
12 | 42 | 50000 | 19855.69 | 12 | 18 | 4372.05 | 4.00 | 17470.78 | |||
13 | 43 | 50000 | 18384.9 | 13 | 17 | 4372.05 | 3.70 | 16176.65 | |||
14 | 44 | 50000 | 17023.05 | 14 | 16 | 4372.05 | 3.43 | 14978.38 | |||
15 | 45 | 50000 | 15762.09 | 15 | 15 | 4372.05 | 3.17 | 13868.87 | |||
16 | 46 | 50000 | 14594.52 | 16 | 14 | 4372.05 | 2.94 | 12841.55 | |||
17 | 47 | 50000 | 13513.45 | 17 | 13 | 4372.05 | 2.72 | 11890.32 | |||
18 | 48 | 50000 | 12512.45 | 18 | 12 | 4372.05 | 2.52 | 11009.56 | |||
19 | 49 | 50000 | 11585.6 | 19 | 11 | 4372.05 | 2.33 | 10194.03 | |||
20 | 50 | 50000 | 10727.41 | 20 | 10 | 4372.05 | 2.16 | 9438.92 | |||
21 | 9 | 4372.05 | 2.00 | 8739.74 | |||||||
Total | 490907.4 | 22 | 8 | 4372.05 | 1.85 | 8092.35 | |||||
23 | 7 | 4372.05 | 1.71 | 7492.92 | |||||||
24 | 6 | 4372.05 | 1.59 | 6937.89 | |||||||
25 | 5 | 4372.05 | 1.47 | 6423.97 | |||||||
26 | 4 | 4372.05 | 1.36 | 5948.12 | |||||||
27 | 3 | 4372.05 | 1.26 | 5507.52 | |||||||
28 | 2 | 4372.05 | 1.17 | 5099.55 | |||||||
29 | 1 | 4372.05 | 1.08 | 4721.81 | |||||||
Aggregate FV Factor for 30 years | 112.28 | 490907.37 | |||||||||
Deposits each year | (490907.4)/112.28 | 4372.05 |
(ii) | ||||
year of Deposit | Compounded for Years | CF | FV Factor (8%) | FV |
0 | 30 | 25000 | 10.06 | 251566.42 |
1 | 29 | 2131.58 | 9.32 | 19860.54 |
2 | 28 | 2131.58 | 8.63 | 18389.39 |
3 | 27 | 2131.58 | 7.99 | 17027.21 |
4 | 26 | 2131.58 | 7.40 | 15765.94 |
5 | 25 | 2131.58 | 6.85 | 14598.09 |
6 | 24 | 2131.58 | 6.34 | 13516.75 |
7 | 23 | 2131.58 | 5.87 | 12515.51 |
8 | 22 | 2131.58 | 5.44 | 11588.44 |
9 | 21 | 2131.58 | 5.03 | 10730.03 |
10 | 20 | 2131.58 | 4.66 | 9935.22 |
11 | 19 | 2131.58 | 4.32 | 9199.27 |
12 | 18 | 2131.58 | 4.00 | 8517.85 |
13 | 17 | 2131.58 | 3.70 | 7886.89 |
14 | 16 | 2131.58 | 3.43 | 7302.68 |
15 | 15 | 2131.58 | 3.17 | 6761.74 |
16 | 14 | 2131.58 | 2.94 | 6260.87 |
17 | 13 | 2131.58 | 2.72 | 5797.10 |
18 | 12 | 2131.58 | 2.52 | 5367.69 |
19 | 11 | 2131.58 | 2.33 | 4970.08 |
20 | 10 | 2131.58 | 2.16 | 4601.93 |
21 | 9 | 2131.58 | 2.00 | 4261.04 |
22 | 8 | 2131.58 | 1.85 | 3945.41 |
23 | 7 | 2131.58 | 1.71 | 3653.16 |
24 | 6 | 2131.58 | 1.59 | 3382.55 |
25 | 5 | 2131.58 | 1.47 | 3131.99 |
26 | 4 | 2131.58 | 1.36 | 2899.99 |
27 | 3 | 2131.58 | 1.26 | 2685.18 |
28 | 2 | 2131.58 | 1.17 | 2486.28 |
29 | 1 | 2131.58 | 1.08 | 2302.11 |
Aggregate FV Factor for 30 years | 112.28 | 490907.37 | ||
Deposits each year | (490907.4-251566.42)/112.28 | 2131.58 |
(iii) | ||||
year of Deposit | Compounded for Years | CF | FV Factor (8%) | FV |
0 | 30 | 25000 | 10.06 | 251566.42 |
1 | 29 | 1170.21 | 9.32 | 10903.15 |
2 | 28 | 1170.21 | 8.63 | 10095.51 |
3 | 27 | 1170.21 | 7.99 | 9347.69 |
4 | 26 | 1170.21 | 7.40 | 8655.27 |
5 | 25 | 1170.21 | 6.85 | 8014.14 |
6 | 24 | 1170.21 | 6.34 | 7420.50 |
7 | 23 | 1170.21 | 5.87 | 6870.83 |
8 | 22 | 1170.21 | 5.44 | 6361.88 |
9 | 21 | 1170.21 | 5.03 | 5890.63 |
10 | 20 | 1170.21 | 4.66 | 5454.29 |
11 | 19 | 1170.21 | 4.32 | 5050.27 |
12 | 18 | 1170.21 | 4.00 | 4676.17 |
13 | 17 | 1170.21 | 3.70 | 4329.79 |
14 | 16 | 1170.21 | 3.43 | 4009.07 |
15 | 15 | 1170.21 | 3.17 | 3712.10 |
16 | 14 | 1170.21 | 2.94 | 3437.13 |
17 | 13 | 1170.21 | 2.72 | 3182.53 |
18 | 12 | 1170.21 | 2.52 | 2946.78 |
19 | 11 | 1170.21 | 2.33 | 2728.50 |
20 | 10 | 50000.00 | 2.16 | 107946.25 |
20 | 10 | 1170.21 | 2.16 | 2526.39 |
21 | 9 | 1170.21 | 2.00 | 2339.25 |
22 | 8 | 1170.21 | 1.85 | 2165.97 |
23 | 7 | 1170.21 | 1.71 | 2005.53 |
24 | 6 | 1170.21 | 1.59 | 1856.97 |
25 | 5 | 1170.21 | 1.47 | 1719.42 |
26 | 4 | 1170.21 | 1.36 | 1592.05 |
27 | 3 | 1170.21 | 1.26 | 1474.12 |
28 | 2 | 1170.21 | 1.17 | 1364.93 |
29 | 1 | 1170.21 | 1.08 | 1263.82 |
Aggregate FV Factor for 30 years | 112.28 | 490907.37 | ||
Deposits each year | (490907.4-251566.42-107946.25)/112.28 | 1170.21 |
Part - B
Part A Your sister is celebrating her 30th birthday. As the party winds down she asks you for some help. She wants to s...
Your sister is celebrating her 32nd birthday. As the party winds down she asks for your assistance in helping her plan for retirements because she knows that you are taking a finance course in your MBA program. She wants to start saving now for retirement at age 62. She tells you that ideally she would like to withdraw $50,000 on an annual basis for at least 20 years starting the year after she retires at age 62. She says that...
Mary's 25th birthday is today, and she hopes to retire on her 65th birthday. She has determined that she will need to have $3,000,000 in her retirement savings account in order to live comfortably. Mary currently has no retirement savings, and her investments will earn 5% annually. How much must she deposit into her account at the end of each of the next 40 years to meet her retirement savings goal? Your Answer:
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: Years until retirement 35 Amount to withdraw each year $85,000 Years to withdraw in retirement 25 Interest rate 7.5% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account...
Question 6: This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: Years until retirement 35 Amount to withdraw each year $85,000 Years to withdraw in retirement 25 Interest rate 7.5% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into...
Question 11 (0.2 points) Mary's 25th birthday is today, and she hopes to retire on her 65th birthday. She has determined that she will need to have $3,000,000 in her retirement savings account in order to live comfortably. Mary currently has no retirement savings, and her investments will earn 6% annually. How much must she deposit into her account at the end of each of the next 40 years to meet her retirement savings goal? Your Answer: Answer Hide hint...
Please write down the intermidiate steps clearly. Intermidiate answers should be stated in 4 decimals in $/% while final answers in 2 decimals in $/%. Paul is celebrating his 43d birthday today and is planning for a retirement savings his family [Planned expenses] - Paul's daughter is now 6 years old and he plans to send her to a top local university in 12 years. programe for Currently, the cost of studying (tuition fees and living expenses) is S150,000 per...
2. Your sister turned 25 today, and she is planning to save $3,500 per year for retirement, with the first deposit to be made one year from today. She will invest in a mutual fund that's expected to provide a return of 7% per year. She plans to retire 40 years from today, when she turns 65, and she expects to live for 25 years after retirement, to age 90. Under these assumptions, how much can she spend each year...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $131,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $106,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...
Your client just turned 75 years old and plans on retiring in 10 years on her 85th birthday. She is saving money today for her retirement and is establishing a retirement account with your office. She would like to withdraw money from her retirement account on her birthday each year until she dies. She would ideally like to withdraw $50,000 on her 85th birthday, and increase her withdrawals 10 percent a year through her 89th birthday (i.e., she would like...