Spreadsheet: 75831d1276432149-excel-2007-creating-a-professional-looking-budget-template-budget-template-cumulative-
Sheet: Budget

 | April | May | June | July | August | September | October | November | December | January | February | March
Sales:
-Income Stream 1 | 2200000 | 4400000 | 6600000 | 7040000 | 9240000 | 11440000 | 14960000 | 18480000 | 22880000 | 29480000 | 36080000 | 44000000
-Income Stream 2 | 1000000 | 1800000 | 2300000 | 3800000 | 4800000 | 5300000 | 5800000 | 6300000 | 6800000 | 7800000 | 8800000 | 10000000
-Income Stream 3 | 2700000 | 5400000 | 7650000 | 9900000 | 12150000 | 14400000 | 16200000 | 18000000 | 18000000 | 18000000 | 18000000 | 18000000
-Income Stream 4 | 3203850 | 6204185 | 8704800 | 10705695 | 12454715 | 13953875 | 15154815 | 16154255 | 17347135 | 17750135 | 18951075 | 20150000
-Income Stream 5 | 2295000 | 4395000 | 6195000 | 7695000 | 8995500 | 10095000 | 11095500 | 11901000 | 12849000 | 13194000 | 14094000 | 15000000
-Income Stream 6 | 83300 | 166600 | 249900 | 333200 | 416500 | 499800 | 583100 | 666400 | 749700 | 833000 | 916300 | 1000000
-Income Stream 7 | 24376587.2 | 48753174.4 | 73129761.6 | 97941645 | 122753528.4 | 151047781.4 | 190224439.4 | 233754059.4 | 281636641.4 | 303401451.4 | 364342919.4 | 435296200
-Income Stream 8 | 3450000 | 6950000.000000001 | 10450000 | 14500000 | 18550000 | 22600000 | 26750000 | 30900000 | 35250000 | 40000000 | 45000000 | 50000000
-Income Stream 9 | 749700 | 1499400 | 2249100 | 2998800 | 3748500 | 4498200 | 5247900 | 5997600 | 6747300 | 7497000 | 8246700 | 9000000
-Income Stream 10 | 606200 | 1212400 | 1818600 | 3124800 | 4431000 | 5877200 | 7323400 | 8769600 | 10215800 | 11382000 | 12688200 | 14000000
-Income Stream 11 | 3500000 | 7000000 | 11200000 | 16100000 | 21420000 | 27020000 | 33320000 | 40320000 | 48020000 | 52220000 | 60620000 | 70000000
-Income Stream 12 | 16637500 | 32343300 | 47782900 | 61758400 | 73870500 | 83986100 | 91972100 | 100224300 | 108476500 | 116728700 | 124980900 | 133100000
-Income Stream 13 | 5200200 | 9886800 | 14091900 | 17590800 | 20576100 | 22566300 | 24556500 | 26065200 | 27573900 | 29082600 | 30591300 | 32100000
-Income Stream 14 | 0 | 0 | 2524997 | 10099988 | 22724973 | 40399952 | 65649922 | 98474883 | 136349838 | 161599808 | 204524757 | 252499700
-Income Stream 15 | 12602765.7 | 25282691.19 | 38579895 | 52545816.99 | 67900615.2 | 85184408.16 | 107200668.24 | 132149000.34 | 145008965.34 | 177158877.84 | 213732618.3 | 257199300
Total Customer Spend
Commission:
-Income Stream 1 | 22000 | 44000 | 66000 | 70400 | 92400 | 114400 | 149600 | 184800 | 228800 | 294800 | 360800 | 440000
-Income Stream 2 | 10000 | 18000 | 23000 | 38000 | 48000 | 53000 | 58000 | 63000 | 68000 | 78000 | 88000 | 100000
-Income Stream 3 | 27000 | 54000 | 76500 | 99000 | 121500 | 144000 | 162000 | 180000 | 180000 | 180000 | 180000 | 180000
-Income Stream 4 | 32038.5 | 62041.85000000001 | 87048 | 107056.95 | 124547.15 | 139538.75 | 151548.15 | 161542.55 | 173471.35 | 177501.35 | 189510.75 | 201500
-Income Stream 5 | 22950 | 43950 | 61950 | 76950 | 89955 | 100950 | 110955 | 119010 | 128490 | 131940 | 140940 | 150000
-Income Stream 6 | 833 | 1666 | 2499 | 3332 | 4165 | 4998 | 5831 | 6664 | 7497 | 8330 | 9163 | 10000
-Income Stream 7 | 243765.872 | 487531.744 | 731297.616 | 979416.4500000001 | 1227535.284 | 1510477.814 | 1830477.814 | 2210477.814 | 2610477.814 | 2810477.814 | 3310477.814 | 3910477.814
-Income Stream 8 | 34500.00000000001 | 69500.00000000001 | 104500 | 145000 | 185500 | 226000 | 267500 | 309000 | 352500 | 400000 | 450000 | 500000
-Income Stream 9 | 7497 | 14994 | 22491 | 29988 | 37485 | 44982 | 52479 | 59976 | 67473 | 74970 | 82467 | 90000
-Income Stream 10 | 6062 | 12124 | 18186 | 31248 | 44310 | 58772 | 73234 | 87696 | 102158 | 113820 | 126882 | 140000
-Income Stream 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
-Income Stream 12 | 166375 | 323433 | 477829 | 617584 | 738705 | 839861 | 919721 | 1002243 | 1084765 | 1167287 | 1249809 | 1331000
-Income Stream 13 | 52002 | 98868 | 140919 | 175908 | 205761 | 225663 | 245565 | 260652 | 275739 | 290826 | 305913 | 321000
-Income Stream 14 | 0 | 0 | 25249.97 | 100999.88 | 227249.73 | 403999.52 | 603999.52 | 853999.52 | 1153999.52 | 1353999.52 | 1703999.52 | 2103999.52
-Income Stream 15 | 126027.657 | 252826.9119 | 385798.95 | 525458.1699 | 679006.152 | 851844.0815999999 | 1021844.0816 | 1201844.0816 | 1271844.0816 | 1471844.0816 | 1701844.0816 | 2035844.0816
Gross Income
Expenditure:
-Expenditure Type 1 | 164901.53613728 | 329803.07227456 | 494704.60841184 | 659606.14454912 | 863702.7190898319 | 1067799.293630544 | 1271895.868171256 | 1475992.442711968 | 1680089.01725268 | 1884185.591793392 | 2088282.166334104 | 2292378.740874816
-Expenditure Type 2 | 35800 | 70200 | 105200 | 141000 | 176800 | 209800 | 244200 | 280000 | 297600 | 314600 | 331600 | 350400
-Expenditure Type 3 | 9466.666666666668 | 18933.33333333334 | 28400 | 37866.66666666667 | 47333.33333333334 | 56800.00000000001 | 66266.66666666669 | 75733.33333333336 | 85200.00000000003 | 94666.6666666667 | 104133.3333333334 | 113600
-Expenditure Type 4 | 750 | 1500 | 2250 | 3000 | 3750 | 4500 | 5250 | 6000 | 6750 | 7500 | 8250 | 9000
-Expenditure Type 5 | 1800 | 6600 | 8400 | 10200 | 12000 | 16800 | 18600 | 20400 | 22200 | 27000 | 28800 | 30600
-Expenditure Type 6 | 5000 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 55000 | 60000
Total Expenditure
Gross Profit