Financial Statement Analysis

Comparative statement data for Farris Company and Raizlaff Company, two competitors, appear below. All balance sheet data are as of December 31, 2019, and December 31, 2018

Instructions

1. Prepare a vertical analysis of the 2019 income statement data for Farris company and Ratzlaff Company in columnar form
2. Comment on the relative profitablity of the companies by return on assets and the return on common stockholder's equity for both companies

Solution

The comparative statements of Painter Tool Company are presented below

All sales were on account.

Instructions

Compute the following ratios for 2020. (Weighted-average common shares in 2020 were 57,000.)

1. Earnings per share
2. Return on common stockholder' equity
3. Return on assets
4. Current ratio
5. Acid-test ratio
6. Accounts receivable turnover
7. Inventory turnover
8. Times interest earned
9. Asset turnover.
10. Debt to assets ratio

Solution

Condensed balance sheet and income statement data for Landwehr Corporation appear below.

Additional Information

1. The market price of Landwehr's common stock was $4.00, $5,00, and $8,00 for 2018, 2019, and 2020, respectively.
2. All Dividends wer paid in cash

Instructions

1. Compute the following ratios for 2019, and 2020.
   
   1. Profit margin.
   2. Asset turnover.
   3. Earnings per share (Weighted average common shares in 2020 were 32,000 and in 2019 were 31,000.)
   4. Price-earning ratio.
   5. Payout ratio..
   6. Debt to assets ratio.
2. Based on the ratios calculated, discuss briefly the improvement or lack thereof in financial position and operating results from 2019 to 2018 of Landwehr Corporation.

Solution

Financial information for Messersmith Company is presented below

Additional Information

1. Inventory at the beginning of 2019 was $118,000
2. Total Assets at the beginning of 2019 were $630,000.
3. No common stock transactions occurred during 2019 or 2020
4. All sales wer on account. Accounts receivable, net at the beginning of 2019, were $88,000.
5. Notes payable are classified as current liabilities.

Instructions

1. Indicate, by using ratios, the change in liquidity and profitability of Meassersmith Company from 2019 to 2020.
2. Given below are theree independent situation and a ratio that may be affected. For each situation, compute the affected ratio (1) as of December 31, 2020, and (2) as of December 31, 2021, after giving effect to the situation. Net income for 2021 was $50,000. Total assets on December 31, 2021, were $700,000

Solution

Selected financial data of Target Corporation and Wal-Mart Stores, Inc. for a recent year are presented here (in millions)

Instructions

1. For each company, compute the following ratios.
   
   1. Current.
   2. Receivables turnover.
   3. Average collection period.
   4. Inventory turnover.
   5. Days in inventory.
   6. Profit margin.
   7. Asset turnover.
   8. Return on assets.
   9. Return on common stockholders' equity.
   10. Debt to total assets.
   11. Times interest earned.
2. Compare the liquidity, profitability, and solvency of the two companies.

Solution

The comparative statements of Corbin Company are presented below and on Compute numerous rations.

Additional data
The common stock recently sold at $19.50 per share

Instructions

1. Current.Ratio
2. Acid-Test Ratio
3. Accounts Receivables turnover.
4. Profit margin.
5. Asset turnover.
6. Return on assets.
7. Return on common stockholders' equity.
8. Earning Per share
9. Price-earning ratio.
10. Payout ratio
11. Debt to total assets.
12. Times interest earned.

Solution

An incomplete income statement and an incomplete comparative balance sheet of Deines Corporation are presented below.

Additional information:

1. The accounts receivable turnover for 2020 is 10 times
2. All sales are on account.
3. The profit margin for 2020 is 14.5%.
4. Return on assets is 22% for 2020.
5. The current ratio on December 31, 2020 is 3.0
6. The inventory turnover for 2020 is 4.8 times

Instructions

Compute thee missing information given the ratios above. Show computations.

Solution

Terwilliger Corporation owns a number of cruise ships and a chain of hotels. The hotels, which have not been profitable, were discontinued on September 1, 2020. The 2020 operating results for the company were as follows.

Analysis discloses that these data include the operating results of the hotel chain, which were operating revenues $1,500,000 and operating expenses $2,400,000. The hotels were sold at a gain of $2,00,000 before taxes. This gain is not included in the operating results. During the year., Terwilliger had an unrealized loss on its available-for-sale securities of $600,000 before taxes, which is not included in the operating results. In 2020, the company had other revenues and gains of $100,000, which are not included in the operating results. The corporation is in the 30% income tax bracket.

Instructions

Prepare a statement of comprehensive income.

Solution

The ledger of Jaime Corporation at December 31,2020, contains the following summary data.

Your analysis reveals the following additional information that is not included in the above data.

1. The entire Puzzles Division was discontinued on August 31. The income from operation for this division before income taxes was $20,000. The Puzzles Division was sold at a loss of $90,000 before income taxes.
2. The company had an unrealized gain on available-for-sale securities of $120,000 before income taxes for the year.
3. The income tax rate on all items is 25%;

Instructions

Prepare a statement of comprehensive income for the year ended December 31, 2020.

Solution

Financial information for Kurzen Inc. is presented below.

Instructions

Prepare a schedule showing a horizontal analysis for 2020 using 2019 as the base year

Solution