BALANCE SHEET | |||||||||||||||||||||||||||||||||||||||||||||||||||
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | |||
Fixed assets | |||||||||||||||||||||||||||||||||||||||||||||||||||
Computer costs | 5,852,778 | 5,899,444 | 5,745,556 | 5,591,111 | 5,436,111 | 5,280,556 | 5,124,444 | 4,948,333 | 4,772,222 | 4,596,111 | 4,420,000 | 4,243,889 | 4,067,778 | 3,891,667 | 3,715,556 | 3,539,444 | 3,363,333 | 3,187,222 | 3,011,111 | 2,835,000 | 2,658,889 | 2,482,778 | 2,306,667 | 2,130,556 | 1,954,444 | 1,778,333 | 1,602,222 | 1,426,111 | 1,250,000 | 1,073,889 | 1,724,167 | 1,524,444 | 1,324,722 | 1,125,000 | 925,278 | 725,556 | 692,500 | 665,000 | 637,500 | 613,889 | 590,278 | 566,667 | 543,056 | 519,445 | 495,834 | 472,223 | 448,612 | 425,001 | |||
Fixtures & fittings | 408,333 | 396,667 | 385,000 | 373,333 | 361,667 | 350,000 | 338,333 | 326,667 | 315,000 | 303,333 | 291,667 | 280,000 | 268,333 | 256,667 | 245,000 | 233,333 | 221,667 | 210,000 | 198,333 | 186,667 | 175,000 | 163,333 | 151,667 | 140,000 | 322,778 | 305,556 | 288,333 | 271,111 | 253,889 | 236,667 | 219,444 | 202,222 | 185,000 | 167,778 | 150,556 | 133,333 | 127,778 | 122,222 | 116,667 | 111,111 | 105,556 | 100,000 | 94,444 | 88,889 | 83,333 | 77,778 | 72,222 | 66,667 | |||
Total fixed assets | 6,261,111 | 6,296,111 | 6,130,556 | 5,964,444 | 5,797,778 | 5,630,556 | 5,462,778 | 5,275,000 | 5,087,222 | 4,899,444 | 4,711,667 | 4,523,889 | 4,336,111 | 4,148,333 | 3,960,556 | 3,772,778 | 3,585,000 | 3,397,222 | 3,209,444 | 3,021,667 | 2,833,889 | 2,646,111 | 2,458,333 | 2,270,556 | 2,277,222 | 2,083,889 | 1,890,556 | 1,697,222 | 1,503,889 | 1,310,556 | 1,943,611 | 1,726,667 | 1,509,722 | 1,292,778 | 1,075,833 | 858,889 | 820,277 | 787,222 | 754,167 | 725,000 | 695,833 | 666,667 | 637,500 | 608,334 | 579,167 | 550,001 | 520,834 | 491,668 | |||
Current assets | |||||||||||||||||||||||||||||||||||||||||||||||||||
Debtors | 0 | 0 | 0 | 0 | 0 | 0 | 2,467,500 | 2,467,500 | 2,115,000 | 655,650 | 675,320 | 695,581 | 730,359 | 766,878 | 805,223 | 845,485 | 887,757 | 932,144 | 997,392 | 1,067,208 | 1,141,910 | 1,221,843 | 1,307,373 | 1,398,889 | 1,398,889 | 1,398,889 | 1,398,889 | 1,398,889 | 1,398,889 | 1,398,889 | 3,249,514 | 3,249,514 | 2,985,139 | 1,890,627 | 1,905,379 | 1,920,575 | 2,086,544 | 2,190,870 | 2,251,946 | 2,315,102 | 2,380,427 | 2,448,009 | 2,531,919 | 2,619,962 | 2,712,380 | 2,809,448 | 2,911,454 | 3,018,711 | |||
Other debtors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
Cash at bank and in hand | 0 | 2,361,264 | (1,648,842) | (3,352,632) | (2,946,374) | (4,482,694) | (6,943,783) | (6,724,007) | (4,694,864) | (3,132,840) | (4,374,267) | (6,258,148) | (6,855,951) | (6,369,063) | (6,223,972) | (6,003,294) | (6,030,947) | (5,645,660) | (5,170,893) | (5,019,311) | (4,291,485) | (3,413,152) | (2,970,476) | (1,755,970) | (354,828) | 132,222 | 1,527,813 | 3,007,716 | 3,650,662 | 5,154,343 | 6,670,091 | 8,569,166 | 13,787,613 | 19,206,897 | 21,054,988 | 24,168,402 | 27,370,400 | 30,777,584 | 34,510,963 | 38,480,005 | 42,646,996 | 47,019,795 | 51,606,603 | 56,430,941 | 61,518,741 | 66,884,332 | 72,542,929 | 78,510,707 | 84,804,866 | ||
Deferred expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
Current assets | 2,361,264 | (1,648,842) | (3,352,632) | (2,946,374) | (4,482,694) | (6,943,783) | (4,256,507) | (2,227,364) | (1,017,840) | (3,718,617) | (5,582,828) | (6,160,369) | (5,638,704) | (5,457,095) | (5,198,071) | (5,185,461) | (4,757,903) | (4,238,749) | (4,021,920) | (3,224,277) | (2,271,242) | (1,748,634) | (448,597) | 1,044,061 | 1,531,112 | 2,926,702 | 4,406,605 | 5,049,551 | 6,553,232 | 8,068,980 | 11,818,681 | 17,037,127 | 22,192,037 | 22,945,615 | 26,073,781 | 29,290,975 | 32,864,129 | 36,701,833 | 40,731,951 | 44,962,098 | 49,400,222 | 54,054,611 | 58,962,860 | 64,138,703 | 69,596,712 | 75,352,377 | 81,422,162 | 87,823,577 | |||
Current liabilities | |||||||||||||||||||||||||||||||||||||||||||||||||||
Creditors | (2,533,030) | (388,177) | (311,947) | (235,717) | (293,949) | (659,217) | (695,517) | (682,812) | (744,673) | (773,562) | (786,267) | (239,803) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (205,998) | (206,302) | (279,617) | (207,017) | (207,017) | (207,017) | (207,017) | (207,017) | (515,567) | (207,017) | (207,017) | (207,017) | (207,017) | (207,321) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | (208,071) | |||
Accruals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
VAT | 1,465,389 | 1,689,955 | 1,870,420 | 136,365 | 306,418 | 687,784 | (332,635) | (672,620) | (871,817) | 252,215 | 505,922 | 437,456 | (98,381) | (207,641) | (328,322) | (132,674) | (277,940) | (436,428) | (177,923) | (376,642) | (597,613) | (244,781) | (515,039) | (812,381) | (254,929) | (551,857) | (848,786) | (296,929) | (593,857) | (890,786) | (669,679) | (1,517,857) | (2,287,286) | (443,404) | (891,202) | (1,343,350) | (1,844,503) | (2,376,731) | (2,927,151) | (3,496,385) | (4,085,076) | (4,693,899) | (5,327,716) | (5,987,758) | (6,675,329) | (7,391,815) | (8,138,685) | (8,917,504) | |||
PAYE | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (104,883) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (114,426) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (123,969) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | (133,512) | |||
Corporation tax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | (186,056) | (372,112) | (558,168) | (744,224) | (930,280) | (1,116,336) | (1,302,392) | (1,488,448) | (1,674,504) | (1,860,560) | (2,046,616) | (2,232,672) | |||
Deferred income | 0 | 0 | 0 | 0 | 0 | 0 | (4,025,000) | (7,875,000) | (10,975,000) | (11,544,500) | (12,099,585) | (12,639,826) | (13,187,465) | (13,742,875) | (14,306,445) | (14,878,583) | (15,459,712) | (16,050,284) | (16,681,178) | (17,355,220) | (18,075,428) | (18,845,036) | (19,667,506) | (20,546,537) | (21,326,355) | (22,006,962) | (22,588,356) | (23,070,539) | (23,453,509) | (23,737,268) | (27,115,564) | (30,438,399) | (33,249,521) | (34,110,057) | (34,908,464) | (35,645,858) | (36,569,570) | (37,569,865) | (38,571,515) | (39,576,436) | (40,586,686) | (41,604,460) | (42,656,229) | (43,747,732) | (44,885,163) | (46,075,219) | (47,325,139) | (48,642,743) | |||
Current liabilities | (1,172,524) | 1,196,894 | 1,453,589 | (204,235) | (92,414) | (76,317) | (5,158,035) | (9,335,315) | (12,696,373) | (12,170,730) | (12,484,814) | (12,547,056) | (13,606,270) | (14,270,939) | (14,955,191) | (15,331,681) | (16,058,076) | (16,807,135) | (17,179,525) | (18,052,286) | (18,993,465) | (19,410,240) | (20,502,969) | (21,679,645) | (21,984,869) | (22,889,805) | (23,768,128) | (23,698,453) | (24,378,352) | (24,959,039) | (28,424,778) | (32,287,242) | (35,867,793) | (34,884,446) | (36,130,651) | (37,320,498) | (38,941,711) | (40,660,291) | (42,398,418) | (44,158,628) | (45,943,625) | (47,756,277) | (49,627,919) | (51,565,521) | (53,576,579) | (55,669,177) | (57,852,022) | (60,134,501) | |||
NET ASSETS | 7,449,851 | 5,844,163 | 4,231,512 | 2,813,836 | 1,222,671 | (1,389,544) | (3,951,764) | (6,287,679) | (8,626,992) | (10,989,903) | (13,355,975) | (14,183,537) | (14,908,863) | (15,579,700) | (16,192,706) | (16,744,365) | (17,230,980) | (17,648,662) | (17,992,000) | (18,254,897) | (18,430,818) | (18,512,763) | (18,493,232) | (18,365,029) | (18,176,536) | (17,879,214) | (17,470,967) | (16,951,679) | (16,321,231) | (15,579,503) | (14,662,487) | (13,523,448) | (12,166,034) | (10,646,053) | (8,981,037) | (7,170,634) | (5,257,305) | (3,171,235) | (912,300) | 1,528,470 | 4,152,431 | 6,965,001 | 9,972,441 | 13,181,516 | 16,599,300 | 20,233,201 | 24,090,973 | 28,180,743 | |||
Ordinary share capital/long term loan | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | ||
Profit and loss - b/f | 0 | (2,550,149) | (4,155,837) | (5,768,488) | (7,186,164) | (8,777,329) | (11,389,544) | (13,951,764) | (16,287,679) | (18,626,992) | (20,989,903) | (23,355,975) | (24,183,537) | (24,908,863) | (25,579,700) | (26,192,706) | (26,744,365) | (27,230,980) | (27,648,662) | (27,992,000) | (28,254,897) | (28,430,818) | (28,512,763) | (28,493,232) | (28,365,029) | (28,176,536) | (27,879,214) | (27,470,967) | (26,951,679) | (26,321,231) | (25,579,503) | (24,662,487) | (23,523,448) | (22,166,034) | (20,646,053) | (18,981,037) | (17,170,634) | (15,256,749) | (13,169,568) | (10,908,966) | (8,469,863) | (5,847,014) | (3,034,999) | (27,559) | 3,181,515 | 6,599,300 | 10,233,200 | 14,090,973 | |||
Profit and loss - current | (2,550,149) | (1,605,688) | (1,612,650) | (1,417,677) | (1,591,165) | (2,612,215) | (2,562,220) | (2,335,915) | (2,339,313) | (2,362,911) | (2,366,073) | (827,561) | (725,327) | (670,837) | (613,006) | (551,659) | (486,615) | (417,682) | (343,339) | (262,897) | (175,921) | (81,945) | 19,531 | 128,203 | 188,493 | 297,322 | 408,246 | 519,288 | 630,448 | 741,728 | 917,017 | 1,139,039 | 1,357,414 | 1,519,981 | 1,665,016 | 1,810,402 | 1,913,885 | 2,087,181 | 2,260,602 | 2,439,103 | 2,622,849 | 2,812,015 | 3,007,440 | 3,209,074 | 3,417,784 | 3,633,901 | 3,857,772 | 4,089,770 | |||
Rounding difference | |||||||||||||||||||||||||||||||||||||||||||||||||||
7,449,851 | 5,844,163 | 4,231,512 | 2,813,836 | 1,222,671 | (1,389,544) | (3,951,764) | (6,287,679) | (8,626,992) | (10,989,903) | (13,355,975) | (14,183,537) | (14,908,863) | (15,579,700) | (16,192,706) | (16,744,365) | (17,230,980) | (17,648,662) | (17,992,000) | (18,254,897) | (18,430,818) | (18,512,763) | (18,493,232) | (18,365,029) | (18,176,536) | (17,879,214) | (17,470,967) | (16,951,679) | (16,321,231) | (15,579,503) | (14,662,487) | (13,523,448) | (12,166,034) | (10,646,053) | (8,981,037) | (7,170,634) | (5,256,749) | (3,169,568) | (908,966) | 1,530,137 | 4,152,986 | 6,965,001 | 9,972,441 | 13,181,515 | 16,599,300 | 20,233,200 | 24,090,973 | 28,180,743 | ||||
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | (0) | (556) | (1,667) | (3,333) | (1,667) | (555) | 0 | 0 | 0 | 1 | 1 | 1 | 1 |