Spreadsheet: 219690d1362882305-need-to-calculate-total-months-backwards-until-it-reach-a-goal-sample
Sheet: BD Returns Analysis Input

 |  |  |  | BD Gross Revenue
Reporting Group Studio 2Yr Summary | Grand Total | Feature New Release | Catalogue | Fee Product | Video Acquired | TV
 |  | 93.7432 | 357.9942200000001 | 670.8804299999999 | 0.16111 | 39.86726
 |  | 207.62983 | 495.5804100000001 | 325.3537499999999 | 0.1565 | 139.25474
 |  | 41.42901999999999 | 2121.70303 | 320.2272100000001 | 0.17493 | 139.16671
 |  | 4609.64354 | 1426.10653 | 298.3926000000001 | 0.04488 | 431.6074
 |  | 1924.10157 | 1168.10574 | 200.06033 | 0.27888 | 1036.53551
 |  | 573.9034900000001 | 356.2110999999999 | 116.27854 | 0.22281 | 86.24292
 |  | 442.4344499999999 | 637.87179 | 189.98857 | 0.08943000000000001 | 27.62575999999999
 |  | 755.7052899999999 | 279.28159 | 70.27796000000002 | 0.25374 | 20.80089
 |  | 922.58632 | 652.5160999999998 | 58.01855 | 0.44886 | 19.51022
 |  | 1610.0786 | 1233.98281 | 167.01556 | 0.17742 | 25.8856
 |  | 246.49031 | 828.3267600000006 | 562.09842 | 0.26009 | 16.18808
 |  | 149.76335 | 379.06025 | 70.17106000000003 | 0.35816 | 12.67179
 |  | 139.56559 | 1829.561169999999 | 206.7137900000001 | 0.62498 | 47.79006
 |  | 287.80179 | 9579.626190000006 | 255.8062800000001 | 1.66899 | 289.7577700000001
 |  | 3069.24811 | 2249.94919 | 344.88724 | 5.02158 | 239.2886
 |  | 890.7111000000001 | 2165.137779999999 | 329.5271000000001 | 13.0684 | 93.69805999999998
 |  | 3823.231340000001 | 2600.33575 | 176.92874 | 1.43036 | 255.9751
 |  | 315.52373 | 678.94966 | 75.69801000000002 | 0.24332 | 101.57281
 |  | 457.92666 | 617.9016299999996 | 141.13759 | 0.59583 | 182.88754
 |  | 225.73441 | 698.88981 | 93.66027999999999 | 0.56326 | 218.31076
 |  | 674.65513 | 1213.763200000001 | 395.7769700000001 | 1.66308 | 50.88168
 |  | 1396.05778 | 1939.71277 | 229.87204 | 3.05947 | 54.16259
 |  | 656.19259 | 530.6510800000003 | 123.54954 | 0.453 | 17.79258
 |  | 770.3945099999999 | 602.5637499999997 | 129.92001 | 0 | 66.11443000000001
 |  | 185.42742 | 454.8116800000002 | 208.2056700000001 | 11.84133 | 89.56145
 |  | 1593.45713 | 818.5126099999998 | 2284.62312 | 1.46287 | 528.08275
 |  | 5333.045479999999 | 1945.391409999999 | 817.714159999999 | -1.29441 | 511.0498800000001
 |  | 1152.50411 | 1901.88696 | 1411.188010000001 | 0.49265 | 394.6530400000001
TOTAL
 |  |  |  | BD Returns Revenue
Reporting Group Studio 2Yr Summary | Grand Total | Feature New Release | Catalogue | Fee Product | Video Acquired | TV
 |  | 331.14903 | 72.82678 | 20.77568999999999 | 0.0291 | 2.94256
 |  | 35.42749 | 171.2422700000001 | 8.31861 | 0.6929599999999999 | 2.43377
 |  | 58.82188 | 108.3378 | 47.40735000000001 | 0.1194 | 18.84601
 |  | 74.81879 | 101.67826 | 71.68673000000001 | 0.14736 | 37.25776999999999
 |  | 117.80243 | 71.42054000000002 | 91.87275999999997 | 0 | 10.94595
 |  | 138.78442 | 475.9719899999999 | 78.75568 | 0.3 | 37.87721000000001
 |  | 119.1863 | 596.3504099999999 | 86.31249 | 0.255 | 167.56454
 |  | 111.48317 | 85.10067000000001 | 18.16552 | 0.14531 | 62.62260999999999
 |  | 177.40506 | 76.15315000000002 | 33.18684 | 0.01512 | 51.49219999999999
 |  | 214.46742 | 67.86073000000002 | 16.93475 | 0.04422 | 36.79571
 |  | 59.434 | 223.8865499999999 | 11.92556 | 0.00756 | 94.27614
 |  | 52.0947 | 224.1457499999999 | 37.28471 | 0 | 1.65957
 |  | 94.90009 | 124.02549 | 35.37027000000001 | 0 | 39.31941
 |  | 77.67055 | 51.88273000000002 | 12.91128 | 0 | 6.577700000000001
 |  | 44.34668 | 49.15376000000003 | 3.532239999999999 | 0 | 0.9358799999999999
 |  | 81.89261 | 116.19063 | 18.88121000000001 | 0 | 13.84884
 |  | 107.93757 | 359.43122 | 38.58732999999999 | 0.0154 | 17.58812
 |  | 84.40195999999995 | 131.01686 | 13.68339 | 0.67665 | 4.27268
 |  | 269.5040200000001 | 410.4508699999998 | 35.96255 | 3.03692 | 22.34383
 |  | 66.03254000000001 | 119.0416400000001 | 54.40311000000001 | 0.34738 | 3.07906
 |  | 119.42195 | 96.13515999999993 | 14.40908 | 2.30302 | 5.811679999999999
 |  | 113.99814 | 96.68114999999997 | 19.98834999999999 | 1.36485 | 12.71407
 |  | 17.24696 | 206.1616499999998 | 26.12075999999999 | 0.228 | 26.71053
 |  | 44.37188 | 226.3611199999999 | 3.703700000000001 | 0 | 6.970009999999999
 |  | 171.39991 | 82.41429000000001 | 72.86043000000006 | 0.0204 | 2.19545
 |  | 30.79453999999999 | 79.98645999999998 | 22.54319 | 0.02938 | 1.08703
 |  | 122.65168 | 71.30300000000001 | 19.06609 | 0.3246 | 77.70326
 |  | 83.2771 | 50.8811 | 55.90015999999994 | 0.34236 | 8.41225
TOTAL
Historical Return Rate Rate
Reserve for Returns |  | 1820.84802 | 1721.77665 | 1137.84542 | 2.27935 | 247.0046199999999
Months Coverage
Historical Return Rate Rate
Reserve for Returns |  | 437.04135 | 1566.32091 | 183.92524 | 2.8817 | 110.03271
Months Coverage
Historical Return Rate Rate
Reserve for Returns |  | 848.61877 | 1936.56041 | 286.7800100000001 | 2.13645 | 188.74813
Months Coverage
Historical Return Rate Rate
Reserve for Returns |  | 1026.31922 | 1787.91167 | 279.5584799999999 | 2.32186 | 154.81303
Months Coverage
Historical Return Rate Rate
Reserve for Returns |  | 823.81839 | 2799.457809999999 | 321.7735599999999 | 3.93461 | 96.63074
Months Coverage