A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Only fill in the cells that are yellow to avoid deleting formulas. Please download or make a copy of this calculator from File -> Make a copy, or File -> Download | |||||||||||
2 | Changing the cells in red are optional. It will override the formulas but will allow you more flexibility to determine your annual expenses. | |||||||||||
3 | This calculator is provided for free by freeinfiveyears.com | |||||||||||
4 | ||||||||||||
5 | (a) | How old are you now? | 35 | AGE THAT YOU ARE FINANCIALLY FREE | ||||||||
6 | (b) | What were your annual expenses last year? | 200,000 | 50 | ||||||||
7 | (c) | What inflation rate do you want to use? | 3.70% | |||||||||
8 | (d) | How much do you have invested currently? | 800,000 | |||||||||
9 | (e) | What is the average yearly ROI for your investments? | 4.00% | |||||||||
10 | ||||||||||||
11 | Age (a) | Year | Annual Expenses (b) | Increase/(Decrease) in Annual Expenses | Inflation Rate (c) | Annual Expenses After Inflation | Monthly Financial Freedom Number | Investments (d) | Increase/(Decrease) in Annual Investments | Total Investments | ROI (annual) (e) | Passive Income (monthly) |
12 | 35 | 1 | 200,000 | 2.0% | 3.7% | 211,548 | 17,629 | 800,000 | 5.0% | 840,000 | 33,600 | 2,800 |
13 | 36 | 2 | 215,779 | 2.0% | 3.7% | 228,238 | 19,020 | 873,600 | 5.0% | 917,280 | 36,691 | 3,058 |
14 | 37 | 3 | 232,803 | 2.0% | 3.7% | 246,245 | 20,520 | 953,971 | 5.0% | 1,001,670 | 40,067 | 3,339 |
15 | 38 | 4 | 251,170 | 2.0% | 3.7% | 265,672 | 22,139 | 1,041,737 | 8.0% | 1,125,075 | 45,003 | 3,750 |
16 | 39 | 5 | 270,986 | 2.0% | 3.7% | 286,632 | 23,886 | 1,170,078 | 8.0% | 1,263,685 | 50,547 | 4,212 |
17 | 40 | 6 | 292,365 | 2.0% | 3.7% | 309,246 | 25,771 | 1,314,232 | 8.0% | 1,419,371 | 56,775 | 4,731 |
18 | 41 | 7 | 315,431 | 2.0% | 3.7% | 333,644 | 27,804 | 1,476,146 | 12.0% | 1,653,283 | 66,131 | 5,511 |
19 | 42 | 8 | 340,317 | 5.0% | 3.7% | 370,554 | 30,880 | 1,719,414 | 12.0% | 1,925,744 | 77,030 | 6,419 |
20 | 43 | 9 | 389,082 | 5.0% | 3.7% | 423,652 | 35,304 | 2,002,774 | 12.0% | 2,243,107 | 89,724 | 7,477 |
21 | 44 | 10 | 444,834 | 5.0% | 3.7% | 484,358 | 40,363 | 2,332,831 | 15.0% | 2,682,756 | 107,310 | 8,943 |
22 | 45 | 11 | 508,576 | -20.0% | 3.7% | 421,915 | 35,160 | 2,790,066 | 15.0% | 3,208,576 | 128,343 | 10,695 |
23 | 46 | 12 | 337,532 | -5.0% | 3.7% | 332,519 | 27,710 | 3,336,919 | 15.0% | 3,837,457 | 153,498 | 12,792 |
24 | 47 | 13 | 315,893 | -20.0% | 3.7% | 262,065 | 21,839 | 3,990,955 | 3.0% | 4,110,683 | 164,427 | 13,702 |
25 | 48 | 14 | 209,652 | -3.0% | 3.7% | 210,887 | 17,574 | 4,275,111 | 3.0% | 4,403,364 | 176,135 | 14,678 |
26 | 49 | 15 | 204,560 | -3.0% | 3.7% | 205,765 | 17,147 | 4,579,499 | 3.0% | 4,716,884 | 188,675 | 15,723 |
27 | 50 | 16 | 199,592 | -3.0% | 3.7% | 200,768 | 16,731 | 4,905,559 | 3.0% | 5,052,726 | 202,109 | 16,842 |
28 | 51 | 17 | 194,745 | -3.0% | 3.7% | 195,892 | 16,324 | 5,254,835 | 3.0% | 5,412,480 | 216,499 | 18,042 |
29 | 52 | 18 | 190,015 | 0.0% | 3.7% | 197,046 | 16,420 | 5,628,979 | 3.0% | 5,797,848 | 231,914 | 19,326 |
30 | 53 | 19 | 197,046 | 0.0% | 3.7% | 204,336 | 17,028 | 6,029,762 | 3.0% | 6,210,655 | 248,426 | 20,702 |
31 | 54 | 20 | 204,336 | 0.0% | 3.7% | 211,897 | 17,658 | 6,459,081 | 0.0% | 6,459,081 | 258,363 | 21,530 |
32 | 55 | 21 | 211,897 | 0.0% | 3.7% | 219,737 | 18,311 | 6,717,445 | 0.0% | 6,717,445 | 268,698 | 22,391 |
33 | 56 | 22 | 219,737 | 0.0% | 3.7% | 227,867 | 18,989 | 6,986,142 | 0.0% | 6,986,142 | 279,446 | 23,287 |
34 | 57 | 23 | 227,867 | 0.0% | 3.7% | 236,298 | 19,692 | 7,265,588 | 0.0% | 7,265,588 | 290,624 | 24,219 |
35 | 58 | 24 | 236,298 | 0.0% | 3.7% | 245,041 | 20,420 | 7,556,212 | 0.0% | 7,556,212 | 302,248 | 25,187 |
36 | 59 | 25 | 245,041 | 0.0% | 3.7% | 254,108 | 21,176 | 7,858,460 | 0.0% | 7,858,460 | 314,338 | 26,195 |
37 | 60 | 26 | 254,108 | 0.0% | 3.7% | 263,510 | 21,959 | 8,172,799 | 0.0% | 8,172,799 | 326,912 | 27,243 |
38 | 61 | 27 | 263,510 | 0.0% | 3.7% | 273,260 | 22,772 | 8,499,711 | 0.0% | 8,499,711 | 339,988 | 28,332 |
39 | 62 | 28 | 273,260 | 0.0% | 3.7% | 283,370 | 23,614 | 8,839,699 | 0.0% | 8,839,699 | 353,588 | 29,466 |
40 | 63 | 29 | 283,370 | 0.0% | 3.7% | 293,855 | 24,488 | 9,193,287 | 0.0% | 9,193,287 | 367,731 | 30,644 |
41 | 64 | 30 | 293,855 | 0.0% | 3.7% | 304,728 | 25,394 | 9,561,018 | 0.0% | 9,561,018 | 382,441 | 31,870 |
42 | 65 | 31 | 304,728 | 0.0% | 3.7% | 316,003 | 26,334 | 9,943,459 | 0.0% | 9,943,459 | 397,738 | 33,145 |
43 | 66 | 32 | 316,003 | 0.0% | 3.7% | 327,695 | 27,308 | 10,341,197 | 0.0% | 10,341,197 | 413,648 | 34,471 |
44 | 67 | 33 | 327,695 | 0.0% | 3.7% | 339,819 | 28,318 | 10,754,845 | 0.0% | 10,754,845 | 430,194 | 35,849 |
45 | 68 | 34 | 339,819 | 0.0% | 3.7% | 352,393 | 29,366 | 11,185,039 | 0.0% | 11,185,039 | 447,402 | 37,283 |
46 | 69 | 35 | 352,393 | 0.0% | 3.7% | 365,431 | 30,453 | 11,632,441 | 0.0% | 11,632,441 | 465,298 | 38,775 |
47 | 70 | 36 | 365,431 | 0.0% | 3.7% | 378,952 | 31,579 | 12,097,738 | 0.0% | 12,097,738 | 483,910 | 40,326 |
48 | 71 | 37 | 378,952 | 0.0% | 3.7% | 392,973 | 32,748 | 12,581,648 | 0.0% | 12,581,648 | 503,266 | 41,939 |
49 | 72 | 38 | 392,973 | 0.0% | 3.7% | 407,513 | 33,959 | 13,084,914 | 0.0% | 13,084,914 | 523,397 | 43,616 |
50 | 73 | 39 | 407,513 | 0.0% | 3.7% | 422,591 | 35,216 | 13,608,310 | 0.0% | 13,608,310 | 544,332 | 45,361 |
51 | 74 | 40 | 422,591 | 0.0% | 3.7% | 438,227 | 36,519 | 14,152,643 | 0.0% | 14,152,643 | 566,106 | 47,175 |
52 | 75 | 41 | 438,227 | 0.0% | 3.7% | 454,442 | 37,870 | 14,718,749 | 0.0% | 14,718,749 | 588,750 | 49,062 |
53 | 76 | 42 | 454,442 | 0.0% | 3.7% | 471,256 | 39,271 | 15,307,498 | 0.0% | 15,307,498 | 612,300 | 51,025 |
54 | 77 | 43 | 471,256 | 0.0% | 3.7% | 488,693 | 40,724 | 15,919,798 | 0.0% | 15,919,798 | 636,792 | 53,066 |
55 | 78 | 44 | 488,693 | 0.0% | 3.7% | 506,774 | 42,231 | 16,556,590 | 0.0% | 16,556,590 | 662,264 | 55,189 |
56 | 79 | 45 | 506,774 | 0.0% | 3.7% | 525,525 | 43,794 | 17,218,854 | 0.0% | 17,218,854 | 688,754 | 57,396 |
57 | 80 | 46 | 525,525 | 0.0% | 3.7% | 544,969 | 45,414 | 17,907,608 | 0.0% | 17,907,608 | 716,304 | 59,692 |
58 | 81 | 47 | 544,969 | 0.0% | 3.7% | 565,133 | 47,094 | 18,623,912 | 0.0% | 18,623,912 | 744,956 | 62,080 |
59 | 82 | 48 | 565,133 | 0.0% | 3.7% | 586,043 | 48,837 | 19,368,869 | 0.0% | 19,368,869 | 774,755 | 64,563 |
60 | 83 | 49 | 586,043 | 0.0% | 3.7% | 607,727 | 50,644 | 20,143,624 | 0.0% | 20,143,624 | 805,745 | 67,145 |
61 | 84 | 50 | 607,727 | 0.0% | 3.7% | 630,213 | 52,518 | 20,949,369 | 0.0% | 20,949,369 | 837,975 | 69,831 |
62 | 85 | 51 | 630,213 | 0.0% | 3.7% | 653,530 | 54,461 | 21,787,343 | 0.0% | 21,787,343 | 871,494 | 72,624 |
63 | 86 | 52 | 653,530 | 0.0% | 3.7% | 677,711 | 56,476 | 22,658,837 | 0.0% | 22,658,837 | 906,353 | 75,529 |
64 | 87 | 53 | 677,711 | 0.0% | 3.7% | 702,786 | 58,566 | 23,565,191 | 0.0% | 23,565,191 | 942,608 | 78,551 |
65 | 88 | 54 | 702,786 | 0.0% | 3.7% | 728,789 | 60,732 | 24,507,798 | 0.0% | 24,507,798 | 980,312 | 81,693 |
66 | 89 | 55 | 728,789 | 0.0% | 3.7% | 755,755 | 62,980 | 25,488,110 | 0.0% | 25,488,110 | 1,019,524 | 84,960 |
67 | 90 | 56 | 755,755 | 0.0% | 3.7% | 783,718 | 65,310 | 26,507,635 | 0.0% | 26,507,635 | 1,060,305 | 88,359 |
68 | 91 | 57 | 783,718 | 0.0% | 3.7% | 812,715 | 67,726 | 27,567,940 | 0.0% | 27,567,940 | 1,102,718 | 91,893 |
69 | 92 | 58 | 812,715 | 0.0% | 3.7% | 842,786 | 70,232 | 28,670,658 | 0.0% | 28,670,658 | 1,146,826 | 95,569 |
70 | 93 | 59 | 842,786 | 0.0% | 3.7% | 873,969 | 72,831 | 29,817,484 | 0.0% | 29,817,484 | 1,192,699 | 99,392 |
71 | 94 | 60 | 873,969 | 0.0% | 3.7% | 906,305 | 75,525 | 31,010,183 | 0.0% | 31,010,183 | 1,240,407 | 103,367 |