Time Value of Money (ACCT assignment)
zhanghaojietime_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 |