1
2
Company CodeCIB
3
Company NameBancolombia S.A.
4
Denominator1,000,000
5
1
Profile
2
SymbolPriceBetaVolavgMktcapLastdivRangeChangesCompanynameCurrencyCikIsinCusipExchange
Exchangeshortname
IndustryWebsiteDescriptionCeoSectorCountry
Fulltimeemployees
PhoneAddressCityStateZipDcfdiffDcfImageIpodateDefaultimageIsetfIsactivelytradingIsadrIsfund
3
CIB31.571.14224294578512578683.424.15-37.85-0.025
Bancolombia S.A.
USD1071371US05968L102605968L102
New York Stock Exchange
NYSEBanks - Regional
https://www.grupobancolombia.com
Bancolombia S.A. provides banking products and services in Colombia, Panama, Puerto Rico, El Salvador, Costa Rica, and Guatemala. The company operates through nine segments: Banking Colombia, Banking Panama, Banking El Salvador, Banking Guatemala, Trust, Investment Banking, Brokerage, International Banking, and All Other. It offers checking and savings accounts, fixed term deposits, and investment products; trade financing, loans funded by domestic development banks, working capital loans, credit cards, personal and vehicle loans, payroll loans, and overdrafts; financial support to real estate developers and mortgages for individuals and companies; factoring; and financial and operating leasing services. The company also provides hedging instruments, including futures, forwards, options, and swaps; and brokerage, investment advisory, and private banking services, including selling and distributing equities, futures, foreign currencies, fixed income securities, mutual funds, and structured products. In addition, it offers cash management services; foreign currency transaction services; life, auto, commercial, and homeowner's insurance products; and online and computer banking services. Further, the company provides project and acquisition finance, debt and equity capital markets, principal investments, M&A, hedging strategies, restructurings, and structured financing; money market accounts, mutual and pension funds, private equity funds, payment and corporate trust, and custody; internet-based trading platform; inter-bank lending and repurchase agreements; managing escrow accounts, and investment and real estate funds; and transportation, securities brokerage, maintenance and remodeling, and outsourcing services. As of December 31, 2021, it operated 1,015 branches; 28,676 banking correspondents; 529 PAMs; 210 kiosks in El Salvador and 187 in Colombia; and 6,094 ATMs. Bancolombia S.A. was incorporated in 1945 and is headquartered in Medellín, Colombia.
Mr. Juan Carlos Mora Uribe
Financial Services
CO3475657 4 404 1837
Carrera 48 # 26-85
Medellín-83.50987114.93986811995-07-26FALSEFALSETRUETRUEFALSE
4
5
6
Income Statement - FY
7
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriodRevenueCostofrevenueGrossprofitGrossprofitratio
Researchanddevelopmentexpenses
Generalandadministrativeexpenses
Sellingandmarketingexpenses
Sellinggeneralandadministrativeexpenses
Otherexpenses
Operatingexpenses
Costandexpenses
InterestincomeInterestexpense
Depreciationandamortization
EbitdaEbitdaratio
Operatingincome
Operatingincomeratio
Totalotherincomeexpensesnet
Incomebeforetax
Incomebeforetaxratio
Incometaxexpense
NetincomeNetincomeratioEpsEpsdiluted
Weightedaverageshsout
Weightedaverageshsoutdil
LinkFinallink
8
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023FY47076707000000047076707000000101019435200000017569000000010370042000000-80918360000008091836000000392065670000003646747100000016668295000000107835800000011399390000000.0242145017150800000000.0003203283803441100000080344110000000.1706663765193255500000061169360000000.12993551146359.7125680961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
9
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022FY242056930000004896065000000193096280000000.797730847908977556000000185122000000897755600000018458000000184580000004914523000000254342470000008442470000000949448000000179743810000000.7425683289170249330000000.7033441678-728014700000097447860000000.4025824008274842100000067834900000000.28024357743769.263769.26961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
10
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021FY173608900000000173608900000001073045160000001530660000007304516000000-18802386000000-11497870000000-1149787000000015665191000000435155600000085516700000067181870000000.386972499758630200000000.337714253112099200000059840120000000.3446834811177622500000040867950000000.23540239012283.482283.48961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
11
2020-12-31CIBCOP10713712021-04-232021-04-22 21:13:102020FY157215660000000157215660000001061855190000001280110000006185519000000-21637677000000-15452158000000-1545215800000016473792000000586300800000073636700000010057750000000.0639742252694080000000.0171362064393650000003087730000000.0196400918-65860000002759940000000.0175551214183.85183.85961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/0001558370-21-004672-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/cib-20201231x20f.htm
12
2019-12-31CIBCOP10713712020-04-272020-04-27 14:10:482019FY158220300000000158220300000001064358820000001512460000006435882000000-17877597000000-11441715000000-1144171500000016856244000000617979400000082459000000052049050000000.32896568943803150000000.27684911489721600000044775310000000.2829934591126296400000031173510000000.19702598211749.461749.46961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/0001104659-20-051519-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/tm206804d3_20f.htm
13
2018-12-31CIBCOP10713712019-04-252019-04-24 21:56:012018FY1449887100000016302000000144825690000000.9988756366060288230000001449000000006028823000000-11352877000000-5324054000000-532405400000015731890000000567021600000049390200000096262920000000.663933902291585150000000.6316709073-554264500000036158700000000.249389762882943500000026588640000000.18338420971105711057240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/0001144204-19-021114-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/tv517668_20f.htm
14
2017-12-31CIBCOP10713712018-04-302018-04-30 6:29:512017FY146214780000000146214780000001057718780000001271420000005771878000000-10566663000000-4794785000000-214041000000161602540000006232986000000433033000000105196170000000.7194633128100407340000000.6867112887-604796300000039927710000000.2730757451123859800000026150000000000.17884648871112011120240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/0001144204-18-023396-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/tv487004_20f.htm
15
2016-12-31CIBCOP10713712017-05-012017-05-01 13:01:332016FY135415770000000135415770000001054602650000001200460000005460265000000-9063762000000-3603497000000-122273000000152046210000006053100000000479034000000105781620000000.781161751100603530000000.7429232947-609207100000039682820000000.2930443035117683200000028653280000000.21159485341216012160240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/0001144204-17-023550-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/v461406_20f.htm
16
2015-12-31CIBCOP10713712016-04-222016-04-22 8:50:172015FY106212820000000106212820000001044929890000001138210000004492989000000-2866487000000-231981000000-40475900000011038895000000403794100000047728500000076876390000000.72379577153740390000000.035215993795628900000032356350000000.304636954464925000000025188900000000.23715498751072010720240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/0001144204-16-095666-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/v436669_20f.htm
17
2014-12-31CIBCOP10713712015-04-282015-04-27 17:32:482014FY933957800000009339578000000104612815000000944330000004612815000000-58768000000455404700000045540470000009345608000000324078700000093492700000069207440000000.741012495459858170000000.640908722-351802100000024677960000000.264229925658907500000018787210000000.20115694737813.137813.13240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/0001144204-15-025318-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/v406713_20f.htm
18
19
20
Balance Sheet - FY
21
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriod
Cashandcashequivalents
Shortterminvestments
Cashandshortterminvestments
NetreceivablesInventory
Othercurrentassets
Totalcurrentassets
Propertyplantequipmentnet
GoodwillIntangibleassets
Goodwillandintangibleassets
Longterminvestments
Taxassets
Othernoncurrentassets
Totalnoncurrentassets
OtherassetsTotalassets
Accountpayables
ShorttermdebtTaxpayables
Deferredrevenue
Othercurrentliabilities
Totalcurrentliabilities
Longtermdebt
Deferredrevenuenoncurrent
Deferredtaxliabilitiesnoncurrent
Othernoncurrentliabilities
Totalnoncurrentliabilities
Otherliabilities
Capitalleaseobligations
TotalliabilitiesPreferredstockCommonstock
Retainedearnings
Accumulatedothercomprehensiveincomeloss
Othertotalstockholdersequity
Totalstockholdersequity
Totalequity
Totalliabilitiesandstockholdersequity
Minorityinterest
Totalliabilitiesandtotalequity
Totalinvestments
TotaldebtNetdebtLinkFinallink
22
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023FY31958683000000-59933667000000-2797498400000028449029000000-4740450000004280683400000042806834000000815657900000078181250000006715720000008489697000000924987300000068561200000027354021400000030012197500000003429288090000006459875000000470295000000164339000000-64598750000001643390000006346340000003150252700000014170160000001785230000000268539673000000303244446000000017736100000003038790800000000480914000000863221400000024118930000000485745400000038089512000000390497290000003429288090000009602170000003429288090000009249873000000337464320000001787749000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
23
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022FY247211680000000247211680000001066031000000608449000000-60844900000025787199000000855417400000098366610000006025310000001043919200000030855773000000764594000000-7645940000004984913900000027717839500000035281473300000060195780000001900268000000965180000000250992323000000-2528925910000006019578000000411688940000001179386000000633361000000-36962063000000601957800000030077802600000019002680000003128171820000000480914000000100616540000002368888100000048574540000003908890300000039997551000000352814733000000908648000000352814733000000308557730000004116889400000016447726000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
24
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021FY231476760000000231476760000001642933000000-29459415000000294594150000002479060900000067965170000008143146000000485626000000862877200000032009860000000746375000000-746375000000474351490000002176292900000002898550480000003981649000000860793300000026165300000077115000000-86850480000003981649000000314644990000008769340000001016586000000-33358019000000333580190000002185899220000001819077000000255929590000000048091400000073605830000001953539600000048574540000003223434700000033925458000000289855048000000169111100000028985504800000032009860000000314644990000008316823000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
25
2020-12-31CIBCOP10713712021-04-232021-04-22 21:13:102020FY201850740000000201850740000001204529000000-25825437000000258254370000002138960300000059633190000007011715000000495606000000750732100000032059318000000675295000000-675295000000455299580000001886489440000002555685050000003151297000000237459200000029640400000024929000000-23995210000003151297000000321470770000008046100000001056094000000-340077810000003400778100000019029421400000018183580000002274532920000000480914000000418724300000017019618000000485745400000026545229000000281152130000002555685050000001569984000000255568505000000320593180000003214707700000011962003000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/0001558370-21-004672-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/cib-20201231x20f.htm
26
2019-12-31CIBCOP10713712020-04-272020-04-27 14:10:482019FY18256065000000018256065000000802074000000-26902022000000269020220000001905813900000055199810000006694354000000538958000000723331200000019190511000000401002000000-401002000000319438040000001850861700000002360881130000003484151000000158600500000019575700000034290000000-16202950000003484151000000357124430000009807780000001521958000000-382151790000003821517900000016558316400000018315850000002072824940000000480914000000781236100000013733190000000485745400000026883919000000288056190000002360881130000001921700000000236088113000000191905110000003571244300000017456378000000
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/0001104659-20-051519-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/tm206804d3_20f.htm
27
2018-12-31CIBCOP10713712019-04-252019-04-24 21:56:012018FY1583301700000065420700000017798990000000634855000000201342200000021363159000000418104260000003368647000000663840300000056345200000072018550000001951105400000031500870000000-30791213000000307912130000001475119790000002201136180000003100664000000296813400000016647200000044598000000-301273200000031006640000003662519700000010882090000001318295000000-39031701000000390317010000001513260280000001333770000001934583930000000480914000000656580900000012944743000000485745400000024848920000000266552250000002201136180000001806305000000220113618000000201652610000003662519700000020792180000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/0001144204-19-021114-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/tv517668_20f.htm
28
2017-12-31CIBCOP10713712018-04-302018-04-30 6:29:512017FY15523123000000176146000000017284583000000256721000000-19399720000000193997200000001754130400000031274050000006095959000000535465000000663142400000017942312000000148614000000-14861400000027701141000000158665766000000203908211000000309329000000011383529000000161966000000-8290239000000-30932900000003093290000000334708660000005966880000001440198000000-355077520000003550775200000014087761900000001794786610000000480914000000618318200000011591414000000485745400000023112964000000244295500000002039082110000001316586000000203908211000000179423120000003347086600000017947743000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/0001144204-18-023396-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/tv487004_20f.htm
29
2016-12-31CIBCOP10713712017-05-012017-05-01 13:01:332016FY16216907000000160650600000017823413000000581153000000-21784530000000217845300000001840456600000031156970000006130095000000563942000000669403700000014358899000000222862000000-22286200000024168633000000153687845000000196261044000000288741800000012698832000000124802000000-9811414000000-28874180000002887418000000376106520000007255300000001325354000000-39661536000000396615360000001312351100000000173784064000000048091400000063806570000009548558000000485745400000021267583000000224769800000001962610440000001209397000000196261044000000143588990000003761065200000021393745000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/0001144204-17-023550-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/v461406_20f.htm
30
2015-12-31CIBCOP10713712016-04-222016-04-22 8:50:172015FY14295163000000138558700000015680750000000899485000000195080800000020173790000002054842200000032415620000006484669000000607586000000709225500000014824373000000170482000000-1499485500000010333817000000162090628000000192972867000000205176000000013533993000000193949000000121802028000000-155857530000001218020280000003915704900000081988600000083439200000099515930000005076292000000000172564948000000048091400000058505880000008090493000000485745400000019279449000000204079190000001929728670000001128470000000192972867000000148243730000003915704900000024861886000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/0001144204-16-095666-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/v436669_20f.htm
31
2014-12-31CIBCOP10713712015-04-282015-04-27 17:32:482014FY1119282500000015407700000011346902000000136241920000000024971094000000595009400000039706900000001711210000003970690000000136778010000000-23598585000000235985850000001001551820000001487248610000003242690000000000-2154202000000108848800000027529398000000557824000000237895000000257210700000005404618700000076772832000000013190750700000023842200000048091400000015377243000000-255500000007463250000001681735400000017311927000000148724861000000494573000000148724861000000136778010000002752939800000016336573000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/0001144204-15-025318-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/v406713_20f.htm
32
33
34
Cash Flow - FY
35
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriodNetincome
Depreciationandamortization
Deferredincometax
Stockbasedcompensation
Changeinworkingcapital
Accountsreceivables
Inventory
Accountspayables
Otherworkingcapital
Othernoncashitems
Netcashprovidedbyoperatingactivities
Investmentsinpropertyplantandequipment
Acquisitionsnet
Purchasesofinvestments
Salesmaturitiesofinvestments
Otherinvestingactivites
Netcashusedforinvestingactivites
Debtrepayment
Commonstockissued
Commonstockrepurchased
Dividendspaid
Otherfinancingactivites
Netcashusedprovidedbyfinancingactivities
Effectofforexchangesoncash
Netchangeincash
Cashatendofperiod
Cashatbeginningofperiod
Operatingcashflow
Capitalexpenditure
FreecashflowLinkFinallink
36
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023FY62149710000001082838000000193255500000004815748000000-525550000000-1150177700000094592300000015897152000000-1666601100000019153084000000-2412123000000185324000000-1159045000000014009028000000-351468000000-159689000000-1403285100000000-329818300000011900362000000-5430672000000-54084050000008154318000000397996090000003164529100000019153084000000-241212300000016740961000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
37
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022FY699636500000094944800000027484210000000-535868300000051505200000002719586000000-859332100000012286750000006564226000000-3538855000000-815282000000-1173318000000011256290000000176525000000-4654502000000-1273145400000000-2310666000000158955560000008534360000003552285000000631544500000031645291000000253298460000006564226000000-35388550000003025371000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
38
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021FY420778700000085516700000017762250000000-2460031000000-489266000000-24611401000000127134700000021369289000000-97205860000006095305000000-2185800000000-9178000000-1261753000000013752718000000409304000000-650486000000-1045561100000000-4672170000004112856000000-68099720000002993850000000162869700000025329846000000237011490000006095305000000-21858000000003909505000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
39
2020-12-31CIBCOP10713712021-04-232021-04-22 21:13:102020FY315359000000736367000000-658600000005037322000000-408015000000-7486103000000-79720700000013728647000000-945213100000011230345000000-1530153000000268898000000-1627749000000010122947000000-106269000000-7522067000000-2044171000000000-155582100000017082091000000-49154400000001170269000000-36893000000237011490000002373804200000011230345000000-15301530000009700192000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/0001558370-21-004672-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837021004672/cib-20201231x20f.htm
40
2019-12-31CIBCOP10713712020-04-272020-04-27 14:10:482019FY3214567000000677253000000126296400000002912523000000-185220000000-13088167000000-97726600000017163176000000-939613700000012315612000000-155545300000070306000000-87869940000007963092000000118217000000-2190832000000-1705205800000000-103249200000012823858000000-52606920000001431440000005007232000000237380420000001873081000000012315612000000-155545300000010760159000000
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/0001104659-20-051519-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000110465920051519/tm206804d3_20f.htm
41
2018-12-31CIBCOP10713712019-04-252019-04-24 21:56:012018FY27864350000004677770000008294350000000-6573248000000-423960000000-12546419000000-2738550000006670986000000-100584040000001042858000000-101409300000026000000-43216130000003769644000000184194000000-1381842000000-1635897800000000-73579800000016362065000000-732711000000163686100000056516600000018730810000000181656440000001042858000000-101409300000028765000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/0001144204-19-021114-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420419021114/tv517668_20f.htm
42
2017-12-31CIBCOP10713712018-04-302018-04-30 6:29:512017FY275417300000043303300000012898180000000-4415969000000338211000000-11116825000000-6299900000006992635000000-93852250000002939588000000-1132015000000-1534000000-34285220000002174929000000479062000000-1908080000000-1901206400000000-112620900000016517364000000-3620909000000294800000000-229460100000018165644000000204602450000002939588000000-11320150000001807573000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/0001144204-18-023396-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420418023396/tv487004_20f.htm
43
2016-12-31CIBCOP10713712017-05-012017-05-01 13:01:332016FY295494700000048290200000014263380000000-3116519000000263871000000-106934360000004455700000006867476000000-91182550000003601418000000-1082522000000-219311000000-25648600000002419464000000419602000000-1027627000000-1684371500000000-84024200000017340118000000-343839000000-575284000000165466800000020460245000000188055770000003601418000000-10825220000002518896000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/0001144204-17-023550-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420417023550/v461406_20f.htm
44
2015-12-31CIBCOP10713712016-04-222016-04-22 8:50:172015FY26088980000004815580000008104850000000-4423249000000-680752000000-14974407000000-35962800000011591538000000-69996740000001856726000000-961827000000783555000000-17776810000001942688000000155250000000141985000000-145053710000000-28081000000-78533200000015087310000000-2314740000003571557000000533879400000018805577000000134667830000001856726000000-961827000000894899000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/0001144204-16-095666-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420416095666/v436669_20f.htm
45
2014-12-31CIBCOP10713712015-04-282015-04-27 17:32:482014FY18787210000001212161000000792790000000-10024468000000-354295000000-12680305000000-18551000000302868300000027372000000-5753188000000-189756800000013590000000-4902555000000636869900000047507700000057243000000-286354700000000-713679000000518386700000016066410000002122787000000-19665170000001344212900000015408646000000-5753188000000-1897568000000-7650756000000
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/0001144204-15-025318-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000114420415025318/v406713_20f.htm
46
47
48
Ratios - FY
49
SymbolDateCalendaryearPeriodCurrentratioQuickratioCashratio
Daysofsalesoutstanding
Daysofinventoryoutstanding
Operatingcycle
Daysofpayablesoutstanding
Cashconversioncycle
Grossprofitmargin
Operatingprofitmargin
Pretaxprofitmargin
NetprofitmarginEffectivetaxrateReturnonassetsReturnonequity
Returnoncapitalemployed
Netincomeperebt
EbtperebitEbitperrevenueDebtratioDebtequityratio
Longtermdebttocapitalization
Totaldebttocapitalization
Interestcoverage
Cashflowtodebtratio
Companyequitymultiplier
Receivablesturnover
Payablesturnover
Inventoryturnover
Fixedassetturnover
Assetturnover
Operatingcashflowpershare
Freecashflowpershare
CashpersharePayoutratio
Operatingcashflowsalesratio
Freecashflowoperatingcashflowratio
Cashflowcoverageratios
Shorttermcoverageratios
Capitalexpenditurecoverageratio
Dividendpaidandcapexcoverageratio
Dividendpayoutratio
Pricebookvalueratio
Pricetobookratio
Pricetosalesratio
Priceearningsratio
Pricetofreecashflowsratio
Pricetooperatingcashflowsratio
Pricecashflowratio
Priceearningstogrowthratio
PricesalesratioDividendyield
Enterprisevaluemultiple
Pricefairvalue
50
CIB2023-12-312023FY67.451214468.1981724950.35765969220.57395780010.00032032826770.17066637650.12993551140.24053474490.017837334860.16059370880.000044055672290.7613421818532.78587530.00032032826770.093234575690.83941274960.45267429220.45634822840.00090471160970.59904264949.0032345121.654773771005.7716239860.137278367319913.231817405.37643-29085.255460.53918873760.40684842290.87406085620.599042649440.72568069-7.94034300921.616012460.53918873763.0089344133.0089344132.4345127518.73631566.8460134065.9838323395.9838323390.2726246212.434512750.02877773566102.10773773.008934413
51
CIB2022-12-312022FY4.2838881734.1828098254.10679419716.0747851845.3596684361.4344536448.7575165-387.32306290.79773084790.70334416780.40258240080.28024357740.28204015970.019226776450.17354004540.049092188150.69611482490.57238322170.70334416780.12207302581.1018258050.51295818650.52422317882.0165819960.15241127759.02595636922.706368760.81335684998.0467960342.8296937850.068607375876824.747073145.44195625702.301970.34063085520.27118521250.46088769640.15241127753.454368542-1.854901091-5.3446383250.34063085523.4052549643.4052549645.49902376119.6223007643.9971431520.2777419620.277741960.30157312215.4990237610.017359373888.3204760693.405254964
52
CIB2021-12-312021FY6.22621657513.625014165.81359029934.54146331061.43445360-387.323062910.33771425310.34468348110.23540239010.29682844890.014099443940.12678386190.020509148530.68295234031.0206364640.33771425310.13824990211.2431594160.49395712760.55420020851.3473387450.15210718938.9921178810.56701034002.5543804280.059895075566337.2155284064.66547524066.361210.11432357140.35109403950.64139612370.15210718930.7081032113-2.788592277-3.5467038830.11432357143.8320579193.8320579197.11506637530.2251237731.5957863420.2654148920.265414890.026466039277.1150663750.00378240209319.624447443.832057919
53
CIB2020-12-312020FY6.7875554114.982732516.40532263427.96496768061.43445360-387.323062910.017136206410.019640091830.01755512142-0.021329585160.00107992180.010397122590.0010673123360.89384110661.1461166710.017136206410.13507794711.3004848820.54772216650.56530903210.045950474570.32531292169.6276624713.05204441002.63637850.0615160541811676.0550510085.1733220986.179435.6371551560.71432737680.86374835320.32531292164.729378773-7.339360835437.52318065.6371551564.9710432014.9710432018.393405603478.11720613.6035946711.7500824911.75008249-5.3426263718.3934056030.01179032063143.09312044.971043201
54
CIB2019-12-312019FY5.46995207713.191208135.23974563718.50312571061.43445360-387.323062910.27684911480.28299345910.19702598210.28206705880.013204184490.11595597350.018831643980.69622097541.0221938380.27684911480.15798528581.3873887960.57051946570.58113232250.7088124620.33019100428.78175957219.72639682002.8663196490.0670174783412804.3941411187.208318980.61190.33120813150.77838381040.87370071420.33019100427.765178546-7.917701146-23.54977140.33120813156.4373753836.43737538310.938032555.5156857116.0835800314.0522353614.05223536-0.659505021610.93803250.0059660279336.603599186.437375383
55
CIB2018-12-312018FY13.4843459312.834994055.10633109615.9820771645080.2987445096.2808169423.5284-24327.247590.99887563660.63167090730.24938976280.18338420970.2293873950.012079507050.10700118960.042202618930.73533174590.39480963890.63167090730.17987678981.5933622470.59578240060.6144001861.6151968460.026339233758.85807584422.838082710.0052575835370.0080966632934.304063620.065869940864336.987837119.626502568566.276470.27673397360.071926841750.027582854040.026339233750.3513513878-1.028365249-3.7473113060.27673397361.1960112821.1960112822.04978640411.177551261033.18576928.4982122728.49821227-19.729265082.0497864040.024758014275.2472716031.196011282
56
57
Income Statement - Q
58
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriodRevenueCostofrevenueGrossprofitGrossprofitratio
Researchanddevelopmentexpenses
Generalandadministrativeexpenses
Sellingandmarketingexpenses
Sellinggeneralandadministrativeexpenses
Otherexpenses
Operatingexpenses
Costandexpenses
InterestincomeInterestexpense
Depreciationandamortization
EbitdaEbitdaratio
Operatingincome
Operatingincomeratio
Totalotherincomeexpensesnet
Incomebeforetax
Incomebeforetaxratio
Incometaxexpense
NetincomeNetincomeratioEpsEpsdiluted
Weightedaverageshsout
Weightedaverageshsoutdil
LinkFinallink
59
2024-06-30CIBCOP10713712024-04-102024-04-09 20:52:302024Q21103175500000001103175500000010000-23380880000002338088000000927700100000006924480000002897330000003237760000000.0293494553340430000000.0030859097176905400000017690540000000.160360160336332300000014397740000000.13051178171496.921496.929618270000
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/0001071371-24-000046-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/cib-20240409xex99d1.htm
60
2024-03-31CIBCOP10713712024-04-102024-04-09 20:52:302024Q111147744000000011147744000000102512703000000262340000002512703000000-191495500000019149550000008889766000000869134800000039390790000002634230000003306920000000.0296644774557500000000.0050010119230260200000023026020000000.206553182469488000000016634720000000.1492205061729.496917.97961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/0001071371-24-000046-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/cib-20240409xex99d1.htm
61
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023Q4118175420000000118175420000001025917890000001756900000002767479000000-23028590000002302859000000987913800000090446710000007935550000002968810000002668420000000.0225801609-69130000000-0.0058497782199145100000019914510000000.168516515547441400000014479090000000.12252201011505.371505.37961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
62
2023-09-30CIBCOP10713712023-09-302023-09-29 20:00:002023Q3676385000000006763850000000102585930000000387700000002585930000000-7412579000000-4826649000000-48266490000008944529000000425242200000026966400000019372010000000.286405079919372010000000.28640507992481600000019620170000000.290073996344544200000014917590000000.2205487999829.8829.8961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
63
2023-06-30CIBCOP10713712023-06-302023-06-30 0:00:002023Q2713857900000007138579000000102552962000000399640000002552962000000-7804722000000-5251760000000-52517600000009286957000000414101300000026121200000018868190000000.264312967618868190000000.26431296762367100000019104900000000.267628893642632800000014604910000000.2045912779812.29812.29961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
64
2023-03-31CIBCOP10713712023-03-312023-03-31 0:00:002023Q1737321400000007373214000000102463671000000275960000002463671000000-3553990000000-1090319000000-10903190000009191314000000402526300000025060100000063284110000000.858297480662828950000000.8521243246-393423100000023486640000000.318540055958637100000017167770000000.2328397087954.06954.06961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
65
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022Q46872933000000489606500000019768680000000.28763091390268135300000085636000000268135300000063146590000001845800000049145230000008157103000000318799800000027033400000051422810000000.748193093156719430000000.8252580085-369406000000019778830000000.287778594731158800000016426950000000.2390093138913.18913.18961827000961827000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
66
2022-09-30CIBCOP10713712022-09-302022-09-29 20:00:002022Q3632910500000006329105000000102211077000000414280000002211077000000-3735108000000-1524031000000-15240310000006827461000000237147800000024254800000048376800000000.764354517748050740000000.7592027625-230626600000024988080000000.394812220783695700000016292450000000.2574210736775.636775.63240456750240456750
67
2022-06-30CIBCOP10713712022-06-302022-06-29 20:00:002022Q2572234700000005722347000000102084738000000339630000002084738000000-3677922000000-1593184000000-15931840000005607685000000163983700000022049900000042043080000000.734717415841291630000000.7215855662-148954700000026396160000000.461282057978477600000017796950000000.31100787847401.317401.31240456750240456750
68
2022-03-31CIBCOP10713712022-03-312022-03-30 20:00:002022Q1528130800000005281308000000102000386000000240960000002000386000000-3410055000000-1409669000000-14096690000004841998000000124315700000021606700000037901150000000.717647029938716390000000.7330833574-124315700000026284820000000.497695267981510000000017318580000000.32792217387202.377202.37240456750240456750
69
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021Q4480911200000004809112000000102189984000000566310000002189984000000-3731139000000-1541155000000-15411550000004217109000000112947700000024858100000032233660000000.670262202332679570000000.6795343922-112947700000021384800000000.4446725364914500000014447440000000.30041803986008.336008.33240456750240456750
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
70
2021-09-30CIBCOP10713712021-09-302021-09-29 20:00:002021Q3437150700000004371507000000101886687000000416820000001886687000000-3671732000000-1785045000000-17850450000003889983000000106259900000021984900000025864620000000.591663698625864620000000.5916636986-103952400000015469380000000.35386835715812430000009426200000000.21562815753920.123920.12240456750240456750
71
72
73
Cash Flow - Q
74
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriodNetincome
Depreciationandamortization
Deferredincometax
Stockbasedcompensation
Changeinworkingcapital
Accountsreceivables
Inventory
Accountspayables
Otherworkingcapital
Othernoncashitems
Netcashprovidedbyoperatingactivities
Investmentsinpropertyplantandequipment
Acquisitionsnet
Purchasesofinvestments
Salesmaturitiesofinvestments
Otherinvestingactivites
Netcashusedforinvestingactivites
Debtrepayment
Commonstockissued
Commonstockrepurchased
Dividendspaid
Otherfinancingactivites
Netcashusedprovidedbyfinancingactivities
Effectofforexchangesoncash
Netchangeincash
Cashatendofperiod
Cashatbeginningofperiod
Operatingcashflow
Capitalexpenditure
FreecashflowLinkFinallink
75
2024-03-31CIBCOP10713712024-04-102024-04-09 20:52:302024Q116634720000002634230000006948800000000-984684000000-2749290000000-707776000000-596429400000015019360000001917301000000-291870000000110366000000-39211960000001850288000000-43061000000-9597377000000-131533500000000-849322000000-17279000000-5750268000000317182000000-1311316200000026686447000000397996090000001917301000000-2918700000001625431000000
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/0001071371-24-000046-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/cib-20240409xex99d1.htm
76
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023Q41447907000000296881000000003276330000000000-176178000000020227960000006450152000000-80863300000065972000000-148623200000035762730000001951337000000-1658225000000-3722000000000-84942900000085857720000007740185000000-17483170000001078379500000039799609000000290158140000006450152000000-8086330000005641519000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
77
2023-09-30CIBCOP10713712023-09-302023-09-28 20:00:002023Q3149175900000026966400000000282757000000000-191801100000014477600000002952612000000-44104500000036492000000-1631477000000776506000000-104757000000-2615029000000-253947100000000-8498190000001119151000000287805000000-30365700000032173100000029015814000000286940830000002952612000000-4410450000002511567000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
78
2023-06-30CIBCOP10713712023-06-302023-06-29 20:00:002023Q2146049100000026121200000000661023000000000-498562900000020842660000003944568000000-73574800000039583000000-26310880000006004463000000268035000000-2155137000000-64515000000000-84945000000020250190000001177881000000-260866000000035865200000028694083000000283354310000003944568000000-7357480000003208820000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
79
2023-03-31CIBCOP10713712023-03-312023-03-30 20:00:002023Q117167770000002506010000005863710000000-2914992000000-5172320000000-2360777000000-2811250000001912362000000463546000000-77816500000043277000000-70111030000003651786000000-44675000000-5455694000000-2289300000000-749485000000-166180000002430059000000-747771000000-33098600000002833543100000031645291000000463546000000-778165000000-314619000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
80
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022Q41642695000000270334000000003239740000000000-728223100000019560900000006568191000000-214320700000093397000000-12462820000002003283000000-139769000000-8753056000000-79316800000000-749404000000728942300000070998360000001956427000000663572500000031645291000000250095660000006568191000000-21432070000004424984000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
81
2022-09-30CIBCOP10713712022-09-302022-09-29 20:00:002022Q3162924500000024254800000000-330996000000000-931087600000011431050000002198806000000-639406000000145034000000-32319260000004273596000000285691000000-8524084000000-27408200000000-74981100000057228950000005433065000000128193500000035566500000025009566000000246539010000002198806000000-6394060000001559400000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
82
2022-06-30CIBCOP10713712022-06-302022-06-29 20:00:002022Q21779695000000220499000000001258082000000000-126884130000005274110000003344689000000-583050000000152358000000-50612710000007144674000000730277000000-11787490000000-81758500000000-748948000000641350700000056268790000001718176000000-101490800000024653901000000256688090000003344689000000-5830500000002761639000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
83
2022-03-31CIBCOP10713712022-03-312022-03-30 20:00:002022Q1173185800000021606700000000-362652000000000-833250700000010089640000002162103000000-41839600000031739000000-30469730000004504731000000-1176564000000-6550944000000-360836000000000-6250300000037513020000005945165000000-117946500000033896300000025668809000000253298460000002162103000000-4183960000001743707000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
84
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021Q41444744000000248581000000002042465000000000-79259690000004068360000003645464000000-1113591000000113937000000-2129585000000290455000000-154229000000-11001648000000-539744500000000-615170000001288423100000011654986000000855879000000515468100000025329846000000201751650000003645464000000-11135910000002531873000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
85
2021-09-30CIBCOP10713712021-09-302021-09-29 20:00:002021Q39426200000002198490000000086950000000000-689508600000012319070000002041628000000-579984000000238772000000-189267100000043387160000002015504000000-4591290000000-188914000000000-6251900000012053490000001030566000000365377000000-115371900000020175165000000213288840000002041628000000-5799840000001461644000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
86
2021-06-30CIBCOP10713712021-06-302021-06-29 20:00:002021Q2115691500000019369500000000693765000000000-68770030000009332230000002590208000000-33561900000051714000000-55667600000004923137000000-317642000000-7404096000000-64999500000000-6260200000066994460000004358338000000385313000000-7023700000021328884000000213991210000002590208000000-3356190000002254589000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
87
88
89
Balance Sheet - Q
90
DateSymbol
Reportedcurrency
CikFillingdateAccepteddateCalendaryearPeriod
Cashandcashequivalents
Shortterminvestments
Cashandshortterminvestments
NetreceivablesInventory
Othercurrentassets
Totalcurrentassets
Propertyplantequipmentnet
GoodwillIntangibleassets
Goodwillandintangibleassets
Longterminvestments
Taxassets
Othernoncurrentassets
Totalnoncurrentassets
OtherassetsTotalassets
Accountpayables
ShorttermdebtTaxpayables
Deferredrevenue
Othercurrentliabilities
Totalcurrentliabilities
Longtermdebt
Deferredrevenuenoncurrent
Deferredtaxliabilitiesnoncurrent
Othernoncurrentliabilities
Totalnoncurrentliabilities
Otherliabilities
Capitalleaseobligations
TotalliabilitiesPreferredstockCommonstock
Retainedearnings
Accumulatedothercomprehensiveincomeloss
Othertotalstockholdersequity
Totalstockholdersequity
Totalequity
Totalliabilitiesandstockholdersequity
Minorityinterest
Totalliabilitiesandtotalequity
Totalinvestments
TotaldebtNetdebtLinkFinallink
91
2024-06-30CIBCOP10713712024-04-102024-04-09 20:52:302024Q2-213747000000000-213747000000000035291538000000352915380000007716647000000002927894350000006294550000000796955000000930994700000031690753400000003521990720000000594983000000006956450000001290628000000301125850000002589913710000002128321000000194712170000003107034940000000181774000000031199412200000004809140000005779197000000281023500000004857454000000392199150000004020495000000035219907200000098503500000035219907200000062945500000003252530800000053900008000000
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/0001071371-24-000046-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/cib-20240409xex99d1.htm
92
2024-03-31CIBCOP10713712024-04-102024-04-09 20:52:302024Q119282299000000-38564598000000-19282299000000153446600000017747833000000300826620000003008266200000077106880000007859491000000852695100000085269510000007465965000000686104000000282484059000000306873767000000033695642900000014476510000001022224000000694914000000206636000000-9593730000001717138000000296792220000002458759940000001844141000000203893700000002977887270000000176102600000029950586500000004809140000004344094000000268030790000004857454000000364855410000003745056400000033695642900000096502300000033695642900000074659650000003246247200000013180173000000
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/0001071371-24-000046-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000107137124000046/cib-20240409xex99d1.htm
93
2023-12-31CIBCOP10713712024-03-262024-03-26 16:46:502023Q431958683000000-59933667000000-2797498400000028449029000000-4740450000004280683400000042806834000000815657900000078181250000006715720000008489697000000924987300000068561200000027354021400000030012197500000003429288090000006459875000000470295000000164339000000-64598750000001643390000006346340000003150252700000014170160000001785230000000268539673000000303244446000000017736100000003038790800000000480914000000863221400000024118930000000485745400000038089512000000390497290000003429288090000009602170000003429288090000009249873000000337464320000001787749000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
94
2023-09-30CIBCOP10713712023-09-302023-09-29 20:00:002023Q3209189250000000209189250000002163913000000-29946836000000299468360000002308283800000082603880000008291449000000598983000000889043200000030212554000000702862000000-702862000000473633740000002677377030000003381839150000000609617700000088681400000001385426990000001446388760000003371110700000001742089000000-3545319600000035453196000000-144638876000000170730100000035453196000000048091400000072097190000002498533100000048574540000003753341800000038494670000000338183915000000961252000000338183915000000302125540000003371110700000012792182000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
95
2023-06-30CIBCOP10713712023-06-302023-06-30 0:00:002023Q2237431390000000237431390000001556883000000-29497568000000294975680000002530002200000084655110000008544381000000585262000000912964300000029056174000000671478000000-671478000000466513280000002666453190000003385966690000000771534600000056170700000001404549690000001481703150000003683153700000001470474000000-3830201100000038302011000000-148170315000000174188600000038302011000000048091400000057072750000002549699600000048574540000003654263900000037498131000000338596669000000955492000000338596669000000290561740000003683153700000013088398000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
96
2023-03-31CIBCOP10713712023-03-312023-03-31 0:00:002023Q1238000720000000238000720000001444301000000-290489100000002904891000000025244373000000870041500000095014060000005911680000001009257400000033961563000000790751000000-790751000000527545520000002713240190000003493229440000000860834400000011174140000000150083703000000158692047000000398436280000000921345000000-4076497300000040764973000000-158692047000000187330000000040764973000000048091400000043545700000002722462500000048574540000003691756300000037853860000000349322944000000936297000000349322944000000339615630000003984362800000016043556000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/0001558370-24-003957-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837024003957/cib-20231231x20f.htm
97
2022-12-31CIBCOP10713712023-04-032023-04-03 12:04:192022Q4247211680000000247211680000001066031000000-355998450000003559984500000025787199000000855417400000098366610000006025310000001043919200000030855773000000764594000000-764594000000498491390000002771783950000003528147330000006019578000000993099200000096518000000096939000000-100279310000006019578000000411688940000001179386000000633361000000-36962063000000601957800000030077802600000019002680000003128171820000000480914000000100616540000002368888100000048574540000003908890300000039997551000000352814733000000908648000000352814733000000308557730000004116889400000016447726000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/0001558370-23-005367-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837023005367/cib-20221231x20f.htm
98
2022-09-30CIBCOP10713712022-09-302022-09-29 20:00:002022Q3216164390000000216164390000001719639000000-25621739000000256217390000002333607800000074998660000009387953000000553532000000994148500000031423264000000869403000000-869403000000488646150000002634538830000003356545760000000895604300000020533290000000-89560429999936.65388049690000000.0021875843628000000-396485969999990.512982557929999921846835000000298255793000000048091400000079428910000002324150400000048574540000003652276300000037398783000000335654576000000876020000000335654576000000314232640000003880496900000017188530000000
99
2022-06-30CIBCOP10713712022-06-302022-06-29 20:00:002022Q2214085290000000214085290000001257582000000-25206979000000252069790000002266611100000071688700000008490514000000500223000000899073700000030292077000000755533000000-7555330000004645168400000024431400800000031343180300000004001147000000134322800000001528057110000001568068580000003503247800000001084246000000-36116724000000278332783000000-15680685800000017829920000002783327830000000480914000000577184200000022171426000000485745400000033281636000000350990200000003134318030000001817384000000313431803000000302920770000003503247800000013623949000000
100
2022-03-31CIBCOP10713712022-03-312022-03-30 20:00:002022Q122075426000000-100902000000167543650000003236316000000-26776189000000262429550000001945744700000067932750000007683263000000471659000000815492200000030099641000000664290000000-1660389000000440517390000002279556310000002914648170000000068523500000001455432490000001455432490000003215908400000001424876000000-33583960000000259518213000000-14554324900000017297260000002595182130000000480914000000399827000000020863624000000485745400000030200262000000319466040000002914648170000001746342000000291464817000000299987390000003215908400000010083658000000
101
2021-12-31CIBCOP10713712022-04-272022-04-26 18:37:552021Q423147676000000850688000000245360870000001642933000000-579727400000029459415000000498411610000006796517000000814314600000048562600000086287720000003200986000000049354769000000-48394959000000483949590000001916189280000002898550480000003981649000000860793300000026165300000077115000000-86850480000003981649000000314644990000008769340000001016586000000-2937637000000039816490000002479662920000001819077000000255929590000000048091400000073605830000001953539600000048574540000003223434700000033925458000000289855048000000169111100000028985504800000032860548000000314644990000008316823000000
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/0001558370-22-006007-index.htm
https://www.sec.gov/Archives/edgar/data/1071371/000155837022006007/tmb-20211231x20f.htm
102
2021-09-30CIBCOP10713712021-09-302021-09-29 20:00:002021Q3174164030000000174164030000002079244000000-20707862000000207078620000001949564700000063009880000007788509000000469533000000825804200000029497900000000745647000000-745647000000440569300000002061986440000002697512210000000813477700000010010890000000131908368000000140043145000000298348590000000806106000000-30640965000000237881871000000-14004314500000017993650000002378818710000000480914000000583814300000019084628000000485745400000030261139000000318693500000002697512210000001608211000000269751221000000294979000000002983485900000012418456000000
103
104
153
Treasury rates
154
155
2024-07-282024728
156
DateMonth1Month2Month3Month6Year1Year2Year3Year5Year7Year10Year20Year30
157
2024-08-095.545.45.335.024.54.053.863.83.853.944.334.23
158
2024-08-085.555.425.345.014.484.043.863.833.893.994.384.28
159
2024-08-075.55.435.344.994.4543.813.793.853.964.354.26
160
2024-08-065.55.435.3454.463.993.763.733.793.94.284.18
161
2024-08-055.525.435.354.914.343.893.713.623.663.784.164.06
162
2024-08-025.545.435.294.884.333.883.73.623.683.84.194.11
163
2024-08-015.555.465.375.084.624.163.963.843.893.994.354.27
164
2024-07-315.495.515.415.144.734.294.13.9744.094.444.35
165
2024-07-305.55.55.45.164.784.354.164.034.064.154.54.4
166
2024-07-295.55.515.415.184.794.364.194.054.084.174.514.42
167
2024-03-055.55.475.475.354.944.544.324.134.154.134.394.27
168
169
Market Risk Premium
170
171
CountryContinent
Totalequityriskpremium
Countryriskpremium
172
Abu Dhabi5.750.75
173
British Virgin IslandsNorth America17.1311.19
174
BulgariaEurope7.432.43
175
Burkina FasoAfrica16.3811.38
176
CambodiaAsia13.358.35
177
CameroonAfrica13.358.35
178
Channel IslandsAfrica7.451.51
179
ChileSouth America6.281.28
180
ChinaAsia6.071.07
181
ColombiaSouth America7.892.89
182
Congo (Democratic Republic of)South America14.869.86
183
Congo (Republic of)South America18.6613.66
184
Cook IslandsOceania13.358.35
185
Costa RicaNorth America13.358.35
186
Côte d'IvoireAfrica10.465.46
187
CroatiaEurope7.892.89
188
CubaNorth America23.2118.21
189
CuracaoNorth America7.892.89
190
CyprusAsia8.83.8
191
Czech RepublicEurope5.910.91
192
LaosAsia20.1815.18
193
LatviaEurope6.821.82
194
LebanonAsia29.8224.82
195
LiberiaAfrica20.1815.18
196
LibyaAfrica7.892.89
197
LiechtensteinEurope50
198
MacaoAsia5.910.91
199
Yemen, RepublicAsia20.1815.18
200
ZimbabweAfrica16.3811.38
201
JerseyEurope4.240
202
DenmarkEurope50
203
Dominican RepublicNorth America10.465.46
204
EcuadorSouth America20.1815.18
205
EgyptAfrica14.869.86
206
El SalvadorNorth America20.1815.18
207
EstoniaEurope6.071.07
208
EthiopiaAfrica18.6613.66
209
FijiOceania11.836.83
210
FinlandEurope5.610.61
211
GuyanaSouth America7.432.43
212
HaitiNorth America23.2118.21
213
HondurasNorth America11.836.83
214
Hong KongAsia5.910.91
215
HungaryEurope7.892.89
216
IcelandEurope6.281.28
217
Falkland IslandsSouth America12.516.57
218
IndiaAsia8.333.33
219
IndonesiaAsia7.892.89
220
IraqAsia16.3811.38
221
IrelandEurope5.910.91
222
Isle of ManEurope5.910.91
223
IsraelAsia6.071.07
224
ItalyEurope8.333.33
225
JamaicaNorth America13.358.35
226
JapanAsia6.071.07
227
JordanAsia11.836.83
228
KazakhstanAsia7.892.89
229
KenyaAfrica14.869.86
230
Korea, D.P.R.Africa23.2118.21
231
KuwaitAsia6.071.07
232
KyrgyzstanAsia14.869.86
233
Ivory CoastAfrica12.156.21
234
AlbaniaEurope11.836.83
235
AlgeriaAfrica10.465.46
236
CanadaNorth America50
237
Cape VerdeAfrica14.869.86
238
Cayman IslandsNorth America5.910.91
239
FranceEurope5.750.75
240
French GuianaSouth America12.516.57
241
GabonAfrica16.3811.38
242
GambiaAfrica13.358.35
243
GeorgiaAsia9.574.57
244
GermanyEurope50
245
UruguaySouth America7.892.89
246
GibraltarEurope7.451.51
247
UzbekistanAsia10.465.46
248
GreenlandNorth America7.451.51
249
VenezuelaSouth America29.8224.82
250
VietnamAsia9.574.57
251
ZambiaAfrica23.2118.21
252
GuernseyEurope4.840.6
253
GhanaAfrica23.2118.21
254
GreeceEurope10.465.46
255
GuatemalaNorth America8.83.8
256
Guernsey (States of)North America5.750.75
257
GuineaAfrica18.6613.66
258
Guinea-BissauAfrica13.358.35
259
Jersey (States of)Africa5.910.91
260
KoreaAfrica5.750.75
261
LithuaniaEurope6.281.28
262
South KoreaAsia6.790.85
263
LuxembourgEurope50
264
MacedoniaEurope10.465.46
265
MadagascarAfrica14.869.86
266
MalawiAfrica23.2118.21
267
MalaysiaAsia6.821.82
268
MaldivesAsia16.3811.38
269
South AfricaAfrica9.574.57
270
Sri LankaAsia23.2118.21
271
St. MaartenAsia9.574.57
272
St. Vincent & the GrenadinesAsia14.869.86
273
SudanAfrica29.8224.82
274
SurinameSouth America20.1815.18
275
SwazilandAfrica14.869.86
276
SwedenEurope50
277
SwitzerlandEurope50
278
SyriaAsia29.8224.82
279
TaiwanAsia5.910.91
280
TajikistanAsia14.869.86
281
TanzaniaAfrica13.358.35
282
ThailandAsia7.432.43
283
TogoAfrica14.869.86
284
Trinidad and TobagoNorth America9.574.57
285
TunisiaAfrica18.6613.66
286
TurkeyAsia14.869.86
287
Turks and Caicos IslandsNorth America7.432.43
288
YemenAsia30.6324.69
289
UgandaAfrica13.358.35
290
UkraineEurope23.2118.21
291
United Arab EmiratesAsia5.750.75
292
United KingdomEurope5.910.91
293
United StatesNorth America50
294
Andorra (Principality of)North America7.892.89
295
AngolaAfrica14.869.86
296
IranAsia14.869.86
297
AnguillaNorth America17.1311.19
298
Antigua & BarbudaNorth America17.1311.19
299
ArgentinaSouth America23.2118.21
300
ArmeniaAsia10.465.46
301
ArubaNorth America7.892.89
302
AustraliaOceania50
303
AustriaEurope5.610.61
304
AzerbaijanAsia8.83.8
305
BahamasNorth America11.836.83
306
BahrainAsia13.358.35
307
BangladeshAsia11.836.83
308
BarbadosNorth America16.3811.38
309
BelarusEurope29.8224.82
310
BelgiumEurope5.910.91
311
BelizeNorth America18.6613.66
312
BeninAfrica11.836.83
313
BermudaNorth America6.281.28
314
BoliviaSouth America16.3811.38
315
Bosnia and HerzegovinaEurope14.869.86
316
BotswanaAfrica6.821.82
317
BrazilSouth America9.574.57
318
BruneiAsia5.910.91
319
MartiniqueNorth America17.1311.19
320
MaliAfrica18.6613.66
321
MaltaEurope6.281.28
322
MauritiusAfrica8.333.33
323
MexicoNorth America7.892.89
324
MoldovaEurope14.869.86
325
MongoliaAsia14.869.86
326
Netherlands AntillesAsia17.1311.19
327
MontenegroEurope11.836.83
328
MontserratNorth America8.333.33
329
MoroccoAfrica8.83.8
330
MozambiqueAfrica18.6613.66
331
MyanmarAsia20.1815.18
332
NamibiaAfrica11.836.83
333
NetherlandsEurope50
334
Palestinian AuthorityEurope8.452.51
335
New ZealandOceania50
336
NicaraguaNorth America14.869.86
337
NigerAfrica14.869.86
338
NigeriaAfrica16.3811.38
339
NorwayEurope50
340
OmanAsia9.574.57
341
PakistanAsia20.1815.18
342
PanamaNorth America7.892.89
343
Papua New GuineaOceania13.358.35
344
ReunionOceania7.451.51
345
ParaguaySouth America8.83.8
346
PeruSouth America7.432.43
347
PhilippinesAsia7.892.89
348
Saint LuciaNorth America17.1311.19
349
PolandEurope6.281.28
350
PortugalEurope7.892.89
351
QatarAsia5.910.91
352
Ras Al Khaimah (Emirate of)Asia6.821.82
353
RomaniaEurope8.333.33
354
RussiaEurope23.2118.21
355
RwandaAfrica13.358.35
356
Saudi ArabiaAsia6.071.07
357
SenegalAfrica10.465.46
358
SerbiaEurope9.574.57
359
SharjahEurope8.83.8
360
Sierra LeoneAfrica23.2118.21
361
SingaporeAsia50
362
SlovakiaEurope6.281.28
363
SloveniaEurope6.821.82
364
Solomon IslandsOceania16.3811.38
365
SomaliaAfrica23.2118.21
366
SpainEurope7.432.43
1
2
Bancolombia S.A.
3
4
CO | Financial Services | Banks - Regional
5
6
Quick LookStock Price per Share / Intrinsic Value - Price Fair Value
7
6.444.973.833.413.01
8
Country
CO
Currency
USD
Exchange
NYSE
9
Avg Volume
242,945
FTEs
34,756
EV/EBITDA
102.1x
10
Price
32
ROE
16.1%
P/E
18.7x
11
Market Cap
7.9B
ROA
1.8%
P/B
3.0x
12
Beta
1.14
Gross Margin
100.0%
Debt/Equity
0.8x
13
52 Week
24.15-37.85
DPS
53.9%
Current Ratio
67.5x
14
20192020202120222023
15
P/E - Price / Earnings RatioEV/EBITDA - Enterprise Value Multiplier
16
17
55.52478.1230.2319.6218.7436.60143.0919.628.32102.11
18
19
20
21
22
23
24
25
26
27
28
2019202020212022202320192020202120222023
29
30
P/B - Price Book Value RatioDebt / Equity - Debt Equity Ratio
31
32
6.444.973.833.413.011.391.301.241.100.84
33
34
35
36
37
38
39
40
41
42
43
2019202020212022202320192020202120222023
1
2
About the Company
3
4
Company NameBancolombia S.A.
5
CEOMr. Juan Carlos Mora Uribe
6
CountryCO
7
SectorFinancial Services
8
IndustryBanks - Regional
9
Websitehttps://www.grupobancolombia.com
10
ExchangeNew York Stock Exchange
11

Description		Bancolombia S.A. provides banking products and services in Colombia, Panama, Puerto Rico, El Salvador, Costa Rica, and Guatemala. The company operates through nine segments: Banking Colombia, Banking Panama, Banking El Salvador, Banking Guatemala, Trust, Investment Banking, Brokerage, International Banking, and All Other. It offers checking and savings accounts, fixed term deposits, and investment products; trade financing, loans funded by domestic development banks, working capital loans, credit cards, personal and vehicle loans, payroll loans, and overdrafts; financial support to real estate developers and mortgages for individuals and companies; factoring; and financial and operating leasing services. The company also provides hedging instruments, including futures, forwards, options, and swaps; and brokerage, investment advisory, and private banking services, including selling and distributing equities, futures, foreign currencies, fixed income securities, mutual funds, and structured products. In addition, it offers cash management services; foreign currency transaction services; life, auto, commercial, and homeowner's insurance products; and online and computer banking services. Further, the company provides project and acquisition finance, debt and equity capital markets, principal investments, M&A, hedging strategies, restructurings, and structured financing; money market accounts, mutual and pension funds, private equity funds, payment and corporate trust, and custody; internet-based trading platform; inter-bank lending and repurchase agreements; managing escrow accounts, and investment and real estate funds; and transportation, securities brokerage, maintenance and remodeling, and outsourcing services. As of December 31, 2021, it operated 1,015 branches; 28,676 banking correspondents; 529 PAMs; 210 kiosks in El Salvador and 187 in Colombia; and 6,094 ATMs. Bancolombia S.A. was incorporated in 1945 and is headquartered in Medellín, Colombia.
12
1
2
Income Statement - (USD 'MM)
3
4
Year2014201520162017201820192020202120222023
5
6
Revenue 9,339,578 10,621,282 13,541,577 14,621,478 14,498,871 15,822,030 15,721,566 17,360,890 24,205,693 47,076,707
7
 Cost of Revenue - - - - (16,302) - - - (4,896,065) -
8
Gross Profit 9,339,578 10,621,282 13,541,577 14,621,478 14,482,569 15,822,030 15,721,566 17,360,890 19,309,628 47,076,707
9
 Gross Margin, %100.0%100.0%100.0%100.0%99.9%100.0%100.0%100.0%79.8%100.0%
10
EBITDA 6,920,744 7,687,639 10,578,162 10,519,617 9,626,292 5,204,905 1,005,775 6,718,187 17,974,381 1,139,939
11
 EBITDA, %74.1%72.4%78.1%71.9%66.4%32.9%6.4%38.7%74.3%2.4%
12
Operating Income (EBIT) 5,985,817 374,039 10,060,353 10,040,734 9,158,515 4,380,315 269,408 5,863,020 17,024,933 15,080
13
 EBIT, %64.1%3.5%74.3%68.7%63.2%27.7%1.7%33.8%70.3%0.0%
14
Profit Before Tax 2,467,796 3,235,635 3,968,282 3,992,771 3,615,870 4,477,531 308,773 5,984,012 9,744,786 8,034,411
15
 Earnings Before Tax, %26.4%30.5%29.3%27.3%24.9%28.3%2.0%34.5%40.3%17.1%
16
Net Profit After Tax 1,878,721 2,518,890 2,865,328 2,615,000 2,658,864 3,117,351 275,994 4,086,795 6,783,490 6,116,936
17
 Profit Margin, %20.1%23.7%21.2%17.9%18.3%19.7%1.8%23.5%28.0%13.0%
18
19
Cash Flow Statement - (USD 'MM)
20
21
Year2014201520162017201820192020202120222023
22
23
 Net Income 1,878,721 2,608,898 2,954,947 2,754,173 2,786,435 3,214,567 315,359 4,207,787 6,996,365 6,214,971
24
 Depreciation & Amortization 1,212,161 481,558 482,902 433,033 467,777 677,253 736,367 855,167 949,448 1,082,838
25
 Deferred income taxes 79,279 810,485 1,426,338 1,289,818 829,435 1,262,964 (6,586) 1,776,225 2,748,421 1,932,555
26
 Stock-based compensation - - - - - - - - - -
27
 Change in working capital (10,024,468) (4,423,249) (3,116,519) (4,415,969) (6,573,248) 2,912,523 5,037,322 (2,460,031) (5,358,683) 4,815,748
28
 Other non-cash items 27,372 (6,999,674) (9,118,255) (9,385,225) (10,058,404) (9,396,137) (9,452,131) (9,720,586) 1,228,675 (16,666,011)
29
Operating Cash Flow (5,753,188) 1,856,726 3,601,418 2,939,588 1,042,858 12,315,612 11,230,345 6,095,305 6,564,226 19,153,084
30
 Investments in PPE (1,897,568) (961,827) (1,082,522) (1,132,015) (1,014,093) (1,555,453) (1,530,153) (2,185,800) (3,538,855) (2,412,123)
31
 Acquisitions 13,590 783,555 (219,311) (1,534) 26 70,306 268,898 (9,178) (815,282) 185,324
32
 Investment purchases (4,902,555) (1,777,681) (2,564,860) (3,428,522) (4,321,613) (8,786,994) (16,277,490) (12,617,530) (11,733,180) (11,590,450)
33
 Sales/Maturities of investments 6,368,699 1,942,688 2,419,464 2,174,929 3,769,644 7,963,092 10,122,947 13,752,718 11,256,290 14,009,028
34
 Other Investing Activites 475,077 155,250 419,602 479,062 184,194 118,217 (106,269) 409,304 176,525 (351,468)
35
Investing Cash Flow 57,243 141,985 (1,027,627) (1,908,080) (1,381,842) (2,190,832) (7,522,067) (650,486) (4,654,502) (159,689)
36
 Debt repayment (2,863,547) (14,505,371) (16,843,715) (19,012,064) (16,358,978) (17,052,058) (20,441,710) (10,455,611) (12,731,454) (14,032,851)
37
 Dividends payments (713,679) (785,332) (840,242) (1,126,209) (735,798) (1,032,492) (1,555,821) (467,217) (2,310,666) (3,298,183)
38
 Common Stock Repurchased - (28,081) - - - - - - - -
39
 Common Stock Issuance - - - - - - - - - -
40
 Other Financing Activites 5,183,867 15,087,310 17,340,118 16,517,364 16,362,065 12,823,858 17,082,091 4,112,856 15,895,556 11,900,362
41
Financing Cash Flow 1,606,641 (231,474) (343,839) (3,620,909) (732,711) (5,260,692) (4,915,440) (6,809,972) 853,436 (5,430,672)
42
Cash at beginning of period 15,408,646 13,466,783 18,805,577 20,460,245 18,165,644 18,730,810 23,738,042 23,701,149 25,329,846 31,645,291
43
Net cash flow / Change in cash (1,966,517) 5,338,794 1,654,668 (2,294,601) 565,166 5,007,232 (36,893) 1,628,697 6,315,445 8,154,318
44
Cash at end of period 13,442,129 18,805,577 20,460,245 18,165,644 18,730,810 23,738,042 23,701,149 25,329,846 31,645,291 39,799,609
45
46
Balance Sheet Statement - (USD 'MM)
47
48
Year2014201520162017201820192020202120222023
49
50
 Cash and cash equivalents 11,192,825 14,295,163 16,216,907 15,523,123 15,833,017 18,256,065 20,185,074 23,147,676 24,721,168 31,958,683
51
 Short Term Investments 154,077 1,385,587 1,606,506 1,761,460 654,207 - - - - (59,933,667)
52
Cash and Short Term Investments 11,346,902 15,680,750 17,823,413 17,284,583 17,798,990 18,256,065 20,185,074 23,147,676 24,721,168 (27,974,984)
53
 Account Receivables 13,624,192 899,485 581,153 256,721 634,855 802,074 1,204,529 1,642,933 1,066,031 28,449,029
54
 Inventory - 1,950,808 (21,784,530) (19,399,720) 2,013,422 (26,902,022) (25,825,437) (29,459,415) 608,449 (474,045)
55
 Other Current Assets - 2,017,379 21,784,530 19,399,720 21,363,159 26,902,022 25,825,437 29,459,415 (608,449) 42,806,834
56
Total Current Assets 24,971,094 20,548,422 18,404,566 17,541,304 41,810,426 19,058,139 21,389,603 24,790,609 25,787,199 42,806,834
57
 Goodwill 3,970,690 6,484,669 6,130,095 6,095,959 6,638,403 6,694,354 7,011,715 8,143,146 9,836,661 7,818,125
58
 Intangible Assets 171,121 607,586 563,942 535,465 563,452 538,958 495,606 485,626 602,531 671,572
59
Goodwill and Intangible Assets 3,970,690 7,092,255 6,694,037 6,631,424 7,201,855 7,233,312 7,507,321 8,628,772 10,439,192 8,489,697
60
 Long Term Investments 13,677,801 14,824,373 14,358,899 17,942,312 19,511,054 19,190,511 32,059,318 32,009,860 30,855,773 9,249,873
61
 Property, Plant & Equipment Net 5,950,094 3,241,562 3,115,697 3,127,405 3,368,647 5,519,981 5,963,319 6,796,517 8,554,174 8,156,579
62
 Other non-current Assets (23,598,585) (14,994,855) (222,862) (148,614) (30,791,213) (401,002) (675,295) (746,375) (764,594) 273,540,214
63
Total non-current Assets 23,598,585 10,333,817 24,168,633 27,701,141 30,791,213 31,943,804 45,529,958 47,435,149 49,849,139 300,121,975
64
Total assets 148,724,861 192,972,867 196,261,044 203,908,211 220,113,618 236,088,113 255,568,505 289,855,048 352,814,733 342,928,809
65
 Short Term debt - 13,533,993 12,698,832 11,383,529 2,968,134 1,586,005 2,374,592 8,607,933 1,900,268 470,295
66
 Account Payables 3,242,690 2,051,760 2,887,418 3,093,290 3,100,664 3,484,151 3,151,297 3,981,649 6,019,578 6,459,875
67
 Deferred revenue - 121,802,028 (9,811,414) (8,290,239) 44,598 34,290 24,929 77,115 250,992,323 (6,459,875)
68
 Other Current Liabilities (2,154,202) (15,585,753) (2,887,418) (3,093,290) (3,012,732) (1,620,295) (2,399,521) (8,685,048) (252,892,591) 164,339
69
Total current liabilities 1,088,488 121,802,028 2,887,418 3,093,290 3,100,664 3,484,151 3,151,297 3,981,649 6,019,578 634,634
70
 Long Term debt 27,529,398 39,157,049 37,610,652 33,470,866 36,625,197 35,712,443 32,147,077 31,464,499 41,168,894 31,502,527
71
 Deferred Revenue Non Current 557,824 819,886 725,530 596,688 1,088,209 980,778 804,610 876,934 1,179,386 1,417,016
72
 Deferred Tax Liabilities Non Current 237,895 834,392 1,325,354 1,440,198 1,318,295 1,521,958 1,056,094 1,016,586 633,361 1,785,230
73
 Other non-current Liabilities 25,721,070 9,951,593 (39,661,536) (35,507,752) (39,031,701) (38,215,179) (34,007,781) (33,358,019) (36,962,063) 268,539,673
74
Total non-current liabilities 54,046,187 50,762,920 39,661,536 35,507,752 39,031,701 38,215,179 34,007,781 33,358,019 6,019,578 303,244,446
75
Total liabilities 131,907,507 172,564,948 173,784,064 179,478,661 193,458,393 207,282,494 227,453,292 255,929,590 312,817,182 303,879,080
76
 Common Stock 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914
77
 Retained earnings 15,377,243 5,850,588 6,380,657 6,183,182 6,565,809 7,812,361 4,187,243 7,360,583 10,061,654 8,632,214
78
 Other Income/Loss (25,550) 8,090,493 9,548,558 11,591,414 12,944,743 13,733,190 17,019,618 19,535,396 23,688,881 24,118,930
79
 Other Stockholders Equity 746,325 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454
80
Total shareholders equity 16,817,354 19,279,449 21,267,583 23,112,964 24,848,920 26,883,919 26,545,229 32,234,347 39,088,903 38,089,512
81
Minority Interest 494,573 1,128,470 1,209,397 1,316,586 1,806,305 1,921,700 1,569,984 1,691,111 908,648 960,217
82
Total Equity 17,311,927 20,407,919 22,476,980 24,429,550 26,655,225 28,805,619 28,115,213 33,925,458 39,997,551 39,049,729
83
Total debt 27,529,398 39,157,049 37,610,652 33,470,866 36,625,197 35,712,443 32,147,077 31,464,499 41,168,894 33,746,432
84
Total Investments 13,677,801 14,824,373 14,358,899 17,942,312 20,165,261 19,190,511 32,059,318 32,009,860 30,855,773 9,249,873
85
Net Debt 16,336,573 24,861,886 21,393,745 17,947,743 20,792,180 17,456,378 11,962,003 8,316,823 16,447,726 1,787,749
1
2
Income Statement - (USD 'MM)
3
4
Year2021-Q32021-Q42022-Q12022-Q22022-Q32022-Q42023-Q12023-Q22023-Q32023-Q42024-Q12024-Q2
5
6
Revenue 4,371,507 4,809,112 5,281,308 5,722,347 6,329,105 6,872,933 7,373,214 7,138,579 6,763,850 11,817,542 11,147,744 11,031,755
7
 Cost of Revenue - - - - - (4,896,065) - - - - - -
8
Gross Profit 4,371,507 4,809,112 5,281,308 5,722,347 6,329,105 1,976,868 7,373,214 7,138,579 6,763,850 11,817,542 11,147,744 11,031,755
9
 Gross Margin, %100.0%100.0%100.0%100.0%100.0%28.8%100.0%100.0%100.0%100.0%100.0%100.0%
10
EBITDA 2,586,462 3,223,366 3,790,115 4,204,308 4,837,680 5,142,281 6,328,411 1,886,819 1,937,201 266,842 330,692 323,776
11
 EBITDA, %59.2%67.0%71.8%73.5%76.4%74.8%85.8%26.4%28.6%2.3%3.0%2.9%
12
Operating Income (EBIT) 2,586,462 3,267,957 3,871,639 4,129,163 4,805,074 5,671,943 6,282,895 1,886,819 1,937,201 (69,130) 55,750 34,043
13
 EBIT, %59.2%68.0%73.3%72.2%75.9%82.5%85.2%26.4%28.6%-0.6%0.5%0.3%
14
Profit Before Tax 1,546,938 2,138,480 2,628,482 2,639,616 2,498,808 1,977,883 2,348,664 1,910,490 1,962,017 1,991,451 2,302,602 1,769,054
15
 Earnings Before Tax, %35.4%44.5%49.8%46.1%39.5%28.8%31.9%26.8%29.0%16.9%20.7%16.0%
16
Net Profit After Tax 942,620 1,444,744 1,731,858 1,779,695 1,629,245 1,642,695 1,716,777 1,460,491 1,491,759 1,447,909 1,663,472 1,439,774
17
 Profit Margin, %21.6%30.0%32.8%31.1%25.7%23.9%23.3%20.5%22.1%12.3%14.9%13.1%
18
19
Cash Flow Statement - (USD 'MM)
20
21
Year2021-Q32021-Q42022-Q12022-Q22022-Q32022-Q42023-Q12023-Q22023-Q32023-Q42024-Q12024-Q2
22
23
 Net Income 1,156,915 942,620 1,444,744 1,731,858 1,779,695 1,629,245 1,642,695 1,716,777 1,460,491 1,491,759 1,447,907 1,663,472
24
 Depreciation & Amortization 193,695 219,849 248,581 216,067 220,499 242,548 270,334 250,601 261,212 269,664 296,881 263,423
25
 Deferred income taxes - - - - - - - 586,371 - - - 694,880
26
 Stock-based compensation - - - - - - - - - - - -
27
 Change in working capital 693,765 86,950 2,042,465 (362,652) 1,258,082 (330,996) 3,239,740 (2,914,992) 661,023 282,757 3,276,330 (984,684)
28
 Other non-cash items 933,223 1,231,907 406,836 1,008,964 527,411 1,143,105 1,956,090 1,912,362 2,084,266 1,447,760 2,022,796 1,501,936
29
Operating Cash Flow 2,590,208 2,041,628 3,645,464 2,162,103 3,344,689 2,198,806 6,568,191 463,546 3,944,568 2,952,612 6,450,152 1,917,301
30
 Investments in PPE (335,619) (579,984) (1,113,591) (418,396) (583,050) (639,406) (2,143,207) (778,165) (735,748) (441,045) (808,633) (291,870)
31
 Acquisitions 51,714 238,772 113,937 31,739 152,358 145,034 93,397 43,277 39,583 36,492 65,972 110,366
32
 Investment purchases (5,566,760) (1,892,671) (2,129,585) (3,046,973) (5,061,271) (3,231,926) (1,246,282) (7,011,103) (2,631,088) (1,631,477) (1,486,232) (3,921,196)
33
 Sales/Maturities of investments 4,923,137 4,338,716 290,455 4,504,731 7,144,674 4,273,596 2,003,283 3,651,786 6,004,463 776,506 3,576,273 1,850,288
34
 Other Investing Activites (317,642) 2,015,504 (154,229) (1,176,564) 730,277 285,691 (139,769) (44,675) 268,035 (104,757) 1,951,337 (43,061)
35
Investing Cash Flow (7,404,096) (4,591,290) (11,001,648) (6,550,944) (11,787,490) (8,524,084) (8,753,056) (5,455,694) (2,155,137) (2,615,029) (1,658,225) (9,597,377)
36
 Debt repayment (649,995) (1,889,140) (5,397,445) (3,608,360) (817,585) (274,082) (793,168) (22,893) (645,150) (2,539,471) (37,220) (1,315,335)
37
 Dividends payments (62,602) (62,519) (61,517) (62,503) (748,948) (749,811) (749,404) (749,485) (849,450) (849,819) (849,429) (849,322)
38
 Common Stock Repurchased - - - - - - - - - - - -
39
 Common Stock Issuance - - - - - - - - - - - -
40
 Other Financing Activites 6,699,446 1,205,349 12,884,231 3,751,302 6,413,507 5,722,895 7,289,423 (16,618) 2,025,019 1,119,151 8,585,772 (17,279)
41
Financing Cash Flow 4,358,338 1,030,566 11,654,986 5,945,165 5,626,879 5,433,065 7,099,836 2,430,059 1,177,881 287,805 7,740,185 (5,750,268)
42
Cash at beginning of period 21,399,121 21,328,884 20,175,165 25,329,846 25,668,809 24,653,901 25,009,566 31,645,291 28,335,431 28,694,083 29,015,814 39,799,609
43
Net cash flow / Change in cash (70,237) (1,153,719) 5,154,681 338,963 (1,014,908) 355,665 6,635,725 (3,309,860) 358,652 321,731 10,783,795 (13,113,162)
44
Cash at end of period 21,328,884 20,175,165 25,329,846 25,668,809 24,653,901 25,009,566 31,645,291 28,335,431 28,694,083 29,015,814 39,799,609 26,686,447
45
46
Balance Sheet Statement - (USD 'MM)
47
48
Year2021-Q32021-Q42022-Q12022-Q22022-Q32022-Q42023-Q12023-Q22023-Q32023-Q42024-Q12024-Q2
49
50
 Cash and cash equivalents 17,416,403 23,147,676 22,075,426 21,408,529 21,616,439 24,721,168 23,800,072 23,743,139 20,918,925 31,958,683 19,282,299 (21,374,700)
51
 Short Term Investments - 850,688 (100,902) - - - - - - (59,933,667) (38,564,598) -
52
Cash and Short Term Investments 17,416,403 24,536,087 16,754,365 21,408,529 21,616,439 24,721,168 23,800,072 23,743,139 20,918,925 (27,974,984) (19,282,299) (21,374,700)
53
 Account Receivables 2,079,244 1,642,933 3,236,316 1,257,582 1,719,639 1,066,031 1,444,301 1,556,883 2,163,913 28,449,029 1,534,466 -
54
 Inventory (20,707,862) (5,797,274) (26,776,189) (25,206,979) (25,621,739) (35,599,845) (29,048,910) (29,497,568) (29,946,836) (474,045) 17,747,833 -
55
 Other Current Assets 20,707,862 29,459,415 26,242,955 25,206,979 25,621,739 35,599,845 29,048,910 29,497,568 29,946,836 42,806,834 30,082,662 35,291,538
56
Total Current Assets 19,495,647 49,841,161 19,457,447 22,666,111 23,336,078 25,787,199 25,244,373 25,300,022 23,082,838 42,806,834 30,082,662 35,291,538
57
 Goodwill 7,788,509 8,143,146 7,683,263 8,490,514 9,387,953 9,836,661 9,501,406 8,544,381 8,291,449 7,818,125 7,859,491 -
58
 Intangible Assets 469,533 485,626 471,659 500,223 553,532 602,531 591,168 585,262 598,983 671,572 8,526,951 -
59
Goodwill and Intangible Assets 8,258,042 8,628,772 8,154,922 8,990,737 9,941,485 10,439,192 10,092,574 9,129,643 8,890,432 8,489,697 8,526,951 292,789,435
60
 Long Term Investments 29,497,900 32,009,860 30,099,641 30,292,077 31,423,264 30,855,773 33,961,563 29,056,174 30,212,554 9,249,873 7,465,965 6,294,550
61
 Property, Plant & Equipment Net 6,300,988 6,796,517 6,793,275 7,168,870 7,499,866 8,554,174 8,700,415 8,465,511 8,260,388 8,156,579 7,710,688 7,716,647
62
 Other non-current Assets (745,647) (48,394,959) (1,660,389) (755,533) (869,403) (764,594) (790,751) (671,478) (702,862) 273,540,214 282,484,059 9,309,947
63
Total non-current Assets 44,056,930 48,394,959 44,051,739 46,451,684 48,864,615 49,849,139 52,754,552 46,651,328 47,363,374 300,121,975 306,873,767 316,907,534
64
Total assets 269,751,221 289,855,048 291,464,817 313,431,803 335,654,576 352,814,733 349,322,944 338,596,669 338,183,915 342,928,809 336,956,429 352,199,072
65
 Short Term debt 8,134,777 8,607,933 - 4,001,147 8,956,043 9,930,992 8,608,344 7,715,346 6,096,177 470,295 1,022,224 594,983
66
 Account Payables - 3,981,649 - - - 6,019,578 - - - 6,459,875 1,447,651 -
67
 Deferred revenue - 77,115 - - - 96,939 - - - (6,459,875) 206,636 -
68
 Other Current Liabilities 131,908,368 (8,685,048) 145,543,249 152,805,711 (8,956,043) (10,027,931) 150,083,703 140,454,969 138,542,699 164,339 (959,373) 695,645
69
Total current liabilities 140,043,145 3,981,649 145,543,249 156,806,858 0 6,019,578 158,692,047 148,170,315 144,638,876 634,634 1,717,138 1,290,628
70
 Long Term debt 29,834,859 31,464,499 32,159,084 35,032,478 38,804,969 41,168,894 39,843,628 36,831,537 33,711,107 31,502,527 29,679,222 30,112,585
71
 Deferred Revenue Non Current - 876,934 - - 0 1,179,386 - - - 1,417,016 245,875,994 258,991,371
72
 Deferred Tax Liabilities Non Current 806,106 1,016,586 1,424,876 1,084,246 843,628 633,361 921,345 1,470,474 1,742,089 1,785,230 1,844,141 2,128,321
73
 Other non-current Liabilities (30,640,965) (29,376,370) (33,583,960) (36,116,724) (39,648,597) (36,962,063) (40,764,973) (38,302,011) (35,453,196) 268,539,673 20,389,370 19,471,217
74
Total non-current liabilities 237,881,871 3,981,649 259,518,213 278,332,783 0 6,019,578 40,764,973 38,302,011 35,453,196 303,244,446 297,788,727 310,703,494
75
Total liabilities 237,881,871 255,929,590 259,518,213 278,332,783 298,255,793 312,817,182 40,764,973 38,302,011 35,453,196 303,879,080 299,505,865 311,994,122
76
 Common Stock 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914 480,914
77
 Retained earnings 5,838,143 7,360,583 3,998,270 5,771,842 7,942,891 10,061,654 4,354,570 5,707,275 7,209,719 8,632,214 4,344,094 5,779,197
78
 Other Income/Loss 19,084,628 19,535,396 20,863,624 22,171,426 23,241,504 23,688,881 27,224,625 25,496,996 24,985,331 24,118,930 26,803,079 28,102,350
79
 Other Stockholders Equity 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454 4,857,454
80
Total shareholders equity 30,261,139 32,234,347 30,200,262 33,281,636 36,522,763 39,088,903 36,917,563 36,542,639 37,533,418 38,089,512 36,485,541 39,219,915
81
Minority Interest 1,608,211 1,691,111 1,746,342 1,817,384 876,020 908,648 936,297 955,492 961,252 960,217 965,023 985,035
82
Total Equity 31,869,350 33,925,458 31,946,604 35,099,020 37,398,783 39,997,551 37,853,860 37,498,131 38,494,670 39,049,729 37,450,564 40,204,950
83
Total debt 29,834,859 31,464,499 32,159,084 35,032,478 38,804,969 41,168,894 39,843,628 36,831,537 33,711,107 33,746,432 32,462,472 32,525,308
84
Total Investments 29,497,900 32,860,548 29,998,739 30,292,077 31,423,264 30,855,773 33,961,563 29,056,174 30,212,554 9,249,873 7,465,965 6,294,550
85
Net Debt 12,418,456 8,316,823 10,083,658 13,623,949 17,188,530 16,447,726 16,043,556 13,088,398 12,792,182 1,787,749 13,180,173 53,900,008
1
2
Weighted Average Cost Of Capital (WACC)
3
4
Share price, USD31.57
5
Beta1.14
6
Diluted Shares Outstanding, MM962
7
 Cost of Debt, %26.2%
8
 Tax Rate, %28.2%
9
After-tax Cost of Debt, %18.8%
10
* Risk-Free Rate, %3.9%
11
** Market Risk Premium, %5.0%
12
Cost of Equity, %9.7%
13
 Total Debt - (USD 'MM)33,746,432Debt
14
 Total Equity - (USD 'MM)30,365Equity
15
Total Capital - (USD 'MM)33,776,797
16
Debt Weighting, %99.9%
17
Equity Weighting, %0.1%
18
WACC, %18.8%
19
20
21
Tax Rate
22
20192020202120222023
23
Historical tax rate, %28.2%-2.1%29.7%28.2%24.1%
24
Selected tax rate, %28.2%
25
26
27
Cost Of Debt (Effective interest rate method)
28
29
20192020202120222023
30
Interest expense - (USD 'MM)6,179,7945,863,0084,351,5568,442,47016,668,295
31
Total debt - (USD 'MM)33,746,43233,746,43233,746,43233,746,43233,746,432
32
Effective interest rate, %17.4%12.9%25.0%49.4%
33
34
Average effective interest rate, %26.2%
1
2
Operating Data - (USD 'MM)
3
4
Year2019202020212022202320242025202620272028
5
A/FActualActualActualActualActualForecastForecastForecastForecastForecast
6
7
Revenue 15,822,030 15,721,566 17,360,890 24,205,693 47,076,707 63,989,594 86,978,645 118,226,795 160,701,228 218,435,125
8
Revenue Growth, %-0.6%10.4%39.4%94.5%35.9%35.9%35.9%35.9%35.9%
9
EBITDA 5,204,905 1,005,775 6,718,187 17,974,381 1,139,939 19,480,505 26,479,117 35,992,066 48,922,659 66,498,727
10
EBITDA, %32.9%6.4%38.7%74.3%2.4%30.4%30.4%30.4%30.4%30.4%
11
Depreciation 824,590 736,367 855,167 949,448 1,078,358 2,531,218 3,440,589 4,676,663 6,356,811 8,640,574
12
Depreciation, %5.2%4.7%4.9%3.9%2.3%4.0%4.0%4.0%4.0%4.0%
13
EBIT 4,380,315 269,408 5,863,020 17,024,933 61,581 16,949,287 23,038,528 31,315,403 42,565,847 57,858,153
14
EBIT, %27.7%1.7%33.8%70.3%0.1%26.5%26.5%26.5%26.5%26.5%
15
16
Balance Sheet Data - (USD 'MM)
17
18
Year2019202020212022202320242025202620272028
19
A/FActualActualActualActualActualForecastForecastForecastForecastForecast
20
21
Total Cash 18,256,065 20,185,074 23,147,676 24,721,168 (27,974,984) 48,700,657 66,196,968 89,979,045 122,305,126 166,244,750
22
Total Cash, %115.4%128.4%133.3%102.1%-59.4%76.1%76.1%76.1%76.1%76.1%
23
Account Receivables 802,074 1,204,529 1,642,933 1,066,031 28,449,029 13,111,519 17,821,994 24,224,765 32,927,811 44,757,533
24
Account Receivables, %5.1%7.7%9.5%4.4%60.4%20.5%20.5%20.5%20.5%20.5%
25
Inventories (26,902,022) (25,825,437) (29,459,415) 608,449 (474,045) (53,183,236) (72,289,970) (98,261,032) (133,562,519) (181,546,500)
26
Inventories, %-170.0%-164.3%-169.7%2.5%-1.0%-83.1%-83.1%-83.1%-83.1%-83.1%
27
Accounts Payable 3,484,151 3,151,297 3,981,649 6,019,578 6,459,875 13,048,993 17,737,005 24,109,243 32,770,785 44,544,094
28
Accounts Payable, %22.0%20.0%22.9%24.9%13.7%20.4%20.4%20.4%20.4%20.4%
29
Capital Expenditure (1,555,453) (1,530,153) (2,185,800) (3,538,855) (2,412,123) (6,729,616) (9,147,313) (12,433,598) (16,900,522) (22,972,243)
30
Capital Expenditure, %9.8%9.7%12.6%14.6%5.1%10.5%10.5%10.5%10.5%10.5%
31
32
Build Up Free Cash Flow - (USD 'MM)
33
34
Year2019202020212022202320242025202620272028
35
A/FActualActualActualActualActualForecastForecastForecastForecastForecast
36
37
Revenue 15,822,030 15,721,566 17,360,890 24,205,693 47,076,707 63,989,594 86,978,645 118,226,795 160,701,228 218,435,125
38
EBITDA 5,204,905 1,005,775 6,718,187 17,974,381 1,139,939 19,480,505 26,479,117 35,992,066 48,922,659 66,498,727
39
EBIT 4,380,315 269,408 5,863,020 17,024,933 61,581 16,949,287 23,038,528 31,315,403 42,565,847 57,858,153
40
Tax Rate, %28.2%-2.1%29.7%28.2%24.1%20.0%20.0%20.0%20.0%20.0%
41
EBIAT 3,144,772 275,154 4,122,709 12,223,218 46,769 13,567,592 18,441,917 25,067,402 34,073,176 46,314,384
42
Depreciation 824,590 736,367 855,167 949,448 1,078,358 2,531,218 3,440,589 4,676,663 6,356,811 8,640,574
43
Accounts Receivable (167,219) (402,455) (438,404) 576,902 (27,382,998) 15,337,510 (4,710,475) (6,402,771) (8,703,046) (11,829,722)
44
Inventories 28,915,444 (1,076,585) 3,633,978 (30,067,864) 1,082,494 52,709,191 19,106,733 25,971,063 35,301,487 47,983,981
45
Accounts Payable 383,487 (332,854) 830,352 2,037,929 440,297 6,589,118 4,688,012 6,372,238 8,661,543 11,773,309
46
Capital Expenditure (1,555,453) (1,530,153) (2,185,800) (3,538,855) (2,412,123) (6,729,616) (9,147,313) (12,433,598) (16,900,522) (22,972,243)
47
UFCF 31,545,621 (2,330,526) 6,818,002 (17,819,222) (27,147,203) 84,005,013 31,819,462 43,250,996 58,789,449 79,910,284
48
WACC, %18.8%18.8%18.8%18.8%18.8%
49
PV UFCF 70,722,862 22,552,884 25,808,335 29,533,703 33,796,817
50
SUM PV UFCF 182,414,601
51
52
Valuation - (USD 'MM)
53
Terminal Value (Perpetuity Growth method) - (USD 'MM)
Intrinsic Value
54
Long-term growth rate, %4.0%
Enterprise Value - (USD 'MM)
420,218,083
55
WACC, %18.8%
Net Debt - (USD 'MM)
1,787,749
56
Free cash flow (t + 1)83,106,695
Equity Value - (USD 'MM)
418,430,334
57
Terminal Value562,270,215
Shares Outstanding, MM
962
58
Present Value of Terminal Value237,803,482
Equity Value Per Share, USD
435,037.00
1
2
Free Cash Flow - (USD 'MM)
3
4
Year2019202020212022202320242025202620272028
5
A/FActualActualActualActualActualForecastForecastForecastForecastForecast
6
7
Revenue 15,822,030 15,721,566 17,360,890 24,205,693 47,076,707 63,989,594 86,978,645 118,226,795 160,701,228 218,435,125
8
Revenue Growth, %-0.6%10.4%39.4%94.5%35.9%35.9%35.9%35.9%35.9%
9
Operating Cash Flow 12,315,612 11,230,345 6,095,305 6,564,226 19,153,084 27,890,745 37,910,839 51,530,776 70,043,842 95,207,956
10
Operating Cash Flow, %77.8%71.4%35.1%27.1%40.7%43.6%43.6%43.6%43.6%43.6%
11
Capital Expenditure (1,555,453) (1,530,153) (2,185,800) (3,538,855) (2,412,123) (6,729,616) (9,147,313) (12,433,598) (16,900,522) (22,972,243)
12
Capital Expenditure, %9.8%9.7%12.6%14.6%5.1%10.5%10.5%10.5%10.5%10.5%
13
Free Cash Flow 10,760,159 9,700,192 3,909,505 3,025,371 16,740,961 21,161,129 28,763,526 39,097,177 53,143,320 72,235,713
14
Free Cash Flow, %68.0%61.7%22.5%12.5%35.6%33.1%33.1%33.1%33.1%33.1%
15
16
Build Up Free Cash Flow - (USD 'MM)
17
18
Year2019202020212022202320242025202620272028
19
A/FActualActualActualActualActualForecastForecastForecastForecastForecast
20
21
Free Cash Flow 10,760,159 9,700,192 3,909,505 3,025,371 16,740,961 21,161,129 28,763,526 39,097,177 53,143,320 72,235,713
22
WACC, %18.8%18.8%18.8%18.8%18.8%
23
PV UFCF 17,815,314 20,386,909 23,329,707 26,697,291 30,550,976
24
SUM PV UFCF 118,780,196
25
26
Valuation - (USD 'MM)
27
Terminal Value (Perpetuity Growth method) - (USD 'MM)
Intrinsic Value
28
29
Long-term growth rate, %4.0%
Enterprise Value - (USD 'MM)
333,745,070
30
WACC, %18.8%
Net Debt - (USD 'MM)
1,787,749
31
Free cash flow (t + 1)75,125,141
Equity Value - (USD 'MM)
331,957,321
32
Terminal Value508,269,875
Shares Outstanding, MM
962
33
Present Value of Terminal Value214,964,874
Equity Value Per Share, USD
345,132.05
1
2
Liquidity Measurement RatiosRatio Description
3
4
Year20192020202120222023Sparkline
5
6
Current Ratio5.476.796.234.2867.45A current ratio of 1.0 or greater is an indication that the company is well-positioned to cover its current or short-term liabilities.
7
Current Assets / Current Liabilities
8
9
Quick Ratio13.1914.9813.634.1868.20The quick ratio is more conservative than the current ratio because it excludes inventory and other current assets, which generally are more difficult to turn into cash. A higher quick ratio means a more liquid current position.
10
(Cash and Cash Equivalents+Short Term Investments+Account Receivables) / Current Liabilities
11
12
Cash Ratio5.246.415.814.1150.36The cash ratio is almost like an indicator of a firm’s value under the worst-case scenario where the company is about to go out of business.
13
Cash and Cash Equivalents / Current Liabilities
14
15
Days of Sales Outstanding18.5027.9634.5416.07220.57DSO tells you how many days after the sale it takes people to pay you on average.
16
((Account Receivables (start)+Account Receivables (end)) / 2) / (Revenue / 365)
17
18
Days of Inventory Outstanding0.000.000.0045.360.00DIO tells you how many days inventory sits on the shelf on average.
19
((Inventory (start)+Inventory (end)) / 2) / (COGS / 365)
20
21
Operating Cycle61.4361.4361.4361.430.00(DSO + DIO) Basically the Operating Cycle tells you how many days it takes for something to go from first being in inventory to receiving the cash after the sale.
22
DSO + DIO
23
24
Days of Payables Outstanding0.000.000.00448.760.00DPO tells you how many days the company takes to pay its suppliers.
25
((Account Payables (start)+Account Payables (end)) / 2) / (COGS / 365)
26
27
Cash Conversion Cycle-387.32-387.32-387.32-387.320.00The cash conversion cycle (CCC = DSO + DIO – DPO) measures the number of days a company's cash is tied up in the production and sales process of its operations and the benefit it derives from payment terms from its creditors. The shorter this cycle, the more liquid the company's working capital position is. The CCC is also known as the "cash" or "operating" cycle.
28
DSO + DIO − DPO
29
30
31
32
Profitability Indicator RatiosRatio Description
33
34
Year20192020202120222023Sparkline
35
36
Gross Profit Margin100.0%100.0%100.0%79.8%100.0%You can think of it as the amount of money from product sales left over after all of the direct costs associated with manufacturing the product have been paid.
37
Gross Profit / Revenue
38
39
Operating Profit Margin27.7%1.7%33.8%70.3%0.0%If companies can make enough money from their operations to support the business, the company is usually considered more stable.
40
Operating Income / Revenue
41
42
Pretax Profit Margin28.3%2.0%34.5%40.3%17.1%Profit is the main goal of for-profit organizations. The goal is to make a profit through growth and to grow every year. As a result, one of the most important roles of the financial and investment analyst is to track and forecast profitability.
43
Income Before Tax / Revenue
44
45
Net Profit Margin19.7%1.8%23.5%28.0%13.0%Generally, a net profit margin in excess of 10% is considered excellent, though it depends on the industry and the structure of the business.
46
Net Income / Revenue
47
48
Effective Tax Rate28.2%-2.1%29.7%28.2%24.1%If there’s one takeaway, it should be that a company’s tax situation is all but a living, breathing organism in its own right.
49
Provision For Income Taxes / Income Before Tax
50
51
Return On Assets0.010.000.010.020.02ROA Return on assets gives an indication of the capital intensity of the company, which will depend on the industry; companies that require large initial investments will generally have lower return on assets. ROAs over 5% are generally considered good.
52
Net Income / Avg Total Assets
53
54
Return On Equity0.120.010.130.170.16ROE this ratio calculates how much money is made based on the investors' investment in the company.investors want to see a high return on equity ratio because this indicates that the company is using its investors' funds effectively.
55
Net Income / Avg Total Equity
56
57
Return On Capital Employed0.020.000.020.050.00ROCE shows investors how many dollars in profits each dollar of capital employed generates.
58
Net Income / (Avg Total Assets - Avg Current Liabilities)
59
60
61
Debt RatiosRatio Description
62
63
Year20192020202120222023Sparkline
64
65
Debt Ratio0.160.140.140.120.09The debt ratio tells us the degree of leverage used by the company.
66
Total Liabilities / Total Assets
67
68
Debt Equity Ratio1.391.301.241.100.84This is a measurement of the percentage of the company’s balance sheet that is financed by suppliers, lenders, creditors and obligors versus what the shareholders have committed.
69
Total Debt / Total Equity
70
71
Long-term Debt to Capitalization
0.570.550.490.510.45While a high capitalization ratio can increase the return on equity because of the tax shield of debt, a higher proportion of debt increases the risk of bankruptcy for a company.
72
Long−Term Debt / (Long−Term Debt + Shareholders Equity)
73
74
Total Debt to Capitalization0.580.570.550.520.46Capitalization ratio describes to investors the extent to which a company is using debt to fund its business and expansion plans.
75
Total Debt / (Total Debt + Shareholders Equity)
76
77
Interest Coverage Ratio0.710.051.352.020.00The lower a company’s interest coverage ratio is, the more its debt expenses burden the company.
78
EBIT / Interest Expenses
79
80
Cash Flow to Debt Ratio0.330.330.150.150.60The cash flow to debt ratio reveals the ability of a business to support its debt obligations from its operating cash flows
81
Operating Cash Flows / Total Debt
82
83
Company Equity Multiplier8.789.638.999.039.00This is a measure of financial leverage.
84
Total Assets / Total Equity
85
86
87
Operating Performance RatiosRatio Description
88
89
Year20192020202120222023Sparkline
90
91
Fixed Asset Turnover2.872.642.552.835.77Calculates how efficiently a company is a producing sales with its machines and equipment.
92
Revenue / Avg Fixed Assets
93
94
Asset Turnover0.070.060.060.070.14The Asset Turnover ratio can often be used as an indicator of the efficiency with which a company is deploying its assets in generating revenue.
95
Revenue / Avg Total Assets
96
97
98
99
Cash Flow Indicator RatiosRatio Description
100
101
Year20192020202120222023Sparkline
102
103
Operating Cash Flow Sales Ratio0.780.710.350.270.41Gives investors an idea of the company's ability to turn sales into cash.
104
Operating Cash Flow / Revenue
105
106
Free Cash Flow Operating Cash Flow Ratio
0.870.860.640.460.87The higher the percentage of free cash flow embedded in a company's operating cash flow, the greater the financial strength of the company.
107
Free Cash Flow / Operating Cash Flow
108
109
Cash Flow Coverage Ratios0.330.330.150.150.60The operating cash flow is simply the amount of cash generated by the company from its main operations, which are used to keep the business funded.
110
Operating Cash Flow / Total Debt
111
112
Short-Term Coverage Ratios7.774.730.713.4540.73The short-term debt coverage ratio compares the sum of a company's short-term borrowings and the current portion of its long-term debt to operating cash flow.
113
Operating Cash Flow / Short-Term Debt
114
115
Capital Expenditure Coverage Ratios7.927.342.791.857.94The larger the operating cash flow coverage for these items, the greater the company's ability to meet its obligations, along with giving the company more cash flow to expand its business, withstand hard times, and not be burdened by debt servicing and the restrictions typically included in credit agreements.
116
Operating Cash Flow / Capital Expenditure
117
118
Dividend Paid and Capex Coverage Ratios-23.55437.52-3.55-5.3421.62For conservative investors focused on cash flow coverage, comparing the sum of a company's capital expenditures and cash dividends to its operating cash flow is a stringent measurement that puts cash flow to the ultimate test. If a company is able to cover both of these outlays of funds from internal sources and still have cash left over, it is producing what might be called "free cash flow on steroids". This circumstance is a highly favorable investment quality.
119
Operating Cash Flow / (Dividends Paid + Capital Expenditure)
120
121
Dividend Payout Ratio0.335.640.110.340.54The dividend payout ratio is an indicator of how well earnings support the dividend payment.
122
DPS (Dividends per Share) / EPS (Net Income per Share)
123
124
125
126
Investment Valuation RatiosRatio Description
127
128
Year20192020202120222023Sparkline
129
130
Price Book Value Ratio6.444.973.833.413.01The price-to-book value ratio, expressed as a multiple (i.e. how many times a company's stock is trading per share compared to the company's book value per share), is an indication of how much shareholders are paying for the net assets of a company.
131
Stock Price per Share / Equity per Share
132
133
Price Cash Flow Ratio14.0511.7520.2720.285.98The price/cash flow ratio is used by investors to evaluate the investment attractiveness, from a value standpoint, of a company's stock.
134
Stock Price per Share / Operating Cash Flow per Share
135
136
Price Earnings Ratio55.52478.1230.2319.6218.74The financial reporting of both companies and investment research services use a basic earnings per share (EPS) figure divided into the current stock price to calculate the P/E multiple (i.e. how many times a stock is trading (its price) per each dollar of EPS).
137
Stock Price per Share / EPS
138
139
Price Earnings to Growth Ratio-0.66-5.340.030.300.27
140
Price Earnings Ratio / Expected Revenue GrowthThe PEG ratio is a refinement of the P/E ratio and factors in a stock's estimated earnings growth into its current valuation.The general consensus is that if the PEG ratio indicates a value of 1, this means that the market is correctly valuing (the current P/E ratio) a stock in accordance with the stock's current estimated earnings per share growth. If the PEG ratio is less than 1, this means that EPS growth is potentially able to surpass the market's current valuation.
141
142
Price Sales Ratio10.948.397.125.502.43The P/E ratio and P/S reflects how many times investors are paying for every dollar of a company's sales. Since earnings are subject, to one degree or another, to accounting estimates and management manipulation, many investors consider a company's sales (revenue) figure a more reliable ratio component in calculating a stock's price multiple than the earnings figure.
143
Stock Price per Share / Revenue per Share
144
145
Dividend Yield0.0060.0120.0040.0170.029Income investors value a dividend-paying stock, while growth investors have little interest in dividends, preferring to capture large capital gains. Whatever your investing style, it is a matter of historical record that dividend-paying stocks have performed better than non-paying-dividend stocks over the long term.
146
Dividend per Share / Stock Price per Share
147
148
Enterprise Value Multiplier36.60143.0919.628.32102.11Overall, this measurement allows investors to assess a company on the same basis as that of an acquirer. As a rough calculation, enterprise value multiple serves as a proxy for how long it would take for an acquisition to earn enough to pay off its costs in years(assuming no change in EBITDA).
149
Enterprise Value / EBITDA
150
151
Price Fair Value6.444.973.833.413.01Helps investors determine whether a stock is trading at, below, or above its fair value estimate,A price/fair value ratio below 1 suggests the stock is trading at a discount to its fair value, while a ratio above 1 suggests it is trading at a premium to its fair value.
152
Stock Price per Share / Intrinsic Value
153
1
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
1
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74