Spreadsheet: 127666d1320446430-please-help-need-sample-spreadsheets-cash-flow-model-rev01-01-07-1a
Sheet: Lookups

AGE | Divisor | Year
55 | 0 | 2011 |  |  |  |  |  |  |  |  | 53
56 | 0 | 2012 |  |  |  |  |  |  |  |  | 54
57 | 0 | 2013 |  |  |  |  |  |  |  |  | 55
58 | 0 | 2014 |  |  |  |  |  |  |  |  | 56
59 | 0 | 2015 |  |  |  |  |  |  |  |  | 57
60 | 0 | 2016 |  |  |  |  |  |  |  |  | 58
61 | 0 | 2017 |  |  |  |  |  |  |  |  | 59
62 | 0 | 2018 |  |  |  |  |  |  |  |  | 60
63 | 0 | 2019 |  |  |  |  |  |  |  |  | 61
64 | 0 | 2020 |  |  |  |  |  |  |  |  | 62
65 | 0 | 2021 |  |  |  |  |  |  |  |  | 63
66 | 0 | 2022 |  |  |  |  |  |  |  |  | 64
67 | 0 | 2023 |  |  |  |  |  |  |  |  | 65
68 | 0 | 2024 |  |  |  |  |  |  |  |  | 66
69 | 0 | 2025 |  |  |  |  |  |  |  |  | 67
70 | 27.4 | 2026 |  |  |  |  |  |  |  |  | 68
71 | 26.5 | 2027 |  |  |  |  |  |  |  |  | 69
72 | 25.6 | 2028 |  |  |  |  |  |  |  |  | 70 | 27.4
73 | 24.7 | 2029 |  |  |  |  |  |  |  |  | 71 | 26.5
74 | 23.8 | 2030 |  |  |  |  |  |  |  |  | 72 | 25.6
75 | 22.9 | 2031 |  |  |  |  |  |  |  |  | 73 | 24.7
76 | 22 | 2032 |  |  |  |  |  |  |  |  | 74 | 23.8
77 | 21.2 | 2033 |  |  |  |  |  |  |  |  | 75 | 22.9
78 | 20.3 | 2034 |  |  |  |  |  |  |  |  | 76 | 22
79 | 19.5 | 2035 |  |  |  |  |  |  |  |  | 77 | 21.2
80 | 18.7 | 2036 |  |  |  |  |  |  |  |  | 78 | 20.3
81 | 17.9 | 2037 |  |  |  |  |  |  |  |  | 79 | 19.5
82 | 17.1 | 2038 |  |  |  |  |  |  |  |  | 80 | 18.7
83 | 16.3 | 2039 |  |  |  |  |  |  |  |  | 81 | 17.9
84 | 15.3 | 2040 |  |  |  |  |  |  |  |  | 82 | 17.1
85 | 14.8 | 2041 |  |  |  |  |  |  |  |  | 83 | 16.3
86 | 14.1 | 2042 |  |  |  |  |  |  |  |  | 84 | 15.3
87 | 13.4 | 2043 |  |  |  |  |  |  |  |  | 85 | 14.8
88 | 12.7 | 2044 |  |  |  |  |  |  |  |  | 86 | 14.1
89 | 12 | 2045 |  |  |  |  |  |  |  |  | 87 | 13.4
90 | 11.4 | 2046 |  |  |  |  |  |  |  |  | 88 | 12.7
91 | 10.8 | 2047 |  |  |  |  |  |  |  |  | 89 | 12
92 | 10.2 | 2048 |  |  |  |  |  |  |  |  | 90 | 11.4
93 | 9.6 | 2049 |  |  |  |  |  |  |  |  | 91 | 10.8
94 | 9.1 | 2050 |  |  |  |  |  |  |  |  | 92 | 10.2
95 | 8.6 | 2051 |  |  |  |  |  |  |  |  | 93 | 9.6
96 | 8.1 | 2052 |  |  |  |  |  |  |  |  | 94 | 9.1
97 | 7.6 | 2053 |  |  |  |  |  |  |  |  | 95 | 8.6
98 | 7.1 | 2054 |  |  |  |  |  |  |  |  | 96 | 8.1
99 | 6.7 | 2055 |  |  |  |  |  |  |  |  | 97 | 7.6
100 | 6.3 | 2056 |  |  |  |  |  |  |  |  | 98 | 7.1
101 | 5.9 | 2057 |  |  |  |  |  |  |  |  | 99 | 6.7
102 | 5.5 | 2058 |  |  |  |  |  |  |  |  | 100 | 6.3
103 | 5.2 | 2059 |  |  |  |  |  |  |  |  | 101 | 5.9
104 | 4.9 | 2060 |  |  |  |  |  |  |  |  | 102 | 5.5
105 | 4.5 | 2061 |  |  |  |  |  |  |  |  | 103 | 5.2
106 | 4.2 | 2062 |  |  |  |  |  |  |  |  | 104 | 4.9
107 | 3.9 | 2063 |  |  |  |  |  |  |  |  | 105 | 4.5
108 | 3.7 | 2064 |  |  |  |  |  |  |  |  | 106 | 4.2
109 | 3.4 | 2065 |  |  |  |  |  |  |  |  | 107 | 3.9
110 | 3.1 | 2066 |  |  |  |  |  |  |  |  | 108 | 3.7
111 | 2.9 | 2067 |  |  |  |  |  |  |  |  | 109 | 3.4
112 | 2.6 | 2068 |  |  |  |  |  |  |  |  | 110 | 3.1
113 | 2.4 | 2069 |  |  |  |  |  |  |  |  | 111 | 2.9
114 | 2.1 | 2070 |  |  |  |  |  |  |  |  | 112 | 2.6
 |  |  |  |  |  |  |  |  |  |  | 113 | 2.4
 |  |  |  |  |  |  |  |  |  |  | 114 | 2.1
 |  |  |  |  |  |  |  |  |  |  | 115 | 1.9