| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ↑ create a copy to edit | ||||||||||||||||||||||||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||||||||||||||||||||||||
3 | Model Settings | Chart Work | |||||||||||||||||||||||||||||||||||||||||||||||
4 | Investment Terms | Debt Portion | Preferred Equity Portion | Participating Preferred Payout | Converted Common Equity Payout | Investment Payout | Return | Slope | Value | Underlying | Exercise | Volatility | Interest | T | D1 | D2 | C (Price) | ||||||||||||||||||||||||||||||||
5 | Investment Amount ($) | $120.00 mm | 0 | 0 | 0 | 0 | 0 | 0 | -- | ||||||||||||||||||||||||||||||||||||||||
6 | Equity Ownership (%) | 0.2 | 15 | 15 | 0 | 15 | 3.6 | 15 | 1 | Company Value | $525.00 mm | 1.25 | 7 years | ||||||||||||||||||||||||||||||||||||
7 | Investment Type | Participating Preferred | 30 | 30 | 0 | 30 | 7.2 | 30 | 1 | Preferred Debt Call Option | -499.6396617 | $525.00 mm | $144.00 | 1.25 | 0.25% | 7 years | 2.050029399 | -1.25715974 | 499.6396617 | ||||||||||||||||||||||||||||||
8 | Participation Cap (X of Total Investment) | 1.5x | 45 | 45 | 0 | 45 | 10.8 | 45 | 1 | Common | 0 | ||||||||||||||||||||||||||||||||||||||
9 | Liquidity Preference #1 (X) | 1.2x | 60 | 60 | 0 | 60 | 14.4 | 60 | 1 | Participation | 99.92793233 | $525.00 mm | $144.00 | 1.25 | 0.25% | 7 years | 2.050029399 | -1.25715974 | 499.6396617 | ||||||||||||||||||||||||||||||
10 | Uptill (If Applicable, Value of Company) | 75 | 75 | 0 | 75 | 18 | 75 | 1 | Cap | -97.0325978 | $525.00 mm | 324 | 1.25 | 0.25% | 7 years | 1.80482715 | -1.502361989 | 485.162989 | |||||||||||||||||||||||||||||||
11 | Conversion Multiple (X) | 1.2x | 90 | 90 | 0 | 90 | 21.6 | 90 | 1 | Equity Conversion (No Participation) | 0 | $525.00 mm | 720 | 1.25 | 0.25% | 7 years | 1.563381117 | -1.743808022 | 465.3124558 | ||||||||||||||||||||||||||||||
12 | 105 | 105 | 0 | 105 | 25.2 | 105 | 1 | Equity Conversion (Participation) | 91.73010631 | $525.00 mm | 900 | 1.25 | 0.25% | 7 years | 1.495908849 | -1.811280289 | 458.6505316 | ||||||||||||||||||||||||||||||||
13 | Black- Scholes Assumptions | 120 | 120 | 0 | 120 | 28.8 | 120 | 1 | $119.99 mm | ||||||||||||||||||||||||||||||||||||||||
14 | Volatility | 1.25 | 135 | 135 | 0 | 135 | 32.4 | 135 | 1 | ||||||||||||||||||||||||||||||||||||||||
15 | Risk Free Rate | 0.25% | 150 | 144 | 1.2 | 145.2 | 36 | 145.2 | 0.68 | ||||||||||||||||||||||||||||||||||||||||
16 | Time to Expire (Years) | 7 years | 165 | 144 | 4.2 | 148.2 | 39.6 | 148.2 | 0.2 | Hacky Goal Seek | Different From Investment | Portfolio Value | Company Value | Preferred Debt Call Option | Participation | Cap | Equity Conversion (No Participation) | Equity Conversion (Participation) | |||||||||||||||||||||||||||||||
17 | 180 | 144 | 7.2 | 151.2 | 43.2 | 151.2 | 0.2 | ||||||||||||||||||||||||||||||||||||||||||
18 | 195 | 144 | 10.2 | 154.2 | 46.8 | 154.2 | 0.2 | Value | D1 | D2 | C (Price) | Value | D1 | D2 | C (Price) | Value | D1 | D2 | C (Price) | Value | D1 | D2 | C (Price) | Value | D1 | D2 | C (Price) | ||||||||||||||||||||||
19 | Valuations | 210 | 144 | 13.2 | 157.2 | 50.4 | 157.2 | 0.2 | 0 | ||||||||||||||||||||||||||||||||||||||||
20 | Pre & Post Money | 225 | 144 | 16.2 | 160.2 | 54 | 160.2 | 0.2 | 116.7201245 | 3.279875483 | 7.5 | -5.05458588 | 0.7654051869 | -2.541783952 | 5.05458588 | 1.010917176 | 0.7654051869 | -2.541783952 | 5.05458588 | -0.8784282262 | 0.5202029375 | -2.786986201 | 4.392141131 | 0 | 0.278756905 | -3.028432234 | 3.703760283 | 0.7019724125 | 0.2112846372 | -3.095904502 | 3.509862063 | ||||||||||||||||||
21 | Post-Money Valuation | $600.00 mm | 240 | 144 | 19.2 | 163.2 | 57.6 | 163.2 | 0.2 | 114.248401 | 5.751598974 | 15 | -11.13515904 | 0.974993194 | -2.332195945 | 11.13515904 | 2.227031808 | 0.974993194 | -2.332195945 | 11.13515904 | -1.984785325 | 0.7297909445 | -2.577398194 | 9.923926623 | 0 | 0.488344912 | -2.818844227 | 8.605219785 | 1.644511531 | 0.4208726442 | -2.886316495 | 8.222557655 | |||||||||||||||||
22 | Pre-Money Valuation | $480.00 mm | 255 | 144 | 22.2 | 166.2 | 61.2 | 166.2 | 0.2 | 112.0032188 | 7.996781203 | 22.5 | -17.51599945 | 1.097594319 | -2.20959482 | 17.51599945 | 3.503199891 | 1.097594319 | -2.20959482 | 17.51599945 | -3.164707156 | 0.8523920692 | -2.45479707 | 15.82353578 | 0 | 0.6109460368 | -2.696243102 | 13.93034535 | 2.674287922 | 0.5434737689 | -2.76371537 | 13.37143961 | |||||||||||||||||
23 | 270 | 144 | 25.2 | 169.2 | 64.8 | 169.2 | 0.2 | 109.8838173 | 10.11618269 | 30 | -24.06681104 | 1.184581201 | -2.122607938 | 24.06681104 | 4.813362209 | 1.184581201 | -2.122607938 | 24.06681104 | -4.387692513 | 0.9393789516 | -2.367810187 | 21.93846256 | 0 | 0.6979329191 | -2.60925622 | 19.51176742 | 3.757324042 | 0.6304606513 | -2.676728488 | 18.78662021 | |||||||||||||||||||
24 | Option Implied Valuation | 285 | 144 | 28.2 | 172.2 | 68.4 | 172.2 | 0.2 | 107.8475805 | 12.15241954 | 37.5 | -30.73162944 | 1.252053469 | -2.05513567 | 30.73162944 | 6.146325888 | 1.252053469 | -2.05513567 | 30.73162944 | -5.640218767 | 1.006851219 | -2.300337919 | 28.20109383 | 0 | 0.7654051869 | -2.541783952 | 25.2729294 | 4.877941855 | 0.6979329191 | -2.60925622 | 24.38970927 | ||||||||||||||||||
25 | Option Valuation | $525.00 mm | 300 | 144 | 31.2 | 175.2 | 72 | 175.2 | 0.2 | 105.8715628 | 14.12843718 | 45 | -37.47997173 | 1.307182326 | -2.000006813 | 37.47997173 | 7.495994346 | 1.307182326 | -2.000006813 | 37.47997173 | -6.914759784 | 1.061980076 | -2.245209063 | 34.57379892 | 0 | 0.8205340438 | -2.486655095 | 31.17030555 | 6.02717435 | 0.753061776 | -2.554127363 | 30.13587175 | |||||||||||||||||
26 | Option Portfolio's Value | $120.00 mm | 315 | 144 | 34.2 | 178.2 | 75.6 | 178.2 | 0.2 | 103.9416971 | 16.05830288 | 52.5 | -44.29297084 | 1.35379311 | -1.953396029 | 44.29297084 | 8.858594168 | 1.35379311 | -1.953396029 | 44.29297084 | -8.20657946 | 1.108590861 | -2.198598278 | 41.0328973 | 0 | 0.8671448282 | -2.440044311 | 37.17605294 | 7.19925901 | 0.7996725604 | -2.507516578 | 35.99629505 | |||||||||||||||||
27 | Option Value Pre | $405.00 mm | 330 | 144 | 36 | 180 | 79.2 | 180 | 0.12 | 102.0486139 | 17.95138612 | 60 | -51.15795682 | 1.394169208 | -1.913019931 | 51.15795682 | 10.23159136 | 1.394169208 | -1.913019931 | 51.15795682 | -9.512453992 | 1.148966959 | -2.15822218 | 47.56226996 | 0 | 0.9075209261 | -2.399668213 | 43.27096386 | 8.390205561 | 0.8400486583 | -2.467140481 | 41.9510278 | |||||||||||||||||
28 | 345 | 144 | 36 | 180 | 82.8 | 180 | 0 | 100.1857 | 19.81430003 | 67.5 | -58.0659218 | 1.42978345 | -1.877405688 | 58.0659218 | 11.61318436 | 1.42978345 | -1.877405688 | 58.0659218 | -10.83006497 | 1.184581201 | -2.122607938 | 54.15032485 | 0 | 0.9431351685 | -2.36405397 | 49.4410676 | 9.597102447 | 0.8756629007 | -2.431526238 | 47.98551223 | |||||||||||||||||||
29 | Term Worth | 360 | 144 | 36 | 180 | 86.4 | 180 | 0 | 98.34808248 | 21.65191752 | 75 | -65.01018473 | 1.461641476 | -1.845547663 | 65.01018473 | 13.00203695 | 1.461641476 | -1.845547663 | 65.01018473 | -12.15767566 | 1.216439226 | -2.090749912 | 60.7883783 | 0 | 0.974993194 | -2.332195945 | 55.6757952 | 10.81774096 | 0.9075209261 | -2.399668213 | 54.08870482 | ||||||||||||||||||
30 | Premium Paid for Terms | $15.00 mm | 375 | 144 | 36 | 180 | 90 | 180 | 1.50x | 0 | 96.53204931 | 23.46795069 | 82.5 | -71.98562544 | 1.490460565 | -1.816728573 | 71.98562544 | 14.39712509 | 1.490460565 | -1.816728573 | 71.98562544 | -13.49394334 | 1.245258316 | -2.061930823 | 67.46971672 | 0 | 1.003812283 | -2.303376855 | 61.96690411 | 12.05039438 | 0.9363400157 | -2.370849123 | 60.25197192 | ||||||||||||||||
31 | Premium as % of Investment | 14.29% | 390 | 144 | 36 | 180 | 93.6 | 180 | 0 | 94.73469653 | 25.26530347 | 90 | -78.98821628 | 1.516770333 | -1.790418806 | 78.98821628 | 15.79764326 | 1.516770333 | -1.790418806 | 78.98821628 | -14.83780344 | 1.271568083 | -2.035621055 | 74.18901722 | 0 | 1.030122051 | -2.277067088 | 68.30780813 | 13.29367994 | 0.9626497831 | -2.344539356 | 66.46839971 | |||||||||||||||||
32 | 405 | 144 | 36 | 180 | 97.2 | 180 | 0 | 92.95370255 | 27.04629745 | 97.5 | -86.01472068 | 1.540972973 | -1.766216166 | 86.01472068 | 17.20294414 | 1.540972973 | -1.766216166 | 86.01472068 | -16.18839435 | 1.295770723 | -2.011418416 | 80.94197177 | 0 | 1.054324691 | -2.252864448 | 74.693139 | 14.54646835 | 0.9868524229 | -2.320336716 | 72.73234176 | |||||||||||||||||||
33 | 420 | 144 | 36 | 180 | 100.8 | 180 | 0 | 91.18717751 | 28.81282249 | 105 | -93.06249117 | 1.563381117 | -1.743808022 | 93.06249117 | 18.61249823 | 1.563381117 | -1.743808022 | 93.06249117 | -17.54500668 | 1.318178868 | -1.989010271 | 87.72503341 | 0 | 1.076732835 | -2.230456304 | 81.11844818 | 15.8078221 | 1.009260567 | -2.297928571 | 79.03911052 | |||||||||||||||||||
34 | 435 | 144 | 36 | 180 | 104.4 | 180 | 0 | 89.43355926 | 30.56644074 | 112.5 | -100.1293294 | 1.584242601 | -1.722946538 | 100.1293294 | 20.02586587 | 1.584242601 | -1.722946538 | 100.1293294 | -18.90704781 | 1.339040351 | -1.968148788 | 94.53523904 | 0 | 1.097594319 | -2.20959482 | 87.57999727 | 17.07695203 | 1.030122051 | -2.277067088 | 85.38476017 | |||||||||||||||||||
35 | 450 | 144 | 36 | 180 | 108 | 180 | 0 | 87.69153941 | 32.30846059 | 120 | -107.213386 | 1.603757215 | -1.703431924 | 107.213386 | 21.44267721 | 1.603757215 | -1.703431924 | 107.213386 | -20.27401646 | 1.358554966 | -1.948634173 | 101.3700823 | 0 | 1.117108933 | -2.190080206 | 94.07460663 | 18.35318589 | 1.049636665 | -2.257552473 | 91.76592945 | |||||||||||||||||||
36 | 465 | 144 | 36 | 180 | 111.6 | 180 | 0 | 85.9600096 | 34.0399904 | 127.5 | -114.3130883 | 1.622088378 | -1.685100761 | 114.3130883 | 22.86261766 | 1.622088378 | -1.685100761 | 114.3130883 | -21.64548404 | 1.376886128 | -1.930303011 | 108.2274202 | 0 | 1.135440096 | -2.171749043 | 100.5995435 | 19.63594507 | 1.067967828 | -2.239221311 | 98.17972537 | |||||||||||||||||||
37 | 480 | 144 | 36 | 180 | 115.2 | 180 | 0 | 84.23802145 | 35.76197855 | 135 | -121.4270849 | 1.639371458 | -1.667817681 | 121.4270849 | 24.28541699 | 1.639371458 | -1.667817681 | 121.4270849 | -23.02108057 | 1.394169208 | -1.913019931 | 115.1054028 | 0 | 1.152723176 | -2.154465963 | 107.1524377 | 20.92472706 | 1.085250908 | -2.221938231 | 104.6236353 | |||||||||||||||||||
38 | 495 | 144 | 36 | 180 | 118.8 | 180 | 0 | 82.52475632 | 37.47524368 | 142.5 | -128.5542053 | 1.655719849 | -1.65146929 | 128.5542053 | 25.71084105 | 1.655719849 | -1.65146929 | 128.5542053 | -24.40048402 | 1.410517599 | -1.89667154 | 122.0024201 | 0 | 1.169071567 | -2.138117572 | 113.7312167 | 22.2190919 | 1.101599299 | -2.20558984 | 111.0954595 | |||||||||||||||||||
39 | This model illustrates the difference between the stated valuation of a company and the actual implied valuation derived when factoring in the added protections given to investors. | 510 | 144 | 36 | 180 | 122.4 | 180 | 0 | 80.81950192 | 39.18049808 | 150 | -135.693427 | 1.671229483 | -1.635959656 | 135.693427 | 27.1386854 | 1.671229483 | -1.635959656 | 135.693427 | -25.78341198 | 1.426027233 | -1.881161905 | 128.9170599 | 0 | 1.184581201 | -2.122607938 | 120.3340552 | 23.51865166 | 1.117108933 | -2.190080206 | 117.5932583 | ||||||||||||||||||
40 | 525 | 144 | 36 | 180 | 126 | 180 | 0 | 79.12163419 | 40.87836581 | 157.5 | -142.8438514 | 1.685982242 | -1.621206897 | 142.8438514 | 28.56877028 | 1.685982242 | -1.621206897 | 142.8438514 | -27.16961515 | 1.440779992 | -1.866409146 | 135.8480757 | 0 | 1.19933396 | -2.107855179 | 126.9593355 | 24.82306209 | 1.131861692 | -2.175327447 | 124.1153105 | |||||||||||||||||||
41 | 540 | 144 | 36 | 180 | 129.6 | 180 | 0 | 77.43060285 | 42.56939715 | 165 | -150.0046834 | 1.700048572 | -1.607140566 | 150.0046834 | 30.00093667 | 1.700048572 | -1.607140566 | 150.0046834 | -28.5588721 | 1.454846323 | -1.852342816 | 142.7943605 | 0 | 1.213400291 | -2.093788848 | 133.605615 | 26.13201595 | 1.145928023 | -2.161261116 | 130.6600798 | |||||||||||||||||||
42 | 555 | 144 | 36 | 180 | 133.2 | 180 | 0 | 75.74591985 | 44.25408015 | 172.5 | -157.1752154 | 1.713489522 | -1.593699617 | 157.1752154 | 31.43504309 | 1.713489522 | -1.593699617 | 157.1752154 | -29.95098511 | 1.468287273 | -1.838901866 | 149.7549255 | 0 | 1.22684124 | -2.080347899 | 140.2716011 | 27.4452376 | 1.159368972 | -2.147820167 | 137.226188 | |||||||||||||||||||
43 | 570 | 144 | 36 | 180 | 136.8 | 180 | 0 | 74.06715014 | 45.93284986 | 180 | -164.3548149 | 1.72635834 | -1.580830799 | 164.3548149 | 32.87096299 | 1.72635834 | -1.580830799 | 164.3548149 | -31.34577672 | 1.48115609 | -1.826033048 | 156.7288836 | 0 | 1.239710058 | -2.067479081 | 146.9561295 | 28.76247854 | 1.17223779 | -2.134951349 | 143.8123927 | |||||||||||||||||||
44 | 585 | 144 | 36 | 180 | 140.4 | 180 | 0 | 72.39390396 | 47.60609604 | 187.5 | -171.5429135 | 1.738701751 | -1.568487388 | 171.5429135 | 34.3085827 | 1.738701751 | -1.568487388 | 171.5429135 | -32.74308697 | 1.493499501 | -1.813689638 | 163.7154349 | 0 | 1.252053469 | -2.05513567 | 153.6581472 | 30.08351381 | 1.184581201 | -2.122607938 | 150.417569 | |||||||||||||||||||
45 | 600 | 144 | 36 | 180 | 144 | 180 | 0 | 70.72583067 | 49.27416933 | 195 | -178.7389982 | 1.75056098 | -1.556628159 | 178.7389982 | 35.74779963 | 1.75056098 | -1.556628159 | 178.7389982 | -34.14277104 | 1.50535873 | -1.801830409 | 170.7138552 | 0 | 1.263912698 | -2.043276441 | 160.3766977 | 31.40813891 | 1.19644043 | -2.110748709 | 157.0406945 | |||||||||||||||||||
46 | 615 | 144 | 36 | 180 | 147.6 | 180 | 0 | 69.06261347 | 50.93738653 | 202.5 | -185.9426043 | 1.761972582 | -1.545216557 | 185.9426043 | 37.18852086 | 1.761972582 | -1.545216557 | 185.9426043 | -35.54469733 | 1.516770333 | -1.790418806 | 177.7234866 | 0 | 1.2753243 | -2.031864839 | 167.1109094 | 32.73616728 | 1.207852033 | -2.099337106 | 163.6808364 | |||||||||||||||||||
47 | 630 | 144 | 36 | 180 | 151.2 | 180 | 0 | 67.40396513 | 52.59603487 | 210 | -193.1533093 | 1.772969124 | -1.534220015 | 193.1533093 | 38.63066187 | 1.772969124 | -1.534220015 | 193.1533093 | -36.9487458 | 1.527766875 | -1.779422264 | 184.743729 | 0 | 1.286320842 | -2.020868297 | 173.8599848 | 34.06742814 | 1.218848574 | -2.088340564 | 170.3371407 | |||||||||||||||||||
48 | 645 | 144 | 36 | 180 | 154.8 | 180 | 0 | 65.74962426 | 54.25037574 | 217.5 | -200.3707278 | 1.783579742 | -1.523609397 | 200.3707278 | 40.07414557 | 1.783579742 | -1.523609397 | 200.3707278 | -38.35480665 | 1.538377493 | -1.768811646 | 191.7740333 | 0 | 1.29693146 | -2.010257679 | 180.6231924 | 35.40176466 | 1.229459192 | -2.077729947 | 177.0088233 | |||||||||||||||||||
49 | 660 | 144 | 36 | 180 | 158.4 | 180 | 0 | 64.09935225 | 55.90064775 | 225 | -207.5945069 | 1.793830608 | -1.513358531 | 207.5945069 | 41.51890139 | 1.793830608 | -1.513358531 | 207.5945069 | -39.76277909 | 1.548628358 | -1.758560781 | 198.8138955 | 0 | 1.307182326 | -2.000006813 | 187.3998587 | 36.73903239 | 1.239710058 | -2.067479081 | 183.6951619 | |||||||||||||||||||
50 | 675 | 144 | 36 | 180 | 162 | 180 | 0 | 62.45293065 | 57.54706935 | 232.5 | -214.8243228 | 1.803745318 | -1.503443821 | 214.8243228 | 42.96486456 | 1.803745318 | -1.503443821 | 214.8243228 | -41.17257035 | 1.558543069 | -1.74864607 | 205.8628518 | 0 | 1.317097036 | -1.990092103 | 194.1893623 | 38.07909793 | 1.249624768 | -2.05756437 | 190.3954896 | |||||||||||||||||||
51 | 690 | 144 | 36 | 180 | 165.6 | 180 | 0 | 60.81015884 | 59.18984116 | 240 | -222.0598772 | 1.813345222 | -1.493843917 | 222.0598772 | 44.41197545 | 1.813345222 | -1.493843917 | 222.0598772 | -42.58409482 | 1.568142973 | -1.739046166 | 212.9204741 | 0 | 1.32669694 | -1.980492199 | 200.9911285 | 39.42183778 | 1.259224672 | -2.047964466 | 197.1091889 | |||||||||||||||||||
52 | 705 | 144 | 36 | 180 | 169.2 | 180 | 0 | 59.17085214 | 60.82914786 | 247.5 | -229.3008952 | 1.822649697 | -1.484539442 | 229.3008952 | 45.86017904 | 1.822649697 | -1.484539442 | 229.3008952 | -43.99727329 | 1.577447448 | -1.729741691 | 219.9863665 | 0 | 1.336001415 | -1.971187724 | 207.804624 | 40.76713732 | 1.268529147 | -2.038659991 | 203.8356866 | |||||||||||||||||||
53 | 720 | 144 | 36 | 180 | 172.8 | 180 | 0 | 57.53484013 | 62.46515987 | 255 | -236.5471222 | 1.831676385 | -1.475512754 | 236.5471222 | 47.30942443 | 1.831676385 | -1.475512754 | 236.5471222 | -45.41203233 | 1.586474135 | -1.720715004 | 227.0601616 | 0 | 1.345028103 | -1.962161036 | 214.6293531 | 42.11488992 | 1.277555835 | -2.029633304 | 210.5744496 | |||||||||||||||||||
54 | 735 | 144 | 36 | 180 | 176.4 | 180 | 0 | 55.90196512 | 64.09803488 | 262.5 | -243.7983221 | 1.840441392 | -1.466747747 | 243.7983221 | 48.75966442 | 1.840441392 | -1.466747747 | 243.7983221 | -46.82830366 | 1.595239143 | -1.711949996 | 234.1415183 | 0 | 1.35379311 | -1.953396029 | 221.4648542 | 43.46499621 | 1.286320842 | -2.020868297 | 217.324981 | |||||||||||||||||||
55 | 750 | 144 | 36 | 180 | 180 | 180 | 1.50x | 0 | 54.27208095 | 65.72791905 | 270 | -251.0542757 | 1.848959465 | -1.458229674 | 251.0542757 | 50.21085514 | 1.848959465 | -1.458229674 | 251.0542757 | -48.24602372 | 1.603757215 | -1.703431924 | 241.2301186 | 0 | 1.362311183 | -1.944877956 | 228.3106964 | 44.81736335 | 1.294838915 | -2.012350224 | 224.0868167 | ||||||||||||||||||
56 | 765 | 144 | 36 | 180 | 183.6 | 183.6 | 0.24 | 52.64505182 | 67.35494818 | 277.5 | -258.3147789 | 1.857244136 | -1.449945003 | 258.3147789 | 51.66295578 | 1.857244136 | -1.449945003 | 258.3147789 | -49.66513319 | 1.612041886 | -1.695147253 | 248.3256659 | 0 | 1.370595854 | -1.936593285 | 235.1664765 | 46.17190449 | 1.303123586 | -2.004065553 | 230.8595224 | |||||||||||||||||||
57 | 780 | 144 | 36 | 180 | 187.2 | 187.2 | 0.24 | 51.02075134 | 68.97924866 | 285 | -265.5796412 | 1.865307856 | -1.441881283 | 265.5796412 | 53.11592824 | 1.865307856 | -1.441881283 | 265.5796412 | -51.08557661 | 1.620105606 | -1.687083533 | 255.427883 | 0 | 1.378659574 | -1.928529565 | 242.0318172 | 47.52853821 | 1.311187306 | -1.996001833 | 237.642691 | |||||||||||||||||||
58 | 795 | 144 | 36 | 180 | 190.8 | 190.8 | 0.24 | 49.39906163 | 70.60093837 | 292.5 | -272.8486846 | 1.873162104 | -1.434027034 | 272.8486846 | 54.56973691 | 1.873162104 | -1.434027034 | 272.8486846 | -52.50730204 | 1.627959855 | -1.679229284 | 262.5365102 | 0 | 1.386513823 | -1.920675316 | 248.9063641 | 48.88718805 | 1.319041555 | -1.988147584 | 244.4359403 | |||||||||||||||||||
59 | 810 | 144 | 36 | 180 | 194.4 | 194.4 | 0.24 | 47.77987257 | 72.22012743 | 300 | -280.1217424 | 1.88081749 | -1.426371649 | 280.1217424 | 56.02434848 | 1.88081749 | -1.426371649 | 280.1217424 | -53.93026078 | 1.635615241 | -1.671573898 | 269.6513039 | 0 | 1.394169208 | -1.913019931 | 255.7897841 | 50.24778213 | 1.32669694 | -1.980492199 | 251.2389106 | |||||||||||||||||||
60 | 825 | 144 | 36 | 180 | 198 | 198 | 0.24 | 46.16308112 | 73.83691888 | 307.5 | -287.3986585 | 1.888283834 | -1.418905305 | 287.3986585 | 57.4797317 | 1.888283834 | -1.418905305 | 287.3986585 | -55.35440704 | 1.643081585 | -1.664107554 | 276.7720352 | 0 | 1.401635552 | -1.905553587 | 262.6817638 | 51.61025271 | 1.334163284 | -1.973025854 | 258.0512636 | |||||||||||||||||||
61 | 840 | 144 | 36 | 180 | 201.6 | 201.6 | 0.24 | 44.5485907 | 75.4514093 | 315 | -294.6792861 | 1.895570249 | -1.41161889 | 294.6792861 | 58.93585721 | 1.895570249 | -1.41161889 | 294.6792861 | -56.77969777 | 1.650368 | -1.656821139 | 283.8984888 | 0 | 1.408921967 | -1.898267172 | 269.5820076 | 52.97453592 | 1.341449699 | -1.96573944 | 264.8726796 | |||||||||||||||||||
62 | 855 | 144 | 36 | 180 | 205.2 | 205.2 | 0.24 | 42.93631067 | 77.06368933 | 322.5 | -301.9634872 | 1.902685203 | -1.404503936 | 301.9634872 | 60.39269743 | 1.902685203 | -1.404503936 | 301.9634872 | -58.20609237 | 1.657482953 | -1.649706186 | 291.0304619 | 0 | 1.416036921 | -1.891152218 | 276.4902366 | 54.34057143 | 1.348564653 | -1.958624486 | 271.7028571 | |||||||||||||||||||
63 | 870 | 144 | 36 | 180 | 208.8 | 208.8 | 0.24 | 41.32615581 | 78.67384419 | 330 | -309.2511318 | 1.90963658 | -1.397552559 | 309.2511318 | 61.85022635 | 1.90963658 | -1.397552559 | 309.2511318 | -59.63355256 | 1.66443433 | -1.642754809 | 298.1677628 | 0 | 1.422988298 | -1.884200841 | 283.4061869 | 55.70830216 | 1.35551603 | -1.951673109 | 278.5415108 | |||||||||||||||||||
64 | 885 | 144 | 36 | 180 | 212.4 | 212.4 | 0.24 | 39.71804591 | 80.28195409 | 337.5 | -316.5420973 | 1.916431732 | -1.390757406 | 316.5420973 | 63.30841946 | 1.916431732 | -1.390757406 | 316.5420973 | -61.06204215 | 1.671229483 | -1.635959656 | 305.3102108 | 0 | 1.42978345 | -1.877405688 | 290.329609 | 57.07767409 | 1.362311183 | -1.944877956 | 285.3883704 | |||||||||||||||||||
65 | 900 | 144 | 36 | 180 | 216 | 216 | 0.24 | 38.11190536 | 81.88809464 | 345 | -323.836268 | 1.923077529 | -1.38411161 | 323.836268 | 64.7672536 | 1.923077529 | -1.38411161 | 323.836268 | -62.49152692 | 1.67787528 | -1.629313859 | 312.4576346 | 0 | 1.436429247 | -1.870759892 | 297.2602663 | 58.44863598 | 1.368956979 | -1.938232159 | 292.2431799 | |||||||||||||||||||
66 | 915 | 144 | 36 | 180 | 219.6 | 219.6 | 0.24 | 36.50766283 | 83.49233717 | 352.5 | -331.1335345 | 1.929580394 | -1.377608744 | 331.1335345 | 66.22670689 | 1.929580394 | -1.377608744 | 331.1335345 | -63.92197446 | 1.684378145 | -1.622810994 | 319.6098723 | 0 | 1.442932112 | -1.864257026 | 304.1979344 | 59.82113921 | 1.375459845 | -1.931729294 | 299.105696 | |||||||||||||||||||
67 | 930 | 144 | 36 | 180 | 223.2 | 223.2 | 0.24 | 34.90525089 | 85.09474911 | 360 | -338.433793 | 1.935946347 | -1.371242792 | 338.433793 | 67.68675861 | 1.935946347 | -1.371242792 | 338.433793 | -65.35335403 | 1.690744097 | -1.616445041 | 326.7667701 | 0 | 1.449298065 | -1.857891074 | 311.1424001 | 61.19513757 | 1.381825797 | -1.925363342 | 305.9756879 | |||||||||||||||||||
68 | 945 | 144 | 36 | 180 | 226.8 | 226.8 | 0.24 | 33.30460578 | 86.69539422 | 367.5 | -345.7369456 | 1.942181033 | -1.365008105 | 345.7369456 | 69.14738911 | 1.942181033 | -1.365008105 | 345.7369456 | -66.78563645 | 1.696978784 | -1.610210355 | 333.9281823 | 0 | 1.455532751 | -1.851656387 | 318.0934608 | 62.57058713 | 1.388060484 | -1.919128655 | 312.8529356 | |||||||||||||||||||
69 | 960 | 144 | 36 | 180 | 230.4 | 230.4 | 0.24 | 31.7056671 | 88.2943329 | 375 | -353.0428989 | 1.948289758 | -1.358899381 | 353.0428989 | 70.60857978 | 1.948289758 | -1.358899381 | 353.0428989 | -68.21879401 | 1.703087508 | -1.60410163 | 341.0939701 | 0 | 1.461641476 | -1.845547663 | 325.0509236 | 63.94744602 | 1.394169208 | -1.913019931 | 319.7372301 | |||||||||||||||||||
70 | 975 | 144 | 36 | 180 | 234 | 234 | 0.24 | 30.10837761 | 89.89162239 | 382.5 | -360.3515646 | 1.95427751 | -1.352911629 | 360.3515646 | 72.07031291 | 1.95427751 | -1.352911629 | 360.3515646 | -69.65280034 | 1.70907526 | -1.598113879 | 348.2640017 | 0 | 1.467629228 | -1.839559911 | 332.0146049 | 65.32567438 | 1.40015696 | -1.907032179 | 326.6283719 | |||||||||||||||||||
71 | 990 | 144 | 36 | 180 | 237.6 | 237.6 | 0.24 | 28.51268298 | 91.48731702 | 390 | -367.6628585 | 1.960148987 | -1.347040152 | 367.6628585 | 73.5325717 | 1.960148987 | -1.347040152 | 367.6628585 | -71.08763033 | 1.714946737 | -1.592242402 | 355.4381517 | 0 | 1.473500705 | -1.833688434 | 338.9843294 | 66.70523415 | 1.406028437 | -1.901160702 | 333.5261708 | |||||||||||||||||||
72 | 1005 | 144 | 36 | 180 | 241.2 | 241.2 | 0.24 | 26.9185316 | 93.0814684 | 397.5 | -374.9767007 | 1.96590862 | -1.341280519 | 374.9767007 | 74.99534014 | 1.96590862 | -1.341280519 | 374.9767007 | -72.52326007 | 1.72070637 | -1.586482769 | 362.6163003 | 0 | 1.479260338 | -1.827928801 | 345.9599299 | 68.08608902 | 1.41178807 | -1.895401069 | 340.4304451 | |||||||||||||||||||
73 | 1020 | 144 | 36 | 180 | 244.8 | 244.8 | 0.24 | 25.32587441 | 94.67412559 | 405 | -382.293015 | 1.971560589 | -1.33562855 | 382.293015 | 76.45860299 | 1.971560589 | -1.33562855 | 382.293015 | -73.95966672 | 1.72635834 | -1.580830799 | 369.7983336 | 0 | 1.484912307 | -1.822276831 | 352.9412467 | 69.46820428 | 1.41744004 | -1.889749099 | 347.3410214 | |||||||||||||||||||
74 | 1035 | 144 | 36 | 180 | 248.4 | 248.4 | 0.24 | 23.7346647 | 96.2653353 | 412.5 | -389.6117286 | 1.977108847 | -1.330080291 | 389.6117286 | 77.92234573 | 1.977108847 | -1.330080291 | 389.6117286 | -75.39682852 | 1.731906598 | -1.575282541 | 376.9841426 | 0 | 1.490460565 | -1.816728573 | 359.9281272 | 70.85154673 | 1.422988298 | -1.884200841 | 354.2577337 | |||||||||||||||||||
75 | 1050 | 144 | 36 | 180 | 252 | 252 | 0.24 | 22.144858 | 97.855142 | 420 | -396.9327724 | 1.982557131 | -1.324632008 | 396.9327724 | 79.38655449 | 1.982557131 | -1.324632008 | 396.9327724 | -76.83472465 | 1.737354882 | -1.569834257 | 384.1736233 | 0 | 1.495908849 | -1.811280289 | 366.9204253 | 72.2360846 | 1.428436582 | -1.878752557 | 361.180423 | |||||||||||||||||||
76 | 1065 | 144 | 36 | 180 | 255.6 | 255.6 | 0.24 | 20.55641191 | 99.44358809 | 427.5 | -404.2560802 | 1.98790898 | -1.319280158 | 404.2560802 | 80.85121604 | 1.98790898 | -1.319280158 | 404.2560802 | -78.27333521 | 1.742706731 | -1.564482408 | 391.3666761 | 0 | 1.501260698 | -1.80592844 | 373.918001 | 73.62178745 | 1.433788431 | -1.873400708 | 368.1089372 | |||||||||||||||||||
77 | 1080 | 144 | 36 | 180 | 259.2 | 259.2 | 0.24 | 18.96928597 | 101.030714 | 435 | -411.5815886 | 1.993167749 | -1.31402139 | 411.5815886 | 82.31631773 | 1.993167749 | -1.31402139 | 411.5815886 | -79.71264116 | 1.7479655 | -1.559223639 | 398.5632058 | 0 | 1.506519467 | -1.800669672 | 380.9207204 | 75.0086261 | 1.439047199 | -1.86814194 | 375.0431305 | |||||||||||||||||||
78 | 1095 | 144 | 36 | 180 | 262.8 | 262.8 | 0.24 | 17.38344156 | 102.6165584 | 442.5 | -418.9092374 | 1.99833662 | -1.308852519 | 418.9092374 | 83.78184747 | 1.99833662 | -1.308852519 | 418.9092374 | -81.15262426 | 1.75313437 | -1.554054768 | 405.7631213 | 0 | 1.511688338 | -1.795500801 | 387.928455 | 76.39657258 | 1.44421607 | -1.862973069 | 381.9828629 | |||||||||||||||||||
79 | 1110 | 144 | 36 | 180 | 266.4 | 266.4 | 0.24 | 15.79884177 | 104.2011582 | 450 | -426.2389684 | 2.003418615 | -1.303770524 | 426.2389684 | 85.24779369 | 2.003418615 | -1.303770524 | 426.2389684 | -82.59326704 | 1.758216365 | -1.548972774 | 412.9663352 | 0 | 1.516770333 | -1.790418806 | 394.9410814 | 77.78560002 | 1.449298065 | -1.857891074 | 388.9280001 | |||||||||||||||||||
80 | 1125 | 144 | 36 | 180 | 270 | 270 | 2.25x | 0.24 | 14.21545129 | 105.7845487 | 457.5 | -433.5707265 | 2.008416606 | -1.298772533 | 433.5707265 | 86.71414529 | 2.008416606 | -1.298772533 | 433.5707265 | -84.03455274 | 1.763214356 | -1.543974782 | 420.1727637 | 0 | 1.521768324 | -1.785420815 | 401.9584812 | 79.17568261 | 1.454296056 | -1.852893083 | 395.8784131 | ||||||||||||||||||
81 | 1140 | 144 | 36 | 180 | 273.6 | 273.6 | 0.24 | 12.63323637 | 107.3667636 | 465 | -440.9044583 | 2.013333325 | -1.293855814 | 440.9044583 | 88.18089166 | 2.013333325 | -1.293855814 | 440.9044583 | -85.47646527 | 1.768131076 | -1.539058063 | 427.3823264 | 0 | 1.526685043 | -1.780504096 | 408.9805407 | 80.56679555 | 1.459212775 | -1.847976363 | 402.8339777 | |||||||||||||||||||
82 | 1155 | 144 | 36 | 180 | 277.2 | 277.2 | 0.24 | 11.05216464 | 108.9478354 | 472.5 | -448.240113 | 2.018171374 | -1.289017765 | 448.240113 | 89.6480226 | 2.018171374 | -1.289017765 | 448.240113 | -86.9189892 | 1.772969124 | -1.534220015 | 434.594946 | 0 | 1.531523092 | -1.775666047 | 416.0071504 | 81.95891498 | 1.464050824 | -1.843138315 | 409.7945749 | |||||||||||||||||||
83 | 1170 | 144 | 36 | 180 | 280.8 | 280.8 | 0.24 | 9.472205112 | 110.5277949 | 480 | -455.5776417 | 2.022933229 | -1.28425591 | 455.5776417 | 91.11552834 | 2.022933229 | -1.28425591 | 455.5776417 | -88.36210969 | 1.77773098 | -1.529458159 | 441.8105484 | 0 | 1.536284947 | -1.770904192 | 423.038205 | 83.35201795 | 1.468812679 | -1.838376459 | 416.7600897 | |||||||||||||||||||
84 | 1185 | 144 | 36 | 180 | 284.4 | 284.4 | 0.24 | 7.893328075 | 112.1066719 | 487.5 | -462.9169974 | 2.027621255 | -1.279567884 | 462.9169974 | 92.58339949 | 2.027621255 | -1.279567884 | 462.9169974 | -89.80581246 | 1.782419005 | -1.524770134 | 449.0290623 | 0 | 1.540972973 | -1.766216166 | 430.0736034 | 84.74608234 | 1.473500705 | -1.833688434 | 423.7304117 | |||||||||||||||||||
85 | 1200 | 144 | 36 | 180 | 288 | 288 | 0.24 | 6.315505011 | 113.684495 | 495 | -470.2581351 | 2.032237704 | -1.274951435 | 470.2581351 | 94.05162702 | 2.032237704 | -1.274951435 | 470.2581351 | -91.25008381 | 1.787035455 | -1.520153684 | 456.250419 | 0 | 1.545589422 | -1.761599717 | 437.1132479 | 86.14108687 | 1.478117154 | -1.829071984 | 430.7054343 | |||||||||||||||||||
86 | 1215 | 144 | 36 | 180 | 291.6 | 291.6 | 0.24 | 4.738708545 | 115.2612915 | 502.5 | -477.6010113 | 2.036784731 | -1.270404408 | 477.6010113 | 95.52020226 | 2.036784731 | -1.270404408 | 477.6010113 | -92.69491051 | 1.791582482 | -1.515606657 | 463.4745525 | 0 | 1.550136449 | -1.75705269 | 444.1570444 | 87.53701099 | 1.482664181 | -1.824524958 | 437.6850549 | |||||||||||||||||||
87 | 1230 | 144 | 36 | 180 | 295.2 | 295.2 | 0.24 | 3.162912381 | 116.8370876 | 510 | -484.9455843 | 2.041264392 | -1.265924747 | 484.9455843 | 96.98911686 | 2.041264392 | -1.265924747 | 484.9455843 | -94.14027984 | 1.796062142 | -1.511126996 | 470.7013992 | 0 | 1.55461611 | -1.752573029 | 451.2049024 | 88.9338349 | 1.487143842 | -1.820045297 | 444.6691745 | |||||||||||||||||||
88 | 1245 | 144 | 36 | 180 | 298.8 | 298.8 | 0.24 | 1.588091243 | 118.4119088 | 517.5 | -492.291814 | 2.045678654 | -1.261510485 | 492.291814 | 98.4583628 | 2.045678654 | -1.261510485 | 492.291814 | -95.58617954 | 1.800476404 | -1.506712734 | 477.9308977 | 0 | 1.559030372 | -1.748158767 | 458.2567344 | 90.33153949 | 1.491558104 | -1.815631035 | 451.6576975 | |||||||||||||||||||
89 | 1260 | 144 | 36 | 180 | 302.4 | 302.4 | 0.24 | 0.01422082486 | 119.9857792 | 525 | -499.6396617 | 2.050029399 | -1.25715974 | 499.6396617 | 99.92793233 | 2.050029399 | -1.25715974 | 499.6396617 | -97.0325978 | 1.80482715 | -1.502361989 | 485.162989 | 0 | 1.563381117 | -1.743808022 | 465.3124558 | 91.73010631 | 1.495908849 | -1.811280289 | 458.6505316 | |||||||||||||||||||
90 | 1275 | 144 | 36 | 180 | 306 | 306 | 0.24 | 1.558722263 | 121.5587223 | 532.5 | -506.9890901 | 2.05431843 | -1.252870709 | 506.9890901 | 101.397818 | 2.05431843 | -1.252870709 | 506.9890901 | -98.47952321 | 1.80911618 | -1.498072959 | 492.397616 | 0 | 1.567670148 | -1.739518991 | 472.3719853 | 93.12951754 | 1.50019788 | -1.806991259 | 465.6475877 | |||||||||||||||||||
91 | 1290 | 144 | 36 | 180 | 309.6 | 309.6 | 0.24 | 3.130760538 | 123.1307605 | 540 | -514.3400633 | 2.058547472 | -1.248641667 | 514.3400633 | 102.8680127 | 2.058547472 | -1.248641667 | 514.3400633 | -99.92694476 | 1.813345222 | -1.493843917 | 499.6347238 | 0 | 1.57189919 | -1.735289949 | 479.435244 | 94.52975594 | 1.504426922 | -1.802762217 | 472.6487797 | |||||||||||||||||||
92 | 1305 | 144 | 36 | 180 | 313.2 | 313.2 | 0.24 | 4.701915688 | 124.7019157 | 547.5 | -521.6925467 | 2.06271818 | -1.244470959 | 521.6925467 | 104.3385093 | 2.06271818 | -1.244470959 | 521.6925467 | -101.3748518 | 1.817515931 | -1.489673208 | 506.8742592 | 0 | 1.576069898 | -1.731119241 | 486.5021559 | 95.93080486 | 1.50859763 | -1.798591508 | 479.6540243 | |||||||||||||||||||
93 | 1320 | 144 | 36 | 180 | 316.8 | 316.8 | 0.24 | 6.272208614 | 126.2722086 | 555 | -529.0465068 | 2.066832143 | -1.240356996 | 529.0465068 | 105.8093014 | 2.066832143 | -1.240356996 | 529.0465068 | -102.8232342 | 1.821629893 | -1.485559246 | 514.1161709 | 0 | 1.580183861 | -1.727005278 | 493.5726472 | 97.3326482 | 1.512711593 | -1.794477546 | 486.663241 | |||||||||||||||||||
94 | 1335 | 144 | 36 | 180 | 320.4 | 320.4 | 0.24 | 7.841659468 | 127.8416595 | 562.5 | -536.4019113 | 2.070890883 | -1.236298256 | 536.4019113 | 107.2803823 | 2.070890883 | -1.236298256 | 536.4019113 | -104.2720818 | 1.825688633 | -1.481500506 | 521.3604092 | 0 | 1.584242601 | -1.722946538 | 500.6466468 | 98.73527035 | 1.516770333 | -1.790418806 | 493.6763518 | |||||||||||||||||||
95 | 1350 | 144 | 36 | 180 | 324 | 324 | 0.24 | 9.41028769 | 129.4102877 | 570 | -543.7587291 | 2.074895863 | -1.232293276 | 543.7587291 | 108.7517458 | 2.074895863 | -1.232293276 | 543.7587291 | -105.7213853 | 1.829693613 | -1.477495526 | 528.6069263 | 0 | 1.588247581 | -1.718941558 | 507.7240857 | 100.1386562 | 1.520775313 | -1.786413826 | 500.6932811 | |||||||||||||||||||
96 | 1365 | 144 | 36 | 180 | 327.6 | 327.6 | 0.24 | 10.97811204 | 130.978112 | 577.5 | -551.11693 | 2.078848489 | -1.22834065 | 551.11693 | 110.223386 | 2.078848489 | -1.22834065 | 551.11693 | -107.1711352 | 1.833646239 | -1.4735429 | 535.8556758 | 0 | 1.592200207 | -1.714988932 | 514.8048971 | 101.5427912 | 1.524727939 | -1.7824612 | 507.713956 | |||||||||||||||||||
97 | 1380 | 144 | 36 | 180 | 331.2 | 331.2 | 0.24 | 12.54515062 | 132.5451506 | 585 | -558.476485 | 2.082750112 | -1.224439027 | 558.476485 | 111.695297 | 2.082750112 | -1.224439027 | 558.476485 | -108.6213225 | 1.837547862 | -1.469641277 | 543.1066127 | 0 | 1.59610183 | -1.711087309 | 521.8890165 | 102.9476611 | 1.528629562 | -1.778559577 | 514.7383056 | |||||||||||||||||||
98 | 1395 | 144 | 36 | 180 | 334.8 | 334.8 | 0.24 | 14.11142094 | 134.1114209 | 592.5 | -565.8373657 | 2.086602031 | -1.220587108 | 565.8373657 | 113.1674731 | 2.086602031 | -1.220587108 | 565.8373657 | -110.0719387 | 1.841399781 | -1.465789357 | 550.3596936 | 0 | 1.599953749 | -1.70723539 | 528.9763811 | 104.3532522 | 1.532481481 | -1.774707658 | 521.7662612 | |||||||||||||||||||
99 | 1410 | 144 | 36 | 180 | 338.4 | 338.4 | 0.24 | 15.6769399 | 135.6769399 | 600 | -573.1995451 | 2.090405497 | -1.216783642 | 573.1995451 | 114.639909 | 2.090405497 | -1.216783642 | 573.1995451 | -111.5229753 | 1.845203248 | -1.461985891 | 557.6148764 | 0 | 1.603757215 | -1.703431924 | 536.0669302 | 105.7595513 | 1.536284947 | -1.770904192 | 528.7977563 | |||||||||||||||||||
100 | 1425 | 144 | 36 | 180 | 342 | 342 | 0.24 | 17.24172384 | 137.2417238 | 607.5 | -580.5629967 | 2.094161714 | -1.213027425 | 580.5629967 | 116.1125993 | 2.094161714 | -1.213027425 | 580.5629967 | -112.9744241 | 1.848959465 | -1.458229674 | 564.8721204 | 0 | 1.607513432 | -1.699675707 | 543.1606049 | 107.1665452 | 1.540041164 | -1.767147975 | 535.8327262 | |||||||||||||||||||