ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ScenarioOpportunity Cost
2
1 Dog for 24 years
$ 1,219,902
3
4
5
Assumptions $ 1
6
7
Retirement age62
8
Annual Costs $ 1,200
9
After Tax Investment rate
10%
10
Inflation3%
11
How many years own pet?
24
12
Starting Age22fixed
13
14
Long-term Opportunity Cost
15
16
Retirement Value $ 1,219,902
17
18
19
20
21
22
23
24
25
26
AgeAnnual Opp Cost calc step
Cum Investment value
Age1 Dog for 24 years
27
20 $ - $ - 20$0.000
28
21 $ - $ - $ - 21$0.000
29
22 $ 1,200 $ 1,200 $ 1,320 22$1,320.010
30
23 $ 1,238 $ 2,558 $ 2,814 23$2,814.210
31
24 $ 1,278 $ 4,092 $ 4,501 24$4,501.510
32
25 $ 1,319 $ 5,820 $ 6,402 25$6,402.510
33
26 $ 1,361 $ 7,764 $ 8,540 26$8,540.010
34
27 $ 1,405 $ 9,945 $ 10,939 27$10,939.110
35
28 $ 1,450 $ 12,389 $ 13,628 28$13,627.610
36
29 $ 1,496 $ 15,124 $ 16,636 29$16,636.010
37
30 $ 1,544 $ 18,180 $ 19,998 30$19,997.910
38
31 $ 1,593 $ 21,591 $ 23,750 31$23,750.310
39
32 $ 1,644 $ 25,395 $ 27,934 32$27,934.110
40
33 $ 1,697 $ 29,631 $ 32,594 33$32,594.110
41
34 $ 1,751 $ 34,345 $ 37,780 34$37,779.810
42
35 $ 1,807 $ 39,587 $ 43,546 35$43,545.810
43
36 $ 1,865 $ 45,411 $ 49,952 36$49,951.910
44
37 $ 1,925 $ 51,877 $ 57,064 37$57,064.410
45
38 $ 1,986 $ 59,051 $ 64,956 38$64,955.810
46
39 $ 2,050 $ 67,006 $ 73,706 39$73,706.310
47
40 $ 2,116 $ 75,822 $ 83,404 40$83,404.010
48
41 $ 2,183 $ 85,587 $ 94,146 41$94,145.910
49
42 $ 2,253 $ 96,399 $ 106,039 42$106,038.910
50
43 $ 2,325 $ 108,364 $ 119,200 43$119,200.410
51
44 $ 2,400 $ 121,600 $ 133,760 44$133,760.010
52
45 $ 2,476 $ 136,236 $ 149,860 45$149,860.010
53
46 $ - $ 149,860 $ 164,846 46$164,846.011
54
47 $ - $ 164,846 $ 181,331 47$181,330.611
55
48 $ - $ 181,331 $ 199,464 48$199,463.711
56
49 $ - $ 199,464 $ 219,410 49$219,410.011
57
50 $ - $ 219,410 $ 241,351 50$241,351.011
58
51 $ - $ 241,351 $ 265,486 51$265,486.111
59
52 $ - $ 265,486 $ 292,035 52$292,034.711
60
53 $ - $ 292,035 $ 321,238 53$321,238.211
61
54 $ - $ 321,238 $ 353,362 54$353,362.011
62
55 $ - $ 353,362 $ 388,698 55$388,698.211
63
56 $ - $ 388,698 $ 427,568 56$427,568.111
64
57 $ - $ 427,568 $ 470,325 57$470,324.911
65
58 $ - $ 470,325 $ 517,357 58$517,357.411
66
59 $ - $ 517,357 $ 569,093 59$569,093.111
67
60 $ - $ 569,093 $ 626,002 60$626,002.411
68
61 $ - $ 626,002 $ 688,603 61$688,602.711
69
62 $ - $ 688,603 $ 757,463 62$757,462.911
70
63 $ - $ 757,463 $ 833,209 63$833,209.211
71
64 $ - $ 833,209 $ 916,530 64$916,530.111
72
65 $ - $ 916,530 $ 1,008,183 65$1,008,183.111
73
66 $ - $ 1,008,183 $ 1,109,001 66$1,109,001.511
74
67 $ - $ 1,109,001 $ 1,219,902 67$1,219,901.611
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100