Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 15, Problem 1R
The comparative financial statements of Global Technology are as follows:
Review the worksheet RATIOA that follows these requirements. You have been asked to perform a ratio analysis of this company for 2012.
Expert Solution & Answer
To determine
Perform a ratio analysis for Company GT.
Explanation of Solution
Perform a ratio analysis for Company GT.
Table (1)
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
A company’s comparative statements are given below. Please conduct the following analyses:
c. Calculate the three profitability ratios for year 2017 and show how ROE can be derived from the DuPont formula for this company.
d. What do the analyses tell you about the company’s financial performance?
Given the income statement for the MLC (Table 4–7) and balance sheet(Table 4–4), answer the following:a. Calculate the following ratios for 2012: operating profit margin, net profitmargin, operating return on assets, net return on assets, and return onequity.b. In a written explanation, describe what each ratio means.c. In a brief paragraph, describe the overall profitability of the MLC.
A company’s comparative statements are given below. Please conduct the following analyses
(hint: use of a spreadsheet is recommended for ease of computation):a. Horizontal analysis (trend analysis) on the income statement
b. Vertical analysis (common size financial statement analysis) on the income statement
c. Calculate the three profitability ratios for the year 2017 and show how ROE can be derived from the DuPont formula for this company.
d. What do the analyses tell you about the company’s financial performance?
Chapter 15 Solutions
Excel Applications for Accounting Principles
Ch. 15 - The comparative financial statements of Global...Ch. 15 - The comparative financial statements of Global...Ch. 15 - a. What information does a comparison of the...Ch. 15 - Prepare a ratio analysis for Global Technology for...Ch. 15 - Compare your printout from requirement 2 with your...Ch. 15 - With the 2013 data still on the screen, click the...
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
- You 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_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
- Compare the resulting ratios of P and P Manufacturing Company for 2018 (per your computation) with its competitors in the table given below.arrow_forwardPerform a horizontal analysis for the MLC income statement (Table 4–7)for 2011 and 2012. Write an explanation of this analysis.arrow_forwardYou are given financial statements and a Dupont analysis for Tesco and Ahold. What do you conclude about the two companies’ performances based on these numbers?arrow_forward
- Using the data for 2018 and the industry norms, compute the financial ratios that were discussed in this chapter (current ratio, return on assets, operating profit margin, total asset turnover, debt ratio, and return on equity).arrow_forwardQuestions: 1. Make a comparison for each company based on computed ratio. 2. What is your financial analysis on their overall performance?arrow_forwardHow you can assess the company’s performance with financial ratios? Select any company and analyzes the current situation of financial statements with the help of rations.arrow_forward
- Base on this financial ratios, what are your conclusions and recommendations for the companyarrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (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.08 2.7 Quick Ratio 1.8 1.32 1.75 Inventory Turnover 4.5 6 4.7 Average Collection Period 40days 9.125 42 days Total Asset Turnover 1.2 1.69 1 Debt Ratio 20% 28.2% 21% Times Interest Earned 9 5.9% 8.9 Gross Profit Margin 43% 42.8% 44% Operating Profit Margin 30% 25.5% 32% Net Profit Margin 20% 17% 21% Return on total assets 12% 4.11% 13% Return on Equity Price/Earnings Ratio 15% 7.3 19% 4.4 16% 8…arrow_forwardVII. 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License