ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ScenarioOpportunity Cost
2
1 Dog for 24 years
$ 1,446,923
3
4
5
Assumptions $ 1
6
7
Retirement age62
8
Annual Costs $ 2,000
9
After Tax Investment rate
9%
10
Inflation3%
11
How many years own pet?
24
12
Starting Age22fixed
13
14
Long-term Opportunity Cost
15
16
Retirement Value $ 1,446,923
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 $ 2,000 $ 2,000 $ 2,180 22$2,180.010
32
23 $ 2,064 $ 4,244 $ 4,626 23$4,626.010
33
24 $ 2,130 $ 6,756 $ 7,364 24$7,364.010
34
25 $ 2,198 $ 9,562 $ 10,423 25$10,422.910
35
26 $ 2,269 $ 12,691 $ 13,834 26$13,833.610
36
27 $ 2,341 $ 16,175 $ 17,631 27$17,630.510
37
28 $ 2,416 $ 20,047 $ 21,851 28$21,850.810
38
29 $ 2,493 $ 24,344 $ 26,535 29$26,535.110
39
30 $ 2,573 $ 29,108 $ 31,728 30$31,728.010
40
31 $ 2,656 $ 34,384 $ 37,478 31$37,478.110
41
32 $ 2,740 $ 40,219 $ 43,838 32$43,838.210
42
33 $ 2,828 $ 46,666 $ 50,866 33$50,866.410
43
34 $ 2,919 $ 53,785 $ 58,626 34$58,625.710
44
35 $ 3,012 $ 61,638 $ 67,185 35$67,185.210
45
36 $ 3,108 $ 70,294 $ 76,620 36$76,620.110
46
37 $ 3,208 $ 79,828 $ 87,013 37$87,012.510
47
38 $ 3,311 $ 90,323 $ 98,452 38$98,452.210
48
39 $ 3,417 $ 101,869 $ 111,037 39$111,036.910
49
40 $ 3,526 $ 114,563 $ 124,873 40$124,873.410
50
41 $ 3,639 $ 128,512 $ 140,078 41$140,078.210
51
42 $ 3,755 $ 143,833 $ 156,778 42$156,778.310
52
43 $ 3,875 $ 160,654 $ 175,112 43$175,112.410
53
44 $ 3,999 $ 179,112 $ 195,232 44$195,231.710
54
45 $ 4,127 $ 199,359 $ 217,301 45$217,301.310
55
46 $ - $ 217,301 $ 236,858 46$236,858.411
56
47 $ - $ 236,858 $ 258,176 47$258,175.711
57
48 $ - $ 258,176 $ 281,412 48$281,411.511
58
49 $ - $ 281,412 $ 306,739 49$306,738.511
59
50 $ - $ 306,739 $ 334,345 50$334,345.011
60
51 $ - $ 334,345 $ 364,436 51$364,436.111
61
52 $ - $ 364,436 $ 397,235 52$397,235.311
62
53 $ - $ 397,235 $ 432,986 53$432,986.511
63
54 $ - $ 432,986 $ 471,955 54$471,955.311
64
55 $ - $ 471,955 $ 514,431 55$514,431.211
65
56 $ - $ 514,431 $ 560,730 56$560,730.011
66
57 $ - $ 560,730 $ 611,196 57$611,195.811
67
58 $ - $ 611,196 $ 666,203 58$666,203.411
68
59 $ - $ 666,203 $ 726,162 59$726,161.711
69
60 $ - $ 726,162 $ 791,516 60$791,516.211
70
61 $ - $ 791,516 $ 862,753 61$862,752.711
71
62 $ - $ 862,753 $ 940,400 62$940,400.411
72
63 $ - $ 940,400 $ 1,025,036 63$1,025,036.511
73
64 $ - $ 1,025,036 $ 1,117,290 64$1,117,289.711
74
65 $ - $ 1,117,290 $ 1,217,846 65$1,217,845.811
75
66 $ - $ 1,217,846 $ 1,327,452 66$1,327,451.911
76
67 $ - $ 1,327,452 $ 1,446,923 67$1,446,922.611
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100