ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ScenarioOpportunity Cost
2
1 Dog for 24 years
$ 1,423,219
3
4
5
Assumptions $ 1
6
7
Retirement age62
8
Annual Costs $ 1,400
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,423,219
17
18
19
20
21
22
23
24
25
26
27
28
AgeAnnual Opp Cost calc step
Cum Investment value
Age1 Dog for 24 years
29
20 $ - $ - 20$0.000
30
21 $ - $ - $ - 21$0.000
31
22 $ 1,400 $ 1,400 $ 1,540 22$1,540.010
32
23 $ 1,445 $ 2,985 $ 3,283 23$3,283.310
33
24 $ 1,491 $ 4,774 $ 5,252 24$5,251.710
34
25 $ 1,539 $ 6,790 $ 7,470 25$7,469.510
35
26 $ 1,588 $ 9,058 $ 9,963 26$9,963.310
36
27 $ 1,639 $ 11,602 $ 12,762 27$12,762.310
37
28 $ 1,691 $ 14,454 $ 15,899 28$15,898.910
38
29 $ 1,745 $ 17,644 $ 19,409 29$19,408.710
39
30 $ 1,801 $ 21,210 $ 23,331 30$23,330.910
40
31 $ 1,859 $ 25,190 $ 27,709 31$27,708.710
41
32 $ 1,918 $ 29,627 $ 32,590 32$32,589.810
42
33 $ 1,980 $ 34,569 $ 38,026 33$38,026.410
43
34 $ 2,043 $ 40,069 $ 44,076 34$44,076.410
44
35 $ 2,108 $ 46,185 $ 50,803 35$50,803.410
45
36 $ 2,176 $ 52,979 $ 58,277 36$58,277.210
46
37 $ 2,246 $ 60,523 $ 66,575 37$66,575.110
47
38 $ 2,317 $ 68,892 $ 75,782 38$75,781.710
48
39 $ 2,392 $ 78,173 $ 85,991 39$85,990.610
49
40 $ 2,468 $ 88,459 $ 97,305 40$97,304.610
50
41 $ 2,547 $ 99,852 $ 109,837 41$109,836.910
51
42 $ 2,629 $ 112,465 $ 123,712 42$123,712.010
52
43 $ 2,713 $ 126,425 $ 139,067 43$139,067.210
53
44 $ 2,800 $ 141,867 $ 156,053 44$156,053.310
54
45 $ 2,889 $ 158,942 $ 174,837 45$174,836.710
55
46 $ - $ 174,837 $ 192,320 46$192,320.311
56
47 $ - $ 192,320 $ 211,552 47$211,552.411
57
48 $ - $ 211,552 $ 232,708 48$232,707.611
58
49 $ - $ 232,708 $ 255,978 49$255,978.411
59
50 $ - $ 255,978 $ 281,576 50$281,576.211
60
51 $ - $ 281,576 $ 309,734 51$309,733.811
61
52 $ - $ 309,734 $ 340,707 52$340,707.211
62
53 $ - $ 340,707 $ 374,778 53$374,777.911
63
54 $ - $ 374,778 $ 412,256 54$412,255.711
64
55 $ - $ 412,256 $ 453,481 55$453,481.311
65
56 $ - $ 453,481 $ 498,829 56$498,829.411
66
57 $ - $ 498,829 $ 548,712 57$548,712.411
67
58 $ - $ 548,712 $ 603,584 58$603,583.611
68
59 $ - $ 603,584 $ 663,942 59$663,942.011
69
60 $ - $ 663,942 $ 730,336 60$730,336.111
70
61 $ - $ 730,336 $ 803,370 61$803,369.811
71
62 $ - $ 803,370 $ 883,707 62$883,706.711
72
63 $ - $ 883,707 $ 972,077 63$972,077.411
73
64 $ - $ 972,077 $ 1,069,285 64$1,069,285.211
74
65 $ - $ 1,069,285 $ 1,176,214 65$1,176,213.711
75
66 $ - $ 1,176,214 $ 1,293,835 66$1,293,835.011
76
67 $ - $ 1,293,835 $ 1,423,219 67$1,423,218.511
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100