Appendix 1. Financial statement
Figure 41: Kernel`s IFRS Financial, USD thousands
BALANCE SHEET
| FY2011 | FY2012 | FY2013E | FY2014F | FY2015F | FY2016F | FY2017F | FY2018F | ||||
| ASSETS | |||||||||||
| Cash & equivalents | 115,897 | 82,529 | 128,042 | 197,673 | 348,686 | 558,632 | 810,089 | 1 065 315 | |||
| Trade accounts receivable, net | 111,586 | 146,362 | 160,618 | 190,707 | 208,166 | 227,889 | 236,772 | 246 775 | |||
| Prepayments to suppliers & other current assets, net | 81,334 | 90,335 | 112,634 | 131,997 | 143,233 | 155,926 | 161,642 | 168 079 | |||
| Taxes recoverable & prepaid, net | 221,274 | 238,294 | 238,294 | 238,294 | 238,294 | 238,294 | 238,294 | 238 294 | |||
| Inventories | 183,668 | 410,182 | 414,130 | 493,849 | 540,586 | 593,770 | 617,849 | 645 052 | |||
| Biological assets | 95,961 | 153,338 | 160,068 | 185,787 | 204,480 | 217,871 | 227,378 | 234 087 | |||
| Total current assets | 809,720 | 1,121,040 | 1,213,786 | 1,438,307 | 1,683,444 | 1,992,383 | 2,292,023 | 2,597,602 | |||
| PP&E, net | 502,752 | 728,371 | 858,102 | 930,303 | 1,001,015 | 1,039,483 | 1,079,256 | 1 120 632 | |||
| Intangible assets, net | 65,563 | 91,087 | 106,858 | 117,854 | 125,519 | 130,863 | 134,589 | 137 186 | |||
| Goodwill | 85,989 | 137,227 | 137,227 | 137,227 | 137,227 | 137,227 | 137,227 | 137 227 | |||
| Deffered tax assets | 10,723 | 21,502 | 21,502 | 21,502 | 21,502 | 21,502 | 21,502 | 21 502 | |||
| Other non-current assets | 97,862 | 19,805 | 19,805 | 19,805 | 19,805 | 19,805 | 19,805 | 19 805 | |||
| Total non-current assets | 762 889 | 997,992 | 1,143,495 | 1,226,691 | 1,305,068 | 1,348,880 | 1,392,379 | 1,436,352 | |||
| TOTAL ASSETS | 1,572,609 | 2,119,032 | 2,357,280 | 2,664,998 | 2,988,512 | 3,341,263 | 3,684,402 | 4,033,954 | |||
| LIABILITIES | |||||||||||
| Trade accounts payables | 27,055 | 25,490 | 31,750 | 37,720 | 41,185 | 45,098 | 46,861 | 48 845 | |||
| Advances from customers and other current liabilities | 102,029 | 157,338 | 172,272 | 204,633 | 223,410 | 244,622 | 254,176 | 264 934 | |||
| Short-term borrowings | 234,514 | 167,348 | 296,298 | 333,938 | 376,033 | 421,810 | 468,174 | 515,234 | |||
| Current portion of long-term borrowings | 31,392 | 98,622 | - | - | - | - | - | - | |||
| Total current liabilities | 394 990 | 448,798 | 500,320 | 576,291 | 640,628 | 711,531 | 769,211 | 829,014 | |||
| Long-term borrowings | 152,684 | 414,238 | 462,912 | 523,320 | 590,880 | 664,349 | 738,759 | 814,287 | |||
| Obligation under finance lease | 3,373 | 12,622 | 12,622 | 12,622 | 12,622 | 12,622 | 12,622 | 12,622 | |||
| Deferred tax liability | 24,119 | 26,356 | 26,356 | 26,356 | 26,356 | 26,356 | 26,356 | 26,356 | |||
| Other non-current liabilities | 153 | 6,317 | 6,317 | 6,317 | 6,317 | 6,317 | 6,317 | 6,317 | |||
| Total non-current liabilities | 180,329 | 459,533 | 508,207 | 568,615 | 636,175 | 709,644 | 784,054 | 859,582 | |||
| SHAREHOLDERS' EQUITY | |||||||||||
| Share capital | 1,945 | 2,104 | 2,104 | 2,104 | 2,104 | 2,104 | 2,104 | 2,104 | |||
| Share premium reserve | 321,556 | 463,879 | 463,879 | 463,879 | 463,879 | 463,879 | 463,879 | 463,879 | |||
| Subscrived capital | 137,354 | - | - | - | - | - | - | - | |||
| Additional paid-in capital | 39,944 | 39,944 | 39,944 | 39,944 | 39,944 | 39,944 | 39,944 | 39,944 | |||
| Equity‑settled employee benefits reserve | 1,211 | 1,211 | 1,211 | 1,211 | 1,211 | 1,211 | 1,211 | ||||
| Revaluation reserve | 15,049 | 15,049 | 15,049 | 15,049 | 15,049 | 15,049 | 15,049 | 15,049 | |||
| Translation reserve | -162,152 | -167,082 | -167,082 | -167,082 | -167,082 | -167,082 | -167,082 | -167,082 | |||
| Retained earnings | 617,878 | 824,578 | 962,631 | 1,133,968 | 1,325,587 | 1,533,965 | 1,745,014 | 1,959,235 | |||
| Shareholders' equity | 971,574 | 1,179,683 | 1,317,736 | 1,489,073 | 1,680,692 | 1,889,070 | 2,100,119 | 2,314,340 | |||
| Minority interest | 25,716 | 31,018 | 31,018 | 31,018 | 31,018 | 31,018 | 31,018 | 31,018 | |||
| Total shareholders' equity | 997,290 | 1,210,701 | 1348754 | 1,520,091 | 1,711,710 | 1,920,088 | 2,131,137 | 2,345,358 | |||
| TOTAL LIABILITIES & EQUITY | 1,572,609 | 2,119,032 | 2357280 | 2,664,998 | 2,988,512 | 3,341,263 | 3,684,402 | 4,033,954 | |||
INCOME STATEMENT
| FY2011 | FY2012 | FY2013E | FY2014F | FY2015F | FY2016F | FY2017F | FY2018F | |||||||||
| Revenue | 1,899,118 | 2,157,441 | 2,535,981 | 2,982,421 | 3,241,458 | 3,534093 | 3,665,888 | 3,814,298 | ||||||||
| Cost of sales | -1,439,591 | -1,696,468 | -2,021,760 | -2,370,410 | -2,571,595 | -2,804,815 | -2,909,134 | -3,026,322 | ||||||||
| Gross profit | 459,527 | 460,973 | 514,222 | 612,011 | 669,863 | 729,278 | 756,754 | 787,975 | ||||||||
| Other operating income | 26,192 | 65,993 | 73,059 | 83,900 | 91,712 | 97,277 | 101,212 | 103,983 | ||||||||
| Operating expenses: | ||||||||||||||||
| Distribution,costs | -170,281 | -200,368 | -243,044 | -283,454 | -306,900 | -333,388 | -345,317 | -358,751 | ||||||||
| General,&administrative,expenses | -38,170 | -70,128 | -73,634 | -77,316 | -81,182 | -85,241 | -89,503 | -93,978 | ||||||||
| Total operating expenses | -208,451 | -270,496 | -316,679 | -360,770 | -388,082 | -418,629 | -434,821 | -452,729 | ||||||||
| Operating profit | 277,268 | 256,470 | 270,602 | 335,141 | 373,493 | 407,925 | 423,146 | 439,229 | ||||||||
| Finance,costs | -42,452 | -64,361 | -73,384 | -90,374 | -99,752 | -110,241 | -121,647 | -133,199 | ||||||||
| Foreign,exchange,gain,,net | 1,723 | 5,269 | - | - | - | - | - | - | ||||||||
| Other,expenses/income,,net | -28,121 | -3,486 | - | - | - | - | - | - | ||||||||
| Profit before income tax | 208,418 | 193,892 | 197,218 | 244,767 | 273,741 | 297,684 | 301,498 | 306,030 | ||||||||
| Income tax benefit profit | 17,629 | 16,890 | - | - | - | - | - | - | ||||||||
| NET PROFIT | 226,047 | 210,782 | 197,218 | 244,767 | 273,741 | 297,684 | 301,498 | 306,030 | ||||||||
Source: Company data, KNU estimates
Appendix 2. Kernel Historical lookup
Figure 42: Kernel Business Lifecycle: from seed to mature
|
|
Source: Company data, KNU estimates
Figure 43. Kernel Holding S.A. M&A activity
| Data | Company | Segment | Value, M USD US | |
| 23 January 2008 | Zaliznichni slyakhi JS | Transshipment services | 2.4 | |
| 14 January 2010 | Allseeds Group | Oil | 42 | |
| 15 February 2010 | Allseeds Group | Oil | 28 | |
| 12 October 2010 | Private farming | Farming | 1.60 | |
| 21 March 2011 | Ukrros | Sugar | 142 | |
| 16 August 2011 | Russkie Masla Group | Oil | 63.8 | |
| 15 September 2011 | Black Sea Industries | OIl | 140 | |
| 02 April 2012 | Farming companies (Khmelnytsk & Poltava regions) | Farming | 149.4 | |
| 02 October 2012 | Grain Port/Taman | Transshipment services | 265 |
Source: Bloomberg, Company data
Figure 44. Kernel Holding S.A. M&A activity – impact on share price
|
|
|
|
|
|
Source: WSE, Company data
Appendix 3. DCF Building
Figure 45: DCF calculation
| FY2011 | FY2012 | FY2013E | FY2014F | FY2015F | FY2016F | FY2017F | FY2018F | |
| Revenue from oil, cake and meal | 1,309,975 | 1,394,618 | 1,674,501 | 1,793,138 | 1,940,833 | 2,086,969 | 2,183,043 | 2,280,185 |
| Revenue from grain trade | 571,143 | 598,691 | 772,923 | 1,092,869 | 1,188,004 | 1,330,498 | 1,363,658 | 1,413,915 |
| Revenue from farming | 4,309 | 25,814 | 21,739 | 28,954 | 33,923 | 37,360 | 39,471 | 40,892 |
| Revenue from grain silo services | 10,521 | 31,256 | 29,176 | 29,087 | 31,401 | 31,852 | 32,181 | 32,149 |
| Revenue from transshipment services | 3,170 | 8,012 | 31,243 | 38,373 | 47,297 | 47,414 | 47,535 | 47,157 |
| Revenue from other activities | - | 99,050 | 6,400 | Sugar plants are sold | ||||
| TOTAL REVENUE | 1,899,118 | 2,157,441 | 2,535,981 | 2,982,421 | 3,241,458 | 3,534,093 | 3,665,888 | 3,814,298 |
| COGS | 1,358,548 | 1,536,068 | 1,798,844 | 2,120,329 | 2,306,864 | 2,517,592 | 2,612,499 | 2,719,370 |
| Amortization and depreciation | 30,885 | 62,374 | 91,263 | 101,622 | 107,049 | 120,719 | 125,341 | 130,160 |
| Payroll and payroll-related costs | 24,841 | 49,083 | 44,739 | 49,103 | 51,407 | 53,591 | 54,750 | 56,084 |
| Rental expenses | 7,513 | 21,842 | 47,835 | 52,486 | 55,009 | 57,308 | 58,563 | 59,936 |
| Other operating costs | 17,804 | 27,101 | 39,078 | 46,871 | 51,265 | 55,605 | 57,981 | 60,772 |
| TOTAL COSTS | 1,439,591 | 1,696,468 | 2,021,760 | 2,370,410 | 2,571,595 | 2,804,815 | 2,909,134 | 3,026,322 |
| GROSS PROFIT | 459,527 | 460,973 | 514,222 | 612,011 | 669,863 | 729,278 | 756,754 | 787,975 |
| Other operating income | 26,192 | 65,993 | 73,059 | 83,900 | 91,712 | 97,277 | 101,212 | 103,983 |
| Operating expenses: | ||||||||
| Distribution costs | -170,281 | -200,368 | -243,044 | -283,454 | -306,900 | -333,388 | -345,317 | -358,751 |
| General and administrative expenses | -38,170 | -70,128 | -73,634 | -77,316 | -81,182 | -85,241 | -89,503 | -93,978 |
| Operating profit | 277,268 | 256,470 | 270,602 | 335,141 | 373,493 | 407,925 | 423,146 | 439,229 |
| EBITDA | 308,153 | 318,844 | 361,865 | 436,763 | 480,543 | 528,644 | 548,486 | 569,389 |
| Finance cost | -42,452 | -64,361 | -73,384 | -90,374 | -99,752 | -110,241 | -121,647 | -133,199 |
| Foreign exchange (loss)/gain, net | 1,723 | 5,269 | - | - | - | - | - | - |
| Other expenses/income, net | -28,121 | -3,486 | - | - | - | - | - | - |
| Profit before income tax | 208,418 | 193,892 | 197,218 | 244,767 | 273,741 | 297,684 | 301,498 | 306,030 |
| tax rate | 23% | 21% | 19% | 16% | 16% | 16% | 16% | 16% |
| Profit before income tax from continuing operations | 208,418 | 193,892 | 197,218 | 244,767 | 273,741 | 297,684 | 301,498 | 306,030 |
| Tax at statutory tax rate | -47,936 | -42,824 | - | - | - | - | - | - |
| Deferred tax income | 10,589 | 4,823 | - | - | - | - | - | - |
| Tax effect of expenses, net | 54,976 | 54,891 | - | - | - | - | - | - |
| Tax income benefit | 17,629 | 16,890 | - | - | - | - | - | - |
| NET PROFIT | 226,047 | 210,782 | 197,218 | 244,767 | 273,741 | 297,684 | 301,498 | 306,030 |
| Interest paid(=Total Interest * (1-T)) | 31,834 | 46,607 | 55,630 | 72,620 | 81,998 | 92,487 | 103,893 | 115,445 |
| NOPAT | 257,881 | 257,389 | 252,848 | 317,387 | 355,739 | 390,171 | 405,392 | 421,475 |
| Amortization | 3,626 | 12,081 | 21,729 | 26,505 | 29,834 | 32,156 | 33,774 | 34,903 |
| Depreciation | 28,735 | 53,424 | 69,534 | 75,117 | 77,215 | 88,563 | 91,567 | 95,258 |
| Total D&A | 32,361 | 65,505 | 91,263 | 101,622 | 107,049 | 120,719 | 125,341 | 130,160 |
| Increase in trade accounts receivable | -52,080 | -9,281 | -14,256 | -30,089 | -17,459 | -19,723 | -8,883 | -10,003 |
| Increase in prepayments and other current assets | 18,925 | 1,181 | -22,299 | -19,364 | -11,235 | -12,693 | -5,716 | -6,437 |
| Increase in restricted cash balance | 1,720 | 5,716 | - | - | - | - | - | - |
| Increase in taxes recoverable & prepaid | -1,371 | -10,247 | - | - | - | - | - | - |
| Increase in biological assets | 3,292 | 11,585 | -6,730 | -25,719 | -18,693 | -13,391 | -9,507 | -6,710 |
| Increase in inventories | -24,889 | -206,817 | -3,948 | -79,719 | -46,737 | -53,185 | -24,079 | -27,203 |
| Increase in trade accounts payable | 4,830 | -23,220 | 6,260 | 5,970 | 3,464 | 3,914 | 1,763 | 1,985 |
| Increase in advances from customers and other current liabilities | -130,536 | -11,051 | 14,934 | 32,361 | 18,777 | 21,212 | 9,554 | 10,758 |
| Total change in WC | -180,109 | -242,134 | -26,038 | -116,559 | -71,883 | -73,866 | -36,868 | -37,610 |
| Tangible Assets | ||||||||
| Additions, Tangible Assets | 40,743 | 95,702 | 40,000 | 40,000 | 40,000 | 30,410 | 31,441 | 32,709 |
| Acquisitions, Tangible Assets | 112,407 | 186,316 | 159,266 | 107,318 | 107,927 | 96,621 | 99,898 | 103,925 |
| Intangible Assets | ||||||||
| Acquisitions (lease rights) | 37,496 | 37,498 | 37,500 | 37,500 | 37,500 | 37,500 | 37,500 | 37,500 |
| Total CapEx | 190,646 | 319,516 | 236,766 | 184,818 | 185,427 | 164,531 | 168,839 | 174,134 |
| FFCF | 81,307 | 117,632 | 205,478 | 272,493 | 325,025 | 339,892 | |
| Period | 1 | 2 | 3 | 4 | 5 | 6 | |
| Discount,ratio | 0.8785 | 0.7717 | 0.6780 | 0.5956 | 0.5232 | 0.4597 | |
| PV FFCF | 71,428 | 90,783 | 139,310 | 162,296 | 170,062 | 156,232 | |
| USES OF FCF | |||||||
| Interest payment | 55,630 | 72,620 | 81,998 | 92,487 | 103,893 | 115,445 | |
| New Borrowings | 79,001 | 98,049 | 109,655 | 119,246 | 120,774 | 122,589 | |
| FCFF for dividends and cash | 104,679 | 143,061 | 233,135 | 299,252 | 341,906 | 347,036 | |
| Cash | 45,513 | 69,631 | 151,013 | 209,947 | 251,456 | 255,227 | |
| Dividends | 59,166 | 73,430 | 82,122 | 89,305 | 90,450 | 91,809 | |
| Dividends per share, USD | 0.75 | 0.93 | 1.04 | 1.13 | 1.14 | 1.16 | |
| Dividends per share, PLN | 2.36 | 2.93 | 3.28 | 3.57 | 3.61 | 3.67 | |
Source: Company data, KNU estimates
Дата добавления: 2020-04-25; просмотров: 69; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!
