Spreadsheet: 117193d1312493759-nested-sumifs-sample
Sheet: Random vs. Fixed

 |  |  | Randomness?
 |  | Success Rate (out of 10) |  | Return Low | Return High
 | 1 | Strong
 | 2 | Moderate
 | 3 | Poor
 | 4 | Fail
 |  | Target Annual Investment Commitment (US$, 000s)
 |  |  | Annual | Per Qtr
 |  | 2011
 |  | 2016
 |  | Per Investment Commitment Limitations (US$, 000s)
 |  | Min | [NAME]
 |  | Length of Case (Quarters)
 |  | Min | [NAME] |  | Cummulative 5-yr Cash Flows
 |  |  |  | Random |  |  |  |  |  | Fixed
RAND |  | Case |  | Length ([NAME]) | Investment | Success | Pot. Payout | Act. Payout |  | Length ([NAME]) | Investment | Success | Pot. Payout | Act. Payout
 |  | 1 |  |  |  |  |  |  |  | 8 | 1038 | Moderate | 4152 | 1672.218
 |  |  |  |  |  |  |  |  |  | 8 | 1048 | Strong | 4192 | 3245.656
 |  |  |  |  |  |  |  |  |  | 12 | 1547 | Strong | 6188 | 3858.218
 |  |  |  |  |  |  |  |  |  | 10 | 5813 | Strong | 23252 | 12346.812
 |  |  |  |  |  |  |  |  |  | 12 | 5352 | Strong | 21408 | 17533.152
 |  |  |  |  |  |  |  |  |  | 10 | 2096 | Fail | 8384 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 5630 | Strong | 22520 | 12070.72
 |  |  |  |  |  |  |  |  |  | 12 | 4254 | Moderate | 17016 | 6823.416
 |  |  |  |  |  |  |  |  |  | 9 | 4330 | Fail | 17320 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 4603 | Strong | 18412 | 11185.29
 |  |  |  |  |  |  |  |  |  | 10 | 3173 | Strong | 12692 | 9227.083999999999
 |  |  |  |  |  |  |  |  |  | 8 | 4833 | Strong | 19332 | 15799.077
 |  |  |  |  |  |  |  |  |  | 10 | 1259 | Strong | 5036 | 3454.696
 |  |  |  |  |  |  |  |  |  | 10 | 2529 | Strong | 10116 | 8591.012999999999
 |  |  |  |  |  |  |  |  |  | 10 | 4465 | Poor | 17860 | 4255.145
 |  |  |  |  |  |  |  |  |  | 7 | 2615 | Poor | 10460 | 3059.55
 |  |  |  |  |  |  |  |  |  | 11 | 4675 | Strong | 18700 | 10154.1
 |  |  |  |  |  |  |  |  |  | 7 | 1896 | Fail | 7584 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 2841 | Fail | 11364 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 3283 | Strong | 13132 | 11244.275
 |  |  |  |  |  |  |  |  |  | 9 | 1521 | Strong | 6084 | 4596.462
 |  |  |  |  |  |  |  |  |  | 7 | 5583 | Moderate | 22332 | 6738.681
 |  |  |  |  |  |  |  |  |  | 11 | 5735 | Fail | 22940 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 3629 | Fail | 14516 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 1905 | Moderate | 7620 | 3495.675
 |  |  |  |  |  |  |  |  |  | 7 | 1388 | Poor | 5552 | 1188.128
 |  |  |  |  |  |  |  |  |  | 8 | 1007 | Fail | 4028 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 4851 | Strong | 19404 | 16410.933
 |  |  |  |  |  |  |  |  |  | 6 | 4061 | Fail | 16244 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 3297 | Fail | 13188 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 3984 | Poor | 15936 | 4482
 |  |  |  |  |  |  |  |  |  | 11 | 5825 | Strong | 23300 | 16746.875
 |  |  |  |  |  |  |  |  |  | 6 | 2747 | Strong | 10988 | 9001.919
 |  |  |  |  |  |  |  |  |  | 11 | 4490 | Fail | 17960 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 5134 | Fail | 20536 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 3965 | Strong | 15860 | 10606.375
 |  |  |  |  |  |  |  |  |  | 12 | 5308 | Moderate | 21232 | 8402.564
 |  |  |  |  |  |  |  |  |  | 6 | 5011 | Fail | 20044 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 3619 | Strong | 14476 | 8975.12
 |  |  |  |  |  |  |  |  |  | 12 | 5413 | Fail | 21652 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 4100 | Fail | 16400 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 2284 | Poor | 9136 | 2701.972
 |  |  |  |  |  |  |  |  |  | 11 | 4511 | Moderate | 18044 | 5751.525
 |  |  |  |  |  |  |  |  |  | 7 | 4973 | Fail | 19892 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 5334 | Fail | 21336 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 2369 | Fail | 9476 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 5019 | Poor | 20076 | 5616.261
 |  |  |  |  |  |  |  |  |  | 10 | 4417 | Strong | 17668 | 11554.872
 |  |  |  |  |  |  |  |  |  | 12 | 1190 | Strong | 4760 | 2698.92
 |  |  |  |  |  |  |  |  |  | 10 | 3607 | Moderate | 14428 | 4602.532
 |  |  |  |  |  |  |  |  |  | 12 | 5969 | Fail | 23876 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 1965 | Strong | 7860 | 6311.58
 |  |  |  |  |  |  |  |  |  | 7 | 2627 | Strong | 10508 | 5608.645
 |  |  |  |  |  |  |  |  |  | 6 | 5394 | Fail | 21576 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 5166 | Strong | 20664 | 13245.624
 |  |  |  |  |  |  |  |  |  | 11 | 3342 | Fail | 13368 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 5573 | Strong | 22292 | 17326.457
 |  |  |  |  |  |  |  |  |  | 11 | 3171 | Strong | 12684 | 10099.635
 |  |  |  |  |  |  |  |  |  | 9 | 4676 | Strong | 18704 | 9464.224
 |  |  |  |  |  |  |  |  |  | 9 | 4610 | Moderate | 18440 | 7837
 |  |  |  |  |  |  |  |  |  | 10 | 3184 | Strong | 12736 | 10943.408
 |  |  |  |  |  |  |  |  |  | 6 | 1762 | Strong | 7048 | 3927.498
 |  |  |  |  |  |  |  |  |  | 10 | 4467 | Poor | 17868 | 5346.999000000001
 |  |  |  |  |  |  |  |  |  | 12 | 2248 | Strong | 8992 | 6359.592000000001
 |  |  |  |  |  |  |  |  |  | 9 | 4873 | Strong | 19492 | 12177.627
 |  |  |  |  |  |  |  |  |  | 7 | 1002 | Fail | 4008 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 2778 | Moderate | 11112 | 3453.054
 |  |  |  |  |  |  |  |  |  | 7 | 3609 | Strong | 14436 | 8719.344
 |  |  |  |  |  |  |  |  |  | 8 | 5395 | Fail | 21580 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 5249 | Moderate | 20996 | 7925.99
 |  |  |  |  |  |  |  |  |  | 6 | 3835 | Moderate | 15340 | 6734.26
 |  |  |  |  |  |  |  |  |  | 7 | 5037 | Poor | 20148 | 5258.628000000001
 |  |  |  |  |  |  |  |  |  | 7 | 3859 | Strong | 15436 | 10033.4
 |  |  |  |  |  |  |  |  |  | 10 | 4354 | Moderate | 17416 | 6330.715999999999
 |  |  |  |  |  |  |  |  |  | 8 | 5978 | Moderate | 23912 | 11268.53
 |  |  |  |  |  |  |  |  |  | 10 | 1286 | Fail | 5144 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 5915 | Moderate | 23660 | 10723.895
 |  |  |  |  |  |  |  |  |  | 10 | 2098 | Strong | 8392 | 4504.406
 |  |  |  |  |  |  |  |  |  | 7 | 4932 | Strong | 19728 | 16398.9
 |  |  |  |  |  |  |  |  |  | 10 | 4457 | Moderate | 17828 | 7331.765
 |  |  |  |  |  |  |  |  |  | 11 | 4891 | Moderate | 19564 | 5888.764
 |  |  |  |  |  |  |  |  |  | 9 | 3018 | Strong | 12072 | 7741.17
 |  |  |  |  |  |  |  |  |  | 11 | 3765 | Moderate | 15060 | 5169.345
 |  |  |  |  |  |  |  |  |  | 6 | 2776 | Strong | 11104 | 9085.848
 |  |  |  |  |  |  |  |  |  | 8 | 4440 | Fail | 17760 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 1397 | Strong | 5588 | 3906.012
 |  |  |  |  |  |  |  |  |  | 12 | 3853 | Moderate | 15412 | 7513.349999999999
 |  |  |  |  |  |  |  |  |  | 11 | 2004 | Strong | 8016 | 5927.832
 |  |  |  |  |  |  |  |  |  | 9 | 3229 | Strong | 12916 | 11152.966
 |  |  |  |  |  |  |  |  |  | 11 | 2715 | Fail | 10860 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 5698 | Poor | 22792 | 6324.780000000001
 |  |  |  |  |  |  |  |  |  | 6 | 4046 | Fail | 16184 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 4943 | Moderate | 19772 | 8922.115
 |  |  |  |  |  |  |  |  |  | 8 | 1075 | Strong | 4300 | 3135.775
 |  |  |  |  |  |  |  |  |  | 10 | 2908 | Strong | 11632 | 8947.916
 |  |  |  |  |  |  |  |  |  | 10 | 5680 | Moderate | 22720 | 8304.16
 |  |  |  |  |  |  |  |  |  | 12 | 1964 | Strong | 7856 | 4417.036
 |  |  |  |  |  |  |  |  |  | 7 | 4412 | Strong | 17648 | 11400.608
 |  |  |  |  |  |  |  |  |  | 9 | 3269 | Fail | 13076 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 4135 | Fail | 16540 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 4549 | Fail | 18196 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 4971 | Moderate | 19884 | 7098.588
 |  |  |  |  |  |  |  |  |  | 10 | 5061 | Fail | 20244 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 2016 | Strong | 8064 | 4709.375999999999
 |  |  |  |  |  |  |  |  |  | 11 | 3905 | Moderate | 15620 | 7560.08
 |  |  |  |  |  |  |  |  |  | 8 | 4071 | Poor | 16284 | 4665.366
 |  |  |  |  |  |  |  |  |  | 8 | 5866 | Moderate | 23464 | 11538.422
 |  |  |  |  |  |  |  |  |  | 9 | 2951 | Moderate | 11804 | 4031.066
 |  |  |  |  |  |  |  |  |  | 6 | 1074 | Moderate | 4296 | 1690.476
 |  |  |  |  |  |  |  |  |  | 11 | 1266 | Strong | 5064 | 3344.772
 |  |  |  |  |  |  |  |  |  | 12 | 4132 | Moderate | 16528 | 6437.656
 |  |  |  |  |  |  |  |  |  | 9 | 5370 | Strong | 21480 | 13672.02
 |  |  |  |  |  |  |  |  |  | 6 | 1325 | Moderate | 5300 | 2051.1
 |  |  |  |  |  |  |  |  |  | 11 | 2641 | Moderate | 10564 | 4106.755
 |  |  |  |  |  |  |  |  |  | 8 | 4220 | Moderate | 16880 | 7233.08
 |  |  |  |  |  |  |  |  |  | 7 | 2491 | Fail | 9964 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 4125 | Moderate | 16500 | 7882.875
 |  |  |  |  |  |  |  |  |  | 8 | 5811 | Moderate | 23244 | 8013.369
 |  |  |  |  |  |  |  |  |  | 11 | 5820 | Moderate | 23280 | 11244.24
 |  |  |  |  |  |  |  |  |  | 9 | 3988 | Poor | 15952 | 3676.936
 |  |  |  |  |  |  |  |  |  | 7 | 2957 | Poor | 11828 | 2693.827
 |  |  |  |  |  |  |  |  |  | 11 | 4437 | Moderate | 17748 | 7520.715
 |  |  |  |  |  |  |  |  |  | 10 | 4126 | Fail | 16504 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 3429 | Moderate | 13716 | 4214.241
 |  |  |  |  |  |  |  |  |  | 9 | 3508 | Poor | 14032 | 3083.532
 |  |  |  |  |  |  |  |  |  | 7 | 4363 | Moderate | 17452 | 7552.353
 |  |  |  |  |  |  |  |  |  | 7 | 3707 | Strong | 14828 | 12040.336
 |  |  |  |  |  |  |  |  |  | 11 | 5502 | Moderate | 22008 | 8858.220000000001
 |  |  |  |  |  |  |  |  |  | 8 | 5965 | Fail | 23860 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 1188 | Moderate | 4752 | 2282.148
 |  |  |  |  |  |  |  |  |  | 6 | 1867 | Moderate | 7468 | 3132.826
 |  |  |  |  |  |  |  |  |  | 6 | 4811 | Fail | 19244 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 1380 | Strong | 5520 | 4115.16
 |  |  |  |  |  |  |  |  |  | 11 | 1801 | Strong | 7204 | 4448.47
 |  |  |  |  |  |  |  |  |  | 10 | 5870 | Moderate | 23480 | 10994.51
 |  |  |  |  |  |  |  |  |  | 9 | 3529 | Fail | 14116 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 5240 | Strong | 20960 | 11769.04
 |  |  |  |  |  |  |  |  |  | 12 | 1407 | Strong | 5628 | 4236.477
 |  |  |  |  |  |  |  |  |  | 7 | 1206 | Fail | 4824 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 1880 | Moderate | 7520 | 3154.64
 |  |  |  |  |  |  |  |  |  | 10 | 2317 | Strong | 9268 | 7650.734
 |  |  |  |  |  |  |  |  |  | 6 | 4993 | Moderate | 19972 | 7873.961
 |  |  |  |  |  |  |  |  |  | 10 | 3960 | Moderate | 15840 | 7571.52
 |  |  |  |  |  |  |  |  |  | 8 | 2145 | Fail | 8580 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 3678 | Strong | 14712 | 9400.968
 |  |  |  |  |  |  |  |  |  | 11 | 1436 | Strong | 5744 | 4514.784000000001
 |  |  |  |  |  |  |  |  |  | 9 | 2624 | Strong | 10496 | 7559.744
 |  |  |  |  |  |  |  |  |  | 11 | 1142 | Poor | 4568 | 1175.118
 |  |  |  |  |  |  |  |  |  | 8 | 1091 | Strong | 4364 | 2242.005
 |  |  |  |  |  |  |  |  |  | 12 | 1661 | Fail | 6644 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 1778 | Fail | 7112 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 4212 | Strong | 16848 | 11856.78
 |  |  |  |  |  |  |  |  |  | 9 | 2440 | Poor | 9760 | 2127.68
 |  |  |  |  |  |  |  |  |  | 6 | 5080 | Strong | 20320 | 12471.4
 |  |  |  |  |  |  |  |  |  | 10 | 2015 | Fail | 8060 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 2027 | Strong | 8108 | 4388.455
 |  |  |  |  |  |  |  |  |  | 6 | 5595 | Moderate | 22380 | 10775.97
 |  |  |  |  |  |  |  |  |  | 10 | 3704 | Fail | 14816 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 3579 | Strong | 14316 | 8704.128
 |  |  |  |  |  |  |  |  |  | 6 | 2036 | Moderate | 8144 | 3634.26
 |  |  |  |  |  |  |  |  |  | 8 | 5934 | Moderate | 23736 | 7737.936000000001
 |  |  |  |  |  |  |  |  |  | 11 | 1906 | Strong | 7624 | 4197.012
 |  |  |  |  |  |  |  |  |  | 7 | 2207 | Strong | 8828 | 7647.255
 |  |  |  |  |  |  |  |  |  | 7 | 4515 | Moderate | 18060 | 7314.3
 |  |  |  |  |  |  |  |  |  | 10 | 4007 | Strong | 16028 | 10209.836
 |  |  |  |  |  |  |  |  |  | 7 | 3099 | Strong | 12396 | 9157.545
 |  |  |  |  |  |  |  |  |  | 6 | 3539 | Poor | 14156 | 3415.135
 |  |  |  |  |  |  |  |  |  | 12 | 4211 | Strong | 16844 | 9049.439
 |  |  |  |  |  |  |  |  |  | 9 | 5471 | Moderate | 21884 | 6652.736
 |  |  |  |  |  |  |  |  |  | 12 | 5799 | Strong | 23196 | 16996.869
 |  |  |  |  |  |  |  |  |  | 6 | 3043 | Fail | 12172 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 5830 | Strong | 23320 | 14499.21
 |  |  |  |  |  |  |  |  |  | 8 | 4279 | Strong | 17116 | 13898.192
 |  |  |  |  |  |  |  |  |  | 7 | 2327 | Fail | 9308 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 4326 | Moderate | 17304 | 5329.632
 |  |  |  |  |  |  |  |  |  | 8 | 5139 | Fail | 20556 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 3053 | Moderate | 12212 | 3831.515
 |  |  |  |  |  |  |  |  |  | 8 | 3670 | Poor | 14680 | 3787.44
 |  |  |  |  |  |  |  |  |  | 12 | 1971 | Fail | 7884 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 2971 | Strong | 11884 | 6916.487999999999
 |  |  |  |  |  |  |  |  |  | 7 | 5413 | Fail | 21652 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 1707 | Fail | 6828 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 1787 | Strong | 7148 | 3901.021
 |  |  |  |  |  |  |  |  |  | 6 | 5379 | Strong | 21516 | 15383.94
 |  |  |  |  |  |  |  |  |  | 12 | 3497 | Strong | 13988 | 7228.299000000001
 |  |  |  |  |  |  |  |  |  | 8 | 4969 | Fail | 19876 | 0
 |  |  |  |  |  |  |  |  |  | 12 | 3149 | Strong | 12596 | 8880.18
 |  |  |  |  |  |  |  |  |  | 9 | 5174 | Strong | 20696 | 15651.35
 |  |  |  |  |  |  |  |  |  | 7 | 4589 | Strong | 18356 | 11679.005
 |  |  |  |  |  |  |  |  |  | 8 | 2953 | Poor | 11812 | 3215.817
 |  |  |  |  |  |  |  |  |  | 9 | 1461 | Strong | 5844 | 3278.484
 |  |  |  |  |  |  |  |  |  | 8 | 5277 | Fail | 21108 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 3587 | Fail | 14348 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 5116 | Strong | 20464 | 16217.72
 |  |  |  |  |  |  |  |  |  | 8 | 3661 | Poor | 14644 | 3803.779
 |  |  |  |  |  |  |  |  |  | 11 | 5137 | Strong | 20548 | 16787.716
 |  |  |  |  |  |  |  |  |  | 9 | 5716 | Moderate | 22864 | 9385.671999999999
 |  |  |  |  |  |  |  |  |  | 12 | 3712 | Strong | 14848 | 9725.44
 |  |  |  |  |  |  |  |  |  | 9 | 2230 | Strong | 8920 | 7742.559999999999
 |  |  |  |  |  |  |  |  |  | 10 | 2671 | Fail | 10684 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 3631 | Fail | 14524 | 0
 |  |  |  |  |  |  |  |  |  | 10 | 1339 | Strong | 5356 | 3193.515
 |  |  |  |  |  |  |  |  |  | 10 | 1139 | Fail | 4556 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 1568 | Poor | 6272 | 1409.632
 |  |  |  |  |  |  |  |  |  | 11 | 3730 | Fail | 14920 | 0
 |  |  |  |  |  |  |  |  |  | 7 | 4145 | Fail | 16580 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 5722 | Fail | 22888 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 4936 | Strong | 19744 | 13119.888
 |  |  |  |  |  |  |  |  |  | 11 | 2639 | Fail | 10556 | 0
 |  |  |  |  |  |  |  |  |  | 11 | 4730 | Poor | 18920 | 4602.29
 |  |  |  |  |  |  |  |  |  | 11 | 3619 | Fail | 14476 | 0
 |  |  |  |  |  |  |  |  |  | 8 | 2794 | Moderate | 11176 | 4984.496
 |  |  |  |  |  |  |  |  |  | 6 | 2041 | Poor | 8164 | 1757.301
 |  |  |  |  |  |  |  |  |  | 7 | 2648 | Strong | 10592 | 5481.36
 |  |  |  |  |  |  |  |  |  | 10 | 3490 | Fail | 13960 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 1835 | Fail | 7340 | 0
 |  |  |  |  |  |  |  |  |  | 9 | 3726 | Poor | 14904 | 3047.868
 |  |  |  |  |  |  |  |  |  | 8 | 4904 | Strong | 19616 | 14270.64