Given below are the comparative balance sheets and an income statement for the excellent corporation.compute the following:1: Average accounts receivable turnover2: Average inventory turnover3: earnings per share of capital stock Excellent CorporationIncome Statement for the yearended 2018Dec. 31Jan. 1Cash$ 34,000Accounts receivable 94,000$ 34,000$524,000SalesInventoryEquipment (net)(328,000)$ 196,00078,000Cost of goods sold68,000Gross profit on salesOperating expensesOperating income74,000(118,700)$77,300114,000132,000Total Assets$310,000.00 $318,000.00Accounts payable(28,750)Interest expense54,00060,000and income taxesDividends payable 20,000$48,55012,000Net incomeLong-term notepayable32,00032,000Capital stock, $10par (14,000 shs)Retained earnings140,000140,00064,00074,000Total Liabilities+$310,000$318,000Equity(Show calculations below or on back

1 Average accounts receivable turnover Net Credit sales/Average accounts receivable 2 Average…

Given below are the comparative balance sheets and an income statement for the excellent corporation. compute the following: 1: Average accounts receivable turnover 2: Average inventory turnover 3: earnings per share of capital stock

Given below are the comparative balance sheets and an income statement for the excellent corporation. compute the following: 1: Average accounts receivable turnover 2: Average inventory turnover 3: earnings per share of capital stock

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: which of the following ratios indicate the proportion of earnings paid as dividends .a dividends…

A: dividend pay out formula: dividend payout =dividendnet income

Q: Briefly describe the ratios that can be used to evaluate a company’s profitability.

Q: how do I calculate projected financial statement for income, balance, and cash flow for a company…

A: Projected Financial Statements: Income Statement, Balance Sheet, and Cash Flow StatementCreating…

Q: Anal

A: Chiz Trading Company Comparative Statement of Financial Position For the Years Ended…

Q: Autry Corporation's balance sheet and income statement appear below: Comparative Balance Sheet…

A: The various sections of cash flow statement are classified as operating, investing and financing…

Q: For the highlighted in yellow portions what are the Excel formulaes used to calculate ratios?

A: 1. Current ratio: The current ratio estimates a firm's capacity of paying short-term or current…

Q: formula for the following: 1. price earnings ratio 2. dividend yield ratio 3. dividend payout ratio…

A: Note: Since you have posted a question with multiple sub-parts, we will solve the first three…

Q: ne debt to O the F

A: The debt to asset ratio is a leverage ratio that measures the number of total assets that are…

Q: How to Compute the following ratios i. Gross Profit % ii. Operating profit % iii. Net Profit % iv.…

A: There are different types of ratios used to measure the financial stability of the company, some of…

Q: Assume the following relationships for the Caulder Corp.: Sales/Total assets Return on assets (ROA)…

A: The overall indication of the yield percentage of the company from all the activities is denoted by…

Q: What is the Days Payables Outstanding? Use the attached financial data to calculate the ratios.…

A: DAYS PAYABLE OUTSTANDING Days Payable Outstanding is the ratio between Average Accounts Payable…

Q: Select the Income Statements and Balance Sheets of Aramco Saudi from the calculate the following…

A: solution- Income…

Q: Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative…

A: When each line item on an income statement is expressed as a percentage of revenue or sales, the…

Q: Below are financial ratios for XYZ Corporation and comparative ratios for XYZ Corporations industry.…

A: The company uses ratios to evaluate the performance of the entity. The different type of ratios…

Q: Match each computation to one of the profitability measures in the table. Profitability Measures…

A: Assets turnover ratio = net sales /average total Assets Return on total Assets = net income/average…

Q: Asset utilization ratios:

A: Asset Turnover ratios are: Fixed Asset Turnover Ratio= SalesFixed Assets Total Asset Turnover Ratio=…

Q: The process of communicating information that is relevant to investors, creditors, and others in…

A: 1) The Process of Communicating Information that is relevant to investors , creditors and other…

Q: Describe” the Ch9 - return on assets ratio. Explain the factors used in the formula, how the ratio…

A: Return on assets ratio is a profitability ratio that explains how much the company is efficient in…

Q: 1. Provide the equation for each ratio listed. 2. What does each ratio listed tell you about the…

A: Introduction:- Ratio analysis used identify the business performance of the company. It is used to…

Q: Common measures of a company's profitability include price-earnings ratio earnings per share…

A: The profitability ratios are used to measure the business's ability for generating profit from its…

Q: Industry-Specific Ratios: Provide an explanation for each of the following Industry-Specific…

A: Industry specific ratios are defined as the ratios, which are used only in the specific industry.…

Q: Efficiency Asset Turnover TTM 0.73 0.6 Inventory Turnover TTM 14.45 13.6 Revenue/Employee TTM 14.01M…

A: Asset management is a systematic process of acquiring, operating, maintaining and disposing assets…

Q: of the following is a technique for reviewing relationships on an income statement by assigning net…

A: Solution: Technique for reviewing relationships on an income statement by assigning net sales as…

Q: Match the ratio to what it measures F. Current ratio Acid test ratio Working capital Accounts…

A: The objective of the question is to match the financial ratios with their respective definitions or…

Q: In terms of assessing company health,profitability and ability to raise financo

A: Ratio Analysis -A ratio analysis compares line items in a company's financial accounts. Ratio…

Q: What are financial ratios?

A: Financial ratios are the mathematical relationships between different components of the balance…

Q: a. Profitability Ratios Profit margin % Return on Assets % Return on Equity % b. Asset…

A: First let us list the formula used to compute the values. Net profit margin = Net income/…

Q: Required: Compute the following for Year 2: Earnings per share of common stock…

A: Ratio Analysis - The ratio is the technique used by the prospective investor or an individual or…

Q: Using the ratios below, summarize the financial performance of the company. LIQUIDITY RATIOS…

A: LIQUIDITY RATIOS Current Ratio (times) 1.75 Quick Ratio (times) 0.52 Average…

Q: Refer to exhibits 2.1 and 2.2 to use the data to evaluate current ratio, quick ratio, debt ratio,…

A: The question is related to Ratio Analysis. The details are given regarding the same. Since you have…

Q: Balance sheet ($ in millions) Income statement (S in millions) Assets 2010 Liabilities and 2010…

A: Note: I am supposed to provide the solution of first three sub parts. Please repost the remaining…

Q: Cost of goods sold Current ratio Average inventory Net income Days in inventory Net sales Cash…

A: Ratio Analysis: Ratio analysis is a quantitative technique for acquiring understanding into an…

Q: Which financial ratio does the DuPont equation help to explain? ROA (return on assets)…

A: The DuPont equation primarily helps to explain the Return on Equity (ROE). The equation breaks down…

Q: Questions: 1. Make a comparison for each company based on computed ratio. 2. What is your…

A: The performance of the two companies can be evaluated using the ratio. The ratio provides a view of…

Q: examination of the trend of the same items, groups of items and calculated things in two or more…

A: A comparative balance sheet presents side-by-side information about an entity's assets, liabilities,…

Q: What recommendations can be made to a company based on a ratio analysis? (current ratio, cash ratio,…

A: Ratio Analysis is a technique to present the financial position of the company in the simplest,…

Q: The ratio of liabilities to stockholders' equity measures how much of the company is financed by…

A: Since we answer up to 3 sub-parts, we'll answer the first 3. Please resubmit the question and…

Q: Presented below are summary financial data from Pebble Company’s annual report: Assume that the…

A: The question refers to five financial ratios. So first let us just have a brief on these financial…

Q: information and want to calculate the debt-to-equity ratio for the firm. Return on Equity: 23.87%…

A: the ratio analysis is performed by the company in order to know the financial health of the company…

Q: Which of the following statements correctly describe PE ratio? a. Price of ordinary share on the…

A: Financial Ratio analysis is the formula used to analyse and evaluate the relationship between two or…

Q: What are some of the ratios used in evaluating the Liquidity of a company from it's annual financial…

A: there are four ratios used in evaluating the liquidity of a company 1)current ratio 2) quick ratio…

Q: Financial Ratios Fully explain the kind of information the following ratios provided about a firm.…

A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…

Q: find one financial report for a company listed in bursa malaysia and find CURRENT RATIO,QUICK RATIO…

A: Introduction:The UMW Group is a leading industrial conglomerate and ranks among the foremost…

Q: Trend Analysis incorporates this into the calculations: income ratio debt ratio. Analysis year…

A: Trend analysis is the analysis of percentage change between two or more period. It shows the trend…

Q: Use the information provided from Sapphire Ltd calculate and comment on the following ratios:1.…

A: Based on the financial data provided for Sapphire Ltd for the year 2022, we can analyze and…

Q: INCOME STAEMENT Particulars Amount ($) Sales 200000 Cost of Goods Sold -95000 Gross Profit 105000…

Q: use the following information to make a Common size income statement

A: The income statement is prepared at the end of the accounting year to report profit or loss for the…

Q: Describe two Liquidity Ratios and explain how they are used to measure a company's performance and…

A: Ratio analysis is one of the technique of management accounting analysis. Liquidity ratios is one of…

Question

Excellent Corporation
Income Statement for the year
ended 2018
Dec. 31
Jan. 1
Cash
$ 34,000
Accounts receivable 94,000
$ 34,000
$524,000
Sales
Inventory
Equipment (net)
(328,000)
$ 196,000
78,000
Cost of goods sold
68,000
Gross profit on sales
Operating expenses
Operating income
74,000
(118,700)
$77,300
114,000
132,000
Total Assets
$310,000.00 $318,000.00
Accounts payable
(28,750)
Interest expense
54,000
60,000
and income taxes
Dividends payable 20,000
$48,550
12,000
Net income
Long-term note
payable
32,000
32,000
Capital stock, $10
par (14,000 shs)
Retained earnings
140,000
140,000
64,000
74,000
Total Liabilities+
$310,000
$318,000
Equity
(Show calculations below or on back

Definition Definition Money that the business will be receiving from its clients who have utilized the credit provided to buy its goods and services. The credit period typically lasts for a short term, lasting from a few days, a few months, to a year.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

FORMULA

VIEW

ANSWER

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Compare, and contrast the ratio of toyota and tesla
Assume the following relationships for the Brown Corporation: Sales / Assets 1.5Return on assets (ROA) 3%Return on equity (ROE) 5% Calculate the firm’s profit margin and debt-to-assets ratio, assuming the company uses debt and common equity.
DuPont system of analysis Use the following financial information for AT&T and Verizon to conduct a DuPont system of analysis for each company. Sales Earnings available for common stockholders Total assets Stockholders' equity a. Which company has the higher net profit margin? Higher asset turnover? b. Which company has the higher ROA? The higher ROE? c. Which company has the higher financial leverage multiplier? a. Net profit margin (Round to three decimal places.) AT&T Net profit margin AT&T $164,000 13,333 403,921 201,934 Verizon Verizon $126,280 13,608 244,280 24,232
calculate the ratio (expressed to two decimal places) that would reflect each of the following: The amount of funds available relative to sales, to pay the company’s expenses other than its cost of sales (expressed as a percentage) The company's net income as a percentage of the company's net sales.The ability of the company to generate profits from its shareholders investments in the company.A measure of the dividend pay-out per share of the company's ordinary shares. The capacity of the company to pay off its current commitments using just its most liquid assets.The degree to which the company’s assets are financed by debt. A measure of how easily the company can pay the interest on its outstanding debt.
Match the following ratio functions with the ratio (place the number of your chosen answer into the box with the border beside the term you think it goes with : Dividend Yield Debt ratio Current Ratio Price/Earnings Ratio Acid-test ratio Earnings per share 1. The amount of net income earned for each share of the company's common stock 2. The percentage of a stock's market value returned to stockholders as dividends each period 3. The ability to pay current liabilities with current assets. 4. The percentage of assets financed with debt. 5. The ability to pay all current liabilities if they come due immediately. 6. The market price of $1 of earnings.
The following condensed information is reported by Sporting Collectibles. Income Statement Information Sales revenue Cost of goods sold Net income Balance Sheet Information Current assets Long-term assets Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Profitability Ratios a. Gross profit ratio b. Return on assets c. Profit margin d. Asset turnover e. Return on equity % % % The amount of dividends paid Required: 1. Calculate the following profitability ratios for 2021: (Round your answers to 1 decimal place.) times % 2021 $10,440,000 6,827,760 360,000 2. Determine the amount of dividends paid to shareholders in 2021. 2020 $8,400,000 5,900,000 248,000 $ 1,600,000 2,200,000 $ 3,800,000 $ 1,200,000 1,500,000 800,000 $ 900,000 1,500,000 800,000 300,000 200,000 $ 3,800,000 $3,400,000 $1,500,000 1,900,000 $3,400,000
Industry benchmarks can be drawn from quantitative financial ratio information calculated from individual firms. All of the following are key financial ratios that can help establish benchmarks except: Group of answer choices D. Funds from operations/total assets A. EBITDA C. Long-term debt/capital B. Operating income/sales
Exercises 1. Selected data from the Tatum Company are presented below: Total assets Average assets Net income Net sales C. Average common stockholders' equity Net cash provided by operating activities b. Assets Turnover Instructions Calculate the profitability ratios that can be computed from the above information. a. Profit Margin? ROA P1,500,000 1,700,000 275,000 1,400,000 d. ROE 1,000,000 275,000
The most stringent measure of the liquidity status of a business firm. a. Current ratio b. Quick Ratio c. Cash Ratio d. Average collection period
Match each ratio that follows to its use. Items may be used more than once.
You are trying to assess the well-being of the common stockholders of a company. Which of the following ratios would help you make such an assessment?(a) Debt ratio(b) Current ratio(c) Book value per share(d) Total asset turnover
I’m trying to do the debt to equity ratio. I understand that is total liabilities divided by stockholders equity. What would be my liability for the equation? Accounts receivable Inventory Net sales Cost of goods sold Total assets Total stockholders equity Net income