a.
Vertical Analysis:
In vertical analysis, every line item is represented as a percentage of a base amount which can be either total assets, total liabilities, total equities, etc.
Requirement 1
To compute:
Cash as a percentage of total current assets, total current liabilities, total
b.
Horizontal Analysis:
In horizontal analysis, a single line item is represented and compared as a percentage change from one base year to the subsequent years.
Requirement 2
To compute:
Percentage change between the beginning and ending cash balances for the current year.
c.
Days’ sales uncollected:
This ratio defines how fast a company converts its receivable into known amounts of cash. The lesser the ratio is, the better it is for the company as it will prove that the company employs an efficient system of cash collection from customers.
Requirement 3
To compute:
The days’ sales uncollected for both the current and prior year.
d.
Changes in Days’ sales uncollected:
The changes in the ratio of days’ sales uncollected will greatly impact the liquidity problem of the entity. If it is reduced, the company is considered to be efficiently managing its cash collection mechanism or in case, it is increased, the otherwise will follow.
Requirement 4
Whether S’s receivables collection is showing a favorable or unfavorable change.
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
GEN. COMBINED FIN.+MAN.ACCT LCPO
- The following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forwardCalculate the following financial ratios for Phone Corporation: (Use 365 daysin a year. Do not round intermediate calculations. Round your finalanswers to 2 decimal places.)1. Return on Assets (use average balance sheet figures)2. Return on capital (use average balance sheet figures) %3. Days in inventory (use start of year balance sheet figures) %4. Inventory turnover (use start of year balance sheet figures5. Average collection period (use start of year balance sheet figures)6. Operating profit margin %7. Long term debt ratio (use end of year balance sheet figures)8. Total Debt ratio (use end of year balance sheet figures)arrow_forwardRequired: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 % % % % % % Year 2 % % % % % % Year 3 % % % % % % Year 4 % % % % % Year 5 % % % % %arrow_forward
- After reviewing the information, calculate the following ratios for Nestlé for 2021:1) Inventory turnover2) Profit margin3) Return on assets4) Free cash flowRound all answers to two decimal places.arrow_forwardComparative balance sheets report average total assets for the year of $2,450,000 and average totalequity of $1,825,000 (dollar amounts in thousands, except earnings per share).a. Prepare an income statement for the year in a multiple-step format.b. Compute the ( 1 ) gross profit rate, ( 2 ) net income as a percentage of net sales, ( 3 ) return onassets, and ( 4 ) return on equity for the year. (Round computations to the nearest one-tenth of1 percent.)c. Explain why interest revenue is not included in the company’s gross profit computationarrow_forwardAfter reviewing the information, calculate the following ratios for 2021. 1) Inventory turnover2) Profit margin3) Return on assets4) Free cash flow Round all answers to two decimal places.arrow_forward
- INSTRUCTIONS Determine the following measures for both 20Y8 and 20Y9, rounding percentages and ratios other than per-share amounts to one decimal place. Briefly explain how or why management would use this information and comment on the trend from 20Y8 and 20Y9. Working capital Current ratio Quick ratio Accounts receivable turnover Number of days’ sales in receivables Inventory turnover Number of days’ sales in inventory Ratio of fixed assets to long-term liabilities Ratio of liabilities to stockholders’ equity Times interest earned Asset turnover Return on total assets Return on stockholders’ equity Return on common stockholders’ equity Earnings per share on common stock Price-earnings ratio Dividends per share Dividend yieldarrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Decompose the return on equity for the FY 2021…arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the NLF, NSF and the liquidity ratio…arrow_forward
- using the total for income and expense, what is the income statement equation for the most recent year? what amount of net sale is reported for each year? what is the % change in sales for each year and the trend in revenues? Operating activities Net income $6,177.4 $ 7,545.2 $ 4,730.5 Adjustments to reconcile to cash provided by operations Charges and credits: Depreciation and amortization 1,870.6 1,868.1 1,751.4 Deferred income taxes (345.7) (428.3) 6.4 Share-based compensation 166.7 139.2 92.4 Net (gain) loss on sale of restaurant and other businesses Other 732.7 (97.8) (28.2) (570.4) (339.1) (75.2) Changes in working capital items: Accounts receivable (264.1) 309.9 (6.8) Inventories, prepaid expenses and other current assets 5.6 (62.2) (68.6) Accounts payable 31.3 225.0 (137.5) Income taxes (546.7) (302.5) (43.6) Other accrued liabilities 129.3 284.0 44.4 Cash provided by operations 7,386.7 9,141.5 6,265.2 Investing activities Capital expenditures (1,899.2) (2,040.0) (1,640.8)…arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the managerial balance sheet for the FY 2021.arrow_forwardSales Cost of goods sold Net income Cash flow from operations Cash Marketable securities Accounts receivable Inventories Total current assets Accounts payable Accrued liabilities Total current liabilities 275,161 253, 201 (159,054) (59,225) 341,580 342, 258 21,495 6,525 711,858 29, 308 44,806 74,114 a. Calculate the current and quick ratio at the end of each year. Note: Round your answers to 1 decimal place. b. Assuming a 365-day year for all calculations, compute the following: 1. The collection period each year based on sales. a. Current ratio a. Quick ratio b1. Collection period b2. Inventory turnover (X) b2. Payables period (days) b3. Days' sales in cash b4. Gross margin b4. Profit margin 462,913 345, 284 (403,909) (20,933) 269,372 37,300 35,798 72,506 414,976 23,158 125, 251 148,409 2. The inventory turnover and the payables period each year based on cost of goods sold. 3. The days' sales in cash each year. 4. The gross margin and profit margin each year. Note: Round your answers…arrow_forward
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub