FIN. ACCT.-TOOLS FOR BUS.DEC.MAKING-CODE
9th Edition
ISBN: 9781119595724
Author: Kimmel
Publisher: WILEY C
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
VII. Direction: Compute and interpret.
The following comparative financial statements are provided by Avatar Industries. You were asked
to compute the different financial ratios and provide your interpretations with regards to
profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template
below to input your answer and solution.
AVATAR INDUSTRIES
AVATAR INDUSTRIES
Comparative Statement of Financial Position
For the years 2019 and 2018
Comparative Income Statement
For the years 2019 and 2018
2019
2018
2019
2018
ASSETS
Current Assets:
Sales
P200,000
P210,000
Cash & Cash Equivalent
P65,000
P70,000
Sales Returns and Allowances
40,000
25,000
Accounts Receivable
40,000
35,000
Net Sales
160,000
185,000
Marketable Secuities
40,000
35,000
Cost of Goods Sold
100,000
115,625
Inventory
100,000
80,000
Gross Profit
60,000
69,375
Total Current Assets
220,000
200,000 160,000
P445,000 P380,000
245,000
Operating Expenses:
Fixed Assets
Selling Expenses
22,000
25,000
Total…
VII. Direction: Compute and interpret.
The following comparative financial statements are provided by Avatar Industries. You were asked
to compute the different financial ratios and provide your interpretations with regards to
profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template
below to input your answer and solution.
AVATAR INDUSTRIES
AVATAR INDUSTRIES
Comparative Statement of Financial Position
For the years 2019 and 2018
Comparative Income Statement
For the years 2019 and 2018
2019
2018
2019
2018
ASSETS
Current Assets:
Sales
P200,000
P210,000
Cash & Cash Equivalent
P65,000
P70,000
Sales Returns and Allowances
40,000
25,000
Accounts Receivable
40,000
35,000
Net Sales
160,000
185,000
Marketable Securities
40,000
35,000
Cost of Goods Sold
100,000
115,625
Inventory
100,000
80,000
Gross Profit
60,000
69,375
Total Current Assets
245,000
220,000
Operating Expenses:
Fixed Assets
200,000
160,000
Selling Expenses
22,000
25,000
Total Assets
P445,000…
Solve and perform the different financial ratios using the financial statements of XYZ Company for the year 2021.
1. Current Ratio
2. Quick Ratio
3. Receivables Turnover
4. Inventory Turnover
5. Debt Ratio
6. Equity Ratio
7. Times Interest Earned
8. Gross Profit Margin
9. Operating Profit Margin
10. Net Profit Margin
Knowledge Booster
Similar questions
- The average liabilities, average stockholders' equity, and average total assets are as follows: 1. Determine the following ratios for both companies, rounding ratios and percentagesto one decimal place: a. Return on total assets b. Return on stockholders' equity c. Times interest earned d. Ratio of total liabilities to stockholders' equity 2. Based on the information in (1), analyze and compare the two companies'solvency and profitability. Comprehensive profitability and solvency analysis Marriott International, Inc., and Hyatt Hotels Corporation are two major owners and managers of lodging and resort properties in the United States. Abstracted income statement information for the two companies is as follows for a recent year (in millions): Balance sheet information is as follows:arrow_forwardAlex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.arrow_forwardBelow is the balance sheet and income statement for Chin Corporation. You are needed to analyze the financial statements. Use the horizontal, vertical, ratio methods to analyze the financial statements. For the vertical and horizontal analysis, type the accounts and dollar values for the years 2018 and 2017 (as listed on the financial statements even if there is no dollar value for an account). For the ratio analysis, make sure to compute 2 ratios from each section. Income Statement Period Ending: 12/31/2018 12/31/2017 Total Revenue $76,512,000 $78,291,000 Cost of Revenue $54,884,000 $56,586,000 Gross Profit $21,628,000 $21,706,000 Operating Expenses Research and Development $0 $0 Sales, General, and Admin. $13,886,000 $13,599,000 Non-Recurring Items $0 $0 Other Operating Items $0 $0 Operating Income $7,832,000 $8,079,000 Add'l income/expense items -$323,000…arrow_forward
- (A)Prepare ratio analyses (for 2019, 2018, and 2017) for both companies.You should include the following ratios in your computations: 1. Profitability ratios Gross Profit margin Profit margin Return on assets Return on equity 2. Productivity Inventory Turnover Accounts Receivable Turnover PPE Turnover Asset Turnover 3. Solvency Debt-to-equity Times interest earned Return on Financial leverage 4. Liquidity Current Ratio Quick Ratio Operating cash flow to current liabilities Working capitalarrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 — 2.7 Quick Ratio 1.8 — 1.75 Inventory Turnover 4.5 — 4.7 Average Collection Period 40days — 42 days Total Asset Turnover 1.2 — 1 Debt Ratio 20% — 21% Times Interest Earned 9 — 8.9 Gross Profit Margin 43% — 44% Operating Profit Margin 30% — 32% Net Profit Margin 20% — 21% Return on total assets 12% — 13% Return on Equity Price/Earnings Ratio…arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 — 2.7 Quick Ratio 1.8 — 1.75 Inventory Turnover 4.5 — 4.7 Average Collection Period 40days — 42 days Total Asset Turnover 1.2 — 1 Debt Ratio 20% — 21% Times Interest Earned 9 — 8.9 Gross Profit Margin 43% — 44% Operating Profit Margin 30% — 32% Net Profit Margin 20% — 21% Return on total assets 12% — 13% Return on Equity Price/Earnings Ratio…arrow_forward
- Compute Liquidity and Solvency Ratios for Competing Firms Halliburton and Schlumberger compete in the oil field services sector. Refer to the following 2018 financial data for the two companies to answer the requirements. $ millions Cash and equivalents Short-term investments Accounts receivable Current assets Current liabilities Total liabilities Total equity Earnings before interest and tax (EBIT) Interest expense, gross a. Compute the following measures for both companies. Note: Round your final answers to two decimal places (for example, enter 6.78 for 6.77555). 1. Current ratio 2. Quick ratio 3. Times interest earned 4. Liabilities-to-equity HAL SLB $2,008 $1,433 1,344 5,077 7,645 11,151 15,731 4,658 13,081 16,438 33,921 9,258 35,488 2,393 2,959 554 537 HAL 2.28 x 1.5 x 4.54 x 1.69 * SLB 1.114 x 0.79 x 5.79 * 0.91 x b. Which company appears more liquid? HAL c. Which company appears more solvent? SLB =arrow_forwardCalculate the current ratio for each company. Be sure to show your calculations. Current Assets Current Liabilities Company 1 89,378 80,610 Company 2 90,114 19,310 Company 1: Company 2: Comment on the results: Which company has the strongest liquidity position?arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011.Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios.arrow_forward
- Is the organization profitable? Why or why not? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60. Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Accounts Receivable 954.80 Salaries Payable 225.20 Inventories 3,645.20 Other Current Liabilities 1,118.80 Other Current Assets 116.60 Total Current Liabilities 2,955.20 Total Current Assets 5,165.27 Other Liabilities 693.40 Machinery & Equipment 1,688.90 Land 1,129.70 Total Liabilities 3,648.60 Buildings 2,348.40 Depreciation (575.60) SHAREHOLDER'S EQUITY…arrow_forwardBased on the Balance sheet calculate: 1.Current Ratio 2. Acid Test or Quick Ratio 3. Cash Ratio 4. Debt Ratio 5. Debt to Equity Ratio 6. Asset Turnover Ratio 7. Receivable Turnover Ratio and 8. Day Sales to Inventory Ratio. Based on the calculations presented above interpret the overall performance of BMW AG Group’s and the line items it must stay focused upon. Discuss its overall financial status having calculated the ratios across the years, considering the impact of Covid-19 while support decision-making related to its future growth and profitabilityarrow_forwardc. Compute the quick ratio for each company. Round your answers to one decimal place. Abercrombie: The Gap: Current assets: Analyze and compare Abercrombie & Fitch and The Gap Abercrombie & Fitch Co. (ANF) and The Gap, Inc. (GPS) are two U.S. apparel retailers. The current assets and current liabilities for each company from recent balance sheets are as follows (in thousands): Cash Accounts receivable Inventories X Other current assets Total current assets Current liabilities: Accounts payable Other current liabilities Total current liabilities X Abercrombie & Fitch The Gap $723,135 $1,364,000 73,112 290,000 437,879 2,156,000 101,824 706,000 $1,335,950 $4,516,000 $226,878 332,039 $558,917 $1,174,000 2,035,000 $3,209,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning