Spreadsheet: 21671d1209454915-simple-operations-dont-work-finmod-080403-for-excel-forum
Sheet: Calc

D:\Data\Wingarra BMI\Clients active\Legenis\[Finmod 080403 for Excel Forum.xls]Calc
2008-04-29 17:40:43
Financial model | #N/A | to | #N/A
Calculation Schedule
Foundation FUM profiles by wealth bands
Month |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
FUM
Band 1 |  | 187500 | 188671.875 | 189851.07421875 | 191037.6434326172 | 192231.628704071 | 193433.0763834715 | 194642.0331108682 | 195858.5458178111 | 197082.6617291724 | 198314.4283649797 | 199553.8935422609 | 200801.1053769 | 383853.120364223 | 386252.2023664994 | 388666.27863129
Band 2 |  | 375000 | 377343.75 | 379702.1484375 | 382075.2868652344 | 384463.2574081421 | 386866.152766943 | 389284.0662217364 | 391717.0916356222 | 394165.3234583449 | 396628.8567299595 | 399107.7870845217 | 401602.2107538 | 767706.240728446 | 772504.4047329988 | 777332.55726258
Band 3 |  | 625000 | 628906.25 | 632836.9140625 | 636792.1447753906 | 640772.0956802368 | 644776.9212782383 | 648806.7770362273 | 652861.8193927037 | 656942.2057639081 | 661048.0945499325 | 665179.6451408695 | 669337.017923 | 1279510.401214077 | 1287507.341221665 | 1295554.2621043
Band 4 |  | 875000 | 880468.75 | 885971.6796875 | 891509.0026855469 | 897080.9339523315 | 902687.6897895336 | 908329.4878507182 | 914006.5471497852 | 919719.0880694714 | 925467.3323699057 | 931251.5031972176 | 937071.8250922002 | 1791314.561699708 | 1802510.277710331 | 1813775.96694602
Band 5 |  | 1125000 | 1132031.25 | 1139106.4453125 | 1146225.860595703 | 1153389.772224426 | 1160598.458300829 | 1167852.198665209 | 1175151.274906867 | 1182495.970375035 | 1189886.570189879 | 1197323.361253565 | 1204806.6322614 | 2303118.722185338 | 2317513.214198996 | 2331997.67178774
Band 6 |  | 1375000 | 1383593.75 | 1392241.2109375 | 1400942.718505859 | 1409698.610496521 | 1418509.226812124 | 1427374.9094797 | 1436296.002663948 | 1445272.852680598 | 1454305.808009851 | 1463395.219309913 | 1472541.4394306 | 2814922.882670969 | 2832516.150687662 | 2850219.37662946
Band 7 |  | 1625000 | 1635156.25 | 1645375.9765625 | 1655659.576416016 | 1666007.448768616 | 1676419.99532342 | 1686897.620294191 | 1697440.73042103 | 1708049.734986161 | 1718725.045829825 | 1729467.077366261 | 1740276.2465998 | 3326727.0431566 | 3347519.087176329 | 3368441.081471181
Band 8 |  | 1875000 | 1886718.75 | 1898510.7421875 | 1910376.434326172 | 1922316.28704071 | 1934330.763834715 | 1946420.331108682 | 1958585.458178111 | 1970826.617291724 | 1983144.283649798 | 1995538.935422609 | 2008011.053769 | 3838531.20364223 | 3862522.023664995 | 3886662.786312901
Band 9 |  | 2125000 | 2138281.25 | 2151645.5078125 | 2165093.292236328 | 2178625.125312805 | 2192241.53234601 | 2205943.041923173 | 2219730.185935193 | 2233603.499597288 | 2247563.521469771 | 2261610.793478957 | 2275745.8609382 | 4350335.364127861 | 4377524.960153661 | 4404884.491154621
Band 10 |  | 2375000 | 2389843.75 | 2404780.2734375 | 2419810.150146484 | 2434933.9635849 | 2450152.300857306 | 2465465.752737664 | 2480874.913692274 | 2496380.381902851 | 2511982.759289743 | 2527682.651535304 | 2543480.6681074 | 4862139.524613491 | 4892527.896642325 | 4923106.19599634
Band 11 |  | 3750000 | 3773437.5 | 3797021.484375 | 3820752.868652344 | 3844632.574081421 | 3868661.52766943 | 3892840.662217364 | 3917170.916356222 | 3941653.234583449 | 3966288.567299595 | 3991077.870845218 | 4016022.107538 | 7677062.407284461 | 7725044.047329989 | 7773325.572625802
Band 12 |  | 15000000 | 15093750 | 15188085.9375 | 15283011.47460938 | 15378530.29632568 | 15474646.11067772 | 15571362.64886945 | 15668683.66542489 | 15766612.93833379 | 15865154.26919838 | 15964311.48338087 | 16064088.430152 | 30708249.62913784 | 30900176.18931996 | 31093302.29050321
Earnings
Band 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Band 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 392706.240728446
Band 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 654510.4012140767
Band 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 916314.5616997075
Band 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1178118.722185338
Band 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1439922.882670969
Band 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1701727.0431566
Band 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1963531.20364223
Band 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2225335.364127861
Band 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2487139.524613491
Band 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3927062.407284461
Band 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15708249.62913784
Inflation allowance
Band 1 |  | 187500 | 187968.75 | 188438.671875 | 188909.7685546875 | 189382.0429760742 | 189855.4980835144 | 190330.1368287232 | 190805.962170795 | 191282.977076222 | 191761.1845189125 | 192240.5874802098 | 192721.1889489104 | 193202.9919212826 | 193847.0018943536 | 194493.1585673348
Band 2 |  | 375000 | 375937.5 | 376877.34375 | 377819.537109375 | 378764.0859521484 | 379710.9961670288 | 380660.2736574464 | 381611.92434159 | 382565.954152444 | 383522.3690378251 | 384481.1749604197 | 385442.3778978207 | 386405.9838425653 | 387694.0037887071 | 388986.3171346695
Band 3 |  | 625000 | 626562.5 | 628128.90625 | 629699.228515625 | 631273.476586914 | 632851.6602783813 | 634433.7894290773 | 636019.87390265 | 637609.9235874066 | 639203.9483963752 | 640801.9582673662 | 642403.9631630345 | 644009.9730709421 | 646156.6729811786 | 648310.5285577825
Band 4 |  | 875000 | 877187.5 | 879380.46875 | 881578.919921875 | 883782.8672216797 | 885992.3243897338 | 888207.3052007082 | 890427.82346371 | 892653.8930223692 | 894885.5277549252 | 897122.7415743126 | 899365.5484282484 | 901613.962299319 | 904619.34217365 | 907634.7399808955
Band 5 |  | 1125000 | 1127812.5 | 1130632.03125 | 1133458.611328125 | 1136292.257856445 | 1139132.988501087 | 1141980.820972339 | 1144835.77302477 | 1147697.862457332 | 1150567.107113475 | 1153443.524881259 | 1156327.133693462 | 1159217.951527696 | 1163082.011366121 | 1166958.951404009
Band 6 |  | 1375000 | 1378437.5 | 1381883.59375 | 1385338.302734375 | 1388801.648491211 | 1392273.652612439 | 1395754.33674397 | 1399243.72258583 | 1402741.831892295 | 1406248.686472025 | 1409764.308188206 | 1413288.718958676 | 1416821.940756073 | 1421544.680558593 | 1426283.162827122
Band 7 |  | 1625000 | 1629062.5 | 1633135.15625 | 1637217.994140625 | 1641311.039125977 | 1645414.316723792 | 1649527.852515601 | 1653651.67214689 | 1657785.801327257 | 1661930.265830575 | 1666085.091495152 | 1670250.30422389 | 1674425.929984449 | 1680007.349751064 | 1685607.374250235
Band 8 |  | 1875000 | 1879687.5 | 1884386.71875 | 1889097.685546875 | 1893820.429760742 | 1898554.980835144 | 1903301.368287232 | 1908059.62170795 | 1912829.77076222 | 1917611.845189125 | 1922405.874802098 | 1927211.889489103 | 1932029.919212826 | 1938470.018943535 | 1944931.585673347
Band 9 |  | 2125000 | 2130312.5 | 2135638.28125 | 2140977.376953125 | 2146329.820395508 | 2151695.644946496 | 2157074.884058863 | 2162467.57126901 | 2167873.740197183 | 2173293.424547676 | 2178726.658109045 | 2184173.474754317 | 2189633.908441203 | 2196932.688136007 | 2204255.797096461
Band 10 |  | 2375000 | 2380937.5 | 2386889.84375 | 2392857.068359375 | 2398839.211030273 | 2404836.309057849 | 2410848.399830494 | 2416875.52083007 | 2422917.709632145 | 2428975.003906225 | 2435047.441415991 | 2441135.060019531 | 2447237.89766958 | 2455395.357328478 | 2463580.008519573
Band 11 |  | 3750000 | 3759375 | 3768773.4375 | 3778195.37109375 | 3787640.859521484 | 3797109.961670288 | 3806602.736574464 | 3816119.2434159 | 3825659.54152444 | 3835223.690378251 | 3844811.749604196 | 3854423.778978207 | 3864059.838425652 | 3876940.037887071 | 3889863.171346694
Band 12 |  | 15000000 | 15037500 | 15075093.75 | 15112781.484375 | 15150563.43808594 | 15188439.84668115 | 15226410.94629786 | 15264476.9736636 | 15302638.16609776 | 15340894.761513 | 15379246.99841679 | 15417695.11591283 | 15456239.35370261 | 15507760.15154828 | 15559452.68538678
Distributions
Band 1 | 5702.991921282635 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Band 2 | 11405.98384256527 |  |  |  |  |  |  |  |  |  |  |  |  | 11405.98384256527
Band 3 | 19009.9730709421 |  |  |  |  |  |  |  |  |  |  |  |  | 19009.9730709421
Band 4 | 26613.96229931898 |  |  |  |  |  |  |  |  |  |  |  |  | 26613.96229931898
Band 5 | 34217.95152769587 |  |  |  |  |  |  |  |  |  |  |  |  | 34217.95152769587
Band 6 | 41821.94075607276 |  |  |  |  |  |  |  |  |  |  |  |  | 41821.94075607276
Band 7 | 49425.92998444941 |  |  |  |  |  |  |  |  |  |  |  |  | 49425.92998444941
Band 8 | 57029.91921282606 |  |  |  |  |  |  |  |  |  |  |  |  | 57029.91921282606
Band 9 | 64633.90844120318 |  |  |  |  |  |  |  |  |  |  |  |  | 64633.90844120318
Band 10 | 72237.89766957983 |  |  |  |  |  |  |  |  |  |  |  |  | 72237.89766957983
Band 11 | 114059.8384256521 |  |  |  |  |  |  |  |  |  |  |  |  | 114059.8384256521
Band 12 | 456239.3537026085 |  |  |  |  |  |  |  |  |  |  |  |  | 456239.3537026085
Donations
Band 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187500
Band 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 375000
Band 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 625000
Band 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 875000
Band 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1125000
Band 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1375000
Band 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1625000
Band 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1875000
Band 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2125000
Band 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2375000
Band 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3750000
Band 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000000