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 & MANAGERIAL ACCOUNTING (ACCES
- 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_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_forwardAssume 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_forward
- Please answer both a and b thxarrow_forwardThe following data are taken from the financial statements of Coronado Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 (a1) Compute for each year the accounts receivable turnover. At the end of 2020, accounts receivable (net) was $465,000. (Round answers to 1 decimal place, e.g. 1.6.) Accounts receivable turnover eTextbook and Media Save for Later (a2) 2022 2021 $525,000 $500,000 4,100,000 3,184,500 Average collection period 2022 times 2022 days 2021 2021 times Compute for each year the average collection period. At the end of 2020, accounts receivable (net) was $465,000. (Use 365 days for calculation. Round answers to 1 decimal place, e.g. 1.6.) Assistance Used Attempts: unlimited days Submit Answerarrow_forwardThe following data are taken from the financial statements of Sheffield Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 (a1) X Your answer is incorrect. 2022 $555,000 3,997,500 2021 $470,000 3,122,250 Compute for each year the accounts receivable turnover. At the end of 2020, accounts receivable (net) was $435,000. (Round answers to 1 decimal place, e.g. 1.6.)arrow_forward
- Please help me with show all calculation thankuarrow_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_forwardChoose the correct answer and pls provide the formula A Company’s net accounts receivable were P250,000 as of December 31, 2018, and P300,000 as of December 31, 2019. Net cash sales for 2019 were P100,000. The accounts receivable turnover for 2019 was 5.0. What were the Company’s total net sales for 2019? *a. P1,175,000.00b. P1,275,000.00c. P1,375,000.00d. P1,475,000.00e. P1,575,000.00arrow_forward
- Salus Mea Inc., is developing its annual financial statements at December 31, current year. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized as follows: Balance sheet at December 31 Cash Accounts receivable Merchandise inventory Property and equipment Less: Accumulated depreciation Accounts payable Wages payable Note payable, long-term Common stock and additional paid-in capital Retained earnings Income statement for current year Sales Cost of goods sold Depreciation expense Other expenses Net income Additional Data: 1. Bought equipment for cash, $48,900. 2. Paid $14,700 on the long-term note payable. Current Year $ 73,250 15,250 23,450 209,250 (57.450) $263,750 $ 16,500 2,000 56,300 103,950 $5,000 $263.750 $205,000 (123,500) (11,700) (4),000) $26.800 3. Issued new shares of stock for $38,050 cash. 4. Dividends of S650 were declared and paid. 5. Other expenses all relate to wages. 6.…arrow_forwardPritchett Company reported the following year-end data: Cash Short-term investments Accounts receivable (current) Inventory Prepaid (current) assets Total current 1iabilities $ 20, 100 8, 500 13,400 24, 000 6,800 28, 000 Compute the (a) current ratio and ( acid-test ratio. Complete this question by entering your answers in the tabs below. Currlat Ratio Acid Test Ratio Compute the current ratio. Current Ratio Current Ratio Numerator: Denominator: Current assets Current liabilities Current ratio 72.800 %24 28,000 2.6 to 1 %3 Acid Test Ratio>arrow_forwardPlease do not reject.Question is complete.Please answer both parts thxarrow_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