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
FINANCIAL AND MANAGERIAL ACCOUNTING
- 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_forwardDo npt give image formatarrow_forwardRefer to the 10-K for Abercrombie & Fitch. Required: 1. What does the company report for the following accounts for the most current fiscal year: Enter your answer in thousands. a. Cash b. Short-term investments (or marketable securities) c. Accounts receivable d. Inventory e. Other current assets f. Accounts payable g. Other current liabilities h. Cash flow from operations A A AA A A 好 2. The company projects the following to occur in the next fiscal year: • Accounts payable will decrease by 25%. • Other current liabilities are expected to increase by 33%. • Cash flow from operations is expected to decrease by 32%. Assume all other items remain unchanged from the prior year. Provide the next year's forecasted balances for the following accounts and cash flow from operations.arrow_forward
- The following data are taken from the financial statements of Colby Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 Accounts Receivable turnover Average collection period (b) 2022 $550,000 2022 2021 4,300,000 4,000,000 7.9 times $540,000 2021 7.5 times 46.2 days 48.7 days What conclusions about the management of accounts receivable can be drawn from the accounts receivable turnover and the average collections period.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_forwardAarrow_forward
- Comparative 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_forwardN1. Account Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2021. (Use sales when computing the inventory turnover and use total stockholders' equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.)arrow_forwardINSTRUCTIONS 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_forward
- Assume that a company had an accounts payable balance of $50 million at the end of the prior year and a balance in accounts payable of $57 million at the end of the current year. Inventory at the end of the current year is $130 million and Cost of Goods Sold for the current year is $544 million. What is accounts payable turnover for the current year? Round your answer to the nearest whole number (i.e., no decimal places).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_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
- 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