Prepare a horizontal analysis of the balance sheet data

Assignment Help Accounting Basics
Reference no: EM131881610

Exercise 1 - The comparative condensed balance sheets of Garcia Corporation are presented below.

GARCIA CORPORATION Comparative Condensed Balance Sheets December 31

 

2014

2013

Assets

   

Current assets

$ 76,000

$ 80,000

Property, plant, and equipment (net)

100,000

90,000

Intangibles

24,000

40,000

Total assets

$200,000

$210,000

Liabilities and stockholders' equity

   

Current liabilities

$ 40,000

$ 48,000

Long-term liabilities

140,000

150,000

Stockholders' equity

20,000

12,000

Total liabilities and stockholders' equity

$200,000

$210,000

(a) Prepare a horizontal analysis of the balance sheet data for Garcia Corporation using 2013 as a base.

(b) Prepare a vertical analysis of the balance sheet data for Garcia Corporation in columnar form for 2014.

Exercise 2 - The comparative condensed income statements of Hendi Corporation are shown below.

HENDI CORPORATION Comparative Condensed Income Statements For the Years Ended December 31

 

2014

2013

Net sales

$600,000

$500,000

Cost of goods sold

468,000

400,000

Gross profit

132,000

100,000

Operating expenses

60,000

54,000

Net income

$ 72,000

$ 46,000

(a) Prepare a horizontal analysis of the income statement data for Hendi Corporation using 2013 as a base. (Show the amounts of increase or decrease.)

(b) Prepare a vertical analysis of the income statement data for Hendi Corporation in columnar form for both years.

Exercise 3 - Maulder Corporation has income from continuing operations of $290,000 for the year ended December 31, 2014. It also has the following items (before considering income taxes).

1. An extraordinary loss of $70,000.

2. A gain of $35,000 on the discontinuance of a division.

3. A correction of an error in last year's financial statements that resulted in a $25,000 understatement of 2013 net income.

Assume all items are subject to income taxes at a 30% tax rate.

Prepare an income statement, beginning with income from continuing operations.

Exercise 4 - The comparative statements of Beulah Company are presented below.

BEULAH COMPANY Income Statement For the Years Ended December 31

 

2014

2013

Net sales (all on account)

$500,000

$420,000

Expenses

   

Cost of goods sold

315,000

254,000

Selling and administrative

120,800

114,800

Interest expense

7,500

6,500

Income tax expense

20,000

15,000

Total expenses

463,300

390,300

Net income

$ 36,700

$ 29,700

 

BEULAH COMPANY Balance Sheets December 31

Assets

2014

2013

Current assets

   

Cash

$ 21,000

$ 18,000

Short-term investments

18,000

15,000

Accounts receivable (net)

85,000

75,000

Inventory

80,000

60,000

Total current assets

204,000

168,000

Plant assets (net)

423,000

383,000

Total assets

$627,000

$551,000

Liabilities and Stockholders' Equity

   

Current liabilities

   

Accounts payable

$122,000

$110,000

Income taxes payable

12,000

11,000

Total current liabilities

134,000

121,000

Long-term liabilities

   

Bonds payable

120,000

80,000

Total liabilities

254,000

201,000

Stockholders' equity

   

Common stock ($5 par)

150,000

150,000

Retained earnings

223,000

200,000

Total stockholders' equity

373,000

350,000

Total liabilities and stockholders' equity

$627,000

$551,000

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

Compute the following ratios for 2014.

(a) Current ratio

(b) Acid-test ratio

(c) Accounts receivable turnover

(d) Inventory turnover

(e) Profit margin

(f) Asset turnover

(g) Return on assets

(h) Return on common stockholders' equity

(i) Earnings per share

(j) Price-earnings ratio

(k) Payout ratio

(l) Debt to total assets

(m) Times interest earned

Reference no: EM131881610

Questions Cloud

How recognition of gains or losses change on bond retirement : For a multicorporate entry, how is the recognition of gains or losses on bond retirement changed when emphasis is placed on the economic entity.
Calculate the net interest expense to be reported : Calculate the net interest expense to be reported for this note and related swap transactions as of December 31, 2015.
Define sections that make-up multiple-step income statement : What are the sections that make-up a multiple-step income statement? How is this different from the single step income statement format?
Prepare journal entries necessary to record amount of cost : Prepare the journal entries necessary to record the amount of cost capitalized and the cost charged to expense related to the property's acquisition.
Prepare a horizontal analysis of the balance sheet data : Prepare a horizontal analysis of the balance sheet data for Garcia Corporation using 2013 as a base. Prepare a vertical analysis of the balance sheet data
Boulwarism risk sending a negotiation into deadlock : Why does a negotiator who practices Boulwarism risk sending a negotiation into deadlock?
What is the projects mirr : A project has an initial cost of $66,350, expected net cash inflows of $14,000 per year for 8 years, and a cost of capital of 11%. What is the project's MIRR?
What amount should well report as in rea : On January 2, 20X5, Well Co. purchased 10 percent of Rea, Inc.'s outstanding common shares for $400,000. What amount should Well report as in Rea?
What is the return on capital employed : The following accounting ratios have been calculated from a set a company accounts: Capital productivity (CP) = 2.0.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd