AComparison of Firm Performance12 2013 Financials3Net operating revenues4 Cost of goods sold5 Gross profit6 Selling, general, and administrative expense7 Other costs8 Operating income9Interest expense10 Other income (loss) - net11 Income before income taxes12 Income taxes13 Net income14 Assets15 Cash and cash equivalents16 Net receivables17 Inventories18 Prepaid expenses and other19 Total current assets20 Property, plant and equipment21 Goodwill22 Other assets23 Total assets24 Liabilities and Stockholder Equity25 Accounts payable26 Short-term debt27 Total current liability28 Long-term debt29 Other liabilities30 Total liabilities31 Stockholder equity32BWalmart469,162352,488116,67488,87327,8012,25118725,7377,98117,7567,7816,76843,8031,58859,940116,68120,4975,987203,10559,09912,71971,81841,417113,23589,870CMacy's27,93116,72511,2068,440882,678388(134)2,1567671,3891,8363715,3083617,8768,1963,7431,17620,9914,9511245,0756,8063,05914,9406,051D Using the financial statements in the attached workbook (Walmart Macys Financials.xlsx), calculate ROA, Profit Margin, Asset Turn-over, and Cash-to-cashcycle for Walmart and Macy's as of 2013. For returns when you calculate ROA, use a corporate tax rate of 21%.

ROA=Net IncomeTotal Assets×100 Profit Margin=Net IncomeNet Revenues×100 Asset Turnover=Net…

Answered: Using the financial statements in the…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

performance of National Company. Comment on overall financial position and financial health of the business. Identify problems and recommend possible solutions, if historical ratios of company are: Ratios201720182019 Current Ratio1.41.51.6 Acid Test Ratio0.850.740.63 Asset Turnover Ratio4 times3.22.5 Inventory Turnover Ratio6 times5.55 Collection Period6 times5.55 Account payable turnover8 times10 times12 times Total Debt to equity Ratio1.381.611.91 Interest cover543.5 Gross Profit Ratio20%22%23% Net Profit Margin8.5%6.7%3.8% Return on Equity20%21%24% Sales Growth Rate8%5%2% P/E Ratio1098 Fixed Asset Utilization Ratio21.71.4
Use the following Income Statement and Balance Sheet Information for 2018 to answer the question below. This is a Retail Company. All numbers are in Millions. Income Statement Total Sales213.8 Cost of Sales151.3 Gross Profit213.8-151.3 Selling and Administrative Expenses22.3 Research and Development 7.7 Depreciation and Amortization4.5 Other Income2.4 EBIT213.8-151.3-22.3-7.7-4.5+2.4 Interest Expense5.8 Pretax Income213.8-151.3-22.3-7.7-4.5+2.4-5.8 Taxes( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.30 Net Income( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.70 Balance Sheet Assets Liabilities Cash65.8Accounts Payable43.3Accounts Receivable54.4Notes Payable/Short term debt1.6Inventories4.4 Total Current Assets65.8+54.4+4.4Total Current Liabilities43.3+1.6 Net property, plant and equipment103.4Long-term debt80.0Total long-term assets103.4Total long-term debt liabilities80.0 Total Liabilities43.3+1.6+80.0 Stockholders' Equity (Total Equity)65.8+ 54.4+4.4+103.4-43.3-1.6-80.0Total…
Y plc's income statement for the year ended 31 December 2012 and statements of financial position as at 31 December 2011 and 31 December 2012 were as follows: Y plc - Income statement for the year ended 31 December 2012 £’000 £’000 Sales revenue 360 Raw materials consumed (35) Staff costs (47) Depreciation (59) Loss on disposal of machinery (9) (150) Operating profit 210 Interest payable (14) Profit before tax 196 Income tax expense (62) Profit after tax 134 Y plc – Statement of Financial Position as at 31 December 2012 2012 2011 2011 £'000 £'000 £'000 £'000 Non-current assets Cost 798 780 Depreciation (159) (112) 639 668 Current asset Inventory 12 10 Trade receivables 33 25 Bank 24 28 69 63 708 731 Equity and liabilities Share capital 180 170 Share premium 18 12 Retained earnings 358 257 556 439 Non-current…
Prepare a horizontal analysis of the following excerpt of an income statement. Eye Witness Security GmbH Income Statement 2012 2011 Net sales €540.400 €573.000 Cost of goods sold 130.300 165.800 Gross profit (loss) 410.100 407.200 Operating expenses 264.900 205.100 Net income (loss) €145.200 €202.100
SalesOperating costs (excluding depreciation and amortization) EBITDADepreciation and amortization Earnings before interest and taxes Interest Earnings before taxesTaxes (40%)Net income available to common stockholders Common dividendsSEBRINGCORPORATION: BALANCESHEETSFORYEARENDINGDECEMBER31 (FIGURES ARE STATED IN MILLIONS) Assets: Cash and marketable securities Accounts receivableInventories Total current assets Gross Fixed Assets Less DepreciationNet plant and equipment Total assets 2005 2004 $3,600.0 $3,000.0 $3,060.0 $2,550.0 $540.0 $450.0 90.0 75.0 $450.0 $375.0 65.0 60.0 $385.0 $315.0 154.0 126.0 $231.0 $189.0 $15.0 $13.0 2005 2004 $ 36.00 $ 30.00 $ 340.00 $ 250.00 $ 457.00 $ 351.00 $ 833.00 $ 631.00 $ 1,065.00 $ 825.00 $ (165.00) $ (75.00) $ 900.00 $ 750.00 $ 1,733.00 $ 1,381.00 $ 324.00 $ 270.00 $ 201.00 $ 155.00 $ 216.00 $ 180.00 $ 741.00 $ 605.00 $ 450.00 $ 450.00 $ 1,191.00 $ 1,055.00 $ 150.00 $ 150.00 $ 392.00 $ 176.00 $ 542.00 $ 326.00 $ 1,733.00 $ 1,381.00…
Active Fast Berhad has the following income statement items for 2021: Revenue/Sales RM559,236 Cost of goods sold RM311,003 EBIT RM248,233 Interest expenses RM93,938 Income tax expenses RM54,003 Dividend payment 40% of net profit What is the amount of the firm's retained earnings? Select one: a. RM163,438 b. RM60,175 c. RM40,117 d. RM148,910
Analyzing the quality of firm earnings) Kabutell, Inc. had net income of ,$ 800,000 cash flow from financing activities of $60,000 , depreciation expenses of $60,000 , and cash flow from operating activities of $500,000 . a. Calculate the quality of earnings ratio. What does this ratio tell you? b. Kabutell, Inc. reported the following in its annual reports for 2011–2013: ($ million) 2011 2012 2013 Cash Flow from Operations $477 $403 $472 Capital Expenditures (CAPEX) $459 $447 $455 a. What is Kabutell's quality of earnings ratio? 62.562.5% (Round to one decimal place.) Part 3 b. What is Kabutell's average capital acquisitions ratio over the three-year period? enter your response here% (Round to one decimal place.)
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Y4–20Y8 Return on total assets 28%…
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Y4–20Y8 Return on total assets 28%…
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Y4–20Y8 Return on total assets 28%…
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1
Prepare the Pro-Forma Statement of Financial Position for the year ending 31 December 2023 INFORMATIONSibiya ProjectsStatement of Comprehensive Income for the year ended 31 December 2022 RSales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable, selling and administrative costs (1 500 000)Fixed selling and administrative costs (500 000)Net profit 2 250 000 Statement of Financial Position for the year ended 31 December 2022ASSETS RNon-current assets 800 000Property, plant and equipment 800 000 Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000TOTAL ASSETS 4 200 000 EQUITY AND LIABILITIESEquity 3 760 000 Current liabilities 440 000Accounts payable 440 000TOTAL ASSETS AND LIABILITIES 4 200 000 Additional informationA. The sales budget for 2023 is as follows:First Quarter Second Quarter Third Quarter Fourth QuarterR2 625 000 R2 750 000 R2 875 000 R2 750 000 B. 90% of sales is collected in the quarter of the sale and 10% in the quarter…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

Using the financial statements in the attached workbook (Walmart Macys Financials.xlsx), calculate ROA, Profit Margin, Asset Turn-over, and Cash-to-cash cycle for Walmart and Macy's as of 2013. For returns when you calculate ROA, use a corporate tax rate of 21%.