Proforma Balance Sheet
Proforma Balance Sheet
Proforma Balance Sheet
LIABILITIES
Shareholders' Funds
Equity Share Capital 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000
Reserves (843,672) 1,787,107 4,996,760 8,045,767 10,744,886 13,849,700 17,306,515
Loan Funds
Rupee Loans - - - - - - -
Foreign Currency Loans - - - - - - -
Deposit from Franchisees 750,000 1,000,000 1,050,000 1,100,000 1,150,000 1,200,000 1,250,000
Bank Borrowings for Working Capital - - - - - - -
ASSETS
Gross Fixed Assets 611,164 618,414 625,699 633,019 640,379 647,784 655,234
Less: Accumulated Depreciation 123,325 220,250 297,225 358,829 408,572 449,148 482,627
Net Fixed Assets 487,839 398,164 328,474 274,190 231,807 198,636 172,607
Margin for Bank Gurantee 722,459 2,054,156 2,625,052 2,979,832 3,355,269 3,751,305 4,171,664
Net Current Assets 964,936 1,790,117 2,096,654 2,387,419 2,623,480 2,976,302 3,368,992
Cash & Bank Balances 118,806 1,085,454 3,690,436 6,351,254 8,684,329 11,123,457 13,843,253
Miscellaneous Expneses
Net Loss - - - - - -
Pre-Launch Expenses 612,288 459,216 306,144 153,072 - -
Debt Equity Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Annexure
PROFORMA CASH FLOW STATEMENT
(ZMK in '000)
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
SOURCES
Net Cash Accurals (567,275) 2,880,776 3,439,700 3,263,682 2,901,934 3,145,391 3,490,294
Equity Share Capital 3,000,000 - - - - - -
Term Loans
Zambian Kwacha Loans - - - - - - -
Foreign Currency Loans - - - - - - -
Deposits from Franchisees 750,000 250,000 50,000 50,000 50,000 50,000 50,000
Working Capital
TOTAL INFLOW 3,182,725 3,130,776 3,489,700 3,313,682 2,951,934 3,195,391 3,540,294
USES
Debt Service Coverage Ratio (4.34) 18.38 24.48 27.59 30.35 33.27 35.44
Finance Charges & Depreciation 258325 276925 265975 259604 256743 256576 258479
0.49% 0.18% 0.14% 0.12% 0.10% 0.09% 0.08%
Profit Before Taxation -843672 4835887 7914142 9452583 10948042 12593676 14020672
-1.60% 3.21% 4.11% 4.32% 4.44% 4.57% 4.57%
Profit After Taxation -843672 3030852 4360942 5203083 6024819 6930391 7716104
-1.60% 2.01% 2.27% 2.38% 2.44% 2.51% 2.52%
Revenue Projections
Amount in ZMK '000
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Retailers Network at Beginning of Year 0 750 1000 1050 1100 1150 1200
Retailers appointed during the Year 750 250 50 50 50 50 50
Retailers at the end of Year 750 1000 1050 1100 1150 1200 1250
Average No. of Retailers 375 875 1025 1075 1125 1175 1225
No. of Operational Days 313 313 313 313 313 313 313
Avg. Sale per Retailer per day 450 550 600 650 700 750 800
Monthly Lottery
Sale 5281875 11297344 15399600 17496700 19719000 23445656 26072900
Price Payout 52.0% 52.0% 52.0% 52.0% 52.0% 52.0% 52.0%
Prize Payout 2746575 5874619 8007792 9098284 10253880 12191741 13557908
Net Revenue 2535300 5422725 7391808 8398416 9465120 11253915 12514992
Festival Bumper
Sale 3961406.25 11297344 14437125 17496700 20951438 24824813 27606600
Price Payout 43% 43% 43% 43% 43% 43% 43%
Prize Payout 1703404.6875 4857858 6207964 7523581 9009118 10674669 11870838
Net Revenue 2258001.5625 6439486 8229161 9973119 11942319 14150143 15735762
Gross Revenue from Lottery 52818750 150631250 192495000 218708750 246487500 275831250 306740000
Gross Weight of Tickets to be 20,618 62,437 71,945 81,632 81,283 90,649 98,567
Cost per Delivery of 1 kg Pack 10.72 11.80 12.98 14.26 15.66 17.26 18.98
Total Delivery Cost 221,095 736,492 933,509 1,164,251 1,272,582 1,565,032 1,870,845
Cost as % of Sales 0.42% 0.49% 0.48% 0.53% 0.52% 0.57% 0.61%
System Administration & Maintenance
Annual Inflation Index 1.00 1.10 1.21 1.33 1.46 1.61 1.77
Amount in Zambian Kawcha
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
% of Sys Adm & Main/revenue 1.75% 1.75% 1.75% 1.75% 1.75% 1.75% 1.75%
Fixed Asset Additions 611164000 7250000 7285000 7320000 7360000 7405000 7450000
Cumulative Fixed Asset 611164000 618414000 625699000 633019000 640379000 647784000 655234000
AMC Repairs & Maintenance 1,222,328 1,700,639 1,892,739 2,525,746 2,804,860 3,650,263 4,059,175
Assumptions
Gross Revenue in ZMK'000 52818750 150631250 192495000 218708750 246487500 275831250 306740000
Gaming SW dev & maint 1.75% of rev 1.75% of rev 1.75% of rev 1.75% of rev 1.75% of rev 1.75% of rev 1.75% of rev
AMC Repairs & Maintenance 0.2% of FA 0.25% of FA 0.25% of FA 0.3% of FA 0.3% of FA 0.35% of FA 0.35% of FA
Retail Costs
Amount in ZMK '000
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Area Stockist Commission 528,188 1,506,313 1,924,950 2,187,088 2,464,875 2,758,313 3,067,400
Marketing Expenditure
Media
Television 841,521 892,000 945,500 973,900 1,003,100 1,033,200 1,064,200
Radio 85,488 90,600 96,000 101,800 107,900 114,400 117,800
Print Media 266,490 282,500 299,500 317,500 336,600 356,800 367,500
Others 100,000 106,000 112,400 119,100 126,200 133,800 137,800
1,293,499 1,371,100 1,453,400 1,512,300 1,573,800 1,638,200 1,687,300
Sales Retailer Support 39,200 41,600 44,100 46,700 49,500 51,000 52,500
Market Research 7,840 8,300 8,800 9,300 9,900 10,200 10,500
Communications 19,600 20,800 22,000 23,300 24,700 25,400 26,200
Public Relations 14,700 15,600 16,500 17,500 18,600 19,200 19,800
Agency Fee 194,025 205,700 218,000 231,100 245,000 252,400 260,000
Misc/Contingencies 24,500 26,000 27,600 29,300 31,100 32,000 33,000
1,593,364 1,689,100 1,790,400 1,869,500 1,952,600 2,028,400 2,089,300
3.02% 1.12% 0.93% 0.85% 0.79% 0.74% 0.68%
Launch Expenditure
Market Reseach Game Design 15,000 5,000 1,000 1,000 1,000 1,000 1,000
Advertising Concept/Testing 12,000 4,000 200 100 100 100 100
Sales/Retailer Support Play Station 20,000 6,700 1,400 1,400 1,400 1,400 1,400
Sales Portfolio 10,000 3,400 200 100 100 100 100
Communications POS Display Material/Kiosk 300,000 100,000 20,000 20,000 20,000 20,000 20,000
Merchandise 8,000 2,700 600 600 600 600 600
Launch Event 12,500 4,167 833 - - - -
Agency Fee 20,000 6,667 1,333 - - - -
Administrative Costs
Amount in ZMK '000
Units Rate Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Inflation Index 1.00 1.10 1.21 1.33 1.46 1.61 1.77
Office Operations
Training Expenses 5 2500 12,500 13,750 15,125 16,625 18,250 20,125 22,125
Vehicle Expenses 3 9600 28,800 31,680 34,848 38,304 42,048 46,368 50,976
Membership & Subscriptions 1 10000 10,000 - - - - - -
Computer Consumables 5 5000 25,000 27,500 30,250 33,250 36,500 40,250 44,250
Office Supplies 5 2500 12,500 13,750 15,125 16,625 18,250 20,125 22,125
Printing & Stationery 5 1200 6,000 6,600 7,260 7,980 8,760 9,660 10,620
Repair & Maintenance 5 2400 12,000 13,200 14,520 15,960 17,520 19,320 21,240
Postage & Freight 5 800 4,000 4,400 4,840 5,320 5,840 6,440 7,080
Books & Periodicals 5 500 2,500 2,750 3,025 3,325 3,650 4,025 4,425
License fees -
Telephone Charges 5 4000 20,000 22,000 24,200 26,600 29,200 32,200 35,400
Telecom One time cost 2 21146 42,292 - - - - - -
Telecom Charges 2 120000 240,000 264,000 290,400 319,200 350,400 386,400 424,800
Insurance of fixed assets 12,223 13,605 15,142 16,838 18,699 20,859 23,195
Insurance of Man Power 20,100 31,230 34,353 37,788 41,567 73,615 50,296
Audit and Legal fees 30,000 33,000 36,300 39,900 43,800 48,300 53,100
Security Expense 120,000 132,000 159,720 212,428 310,144 499,332 883,818
Total Administrative Cost 4,105,834 5,791,906 6,412,594 7,096,600 7,885,415 8,869,545 10,062,813
Cost as % of Sales 7.77% 3.85% 3.33% 3.24% 3.20% 3.22% 3.28%
Staffing and Remuneration
Amount in ZMK in '000
Rate Rate Nos. Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
p.m. p.a.
CEO 25,000 300,000 1 300,000 330,000 363,000 399,300 439,230 483,153 531,468
Face value of the Tickets sold 52818750 150631250 192495000 218708750 246487500 275831250 306740000
Prize Payment 26369761 74976705 95814386 108763861 122467314 136922633 152265736
Charitable to Good causes 11752172 33515453 42830138 48662697 54843469 61372453 68249650
Retailers cost 5810063 16569438 21174450 24057963 27113625 30341438 33741400
Net Sale receipts including VAT 8886755 25569655 32676026 37224229 42063092 47194727 52483214
Rate of VAT 17.50% 17.50% 17.50% 17.50% 17.50% 17.50% 17.50%
VAT Collection from sale of lottery Tickets 1323559 3808246 4866642 5544034 6264716 7029002 7816649
VAT Collection 1323559 3808246 4866642 5544034 6264716 7029002 7816649
LESS:
VAT Credit on Capital Goods 106954 1269 1275 1281 1288 1296 1304
Depreciation Schedule
(As Per Companies Act)
Amount in ZMK
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Addition
Dep. Rate % Block
10.00% 125,000,000 6,250,000 6,270,000 6,290,000 6,315,000 6,345,000 6,375,000
20.00% 214,314,000 1,000,000 1,015,000 1,030,000 1,045,000 1,060,000 1,075,000
25.00% 271,850,000 - - - - - -
Total 611,164,000 7,250,000 7,285,000 7,320,000 7,360,000 7,405,000 7,450,000
Depreciation
10.00% 12,500,000 11,562,500 11,032,250 10,557,025 10,131,573 9,751,415 9,412,274
20.00% 42,862,800 34,390,240 27,713,692 22,375,454 18,107,863 14,696,790 11,970,932
25.00% 67,962,500 50,971,875 38,228,906 28,671,680 21,503,760 16,127,820 12,095,865
Total 123,325,300 96,924,615 76,974,848 61,604,159 49,743,196 40,576,025 33,479,071
Accumulated Depreciation
10.00% 12,500,000 24,062,500 35,094,750 45,651,775 55,783,348 65,534,763 74,947,037
20.00% 42,862,800 77,253,040 104,966,732 127,342,186 145,450,049 160,146,839 172,117,771
25.00% 67,962,500 118,934,375 157,163,281 185,834,961 207,338,721 223,466,541 235,562,406
Total 123,325,300 220,249,915 297,224,763 358,828,922 408,572,118 449,148,143 482,627,214
Depreciation
10.00% 12,500,000 11,875,000 11,314,500 10,812,050 10,362,345 9,960,611 9,602,049
25.00% 54,178,500 40,633,875 30,475,406 22,856,555 17,142,416 12,856,812 9,642,609
50.00% 77,225,000 39,112,500 20,063,750 10,546,875 5,795,938 3,427,969 2,251,484
60.00% 69,000,000 27,600,000 11,040,000 4,416,000 1,766,400 706,560 282,624
Total 212,903,500 119,221,375 72,893,656 48,631,480 35,067,099 26,951,952 21,778,766
Accumulated Depreciation
10.00% 12,500,000 24,375,000 35,689,500 46,501,550 56,863,895 66,824,506 76,426,555
25.00% 54,178,500 94,812,375 125,287,781 148,144,336 165,286,752 178,143,564 187,786,173
50.00% 77,225,000 116,337,500 136,401,250 146,948,125 152,744,063 156,172,032 158,423,516
60.00% 69,000,000 96,600,000 107,640,000 112,056,000 113,822,400 114,528,960 114,811,584
Total 212,903,500 332,124,875 405,018,531 453,650,011 488,717,110 515,669,062 537,447,828
Franchisee Deposit
Start Of Period - 750,000 1,000,000 1,050,000 1,100,000 1,150,000 1,200,000
Add: Deposit During the year 750,000 250,000 50,000 50,000 50,000 50,000 50,000
Repayment During the year - - - - - - -
End of Period 750,000 1,000,000 1,050,000 1,100,000 1,150,000 1,200,000 1,250,000
Finance Charges
Interest on Franchisee Deposit 135,000 180,000 189,000 198,000 207,000 216,000 225,000
Total Interest Charges 135,000 180,000 189,000 198,000 207,000 216,000 225,000
Project Cost Estimates
Amount in ZMR
Units Rate Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
New Terminals 0 0 0 0 0 0 0
Telecom Infracture
Modem cost 2 1200000 2,400,000 - - - - -
Network Control Centre
Server 1 15000000 15,000,000
LNS / router/NW 0 2000000 -
Peripherals 0 500000 -
LAN at server colocation 0 700000 -
Server at central office 0 400000 -
Telephone system 0 725000 -
Lottery Application software
Server end application-retail 1 - - - - - - -
Server end application-gaming 1 -
Server end application-back office 1 - - - - - - -
Terminal end application 1000 3300 - - - - - - -
Licensed software -servers 1 - - - - - - -
Licensed software -terminals 1000 Incl in terml cost - - - - - -
Customization & Integration - - - - - - - -
Terminals
POS Terminals 0 80000 - - - -
Terminal Installation 0 1700 - - - -
Other Fixed Assets
Motor Cars 3 50000000 150,000,000 - - - - - -
Tata Delivery Van - 207 DI 1 64314000 64,314,000
Computers 10 6500000 65,000,000 - - - - - -
Software 10 2000000 20,000,000 - - - - - -
Other Software 1 15000000 15,000,000 - - - - - -
Printers 3 3250000 9,750,000 - - - - - -
Office LAN 1 7500000 7,500,000 - - - - - -
Peripherals 1 16200000 16,200,000 - - - - - -
GSM Phones 5 2000000 10,000,000 - - - - - -
Security Gadgets 1 81000000 81,000,000
Office EPABX 1 10000000 10,000,000 - - - - - -
448,764,000 - - - - - -
Ongoing Capital Expenses
Leasehold Improvements 25,000,000 1,250,000 1,255,000 1,260,000 1,270,000 1,285,000 1,300,000
Furniture & Fixtures 100,000,000 5,000,000 5,015,000 5,030,000 5,045,000 5,060,000 5,075,000
Machinery & Equipments 20,000,000 1,000,000 1,015,000 1,030,000 1,045,000 1,060,000 1,075,000
145,000,000 7,250,000 7,285,000 7,320,000 7,360,000 7,405,000 7,450,000
Total Fixed Assets 611,164,000 7,250,000 7,285,000 7,320,000 7,360,000 7,405,000 7,450,000
Margin for Bank Guarantee
Reserve for Prize Stabilization Fund 722,459,204 1,331,697,089 570,895,385 354,780,140 375,437,068 396,036,113 420,359,000
Deposits & Guarantees
Secutity Deposit 1 25000000 25,000,000 - - - - - -
Telephone Deposits 5 500000 2,500,000 - - - - - -
Premise Deposits 3 50000000 150,000,000 - - - - - -
177,500,000 - - - - - -
Working Capital 787,435,900 825,180,700 306,537,400 290,764,700 236,061,700 352,821,800 392,689,300
PROJECT COST 2,298,559,104 2,164,127,789 884,717,785 652,864,840 618,858,768 756,262,913 820,498,300
Total Project Cost 8,195,889,500
Annexure
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Profit (Before Tax) (843,672) 4,835,887 7,914,142 9,452,583 10,948,042 12,593,676 14,020,672
ADD: Depreciation As per Companies Act 123,325 96,925 76,975 61,604 49,743 40,576 33,479
Deferred Marketing expenses 153,072 153,072 153,072 153,072 153,072 - -
LESS: Depreciation As per Income Tax Act 212,904 119,221 72,894 48,631 35,067 26,952 21,779
Marketing Expenditure incurred - during pre incorporation 765,360
(780,178) 4,813,590 7,918,223 9,465,555 10,962,718 12,607,300 14,032,372
Net Income/ (Loss) (780,178) 4,033,412 7,918,223 9,465,555 10,962,718 12,607,300 14,032,372
Total Provision for Income Tax - 1,805,035 3,553,200 4,249,500 4,923,223 5,663,285 6,304,567
Fixed Assets
Rate of Rate
-----------------------------------------------------------------------Additions
of during the year----------------------------------------------------------------
Depre. Depre. Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
(Co. Act) (I. Tax)
Telecom Infracture
Modem cost 25.00% 25.00% 2,400,000 - - - - - -
V SAT 25.00% 25.00% - -
Network Control Centre
Server 25.00% 60.00% 15,000,000
LNS / router/NW 25.00% 60.00% -
Peripherals 25.00% 60.00% -
LAN at server colocation 25.00% 100.00% -
Server at central office 25.00% 100.00% -
Telephone system 25.00% 100.00% -
Lottery Application software
Server end application-retail 33.33% 100.00% - - - - - - -
Server end application-gaming 33.33% 100.00% - - - - - - -
Server end application-back office 33.33% 100.00% - - - - - - -
Terminal end application 33.33% 100.00% - - - - - - -
Licensed software -servers 33.33% 100.00% - - - - - - -
Licensed software -terminals 33.33% 100.00% - - - - - - -
Customization & Integration 0 33.33% 100.00% - - - - - - -
Terminals
POS Terminals 33.33% 100.00% - - - - - - -
Terminal Installation 33.33% 100.00% - - - - - - -
Other Fixed Assets
Motor Cars 20.00% 25.00% 150,000,000 - - - - - -
Tata Delivery Van - 207 DI 20.00% 25.00% 64,314,000
Computers 25.00% 60.00% 65,000,000 - - - - - -
Software 25.00% 60.00% 20,000,000 - - - - - -
Other Software 25.00% 60.00% 15,000,000 - - - - - -
Printers 25.00% 50.00% 9,750,000 - - - - - -
Office LAN 25.00% 50.00% 7,500,000 - - - - - -
Peripherals 25.00% 50.00% 16,200,000 - - - - - -
GSM Phones 25.00% 50.00% 10,000,000 - - - - - -
Security Gadgets 25.00% 50.00% 81,000,000
Office EPABX 25.00% 50.00% 10,000,000 - - - - - -
448,764,000 - - - - - -
Ongoing Capital Expenses
Leasehold Improvements 10.00% 10.00% 25,000,000 1,250,000 1,255,000 1,260,000 1,270,000 1,285,000 1,300,000
Furniture & Fixtures 10.00% 10.00% 100,000,000 5,000,000 5,015,000 5,030,000 5,045,000 5,060,000 5,075,000
Machinery & Equipments 25.00% 50.00% 20,000,000 1,000,000 1,015,000 1,030,000 1,045,000 1,060,000 1,075,000
145,000,000 7,250,000 7,285,000 7,320,000 7,360,000 7,405,000 7,450,000
Total Addition 611,164,000 7,250,000 7,285,000 7,320,000 7,360,000 7,405,000 7,450,000
Annexure
Ratios
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
Return on Equity (%) -39% 63% 55% 47% 44% 41% 38%
Return on Capital Employed (%) -32% 124% 117% 94% 90% 78% 67%
Debt Service Coverage Ratio (4.34) 18.38 24.48 27.59 30.35 33.27 35.44
Details of Assumptions
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7
General Inflation Index 1.00 1.10 1.21 1.33 1.46 1.61 1.77
Gross Revenue Face value of the tickets sold is taken as Gross
Revenue
Net Revenue Sale price of the Tickets to the Distributors is
taken as the Net Revenue. i.e., the net revenue
is equal to the Gross Revenue less Distributors
and Retailers Margin
Prize Money Prize money is the total of the prize payouts of
the Individual Games as per the scheme. 49.93% 49.78% 49.78% 49.73% 49.69% 49.64% 49.64%
Contribution towards Charitable Contribution is arrived @ 25% on
Good Causes the Net Revenue. Gross Revunue 52818750000 150631250000 192495000000 218708750000 246487500000 275831250000 306740000000
Retailing Cost 5810062500 16569437500 21174450000 24057962500 27113625000 30341437500 33741400000
Net Revenue 47008687500 134061812500 171320550000 194650787500 219373875000 245489812500 272998600000
Contribution to Good
Causes 11752171875 33515453125 42830137500 48662696875 54843468750 61372453125 68249650000
Draw Expenses ZMK 2500000 is taken as the estimated expenses for conductiing a Draw.
Distribution Cost Total Kilo Grams of the Tickets to be
despatched 20617.96 62437.12 71945.01 81632.36 81283.10 90649.35 98567.06
Cost of Delivery per Year in ZMK'000 10.72 11.80 12.98 14.26 15.66 17.26 18.98
Secutity Deposit Franchisee Deposit Per Terminal (Amount in
Kwacha) 1000000 1000000 1000000 1000000 1000000 1000000 1000000
Cost of Borrowing Rate of Intt.on Franchisee Deposit 18.0% 18.0% 18.0% 18.0% 18.0% 18.0% 18.0%
(At present approximate rate applicable in
Zambia)
Interest on Margin Rate of Interest 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
Money with Bank (At approximate rate as applicable in Zambia)
Dividend Policy % of Allocable Surplus 0% 12% 24% 36% 48% 48% 48%
Bad Debts 0.1% of the Revenue is estimated as the Bad Debts
Taxation Corporate Income Tax Provision made for the Corporate taxation @ 35% of the taxable Income upto ZMK 100 Million and @45% on the
profits in excess of ZMK 100 Millions.
Value Added Taxation
Value added tax is applied at the rate of 17.5% on the net value of gross realisation and Price Payout,
contribution to good causes, retailing cost. The provision is made after adjusting the VAT Credit.
Misc. Expenses First Year's Pre-Launch Expenses, SPV
Registration Expenses and Application Fees 60% of first year's pre-launch expenses, SPV Registration expenses and Application fees have been capitalised
are taken as Misc Expenses and amortised in 5 Equal Instalments.
Depreciation Rate of Depreciation (Co. Act) Schedule as per Companies Act annexed, taken on WDV basis(As per Zambian companies act)
Rate & Method Rate of Depreciation (IT Act) Schedule as per Income Tax Act annexed, taken on WDV basis (As per Zambian Income Tax law)
Distributors & Retailers Tickets with the face value of K1000 will be sold to the distributors at K890 leaving K10 as the profit to the
Margin distributor and K100 to Retailer.