FINANCIAL+MANAG.ACCT.
9th Edition
ISBN: 9781260728774
Author: Wild
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 3.1AA
a.
To determine
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.
To determine
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.
To determine
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.
To determine
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Following is selected financial information from General Mills, Inc., for its fiscal year ended May 31,
2020 ($ millions).
Cash and cash equivalents, end of year.
Net cash from operations..
Net sales.
Stockholders' equity, end of year
Cost of goods sold.
Net cash from financing.
Total liabilities, end of year.
Other expenses, including income taxes
Noncash assets, end of year.
Net cash from investing
Net income...
Effect of exchange rate changes on cash
Cash and cash equivalents, beginning of year.
pg. 1-35
a.
....
....
$ 1,677.8
3,676.2
17,626.6
8,894.1
11,496.7
(1,941.5)
21,912.6
3,919.1
29,128.9
(486.2)
2,210.8
(20.7)
450.0
?
REQUIRED
Prepare an income statement, balance sheet, and statement of cash flows for General Mills, Inc.
ces
Given the following information, complete the balance sheet shown next.
Collection period
Days' sales in cash
Current ratio
Inventory turnover
Liabilities to assets
Payables period
Assets
Current assets:
Cash
Accounts receivable
Inventory
Total current assets
Net fixed assets
Total assets
(All sales are on credit. All calculations assume a 365-day year. The payables period is based on cost of
goods sold.)
Note: Round your answers to the nearest whole dollar.
Liabilities and shareholders' equity
Current liabilities:
71 days
33
days
2.2
times
Accounts payable
Short-term debt
Total current liabilities
Long-term debt
Shareholders' equity
Total liabilities and equity
5
65%
35 days
$
$
1,300,000
2,000,000
7,000,000
Calculate 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)
Chapter 6 Solutions
FINANCIAL+MANAG.ACCT.
Ch. 6 - Prob. 1QSCh. 6 - Prob. 2QSCh. 6 - Prob. 3QSCh. 6 - Prob. 4QSCh. 6 - Prob. 5QSCh. 6 - Prob. 6QSCh. 6 - Prob. 7QSCh. 6 - Prob. 8QSCh. 6 - Prob. 9QSCh. 6 - Prob. 10QS
Ch. 6 - Prob. 11QSCh. 6 - Prob. 12QSCh. 6 - Prob. 13QSCh. 6 - Prob. 14QSCh. 6 - Prob. 15QSCh. 6 - Prob. 16QSCh. 6 - Prob. 1ECh. 6 - Prob. 2ECh. 6 - Prob. 3ECh. 6 - Prob. 4ECh. 6 - Prob. 5ECh. 6 - Prob. 6ECh. 6 - Prob. 7ECh. 6 - Prob. 8ECh. 6 - Prob. 9ECh. 6 - Prob. 10ECh. 6 - Prob. 11ECh. 6 - Prob. 12ECh. 6 - Prob. 13ECh. 6 - Prob. 14ECh. 6 - Prob. 15ECh. 6 - Prob. 16ECh. 6 - Prob. 17ECh. 6 - Prob. 1PSACh. 6 - Prob. 2PSACh. 6 - Prob. 3PSACh. 6 - Prob. 4PSACh. 6 - Prob. 5PSACh. 6 - Prob. 1PSBCh. 6 - Prob. 2PSBCh. 6 - Prob. 3PSBCh. 6 - Prob. 4PSBCh. 6 - Prob. 5PSBCh. 6 - Prob. 6SPCh. 6 - Prob. 1GLPCh. 6 - Prob. 1.1AACh. 6 - Prob. 1.2AACh. 6 - Prob. 1.3AACh. 6 - Prob. 1.4AACh. 6 - Prob. 1.5AACh. 6 - Prob. 2.1AACh. 6 - Prob. 2.2AACh. 6 - Prob. 3.1AACh. 6 - Prob. 3.2AACh. 6 - Prob. 3.3AACh. 6 - Prob. 3.4AACh. 6 - Prob. 1DQCh. 6 - Prob. 2DQCh. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Prob. 7DQCh. 6 - Prob. 8DQCh. 6 - Prob. 9DQCh. 6 - Prob. 10DQCh. 6 - Prob. 11DQCh. 6 - Prob. 12DQCh. 6 - Prob. 13DQCh. 6 - Prob. 14DQCh. 6 - Harriet Knox, Ralph Patton, and Marcia Diamond...Ch. 6 - Prob. 2BTNCh. 6 - Prob. 3BTNCh. 6 - Prob. 4BTN
Knowledge Booster
Similar questions
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forwardThe 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_forwardFormulating Financial Statements from Raw Data Following is selected financial information from Greenwood Industries, for its fiscal year ended ($ millions). Cash and cash equivalents, end of year Net cash from operations Net sales Stockholders' equity, end of year Cost of goods sold Net cash from financing Total liabilities, end of year Other expenses, including income taxes Noncash assets, end of year Net cash from investing Net income Effect of exchange rate changes on cash Cash and cash equivalents, beginning of year Net income Cost of goods sold REQUIRED a. Prepare an income statement, balance sheet, and statement of cash flows for Greenwood Industries. Note: Do not use negative signs with your answers in the Income Statement. Net cash flows from operations $2,516.7 5,514.3 26,439.9 14,411.2 Greenwood Industries Income Statement ($ millions) # 17,245.1 (2,912.3) 31,798.9 5,878.7 43,693.4 (729.3) 3,316.2 (31.1) 675.0 # # ♦ + ♦ + $ $ $ 0 0 0 0 0 Greenwood Industries Balance Sheet (5…arrow_forward
- Required: 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_forwardAfter 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_forward
- After 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_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_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
- A 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_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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial 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
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub