Spreadsheet: 866141d1713093323-vlookup-and-indirect-and-match-formula-animal-sample
Sheet: DONKEY

 |  | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00
In Millions of USD except Per Share |  | FY 2020 | FY 2021 | FY 2022 | FY 2023 | Last 12M | FY 2024 Est | FY 2025 Est
12 Months Ending |  | 06/30/2020 | 06/30/2021 | 06/30/2022 | 06/30/2023 | 12/31/2023 | 06/30/2024 | 06/30/2025
Revenue | SALES_REV_TURN | 327.909 | 352.777 | 429.387 | 5 | 604.654 | 653.882 | 758.167
+ Sales & Services Revenue | IS_SALES_AND_SERVICES_REVENUES | 0.0313776078119234 | 0.00516190114434898 | 0.00548456287684536 | 0.0611877863258379 | 0.0744078431631975
+ Other Revenue | IS_OTHER_REVENUE | 0.968622392188077 | 0.994838098855651 | 0.994515437123155 | 0.938812213674162 | 0.925592156836803
- Cost of Revenue | IS_COGS_TO_FE_AND_PP_AND_G | 0.425980988627942 | 0.437916870997826 | 0.391693274365549 | 0.338597265746564 | 0.337836183999444
+ Cost of Goods & Services | IS_COG_AND_SERVICES_SOLD | 0.425980988627942 | 0.437916870997826 | 0.391693274365549 | 0.338597265746564 | 0.337836183999444
Gross Profit | GROSS_PROFIT | 0.574019011372057 | 0.562083129002174 | 0.608306725634451 | 0.661402734253436 | 0.662163810852499 | 0.68529 | 0.68908
+ Other Operating Income | IS_OTHER_OPER_INC | 0 | 0 | 0 | 0 | 0
- Operating Expenses | IS_OPERATING_EXPN | 0.862846094495729 | 0.787128979496963 | 0.904466134279799 | 0.842997546553958 | 0.790238715033722
+ Selling, General & Admin | IS_SGA_EXPENSE | 0.72297192208814 | 0.713206926755429 | 0.822260571465834 | 0.752578289535582 | 0.711519315178598
+ Selling & Marketing | IS_SELLING_EXPENSES | 0.304956558069464 | 0.300821765591294 | 0.39737812276571 | 0.383747186498086 | 0.368007157812567
+ General & Administrative | IS_GENERAL_AND_ADMINISTRATIVE | 0.418015364018676 | 0.412385161164135 | 0.424882448700124 | 0.368831103037496 | 0.343512157366031
+ Research & Development | IS_OPERATING_EXPENSES_RD | 0.139874172407589 | 0.102104162119413 | 0.100468807858645 | 0.0981794561889805 | 0.0970902367304277
+ Other Operating Expense | IS_OTHER_OPERATING_EXPENSES | 0 | -0.0281821093778789 | -0.01826324504468 | -0.00776019917060497 | -0.0183708368753039
Operating Income (Loss) | IS_OPER_INC | -0.288827083123672 | -0.225045850494789 | -0.296159408645348 | -0.181594812300522 | -0.128074899033166 | 0.162959066008852 | 0.165751081226168
- Non-Operating (Income) Loss | IS_NONOP_INCOME_LOSS | -0.0220305023649854 | 0.0112280562508327 | -0.0024732933228067 | -0.00037814913188539 | 0.00310921617983177
+ Interest Expense, Net | IS_NET_INTEREST_EXPENSE | -0.025949272511581 | 0.00204094938162068 | -0.00422462720110297 | -0.052796132384764 | -0.0652389631094808
+ Interest Expense | IS_INT_EXPENSE | 0.00542833530034247 | 0.00720285052596966 | 0.0012599356757424 | 0.00839165394107387 | 0.00916888005371667
- Interest Income | IS_INT_INC | 0.0313776078119234 | 0.00516190114434898 | 0.00548456287684536 | 0.0611877863258379 | 0.0744078431631975
+ Foreign Exch (Gain) Loss | IS_FOREIGN_EXCH_LOSS | 0 | 0 | 0 | 0
+ Other Non-Op (Income) Loss | IS_OTHER_NON_OPERATING_INC_LOSS | 0.00391877014659555 | 0.009187106869212 | 0.00175133387829627 | 0.0524179832528786 | 0.0683481792893126
Pretax Income (Loss), Adjusted | PRETAX_INC | -0.266796580758686 | -0.236273906745621 | -0.293686115322541 | -0.181216663168636 | -0.131184117395875 | 0.165386109420354 | 0.166283945357685
- Abnormal Losses (Gains) | IS_ABNORMAL_ITEM | 0 | 0.0281821093778789 | 0.029078663303733 | 0.00815282291040942 | 0.0201123284584302
+ Merger/Acquisition Expense | IS_MERGER_ACQUISITION_EXPENSE | — | — | 0.000465780286780923 | — | 0.00829565338193413
+ Early Extinguishment of Debt | IS_G_L_ON_EXT_DBT_OR_SETTLE_DBT | — | 0.00622206096202417 | 8.15115501866614e-05 | —
+ Restructuring | IS_RESTRUCTURING_EXPENSES | — | — | 0.000931560573561845 | 0.00323688419589934 | 0.00264448759125053
+ Sale of Investments | IS_GAIN_LOSS_ON_INVESTMENTS | — | — | -4.65780286780923e-06 | 0.000392623739804448 | 0.000593727983276386
+ Other Abnormal Items | IS_OTHER_ONE_TIME_ITEMS | — | 0.0219600484158548 | 0.0276044686960714 | 0.00452331497470562 | 0.00857845974722734
Pretax Income (Loss), GAAP | PRETAX_INC | -0.266796580758686 | -0.2644560161235 | -0.322764778626274 | -0.189369486079046 | -0.151296442995588 | 0.165386109420354 | 0.166283945357685
- Income Tax Expense (Benefit) | IS_INC_TAX_EXP | -0.0615475635008493 | -0.0589947757365134 | -0.0712038324401996 | -0.020713163932172 | -0.0131265153294281
Income (Loss) from Cont Ops | IS_INC_BEF_XO_ITEM | -0.205249017257837 | -0.205461240386987 | -0.251560946186075 | -0.168656322146874 | -0.138169928587258 | -0.101958763201923 | -0.0694161048950957
- Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 0
+ Discontinued Operations | IS_DISCONTINUED_OPERATIONS | 0 | 0 | 0 | 0 | 0
+ XO & Accounting Changes | EXTRAORD_ITEMS_ACCOUNTING_CHANGS | 0 | 0 | 0 | 0 | 0
Income (Loss) Incl. MI | NI_INCLUDING_MINORITY_INT_RATIO | -0.205249017257837 | -0.205461240386987 | -0.251560946186075 | -0.168656322146874 | -0.138169928587258
- Minority Interest | MIN_NONCONTROL_INTEREST_CREDITS | 0.0698059522611456 | 0.0692732235945087 | 0.0270641635634055 | 0 | 0
Net Income, GAAP | NET_INCOME | -0.275054969518982 | -0.274734463981495 | -0.27862510974948 | -0.168656322146874 | -0.138169928587258 | -0.101958763201923 | -0.0694161048950957
- Preferred Dividends | IS_TOT_CASH_PFD_DVD | 0 | 0 | 0 | 0 | 0
- Other Adjustments | OTHER_ADJUSTMENTS | 0 | 0 | 0 | 0 | 0
Net Income Avail to Common, GAAP | EARN_FOR_COMMON | -0.275054969518982 | -0.274734463981495 | -0.27862510974948 | -0.168656322146874 | -0.138169930959402 | -0.101958763201923 | -0.0694161048950957
Net Abnormal Losses (Gains) | IS_NET_ABNORMAL_ITEMS | 0 | 0.0215319592830598 | 0.0261972206890288 | 0.00631646559023832 | 0.0170684462721871
Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 0
Basic Weighted Avg Shares | IS_AVG_NUM_SH_FOR_EPS | 701.973764794501 | 629.465285112125 | 0.402053445959007 | 0.318513115804101 | 0.293667778597347
Basic EPS, GAAP | IS_EPS | -1.18630473698496e-06 | -1.23307358472916e-06 | -0.00160694198939418 | -0.000958942774637592 | -0.000793842428893218 | -0.000582673938111158 | -0.000342932361867504
Basic EPS from Cont Ops, GAAP | IS_EARN_BEF_XO_ITEMS_PER_SH | -1.18630473698496e-06 | -1.23307358472916e-06 | -0.00160694198939418 | -0.000958942774637592 | -0.000793842428893218 | -0.000582673938111158 | -0.000342932361867504
Basic EPS from Cont Ops, Adjusted | IS_BASIC_EPS_CONT_OPS | -1.18630473698496e-06 | -1.13953007140488e-06 | -0.00146219377857271 | -0.000922177270523185 | -0.000684409596231895 | 0.000717254795207698 | 0.000724114871789461
Diluted Weighted Avg Shares | IS_SH_FOR_DILUTED_EPS | 701.973764794501 | 629.465285112125 | 0.402053445959007 | 0.318513115804101 | 0.293667778597347
Diluted EPS, GAAP | IS_DILUTED_EPS | -1.18630473698496e-06 | -1.23307358472916e-06 | -0.00160694198939418 | -0.000958942774637592 | -0.000793842428893218 | -0.000582673938111158 | -0.000342932361867504
Diluted EPS from Cont Ops, GAAP | IS_DIL_EPS_BEF_XO | -1.18630473698496e-06 | -1.23307358472916e-06 | -0.00160694198939418 | -0.000958942774637592 | -0.000793842428893218 | -0.000582673938111158 | -0.000342932361867504
Diluted EPS from Cont Ops, Adjusted | IS_DIL_EPS_CONT_OPS | -1.18630473698496e-06 | -1.13953007140488e-06 | -0.00146219377857271 | -0.000923062030932237 | -0.000700049945919484 | 0.000717254795207698 | 0.000724114871789461
Reference Items
Accounting Standard | ACCOUNTING_STANDARD | US GAAP | US GAAP | US GAAP | US GAAP
EBITDA | EBITDA | 0.117435020081791 | 0.189666559894778 | 0.00769934814048865 | 0.0556928632945655 | 0.101752407161782 | 0.314218773417834 | 0.312799159024331
EBITDA Margin (T12M) | EBITDA_MARGIN | 0.0358132957619339 | 0.0537638678258503 | 0.00179310272551335 | 0.0100766539048873 | 0.0168282037598001 | 0.0480543543663587 | 0.0412572901516857
EBITA | EBITA | 0.10077795973883 | 0.169974233014057 | -0.00733836841823343 | 0.0470261918030295 | 0.0928365643822748
EBIT | EBIT | -0.288827083123672 | -0.225045850494789 | -0.296159408645348 | -0.181594812300522 | -0.128074899033166 | 0.162959066008852 | 0.165751081226168
Gross Margin | [NAME] | 0.175054362643294 | 0.159331002304572 | 0.141668641575083 | 0.119669314916807 | 0.109511194170642 | 0.104803313136009 | 0.0908876276598691
Operating Margin | OPER_MARGIN | -0.0880814738235303 | -0.0637926650546946 | -0.0689726074613344 | -0.0328564209360729 | -0.0211815185268213 | 0.0249217849717306 | 0.0218620806796086
Profit Margin | PROF_MARGIN | -0.083881494560991 | -0.0717740980846257 | -0.0587879674978516 | -0.0293725727891846 | -0.0200282280965758 | 0.0195567109687038 | 0.0171586723603688
Dividends per Share | EQY_DPS | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Common Dividends | IS_TOT_CASH_COM_DVD | — | 0 | 0 | 0 | 0
Capitalized Interest Expense | IS_CAP_INT_EXP | — | — | 0 | —
Depreciation Expense | IS_DEPR_EXP | 0.016657060342961 | 0.0196923268807207 | 0.0150377165587221 | 0.00866667149153597 | 0.00891584277950696