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 5R
Compare your printout from requirement 2 with your printout from requirement 4. From these two sets of ratios, what conclusions can be drawn concerning changes from 2012 and 2013?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Set out below are the financial statements for KLEE Inc. Limited:
Profit and Loss Accounts ($)
2015
(S000's)
2016
(5000's)
Sales
285
200
Profit before interest and tax
92
84
Interest
10
10
Profit on ordinary activities before taxation
82
74
Тахабоn
32
29
50
Profit on ordinary activities after taxation
Dividends
Retained profit
15
15
35
30
Balance Sheets ($)
Fixed Assets
Fixed Assets
24
58
Current Assets
Stock
25
20
Debtors
Cash
21
20
3
49
48
Current Liabilities
Trade Creditors
18
18
Тахafon payable
Proposed dividend
11
8
15
15
42
41
Net Current Assets
7
5
31
61
Creditors: Amounts falling due after more than one year
10% Debentures
10
10
Total Net Assets
21
51
Shareholders' Funds
Share Capital
Profit and loss account
5
5
18
48
21
51
Please find the following ratios for both year 2017 and year 2018 based on following data
RATIO
AT
ROA
L
ROE
Perform a horizontal analysis for the MLC income statement (Table 4–7)for 2011 and 2012. Write an explanation of this analysis.
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
- Explain the calculation procedures for and significance of the current ratio.arrow_forwardBelow is the overal Performance of Warmart for 2020. make an overall analysis on how it performed describing the ratios used and their interpretations. put in suggestions on how the performance could be improved. You should create a reason for undertaking the analysis, for example assessing an investment opportunity, acquisition or are you a potential customer.arrow_forwardPlease select THREE of the ratios listed below and perform them for years 2012 and 2011. Please interpret the data by including the following: (1) Write out the formula for each ratio you selected and show your calculations. (2) Discuss whether each ratio you selected measures liquidity or profitability and what those terms mean. (3) What factor(s) contributed to the increase or decrease from last year? Discuss whether those changes were favorable or unfavorable to the company and why? (4) What does each of your calculated ratios potentially mean for the company’s overall financial condition? Please assume the market price of the common stock on 12/31/11 was $113.40. Also, if you need any numbers from 2010 for averages, please use the following: Cash 300,000 Marketable securities 1,000,000 A/R 345,000 Inventory 647,000 Prepaids 220,000…arrow_forward
- For the return on equity (ROE) and return on assets (ROA) ratios, perform a DuPont decomposition andanalyze the components of the ratios in both years. Comment on which components of the ROE and ROAratios are driving the changes in the ratios you observe. Here is my ROE for years 2021 (1728.1 / 11,951.5= 14.5%) and 2020 (1066.8 / 9759.1= 11.3%) Here is my ROA for 2021 (1728.1 / 13,555) * 100 = 12.7488% and 2020 (1066.8 / 11,168.9) * 100 = 9.5515%arrow_forwardPrepare a ratio analysis for Global Technology for 2013. The following information is available for 2013: The 2013 information should be entered in column B of the RATIOA2 worksheet. The 2012 information should be entered in column C. Save the revised file as RATIOA4. Print the worksheet when done.arrow_forwardUse the information provided (first picture) to calculate the profit margin ratios for 2021 and put your answer in the template provided (second picture)arrow_forward
- Critically evaluate the ratios calculated below, and comment on your analysis.arrow_forwardCompute trend percents for the following accounts using 2015 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.arrow_forwardInstructions: I. Resolve the ratios listed on table a for each year (2020 & 2021): a. For each ratio includes the formula with math computes (2020 & 2021) b. . Fill M&G Industries Ratio Analysis Table A. (2020 & 2021) II. Perform the following Analysis: a. Explain each ratio results for 2021 only. b. Compare each ratio performance with the previous year results (compare 2021 results with 2020 results) c. Compare each Ratio results for 2021 with their respective Industry average. III. Base on the previous results, evaluate and explain the Company financial position using the following questions: 1. How liquid is the firm? 2. Is management generating adequate operating profits on the firm’s assets? 3. How is the firm financing its assets? 4. Are the owners (stockholders) receiving an adequate return on their investment?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
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Accounting Changes and Error Analysis: Intermediate Accounting Chapter 22; Author: Finally Learn;https://www.youtube.com/watch?v=c2uQdN53MV4;License: Standard Youtube License