Type of advertising 2019 2020 2021

Billboards 28,800,000.00 30,090,240.00 31,438,282.75

Total Advertising Budget 28,800,000.00 30,090,240.00 31,438,282.75

7 days USD 15,600 + 10% VAT 17,160.00

Inflation rate 4.48 0.0448
 2022 2023 2024
32,846,717.82 34,318,250.78 $ 35,855,708.41
32,846,717.82 34,318,250.78 $ 35,855,708.41

68,640.00 4 campaign per year

 Start-up costs
Market Research 450,000
Company Registration Cost 250,000.00
License 125,000.00
Domain Registration 20,000.00
Intellectual property protecti 200,000.00
Trademark 465,000.00
Lawyer Fees 1,200,000.00
Accounting Fees 250,000.00
Transporation for paperwork 200,000.00
Rental Cost 600,000.00
Office Phone 1,440,000.00
Guide's phone 4,860,000.00
Internet 900,000.00
Microsoft Lisence 375,000.00
Microsoft Server 750,000.00
Program For application 1,875,000.00
Softwares 3,000,000.00
Employee Insurance 16,380,000.00
Training 1,800,000.00
3 office Desks 675,000.00
Salaries of 7 Employees 122,400,000.00
3 Office Chairs 337,500.00
6 guest Chairs 450,000.00
Website 1,200,000.00
Office Insurance 5,400,000.00
Water of Lebanon 360,000.00
Municipality Fees 285,000.00
Electricity 600,000.00
Mobile App Development 9,750,000.00
Total Start-up Costs 176,597,500.00
 Demand Forecast
Customer Analysis using Chain Ratio Method
Number of people in Lebanon (Millions) 6,089,000
Average number of members per household 4
Number of households 1,522,250
Percentage of individuals who might use the app 45%
Households who might use the app 685,013
Innovators & early adopters % 16%
Innovators (2.5%) and early adopters (13.5%) 109,602
Potential market share size 20%
Year 1 forecasted demand 21,920
Year 2 forecasted demand 26,304 20%
Year 3 forecasted demand 31,039 18%
Year 4 forecasted demand 34,143 10%
Year 5 forecasted demand 37,558 10%
Assumption 10% growth rate
 Y1 Y2 Y3 Y4
Service Price/hour 20,000 20,000 20,000 20,000
Variable Cost/unit 5,924 4,944 4,198 3,824
Contribution Margin/unit 14,076 15,056 15,802 16,176

Fixed costs 72,580,000 74,464,780 76,429,563 78,477,914

Break Even Point (in units) 5,156

Break Even Point (in LBP) 103,127,075
 Y5
20,000
3,480
16,520

80,613,553
 Guidie
Y1 Y2 Y3
Variable Expenses
Variable Selling and Administrative
Guide's Phone Cost 4,860,000 4,900,000 5,000,000
Variable land line subscription 1,440,000 1,504,512 1,571,914
Electricity prorated for administrative 600,000 660,000 726,000
Drinking water 200,000 208,960 218,321
Salaries 122,400,000 122,400,000 122,400,000
Water Of Lebanon 360,000 370,000 386,576
Total Variable selling and administrative 129,860,000 130,043,472 130,302,812
Total Variable Costs 129,860,000 130,043,472 130,302,812
VC/Unit 5,924.16 4,943.78 4,198.00
Y1 Y2 Y3
Fixed Expenses
Fixed selling and administrative
Advertisement 28,800,000 30,090,240 31,438,283
Rent 7,200,000 7,228,800 7,257,715
Audit fees 4,000,000 4,000,000 4,000,000
Employee Insurance (7 Employees) 16,380,000 16,461,900 16,544,210
Office Insurance 5,400,000 5,400,000 5,400,000
DSL internet subscription 10,800,000 11,283,840 11,789,356
Total Fixed Costs 72,580,000 74,464,780 76,429,563
 Y4 Y5

5,100,000 5,050,000
1,642,336 1,715,913
798,600 878,460 from the gov
228,102 238,321
122,400,000 122,400,000
403,895 421,989
130,572,933 130,704,683
130,572,933 130,704,683
3,824.27 3,480.12 21,780,000
Y4 Y5

32,846,718 34,318,251
7,286,746 7,315,893
4,000,000 4,000,000
16,626,931 16,710,065
5,400,000 5,400,000
12,317,519 12,869,344
78,477,914 80,613,553
 Sales forecasts
Y1 Y2 Y3
Forecasted demand 21,920 26,304 31,039
Service Price (Min 6 hours a day) 120,000 120,000 120,000
Revenues 2,630,448,000 3,156,537,600 3,724,714,368
 Y4 Y5
34,143 37,558
120,000 120,000
4,097,185,805 4,506,904,385
 Statement of comprehensive income - IFRS Adopted
2020 2021
Sales 2,630,448,000 3,156,537,600
Less Cost of Goods Sold 30,000,000.00 60,000,000.00
Gross Profit 2,600,448,000 3,096,537,600
Distribution Costs
Rent 7,200,000 7,228,800
Total Distribution Costs 7,200,000 7,228,800
Administrative Costs
Salaries Of 7 Employees 122,400,000 122,400,000
Advertising/Promotion 28,800,000 30,090,240
DSL internet subscription 10,800,000 11,283,840
Guide's Phone fees 4,860,000 4,900,000
Land line subscription fees 1,440,000 1,504,512
Audit fees 4,000,000 4,000,000
Office Insurance 5,400,000 5,400,000
Employee Insurance 16,380,000 16,461,900
Electricity prorated for administration 600,000 660,000
Water 360,000 370,000
Total Administrative Costs 72,640,000 74,670,492
Total Distribution and Administrative Costs 79,840,000 81,899,292
Operating Profit 2,520,608,000 3,014,638,308
Earnings Before Tax 2,520,608,000 3,014,638,308
Tax Expense (17%) 428,503,360 512,488,512
Net Income for the year 2,092,104,640 2,502,149,796
ome - IFRS Adopted
2022
3,724,714,368
70,000,000.00
3,654,714,368

7,257,715
7,257,715

122,400,000
31,438,283
11,789,356
5,000,000
1,571,914
4,000,000
5,400,000
16,544,210
726,000
386,576
76,856,338
84,114,054
3,570,600,314
3,570,600,314
607,002,053
2,963,598,261
 Statement of financial position
2020 2021

ASSETS- Non Current Assets

Property, plant, and equipment 1,462,500 1,462,500
Less: Accumalated Depreciation 23,400 46,800
Net property, plant, and equipment 1,439,100 1,415,700
Intangible assets 947,092,031 941,064,964
Total Non-Current Assets 948,531,131 942,480,664
Current Assets
Prepaid insurance 21,780,000 21,861,900
Prepaid rent 7,200,000 7,228,800
Accounts receivable, net 789,134,400 946,961,280
Cash 30,449 79,703
Total Current Assets 818,144,849 976,131,683
Total Assets 1,766,675,980 1,918,612,347
Equity&Liabilities
Total Partners' Capital 1,745,675,980 1,876,612,347
Current Liabilities
Accounts payable 21,000,000 42,000,000
Total Current Liabilities 21,000,000 42,000,000
Total Liabilities 21,000,000 42,000,000
Total Liabilities and Partners' Equity 1,766,675,980 1,918,612,347
2022

1,462,500
70,200
1,392,300
1,123,508,445
1,124,900,745

21,944,210
7,257,715
1,117,414,310 30%
181,716 70%
1,146,797,951
2,271,698,696

2,222,698,696 75% Retained

49,000,000 70%
49,000,000
49,000,000
2,271,698,696
 2020 2021 2022
Liquidity
Current Ratio 38.9593 23.2412 23.4040
Quick Ratio 37.5793 22.5486 22.8081
Cash Ratio 0.0014 0.0019 0.0037
Solvency Ratio
Debt-to-assets Ratio 0.0119 0.0219 0.0216
Debt-to-equity Ratio 0.0120 0.0224 0.0220
Equity multiplier 1.0120 1.0224 1.0220
Efficiency
Accounts Receivable turnover 3.33 3.33 3.33
Days sales outstanding 110 110 110
Total assets turnover 1.4889 1.6452 1.6396
Fixed asset turnover 0.5369 0.4912 0.4952
Profitability
Return On Investment 80% 79% 80%
Gross Profit Margin 0.9886 0.9810 0.9812
Operating profit margin 0.9582 0.9550 0.9586
Net profit margin 0.7953 0.7927 0.7957
ROA 1.1842 1.3041 1.3046
Operating ROA 1.4268 1.5713 1.5718
ROE 1.1984 1.3333 1.3333