Time Value of Money (ACCT assignment)
zhanghaojie
time_value.xlsx工作表1
| Informational Provided by Client | ||||||||
| Employee | Current Salary | Salary Growth Rate | Year of Rate | First Payment | Years of Finding | % in Retirement | Years in Retirement | compounded annually |
| Jean Honore | $50,230 | 4.00% | 2040 | 2015 | 12 | 50% | 20 | 8% |
| Colin Davis | $37,610 | 4.00% | 2045 | 2015 | 12 | 40% | 20 | 8% |
| Antia Baker | $20,110 | 4.00% | 2035 | 2015 | 12 | 40% | 20 | 8% |
| Gavin Bryars | $16,620 | 4.00% | 2030 | 2015 | 12 | 40% | 20 | 8% |
| Key Calculated Value | ||||||||
| Employee | Projected salary year priver to retirement (1) | Annual Retirement(2) | value@ Retirement(3) | Funds Lveeded 7/1/2026 (4) | Deferred Anuity Calculation of funds @ 2027 (5) | |||
| Jean Honore | $128,754.77 | 0 | 0 | 0 | ||||
| colin Davis | 117,292.48 | 0 | 0 | 0 | ||||
| Antia Baker | 42,368.74 | 0 | 0 | 0 | ||||
| Gavin Bryars | 28,780.46 | 11,512.19 | 122,070.66 | 96903.57 | 96903.57 | |||
| 96903.57 | 96903.57 | |||||||
| Annual Comtribuyion | ||||||||
| years of funding | 12 | |||||||
| rate of return | 8% | |||||||
| future valve( 7/1/2027) | 96903.57 | |||||||
| problem solving | ||||||||
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 |
