| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||
2 | The Chance That ROI On Link Building Will Be Positive Over 36 Months | 100% | ||||||||||||||||
3 | The Chance That ROI On Link Building Will Be Negative Over 36 Months | 0% | ||||||||||||||||
4 | Average Net Profit Over 36 Months | $452,158 | ||||||||||||||||
5 | Average ROI Over 36 Months | 6.4 | ||||||||||||||||
6 | ||||||||||||||||||
7 | Months To Calculate ROI Over | 36 | ||||||||||||||||
8 | ||||||||||||||||||
9 | Ranges | Traffic Potential (Per Month) | Revenue Per Visit (RPV) | Links Needed To Close Domain Authority Gap | Link Gap Closing Speed (Months) | Cost Per Link | Link Velocity (Per Month) | Triangular Distribution Probability For RPV | ||||||||||
10 | Upper Bound | 120,000 | $0.46 | 100 | 18 | $130 | 18 | Less Than Mean | 75% | |||||||||
11 | Mean | 100,000 | $0.28 | 75 | 15 | $110 | 16 | Greater Than Mean | 25% | |||||||||
12 | Lower Bound | 80,000 | $0.10 | 50 | 12 | $90 | 14 | |||||||||||
13 | ||||||||||||||||||
14 | Max | 142440 | $0.45 | 133 | 23 | $153 | 21 | $1,224,118 | $106,849 | $1,162,924 | 19.6 | |||||||
15 | Min | 55419 | $0.10 | 12 | 8 | $63 | 12 | $134,394 | $40,078 | $60,689 | 0.8 | |||||||
16 | ||||||||||||||||||
17 | Scenario # | Traffic Potential (Per Month) | Revenue Per Visit (RPV) | Links Needed To Close Domain Authority Gap | Link Gap Closing Speed (Months) | Cost Per Link | Link Velocity (Per Month) | Total Revenue From Link Building | Total Link Building Costs | Net Return On Link Building | ROI | Positive ROI? | Bucket | Cumulative Frequency | Bucket Frequency | Bucket Distribution | ||
18 | 1 | 113546 | $0.37 | 64 | 17 | $95 | 16 | $790,404 | $59,667 | $730,737 | 12.2 | 1 | -2 | 0 | 0 | 0% | ||
19 | 2 | 113533 | $0.28 | 56 | 16 | $116 | 16 | $624,488 | $73,214 | $551,273 | 7.5 | 1 | -1 | 0 | 0 | 0% | ||
20 | 3 | 89434 | $0.20 | 68 | 13 | $113 | 15 | $416,553 | $68,984 | $347,569 | 5.0 | 1 | 0 | 0 | 0 | 0% | ||
21 | 4 | 101808 | $0.25 | 95 | 16 | $125 | 16 | $517,957 | $85,492 | $432,465 | 5.1 | 1 | 1 | 1 | 1 | 0% | ||
22 | 5 | 97193 | $0.39 | 89 | 15 | $113 | 16 | $784,314 | $73,980 | $710,334 | 9.6 | 1 | 2 | 100 | 99 | 1% | ||
23 | 6 | 127234 | $0.16 | 82 | 13 | $117 | 15 | $467,373 | $70,888 | $396,485 | 5.6 | 1 | 3 | 565 | 465 | 5% | ||
24 | 7 | 98091 | $0.34 | 71 | 20 | $123 | 18 | $548,996 | $86,986 | $462,009 | 5.3 | 1 | 4 | 1600 | 1035 | 11% | ||
25 | 8 | 95064 | $0.24 | 56 | 15 | $88 | 19 | $463,604 | $66,160 | $397,443 | 6.0 | 1 | 5 | 3096 | 1496 | 16% | ||
26 | 9 | 103865 | $0.27 | 82 | 19 | $98 | 15 | $478,056 | $62,121 | $415,936 | 6.7 | 1 | 6 | 4769 | 1673 | 18% | ||
27 | 10 | 92829 | $0.25 | 88 | 14 | $111 | 16 | $508,910 | $72,536 | $436,374 | 6.0 | 1 | 7 | 6384 | 1615 | 18% | ||
28 | 11 | 128130 | $0.15 | 124 | 14 | $104 | 17 | $422,530 | $76,551 | $345,979 | 4.5 | 1 | 8 | 7652 | 1268 | 14% | ||
29 | 12 | 89095 | $0.30 | 62 | 15 | $114 | 15 | $563,943 | $69,705 | $494,237 | 7.1 | 1 | 9 | 8501 | 849 | 9% | ||
30 | 13 | 72858 | $0.20 | 58 | 12 | $100 | 18 | $346,996 | $70,094 | $276,901 | 4.0 | 1 | 10 | 9095 | 594 | 7% | ||
31 | 14 | 87321 | $0.24 | 77 | 15 | $81 | 16 | $444,604 | $52,233 | $392,372 | 7.5 | 1 | ||||||
32 | 15 | 111356 | $0.27 | 80 | 14 | $126 | 18 | $664,949 | $90,225 | $574,724 | 6.4 | 1 | ||||||
33 | 16 | 107619 | $0.31 | 75 | 18 | $107 | 18 | $594,372 | $76,668 | $517,705 | 6.8 | 1 | ||||||
34 | 17 | 101593 | $0.31 | 84 | 17 | $97 | 16 | $583,361 | $62,993 | $520,369 | 8.3 | 1 | ||||||
35 | 18 | 96231 | $0.33 | 92 | 18 | $102 | 16 | $588,275 | $68,508 | $519,766 | 7.6 | 1 | ||||||
36 | 19 | 132805 | $0.24 | 69 | 15 | $108 | 16 | $670,015 | $71,479 | $598,536 | 8.4 | 1 | ||||||
37 | 20 | 81549 | $0.36 | 87 | 16 | $113 | 17 | $600,742 | $79,310 | $521,431 | 6.6 | 1 | ||||||
38 | 21 | 99943 | $0.24 | 86 | 15 | $124 | 17 | $513,280 | $86,701 | $426,580 | 4.9 | 1 | ||||||
39 | 22 | 92346 | $0.27 | 94 | 14 | $118 | 17 | $529,744 | $81,725 | $448,020 | 5.5 | 1 | ||||||
40 | 23 | 96597 | $0.38 | 56 | 16 | $109 | 17 | $749,130 | $73,653 | $675,478 | 9.2 | 1 | ||||||
41 | 24 | 110150 | $0.24 | 77 | 16 | $113 | 15 | $525,133 | $69,287 | $455,846 | 6.6 | 1 | ||||||
42 | 25 | 108861 | $0.24 | 69 | 19 | $125 | 16 | $435,216 | $78,398 | $356,818 | 4.6 | 1 | ||||||
43 | 26 | 113362 | $0.25 | 60 | 14 | $87 | 15 | $641,755 | $52,378 | $589,378 | 11.3 | 1 | ||||||
44 | 27 | 105324 | $0.20 | 73 | 18 | $122 | 17 | $378,843 | $81,517 | $297,326 | 3.6 | 1 | ||||||
45 | 28 | 116974 | $0.25 | 76 | 17 | $112 | 16 | $544,933 | $75,265 | $469,668 | 6.2 | 1 | ||||||
46 | 29 | 90482 | $0.17 | 92 | 16 | $111 | 16 | $307,777 | $75,213 | $232,565 | 3.1 | 1 | ||||||
47 | 30 | 90934 | $0.20 | 78 | 15 | $129 | 17 | $387,226 | $89,815 | $297,411 | 3.3 | 1 | ||||||
48 | 31 | 107445 | $0.19 | 50 | 17 | $131 | 17 | $406,346 | $86,306 | $320,040 | 3.7 | 1 | ||||||
49 | 32 | 105570 | $0.14 | 70 | 11 | $101 | 15 | $358,741 | $62,201 | $296,539 | 4.8 | 1 | ||||||
50 | 33 | 101629 | $0.30 | 61 | 15 | $105 | 15 | $634,901 | $63,654 | $571,247 | 9.0 | 1 | ||||||
51 | 34 | 75693 | $0.26 | 90 | 14 | $104 | 18 | $448,939 | $74,827 | $374,113 | 5.0 | 1 | ||||||
52 | 35 | 111692 | $0.27 | 70 | 13 | $107 | 15 | $679,133 | $66,204 | $612,929 | 9.3 | 1 | ||||||
53 | 36 | 82194 | $0.31 | 98 | 14 | $124 | 14 | $562,466 | $75,736 | $486,730 | 6.4 | 1 | ||||||
54 | 37 | 87838 | $0.16 | 60 | 14 | $110 | 16 | $321,996 | $68,183 | $253,813 | 3.7 | 1 | ||||||
55 | 38 | 111709 | $0.14 | 71 | 16 | $91 | 15 | $307,293 | $55,936 | $251,357 | 4.5 | 1 | ||||||
56 | 39 | 86375 | $0.44 | 80 | 12 | $106 | 15 | $892,931 | $67,287 | $825,644 | 12.3 | 1 | ||||||
57 | 40 | 95733 | $0.38 | 77 | 15 | $115 | 16 | $771,766 | $76,726 | $695,040 | 9.1 | 1 | ||||||
58 | 41 | 114251 | $0.27 | 40 | 15 | $139 | 17 | $648,886 | $90,192 | $558,694 | 6.2 | 1 | ||||||
59 | 42 | 107342 | $0.34 | 92 | 13 | $110 | 17 | $843,920 | $78,821 | $765,099 | 9.7 | 1 | ||||||
60 | 43 | 99961 | $0.29 | 86 | 14 | $112 | 15 | $655,283 | $69,008 | $586,275 | 8.5 | 1 | ||||||
61 | 44 | 118955 | $0.37 | 69 | 16 | $105 | 18 | $893,760 | $74,284 | $819,476 | 11.0 | 1 | ||||||
62 | 45 | 106122 | $0.23 | 95 | 15 | $119 | 16 | $507,174 | $79,749 | $427,425 | 5.4 | 1 | ||||||
63 | 46 | 97086 | $0.33 | 68 | 15 | $92 | 14 | $667,340 | $53,893 | $613,447 | 11.4 | 1 | ||||||
64 | 47 | 95797 | $0.23 | 88 | 16 | $94 | 16 | $443,364 | $62,050 | $381,314 | 6.1 | 1 | ||||||
65 | 48 | 105534 | $0.38 | 72 | 18 | $106 | 15 | $721,966 | $65,366 | $656,600 | 10.0 | 1 | ||||||
66 | 49 | 90360 | $0.14 | 65 | 18 | $117 | 19 | $230,426 | $86,101 | $144,325 | 1.7 | 1 | ||||||
67 | 50 | 94180 | $0.37 | 71 | 15 | $118 | 16 | $743,526 | $76,975 | $666,551 | 8.7 | 1 | ||||||
68 | 51 | 111179 | $0.34 | 82 | 16 | $113 | 17 | $771,725 | $76,370 | $695,354 | 9.1 | 1 | ||||||
69 | 52 | 101826 | $0.22 | 90 | 17 | $109 | 17 | $416,759 | $77,326 | $339,433 | 4.4 | 1 | ||||||
70 | 53 | 90330 | $0.24 | 64 | 17 | $120 | 17 | $404,584 | $80,032 | $324,552 | 4.1 | 1 | ||||||
71 | 54 | 106422 | $0.23 | 63 | 14 | $110 | 16 | $535,173 | $68,342 | $466,831 | 6.8 | 1 | ||||||
72 | 55 | 95842 | $0.28 | 66 | 16 | $130 | 15 | $539,907 | $78,891 | $461,016 | 5.8 | 1 | ||||||
73 | 56 | 79491 | $0.37 | 73 | 11 | $104 | 16 | $742,950 | $68,365 | $674,585 | 9.9 | 1 | ||||||
74 | 57 | 105011 | $0.23 | 75 | 14 | $127 | 16 | $525,955 | $82,241 | $443,714 | 5.4 | 1 | ||||||
75 | 58 | 97445 | $0.27 | 96 | 15 | $129 | 14 | $559,397 | $78,713 | $480,684 | 6.1 | 1 | ||||||
76 | 59 | 99682 | $0.14 | 54 | 16 | $123 | 15 | $288,867 | $72,544 | $216,324 | 3.0 | 1 | ||||||
77 | 60 | 63493 | $0.18 | 64 | 15 | $111 | 16 | $232,668 | $69,371 | $163,296 | 2.4 | 1 | ||||||
78 | 61 | 94641 | $0.26 | 85 | 10 | $104 | 16 | $632,414 | $68,737 | $563,677 | 8.2 | 1 | ||||||
79 | 62 | 107328 | $0.29 | 58 | 12 | $105 | 16 | $740,589 | $66,738 | $673,851 | 10.1 | 1 | ||||||
80 | 63 | 108439 | $0.28 | 68 | 15 | $102 | 14 | $645,188 | $59,373 | $585,815 | 9.9 | 1 | ||||||
81 | 64 | 103145 | $0.19 | 78 | 17 | $108 | 15 | $373,548 | $68,418 | $305,130 | 4.5 | 1 | ||||||
82 | 65 | 105582 | $0.23 | 56 | 14 | $93 | 14 | $542,542 | $53,577 | $488,964 | 9.1 | 1 | ||||||
83 | 66 | 68946 | $0.31 | 79 | 14 | $111 | 15 | $466,103 | $67,563 | $398,540 | 5.9 | 1 | ||||||
84 | 67 | 88608 | $0.18 | 73 | 16 | $104 | 14 | $325,622 | $60,417 | $265,205 | 4.4 | 1 | ||||||
85 | 68 | 110602 | $0.30 | 80 | 17 | $126 | 16 | $624,172 | $80,936 | $543,236 | 6.7 | 1 | ||||||
86 | 69 | 100005 | $0.23 | 67 | 15 | $130 | 16 | $489,095 | $82,406 | $406,689 | 4.9 | 1 | ||||||
87 | 70 | 97701 | $0.26 | 77 | 17 | $116 | 16 | $481,216 | $74,041 | $407,175 | 5.5 | 1 | ||||||
88 | 71 | 97201 | $0.27 | 107 | 18 | $100 | 16 | $479,872 | $69,538 | $410,334 | 5.9 | 1 | ||||||
89 | 72 | 93301 | $0.19 | 85 | 14 | $128 | 15 | $382,110 | $80,941 | $301,169 | 3.7 | 1 | ||||||
90 | 73 | 116333 | $0.29 | 88 | 15 | $117 | 16 | $728,315 | $77,414 | $650,901 | 8.4 | 1 | ||||||
91 | 74 | 92190 | $0.24 | 71 | 17 | $103 | 16 | $425,740 | $65,365 | $360,374 | 5.5 | 1 | ||||||
92 | 75 | 111880 | $0.21 | 76 | 17 | $97 | 16 | $463,964 | $63,950 | $400,014 | 6.3 | 1 | ||||||
93 | 76 | 110290 | $0.29 | 80 | 16 | $114 | 15 | $642,367 | $70,504 | $571,864 | 8.1 | 1 | ||||||
94 | 77 | 91769 | $0.25 | 89 | 18 | $90 | 14 | $396,774 | $54,665 | $342,109 | 6.3 | 1 | ||||||
95 | 78 | 96870 | $0.29 | 71 | 13 | $104 | 18 | $643,970 | $73,020 | $570,950 | 7.8 | 1 | ||||||
96 | 79 | 100755 | $0.29 | 87 | 12 | $125 | 17 | $710,657 | $86,787 | $623,870 | 7.2 | 1 | ||||||
97 | 80 | 75703 | $0.17 | 48 | 18 | $119 | 15 | $226,464 | $72,204 | $154,259 | 2.1 | 1 | ||||||
98 | 81 | 115406 | $0.28 | 79 | 15 | $121 | 16 | $677,032 | $81,121 | $595,910 | 7.3 | 1 | ||||||
99 | 82 | 70602 | $0.27 | 73 | 14 | $95 | 15 | $417,221 | $59,825 | $357,396 | 6.0 | 1 | ||||||
100 | 83 | 126671 | $0.13 | 47 | 15 | $108 | 15 | $346,098 | $64,637 | $281,461 | 4.4 | 1 | ||||||