Spreadsheet: 31e5fd9c-12fc-4cfa-9f5e-a8a517bc153f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
 | Grazing Economic Analysis
 | SITE AND LOCATION CHARACTERISTICS |  | % Change in Carrying Capacity: |  |  | 4500 |  |  | AUMs | AUMs | AUMs | CHANGE | CHANGE | AMORTIZED | TOTAL | CHANGE | ACCUMLATE |  | GRAPH DATA
 | Cooperator/Ranch Name: | Rocking Raindrop Ranch |  | Before | After | Other |  |  | Before | After | [NAME] | IN | IN GROSS | TREATMENT | ANNUAL | IN NET | CHANGE |  |  | Total AUMs | Total AUMs | [NAME] | Total AUs | Total AUs | [NAME] AUs |  | Life: |  |  | 25
 | County and State: | Wasco, Oregon | Year | Treatment | Treatment | Costs/Ac |  |  | Treatment | Treatment | Usuable | AUM/AC | VALUE | COST | COSTS | VALUE | IN NV | BREAKEVEN | Year | Before | After | Forage | Before | After | Usable |  | ($/Yr Income) / (Total Cost): |  |  | 0.0748621659634318
 | Soil/Site Description: | [NAME] | 1 | -0.02 | 0 | 5 |  |  | 1.283924050632911 | 1.424050632911392 | 1.424050632911392 | 0.140126582278481 | 2.382151898734176 | 5.867003865920549 | 10.86700386592055 | -8.484851967186373 | -8.484851967186373 | 100 | 1 | 821.7113924050634 | 911.3924050632911 | 1120 | 136.9518987341772 | 151.8987341772152 | 186.6666666666667 |  | Internal Rate of Return: |  |  | 6
 | Apparent Trend (up, down): | Down | 2 | -0.04 | 0.1 | 3 |  |  | 1.257721518987342 | 1.566455696202532 | 1.566455696202532 | 0.3087341772151899 | 5.248481012658228 | 5.867003865920549 | 8.867003865920548 | -3.61852285326232 | -12.10337482044869 | 100 | 2 | 804.9417721518988 | 1002.53164556962 | 1120 | 134.1569620253165 | 167.0886075949367 | 186.6666666666667
 |  |  | 3 | -0.06 | 0.2 | 0 |  |  | 1.231518987341772 | 1.708860759493671 | 1.708860759493671 | 0.4773417721518987 | 8.114810126582277 | 5.867003865920549 | 5.867003865920549 | 2.247806260661728 | -9.855568559786963 | 100 | 3 | 788.1721518987342 | 1093.670886075949 | 1120 | 131.3620253164557 | 182.2784810126582 | 186.6666666666667 |  | Interest
 | EVALUATION CRITERIA |  | 4 | -0.08 | 0.3 | 0 |  |  | 1.205316455696203 | 1.85126582278481 | 1.75 | 0.5446835443037974 | 9.259620253164556 | 5.867003865920549 | 5.867003865920549 | 3.392616387244007 | -6.462952172542956 | 100 | 4 | 771.4025316455696 | 1184.810126582279 | 1120 | 128.5670886075949 | 197.4683544303798 | 186.6666666666667 |  | 1 | 0.04540675340054801
 | Grazing Land Treatment: | [NAME] | 5 | -0.1 | 0.25 | 0 |  |  | 1.179113924050633 | 1.78006329113924 | 1.75 | 0.570886075949367 | 9.70506329113924 | 5.867003865920549 | 5.867003865920549 | 3.838059425218691 | -2.624892747324266 | 100 | 5 | 754.632911392405 | 1139.240506329114 | 1120 | 125.7721518987342 | 189.873417721519 | 186.6666666666667 |  | 2 | 0.05122043841739472
 | Initial Treatment Cost ($/Acre): | 75 | 6 | -0.12 | 0.2 | 0 |  |  | 1.152911392405063 | 1.708860759493671 | 1.708860759493671 | 0.5559493670886075 | 9.451139240506329 | 5.867003865920549 | 5.867003865920549 | 3.58413537458578 | 0.9592426272615144 | 6 | 6 | 737.8632911392406 | 1093.670886075949 | 1120 | 122.9772151898734 | 182.2784810126582 | 186.6666666666667 |  | 3 | 0.0574278710391278
 | Life of Treatment (Years): | 25 | 7 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 4.988821039821977 | 7 | 7 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 4 | 0.0640119627864546
 | Interest Rate (%): | 0.06 | 8 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 9.01839945238244 | 8 | 8 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 5 | 0.07095245729922962
 | Value of one AUM ($): | 17 | 9 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 13.0479778649429 | 9 | 9 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 6 | 0.07822671821227399 |  | 6
 | Total Acres Treated: | 640 | 10 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 17.07755627750336 | 10 | 10 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 7 | 0.08581051722066561 |  | 7
 |  |  | 11 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 21.10713469006382 | 11 | 11 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 8 | 0.09367877905196814 |  | 8
 | FORAGE UTILIZATION |  | 12 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 25.13671310262428 | 12 | 12 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 9 | 0.1018062505185718 |  | 9
 | Current Forage Production (Lbs/Ac) | 4500 | 13 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 29.16629151518475 | 13 | 13 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 10 | 0.1101680721900209 |  | 10
 | Pounds/AUM: | 790 | 14 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 33.19586992774521 | 14 | 14 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 11 | 0.1187402420540557 |  | 11
 | Harvest Efficiency Without Treatment: | 0.23 | 15 | -0.14 | 0.2 | 0 |  |  | 1.126708860759494 | 1.708860759493671 | 1.708860759493671 | 0.5821518987341772 | 9.896582278481011 | 5.867003865920549 | 5.867003865920549 | 4.029578412560462 | 37.22544834030567 | 15 | 15 | 721.093670886076 | 1093.670886075949 | 1120 | 120.1822784810127 | 182.2784810126582 | 186.6666666666667 |  | 12 | 0.1274999698095078 |  | 12
 | Harvest Efficiency With Treatment: | 0.25 | 16 | -0.14 | 0.19 | 0 |  |  | 1.126708860759494 | 1.694620253164557 | 1.694620253164557 | 0.5679113924050632 | 9.654493670886074 | 5.867003865920549 | 5.867003865920549 | 3.787489804965525 | 41.01293814527119 | 16 | 16 | 721.093670886076 | 1084.556962025316 | 1120 | 120.1822784810127 | 180.7594936708861 | 186.6666666666667 |  | 13 | 0.1364259276025758 |  | 13
 | Current Forage Production (AUMs/Ac): | 1.310126582278481 | 17 | -0.14 | 0.18 | 0 |  |  | 1.126708860759494 | 1.680379746835443 | 1.680379746835443 | 0.5536708860759494 | 9.41240506329114 | 5.867003865920549 | 5.867003865920549 | 3.54540119737059 | 44.55833934264178 | 17 | 17 | 721.093670886076 | 1075.443037974684 | 1120 | 120.1822784810127 | 179.2405063291139 | 186.6666666666667 |  | 14 | 0.1454984079372444 |  | 14
 | Maximum Carrying Capacity (AUMs/Ac): | 1.75 | 18 | -0.14 | 0.17 | 0 |  |  | 1.126708860759494 | 1.666139240506329 | 1.666139240506329 | 0.5394303797468354 | 9.170316455696202 | 5.867003865920549 | 5.867003865920549 | 3.303312589775653 | 47.86165193241743 | 18 | 18 | 721.093670886076 | 1066.329113924051 | 1120 | 120.1822784810127 | 177.7215189873418 | 186.6666666666667 |  | 15 | 0.1546994023202065 |  | 15
 | Months Grazed/Year | 6 | 19 | -0.14 | 0.16 | 0 |  |  | 1.126708860759494 | 1.651898734177215 | 1.651898734177215 | 0.5251898734177214 | 8.928227848101264 | 5.867003865920549 | 5.867003865920549 | 3.061223982180715 | 50.92287591459814 | 19 | 19 | 721.093670886076 | 1057.215189873418 | 1120 | 120.1822784810127 | 176.2025316455696 | 186.6666666666667 |  | 16 | 0.1640126152844691 |  | 16
 |  |  | 20 | -0.14 | 0.15 | 0 |  |  | 1.126708860759494 | 1.637658227848101 | 1.637658227848101 | 0.5109493670886076 | 8.686139240506328 | 5.867003865920549 | 5.867003865920549 | 2.819135374585779 | 53.74201128918392 | 20 | 20 | 721.093670886076 | 1048.101265822785 | 1120 | 120.1822784810127 | 174.6835443037975 | 186.6666666666667 |  | 17 | 0.1734234281966283 |  | 17
 | RESULTS OF ANALYSIS |  | 21 | -0.14 | 0.14 | 0 |  |  | 1.126708860759494 | 1.623417721518987 | 1.623417721518987 | 0.4967088607594936 | 8.444050632911392 | 5.867003865920549 | 5.867003865920549 | 2.577046766990843 | 56.31905805617476 | 21 | 21 | 721.093670886076 | 1038.987341772152 | 1120 | 120.1822784810127 | 173.1645569620253 | 186.6666666666667 |  | 18 | 0.1829188261129622 |  | 18
 | Years to Break-Even on Investment: | 6 | 22 | -0.14 | 0.13 | 0 |  |  | 1.126708860759494 | 1.609177215189873 | 1.609177215189873 | 0.4824683544303796 | 8.201962025316453 | 5.867003865920549 | 5.867003865920549 | 2.334958159395904 | 58.65401621557066 | 22 | 22 | 721.093670886076 | 1029.873417721519 | 1120 | 120.1822784810127 | 171.6455696202532 | 186.6666666666667 |  | 19 | 0.1924872992809108 |  | 19
 | Increase in Carrying Capacity (AUMs/Ac): | 0.3302742616033756 | 23 | -0.14 | 0.12 | 0 |  |  | 1.126708860759494 | 1.59493670886076 | 1.59493670886076 | 0.4682278481012658 | 7.95987341772152 | 5.867003865920549 | 5.867003865920549 | 2.092869551800971 | 60.74688576737164 | 23 | 23 | 721.093670886076 | 1020.759493670886 | 1120 | 120.1822784810127 | 170.126582278481 | 186.6666666666667 |  | 20 | 0.2021187289820536 |  | 20
 | Increase in Stocking Rate, (#Head/Total Ac): | 52.8373558368496 | 24 | -0.14 | 0.11 | 0 |  |  | 1.126708860759494 | 1.580696202531646 | 1.580696202531646 | 0.4539873417721518 | 7.717784810126581 | 5.867003865920549 | 5.867003865920549 | 1.850780944206032 | 62.59766671157767 | 24 | 24 | 721.093670886076 | 1011.645569620253 | 1120 | 120.1822784810127 | 168.6075949367089 | 186.6666666666667 |  | 21 | 0.2118042654968519 |  | 21
 | Total Installed Treatment Cost ($/Total Ac): | 48000 | 25 | -0.14 | 0.1 | 0 |  |  | 1.126708860759494 | 1.566455696202532 | 1.566455696202532 | 0.4397468354430381 | 7.475696202531647 | 5.867003865920549 | 5.867003865920549 | 1.608692336611098 | 64.20635904818876 | 25 | 25 | 721.093670886076 | 1002.53164556962 | 1120 | 120.1822784810127 | 167.0886075949367 | 186.6666666666667 |  | 22 | 0.2215362041830065 |  | 22
 | Amortized Installed Treatment Cost ($/Ac/yr): | 5.867003865920549 | 26 | -0.14 | 0.09 | 0 |  |  | 1.126708860759494 | 1.552215189873418 | 1.552215189873418 | 0.4255063291139241 | 7.233607594936709 | 0 | 0 | 7.233607594936709 | 71.43996664312547 | 26 | 26 | 721.093670886076 | 993.4177215189874 | 1120 | 120.1822784810127 | 165.5696202531646 | 186.6666666666667 |  | 23 | 0.2313078640803552 |  | 23
 | Rate of Return (%/Yr): | 0.06 | 27 | -0.14 | 0.08 | 0 |  |  | 1.126708860759494 | 1.537974683544304 | 1.537974683544304 | 0.4112658227848101 | 6.991518987341771 | 0 | 0 | 6.991518987341771 | 78.43148563046725 | 27 | 27 | 721.093670886076 | 984.3037974683544 | 1120 | 120.1822784810127 | 164.0506329113924 | 186.6666666666667 |  | 24 | 0.2411134721218967 |  | 24
 | Breakeven $/AUM: | 11.84415336056125 | 28 | -0.14 | 0.07 | 0 |  |  | 1.126708860759494 | 1.52373417721519 | 1.52373417721519 | 0.3970253164556963 | 6.749430379746837 | 0 | 0 | 6.749430379746837 | 85.18091601021409 | 28 | 28 | 721.093670886076 | 975.1898734177216 | 1120 | 120.1822784810127 | 162.5316455696203 | 186.6666666666667 |  | 25 | 0.250948054946898 |  | 25
 | Benefit/Cost Ratio: | 1.404909818766109 | 29 | -0.14 | 0.06 | 0 |  |  | 1.126708860759494 | 1.509493670886076 | 1.509493670886076 | 0.3827848101265823 | 6.507341772151898 | 0 | 0 | 6.507341772151898 | 91.688257782366 | 29 | 29 | 721.093670886076 | 966.0759493670887 | 1120 | 120.1822784810127 | 161.0126582278481 | 186.6666666666667 |  | 26 | 0.2608073394619999 |  | 26
 | Net Present Value ($/Ac): | 33.35929327445594 | 30 | -0.14 | 0.05 | 0 |  |  | 1.126708860759494 | 1.495253164556962 | 1.495253164556962 | 0.3685443037974683 | 6.26525316455696 | 0 | 0 | 6.26525316455696 | 97.95351094692296 | 30 | 30 | 721.093670886076 | 956.9620253164557 | 1120 | 120.1822784810127 | 159.4936708860759 | 186.6666666666667 |  | 27 | 0.2706876626525466 |  | 27
 |  |  |  |  |  |  |  |  |  |  | 1.640400843881857 | 0.4953502109704642 | 115.7462637265741 |  | 82.38697045211815 | 33.35929327445594 |  |  |  |  |  |  |  |  |  |  | 28 | 0.2805858906771498 |  | 28
 |  |  |  |  |  |  |  |  |  |  | (Average) | (Average) | (NPV) |  | (NPV) | (NPV) |  | 6 |  |  |  |  |  |  |  |  | 29 | 0.2904993469515912 |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Years to Break-Even |  |  |  |  |  |  |  |  | 30 | 0.3004257487136954 |  | 30
 |  |  |  |  |  |  |  |  |  | Avg. [NAME], Current (# [NAME]): |  |  |  | 122.1387341772151 |  | 0.2444038474491781 |  |  |  |  |  |  |  |  |  |  | 31 | 0.3103631514325196 |  | 31
 |  |  |  |  |  |  |  |  |  | Avg. [NAME], Improvement (# [NAME]): |  |  |  | 174.9760900140647 |  | (IRR) |  |  |  |  |  |  |  |  |  |  | 32 | 0.3203099003610397 |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 0.3302645885134441 |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 0.3402260203619716 |  | 34
 |  |  | Analysis if AUM/AC: |  |  |  |  |  | Developed By: [NAME], USDA-NRCS, Portland Oregon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 0.3501931805829627 |  | 35
 |  |  | PV Benefits W/O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 0.3601652072292028 |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 0.3701413687596952 |  | 37
 |  |  | PV Benefits W/ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 0.3801210444144341 |  | 38
 |  |  | PV Costs W/ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 0.3901037074776167 |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 0.4000889110261422 |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 0.410076275810013 |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 0.4200654799567789 |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 0.4300562502331979 |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 0.4400483546338518 |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 0.4500415960987341 |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 0.4600358071901045 |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | 0.4700308455835314 |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 0.4800265902493634 |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 0.490022938219261 |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0.5000198018482165 |  | 50