Sample output from COMETS model

Back to the main COMETS page

All figures are in
Euro
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Income 1999 Quarter 1 1999 Quarter 2 1999 Quarter 3 1999 Quarter 4 1999 2000 Quarter 1 2000 Quarter 2 2000 Quarter 3 2000 Quarter 4 2000
Subscriptions         0         0
Transaction-based 8,829,864 10,500,534 12,487,302 14,849,982 46,667,682 17,659,710 21,001,050 24,974,604 29,699,982 93,335,346
Other income         0         0
Less intra-PKI payments (5,023,212) (5,973,637) (7,103,887) (8,447,990) (26,548,726) (10,046,413) (11,947,264) (14,207,775) (16,895,990) (53,097,441)
Total income 3,806,652 4,526,897 5,383,415 6,401,992 20,118,956 7,613,297 9,053,786 10,766,829 12,803,992 40,237,905
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Expenditure
Capital expenditure 1999 Quarter 1 1999 Quarter 2 1999 Quarter 3 1999 Quarter 4 1999 2000 Quarter 1 2000 Quarter 2 2000 Quarter 3 2000 Quarter 4 2000
Location:                    
Equipment 79,200 2,400 22,800 9,800 114,200 10,000 30,600 4,200 17,800 62,600
Furnishings & fittings 21,600 0 0 0 21,600 0 0 0 0 0
Total location costs 100,800 2,400 22,800 9,800 135,800 10,000 30,600 4,200 17,800 62,600
                     
System:                    
Live System 1,448,213 0 0 0 1,448,213 0 0 0 0 0
Standby System 354,473 0 0 0 354,473 0 0 0 0 0
Offsite Contingency 901,343 0 0 0 901,343 0 0 0 0 0
Consultancy 37,000 0 0 0 37,000 0 0 0 0 0
Installation costs 16,000 0 0 0 16,000 0 0 0 0 0
Evaluation 115,857 0 0 0 115,857 0 0 0 0 0
Total system costs 2,872,886 0 0 0 2,872,886 0 0 0 0 0
                     
Total capital expenditure 2,973,686 2,400 22,800 9,800 3,008,686 10,000 30,600 4,200 17,800 62,600
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Other expenditure 1999 Quarter 1 1999 Quarter 2 1999 Quarter 3 1999 Quarter 4 1999 2000 Quarter 1 2000 Quarter 2 2000 Quarter 3 2000 Quarter 4 2000
Location:                    
Moving-in expenses 9,600 0 0 0 9,600 0 0 0 0 0
Rent/rates 252,000 252,000 255,000 256,000 1,015,000 257,000 261,000 261,000 263,000 1,042,000
Total location costs 261,600 252,000 255,000 256,000 1,024,600 257,000 261,000 261,000 263,000 1,042,000
                     
System:                    
Licence, maintenance fees,upgrades 0 126,719 126,719 126,719 380,156 126,719 126,719 126,719 126,719 506,875
Auditing 10,000 0 0 0 10,000 10,000 0 0 0 10,000
Total system costs 10,000 126,719 126,719 126,719 390,156 136,719 126,719 126,719 126,719 516,875
                     
Policies and procedures 40,000 0 0 0 40,000 0 0 0 0 0
                     
Personnel:                    
Salaries 190,845 191,477 238,176 251,437 871,936 270,919 323,432 325,690 353,125 1,273,167
Benefits 32,444 32,551 40,490 42,744 148,229 46,056 54,984 55,367 60,031 216,438
Total personnel costs 223,288 224,029 278,666 294,182 1,020,165 316,975 378,416 381,057 413,156 1,489,605
                     
Expenses 54,600 54,600 67,200 71,400 247,800 75,600 88,200 88,200 96,600 348,600
                     
Operations:                    
Communications 4,800 4,800 6,000 6,400 22,000 6,800 8,400 8,400 9,200 32,800
Utilities 1,440 1,440 1,800 1,920 6,600 2,040 2,520 2,520 2,760 9,840
Cleaning 600 600 750 800 2,750 850 1,050 1,050 1,150 4,100
Stationery etc. 2,400 2,400 3,000 3,200 11,000 3,400 4,200 4,200 4,600 16,400
Total operations costs 9,240 9,240 11,550 12,320 42,350 13,090 16,170 16,170 17,710 63,140
                     
Marketing and PR 112,000 28,000 28,000 28,000 196,000 28,000 28,000 28,000 28,000 112,000
                     
Professional Services:                    
Legal 46,600 1,250 1,250 1,250 50,350 1,250 1,250 1,250 1,250 5,000
Accounting 0 0 0 30,000 30,000 0 0 0 30,000 30,000
Total professional costs 46,600 1,250 1,250 31,250 80,350 1,250 1,250 1,250 31,250 35,000
                     
Liability Insurance 5,000 5,659 6,729 8,002 25,390 9,517 11,317 13,459 16,005 50,297
                     
Contingency 333,689 38,803 41,250 43,177 456,918 41,449 43,089 40,663 45,477 170,677
                     
Total other expenditure 1,096,017 740,299 816,364 871,050 3,523,729 879,599 954,160 956,517 1,037,917 3,828,194
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Profit and Loss account         1999         2000
Operating income         20,118,956         40,237,905
Operating expenditure         (3,523,729)         (3,828,194)
Operating (loss)/profit         16,595,227         36,409,711
                     
Depreciation of fixed assets         (902,606)         (921,386)
Interest (payable)/receivable         31,078         718,265
(loss)/profit before tax         15,723,700         36,206,590
                     
Taxation         (4,559,873)         (10,499,911)
(loss)/profit after tax         11,163,827         25,706,679
                     
Dividends         (3,349,148)         (7,712,004)
Retained Profit/(Loss)         7,814,679         17,994,675
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Balance sheet         1999         2000
ASSETS                    
Fixed assets         2,106,080         1,247,294
                     
Current assets                    
Cash         9,432,781         34,326,366
Debtors         4,267,995         8,535,995
Creditors         (83,156)         (88,387)
Net current assets         13,617,619         42,773,974
                     
Taxation         (4,559,873)         (10,499,911)
Dividends         (3,349,148)         (7,712,004)
Total assets less current liabilities         7,814,679         25,809,354
                     
CAPITAL AND RESERVES                    
Share Capital         0         0
Profit and Loss Account         7,814,679         25,809,354
                     
Total Capital & Reserves         7,814,679         25,809,354
wwwwwwwwwwwwwww 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000 000,000,000
Cashflow analysis 1999 Quarter 1 1999 Quarter 2 1999 Quarter 3 1999 Quarter 4   2000 Quarter 1 2000 Quarter 2 2000 Quarter 3 2000 Quarter 4  
Operating profit 2,710,636 3,786,598 4,567,051 5,530,942   6,733,698 8,099,626 9,810,312 11,766,075  
Net proceeds from shareholders
(Inc)/dec in net current assets (2,349,059) (598,982) (569,069) (667,728)   (814,018) (961,486) (1,142,124) (1,345,142)  
Operating cash flow 361,577 3,187,616 3,997,982 4,863,214   5,919,680 7,138,140 8,668,188 10,420,933  
 
(Inc)/dec fixed assets (2,973,686) (2,400) (22,800) (9,800)   (10,000) (30,600) (4,200) (17,800)  
Corporation tax paid 0 0 0 0   0 0 (4,559,873) 0  
Dividend payable 0 0 0 0   (3,349,148) 0 0 0  
Total expenditure (2,973,686) (2,400) (22,800) (9,800)   (3,359,148) (30,600) (4,564,073) (17,800)  
 
Net movement in cash (2,612,109) 3,185,216 3,975,182 4,853,414   2,560,532 7,107,540 4,104,115 10,403,133  
 
OPENING CASH BALANCE 0 (2,643,944) 515,645 4,514,295   9,432,781 12,093,747 19,347,983 23,652,724  
CLOSING CASH BALANCE (2,612,109) 541,272 4,490,827 9,367,709   11,993,313 19,201,287 23,452,098 34,055,857  
Average cash balance (1,306,055) (1,051,336) 2,503,236 6,941,002   10,713,047 15,647,517 21,400,040 28,854,290  
Interest (payable)/receivable (31,835) (25,626) 23,468 65,072   100,435 146,695 200,625 270,509