Front Page

NEXT

Line Of Business Enter Business Type

Company Name Enter name

Country Enter name

Year Ago 2019

Current Year 2020

Exit Date 2030

Currency Enter Currency

Prepared By Enter name

Reviewed By Enter name

Approved By Enter name

 Content
PREV NEXT

P&L Trend The main purpose of the model is to allows user to

easily compare the financial performance result
BS Trend from one period to the next or between actual and
budget without having to look at multiple financial
statements,
CF Trend
This information is the business intelligence
Ratios Trend decision makers use for determining future
business decisions, and to make changes to steer
P&L Comparison1 your company towards more profitability and
efficiency,
P&L Comparison2
Financials and investors can easily look at the
variance column to pinpoint the reason behind the
P&L Comparison3 changes,

BS Comparison The model provides an extensive financial

analysis comparison and has designed to be
CF Comparison useful tools for beginners and advanced financial
professionals.
Ratio Comparison
Very simple to use, the user only needs to fill the
Strategical Plan green cells in the green tabs and the outputs are
updated instantly
Valuation & Analysis

Dashboard Highly versatile and can be used for medium,

small and large enterprises
Assumption All the data should be entered in the green cells to
dynamicly flow into the dark blue sheets
Budget
Very easy to customize it for your business
Actual PY

Actual YTD

Instructions
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
P&L Trend Fiscal Year Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD

PREV NEXT Current Month Actual

Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget

Revenue 1,397,916 1,467,812 1,541,202 1,633,675 1,748,032 1,870,393 2,001,321 2,161,426 2,334,341 2,571,510 2,626,500 2,679,030 16,156,118
Cost of Services 1,044,420 1,144,893 1,202,138 1,274,267 1,311,024 1,402,795 1,500,991 1,577,842 1,704,069 1,851,487 1,891,080 1,943,610 12,162,439
Gross Profit 353,496 322,919 339,064 359,408 437,008 467,598 500,330 583,584 630,272 720,023 735,420 735,420 3,993,679
Gross Margin % 25% 22% 22% 22% 25% 25% 25% 27% 27% 28% 28% 27% 25%

Operating expenses:
Advertising & Marketing 26,162 29,356 15,412 40,842 43,701 37,408 40,027 43,228 93,374 51,430 54,002 56,702 369,510
Salaries and Benefits 68,804 73,391 77,060 81,684 87,402 93,520 120,079 129,685 116,718 154,290 162,005 170,104 848,343
General & Administration 145,374 161,460 169,532 179,704 192,283 224,447 220,145 216,142 256,778 257,151 270,008 283,509 1,765,865
Depreciation and Amortization 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 18,000
Total Operating Expenses 242,340 266,207 264,004 304,230 325,386 357,375 382,251 391,055 468,870 464,871 488,015 512,315 3,001,718
Operating Profit - EBIT 111,156 56,712 75,060 55,178 111,622 110,223 118,079 192,529 161,402 255,152 247,405 223,105 991,961
EBITDA 256,530 218,172 244,592 234,882 303,905 334,670 338,224 408,671 418,180 512,303 517,413 506,614 2,757,826
Other income (expense):
Interest Expenses 2,575 2,575 2,575 2,575 2,575 2,575 2,575 2,575 2,575 2,627 2,627 2,627 23,175
Other Non-operating gains/(losses) 10,300 10,506 10,716 10,930 11,149 11,371 11,599 11,831 12,067 12,555 12,806 13,062 100,469
Total Non-Operating Income (Expense) 12,875 13,081 13,291 13,505 13,724 13,946 14,174 14,406 14,642 15,182 15,433 15,689 123,644
Earnings Before Tax - EBT 98,281 43,631 61,769 41,673 97,898 96,277 103,905 178,123 146,760 239,970 231,972 207,416 868,317
Income Tax 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,000 2,000 2,000 22,500
Net income (loss) 95,781 41,131 59,269 39,173 95,398 93,777 101,405 175,623 144,260 237,970 229,972 205,416 845,817
Net Margin % 7% 3% 4% 2% 5% 5% 5% 8% 6% 9% 9% 8% 5%

Cumulative Profit 95,781 136,912 196,181 235,354 330,752 424,529 525,934 701,557 845,817 1,083,787 1,313,759 1,519,175
BEP (Revenue) 1,009,259 1,269,489 1,260,433 1,444,252 1,356,440 1,485,285 1,585,701 1,501,710 1,790,785 1,714,475 1,798,029 1,923,443
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
BS Trend Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun PY

PREV NEXT Actual

Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget

Current assets:
Inventories 3,929,450 3,823,227 3,731,095 3,616,212 3,554,559 3,487,763 3,425,065 3,433,680 3,407,822 3,536,504 3,585,350 3,605,881 3,432,211
Trade Receivables 7,775,885 7,931,403 8,090,031 8,251,832 8,416,869 8,585,206 8,756,910 8,932,048 9,110,689 9,478,761 9,668,336 9,861,704 9,386,735
Prepayment Accounts & Others 7,923,971 8,082,451 8,244,100 8,408,983 8,577,162 8,748,706 8,923,680 9,102,153 9,284,196 9,659,279 9,852,464 10,049,513 9,565,499
Cash and cash equivalents 436,941 445,680 454,594 463,685 472,960 482,419 492,067 501,909 511,947 532,630 543,284 554,149 527,459
Total current assets 20,066,247 20,282,761 20,519,820 20,740,712 21,021,550 21,304,094 21,597,722 21,969,790 22,314,654 23,207,174 23,649,434 24,071,247 22,911,904

Non-Current Assets
Property,Plant & Equipment 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000 550,000
Accumulated Depreciation (202,000) (204,000) (206,000) (208,000) (210,000) (212,000) (214,000) (216,000) (218,000) (220,000) (222,000) (224,000) (224,000)
Intangible assets 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506 2,270,506
Deferred tax asset 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905 1,854,905
Total Non-Current Assets 4,473,411 4,471,411 4,469,411 4,467,411 4,465,411 4,463,411 4,461,411 4,459,411 4,457,411 4,455,411 4,453,411 4,451,411 4,451,411
Total Assets 24,539,658 24,754,172 24,989,231 25,208,123 25,486,961 25,767,505 26,059,133 26,429,201 26,772,065 27,662,585 28,102,845 28,522,658 27,363,315

Current liabilities:
Payables to banks 1,802,630 1,892,243 1,983,606 2,076,755 2,171,726 2,268,556 2,367,282 2,467,941 2,570,571 2,728,717 2,837,544 2,948,506 2,806,497
Trade payables 1,775,623 1,803,413 1,831,720 1,860,598 1,890,049 1,920,073 1,950,679 1,981,905 2,013,754 2,386,894 2,420,801 2,455,382 1,599,993
Short-term borrowings 787,319 803,065 819,127 835,509 852,219 869,263 886,649 904,381 922,469 959,736 978,931 998,511 950,419
Accrued Payables & Others 610,766 622,982 635,442 648,151 661,114 674,336 687,823 701,579 715,611 744,521 759,411 774,600 737,293
Total current liabilities 4,976,338 5,121,703 5,269,895 5,421,013 5,575,108 5,732,228 5,892,433 6,055,806 6,222,405 6,819,868 6,996,687 7,176,999 6,094,202

Non-Current Liabilities
Long-term borrowings 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516 465,516
Retirement Benefit Obligations 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455 1,290,455
Deferred tax liability 940,555 968,573 996,171 1,024,772 1,054,117 1,083,764 1,113,782 1,144,854 1,176,859 1,209,723 1,243,192 1,277,277 1,277,277
Total Non-current Liabilities 2,696,526 2,724,544 2,752,142 2,780,743 2,810,088 2,839,735 2,869,753 2,900,825 2,932,830 2,965,694 2,999,163 3,033,248 3,033,248

Stockholders’ equity:
Share Capital 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404 558,404
Other reserves 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340 1,005,340
Retained earnings 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 15,205,269 16,670,121
Current Year Result 95,781 136,912 196,181 235,354 330,752 424,529 525,934 701,557 845,817 1,106,010 1,335,982 1,541,398 -
Cumulative Translation Adj. 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000
Total stockholders’ equity 16,866,794 16,907,925 16,967,194 17,006,367 17,101,765 17,195,542 17,296,947 17,472,570 17,616,830 17,877,023 18,106,995 18,312,411 18,235,865
Total liabilities and stockholders’ equity 24,539,658 24,754,172 24,989,231 25,208,123 25,486,961 25,767,505 26,059,133 26,429,201 26,772,065 27,662,585 28,102,845 28,522,658 27,363,315
- - - - - - - - - - - -
Check Verified Verified Verified Verified Verified Verified Verified Verified Verified Verified Verified Verified Verified
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
CF Trend Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD

PREV NEXT Actual

Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget

Cash flows from operating activities:

Net Earnings 93,360 40,302 57,912 38,401 92,988 91,415 98,820 170,877 140,427 226,316 218,704 195,330 824,502
Adjustments For:
+ Depreciation & Amortization 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 18,000
Cash from operation before Working Capital 95,360 42,302 59,912 40,401 94,988 93,415 100,820 172,877 142,427 228,316 220,704 197,330 842,502
(Increase)/Decrease in Trade Receivables (100,585) (150,988) (154,008) (157,088) (160,230) (163,434) (166,703) (170,037) (173,438) (176,907) (180,445) (184,054) (1,396,511)
(Increase)/Decrease in Inventories (100,555) 103,129 89,449 111,537 59,857 64,850 60,872 (8,364) 25,105 (57,611) (46,493) (19,542) 405,880
Increase/(Decrease) in Prepayment Accounts (160,555) (153,864) (156,941) (160,080) (163,281) (166,547) (169,878) (173,275) (176,741) (180,276) (183,881) (187,559) (1,481,162)
Increase/(Decrease) in Trade Payables 30,000 25,736 26,251 26,776 27,312 27,858 28,415 28,983 29,563 30,154 30,757 31,372 250,894
Increase/(Decrease) in Accrued expenses & other liabilities 40,000 39,878 39,695 40,940 41,930 42,484 43,112 44,428 45,628 46,759 47,642 48,542 378,095
Net Cash From Operating activities (196,335) (93,807) (95,642) (97,514) (99,424) (101,374) (103,362) (105,388) (107,456) (109,565) (111,716) (113,911) (1,000,302)
Cash Flow From Investing Activities
Net change in Property and equipment, net - - - - - - - - - - - - -
Acquisition of intangible assets - - - - - - - - - - - - -
Net Cash From Investing Activities - - - - - - - - - - - - -
Cash Flow From Financing Activities
Capital subscription - - - - - - - - - - - - -
Net change in ST/LT borrowings 200,000 102,291 104,296 106,341 108,428 110,558 112,729 114,943 117,202 119,506 121,856 124,253 1,076,788
Net Cash from Financing Activities 200,000 102,291 104,296 106,341 108,428 110,558 112,729 114,943 117,202 119,506 121,856 124,253 1,076,788

Net Increase/(Decrease) in cash 3,665 8,484 8,654 8,827 9,004 9,184 9,367 9,555 9,746 9,941 10,140 10,342 76,486

Cash at the beginning of the Period (*) 431,276 436,941 445,680 454,594 463,685 472,960 482,419 492,067 501,909 522,186 532,630 543,284 4,181,531
Translation adjustmeents 2,000 255 260 264 271 275 281 287 292 503 514 523 4,185
Cash at the End of the Period 436,941 445,680 454,594 463,685 472,960 482,419 492,067 501,909 511,947 532,630 543,284 554,149 4,262,202
Check - - - - - - - - - - - -
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
Ratios Trend Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Full Year

PREV NEXT Full Year

Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget Budget Budget

Return on Invested Capital

Return on Assets (ROA) 0.39% 0.17% 0.24% 0.16% 0.38% 0.37% 0.40% 0.69% 0.56% 0.92% 0.89% 0.78% 5.80%
Return on Equity (ROE) 0.57% 0.24% 0.35% 0.23% 0.56% 0.55% 0.59% 1.03% 0.84% 1.38% 1.33% 1.18% 8.73%

Profitability Ratios
Gross Profit Margin 25.29% 22.00% 22.00% 22.00% 25.00% 25.00% 25.00% 27.00% 27.00% 28.00% 28.00% 27.45% 25.73%
Operating Profit Margin 7.95% 3.86% 4.87% 3.38% 6.39% 5.89% 5.90% 8.91% 6.91% 9.92% 9.42% 8.33% 7.15%
Net Profit Margin 6.85% 2.80% 3.85% 2.40% 5.46% 5.01% 5.07% 8.13% 6.18% 9.25% 8.76% 7.67% 6.32%
EBITDA Margin 18.35% 14.86% 15.87% 14.38% 17.39% 17.89% 16.90% 18.91% 17.91% 19.92% 19.70% 18.91% 17.87%

Liquidity Ratios
Current Ratio 4.03 3.96 3.89 3.83 3.77 3.72 3.67 3.63 3.59 3.40 3.38 3.35 3.35
Quick Ratio 3.24 3.21 3.19 3.16 3.13 3.11 3.08 3.06 3.04 2.88 2.87 2.85 2.85
Cash Ratio 0.09 0.09 0.09 0.09 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08

Capital Structure and Solvency Ratios

Debt to Equity Ratio 0.45 0.46 0.47 0.48 0.49 0.50 0.51 0.51 0.52 0.55 0.55 0.56 0.56
Long-Term Debt to Equity Ratio 0.16 0.16 0.16 0.16 0.16 0.17 0.17 0.17 0.17 0.17 0.17 0.17 0.17
Debt to Total Assets Ratio 0.31 0.32 0.32 0.33 0.33 0.33 0.34 0.34 0.34 0.35 0.36 0.36 0.36

Activity Ratios
Days’ Sales in Receivables 167 164 162 159 156 152 149 145 141 137 133 131 131
Days’ Sales in Inventory 113 106 102 97 94 90 86 83 80 77 75 73 73
Days’ Purchases in Accounts Payable 51 49 48 47 46 45 44 43 42 42 41 41 41
Operating Cycle 280 271 264 256 250 242 235 228 221 214 208 203 203
Cash Cycle 229 222 216 210 204 197 191 185 179 172 167 163 163

Leverage Ratios
Financial Leverage Ratio 1.45 1.46 1.47 1.48 1.49 1.50 1.51 1.51 1.52 1.55 1.55 1.56 1.56
Degree of Financial Leverage 1.13 1.30 1.22 1.32 1.14 1.14 1.14 1.08 1.10 1.06 1.07 1.08 1.11

Earnings Coverage Ratios

Interest Coverage 43.17 22.02 29.15 21.43 43.35 42.81 45.86 74.77 62.68 97.13 94.18 84.93 55.31
 Enter Business Type
P&L Comparison1 Current month Year to date
PREV NEXT Actual LYSP Budget VS. LYSP VS. Budget Actual LYSP Budget VS. LYSP VS. Budget

Revenue 2,334,341 2,266,350 2,381,028 3% -2% 16,156,118 15,685,551 16,479,241 3% -2%

Cost of Services 1,704,069 1,654,436 1,738,150 3% -2% 12,162,439 11,808,193 12,405,687 3% -2%
Gross Profit 630,272 611,914 642,878 3% -2% 3,993,679 3,877,358 4,073,554 3% -2%
Gross Margin % 27% 27% 27% 25% 25% 25%

Operating expenses:
Advertising & Marketing 93,374 90,654 95,241 3% -2% 369,510 358,746 376,900 3% -2%
Salaries and Benefits 116,718 113,318 119,052 3% -2% 848,343 823,634 865,310 3% -2%
General & Administration 256,778 249,299 261,914 3% -2% 1,765,865 1,714,433 1,801,183 3% -2%
Depreciation and Amortization 2,000 2,000 2,000 0% 0% 18,000 18,000 18,000 0% 0%
Total Operating Expenses 468,870 455,271 478,207 3% -2% 3,001,718 2,914,813 3,061,393 3% -2%
Operating Profit - EBIT 161,402 156,643 164,671 3% -2% 991,961 962,545 1,012,161 3% -2%
EBITDA 418,180 405,942 426,585 3% -2% 2,757,826 2,676,978 2,813,344 3% -2%
Other income (expense):
Interest Expenses 2,575 2,500 2,627 3% -2% 23,175 22,500 23,643 3% -2%
Other Non-operating gains/(losses) 12,067 11,716 12,308 3% -2% 100,469 97,543 102,478 3% -2%
Total Non-Operating Income (Expense) 14,642 14,216 14,935 3% -2% 123,644 120,043 126,121 3% -2%
Earnings Before Tax - EBT 146,760 142,427 149,736 3% -2% 868,317 842,502 886,040 3% -2%
Income Tax 2,500 2,000 2,000 25% 25% 22,500 18,000 18,000 25% 25%
Net income (loss) 144,260 140,427 147,736 3% -2% 845,817 824,502 868,040 3% -3%
Net Margin % 6% 6% 6% 5% 5% 5%
 Enter Business Type
Actual Budget
P&L Comparison2 Current Quarter YoY Changes Full Year = 9 Mths + 3 Mths
PREV NEXT Current Quarter Actual LYSP Budget VS. LYSP VS. Budget Actual LYSP Budget VS. LYSP VS. Budget

Revenue Quarter 1 6,497,088 6,307,852 6,627,030 3% -2% 24,033,158 23,183,209 24,356,281 4% -1%
Cost of Services Quarter 2 4,782,902 4,643,594 4,878,560 3% -2% 17,848,616 17,220,507 18,091,864 4% -1%
Gross Profit Quarter 3 1,714,186 1,664,258 1,748,470 3% -2% 6,184,542 5,962,702 6,264,417 4% -1%
Gross Margin % Quarter 4 26% 26% 26% 26% 26% 26%
3
Operating expenses: Q3
Advertising & Marketing 176,629 171,484 180,162 3% -2% 531,644 513,071 539,034 4% -1%
Salaries and Benefits 366,482 355,808 373,812 3% -2% 1,334,742 1,286,607 1,351,709 4% -1%
General & Administration 693,065 672,879 706,927 3% -2% 2,576,533 2,486,057 2,611,851 4% -1%
Depreciation and Amortization 6,000 6,000 6,000 0% 0% 24,000 24,000 24,000 0% 0%
Total Operating Expenses 1,242,176 1,206,171 1,266,901 3% -2% 4,466,919 4,309,735 4,526,594 4% -1%
Operating Profit - EBIT 472,010 458,087 481,569 3% -2% 1,717,623 1,652,967 1,737,823 4% -1%
EBITDA 1,165,075 1,130,966 1,188,496 3% -2% 4,294,156 4,139,024 4,349,674 4% -1%
Other income (expense):
Interest Expenses 7,725 7,500 7,881 3% -2% 31,056 30,000 31,524 4% -1%
Other Non-operating gains/(losses) 35,497 34,463 36,207 3% -2% 138,892 134,115 140,901 4% -1%
Total Non-Operating Income (Expense) 43,222 41,963 44,088 3% -2% 169,948 164,115 172,425 4% -1%
Earnings Before Tax - EBT 428,788 416,124 437,481 3% -2% 1,547,675 1,488,852 1,565,398 4% -1%
Income Tax 7,500 6,000 6,000 25% 25% 28,500 24,000 24,000 19% 19%
Net income (loss) 421,288 410,124 431,481 3% -2% 1,519,175 1,464,852 1,541,398 4% -1%
Net Margin % 6% 7% 7% 6% 6% 6%
 Enter Business Type
Current Current Current Previous
P&L Comparison3 Last 4 QTR
Year Year Year Year QoQ Changes
PREV NEXT Current Quarter Q3 % Q2 % Q1 % Q4 % Q3 vs Q2 Q2 vs Q1 Q1 vs Q4

Revenue Quarter 1 6,497,088 100% 5,252,100 100% 4,406,930 100% 7,497,658 100% 24% 19% -41%
Cost of Services Quarter 2 4,782,902 74% 3,988,086 76% 3,391,451 77% 5,412,314 72% 20% 18% -37%
Gross Profit Quarter 3 1,714,186 26% 1,264,014 24% 1,015,479 23% 2,085,344 28% 36% 24% -51%
Gross Margin % Quarter 4 26% 24% 23% 28%
3
Operating expenses: Q3
Advertising & Marketing 176,629 3% 121,951 2% 70,930 2% 154,325 2% 45% 72% -54%
Salaries and Benefits 366,482 6% 262,606 5% 219,255 5% 462,973 6% 40% 20% -53%
General & Administration 693,065 11% 596,434 11% 476,366 11% 771,624 10% 16% 25% -38%
Depreciation and Amortization 6,000 0% 6,000 0% 6,000 0% 6,000 0% 0% 0% 0%
Total Operating Expenses 1,242,176 19% 986,991 19% 772,551 18% 1,394,922 19% 26% 28% -45%
Operating Profit - EBIT 472,010 7% 277,023 5% 242,928 6% 690,422 9% 70% 14% -65%
EBITDA 1,165,075 18% 873,457 17% 719,294 16% 1,462,046 20% 33% 21% -51%
Other income (expense):
Interest Expenses 7,725 0% 7,725 0% 7,725 0% 7,500 0% 0% 0% 3%
Other Non-operating gains/(losses) 35,497 1% 33,450 1% 31,522 1% 36,572 0% 6% 6% -14%
Total Non-Operating Income (Expense) 43,222 1% 41,175 1% 39,247 1% 44,072 1% 5% 5% -11%
Earnings Before Tax - EBT 428,788 7% 235,848 4% 203,681 5% 646,350 9% 82% 16% -68%
Income Tax 7,500 0% 7,500 0% 7,500 0% 6,000 0% 0% 0% 25%
Net income (loss) 421,288 6% 228,348 4% 196,181 4% 640,350 9% 84% 16% -69%
Net Margin % 6% 4% 4% 9%
 Enter Business Type
BS Comparison As of Mar As of Mar As of Mar
Current Year Previous Year Current Period Index vs LYSP Index vs Budget
PREV NEXT
Actual % LYSP % Budget % Variance Index Variance Index

Current assets:
Inventories 3,407,822 13% 3,308,565 13% 3,475,978 13% 99,257 3% (68,156) -2%
Trade Receivables 9,110,689 34% 8,845,329 34% 9,292,903 34% 265,360 3% (182,214) -2%
Prepayment Accounts & Others 9,284,196 35% 9,013,783 35% 9,469,880 35% 270,413 3% (185,684) -2%
Cash and cash equivalents 511,947 2% 497,036 2% 522,186 2% 14,911 3% (10,239) -2%
Total current assets 22,314,654 83% 21,664,713 83% 22,760,947 84% 649,941 3% (446,293) -2%

Non-Current Assets
Property,Plant & Equipment 550,000 2% 550,000 2% 550,000 2% - 0% - 0%
Accumulated Depreciation (218,000) -1% (218,000) -1% (218,000) -1% - 0% - 0%
Intangible assets 2,270,506 8% 2,270,506 9% 2,270,506 8% - 0% - 0%
Deferred tax asset 1,854,905 7% 1,854,905 7% 1,854,905 7% - 0% - 0%
Total Non-Current Assets 4,457,411 17% 4,457,411 17% 4,457,411 16% - 0% - 0%
Total Assets 26,772,065 100% 26,122,124 100% 27,218,358 100% 649,941 2% (446,293) -2%

Current liabilities:
Payables to banks 2,570,571 10% 2,495,700 10% 2,621,982 10% 74,871 3% (51,411) -2%
Trade payables 2,013,754 8% 1,507,710 6% 2,353,652 9% 506,044 34% (339,898) -14%
Short-term borrowings 922,469 3% 895,601 3% 940,918 3% 26,868 3% (18,449) -2%
Accrued Payables & Others 715,611 3% 694,768 3% 729,923 3% 20,843 3% (14,312) -2%
Total current liabilities 6,222,405 23% 5,593,779 21% 6,646,475 24% 628,626 11% (424,070) -6%

Non-Current Liabilities
Long-term borrowings 465,516 2% 465,516 2% 465,516 2% - 0% - 0%
Retirement Benefit Obligations 1,290,455 5% 1,290,455 5% 1,290,455 5% - 0% - 0%
Deferred tax liability 1,176,859 4% 1,176,859 5% 1,176,859 4% - 0% - 0%
Total Non-current Liabilities 2,932,830 11% 2,932,830 11% 2,932,830 11% - 0% - 0%

Stockholders’ equity:
Share Capital 558,404 2% 558,404 2% 558,404 2% - 0% - 0%
Other reserves 1,005,340 4% 1,005,340 4% 1,005,340 4% - 0% - 0%
Retained earnings 15,205,269 57% 15,205,269 58% 15,205,269 56% - 0% - 0%
Current Year Result 845,817 3% 824,502 3% 868,040 3% 21,315 3% (22,223) -3%
Cumulative Translation Adj. 2,000 0% 2,000 0% 2,000 0% - 0% - 0%
Total stockholders’ equity 17,616,830 66% 17,595,515 67% 17,639,053 65% 21,315 0% (22,223) 0%
Total liabilities and stockholders’ equity 26,772,065 100% 26,122,124 100% 27,218,358 100% 649,941 2% (446,293) -2%
- - - - -
Check Verified Verified Verified Verified Verified
 Enter Business Type
CF Comparison Current month Year to date
PREV NEXT Actual LYSP Budget VS. LYSP VS. Budget Actual LYSP Budget VS. LYSP VS. Budget

Cash flows from operating activities:

Net Earnings 140,427 140,427 140,427 0% 0% 824,502 824,502 824,502 0% 0%
Adjustments For:
+ Depreciation & Amortization 2,000 2,000 2,000 0% 0% 18,000 18,000 18,000 0% 0%
Cash from operation before Working Capital 142,427 142,427 142,427 0% 0% 842,502 842,502 842,502 0% 0%
(Increase)/Decrease in Trade Receivables (173,438) (173,438) (173,438) 0% 0% (1,396,511) (1,396,511) (1,396,511) 0% 0%
(Increase)/Decrease in Inventories 25,105 25,105 25,105 0% 0% 405,880 405,880 405,880 0% 0%
Increase/(Decrease) in Prepayment Accounts (176,741) (176,741) (176,741) 0% 0% (1,481,162) (1,481,162) (1,481,162) 0% 0%
Increase/(Decrease) in Trade Payables 29,563 29,563 29,563 0% 0% 250,894 250,894 250,894 0% 0%
Increase/(Decrease) in Accrued expenses & other liabilities 45,628 45,628 45,628 0% 0% 378,095 378,095 378,095 0% 0%
Net Cash From Operating activities (107,456) (107,456) (107,456) 0% 0% (1,000,302) (1,000,302) (1,000,302) 0% 0%
Cash Flow From Investing Activities
Net change in Property and equipment, net - - - - - - - - - -
Acquisition of intangible assets - - - - - - - - - -
Net Cash From Investing Activities - - - - - - - - - -
Cash Flow From Financing Activities
Capital subscription - - - - - - - - - -
Net change in ST/LT borrowings 117,202 117,202 117,202 0% 0% 1,076,788 1,076,788 1,076,788 0% 0%
Net Cash from Financing Activities 117,202 117,202 117,202 0% 0% 1,076,788 1,076,788 1,076,788 0% 0%

Net Increase/(Decrease) in cash 9,746 9,746 9,746 0% 0% 76,486 76,486 76,486 0% 0%

Cash at the beginning of the Period (*) 501,909 487,290 511,947 3% -2% 4,181,531 4,059,574 4,265,275 3% -2%
Translation adjustmeents 292 - 493 - -41% 4,185 2,000 5,685 109% -26%
Cash at the End of the Period 511,947 497,036 522,186 3% -2% 4,262,202 4,138,060 4,347,446 3% -2%
Check - - -
 Enter Business Type
Current Current Current Previous
Ratio Comparison Last 4 QTR
Year Year Year Year Index vs Previous Quarter
PREV NEXT Current Quarter Q3 Q2 Q1 Q4 Q3 vs Q2 Q2 vs Q1 Q1 vs Q4

Return on Invested Capital Quarter 1

Return on Assets (ROA) Quarter 2 1.59% 0.90% 0.79% 2.38% 78% 13% -67%
Return on Equity (ROE) Quarter 3 2.41% 1.34% 1.16% 3.55% 81% 15% -67%
Quarter 4
Profitability Ratios 3
Gross Profit Margin Q3 26.38% 24.07% 23.04% 27.81% 10% 4% -17%
Operating Profit Margin 7.26% 5.27% 5.51% 9.21% 38% -4% -40%
Net Profit Margin 6.48% 4.35% 4.45% 8.54% 49% -2% -48%
EBITDA Margin 17.93% 16.63% 16.32% 19.50% 8% 2% -16%

Liquidity Ratios
Current Ratio 3.59 3.72 3.89 3.76 -4% -5% 4%
Quick Ratio 3.04 3.11 3.19 3.20 -2% -2% 0%
Cash Ratio 0.08 0.08 0.09 0.09 -2% -2% 0%

Capital Structure and Solvency Ratios

Debt to Equity Ratio 0.52 0.50 0.47 0.50 4% 5% -6%
Long-Term Debt to Equity Ratio 0.17 0.17 0.16 0.17 1% 2% -2%
Debt to Total Assets Ratio 0.34 0.33 0.32 0.33 3% 4% -4%

Activity Ratios
Days’ Sales in Receivables 140.85 152.35 162.00 131.03 -8% -6% 24%
Days’ Sales in Inventory 79.94 90.02 101.58 72.60 -11% -11% 40%
Days’ Purchases in Accounts Payable 42.00 145.84 47.86 30.07 -71% 205% 59%
Operating Cycle 220.79 242.36 263.58 203.63 -9% -8% 29%
Cash Cycle 178.79 96.52 215.72 173.56 85% -55% 24%

Leverage Ratios
Financial Leverage Ratio 1.52 1.50 1.47 1.50 1% 2% -2%
Degree of Financial Leverage 1.10 1.17 1.19 1.07 -6% -2% 12%

Earnings Coverage Ratios

Interest Coverage 61.10 35.86 31.45 92.06 70% 14% -66%
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
Strategical Plan 2020A 2021E 2022E 2023E 2024E 2025E 2026E 2027E 2028E 2029E 2030E

PREV NEXT
Actual Estimate Estimate Estimate Estimate Estimate Estimate Estimate Estimate Estimate Estimate

Revenue 24,033,158 25,234,816 26,496,557 27,821,385 29,212,454 30,673,077 32,206,731 33,817,068 35,507,921 37,283,317 39,147,483
Cost of Services 17,848,616 18,926,112 19,872,418 20,866,039 21,909,341 23,004,808 24,155,048 25,362,801 26,630,941 27,962,488 29,360,612
Gross Profit 6,184,542 6,308,704 6,624,139 6,955,346 7,303,113 7,668,269 8,051,683 8,454,267 8,876,980 9,320,829 9,786,871
Gross Margin % 26% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25%

Operating expenses:
Advertising & Marketing 531,644 686,030 720,332 756,349 794,166 833,874 875,568 919,346 965,314 1,013,579 1,064,258
Salaries and Benefits 1,334,742 1,423,423 1,494,594 1,569,324 1,647,790 1,730,180 1,816,689 1,907,523 2,002,899 2,103,044 2,208,197
General & Administration 2,576,533 2,691,878 2,826,472 2,967,795 3,116,185 3,271,994 3,435,594 3,607,374 3,787,743 3,977,130 4,175,986
Depreciation and Amortization 24,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000
Total Operating Expenses 4,466,919 4,821,331 5,061,398 5,313,468 5,578,141 5,856,048 6,147,851 6,454,243 6,775,956 7,113,753 7,468,441
Operating Profit - EBIT 1,717,623 1,487,373 1,562,741 1,641,878 1,724,972 1,812,221 1,903,832 2,000,024 2,101,024 2,207,076 2,318,430
EBITDA 4,294,156 4,179,251 4,389,213 4,609,673 4,841,157 5,084,215 5,339,426 5,607,398 5,888,767 6,184,206 6,494,416
Other income (expense):
Interest Expenses 31,056 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
Other Non-operating gains/(losses) 138,892 252,348 264,966 278,214 292,125 306,731 322,067 338,171 355,079 372,833 391,475
Total Non-Operating Income (Expense) 169,948 257,348 269,966 283,214 297,125 311,731 327,067 343,171 360,079 377,833 396,475
Earnings Before Tax - EBT 1,547,675 1,230,025 1,292,775 1,358,664 1,427,847 1,500,490 1,576,765 1,656,853 1,740,945 1,829,243 1,921,955
Income Tax 28,500 184,504 193,916 203,800 214,177 225,074 236,515 248,528 261,142 274,386 288,293
Net income (loss) 1,519,175 1,045,521 1,098,859 1,154,864 1,213,670 1,275,416 1,340,250 1,408,325 1,479,803 1,554,857 1,633,662
Net Margin % 6% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4%
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
Valuation & Analysis

PREV NEXT

Valuation

Intrinsic Value 6,094,101 Cost of Capital Assumptions EV & EPS

Risk Free Rate 2.50% Tax Rate 15.00% Authorized Shares 50,000
Equity Risk Premium 9.50% Discount Rate 10.14% Shares Outstanding 40,000
Levered Beta 1.40 EBITDA Mulltiple 10.00X Current Price 100
Market Value 3,479,099 Debt borrowing rate 6.00% Starting Date 31/12/2019 Common Share 10,000
Tax Rate 15.00% Exit Date 31/12/2030 Cash 554,149
Equity Financing% 70.00% Debts 3,033,248
Debt Financing % 30.0% Terminal Value 19,169,550
Book Value 18,312,411 WACC 10.14%

1 2 3 4 5 6 7 8 9 10 11
Discounted Cash Flow Entry 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 EXIT
Date 31/12/2019 31/12/2020 31/12/2021 31/12/2022 31/12/2023 31/12/2024 31/12/2025 31/12/2026 31/12/2027 31/12/2028 31/12/2029 31/12/2030 31/12/2030

EBT 1,547,675 1,230,025 1,292,775 1,358,664 1,427,847 1,500,490 1,576,765 1,656,853 1,740,945 1,829,243 1,921,955
Interest (31,056) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
EBIT 1,516,619 1,225,025 1,287,775 1,353,664 1,422,847 1,495,490 1,571,765 1,651,853 1,735,945 1,824,243 1,916,955
Less: Income Tax 28,500 184,504 193,916 203,800 214,177 225,074 236,515 248,528 261,142 274,386 288,293
Net Operating Profit After Tax (NOPAT) 1,488,119 1,040,521 1,093,859 1,149,864 1,208,670 1,270,416 1,335,250 1,403,325 1,474,803 1,549,857 1,628,662
Plus: Depreciation & Amortization 24,000 20,000 20,000 20,000 20,000 20,000 20,000 - - - -
EBITDA 1,540,619 1,245,025 1,307,775 1,373,664 1,442,847 1,515,490 1,591,765 1,651,853 1,735,945 1,824,243 1,916,955
Less: Investments in Tangible Assets 550,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Less: Changes in Working Capital 311,241 326,803 343,143 360,300 378,315 397,231 417,093 437,947 459,845 482,837 506,979
Unlevered FCF 650,878 723,718 760,716 799,564 840,355 883,185 928,157 955,378 1,004,958 1,057,020 1,111,683
Plus: Terminal Value 19,169,550
Net FCF 650,878 723,718 760,716 799,564 840,355 883,185 928,157 955,378 1,004,958 1,057,020 1,111,683 19,169,550
WACC / Discount Factor 0.91 0.82 0.75 0.68 0.62 0.56 0.51 0.46 0.42 0.38 0.35 0.31
Present Value PV 590,955 596,594 569,360 543,341 518,486 494,745 472,070 441,179 421,349 402,376 384,225 6,015,491
IRR 29% (3,479,099) 650,878 723,718 760,716 799,564 840,355 883,185 928,157 955,378 1,004,958 1,057,020 1,111,683 19,169,550

Intrinsic Value Market Value Book Value

Enterprise Value 8,573,200 Market Capitalization 1,000,000 Total Liabilites 28,522,658
Plus: Cash 554,149 Plus: Debt 3,033,248 Less: Current Liabilities 7,176,999
Less: Debt 3,033,248 Less: Cash 554,149 Less: Non Current Liabilities 3,033,248
Equity Value 6,094,101 Enterprise Value 3,479,099 Book Value 18,312,411

Intrinsic Value Per Share 152.35 Market Value Per Share 86.98 Book Value Per Share 457.81
 Enter Business Type 1 2 3 4 5 6 7 8 9 10 11 12
Valuation & Analysis

PREV NEXT

Sensitivity Analysis
Share Price Senstivity Intrinsic Value Share Price Senstivity Market Value
Revenue Growth Revenue Growth
152 0.00% 2.50% 5.00% 7.50% 10.00% 87 0.00% 2.50% 5.00% 7.50% 10.00%

EBITDA Mulltiple

EBITDA Mulltiple
6.00X 86.15 86.15 86.15 86.15 86.15 3.00X 86.98 86.98 86.98 86.98 86.98
8.00X 119.25 119.25 119.25 119.25 119.25 4.00X 86.98 86.98 86.98 86.98 86.98
10.00X 152.35 152.35 152.35 152.35 152.35 5.00X 86.98 86.98 86.98 86.98 86.98
12.00X 185.45 185.45 185.45 185.45 185.45 6.00X 86.98 86.98 86.98 86.98 86.98
14.00X 218.55 218.55 218.55 218.55 218.55 7.00X 86.98 86.98 86.98 86.98 86.98

Intrinsic value analysis Market value analysis

Revenue Growth Revenue Growth
6,094,101 0.00% 2.50% 5.00% 7.50% 10.00% 3,479,099 0.00% 2.50% 5.00% 7.50% 10.00%
EBITDA Mulltiple

EBITDA Mulltiple
6.00X 3,446,019 3,446,019 3,446,019 3,446,019 3,446,019 3.00X 3,479,099 3,479,099 3,479,099 3,479,099 3,479,099
8.00X 4,770,060 4,770,060 4,770,060 4,770,060 4,770,060 4.00X 3,479,099 3,479,099 3,479,099 3,479,099 3,479,099
10.00X 6,094,101 6,094,101 6,094,101 6,094,101 6,094,101 5.00X 3,479,099 3,479,099 3,479,099 3,479,099 3,479,099
12.00X 7,418,141 7,418,141 7,418,141 7,418,141 7,418,141 6.00X 3,479,099 3,479,099 3,479,099 3,479,099 3,479,099
14.00X 8,742,182 8,742,182 8,742,182 8,742,182 8,742,182 7.00X 3,479,099 3,479,099 3,479,099 3,479,099 3,479,099
 PREV NEXT Dashboard
ROE Trend for Last 4 Quarters ROA Trend for Last 4 Quarters Ratio Summary for Last 4 Quarters
4.00% 2.50% 2.38%
3.55%
Previous Year Current Year Current Year Current Year
Ratio Comparison

3.50%
3.00% 2.00% Summary Q4 Q1 Q2 Q3
1.59%
2.50% ROA 2.38% 0.79% 0.90% 1.59%
1.50%
2.00% 1.59%
ROE 3.55% 1.16% 1.34% 1.59%
1.34% 0.90% Gross Margin 27.81% 23.04% 24.07% 26.38%
1.50% 1.16% 1.00% 0.79%
1.00% EBITDA Marg. 19.50% 16.32% 16.63% 17.93%
0.50%
0.50% Current Ratio 3.76 3.89 3.72 3.59
0.00% 0.00% Debt to Equity 0.50 0.47 0.50 0.52
Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Operat. Cycle 203.63 263.58 242.36 220.79
Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year Int. Coverage 92.06 31.45 35.86 61.10

Gross Margin Trend for Last 4 Quarters EBITA Margin Trend for Last 4 Quarters Current Ratio Trend for Last 4 Quarters
30.00% 27.81% 30.00% 4.00
26.38%
24.07% 3.89
Ratio Comparison

25.00% 23.04% 25.00% 3.90

19.50%
20.00% 20.00% 17.93% 3.80 3.76
16.32% 16.63% 3.72
15.00% 15.00% 3.70
3.59
10.00% 10.00% 3.60

5.00% 5.00% 3.50

0.00% 0.00% 3.40

Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3

Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year

Debt to Equity Ratio Trend for Last 4 Quarters Operating CycleTrend for Last 4 Quarters Interest Coverage Ratio Trend for Last 4 Quarters
0.53 0.52 300.00 100.00 92.06
263.58
0.52 242.36 90.00
Ratio Comparison

0.51 250.00 220.79

0.50 0.50 203.63 80.00
0.50 200.00 70.00 61.10
0.49 60.00
0.48 0.47 150.00 50.00
35.86
40.00 31.45
0.47 100.00
30.00
0.46
50.00 20.00
0.45 10.00
0.44 - -
Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3
Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year
 PREV NEXT Dashboard
Revenue Trend for Last 4 Quarters EBITA Trend for Last 4 Quarters P&L Summary for Last 4 Quarters
8,000,000 1,600,000
7,000,000 1,400,000 Previous Year Current Year Current Year Current Year
P&L Comparison

6,000,000 1,200,000 P&L Summary Q4 Q1 Q2 Q3

5,000,000 1,000,000 Revenue 7,497,658 4,406,930 5,252,100 6,497,088
4,000,000 800,000 Cost of sales 5,412,314 3,391,451 3,988,086 4,782,902
3,000,000 Gross Profit 2,085,344 1,015,479 1,264,014 1,714,186

1,462,046

1,165,075
7,497,658

5,252,100

6,497,088
4,406,930
600,000

719,294

873,457
2,000,000 400,000 Overhead
1,000,000 200,000 OPEX 1,394,922 772,551 986,991 1,242,176
- - Other income 44,072 39,247 41,175 43,222
Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Income tax 6,000 7,500 7,500 7,500
Previous Year Current Year Current Year Current Year Previous Year Current Year Current Year Current Year Net income 640,350 196,181 228,348 421,288
EBITDA 1,462,046 719,294 873,457 1,165,075
Revenue YTD Comparison EBITA YTD comparison P&L Summary YTD Comparison
16,600,000 2,850,000 P&L Summary Actual YTD LYSP Budget YTD
16,400,000 Revenue 16,156,118 15,685,551 16,479,241
P&L Comparison

2,800,000
16,200,000 Cost of sales 12,162,439 11,808,193 12,405,687
2,750,000 Gross Profit 3,993,679 3,877,358 4,073,554
16,000,000
Overhead
15,800,000
2,700,000 OPEX 3,001,718 2,914,813 3,061,393
16,156,118

15,685,551

16,479,241

2,676,978
2,757,826

2,813,344
15,600,000 Other income 123,644 120,043 126,121
15,400,000
2,650,000 Income tax 22,500 18,000 18,000
Net income 845,817 824,502 868,040
15,200,000 2,600,000
Actual YTD LYSP Budget YTD Actual YTD LYSP Budget YTD EBITDA 2,757,826 2,676,978 2,813,344

Revenue Full Year Comparison EBITA Full Year Comparison P&L Summary Full Year Comparison
24,400,000 4,350,000
24,200,000 P&L Summary Actual PY Budget
P&L Comparison

4,300,000
24,000,000 Revenue 24,033,158 23,183,209 24,356,281
23,800,000 4,250,000 Cost of sales 17,848,616 17,220,507 18,091,864
23,600,000 4,200,000 Gross Profit 6,184,542 5,962,702 6,264,417
23,400,000
4,150,000 Overhead
23,200,000
OPEX 4,466,919 4,309,735 4,526,594
24,033,158

23,183,209

24,356,281

4,139,024
4,294,156

4,349,674
23,000,000 4,100,000
22,800,000 Other income 169,948 164,115 172,425
4,050,000 Income tax 28,500 24,000 24,000
22,600,000
22,400,000 4,000,000 Net income 1,519,175 1,464,852 1,541,398
Actual PY Budget Actual PY Budget EBITDA 4,294,156 4,139,024 4,349,674
 PREV NEXT Dashboard
Current Assets vs Current Liabilies Equity vs Total Liabilities BS Summary Comparison
Current Assets Current Liabilities Equity Total Liabilities
25,000,000 22,314,654 22,760,947 20,000,000
17,616,830 17,595,515 17,639,053 BS Summary Actual PY Budget
21,664,713
18,000,000 Current Assets 22,314,654 21,664,713 22,760,947
BS Comparison

20,000,000 16,000,000 Non-current Assets 4,457,411 4457411 4457411

14,000,000
Total Assets 26,772,065 26,122,124 27,218,358
15,000,000 12,000,000
10,000,000 Liabilities
9,155,235 9,579,305
10,000,000 8,000,000 8,526,609 Current Liabilities 6,222,405 5,593,779 6,646,475
6,646,475
6,000,000 Non-current Liabilities 2,932,830 2,932,830 2,932,830
6,222,405 5,593,779
5,000,000 4,000,000 Shareholders' Equity 17,616,830 17,595,515 17,639,053
2,000,000
Total Liabilities & Equity 26,772,065 26,122,124 27,218,358
- -
Actual PY Budget Actual PY Budget Check Verified Verified Verified
Total Liabilities 9,155,235 8,526,609 9,579,305
Equity vs Profit for the Current Year Total Assets vs Total Liabilities Casf Flow YTD Comparison
Equity Profit Total Assets Total Liabilities 4,400,000
18,500,000
BS & CF Comparison

30,000,000 27,218,358 4,347,446

26,772,065 26,122,124 4,350,000
18,000,000 25,000,000 4,300,000 4,262,202
17,500,000 20,000,000 4,250,000
4,200,000
15,000,000
17,000,000 4,138,060
4,150,000
10,000,000 9,155,235 9,579,305
16,500,000 8,526,609 4,100,000
5,000,000 4,050,000
16,000,000
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun - 4,000,000
Actual PY Budget Actual LYSP Budget

Revenue vs EBITA for 10 Years EBITA vs Unlevered Free Cash Flow Market Value vs Intrinsic Value
Revenue EBITA EBITA Net FCF Intrinsic Value Market value
50,000 2,500,000
Thousands

45,000
40,000 2,000,000
Valuation

35,000
30,000 1,500,000
3,479,099
25,000
20,000 1,000,000
6,094,101
15,000
10,000 500,000
5,000
- -
2021E 2022E 2023E 2024E 2025E 2026E 2027E 2028E 2029E 2030E 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
 PREV NEXT Instructions

Please follow the instruction from 1 to 10. 1 Update the general info in the Front Page
After you fill all the green cells you will get: 2 Update the fiscal year by choosing the selection box in "P&L" sheet under column B, row 3
3 Update the current month on monthly basis by choosing the selection box in "P&L" sheet under column B, row 5
1- P&L trend for 12 month
4 Update the current quarter on quarter basis by choosing the selection box in "P&L Comparison2" sheet under column B, row 5
2- Balance sheet trend for 12 month
3- Cash flow trend for 12 month 5 Update the current quarter on quarter basis by choosing the selection box in "P&L Comparison3" sheet under column B, row 5
4- Ratio trend for 12 month 6 Update the current quarter on quarter basis by choosing the selection box in "Ratio Comparison" sheet under column B, row 5
5- P&L Comparision
7 Enter the budget income statement, balance sheet and cash flow in "Budget" sheet for 12 months, Fill only the green cells
6- Balance sheet comparison
7- Cash flow comparison 8 Enter the previous year income statement, balance sheet and cash flow in "Actual PY" sheet for 12 months, Fill only the green cells
8- Ratio comparison 9 Enter the current year data on monthly basis for income statement, balance sheet and cash flow in "Actual YTD" sheet , Fill only the green cells
9- Strategical plan for 10 years
10 Enter the data in "Assumption" sheet , Fill only the green cells
10- Valuation & analysis
11- Dashboard summary If you need any modification or customization please message me