d. Compute ROA. e. Compute profit margin (PM). f. Compute asset turnover (AT).
Q: 2. Complete the below table to calculate income statement data in common-size percents. (Round your…
A: Common size financial statement refers to an analysis statement of the record of a company in a…
Q: A classified income statement showed net sales of $630,000, cost of goods sold of $342,000, and…
A: Step 1: Introduction to Profit:Profit is an important metric of business operation, which can be…
Q: Shown below are selected financial data for Company a and Company B at the end of the current…
A: Company A Current assets =Cash +Account receivable +inventory Current assets…
Q: Refer to the following selected financial information from McCormik, LLC. Compute the company's…
A: The current ratio is one of the liquidity ratios that help to assess the efficiency of an…
Q: Portions of the financial statements for Peach Computer are provided below. PEACH COMPUTER Income…
A: Cash paid to suppliersCost of good sold$1,070,000Increase in inventory 21,000Increase in…
Q: TB MC Qu. 17-138 (Algo) Refer to the following selected financial... Refer to the following selected…
A: Current Liabilities:AP = 109,900 Current Assets:Cash = 38,200Short-term investments = 97,000AR, net…
Q: P18-5 Selected financial data of Target and Wal-Mart for a recent year are presented here (in…
A: Accounting Ratios are the financial tools used to interpret the financial statements of…
Q: The following information is available from the accounting records of Spenser Co. for the year ended…
A: Loss from discontinuing operations is to be taken is = $17600 Net of tax savings of $5500 is…
Q: Selected comparative statement data for Oriole Company are presented below. All balance sheet data…
A: Ratio analysis helps to analyze the financial statements of the company. The management can take…
Q: Prepare the operating activities section of the statement of cash flows using the indirect method.…
A: Introduction:- The cash flow statement is classified into three types as follows under:- (i) Cash…
Q: Complete the common-size income statement below: Common-Size Income Statement 2016 Revenues $ 29,970…
A: Formula: Formula: Revenues % = ( Revenues value / Revenues value ) x 100
Q: reate a common-sized income statement given the following income statement data for the General…
A: In a common size income statement each line item is expressed as a percentage of revenue or sales.…
Q: Selected current year-end financial statements of Cabot Corporation follow. (All sales were on…
A: The profit margin ratio, also known as the net profit margin, is a financial metric used to measure…
Q: Financial Information for Powell Panther Corporation is shown below: Powell Panther Corporation:…
A: The decision of issuance of dividend can be influenced by various factors like net income, retained…
Q: Complete the balance sheet and sales information using the following financial data:…
A: Computation:
Q: Window World Company's income statement for the year ending December 31, 2024 included the following…
A: Changes in salaries payable are adjusted with salaries expenses during the year to compute the…
Q: What is average payment period using balance sheet below? BALANCE SHEET INCOME STATEMENT ($ in…
A: Average payment period is ratio of Average account payable and daily credit purchase.
Q: Current assets Cash Accounts receivable Inventory Total Assets Sales Cost of goods sold Depreciation…
A: Net income$35,207.00Sales$186,970.00Total assets in 2015$70,215.00Total assets in…
Q: The statement of income for Pembina Ltd. is shown below: PEMBINA LTD. Statement of Income Year Ended…
A: Horizontal Analysis: It implies a technique of analyzing company's financial statements and helps…
Q: Excerpts from Candle Corporation's most recent balance sheet (in thousands of dollars) Year 2 Year 1…
A: The ratio analysis helps to analyze the financial statements on the basis of the different elements…
Q: Portions of the financial statements for Horizon Telecom are provided below. HORIZON TELECOM…
A: Cash flows from operating activities: It is a section of Statement of cash flow that explains the…
Q: Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net…
A: Profit Margin :— It is calculated by dividing net income by net sales. Total asset turnover :— It is…
Q: Selected current year-end financial statements of Cabot Corporation follow. (All sales were on…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Mega Screens, Inc., reports net sales of $2,650,000, cost of goods sold of $1,450,000, and income…
A: Lets understand the basics.For calculating requirements we need to use below formula.Cash received…
Q: MOSS COMPANY Income Statement For Year Ended December 31, 2021 Sales Cost of goods sold Gross profit…
A: CASH FLOW STATEMENT The cash flow statement is prepared to record the cash flow from various…
Q: Tournesol Inc. Income Statement Year Ended December 15, 2018 Sale Cost of goods sold Rent Expense…
A: Total return on assets (TROA) is a financial ratio that compares a company's profitability to its…
Q: Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $…
A: Return on capital is calculated by dividing the earnings before interest and taxes with the capital…
Q: Selected comparative financial statements of Haroun Company follow. ($ thousands) Sales Cost of…
A: A financial statement that compares a company's financial performance across two or more periods is…
Q: Exercise 13-10 (Algo) Part 3 [Alternate Version] (3-a) Compute return on total assets for the…
A: Return on total assets ratio indicates company ability to generate earning using the average…
Q: Presented below are selected balance sheet information and the income statement for Burch Company.…
A: The objective of this question is to calculate the net cash flows from operating activities for…
Q: MOSS COMPANY Income Statement For Year Ended December 31, 2021 Sales Cost of goods sold Gross profit…
A: The cash flow statement is prepared to record the cash flow from various activities during the…
Q: es MOSS COMPANY Income Statement For Year Ended December 31, 2021 Sales Cost of goods sold Gross…
A: The cash flow statement is prepared to record the cash flow from various activities during the…
Q: Selected current year-end financial statements of Cabot Corporation follow. (All sales were on…
A: The ratio analysis helps to analyse the financial statements on the basis of the different elements…
Q: efer to the following selected financial information from a company. Compute the company’s return on…
A: Return on total assets is the efficiency of total assets employed in the business to generate net…
Q: What is the financial performance summary for this balance sheet? BALANCE SHEET INCOME STATEMENT…
A: A) ACTIVITY RATIOS (Note : All figs are $ in millions) a) Inventory turnover Cost Of Goods Sold =…
Q: The Tarboro Corporation data for the current year and prior year is as follows: Current year $75,600…
A: Under horizontal analysis of financial statements, analysis is made over the time . Under this…
Q: CONCORD, INC. Income Statement For the Year Ended December 31, 2026 Net Sales $145 Cost of Goods…
A: The gross profit is calculated as difference between sales and cost of goods sold. The gross profit…
Following is selected financial information from General Mills Inc. for its fiscal year ended May 27, 2018 ($ millions).
Cost of goods sold (COGS) | $11,344.2 | Cash from operating activities | $3,125.1 |
Cash from investing activities | (9,553.9) | Noncash assets, end of year | 33,247.5 |
Cash, end of year | 438.9 | Cash from financing activities* | 6,025.0 |
Income tax expense | 63.0 | Total assets, beginning of year | 23,993.9 |
Revenue | 17,314.4 | Total liabilities, end of year** | 26,544.8 |
Total expenses, other than COGS | 3,527.9 | 7,141.6 | |
and income tax |
* Cash from financing activities includes the effects of foreign exchange rate fluctuations.
** Total liabilities includes redeemable interest.
d. Compute ROA.
e. Compute profit margin (PM).
f. Compute asset turnover (AT).
Notes:
Round ROA and PM to one decimal place (ex: 10.5%)
Round Asset turnover to two decimal places (0.33)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 17.85 Net income $ 67.15 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity Current liabilities $ 200 $ 163 Long-term debt 114 127 Shareholders’ equity 331 262 Total liabilities and shareholders’ equity $ 645 $ 552 The company’s cost of capital is 8.5%. Required: What is the company’s return on capital? (Use start-of-year rather than average capital.) Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. P.S- Answer is not 26.48%Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 450,600 298,350 152,250 99,300 4,500 Cost of goods sold Gross profit Operating expenses Interest expense. Income before taxes Income tax expense Net income $ 10,000 Accounts payable Accrued wages payable 9,200 31,400 Income taxes payable 30,150 Long-term note payable, secured by mortgage on plant assets 3,050 Common stock 152,300 Retained earnings $ 236,100 Total liabilities and equity CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity 48,450 19,518 $ 28,932 $ 17,500 3,800 4,700 69,400 88,000 52,700 $ 236,100 Required: Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total…Condensed financial data are presented below for the Tulsa Corporation: Accounts receivable Inventory C. d. Total current assets Total assets Current liabilities Long-term liabilities Sales Cost of goods sold Interest expense Net income Tax rate 2021 $277,500 310,000 675,000 800,000 700,000 250,000 200,000 77,500 75,000 1,640,000 985,000 10,000 130,000 25% 2020 $230,000 250,000 565,000 The profit margin used to calculate return on assets for 2021 is (rounded): a. b. 8.9% 16.3% 17.2% 18.3%
- Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 31,800 89,500 112,500. 10,700 278,500 $ 523,000 Interest expense Income tax expense Total costs and expenses Net income. Earnings per share $ 129,900 98,500 163,500 131,100 $ 523,000 Current Year $ 411,225 209,550 1 Year Ago $ 35,625 62,500 82,500 9,375 255,000 $ 445,000 The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: 4 12,100 9,525 $ 75,250 101,500 163,500 104,750 $ 445,000 $ 673,500 2 Years Ago 642,400 $ 31,100 $ 1.90 $ 37,800 50,200 54,000 5,000 230,500 $ 377,500 $51,250 83,500 163,500 79,250 $ 377,500 1 Year Ago $ 345,500…CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 448,600 297,150 151,450 98,600 5,000 47,850 19,276 $ 28,574 Cost of goods sold Gross profit Operating expenses Interest expense Profit before taxes Income tax expense Net profit Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Property, plant and equipment, net Total assets Req 1 and 2 Req 3 Req 4 CABOT CORPORATION Balance Sheet December 31 Liabilities and Equity Req 5 8,000 Accounts payable 8,800 Accrued wages payable 32,400 Income taxes payable 2,750 Share capital 150,300 Retained earnings $ 238,400 Total liabilities and equity Complete this question by entering your answers in the tabs below. Compute the current ratio and acid-test ratio. 36,150 Long-term note payable, secured by mortgage on property, plant and equipment Required: Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days'…Use the appropriate information from the data provided below to calculate operating income for the year ended December 31, 2014. Cost of Goods Sold 117,000 Inventory 125,000 General & Administrative Expenses 48,000 Net Cash Provided from Financing Activities 48,000 Dividends Paid 16,000 Net Sales 278,000 Selling & Marketing Expense 65,000 Interest Expense 23,000 Income Tax Expense 7,500
- Selected balance sheet information and the income statement for Pioneer Industries for the current year are presented below. Selected Balance Sheet Accounts Accounts Receivable Prior Year Current Year $ 24,000 $ 16,000 Inventory 32,000 35,200 Prepaid Rent 1,600 0 Accounts Payable 17,600 22,400 Salaries and Wages 3,200 4,800 Payable 04:23 Depreciation Expense Salaries Expense Income Statement Sales Revenue $ 480,000 Expenses: Cost of Goods Sold 288,000 32,000 48,000 19,200 19,200 17,600 16,000 $ 40,000 Rent Expense Insurance Expense Interest Expense Utilities Expense Net Income Required: Prepare the cash flows from operating activities section of the statement of cash flows using the indirect method. (Enter any deductions and cash outflows as a negative value.) Pioneer Industries Cash Flows from Operating Activities Adjustments to reconcile net income to net cash provided by operating activities: Changes in current assets and current liabilities: $ 0Below is financial information ($ values are in millions) in a model. Net income during the year for this company would be: Revenues SG&A Expenses Interest Expense Select one: OA. $4.5 million OB. $3.6 million O C. $16.6 million OD. $0.9 million $67.30 $4.70 $8.10 Cost of Goods Sold Depreciation Tax Rate $43.20 $6.80 20%Sales MOSS COMPANY Income Statement For Year Ended December 31, 2021 Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Income before taxes Income taxes expense Net income $ 549,000 357,600 191,400 128,500 49,000 13,900 8,100 $ 5,800 MOSS COMPANY Selected Balance Sheet Information At December 31 2021 2020 Current assets Cash $ 91,150 $ 33,300 Accounts receivable 31,500 45,000 66,500 55,400 Current liabilities 43,400 32,200 2,700 3,500 Inventory Accounts payable Income taxes payable Use the information above to calculate cash flows from operating activities using the indirect method. Note: Amounts to be deducted should be indicated by a minus sign. Cash flows from operating activities: Adjustments to reconcile net income to net cash provided by operating activities Income statement items not affecting cash Changes in current operating assets and liabilities $ 49,000 49,000 $ 49,000
- saritabenNet sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Target Corporation Income Statement Data for Year $65,357 45,583 15,101 707 (94) 1,384 $ 2,488 $18,424 26,109 Balance Sheet Data (End of Year) $44,533 $11,327 17,859 15,347 Walmart Inc. $44,533 $408,214 304,657 79,607 10,512 2,065 (411) 7,139 $ 14,335 $48,331 122,375 $170,706 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances $44,106 13,712 $163,429 65,682 55,390Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes. Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Sin Comparative Income Statements For Years Ended December 31 2021 $ 420,027 252,856 167,171 59,644 37,802 97,446 69,725 12,969 $ 56,756 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity Assets Current assets Long-term investments Plant assets, net. Total assets Liabilities and Equity Current liabaties Common stock Other paid-in capital Retained earnings Total liabilities and equity 2020 $ 321,775 202,718 KORBIN COMPANY Comparative Balance Sheets December 31 2021 119,057 44,405 28,316 72,721 46,336 9,499 $ 36,837 $ 55,286 0 102,674 $ 157,960 2020 3. Complete the below table to calculate the balance sheet data in trend percents with 2019 as answers to 2 decimal places.) 111.77 % 0.00 $ 37,003 700…