Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me in filling out the Ratios sheet in yellow Income - Adjusted TJX cos InclThe (TJX US) In Millions 01 uSD oxcept SnM
Please help me in filling out the Ratios sheet in yellow
Income - Adjusted TJX cos InclThe (TJX US) In Millions 01 uSD oxcept SnM 12 Months Ending Rev.m. Servcas Cost 01 Cast ot Service Prom Exnu Lou Nel + (treorne) Loss Pretax (Lou), Losu* (Gains) ot Assets Euty E.xtm.ntvnent ot Debt Asset Resnxnrnq Abumai Items Pretax GAAP Tax Expenso (BoneM) Tax Deferred Income Tax Inconv (Lo) trom Cont Opt N.t Avan to Common. GAAP Net Avail to Common. Aq Net Abwrnal (Gains Bal Sheet - Standardized CF - Standardized Growth Ratios Income - Adjusted TJX cos InclThc (TJX US) of USD pef Stun 12 Mont" Cash S Cnh A h Tet Noncwrm Accru&' Cwvatp.s Total Lease Bal Sheet - Standardized Standardizod CF - Standardized Growth Adjusted Burlington Stores lnc (BURL US) - BBG Adjuste In Million. of usD except Share 2021 FY ZOu Ratios Standardized FY zon ornraozz Income - Adjusted TJX cos lnc/The (TJX US) Bal Sheet - Standardized CF - Standardized Growth iou Should be able to cop. 'he TJX rormula. oscr column. ror Burlington's Ratios Example ROIC: D Tax rate FY 2022 dftiW2022 5214 09 493 FY 2022 01,2Y2022 FRIT is operating income 9B 2058643 FY2021 cap,tal EBITDA from lnc Stmt Refererxc Items NOPAT by Sales sheet. the batancc sheet for the 5,101.83 FY2021 carnal ROIC Net EBITDA Losses (Gains) D".nds per Share Expense Rental Expense Source aou Olmrzou 48.5500 32.137_0 34.71308 24.533.0 34.7138 24.5338 13.'".2 7,003.1 on 00 9.0726 6.937,' 9.0812 7208 0.0 00 -838 115.1 1801 1807 1'9.5 193.7 00 4.ua.s 485.3 2508 396.0 0.6 242.2 3122 83.8 4.397 .c 89.3 1,114.8 -12 1.1590 23M -44.2 .23 3.282-0 00.5 00.5 3.481 .o 403.3 1982 312.9 0.0 7.5379 3.3572 4,763.5 666.0 1.04 026 858 0 8580 3292u 2.983.4 Rig"' chck to data tra FY aou Est 40.772-1 1"73S 3.sou 3, sou 5837.9 4,904.8 1,17 (not 12 Months Ending Rvenw Sales & Services Revenue - Cost of Rove-nuo Cost 01 & Services Grou Prom Other Incoma - OperatjrO Expenses + Gemral & Adman Research & Devebpnwnt Other Operating Expense Loss Net Expense Interest income + Non-op (Income) Loss (Lon), Adjusted - Losses (Gains) Expense Erty ot Debt Asset Write-Down Legal Setternent Restructufi" Other Items Pretax (Lou), GAAP _ - incmw Tax Expense (Benefit) Current Tax Delerred Incorno Tax (Los) trom Cont Opt Net Avll to Common, GAAP lncn Avail to Common. Net Abna-mal Losses (Gains) Net Losses (Gams) Reference hms EBITDA EBIT Dividend' per Share DeprociatM Expense Rental Expense an Bkxynberg 0-03012021 5,764.0 5,764.0 3.555 0 2.soos 25234 oo -23.0 -283.1 97.8 96.6 97.8 1.3 1.3 -380' 56.7 60 228 27.7 -437 s -221.1 -1962 -25.0 .21'.s .2f6.s -184.1 0.0 3733 -283.1 0.00 2062 616.3 Roht click ,3Z2.3 9,322.3 5.4362 3,886.1 11.6 3,073.9 3.0958 -21.9 823.8 67.5 67.3 67.5 02 02 211.0 21.9 159.4 7.7 21.9 136.5 84 s 520 408.8 408.8 189.3 0.0 1,53S6 8238 0.00 2492 6S06 show dat FY zon Est 8542.4 3,458.5 4001 341.8 341.8 228.2 228.2 260.7 667.9 400.8 0.00 transparency ( 2020 omrzozo 462 2 99 0 IS,2S4 1 s.074_2 24,''5.0 3.4193 315 e s.tS27 s. ssxt 5176 13.2".' 1 saoz 4.465 4 10.4u 040 22.4".' sscs o Burlington Stores lnc (BURL US) - o' OSO p.' Shan ST Eqt.Sp Tow Noncurrent Asset' ODW Tow 759 '91,0 s.'93. 00 9 4270.5 8626 512 g 1 su.o ' 884 0 41 IMO 4 In Millions of USD except per Share 12 Months Endiig NOPAT (uto row 22 for tax rate) Total capital Return on Invested Capital (use average capitan MACC EVA spread Rotums Return on Equ.tv (oamn use averaqes here) Return on Assots (agan use averages hero' Return on Invested Capital (from above) Margins Gross Margin E Bj TDA Net Operating Margin (use tax rate below' No' Pro"! Margin E "ectrve Tax Rale Turnovers Capital Turnover Working Capital NOWC Balance N OWC Turnover Days Sales Outstand.ng O By' Inventory payaYO Days COGS) Cash CycJo (AR INV AP) days to Cash Days (AR INV) Cash percentage (Cash&STI-to-Assets) PP&E Turnover Liquidity Current Rabo Ratn EBITDA Next Year Total Debt.EB'TDA (both ST and Dobt) EBIT to Interest (use tata'. not net) (both ST and LT Tow Oebtcamai s T use Net 254% Avail to Common, Adj. wherever net income caned for 25.0% Income - Adjusted Bal Sheet - Standardized CF - Standardized Growth Ratios TJX cos InclThe (TJX US) - Standardized Burlington Stores lnc (BURL US) - Standardized In USO pet Sha Keep using average for balance saics and balance she m same rano (e.g an turnosers) 1 807 4."7 This is assets minus liabilities plus this excludes shon.term debt from operating CL 3 679 Ilere i' an example of using the balance sheet average 'n co -"th income statement. by averaging the balance number. Average Accb Payable (COGSJ6S) Days cash Oed up in mvcntory and receivables. anet yahlc-. ve Cash Shon.tcrm investments. divided by total assets Note his trects Capital turnover and Total Capital turnover quite a bit for TJ Shaw Enen. NonCuh NorCash ACQ C' Acq Cash F Cub cash ST Repayr:nts L T COO Capu Cash Cash Financing Net Change. Cath Bent" from SEE* Cash Casn 30.3 7-252.' 3993.0 -ate s 104 6 .27*3 .27'.1 1050 zss 316.8 10509 2022 -5352 1302 90 5.837 90s 284 ss.*S9m 283 s ss_9S9 co 667 889 Use yearGi debt and foreast FY22 EBITDA grven Cash F ram Cash Acq C-nh Cash Net C "h Cash Paid Cash F Cash 10 E 'o Not Bal Sheet - Standardized TJX COS lncfThe (TJX,US) Growth CF - Standardized Growth Burlington Stores Inc (BURL US) - Gro FY 2022 zo'2.7 0.03 In Milbans USD"ccpt Pet ; 12 Monthi Endng' R over-toe Operating Incan. Nel income to EPS Devidend Shro Accounts invontory Fixed Assets Total Account' p Short - Term Debt Total Debt Tow Bwk Value per Share Cash F torn Oporns Capital Expond'ture Net Change In Cash Free Cash Flow S Year Revenue EBITDA Operating Incorne Net Incorne to Ccyrvron EPS Diluted Dividend per Share Accounts Receivable Fixed Assets Total Assets Working Cavitai Accounts Payable Short-Term Debt Deb' Total Equit Book Value per Share Cash Frot-n Operatbns Free Cash Fbw Source, FY 202' In of USD except FY 2021 01/30,'202f 6','29'2022 .22 -5347 -9724 07.38 -71074 1939 .10 98 .29 27.62 183_60 ooo 00 48 1888 2889 -1.94 -1.94 1218 -53.56 3,788.43 40.46 0.76 -5.40 -30 93 -46.94 3 26 2766 2181 15.80 577 16M 54 06 625 843 9.06 14.07 5107 130.01 71668 352862 3,757.14 30000 1225 37.45 0 70 -7.63 -43.46 -742 -6.02 -1523 2.92 -3298 83.94 -49.61 791 10.80 402 7.39 2S 57 1487 14 07 1034 2562 17,18 -1039 767 14.89 39 0B 7.81 0.36 -501 12 Months Ending 1 Yur Growth Rovenue EBITDA Operatim Inayne Net Income to Corrunon EPS muted EPS Diluted before XO Accmjnts Receivable Inven I Fixed Assets Toto' Assets Work no Capital Accounts P bie Short-Term Debt Totaj Debt Total E Book Value Sharo Cash Operouor,. Capital Net Change in Cash Free Cash Flow 5 Year Growth Revenue EBITDA Operatinq Income Nel income to EPS EPS Diluted before XO i Acccx_jnts Receivable Inventory Fixed Assets Total Assets Modified Working Capital E rnployees Accounts Payable Short-Term Dobt ; Total Debi Totai Capital 5 Year Growth Cash From' Oporabons e Free Cash Fbw -2089 -7468 -32 07 -4 69 2122 1906 1364 0 90 27 76 -12.00 -12.61 -7542 -1677 25470 -7.61 10.01 -1 12 so 86 2140 633 760 07 29 03 3362 -772 FY 2022 01'2"2022 61 73 367.34 .12 99 37 83 723 .27,42 0 00 2529 20 95 63 62 63.36 280 12 2888 1077 20 75 14.3S 13.62 79 14.70 487 770 3101 2246 8.33 1104 196.15 31 36.99 6.23 233
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started