A company’s comparative statements are given below. Please conduct the following analyses:a. Horizontal analysis (trend analysis) on the income statement b. Vertical analysis (common size financial statement analysis) on the income statement Note: When the dollar change is positive, it indicates that the value increased and therefore the % change should be positive. Therefore, when calculating % change involving a negative baseline value, use the absolute value of the baseline number in the denominator: % change = (new value - original baseline value)/|baseline value|. Otherwise the % change will be inconsistent with the real change. For example:Let's say item A changed from -10 to +10. Item A increased by 20 and thus should give rise to a positive % change. However, % change based on formula using the original value of -10 is -200% = [10-(-10)]/(-10).Let’s look at another example. Assume item B changed from -10 to -20, a decrease of 10 with a % change of -100%. However, % change based on formula using the original value of -10 is 100% = [-10-(-20)]/(-10). Year ended December 31,(in millions)201820172016ASSETSCash$5,405$6,680$7,000Accounts Receivable2,0002,5001,000Inventory15,00012,00014,000Current Assets22,40521,18022,000Property Plant & Equipment50,00045,00040,000Total Assets72,40566,18062,000LIABILITIESCurrent Portion of Debt$3,000$2,000$3,500Accounts Payable1,0001,5001,000Current Liabilities4,0003,5004,500Long Term Debt25,00020,00015,000Total Liabilities29,00023,50019,500EQUITYShare CapitalRetained EarningsShareholders' EquityTotal Liabilities & Equity30,00030,00030,00013,40512,68012,50043,40542,68042,50072,40566,18062,000 Year ended December 31,(in millions)201820172016Revenue$5,000$4,000$3,000COGS(3,200)(3,000)(2,500)Gross Profit1,8001,000500Depreciation(500)(450)(400)SG&A(300)(300)(300)Interest(50)(50)(50)Earnings Before Tax950200(250)Таx(225)(20)Net Earnings725180-250

Income statement is the statement which shows the net profit or net loss earned during the year for…

Answered: A company’s comparative statements are…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Profitability Ratios Current Yr. Prior Yr. Fav/Unfav. Gross Margin (%) {Gross Income/Sales Revenue} Profit Margin (%) {Net income/ Sales Revenue} Return on Assets (%) {Net Income/ Average Total Assets}
Use the attached information to complete the ratio analysis. The Ratio Analysis is for Profitability.
A condensed income statement for Stock Storage and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. 2. Does Stock's Cost of Goods sold for the current year, as a percentage of revenues, represent better or worse performance as compared to that for the previous year? 3. Has Stock"s net profit margin increased, or decreased, over the two years? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete the vertical analysis by computing each missing line item as a percentage of sales revenues. (Round your answers to the nearest whole percent.) STOCK STORAGE Income Statement (summarized) (in millions of U.S. dollars) Current Year Previous Year Sales Revenues $ 2,090 100 % $ 2,170 100 % Cost of Goods Sold 1,697 81 % 1,661 % Selling, General, and Administrative Expenses 285 % 286 13 % Other Operating Expenses 51 2 %…
I need help to determine the following; 5. For P & B Manufacturing to assess its profitability I need help to calculate the net profit margin percentage AND the return on equity. Include calculations and round answers to 2 decimal places.
go.3
Return on equity (ROE) using the traditional DuPont formula equals to A. (net profit margin) (interest component) (solvency ratio) B. (net profit margin) (interest component) (liquidity ratio) C. (net profit margin) (total asset turnover) (quick ratio) D. (net profit margin) (total asset turnover) (solvency ratio)
Indicate whether the following are a measure of (a) liquidity, (b) profitability, or (c) leverage. 1. Quick ratio 2. Times interest earned ratio 3. Current ratio 4. Ratio of net sales to assets 5. Return on total assets 6. Accounts receivable turnover 7. Return on stockholders' equity 8. Book value per share of common stock 9. Ratio of liabilities to stockholders' equity 10. Acid-test ratio 11. Earnings per share of common stock 12. Merchandise inventory turnover 13. Working capital
For each ratio listed, identify whether the change in ratio value from the Prior Year to the Current Year is usually regarded as favorable or unfavorable. Ratio 1. Profit margin 2. Debt ratio 3. Gross margin 4. Acid-test ratio 5. Accounts receivable turnover 6. Basic earnings per share 7. Inventory turnover 8. Dividend yield Current Year Prior Year Change 9% 8% 47 % 42 % 34 % 46 % 1.00 1.15 5.5 6.7 $ 1.25 $ 1.10 3.6 3.4 2.0 % 1.2 %
2 Tiger Audio declared and paid a cash dividend of $7,925 in the current year. Its comparative financial statements, prepared at December 31, reported the following summarized information: Current Previous Income Statement $342,000 $281,000 175,650 166,350 63,600 6,400 96,350 28,905 Sales Revenue Cost of Goods Sold 159,000 122,000 52,930 5,670 63,400 19,020 Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income $ 67,445 $ 44,380 Balance Sheet $ 72,520 32,900 49,000 151,000 $305,420 $ 45, 200 28,000 46,000 138, 200 Cash Accounts Receivable, Net Inventory Property and Equipment, Net Total Assets $257,400 $ 39,000 4,800 101,900 145,700 39,400 120,320 $ 37,000 4,000 116, 200 157, 200 39,400 60,800 Accounts Payable Income Tax Payable Note Payable (long-term) Total Liabilities Common Stock (par $1) Retained Earnings Total Liabilities and Stockholders' Equity $305,420 $257,400
Which of the following ratios would NOT be considered to be a measure of a business economic performance? A.Return on assets B.Inventory days C.Return on equity D.Sales growth
From the information attached below, calculate: a. the average stock return from 20x1- 20x3. b. The standard deviation over the same period.
Suppose the following model describes changes in Company ABC’s sales: ∆ ABCt = 0.078 - 0.095(∆ ABCt-1) The current change (first difference) in the company’s sales growth rate is 0.04. Use this information to answer the questions below. (NB: For all the questions below, give your final answers to 3 decimal places.) 1. Calculate the mean-reverting level for changes in the company’s sales growth rate. (Give your answer in decimals). 2. What is the best prediction of the next change? (Give your answer in decimals) 3. What is the prediction of the change following the next change? (Give your answer in decimals) 4. blanks. Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

a. Horizontal analysis (trend analysis) on the income statement
b. Vertical analysis (common size financial statement analysis) on the income statement

Note:
When the dollar change is positive, it indicates that the value increased and therefore the % change should be positive. Therefore, when calculating % change involving a negative baseline value, use the absolute value of the baseline number in the denominator: % change = (new value - original baseline value)/\|baseline value\|. Otherwise the % change will be inconsistent with the real change. For example: Let's say item A changed from -10 to +10. Item A increased by 20 and thus should give rise to a positive % change. However, % change based on formula using the original value of -10 is -200% = [10-(-10)]/(-10). Let’s look at another example. Assume item B changed from -10 to -20, a decrease of 10 with a % change of -100%. However, % change based on formula using the original value of -10 is 100% = [-10-(-20)]/(-10).

A company’s comparative statements are given below. Please conduct the following analyses: a. Horizontal analysis (trend analysis) on the income statement b. Vertical analysis (common size financial statement analysis) on the income statement