Please include a file with results or just include what formulas you used and where. Will Give thumbs up from all accounts
Year 2 Year 3 year 4
Tasks - Maintaining the format found on the "Ending Balance Table" tab, produce an ending balance table with each investor's ending balance for each month end. - Show how you populated the data in columns A, B, and of the Ending Balance Table. - Your final Ending Balance Table should only contain data in columns A, B, and C. Notes - You will be graded on how efficiently you utilize excel formulas to complete this task. - This exercise should be completed entirely in excel, exclusively with the use of excel formulas. - If you would also like to complete this exercise using C++/Python/VBA/Macros/etc., please feel free to submit that version as a separate file. Please note, this is a bonus step, and would be in addition to the version completed using Excel formulas. - Note that the ending balance table has been seeded with example answers - you may delete those rows if desired. - Show your work. Document, and be prepared to discuss, any assumptions you made about the data. Random Investment Fund OWNERSHIP December 31, 2012 3 Beginning Balance 01/01/12 Contribution 01/01/12 Balance 01/01/12 373,968 Allocation 01/21/12 64,797 Balance 01/21/12 438,765 Contribution 01/21/12 Ending Balance 01/21/12 438.765 % 01/21/12 59.78% Allocation 02/29/12 Balance 02/29/12 Contribution 02/29/12 Ending Balance % 02/29/12 02/29/12 468.5801 59.70% Income Allocation 03/21/12 18,529 Ending Balance 03/21/12 487,108 Contribution 03/21/12 Ending Balance 03/21/12 AR7.108 01/01/12 59.86% Income Allocation 04/20/12 45,472 % 03/21/12 59.63% 5 6 7 8 9 10 11 12 Ending Balance 04/20/12 441,636 A B 18,698 2.99% 3.240 2 1.933 21.938 2 .99% 1,491 23,428 I 23,428 2 .99% 926 24.355 24,355 2.98% -2,274) 22,081 c 224.391 35.9291 3 8.978 263.259 263.2591 35.87% 292.265 35.78% -27.293 264.992 13 01 0.00% 1 01 0.00% - 0 14 D 15 16 General Partner 0,00% 0 0 7.6201 451 7.6651 1.23% 1.000 9.9931 1.36% 1.000 11.6721 1.49% 462 12,134 1 ,000 13,134 1.61% st 11.908 17 624.667 45 624.712 100.00% 108.243 732.955 1 .000 723.955 100.00%|__ 4,82 100.00% 183,28 1,000 784,828 100.00% 31,034 815,862 -76,255 740,607 19 76,255 21 A1 % fx Random Investment Fund AC AD W X Y Z AA AB AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT 5 Ending Ending Ending Ending 6 7 Contribution 04/30/12 1 Ending Balance % 04/30/12 04/30/12 441.636153.91% Income Allocation 05/31/12 -45.705 Ending Balance 05/31/12 395.931 Contribution 05/31/12 Income Allocation 0 6/30/12 Ending Balance 06/30/12 Contribution 06/30/12 Income Ending Allocation Balance 07/31/12 07/31/12 -2.4821 410.862 Contribution 07/31/12 Income Ending Allocation Balance Contribution 08/31/12 08/31/12 08/31/12 9.3051 420.1671 05/31/12 395.9311 Income Allocation 09/30/12 23.631 05/31/12 06/30/12 | 06/30/12 413.3441 49.779 07/31/12 07/31/12 410.8621 49 599 08/31/12 08/31/12 420,1671 48.53% 48.84% 22.081 2.70% -2.285 19.796 19.796 2 .44% 871 20,667 1 20.6672 .44% -124 20.543 20.5431 2.43% 4651 21.00 21.000 2.43% 1.192 10 11 264,982 32.34% -27,423 237,559 237,559| 29.30% 10,448 248,007 248,007 29.26% 1,489 246,517| 246.517 29.15% 5,583 252,100 252,100 29.12% 14.179 75.000 9.15% -7,762 6 7,238 75.000 142.238 17.54% 6.255 148.494 148.4941 17.529 -8921 147.602 147.602 1 7.46% 3.343 150.945 150.945 17.44% 9,499 656 15 5641 1.90% 1.250 15.203 1.88% 1.1561 17.0281 2 .01% -102 16.9261 20,031 2.37% 454 20,485 1,000 21,485 2.48% 1,208 15 16 17 18 19 7 8.656 319.263 100.00% -84.786 734.477 7 6.250 910.727 100.00% 35.655 846.382 1 .156 347.539 100.00% 5.089 342.449 3.106 345.555 100.00% 19.149 864.704 1 .000 965.704 100.00% 48.689 20 19,149 48,689 A1 = % fx Random Investment Fund BA 8 96,764 AV BF B BK BN BO AU 443,798 AW 443.798 AX 48.48% AY 7,033 A7 436,764 BB 436.764 BC 48.43% BD 8,578 4.43% BE 445,343 8,578 BG 445,343 245,243 BH 48.38% BI 42,490 BL 487.832 BM 48.329 8 BO 113,864 BP 5,693 487,832 9 10 22.189 22,189 2.42% 352 21,838 21,8382 .42% 429 22,267 22,267 2.42% 2.124 2 4391 24,391 2.42% 11 266,279 266,279 29.09% 4,220 262,059 + 262.059 262,058 29.06% 29.06% 5,47 5.1471 267.206 267,206 267,206 29.03% 12 13 14 25,494 292,700 292,700 29.00% 68 3191 159.434 159.434 17.42% 2.527 156.908 156.908 17.400 3.082 159.989 159.999 17.38% 15.264 175.254 175.254 17.36% 25.254 1.263 15 16 22,693 1,000 23,693 2.59% -375 23.313 24,318 2.70% 478 24.796 1,000 25,796 2.80% 2,461 2 8,257 1 ,000 29,257 2.90% 4,424 -221 10,878 17 18 914,393 1,000 915,393 100.00% -14,507 900,897 1.000 901,887 100.00% 17,713 919.600 1,000 920.600 100.00% 87,834 1,008,433 1,000 1,009,433 100.00% 217.553 -10.878 10.878 19 20 14,5071 17.7131 87,834 217,553 A1 BS 24.105 10 11 12 289,284 13 14 173.991 150.000 15 16 39,913 17.213 1.009.433 167 2131 - B C D E F G H I J K L M N O P Q R S T U V 1 Random Investment Fund 2 OWNERSHIP 3 December 31, 2013 Ending Ending Beginning Balance 01/01/12 01/01/12 482,139| 47.76% Income Allocation 01/21/12 55,960 Ending Balance 01/21/12 538,099 Contribution 01/21/12 income Allocation 02/28/12 12,674 % 02/28/12 47.72% Ending Balance 02/28/12 550,773 Contribution 02/28/12 Ending Balance 02/28/12 550,773 Income Allocation 03/31/12 51,872 % 03/31/12 4 3.88% Ending Balance 03/31/12 602,645 Contribution 03/31/12 Ending Balance 03/31/12 602,645 Income Allocation 04/30/12 7,246 01/21/12 538,099 Ending Balance Contribution 04/30/12 1 04/20/12 609,891 250.000 04/30/12 40.87% 04/20/12 859.84 A B 24.106 2.39% 2,798 26,904 26,904 2.39% 634 27,538 27,538 2.19% 2,593 30,131 30.1312 .04% 362 30,493 30,49 8 9 10 11 12 13 14 C 289.284 28.66% 33,576 322.860 322.860 28.63% 7,605 330,464 330,464 26.33% 31,123 361,588 361.598124.53% 4.348 365,935 365.98 D 173.991 17.24% 20,194 194.185 194,185 17.22% 4,574 198,759 100,000 298,759 23.80% 28,137 326,896 326.896 22.17% 3.9301 330.8271 330,82 15 16 E 0.00% 0 0.00% 0 0.00% 0 01 100,000 100,000 6.78% 1.202 101,202 101,20 17 0.00% 0.00% 0,00% 0.00% 1 0 250,000 18 F 19 250.00 20 G 0.COM 0.00% 0.00% o 1.000.000 1,000,00 0.00% 0,00% 0.00% 0.00% 92,500 92,50 110111111111110110 lol lol lol HeHeHeHeHeHeH 0.00% 0.00% 0.00% 0 0.00% 0 100,000 100,00 0.00% 0.00% 0.00% 0.00% 50,000 28 N 0.00% 0.00% 0.00% 0,00% 0 300,000 100,000 50,00 300,0 100,0 0.00% 0.00% 0.00% 0.00% 30 L 31 32 M 33 34 N 0.00% 0 0.00% 0 0.00% 0 0.00% 0.00% o 0.00% oo ol 0.00% 010 0.00% 000 35 36 General 39,913 3.95% 4.633 44.546 1,000 45,546 4.04% 1,073 46.619 1,000 47,619 3.79% 4,485 52 104 1,000 53.103 3.60% 638 53,742 4 .497|| 1,009,433 100,00% 117,160 1,126,593 1,000 1,127,593 100.00% 26,559 1,154,152 101,000 1,255,152 100.00% 118,211 1,373,363 101,000 1,474,363 1 00.00% 17,727 1,492,090 2,146,997 3,639,08 cent W Z AA AB AC AD AE AF AG AH AI AI AK AL AM AN AO AP AQ AR AS - MAWL 5 Ending Ending income Ending Ending Ending Ending Income Ending 6 7 Income Ending A location Balance Contribution 05/31/1305/31/1305/31/13 80,144 940,035 Contribution 06/30/13 Income Allocation 06/30/1307/31/13 23.42% 37,075 Ending Balance 07/31/13 962,229 Contribution 07/31/13 income A location 08/31/13 3.905 Ending Contribution 08/31/13 08/31/13 966.134|| 04/30/12 859,891 04/30/12 23.63% 8 05/31/1305/31/13 23.62% 06/30/13 -14,880 06/30/13 925.154 06/30/13 925.154 07/31/13 | 07/31/13 962,229 22.31% 08/21/13 08/21/13 966.1341 22.31% 1 09/20/13 09/20/13 6 4.7801 1.030.914 9 10 3 0,493 0,84% 2.842 33.335 33.335 0.84% -528 32.90s 32,808 0.83% 1.315 34.122 34,122 0.79% 138 34.261 34.261 0.79% 2.2971 3 6,558 11 3 65.935 10.06% 34.105 400.041 400.041 10.05% -6.2331 393.709 393.709 9.97% 15.778 409.4961 409.496 9.50% 1.662 411.148 411.148 9.49% 27,568 438,716 3 30.827 9.09% 30.834 361.661 361.661 9.09% -5.7251 355.9361 355.9361 9 .01% 14.264 370.199) 370.199) 9.59% 1,503 371.702 371.7021 9.58% 24.923 396,625 12 13 14 15 16 17 18 101,202 2.78% 9,432 1 10,635 110,635 2.78% 1.751 108.893 108.8831 2.76% 4,363 113,247|| 2.63% 460 113.706 113,706 2.63% 121,330 250.000 6.87% 22.301 273.301 273.301 6.87% -4.2261 268.9741 268.9746 .81% 10.779 279.753 279.7531 6.49% 1.135 280.899 280.899 6.49% 16,834_299,722 20 1 .000.000 27.48% 93.203 1.093.203 1.092 203 27.47% -17.305 1.075.998 1,075,898 27.23% 43,116 1,119,013 1,119,013 25.95% 4.5421 1.123.555 1,123,555 25.94% 75.335 1,198,890 92.500 2.54% 9.621 101.121 101.121 2.54% -1.601 99.521 32.500 122.021 3.34% 5,291 137,311 3.18% + 137.868 127.868 3.18% 147,113 CANCIONE 100,000 2.75% 9,3201 109,320 109,320 2.75% -1,731 107,590 107,590 2.72% 4,312 111.901 111.901 2.60% 1 112,355 | 112.355 2.59% 119.899 50.000 1.37% 4,660 54,660 54.660 1.37% -865 53.795 52.795 1.36% 2.156 55,951 55,951 1.30% 227156, 178 56,178 13051 59.9441 300.000 3.24% 27,961 327,961 327.961 9.24% -5.1921 322.769 322,769 8 .17% 12.935 335,704 7.79% 1.3621 337,066 337.066 7.78% 22.601 359.6671 30 100.000 2.75% 9.320 109.3201 109.220 2.75% 1.731 107.590| 107.5901 2.72% 4.3121 111.901 1 2 .60% 454 112.355 112.355 2.59% H 01 0.00% 0 0 0.00% 125.000 125.000 2.90% 507 125.507 125,507 2.90% 8,415 133.923 0 0,00% 0 0 ol 0.00% 0 0 0,00% 0 0 75.000 1 7 5.000 1.74% 30475 304 75.304 1.74% 5.0491 90.354 1.60% 65,546 1.66% R 172 3 128 71 310 1 65% 289 7 1,600 1,000 72.600 1.68% 4.868 77,467 38 3 .639.087 100.00% 339.172 3.978.259 1.250 3.979.509 100.00% -62.994 3.916.515 3 4.156 3.950.671 100,00% 158.320 4.108.991 203.1384 .312.128 100,00% 17,501 4.329.630 1 .000 4.330.630 100.00% 290.372 4,621,002 39 40 339,1721 -62,994 158,320 17,501 AS AT AU AV AW AX AY AZ RA BC BD BE BF BG BH BI BJ B K BL BM BN BO BP Ending 5 6 7 Ending Balance 09/30/13 1,030,914 Contribution 09/30/13 Ending Balance 09/30/13 1,030,914 Withdrawal 1 0/01/13 income Allocation 10/31/13 16.151 Ending Balance 10/31/13 1.047.065 % 10/01/13 2 2.49% Contribution 10/31/13 Income Allocation 11/30/13 94.300 Balance 10/31/13 1.047.065 Ending Balance 1 1/30/13 1.141.365 % 10/31/13 22.47% Ending Balance 11/20/13 1.141.365 Income Allocation 12/21/13 36,256 Contribution 1 1/30/13 Ending Balance 12/31/13 1.177.621 Contribution 12/31/13 09/30/13 22.30% Ending Balance 12/21/13 1.177.621 10/01/13 1.030.9141 2013 Income Allocation 445.4921 2012 GP Allocation -22.274 11/20/13 22.47% 10 36,558 36,558 0.79% -36,558 0.00% 0 0.00% | 0 0.00% 0 12,452 6 23 11 438.7169.49% 9.57% 6.8731 445.599 40.1301 485.719 15.429 501.1481 501.148 211.864 -10.593 396,625 8.58% 1 396.625 8.65% 6.214 402.839 36.280 439.119 439.119 9.65% 13.949 453.068 453,068 179,077 -8,954 14 15 16 17 121.3302 .63% 1 2.65% 1,901 123.231 2.65% 11,098 134.3301 134,330 2.64% 22671 138.597 138,5971 38,597 -1.930 299,722 6.48% 299,722 6.54% 4.696 304,418 27,416 331.834 6.53% 10,541 342.375 342,375 92.375 -4.619 19 1.198.9901 25.94% 1.198.8901 26.149 18.782 1.217.673 1.217.673 26.14% 109.665 1.327.237 1.327.2371 26.139 42,163 1,369,501 1.369.501 369.501 -18,475 21 22 147.113 3.18% 147.113 3.21% 2,305 149,417|| 3.21% 13.457 162,874 162.874 3.21% 5.174 168.048 168,048 49.0491 -2,152 23 24 119,899 119.899 2.59% 119.889 2,61% 1,878 121,767 121,767 2,61% 10.966 132.734 132,734 2,61% 4.216 136,950 136,950 36,950 1.848 25 59.944 59.944 1.30% 59,944 1.31% 939 60.884 5,483 66.367 66.3671 1.31% 68,475 68,475 18,475 -924 26 27 28 359,667 359.667) 7.79% 359.667) 7.84% 5.6351 365.3021 7.84% 32.999 398.201 398.2011 7.84% 410.850 410,850 110.850 -5.543 30 119.8 119.899 2.59% 119.899 2.61% 1.878 121.7671 121,767 2.61% 10.966 132,734 132.7341 2.61% 136.9501 136,950 36,950 1948 123.923 123.9231 2.90% 123.9231 2.92% 2,098 136,021 2.92% 12,250 148.271 148.271 2.92% 152.981 152.981 27.981 1,399 34 90.3541 1.74% 90.354 1.75% 1.259 81,612 1.75% 7.850 88,963 88,963 1.75% 2826 91,789 91.789 16.789 35 77.467 1 .000 78.4671 1.70% 558 79.025 1.72% 1.238 90.263 1.0001 91 2631 1.74% 7.319 38 582 1.000 99.5821 1.76% 2.846 9 2,428 1,058 93.486 34,416 1.721 37 38 4.621.00 1,000 4,622,001 100.00% -36,000 4,586,001 100.00% 71.848 4.657,849 1 ,000 4,658,849 100.00% 419.5901 5.078.4301 1.000 5.079.4301 100.00% 161.3505.240,780 1.674 806 -83.740 39 71.948 161,3501 1,674,806 41 42 BP BO BR BS BT BU NOWN 2013 Balance 2013 GP Allocation Liquidating Cont/ With 2013 Cont/ Allocation Allocation 22,274 250.000 623 35.935 11 10.593 13 8.9541 444.1141 100,000 14 15 16 1,930 136,6671 100,000 17 18 4,619 337,7561 250,000 19 20 18.4751 1,351.026 1.000.000 21 2.152 165,895 125,000 -1,848 135.1031 100,000 67,551 50,000 wNaN NNNN 405,308 300,000 -1.840 100,000 1.3991 125.000 90.9491 75,000 36 1.721 8 3,740 -623 1 74.883 18.534 37 83,740 0 5241 R2R 2.557 599 3883,740 39 N O P 2 OWNERSHIP 3 December 31, 2014 Beginning income % Allocation 01/01/14 1 01/21/14 2 2.04% -2.941 Ending Balance 01/21/14 1.152.406 Contribution 01/21/14 Ending Balance 01/21/14 1.152.406 Allocation 02/28/14 78.439 Contribution 02/28/14 Ending Balance 02/28/14 1.230.845 Balance 02/28/14 1.230.845 Contribution 03/01/14 Ending Balance 03/01/14 1.230.845 income Ending Allocation Balance 1 03/31/14 03/31/14 55.9801 1.286.726 Contribution 03/31/14 01/01/14 1.155.347 Ending Balance 03/31/14 1.286.7261 01/21/14 2 1.62% 02/28/14 21.62% 03/01/14 21.629 03/31/14 21.61% 490.555 9 ,36% 1,249 489,306 489,306 9.18% 33, 305 5 22,611 522.611 9.19% 522,611 9.18% 23,727 546,338 546,338 9.18% 5 6 7 8A 9 10 C 11 12 D 13 14 E 15 16 F 17 444.1141 9.47% 1.1301 442,984 442.9941 9 .31% 30.1521 473.135 473,135 8.31% 473.135 9.31% 21.480 494.616 494.61619.31% 126.6671 2.61% -348 136.3191 136,319 2.56% 9.279 145.598 145,598 145.598 2.56% 6.610 152,208 152,208 2.56% 337,756 6.44% 860 336.896 6 .32% 22.9311 359.8271 359.8271 359.82716 .32% 16.336 3 76,163 376.163 6.32% 18 G 1,351,026 25.77% -3,439 1,347,587 1,347,587 25.29% 91.724 1.439.311 1,439,311 25.28% 65.345 1,504,656 1,504,656 25.28% 19 20 H 165.895 3.16% 3.10% 11,263 176,736 176.7361 3.10% 176.7361 3.10% 8.024 184,760 184.7601 3.10% 21 22 125.103 2.59% -344 134.759 2.53% 9,172 143,932 2.53% 143.9322 .53% 6,535 150,466 150.4661 2.53% 23 247 67,551 1.29% 172 67,379 67,379 1.26% 4,586 7 1.965 71.9651 1.26% 71.965 0 0.00% 0 0 0 0.00% 405,308 1,032 7.59% 27,517 431.794 431.7947 .58% 19.603 451.2971 7.58% 125.103 2.59% -344 134.759 124.7591 2.53% 9.1721 143.932 143.9321 2.53% 143.932 2.53% 6.5351 150.466 150.4661 2.53% 151.591 2.99% 286 151 1951 151.195 2 .84% 10,291 161,496 2.84% 161.496 2.84% 7,331 25 26 K 27 28 L 29 30 M 31 32 IN 33 34 ] 2014 Trust 35 36 General Partner 168.818|| 168.8182841 2321 90.717 90,717 1.70% 6,175 96,892 96.2921 1.70% 96,892 1.70% 4.399 101,291 101.2911.70% 0.00% 0.00% 71,965 7 1,965 1.26% 3.2671 75,232 1.26% -445 174.438 101.092 275.530 5.17% 19.7541 294.294 1.1101295.29415.19% 295.294 5.19% 13,411 308,805 1,1861 309,991 5.21% 37 5.241.838 100.00% -13.342 5.228.496 101.092 5.329.588 100.00% 362.760 5.692.348 1.1101 5.692.458 100.00% 0 5.693.458 100.00% 258.493 5.951.942 1 .1865.953.128 100.00% 38 39 40 -13,342 258,483 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP T AQ AR AS 4 Ending 5 6 7 Income Allocation 04/30/14 -32,788 Ending | Balance 04/30/14 1,253,938 Contribution 0 4/30/14 Ending Balance 0 4/30/14 1,253,938 Income Allocation 05/31/14 -25,737 Ending Balance 05/31/14 1,228,201 Contribution 05/31/14 Balance 05/21/14 1,228,201 Income Allocation 05/21/141 06/20/14 2 1.57% 44,299 04/30/14 21.58% Ending Balance 0 6/20/14 1,272,500 Contribution 06/20/14 Endine Balance 0 6/20/14 1,272,500 Income Ending Allocation Balance 07/21/14 07/21/14 -68.9351 1.203.565 % 06/20/14 21.56% Contribution 07/21/14 Ending Balance 07/21/14 1,203,565 07/31/32 % 07/21/14 21.55% 07/31/24 Income Allocation 08/21/14 44,011 02/22/1,01 1,247,576 Ending Balance Contribution 08/21/141 08/21/14 1,247,576 Ending Balance 08/21/14 1,247.5761 8 9 10 -13,921 532.416 532.4169 .16% -10.928 521.498 521.4981 9.16% 18.909 540.298 540.2981 9.15% -29.270 511.028 511.0281 9.15% 18.687 529.7151 529,715 11 12,603 482,012 482,012 8.29% -9,893 472.119 472.119 8 .29% 17.029 499.148 489,148 8.29% -26,499 462,649 462,649 3.28% 16,918 479,567 479,567 -3.978 148.329 148,329 2.55% -3,044 145,285 145.285 2.55% 5.2401 150,525 -8,154 142,371 142,371 2.55% 5,206 147,577 147,577 -9,585 366,578 366,578 6.31% 7,524 359,054 359,054 6 ,31% 12,951 372,005 372,005 6 .30% 20,153 351,852 351,852 6.30% 12,866 364,718 364,7181 -39.341 1.466.315 1,466,315 25.23% -30,096 1,436,219 1,436, 219 25.22% 51.9021 1.498.021 1,488,021 25.21% -80,611 1,407,411 1,407,411 25.20% 51,465 1,458,876 1,458,876 180,052 180,0521 3.10% -3.696 176.356 176,356 3.10% 6,361 182.717 182,717 3.10% -9,898 172,819 172,819 3.09% 6,319 179,138 179.1381 -3.934 146.632 1 146.632 2.52% -3,010 143,622 143,622 2.52% 5,180 148,803 148,803 2.52% -8,061 140,742 140,742 2.52% 5,147 145,888 145,888 0 0 0 1 0.00% 0 0.00% 0 0 0.00% 0 0 ol 00 -24,183 422,223 11.502 4 39.895 439.895 7.57% -9,029 430.866 430,866 7.57% 15.541 446,407 446,407 7.56% 422.223 7.56% 15.440 437.663 437,6631 28 -3.834 146,632 146.632 146,632 2.52% 2.52% 3,010 143,622 143,622 2.52% 5,1801 148,803 148,803 2.52% -8,061 140,742 140,742 2.52% 5,147 145,838 145,888 4.302 164.5161 164.516 2.83% 3,377 161,139 161,139 2.83% 5,812 166.951 166,951 2.83% -9,044 157,907 157.9071 2.83% 5,774 163,681 163.691 29 30 31 32 33 -2,581 98,710 99.7101 1.70% 96,684 1.70% 3.487 100,171 100,171 1.70% 5,427 94,745 94.745 1.70% 3,465 98,209 98.209 34 -1.917 7 2.315 73.315 1.26% 1,505 71.810 71.910 1 .26% 2.590 74.400 74.400 1.26% 4.030 70.370 70,370 1.26% 2,573 72,943 72.943 35 36 7,899 302,092 10.126 312.219 5.37% 6,408 305,810 2 ,061 307.871 5.41% 11,104 318,975 3,520 3 22,495 5.46% -17,471 305,025 1,230 306,255 5.48% 11,199 317,4541 1,223 318,677 -151.694 5.801.434 1 0126 5.811.560 100.00% 119.282 5.692.2771 2 .061 5.694.238 100.00% 205.397) 5.899.725 3,520 5,903,245 100.00% 319,796 5,583,448 1.230 5.584.678 100.00% 204,216) 5.788.994 1 .223 5.790.118 37 38 39 40 -151,694 119.283 5.692.277|| 205,387 5,899,725 -319,796 5,543,448 204,216 5,788,894 AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ B K BL BM BN BO BP BQ 3 2014 5 6 7 % 08/31/149 2 1.55% Income Allocation /31/2014 -35,044 Ending Balance 9/31/2014 1.212.532 Contribution 9/31/2014 Ending Balance 9/31/2014 1.212.5321 Income Ending Allocation Balance 1 0/31/14 10/31/14 71.7621 1.284.294 Contribution 10/31/14 Balance 10/31/14 1.284.2941 Ending Balance 11/30/14 1.340.2941 Allocation 11/30/14 56.001) Contribution 12/01/14 09/30/14 21.54% Ending Balance 12/01/14 1.340.294 Income Ending Allocation Balance 12/21/14 12/31/14 65.6781 1.405.973 | 2014 GP Allocation -12.531 2014 GP Allocation % 12/01/14 21.53% Liquidating Cont/ With 10/31/14 2 1.54% 11/30/14 21.54% Allocation 250.6261 8 9 .15% -14,880 514,835 514,835 9.15% 30.470 545.305 545.305 9.14% 22.778 569.093 9.14% 569,083 9 .14% 27.887 596.970 9 10 11 12 5,321 9.29% -13.471 466.096 466.0961 9.29% 27,585 493.691 493.6911 9.29% 21.527 515.2081 9.29% 515.209 9.29% 25.2471 540.4541 4817 13 14 2 .55% 4.145 143.431 143,431 2.55% 8.489 151,920 151.920 2.55% 6.624 158.545 2.55% 158.545 2 .55% 7.769 166.314 29.647 1.482 15 .30% 354.4741 6.30% 20,979 375,452 375.452 6.30% 16.371 391.8241 6.30% 391.824 6 ,30% 19,200 411,024 3.663 166 17 18 25.20% 40,980 1,417.896 1,417 896 25.19% 83,916 1,501,812 1,501,812 25.19% 65,486 1.567,298 25.1996 1,567,298 25.18% 76,802 1,644,100 14,654 19 20 174,106 3.09 10.3041 184.4101 184.4101 3.09% 9.0411 192.4511 3.09% 192.451 3.09% 9.431 201.892 -4.098 141.7901 150, 1821 2.52% 6,549| 156,730 156,730 2 .52% 7,680 164,410 1,465 NNNNNN 01 0.00% o 0 0,00% 0 0 0,00% 0 0.00% 0 0 -221 7.56% -12.294 4 25.369 425,3691 450,544 7.56% 19,646 470,190 470,190 7 .55% 23,041 493.230 26 271 28 29 30 2.52% -4.098 141.7901 2.52% 8,392 150,182 150.192 2.52% 6.549 156.7301 2.52% 156.7301 2.52% 7.690 164.4101 2.83% -4.598 159,094 159.0842 .83% 168.499 168,499 9,4151 2.3% 2.3471 175.846 175.846 2 .83% 8.617 184.463 31 1.70% 95.451 1.70% 5,649 101,100 101.100 1.70% 4.4081 105.508 1.70% 105.508 1.70% S,170 110,678 -996 1.26% -2,049 70,894 70.994 1.26% 4,196 75,090 75,090 1.26% 3,274 78,364 1.26% 78,364 1.26% 3,840 82,204 32 33 34 35 36 37 38 5.50% -8.952 309.7251 1.206 310.9321 5.52% 18.4021 329.3341 1.173 220 AC 320.506 E EA 5.54% 14.4121 144122140191 344.918 SAT 5.54% 1 242 246 1601 5.56% 16.962 363.122 63.070 3,153 58,111 100,00% 162.6445.627.474 1.206 5.628.680 100.00% 333.125 5.961.805 1 .173 5.962.977 100.00% 260.0126.222.989 100.00% 1.242 6.224.231 100.00% 305.005 6.529.236 1.162.228 -59.111 5 8.111 39 40 162,644 5,627,474 333,125 5,961,804 260,012 6,222,989 305,005 6,529,236 1,162,228 BO BR BS BT 5 Balance 2014 Liquidating Cont/ Cont 7 with Allocation 1293.441 Der 10 591,649 11 12 525.637 164,831 14 15 407,361 16 17 1,629,446 19 20 200,083 21 488,834 NNNNNNNNMMMMMMM Nima lo NM 182.819 109,692 81,472 71.745 418.0811 125.1701 6,529.236 125,170 Resource Date Ending Balance 7/31/11 7/31/11 7/31/11 7/31/11 500,000.00 25,000.00 300,000.00 0.00 General Partners Tasks - Maintaining the format found on the "Ending Balance Table" tab, produce an ending balance table with each investor's ending balance for each month end. - Show how you populated the data in columns A, B, and of the Ending Balance Table. - Your final Ending Balance Table should only contain data in columns A, B, and C. Notes - You will be graded on how efficiently you utilize excel formulas to complete this task. - This exercise should be completed entirely in excel, exclusively with the use of excel formulas. - If you would also like to complete this exercise using C++/Python/VBA/Macros/etc., please feel free to submit that version as a separate file. Please note, this is a bonus step, and would be in addition to the version completed using Excel formulas. - Note that the ending balance table has been seeded with example answers - you may delete those rows if desired. - Show your work. Document, and be prepared to discuss, any assumptions you made about the data. Random Investment Fund OWNERSHIP December 31, 2012 3 Beginning Balance 01/01/12 Contribution 01/01/12 Balance 01/01/12 373,968 Allocation 01/21/12 64,797 Balance 01/21/12 438,765 Contribution 01/21/12 Ending Balance 01/21/12 438.765 % 01/21/12 59.78% Allocation 02/29/12 Balance 02/29/12 Contribution 02/29/12 Ending Balance % 02/29/12 02/29/12 468.5801 59.70% Income Allocation 03/21/12 18,529 Ending Balance 03/21/12 487,108 Contribution 03/21/12 Ending Balance 03/21/12 AR7.108 01/01/12 59.86% Income Allocation 04/20/12 45,472 % 03/21/12 59.63% 5 6 7 8 9 10 11 12 Ending Balance 04/20/12 441,636 A B 18,698 2.99% 3.240 2 1.933 21.938 2 .99% 1,491 23,428 I 23,428 2 .99% 926 24.355 24,355 2.98% -2,274) 22,081 c 224.391 35.9291 3 8.978 263.259 263.2591 35.87% 292.265 35.78% -27.293 264.992 13 01 0.00% 1 01 0.00% - 0 14 D 15 16 General Partner 0,00% 0 0 7.6201 451 7.6651 1.23% 1.000 9.9931 1.36% 1.000 11.6721 1.49% 462 12,134 1 ,000 13,134 1.61% st 11.908 17 624.667 45 624.712 100.00% 108.243 732.955 1 .000 723.955 100.00%|__ 4,82 100.00% 183,28 1,000 784,828 100.00% 31,034 815,862 -76,255 740,607 19 76,255 21 A1 % fx Random Investment Fund AC AD W X Y Z AA AB AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT 5 Ending Ending Ending Ending 6 7 Contribution 04/30/12 1 Ending Balance % 04/30/12 04/30/12 441.636153.91% Income Allocation 05/31/12 -45.705 Ending Balance 05/31/12 395.931 Contribution 05/31/12 Income Allocation 0 6/30/12 Ending Balance 06/30/12 Contribution 06/30/12 Income Ending Allocation Balance 07/31/12 07/31/12 -2.4821 410.862 Contribution 07/31/12 Income Ending Allocation Balance Contribution 08/31/12 08/31/12 08/31/12 9.3051 420.1671 05/31/12 395.9311 Income Allocation 09/30/12 23.631 05/31/12 06/30/12 | 06/30/12 413.3441 49.779 07/31/12 07/31/12 410.8621 49 599 08/31/12 08/31/12 420,1671 48.53% 48.84% 22.081 2.70% -2.285 19.796 19.796 2 .44% 871 20,667 1 20.6672 .44% -124 20.543 20.5431 2.43% 4651 21.00 21.000 2.43% 1.192 10 11 264,982 32.34% -27,423 237,559 237,559| 29.30% 10,448 248,007 248,007 29.26% 1,489 246,517| 246.517 29.15% 5,583 252,100 252,100 29.12% 14.179 75.000 9.15% -7,762 6 7,238 75.000 142.238 17.54% 6.255 148.494 148.4941 17.529 -8921 147.602 147.602 1 7.46% 3.343 150.945 150.945 17.44% 9,499 656 15 5641 1.90% 1.250 15.203 1.88% 1.1561 17.0281 2 .01% -102 16.9261 20,031 2.37% 454 20,485 1,000 21,485 2.48% 1,208 15 16 17 18 19 7 8.656 319.263 100.00% -84.786 734.477 7 6.250 910.727 100.00% 35.655 846.382 1 .156 347.539 100.00% 5.089 342.449 3.106 345.555 100.00% 19.149 864.704 1 .000 965.704 100.00% 48.689 20 19,149 48,689 A1 = % fx Random Investment Fund BA 8 96,764 AV BF B BK BN BO AU 443,798 AW 443.798 AX 48.48% AY 7,033 A7 436,764 BB 436.764 BC 48.43% BD 8,578 4.43% BE 445,343 8,578 BG 445,343 245,243 BH 48.38% BI 42,490 BL 487.832 BM 48.329 8 BO 113,864 BP 5,693 487,832 9 10 22.189 22,189 2.42% 352 21,838 21,8382 .42% 429 22,267 22,267 2.42% 2.124 2 4391 24,391 2.42% 11 266,279 266,279 29.09% 4,220 262,059 + 262.059 262,058 29.06% 29.06% 5,47 5.1471 267.206 267,206 267,206 29.03% 12 13 14 25,494 292,700 292,700 29.00% 68 3191 159.434 159.434 17.42% 2.527 156.908 156.908 17.400 3.082 159.989 159.999 17.38% 15.264 175.254 175.254 17.36% 25.254 1.263 15 16 22,693 1,000 23,693 2.59% -375 23.313 24,318 2.70% 478 24.796 1,000 25,796 2.80% 2,461 2 8,257 1 ,000 29,257 2.90% 4,424 -221 10,878 17 18 914,393 1,000 915,393 100.00% -14,507 900,897 1.000 901,887 100.00% 17,713 919.600 1,000 920.600 100.00% 87,834 1,008,433 1,000 1,009,433 100.00% 217.553 -10.878 10.878 19 20 14,5071 17.7131 87,834 217,553 A1 BS 24.105 10 11 12 289,284 13 14 173.991 150.000 15 16 39,913 17.213 1.009.433 167 2131 - B C D E F G H I J K L M N O P Q R S T U V 1 Random Investment Fund 2 OWNERSHIP 3 December 31, 2013 Ending Ending Beginning Balance 01/01/12 01/01/12 482,139| 47.76% Income Allocation 01/21/12 55,960 Ending Balance 01/21/12 538,099 Contribution 01/21/12 income Allocation 02/28/12 12,674 % 02/28/12 47.72% Ending Balance 02/28/12 550,773 Contribution 02/28/12 Ending Balance 02/28/12 550,773 Income Allocation 03/31/12 51,872 % 03/31/12 4 3.88% Ending Balance 03/31/12 602,645 Contribution 03/31/12 Ending Balance 03/31/12 602,645 Income Allocation 04/30/12 7,246 01/21/12 538,099 Ending Balance Contribution 04/30/12 1 04/20/12 609,891 250.000 04/30/12 40.87% 04/20/12 859.84 A B 24.106 2.39% 2,798 26,904 26,904 2.39% 634 27,538 27,538 2.19% 2,593 30,131 30.1312 .04% 362 30,493 30,49 8 9 10 11 12 13 14 C 289.284 28.66% 33,576 322.860 322.860 28.63% 7,605 330,464 330,464 26.33% 31,123 361,588 361.598124.53% 4.348 365,935 365.98 D 173.991 17.24% 20,194 194.185 194,185 17.22% 4,574 198,759 100,000 298,759 23.80% 28,137 326,896 326.896 22.17% 3.9301 330.8271 330,82 15 16 E 0.00% 0 0.00% 0 0.00% 0 01 100,000 100,000 6.78% 1.202 101,202 101,20 17 0.00% 0.00% 0,00% 0.00% 1 0 250,000 18 F 19 250.00 20 G 0.COM 0.00% 0.00% o 1.000.000 1,000,00 0.00% 0,00% 0.00% 0.00% 92,500 92,50 110111111111110110 lol lol lol HeHeHeHeHeHeH 0.00% 0.00% 0.00% 0 0.00% 0 100,000 100,00 0.00% 0.00% 0.00% 0.00% 50,000 28 N 0.00% 0.00% 0.00% 0,00% 0 300,000 100,000 50,00 300,0 100,0 0.00% 0.00% 0.00% 0.00% 30 L 31 32 M 33 34 N 0.00% 0 0.00% 0 0.00% 0 0.00% 0.00% o 0.00% oo ol 0.00% 010 0.00% 000 35 36 General 39,913 3.95% 4.633 44.546 1,000 45,546 4.04% 1,073 46.619 1,000 47,619 3.79% 4,485 52 104 1,000 53.103 3.60% 638 53,742 4 .497|| 1,009,433 100,00% 117,160 1,126,593 1,000 1,127,593 100.00% 26,559 1,154,152 101,000 1,255,152 100.00% 118,211 1,373,363 101,000 1,474,363 1 00.00% 17,727 1,492,090 2,146,997 3,639,08 cent W Z AA AB AC AD AE AF AG AH AI AI AK AL AM AN AO AP AQ AR AS - MAWL 5 Ending Ending income Ending Ending Ending Ending Income Ending 6 7 Income Ending A location Balance Contribution 05/31/1305/31/1305/31/13 80,144 940,035 Contribution 06/30/13 Income Allocation 06/30/1307/31/13 23.42% 37,075 Ending Balance 07/31/13 962,229 Contribution 07/31/13 income A location 08/31/13 3.905 Ending Contribution 08/31/13 08/31/13 966.134|| 04/30/12 859,891 04/30/12 23.63% 8 05/31/1305/31/13 23.62% 06/30/13 -14,880 06/30/13 925.154 06/30/13 925.154 07/31/13 | 07/31/13 962,229 22.31% 08/21/13 08/21/13 966.1341 22.31% 1 09/20/13 09/20/13 6 4.7801 1.030.914 9 10 3 0,493 0,84% 2.842 33.335 33.335 0.84% -528 32.90s 32,808 0.83% 1.315 34.122 34,122 0.79% 138 34.261 34.261 0.79% 2.2971 3 6,558 11 3 65.935 10.06% 34.105 400.041 400.041 10.05% -6.2331 393.709 393.709 9.97% 15.778 409.4961 409.496 9.50% 1.662 411.148 411.148 9.49% 27,568 438,716 3 30.827 9.09% 30.834 361.661 361.661 9.09% -5.7251 355.9361 355.9361 9 .01% 14.264 370.199) 370.199) 9.59% 1,503 371.702 371.7021 9.58% 24.923 396,625 12 13 14 15 16 17 18 101,202 2.78% 9,432 1 10,635 110,635 2.78% 1.751 108.893 108.8831 2.76% 4,363 113,247|| 2.63% 460 113.706 113,706 2.63% 121,330 250.000 6.87% 22.301 273.301 273.301 6.87% -4.2261 268.9741 268.9746 .81% 10.779 279.753 279.7531 6.49% 1.135 280.899 280.899 6.49% 16,834_299,722 20 1 .000.000 27.48% 93.203 1.093.203 1.092 203 27.47% -17.305 1.075.998 1,075,898 27.23% 43,116 1,119,013 1,119,013 25.95% 4.5421 1.123.555 1,123,555 25.94% 75.335 1,198,890 92.500 2.54% 9.621 101.121 101.121 2.54% -1.601 99.521 32.500 122.021 3.34% 5,291 137,311 3.18% + 137.868 127.868 3.18% 147,113 CANCIONE 100,000 2.75% 9,3201 109,320 109,320 2.75% -1,731 107,590 107,590 2.72% 4,312 111.901 111.901 2.60% 1 112,355 | 112.355 2.59% 119.899 50.000 1.37% 4,660 54,660 54.660 1.37% -865 53.795 52.795 1.36% 2.156 55,951 55,951 1.30% 227156, 178 56,178 13051 59.9441 300.000 3.24% 27,961 327,961 327.961 9.24% -5.1921 322.769 322,769 8 .17% 12.935 335,704 7.79% 1.3621 337,066 337.066 7.78% 22.601 359.6671 30 100.000 2.75% 9.320 109.3201 109.220 2.75% 1.731 107.590| 107.5901 2.72% 4.3121 111.901 1 2 .60% 454 112.355 112.355 2.59% H 01 0.00% 0 0 0.00% 125.000 125.000 2.90% 507 125.507 125,507 2.90% 8,415 133.923 0 0,00% 0 0 ol 0.00% 0 0 0,00% 0 0 75.000 1 7 5.000 1.74% 30475 304 75.304 1.74% 5.0491 90.354 1.60% 65,546 1.66% R 172 3 128 71 310 1 65% 289 7 1,600 1,000 72.600 1.68% 4.868 77,467 38 3 .639.087 100.00% 339.172 3.978.259 1.250 3.979.509 100.00% -62.994 3.916.515 3 4.156 3.950.671 100,00% 158.320 4.108.991 203.1384 .312.128 100,00% 17,501 4.329.630 1 .000 4.330.630 100.00% 290.372 4,621,002 39 40 339,1721 -62,994 158,320 17,501 AS AT AU AV AW AX AY AZ RA BC BD BE BF BG BH BI BJ B K BL BM BN BO BP Ending 5 6 7 Ending Balance 09/30/13 1,030,914 Contribution 09/30/13 Ending Balance 09/30/13 1,030,914 Withdrawal 1 0/01/13 income Allocation 10/31/13 16.151 Ending Balance 10/31/13 1.047.065 % 10/01/13 2 2.49% Contribution 10/31/13 Income Allocation 11/30/13 94.300 Balance 10/31/13 1.047.065 Ending Balance 1 1/30/13 1.141.365 % 10/31/13 22.47% Ending Balance 11/20/13 1.141.365 Income Allocation 12/21/13 36,256 Contribution 1 1/30/13 Ending Balance 12/31/13 1.177.621 Contribution 12/31/13 09/30/13 22.30% Ending Balance 12/21/13 1.177.621 10/01/13 1.030.9141 2013 Income Allocation 445.4921 2012 GP Allocation -22.274 11/20/13 22.47% 10 36,558 36,558 0.79% -36,558 0.00% 0 0.00% | 0 0.00% 0 12,452 6 23 11 438.7169.49% 9.57% 6.8731 445.599 40.1301 485.719 15.429 501.1481 501.148 211.864 -10.593 396,625 8.58% 1 396.625 8.65% 6.214 402.839 36.280 439.119 439.119 9.65% 13.949 453.068 453,068 179,077 -8,954 14 15 16 17 121.3302 .63% 1 2.65% 1,901 123.231 2.65% 11,098 134.3301 134,330 2.64% 22671 138.597 138,5971 38,597 -1.930 299,722 6.48% 299,722 6.54% 4.696 304,418 27,416 331.834 6.53% 10,541 342.375 342,375 92.375 -4.619 19 1.198.9901 25.94% 1.198.8901 26.149 18.782 1.217.673 1.217.673 26.14% 109.665 1.327.237 1.327.2371 26.139 42,163 1,369,501 1.369.501 369.501 -18,475 21 22 147.113 3.18% 147.113 3.21% 2,305 149,417|| 3.21% 13.457 162,874 162.874 3.21% 5.174 168.048 168,048 49.0491 -2,152 23 24 119,899 119.899 2.59% 119.889 2,61% 1,878 121,767 121,767 2,61% 10.966 132.734 132,734 2,61% 4.216 136,950 136,950 36,950 1.848 25 59.944 59.944 1.30% 59,944 1.31% 939 60.884 5,483 66.367 66.3671 1.31% 68,475 68,475 18,475 -924 26 27 28 359,667 359.667) 7.79% 359.667) 7.84% 5.6351 365.3021 7.84% 32.999 398.201 398.2011 7.84% 410.850 410,850 110.850 -5.543 30 119.8 119.899 2.59% 119.899 2.61% 1.878 121.7671 121,767 2.61% 10.966 132,734 132.7341 2.61% 136.9501 136,950 36,950 1948 123.923 123.9231 2.90% 123.9231 2.92% 2,098 136,021 2.92% 12,250 148.271 148.271 2.92% 152.981 152.981 27.981 1,399 34 90.3541 1.74% 90.354 1.75% 1.259 81,612 1.75% 7.850 88,963 88,963 1.75% 2826 91,789 91.789 16.789 35 77.467 1 .000 78.4671 1.70% 558 79.025 1.72% 1.238 90.263 1.0001 91 2631 1.74% 7.319 38 582 1.000 99.5821 1.76% 2.846 9 2,428 1,058 93.486 34,416 1.721 37 38 4.621.00 1,000 4,622,001 100.00% -36,000 4,586,001 100.00% 71.848 4.657,849 1 ,000 4,658,849 100.00% 419.5901 5.078.4301 1.000 5.079.4301 100.00% 161.3505.240,780 1.674 806 -83.740 39 71.948 161,3501 1,674,806 41 42 BP BO BR BS BT BU NOWN 2013 Balance 2013 GP Allocation Liquidating Cont/ With 2013 Cont/ Allocation Allocation 22,274 250.000 623 35.935 11 10.593 13 8.9541 444.1141 100,000 14 15 16 1,930 136,6671 100,000 17 18 4,619 337,7561 250,000 19 20 18.4751 1,351.026 1.000.000 21 2.152 165,895 125,000 -1,848 135.1031 100,000 67,551 50,000 wNaN NNNN 405,308 300,000 -1.840 100,000 1.3991 125.000 90.9491 75,000 36 1.721 8 3,740 -623 1 74.883 18.534 37 83,740 0 5241 R2R 2.557 599 3883,740 39 N O P 2 OWNERSHIP 3 December 31, 2014 Beginning income % Allocation 01/01/14 1 01/21/14 2 2.04% -2.941 Ending Balance 01/21/14 1.152.406 Contribution 01/21/14 Ending Balance 01/21/14 1.152.406 Allocation 02/28/14 78.439 Contribution 02/28/14 Ending Balance 02/28/14 1.230.845 Balance 02/28/14 1.230.845 Contribution 03/01/14 Ending Balance 03/01/14 1.230.845 income Ending Allocation Balance 1 03/31/14 03/31/14 55.9801 1.286.726 Contribution 03/31/14 01/01/14 1.155.347 Ending Balance 03/31/14 1.286.7261 01/21/14 2 1.62% 02/28/14 21.62% 03/01/14 21.629 03/31/14 21.61% 490.555 9 ,36% 1,249 489,306 489,306 9.18% 33, 305 5 22,611 522.611 9.19% 522,611 9.18% 23,727 546,338 546,338 9.18% 5 6 7 8A 9 10 C 11 12 D 13 14 E 15 16 F 17 444.1141 9.47% 1.1301 442,984 442.9941 9 .31% 30.1521 473.135 473,135 8.31% 473.135 9.31% 21.480 494.616 494.61619.31% 126.6671 2.61% -348 136.3191 136,319 2.56% 9.279 145.598 145,598 145.598 2.56% 6.610 152,208 152,208 2.56% 337,756 6.44% 860 336.896 6 .32% 22.9311 359.8271 359.8271 359.82716 .32% 16.336 3 76,163 376.163 6.32% 18 G 1,351,026 25.77% -3,439 1,347,587 1,347,587 25.29% 91.724 1.439.311 1,439,311 25.28% 65.345 1,504,656 1,504,656 25.28% 19 20 H 165.895 3.16% 3.10% 11,263 176,736 176.7361 3.10% 176.7361 3.10% 8.024 184,760 184.7601 3.10% 21 22 125.103 2.59% -344 134.759 2.53% 9,172 143,932 2.53% 143.9322 .53% 6,535 150,466 150.4661 2.53% 23 247 67,551 1.29% 172 67,379 67,379 1.26% 4,586 7 1.965 71.9651 1.26% 71.965 0 0.00% 0 0 0 0.00% 405,308 1,032 7.59% 27,517 431.794 431.7947 .58% 19.603 451.2971 7.58% 125.103 2.59% -344 134.759 124.7591 2.53% 9.1721 143.932 143.9321 2.53% 143.932 2.53% 6.5351 150.466 150.4661 2.53% 151.591 2.99% 286 151 1951 151.195 2 .84% 10,291 161,496 2.84% 161.496 2.84% 7,331 25 26 K 27 28 L 29 30 M 31 32 IN 33 34 ] 2014 Trust 35 36 General Partner 168.818|| 168.8182841 2321 90.717 90,717 1.70% 6,175 96,892 96.2921 1.70% 96,892 1.70% 4.399 101,291 101.2911.70% 0.00% 0.00% 71,965 7 1,965 1.26% 3.2671 75,232 1.26% -445 174.438 101.092 275.530 5.17% 19.7541 294.294 1.1101295.29415.19% 295.294 5.19% 13,411 308,805 1,1861 309,991 5.21% 37 5.241.838 100.00% -13.342 5.228.496 101.092 5.329.588 100.00% 362.760 5.692.348 1.1101 5.692.458 100.00% 0 5.693.458 100.00% 258.493 5.951.942 1 .1865.953.128 100.00% 38 39 40 -13,342 258,483 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP T AQ AR AS 4 Ending 5 6 7 Income Allocation 04/30/14 -32,788 Ending | Balance 04/30/14 1,253,938 Contribution 0 4/30/14 Ending Balance 0 4/30/14 1,253,938 Income Allocation 05/31/14 -25,737 Ending Balance 05/31/14 1,228,201 Contribution 05/31/14 Balance 05/21/14 1,228,201 Income Allocation 05/21/141 06/20/14 2 1.57% 44,299 04/30/14 21.58% Ending Balance 0 6/20/14 1,272,500 Contribution 06/20/14 Endine Balance 0 6/20/14 1,272,500 Income Ending Allocation Balance 07/21/14 07/21/14 -68.9351 1.203.565 % 06/20/14 21.56% Contribution 07/21/14 Ending Balance 07/21/14 1,203,565 07/31/32 % 07/21/14 21.55% 07/31/24 Income Allocation 08/21/14 44,011 02/22/1,01 1,247,576 Ending Balance Contribution 08/21/141 08/21/14 1,247,576 Ending Balance 08/21/14 1,247.5761 8 9 10 -13,921 532.416 532.4169 .16% -10.928 521.498 521.4981 9.16% 18.909 540.298 540.2981 9.15% -29.270 511.028 511.0281 9.15% 18.687 529.7151 529,715 11 12,603 482,012 482,012 8.29% -9,893 472.119 472.119 8 .29% 17.029 499.148 489,148 8.29% -26,499 462,649 462,649 3.28% 16,918 479,567 479,567 -3.978 148.329 148,329 2.55% -3,044 145,285 145.285 2.55% 5.2401 150,525 -8,154 142,371 142,371 2.55% 5,206 147,577 147,577 -9,585 366,578 366,578 6.31% 7,524 359,054 359,054 6 ,31% 12,951 372,005 372,005 6 .30% 20,153 351,852 351,852 6.30% 12,866 364,718 364,7181 -39.341 1.466.315 1,466,315 25.23% -30,096 1,436,219 1,436, 219 25.22% 51.9021 1.498.021 1,488,021 25.21% -80,611 1,407,411 1,407,411 25.20% 51,465 1,458,876 1,458,876 180,052 180,0521 3.10% -3.696 176.356 176,356 3.10% 6,361 182.717 182,717 3.10% -9,898 172,819 172,819 3.09% 6,319 179,138 179.1381 -3.934 146.632 1 146.632 2.52% -3,010 143,622 143,622 2.52% 5,180 148,803 148,803 2.52% -8,061 140,742 140,742 2.52% 5,147 145,888 145,888 0 0 0 1 0.00% 0 0.00% 0 0 0.00% 0 0 ol 00 -24,183 422,223 11.502 4 39.895 439.895 7.57% -9,029 430.866 430,866 7.57% 15.541 446,407 446,407 7.56% 422.223 7.56% 15.440 437.663 437,6631 28 -3.834 146,632 146.632 146,632 2.52% 2.52% 3,010 143,622 143,622 2.52% 5,1801 148,803 148,803 2.52% -8,061 140,742 140,742 2.52% 5,147 145,838 145,888 4.302 164.5161 164.516 2.83% 3,377 161,139 161,139 2.83% 5,812 166.951 166,951 2.83% -9,044 157,907 157.9071 2.83% 5,774 163,681 163.691 29 30 31 32 33 -2,581 98,710 99.7101 1.70% 96,684 1.70% 3.487 100,171 100,171 1.70% 5,427 94,745 94.745 1.70% 3,465 98,209 98.209 34 -1.917 7 2.315 73.315 1.26% 1,505 71.810 71.910 1 .26% 2.590 74.400 74.400 1.26% 4.030 70.370 70,370 1.26% 2,573 72,943 72.943 35 36 7,899 302,092 10.126 312.219 5.37% 6,408 305,810 2 ,061 307.871 5.41% 11,104 318,975 3,520 3 22,495 5.46% -17,471 305,025 1,230 306,255 5.48% 11,199 317,4541 1,223 318,677 -151.694 5.801.434 1 0126 5.811.560 100.00% 119.282 5.692.2771 2 .061 5.694.238 100.00% 205.397) 5.899.725 3,520 5,903,245 100.00% 319,796 5,583,448 1.230 5.584.678 100.00% 204,216) 5.788.994 1 .223 5.790.118 37 38 39 40 -151,694 119.283 5.692.277|| 205,387 5,899,725 -319,796 5,543,448 204,216 5,788,894 AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ B K BL BM BN BO BP BQ 3 2014 5 6 7 % 08/31/149 2 1.55% Income Allocation /31/2014 -35,044 Ending Balance 9/31/2014 1.212.532 Contribution 9/31/2014 Ending Balance 9/31/2014 1.212.5321 Income Ending Allocation Balance 1 0/31/14 10/31/14 71.7621 1.284.294 Contribution 10/31/14 Balance 10/31/14 1.284.2941 Ending Balance 11/30/14 1.340.2941 Allocation 11/30/14 56.001) Contribution 12/01/14 09/30/14 21.54% Ending Balance 12/01/14 1.340.294 Income Ending Allocation Balance 12/21/14 12/31/14 65.6781 1.405.973 | 2014 GP Allocation -12.531 2014 GP Allocation % 12/01/14 21.53% Liquidating Cont/ With 10/31/14 2 1.54% 11/30/14 21.54% Allocation 250.6261 8 9 .15% -14,880 514,835 514,835 9.15% 30.470 545.305 545.305 9.14% 22.778 569.093 9.14% 569,083 9 .14% 27.887 596.970 9 10 11 12 5,321 9.29% -13.471 466.096 466.0961 9.29% 27,585 493.691 493.6911 9.29% 21.527 515.2081 9.29% 515.209 9.29% 25.2471 540.4541 4817 13 14 2 .55% 4.145 143.431 143,431 2.55% 8.489 151,920 151.920 2.55% 6.624 158.545 2.55% 158.545 2 .55% 7.769 166.314 29.647 1.482 15 .30% 354.4741 6.30% 20,979 375,452 375.452 6.30% 16.371 391.8241 6.30% 391.824 6 ,30% 19,200 411,024 3.663 166 17 18 25.20% 40,980 1,417.896 1,417 896 25.19% 83,916 1,501,812 1,501,812 25.19% 65,486 1.567,298 25.1996 1,567,298 25.18% 76,802 1,644,100 14,654 19 20 174,106 3.09 10.3041 184.4101 184.4101 3.09% 9.0411 192.4511 3.09% 192.451 3.09% 9.431 201.892 -4.098 141.7901 150, 1821 2.52% 6,549| 156,730 156,730 2 .52% 7,680 164,410 1,465 NNNNNN 01 0.00% o 0 0,00% 0 0 0,00% 0 0.00% 0 0 -221 7.56% -12.294 4 25.369 425,3691 450,544 7.56% 19,646 470,190 470,190 7 .55% 23,041 493.230 26 271 28 29 30 2.52% -4.098 141.7901 2.52% 8,392 150,182 150.192 2.52% 6.549 156.7301 2.52% 156.7301 2.52% 7.690 164.4101 2.83% -4.598 159,094 159.0842 .83% 168.499 168,499 9,4151 2.3% 2.3471 175.846 175.846 2 .83% 8.617 184.463 31 1.70% 95.451 1.70% 5,649 101,100 101.100 1.70% 4.4081 105.508 1.70% 105.508 1.70% S,170 110,678 -996 1.26% -2,049 70,894 70.994 1.26% 4,196 75,090 75,090 1.26% 3,274 78,364 1.26% 78,364 1.26% 3,840 82,204 32 33 34 35 36 37 38 5.50% -8.952 309.7251 1.206 310.9321 5.52% 18.4021 329.3341 1.173 220 AC 320.506 E EA 5.54% 14.4121 144122140191 344.918 SAT 5.54% 1 242 246 1601 5.56% 16.962 363.122 63.070 3,153 58,111 100,00% 162.6445.627.474 1.206 5.628.680 100.00% 333.125 5.961.805 1 .173 5.962.977 100.00% 260.0126.222.989 100.00% 1.242 6.224.231 100.00% 305.005 6.529.236 1.162.228 -59.111 5 8.111 39 40 162,644 5,627,474 333,125 5,961,804 260,012 6,222,989 305,005 6,529,236 1,162,228 BO BR BS BT 5 Balance 2014 Liquidating Cont/ Cont 7 with Allocation 1293.441 Der 10 591,649 11 12 525.637 164,831 14 15 407,361 16 17 1,629,446 19 20 200,083 21 488,834 NNNNNNNNMMMMMMM Nima lo NM 182.819 109,692 81,472 71.745 418.0811 125.1701 6,529.236 125,170 Resource Date Ending Balance 7/31/11 7/31/11 7/31/11 7/31/11 500,000.00 25,000.00 300,000.00 0.00 General Partners
