TJXBURL Group Project C BUSMBA515

xlsx

School

Boise State University *

*We aren’t endorsed by this school

Course

520

Subject

Accounting

Date

May 20, 2024

Type

xlsx

Pages

21

Uploaded by PrivateLyrebirdPerson1083

Report
TJX Cos Inc/The (TJX US) - Adjusted Burlington Stores Inc (BURL In Millions of USD except Per Share FY 2021 FY 2022 FY 2023 Est In Millions of USD except Per Share FY 2021 12 Months Ending 01/30/2021 01/29/2022 01/31/2023 12 Months Ending 01/30/2021 Revenue 32,137.0 48,550.0 49,772.1 Revenue 5,764.0 + Sales & Services Revenue 32,137.0 48,550.0 + Sales & Services Revenue 5,764.0 - Cost of Revenue 24,533.8 34,713.8 - Cost of Revenue 3,555.0 + Cost of Goods & Services 24,533.8 34,713.8 + Cost of Goods & Services 3,555.0 Gross Profit 7,603.1 13,836.2 13,973.5 Gross Profit 2,209.0 + Other Operating Income 0.0 0.0 + Other Operating Income 8.4 - Operating Expenses 6,937.1 9,072.6 - Operating Expenses 2,500.5 + Selling, General & Admin 7,020.9 9,081.2 + Selling, General & Admin 2,523.4 + Research & Development 0.0 0.0 + Research & Development 0.0 + Other Operating Expense -83.8 -8.6 + Other Operating Expense -23.0 Operating Income (Loss) 666.0 4,763.5 4,904.8 Operating Income (Loss) -283.1 - Non-Operating (Income) Loss 180.7 115.1 - Non-Operating (Income) Loss 97.8 + Interest Expense, Net 180.7 115.1 + Interest Expense, Net 96.5 + Interest Expense 193.7 119.5 + Interest Expense 97.8 - Interest Income 12.9 4.4 - Interest Income 1.3 + Other Non-Op (Income) Loss 0.0 0.0 + Other Non-Op (Income) Loss 1.3 Pretax Income (Loss), Adjusted 485.3 4,648.5 4,833.1 Pretax Income (Loss), Adjusted -380.9 - Abnormal Losses (Gains) 396.0 250.8 - Abnormal Losses (Gains) 56.7 + Disposal of Assets — 8.6 + Merger/Acquisition Expense — + Early Extinguishment of Debt 312.2 242.2 + Early Extinguishment of Debt 0.2 + Asset Write-Down — + Asset Write-Down 6.0 + Impairment of Goodwill — + Legal Settlement 22.8 + Restructuring — + Restructuring — + Other Abnormal Items 83.8 + Other Abnormal Items 27.7 Pretax Income (Loss), GAAP 89.3 4,397.6 4,833.1 Pretax Income (Loss), GAAP -437.6 - Income Tax Expense (Benefit) -1.2 1,114.8 - Income Tax Expense (Benefit) -221.1 + Current Income Tax 231.1 1,159.0 + Current Income Tax -196.2 + Deferred Income Tax -232.3 -44.2 + Deferred Income Tax -25.0
Income (Loss) from Cont Ops 90.5 3,282.8 3,506.4 Income (Loss) from Cont Ops -216.5 Net Income Avail to Common, GAAP 90.5 3,282.8 3,506.4 Net Income Avail to Common, GAA -216.5 Net Income Avail to Common, Adj 403.3 3,481.0 3,632.9 Net Income Avail to Common, Adj -184.1 Net Abnormal Losses (Gains) 312.9 198.2 Net Abnormal Losses (Gains) 32.4 Net Extraordinary Losses (Gains) 0.0 0.0 Net Extraordinary Losses (Gains) 0.0 Reference Items Reference Items EBITDA 3,357.2 7,537.9 5,837.9 EBITDA 373.3 EBIT 666.0 4,763.5 4,904.8 EBIT -283.1 Dividends per Share 0.26 1.04 1.17 Dividends per Share 0.00 Depreciation Expense 858.0 858.0 Depreciation Expense 206.2 Rental Expense 2,983.4 3,292.4 Rental Expense 616.3 Source: Bloomberg Right click to show data transparency (not supported for Source: Bloomberg Right click
L US) - BBG Adjusted FY 2022 FY 2023 Est 01/29/2022 01/31/2023 9,322.3 8,542.4 9,322.3 5,436.2 5,436.2 3,886.1 3,458.5 11.6 3,073.9 3,095.8 — -21.9 823.8 400.8 67.5 67.3 67.5 0.2 0.2 756.3 341.8 211.0 21.9 159.4 7.7 — — 21.9 545.3 341.8 136.5 84.5 52.0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
408.8 228.2 408.8 228.2 598.2 260.7 189.3 0.0 1,535.6 667.9 823.8 400.8 0.00 0.00 249.2 650.6 to show data transparency (not supported for all values)
TJX Cos Inc/The (TJX US) - Standardized In Millions of USD except Per Share FY 2020 FY 2021 FY 2022 12 Months Ending 02/01/2020 01/30/2021 01/29/2022 Total Assets + Cash, Cash Equivalents & STI 3,216.8 10,469.6 6,226.8 + Cash & Cash Equivalents 3,216.8 10,469.6 6,226.8 + ST Investments 0.0 0.0 0.0 + Accounts & Notes Receiv 386.3 461.1 517.6 + Accounts Receivable, Net 386.3 461.1 517.6 + Notes Receivable, Net 0.0 0.0 0.0 + Inventories 4,872.6 4,337.4 5,961.6 + Other ST Assets 415.0 471.2 552.6 + Derivative & Hedging Assets 7.2 9.0 45.1 + Misc ST Assets 407.8 462.2 393.0 Total Current Assets 8,890.6 15,739.3 13,258.6 + Property, Plant & Equip, Net 14,385.4 14,026.1 14,124.8 + Property, Plant & Equip 20,432.6 20,752.8 21,289.6 - Accumulated Depreciation 6,047.2 6,726.7 7,164.8 + LT Investments & Receivables 0.0 0.0 0.0 + Other LT Assets 869.0 1,048.1 1,078.1 + Total Intangible Assets 95.5 99.0 96.7 + Goodwill 95.5 99.0 96.7 + Other Intangible Assets 0.0 0.0 0.0 + Deferred Tax Assets 12.1 127.2 185.0 + Derivative & Hedging Assets 0.0 0.0 0.0 + Misc LT Assets 761.3 821.9 796.5 Total Noncurrent Assets 15,254.4 15,074.2 15,202.9 Total Assets 24,145.0 30,813.6 28,461.5 Liabilities & Shareholders' Equity + Payables & Accruals 3,419.3 5,825.6 5,734.5
+ Accounts Payable 2,672.6 4,823.4 4,465.4 + Accrued Taxes 24.7 81.5 181.2 + Interest & Dividends Payable 281.7 315.6 311.8 + Other Payables & Accruals 440.4 605.1 776.1 + ST Debt 1,411.2 1,677.6 1,576.6 + ST Borrowings 0.0 0.0 0.0 + ST Lease Liabilities 1,411.2 1,677.6 1,576.6 + ST Finance Leases 0.0 0.0 0.0 + ST Operating Leases 1,411.2 1,677.6 1,576.6 + Current Portion of LT Debt 0.0 0.0 0.0 + Other ST Liabilities 2,319.7 3,300.5 3,157.1 + Deferred Revenue 784.2 891.8 1,084.2 + Derivatives & Hedging 20.2 21.9 3.3 + Misc ST Liabilities 1,515.3 2,386.8 2,069.6 Total Current Liabilities 7,150.2 10,803.7 10,468.1 + LT Debt 10,053.3 13,076.1 10,930.4 + LT Borrowings 2,236.6 5,332.9 3,354.8 + LT Lease Liabilities 7,816.6 7,743.2 7,575.6 + LT Finance Leases 0.0 0.0 0.0 + LT Operating Leases 7,816.6 7,743.2 7,575.6 + Other LT Liabilities 993.3 1,101.1 1,059.9 + Accrued Liabilities 0.0 0.0 0.0 + Pension Liabilities 101.8 106.0 114.0 + Pensions 0.0 0.0 0.0 + Deferred Revenue 0.0 0.0 0.0 + Deferred Tax Liabilities 142.2 37.2 44.2 + Derivatives & Hedging 0.0 0.0 0.0 + Misc LT Liabilities 749.3 957.9 901.7 Total Noncurrent Liabilities 11,046.5 14,177.2 11,990.3 Total Liabilities 18,196.8 24,980.9 22,458.5 + Preferred Equity and Hybrid Capital 0.0 0.0 0.0 + Share Capital & APIC 1,199.1 1,465.2 1,181.2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
+ Common Stock 1,199.1 1,204.7 1,181.2 + Additional Paid in Capital 0.0 260.5 0.0 - Treasury Stock 0.0 0.0 0.0 + Retained Earnings 5,422.3 4,973.5 5,509.0 + Other Equity -673.2 -606.1 -687.2 Equity Before Minority Interest 5,948.2 5,832.7 6,003.0 + Minority/Non Controlling Interest 0.0 0.0 0.0 Total Equity 5,948.2 5,832.7 6,003.0 Total Liabilities & Equity 24,145.0 30,813.6 28,461.5 Reference Items Shares Outstanding (millions) 1,199.1 1,199.1 1,181.2 Stock Price 59.0 64.0 71.4 Number of Employees 286,000.00 286,000.00 340,000.00 Source: Bloomberg
Burlington Stores Inc (BURL US) - Standardized In Millions of USD except Per Share FY 2020 FY 2021 FY 2022 12 Months Ending 02/01/2020 01/30/202101/29/2022 Total Assets + Cash, Cash Equivalents & STI 403.1 1,380.3 1,091.1 + Cash & Cash Equivalents 403.1 1,380.3 1,091.1 + ST Investments 0.0 0.0 0.0 + Accounts & Notes Receiv 91.5 62.2 54.1 + Accounts Receivable, Net 91.5 62.2 54.1 + Notes Receivable, Net 0.0 0.0 0.0 + Inventories 777.2 740.8 1,021.0 + Other ST Assets 145.5 327.4 381.5 + Derivative & Hedging Assets — 0.0 0.0 + Misc ST Assets 145.5 327.4 381.5 Total Current Assets 1,417.4 2,510.6 2,547.6 + Property, Plant & Equip, Net 3,800.3 3,908.2 4,190.7 + Property, Plant & Equip 5,162.6 5,406.9 5,842.2 - Accumulated Depreciation 1,362.3 1,498.7 1,651.4 + LT Investments & Receivables 0.0 0.0 0.0 + Other LT Assets 376.2 362.2 351.2 + Total Intangible Assets 285.8 285.1 285.1 + Goodwill 47.1 47.1 47.1 + Other Intangible Assets 238.7 238.0 238.0 + Deferred Tax Assets 4.7 4.4 4.0 + Derivative & Hedging Assets 0.0 0.0 0.0 + Misc LT Assets 85.7 72.8 62.1 Total Noncurrent Assets 4,176.5 4,270.5 4,541.9 Total Assets 5,593.9 6,781.1 7,089.5 Liabilities & Shareholders' Equity + Payables & Accruals 759.1 862.6 1,080.8
+ Accounts Payable 759.1 862.6 1,080.8 + Accrued Taxes — — — + Interest & Dividends Payable — — — + Other Payables & Accruals 0.0 0.0 0.0 + ST Debt 305.8 308.5 373.2 + ST Borrowings 0.0 0.0 0.0 + ST Lease Liabilities 305.8 308.5 373.2 + ST Finance Leases 3.6 3.9 14.4 + ST Operating Leases 302.2 304.6 358.8 + Current Portion of LT Debt — 0.0 0.0 + Other ST Liabilities 397.0 512.8 493.7 + Deferred Revenue 0.0 0.0 0.0 + Derivatives & Hedging 0.0 0.0 0.0 + Misc ST Liabilities 397.0 512.8 493.7 Total Current Liabilities 1,461.9 1,684.0 1,947.6 + LT Debt 3,323.7 4,328.6 4,080.5 + LT Borrowings 955.2 1,884.0 1,501.9 + LT Lease Liabilities 2,368.6 2,444.5 2,578.6 + LT Finance Leases 46.6 43.8 39.2 + LT Operating Leases 2,322.0 2,400.8 2,539.4 + Other LT Liabilities 280.1 303.8 300.9 + Accrued Liabilities 0.0 0.0 0.0 + Pension Liabilities 0.0 0.0 — + Pensions 0.0 0.0 — + Deferred Revenue 0.0 0.0 0.0 + Deferred Tax Liabilities 182.3 199.9 220.0 + Derivatives & Hedging 26.2 31.7 11.0 + Misc LT Liabilities 71.6 72.3 69.9 Total Noncurrent Liabilities 3,603.8 4,632.3 4,381.4 Total Liabilities 5,065.7 6,316.3 6,329.1 + Preferred Equity and Hybrid Capital 0.0 0.0 0.0 + Share Capital & APIC 1,587.2 1,809.8 1,927.6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
+ Common Stock 0.0 0.0 0.0 + Additional Paid in Capital 1,587.1 1,809.8 1,927.6 - Treasury Stock 1,244.8 1,310.4 1,577.0 + Retained Earnings 204.8 -11.7 414.3 + Other Equity -19.0 -23.0 -4.4 Equity Before Minority Interest 528.1 464.8 760.4 + Minority/Non Controlling Interest 0.0 0.0 0.0 Total Equity 528.1 464.8 760.4 Total Liabilities & Equity 5,593.9 6,781.1 7,089.5 Reference Items Shares Outstanding 65.9 66.4 66.5 Stock Price 284.90 283.85 Number of Employees 47,000.00 55,959.00 55,959.00 Source: Bloomberg
TJX Cos Inc/The (TJX US) - Standardized In Millions of USD except Per Share FY 2021 FY 2022 12 Months Ending 01/30/2021 01/29/2022 Cash from Operating Activities + Net Income 90.5 3,282.8 + Depreciation & Amortization 870.8 868.0 + Non-Cash Items 381.3 251.2 + Stock-Based Compensation 58.5 189.0 + Deferred Income Taxes -230.7 -44.5 + Other Non-Cash Adj 553.4 106.6 + Chg in Non-Cash Work Cap 3,219.4 -1,344.5 + (Inc) Dec in Accts Receiv -71.1 -61.5 + (Inc) Dec in Inventories 588.8 -1,657.8 + Inc (Dec) in Accts Payable 2,111.2 -338.1 + Inc (Dec) in Other 590.6 712.8 + Net Cash From Disc Ops 0.0 0.0 Cash from Operating Activities 4,561.9 3,057.5 Cash from Investing Activities + Change in Fixed & Intang -568.0 -1,044.8 + Disp in Fixed & Intang 0.0 0.0 + Disp of Fixed Prod Assets — 0.0 + Disp of Intangible Assets — 0.0 + Acq of Fixed & Intang -568.0 -1,044.8 + Acq of Fixed Prod Assets -568.0 -1,044.8 + Acq of Intangible Assets 0.0 0.0 + Other Investing Activities -10.6 -1.6 + Net Cash From Disc Ops 0.0 0.0 Cash from Investing Activities -578.6 -1,046.4 Cash from Financing Activities
+ Dividends Paid -278.3 -1,251.8 + Cash From (Repayment) Debt 3,568.5 -2,975.5 + Cash From (Repay) ST Debt — 0.0 + Cash From LT Debt 5,986.9 0.0 + Repayments of LT Debt -2,418.4 -2,975.5 + Cash (Repurchase) of Equity 9.7 -1,946.9 + Increase in Capital Stock 211.2 229.4 + Decrease in Capital Stock -201.5 -2,176.3 + Other Financing Activities -71.7 -25.5 + Net Cash From Disc Ops 0.0 0.0 Cash from Financing Activities 3,228.3 -6,199.8 Effect of Foreign Exchange Rates 41.3 -54.1 Net Changes in Cash 7,252.8 -4,242.8 Cash Paid for Taxes 146.0 1,118.9 Cash Paid for Interest 153.0 138.7 Reference Items EBITDA 3,273.4 7,529.3 Net Cash Paid for Acquisitions — — Tax Benefit from Stock Options — — Free Cash Flow 3,993.9 2,012.7 Free Cash Flow to Firm — 2,101.9 Free Cash Flow to Equity 7,562.4 -962.8 Free Cash Flow per Basic Share 3.33 1.68 Price to Free Cash Flow 19.24 42.56 Cash Flow to Net Income 50.42 0.93 Source: Bloomberg
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Burlington Stores Inc (BURL US) - Standardized In Millions of USD except Per Share FY 2021 FY 2022 12 Months Ending 01/30/2021 01/29/2022 Cash from Operating Activities + Net Income -216.5 408.8 + Depreciation & Amortization 220.4 249.2 + Non-Cash Items 120.9 319.8 + Stock-Based Compensation 55.8 58.5 + Deferred Income Taxes -25.0 52.0 + Other Non-Cash Adj 90.1 209.3 + Chg in Non-Cash Work Cap 94.3 -144.7 + (Inc) Dec in Accts Receiv 26.9 10.2 + (Inc) Dec in Inventories 36.5 -280.2 + Inc (Dec) in Accts Payable 104.6 214.8 + Inc (Dec) in Other -73.6 -89.5 + Net Cash From Disc Ops 0.0 0.0 Cash from Operating Activities 219.2 833.2 Cash from Investing Activities + Change in Fixed & Intang -273.3 -343.8 + Disp in Fixed & Intang 0.0 8.7 + Disp of Fixed Prod Assets 0.0 8.7 + Disp of Intangible Assets 0.0 0.0 + Acq of Fixed & Intang -273.3 -352.5 + Acq of Fixed Prod Assets -273.3 -352.5 + Acq of Intangible Assets 0.0 0.0 + Other Investing Activities -0.9 -0.6 + Net Cash From Disc Ops 0.0 0.0 Cash from Investing Activities -274.1 -344.4 Cash from Financing Activities
+ Dividends Paid 0.0 0.0 + Cash From (Repayment) Debt 1,105.0 -535.2 + Cash From (Repay) ST Debt 0.0 0.0 + Cash From LT Debt 1,505.0 956.6 + Repayments of LT Debt -400.0 -1,491.8 + Cash (Repurchase) of Equity -30.6 -226.7 + Increase in Capital Stock 34.9 39.9 + Decrease in Capital Stock -65.5 -266.6 + Other Financing Activities -42.2 -16.0 + Net Cash From Disc Ops 0.0 0.0 Cash from Financing Activities 1,032.2 -778.0 Effect of Foreign Exchange Rates 0.0 0.0 Net Changes in Cash 977.2 -289.2 Cash Paid for Taxes 45.0 130.2 Cash Paid for Interest 48.4 52.7 Reference Items EBITDA 316.8 1,480.6 Net Cash Paid for Acquisitions 0.0 0.6 Tax Benefit from Stock Options — — Free Cash Flow -54.1 480.7 Free Cash Flow to Firm — 531.3 Free Cash Flow to Equity 1,050.9 -45.9 Free Cash Flow per Basic Share -0.82 7.22 Price to Free Cash Flow — 31.90 Cash Flow to Net Income — 2.04 Source: Bloomberg
TJX Cos Inc/The (TJX US) - Growth Burlington Stores Inc (BURL In Millions of USD except Per Share FY 2021 FY 2022 In Millions of USD except Per S FY 2021 12 Months Ending 01/30/2021 01/29/2022 12 Months Ending 01/30/2021 1 Year Growth 1 Year Growth Revenue -22.96 51.07 Revenue -20.89 EBITDA -53.47 130.01 EBITDA -74.68 Operating Income -86.82 716.68 Operating Income — Net Income to Common -97.24 3,528.62 Net Income to Common — EPS Diluted -97.38 3,757.14 EPS Diluted — Dividend per Share -71.74 300.00 EPS Diluted before XO — Accounts Receivable 19.39 12.25 Accounts Receivable -32.07 Inventory -10.98 37.45 Inventory -4.69 Fixed Assets -2.50 0.70 Fixed Assets 2.84 Total Assets 27.62 -7.63 Total Assets 21.22 Working Capital 183.60 -43.46 Working Capital — Employees 0.00 18.88 Employees 19.06 Accounts Payable 80.48 -7.42 Accounts Payable 13.64 Short-Term Debt 18.88 -6.02 Short-Term Debt 0.90 Total Debt 28.69 -15.23 Total Debt 27.76 Total Equity -1.94 2.92 Total Equity -12.00 Book Value per Share -1.94 4.97 Book Value per Share -12.61 Cash From Operations 12.18 -32.98 Cash From Operations -75.42 Capital Expenditures -53.56 83.94 Capital Expenditures -16.77 Net Change In Cash 3,788.43 — Net Change In Cash 254.70 Free Cash Flow 40.46 -49.61 Free Cash Flow — 5 Year Growth 5 Year Growth Revenue 0.76 7.91 Revenue 2.36 EBITDA -5.40 10.80 EBITDA -7.61
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Operating Income -30.93 4.32 Operating Income — Net Income to Common -47.54 7.39 Net Income to Common — EPS Diluted -46.94 25.57 EPS Diluted — Dividend per Share -9.15 14.87 EPS Diluted before XO — Accounts Receivable 14.14 14.87 Accounts Receivable 10.01 Inventory 3.26 10.34 Inventory -1.12 Fixed Assets 27.66 25.52 Fixed Assets 30.86 Total Assets 21.81 17.18 Total Assets 21.40 Working Capital 15.80 -1.39 Modified Working Capital — Employees 5.77 7.67 Employees 8.33 Accounts Payable 16.97 14.89 Accounts Payable 7.60 Short-Term Debt — — Short-Term Debt 194.07 Total Debt 54.06 39.08 Total Debt 29.03 Total Equity 6.25 5.88 Total Capital 5 Year Growth 33.62 Book Value per Share 8.43 7.81 Cash From Operations 9.06 -3.36 Cash From Operations -7.72 Free Cash Flow 14.07 -5.01 Free Cash Flow — Source: Bloomberg
L US) - Growth FY 2022 01/29/2022 61.73 367.34 — — — — -12.99 37.83 7.23 4.55 -27.42 0.00 25.29 20.95 -3.96 63.62 63.36 280.12 28.98 — — 10.77 20.75
14.35 13.62 14.79 14.79 4.57 7.78 31.91 22.46 — 8.33 11.04 196.15 31.55 36.99 6.23 2.33
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Burlington Stores Inc (BURL US) - TJX Cos Inc/The (TJX US) You should be able to copy the TJX formulas over 5 columns for Burlington's ratios In Millions of USD except Per Share FY 2022 FY 2022 12 Months Ending 01/29/2022 01/29/2022 3,556 618 Total Capital 18,509.98 5,214.09 18.19% 6.67% WACC 8.50% 9.00% EVA spread 9.69% -2.33% Returns Return on Equity (again use averages here) 58.82% 97.64% Return on Assets (again use averages here) 11.08% 8.62% 18.19% 6.67% Margins Gross Margin 28.50% 41.69% EBITDA Margin 15.53% 16.47% 7.32% 6.63% Net Profit Margin 7.17% 6.42% Taxes Effective Tax Rate 25.4% 25.0% Turnovers Capital Turnover 2.48 1.01 Working Capital NOWC Balance 4,367.0 973.1 NOWC Turnover 11.1 9.6 Days Sales Outstanding 3.7 2.3 Days Inventory 54.1 59.1 Accounts Payable Days (use COGS) 48.8 65.2 Cash Conversion Cycle (AR + INV - AP) days 9.0 (3.8) NOPAT (use row 22 for tax rate) Return on Invested Capital (use average capital) Return on Invested Capital (from above) Net Operating Margin (use tax rate below)
Inventory to Cash Days (AR + INV) 57.8 61.4 Cash percentage (Cash&STI-to-Assets) 47.0% 42.8% PP&E Turnover 3.4 2.2 Liquidity Current Ratio 1.27 1.31 Quick Ratio 0.70 0.78 Solvency Forecast EBITDA Next Year 5,838 668 Total Debt/EBITDA (both ST and LT Debt) 2.14 6.67 EBIT to Interest Expense (use total, not net) 39.86 12.20 Total Debt/Equity (both ST and LT) 2.01 5.86 Total Debt/Capital (both ST and LT) 0.68 0.85
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

ACC_2233_Lesson_Seven_Learning_Activities and Solutions.docx
fm1[2] 1.docx
Homework 4.xlsx
Image 5-18-24 at 7.32 PM.jpeg
Homework 2.xlsx
4-1 Assignment ACC201.docx
Homework 1.xlsx
Image 5-18-24 at 7.31 PM.jpeg
Assessment 3. pdf.pdf
CPPREP5006 - Written Questions v1.0.docx
task 1.docx
1 Describe the.docx
Related Questions
Summerfields Sdn BhdBalance Sheet as at 31 December 2020 (RM’000)Cash 400 Account payable 1,200Marketable securities 500 Accrued wages 1,200Accounts receivable 750 Notes payable 700Inventories 500 Mortgage payable 2,200Net Fixed Asset 4,850 Common stock 500Retained earnings 1,200TOTAL ASSETS 7,000 TOTAL CLAIMS 7,000Additional information:-i) Sales in 2020 was RM 12 million and it is projected to increase to 18 million in 2021.ii) The company is operating at full capacity.iii) The net profit for this company in 2020 was RM1,200,000 and dividend payment wasRM300,000.iv) All external financing will be absorbed and met by common stock.Prepare a pro-forma balance sheet for Summerfields Sdn Bhd for the year ended 2021by using percent of sales method and determine the external funds required.
A. Belowis the Statement of Firancial Position of QM General Merchandise: Increase (Decrease) 2019 2020 Percentage P 192,375 937,508 152,618 P1,282,500 P1,392,750 P 265,500 968,500 159,750 Curent Assets Property, Plant, and Equipment Other Assets Total Assets Liabilities |Total Current Liabilities Long-term debt Owner's Capit al Total Liabilities and Equity P 220,590 491,198 570,713 P1,282,500 P1,392,750 P 225,450 460,250 706,950 Requirements: Prepare a horizontal aralysis for QM General Merchandise.
General Account
Walmart Revenue The annual revenue of Walmart is given in the table below (source ). Walmart Annual Revenue (Billions of US dollars) 559.151 Year 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 523.964 514.405 500.343 485.873 482.130 485.651 476.294 468.651 446.509 421.849 408.085 404.254 377.023 348.368 312.101 284.310 Apply linear regression to the data in the table to find a model y = mx + b, where y is Walmart's annual revenue in billions of US dollars, and a is the number of years since 2000. Use the model y = mx + b with m rounded to the nearest tenth and 6 rounded to the nearest
Powell Panther Corporatlon: Income Statements for Year Ending December 31 (millons of dollars) 2021 2020 Sales 2,185.0 S 1,900.0 Operating costs excluding depreciation and amortization 1,748.0 1,615.0 EBITDA 437.0 S 285.0 Depreciation and amortization 46.0 42.0 Earnings before interest and taxes (EBIT) 391.0 S 243.0 Interest 48.1 41.8 Earnings before taxes (EBT) 342.9 S 201.2 Taxes (25%) 137.2 80.5 Net income 205.7 S 120.7 Common dividends 185.1 S 96.6 Powell Panther Corporatlon: Balance Sheets as of December 31 (mllons of dollars) 2021 2020 Assets Cash and equivalents 34.0 $ 27.0 Accounts receivable 251.0 228.0 Inventories 502.0 456.0 Total current assets 787.0 $ 711.0 Net plant and equipment 460.0 418.0 Total assets 1,247.0 S 1,129.0 Liabilities and Equity Accounts payable 219.0 $ 190.0 Accruals 137.0 114.0 Notes payable 43.7 38.0 Total current liabilities 399.7 342.0 Long-term bonds 437.0 380.0 Total liabilities 836.7 $ 722.0 Common stock 353.5 370.8 Retained earnings 56.8 36.2…
Life-Positive’s Account  Balances   2021 ($)                        2022 ($)                                                                  Accounts Payable                           24,600.00                      21,250.00 Accounts receivable                       15,700.00                      12,340.00  Cash                                               23,450.00                      28,600.00                                                                                   Cost of goods sold                         19,700.00                      23,000.00 Depreciation                                   3,090.00                        4,590.00 Dividends                                       5,800.00                       10,800.00 Interest                                           2,340.00                        2,890.00 Inventory                                        7,050.00                       8,640.00  Long-term debt                             28,000.00…
7
Chapter : Adjustment financial statements
Assets Current assets Net fixed assets INCOME STATEMENT, 2022 (Figures in $ millions) Revenue Cost of goods sold Depreciation Interest expense 2021 $ 101 2022 $ 195 910 1,010 $ 2,005 1,085 405 251 Req A and B Req C and D BALANCE SHEET AT END OF YEAR (Figures in $ millions) Liabilities and Shareholders' Equity Current liabilities Long-term debt Req E Complete this question by entering your answers in the tabs below. a&b. What is shareholders' equity in 2021 and 2022? c&d. What is net working capital in 2021 and 2022? e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income. f. What is cash provided by operations during 2022? g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in fixed assets during 2022? Answer is complete but not entirely correct. h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…
Global Corp. initially projected the 2019 income statement shown in the table E. Suppose that in 2019, Global launched an aggressive marketing campaign that boosted 2019 sales further by 14.1%. However, their operating margin fell from 5.56% to 4.49% Suppose that they had no other income, interest expenses were unchanged, and taxes were the same percentage of pretax income (26%) as in 2018. a. What was Global's EBIT in 2019? b. What was Global's income in 2019? c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? a. What was Global's EBIT in 2019? Global's EBIT was $ million. (Round to two decimal places.) b. What was Global's income in 2019? Net income was $ million. (Round to two decimal places.) c. If Global's P/E ratio (18.0) and number of shares outstanding (3.6 million) remained unchanged, what was Global's share price in 2019? Global's share price in 2019 was $. (Round to the nearest cent.)
FULL HD-1080- Q @ 2 P W S F3 # 3 E D Current assets Cash Trading investments Accounts receivable, net Inventory Prepaid expenses Total current assets Total current liabilities Additional information: (in thousands) Allowance for doubtful accounts Credit sales Cost of goods sold F4 O $ 4 R F DIO % 5 F6 (in thousands) € T 2021 $30 $ 91 $ 60 A 55 6 671 624 41 2021 $ 1,421 $ 1,311 $ 882 $ 826 H O M 4,175 Y 2,909 2020 H $ 50 $ 45 FB & 7 60 582 A 526 52 2020 3,901 2,645 U 2019 * 8 40 498 581 29 $ 1,208 $ 756 2019 $ 40 3,733 2,364 F10 4 ( 9 U K O F12 D Ser Lk P PrtSc SysRq Pause AOGANO
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Related Questions
Recommended textbooks for you
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
SEE MORE TEXTBOOKS