Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Ratio Calculations should be done in a table in Excel and included with your submission. The following ratios should be included for TJ Maxx

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedThe Ratio Calculations should be done in a table in Excel and included with your submission. The following ratios should be included for TJ Maxx for 2 years: calculate these ratios below is a link to 10-K form

  • Working Capital
  • Current Ratio
  • Total Debt to Total Equity Ratio
  • Times Interest Earned
  • RNOA
  • ROCE

Show calculations please for TJ Maxx

Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Cash flows from operating activ... Net Income 3,272,193 3,059,798 2.607.948 2.298.234 Depreciation & amortization 867,303 819,655 725.957 658,796 Deferred income taxes -6,233 -88,594 -137,440 -5.503 Stock based compensation 124.957 103,557 101,362 102.251 Change in working capital 144,059 155,976 -385,444 563,445 Accounts receivable - 42,998 -23,532 -62,358 -23,235 Inventory -296,541 -465,429 -450,377 11,862 Accounts Payable 29.338 198,212 205,111 48,253 Other working capital 2,843,424 2.963,320 1.968,007 2,577.147 Other non-cash items -63.675 20.414 5,120 -1.310 Net cash provided by operatin... 4,066,540 4,088,459 3,025,624 3,601,894 Cash flows from investing activi... Investments in property, plant a... -1,223,116 -1,125,139 1,057,617 -1,024,747 Acquisitions, net -230,156 -2,324 Purchases of investments -28,838 - 161,625 -861,256 -716,953 Sales/Maturities of investments 12,720 636.560 906,137 529,146 Other investing activites 7.419 26,652 -2,300 Net cash used for investing act... -1,461,971 -623,552 1,012,736 -1,214,878 Cash flows from financing activ... Debt repayment -7,115 -3,138 -425,584 Common stock issued 232,106 255,241 133,687 164,190 Common stock repurchased - 1,551,992 -2,406,997 -1,644,581 -1,699,998 Dividends Paid -1,071,562 -922,596 -764,040 -650,988 Other financing activites -23,423 -16,014 -19,274 57.928 Net cash used privided by (use... -2,414,871 -3,097,481 -2,297,346 -1,561,912 Net cash used privided by (use... -2,414,871 -3,097,481 -2,297,346 -1.561,912 Net change in cash 186,523 271,752 - 171,372 834,376 Cash at beginning of period 3,030,229 2,758,477 2,929,849 2,095,473 Cash at end of period 3,216,752 3,030,229 2.758,477 2,929,849 Free Cash Flow Operating Cash Flow 4,066,540 4,088,459 3,025,624 3,601,894 Capital Expenditure -1,223,116 -1,125,139 -1,057,617 -1,024.747 Free Cash Flow 2,843,424 2,963,320 1,968,007 2.577.147 20 19 18 17 Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Total Revenue 41,716,977 38,972,934 35,864,664 33,183,744 Cost of Revenue 29,845,780 27,831,177 25,502,167 23,565,754 Gross Profit 11,871,197 11,141,757 10,362,497 9,617,990 Operating Expenses Selling General and Administrati... 7,454,988 6,923,564 6,375,071 5,768,467 Total Operating Expenses 7,454,988 6,923,564 6,375,071 5,768,467 Operating Income or Loss 4,416,209 4,218,193 3,987,426 3,849,523 Interest Expense 59,086 64,839 64,295 61,671 Total Other Income/Expenses Net -36,122 -99,250 -82,946 Income Before Tax 4,406,183 4,173.211 3,856,588 3,723,043 Income Tax Expense 1,133,990 1,113,413 1,248,640 1,424,809 Income from Continuing Operations 3,272,193 3,059,798 2,607,948 2,298,234 Net Income 3,272,193 3,059,798 2,607,948 2,298,234 Net Income available to common s... 3,272,193 3,059.798 2,607,948 2,298,234 Basic EPS 2.48 2.06 1.78 Diluted EPS 2.43 2.02 1.73 Basic Average Shares 1,217,183 1,256,018 1,292,638 Diluted Average Shares 1,259,252 1,292,210 1,328,864 EBITDA 5,332,572 5,057,705 4,646,840 4,443,510 Breakdown 1/31/2020 1/31/2019 1/31/2018 1/31/2017 Assets Current Assets > Cash 3,216,752 3,030.229 3,264.642 3,473,091 Net Receivables 386,261 346,298 327,166 258,831 Inventory 4,872,592 4,579,033 4,187,243 3,644,959 Total Current Assets 8.890,622 8.469.222 8,485,727 7,750,774 Non-current assets > Property, plant and equip... 14,385.380 5,255,208 5.006.053 4,532,894 Goodwill 95.546 97,552 100,069 195,871 Other long term assets 761,323 497.580 459,608 398,076 Total non-current assets 15.254.381 5,856,807 5.572,288 5,133,034 Total Assets 24,145,003 14,326,029 14,058,015 12,883,808 Liabilities and stockholders' eq... Liabilities > Current Liabilities 7.150.247 5,531,374 5,125.537 4,757.656 Non-current liabilities Long Term Debt 2.236,625 2,233,616 2.230.607 2,227.599 Deferred taxes liabilities 397,541 393,658 277,810 350,713 Other long-term liabilities 28,743 27.278 33,248 34,140 Total non-current liabilities 11,046,544 3,746,049 3,784,169 3,615,553 Total Liabilities 18,196,791 9,277,423 8,909,706 8,373,209 Stockholders' Equity Common Stock 1.199.100 1,217,183 628,009 646,319 Retained Earnings 5,422,283 4,461,744 4,962.159 4,558,506 Accumulated other comprehe... -673,171 -630,321 -441,859 -694,226 Total stockholders' equity 5.948.212 5,048,606 5,148,309 4,510.599 Total liabilities and stockholde... 24.145,003 14,326.029 14,058.015 12,883,808

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Guidelines For Laboratory Quality Auditing

Authors: Donald C. Singer, Ronald P. Upton

1st Edition

0824787846, 978-0824787844

More Books

Students also viewed these Accounting questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago

Question

9. Understand the phenomenon of code switching and interlanguage.

Answered: 1 week ago

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago