wfiRetirementCalculator Save As Excel | 
Loading...
Updating...
Please wait to edit...
Ready for editing X
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
WFI Retirement Saving Calculator
©Zvi Bodie 2003. All rights reserved.
INPUTS:
Current age35
Retirement age65
Life expectancy85
Real interest rate3.0%
Current salary50,000
Replacement rate70%
Social security benefits0
Employer pension0
Part-time income0
Initial retirement savings0
Bequest0
Expected inflation0%
OUTPUTS:
Annual saving needed$10,626
Saving rate21.25%
Intermediate calculations
Retirement income shortfall35,000
PV of shortfall at retirement 520,712
FV of initial savings0
PV of employer pension at retirement 0
Addl savings needed at retirement520,712
Retirement saving
 
      0
powered by ZOHOSheet
Processing...
Assign Macro Edit Label More