Prepare an analysis of balance sheet and income statement

Assignment Help Accounting Basics
Reference no: EM131780199

Assignment: MCM Industries

The following information was obtained from the records of MCM Industries:

 

December 31, 2012

December 31, 2011

Accounts Payable

$     79,000

$      69,200

Accounts Receivable

325,000

332,200

Building, Furniture and fixtures, net

1,161,000

1,161,000

Cash

$      165,000

$      188,000

Common stock

1,140,332

1,248,000

Cost of goods sold

13,823,440

12,533,300

General and Adm. expense

2,682,000

2,314,000

Income tax expense

994,000

1,337,000

Interest expense

29,000

38,000

Inventory

1,095,000

1,064,000

Long-term debt

211,000

256,000

Long Term Notes Payable

85,000

110,000

Other current assets

162,000

165,000

Other accrued payables

18,000

16,000

Retained earnings

1,374,668

1,211,000

Sales

$ 20,632,000

$ 19,282,000

Selling expense

640,000

578,000

Required:

1. Prepare an Income Statement and a Balance Sheet for MCM Corporation for 2011 and 2012.

2. Prepare a vertical analysis of the Balance Sheet and Income Statement for 2011 and 2012. Note any areas of concern and suggested actions management may need to take to address the areas of concern.

3. Compute the following ratios for both years:

• Current ratio
• Quick ratio
• Inventory Turnover ratio
• Debt to equity ratio
• Times interest earned
• Return on equity
• Gross margin percentage

4. Industry Comparison - Compare the performance of MCM Industries to the 2012 industry ratios below and identify differences between the ratios of MCM and the industry averages. Include any explanation on why a ratio may be higher or lower than the industry average. You should also include any actions management needs to take to bring the ratios of MCM more in line with the industry averages.

Industry average ratios:

Current ratio

5.8 to 1

Quick (Acid) ratio

4.0 to 1

Inventory turnover

6.2 times

Debt to equity ratio

.68 to 1

Time Interest Earned

70.4 times

Return on Equity

68%

Gross Margin Percentage

45%

Reference no: EM131780199

Questions Cloud

Determine the buildup of vibration : A balanced wheel supported on springs, as shown in Figure, is rotating at 1200 rpm. If a bolt weighing 15 g and located 5 cm from center suddenly comes loose.
Particle has a velocity of the speed : A particle has a velocity of 33% of the speed of light. If the wavelength of the particle is 1.5 x 10^-10 m, calculate the mass of the particle.
What would the answer be if lucia died five years : What would the answer be if Lucia died five years after inheriting the property
Problem regarding the chemical reaction : In a chemical reaction, C2H6O + PCl3 Æ C2H5Cl + H3PO3, when the reaction was carried out, the actual yield of C2H5Cl was calculated 97.3 % of the theoretical
Prepare an analysis of balance sheet and income statement : Prepare a vertical analysis of the Balance Sheet and Income Statement for 2011 and 2012. Note any areas of concern and suggested actions management may need.
Compute the standard product cost per container of catsup : Compute the standard product cost per container of catsup under (1) absorption costing and (2) variable costing
Discuss the payback period would be approximately : Warburg Company is planning to purchase a new machine for $91,435 with no salvage. The new machine is expected to produce cash inflows from operations before
Calculate the ph of a 1.60 m kbro solution : Calculate the pH of a 1.60 M KBrO solution. Ka for hypobromous acid, HBrO, is 2.0 × 10-9.
Find the ka of a weak acid : The concentration of the acid was found from the titration. PH=2.71, H+=10^-PH, Vab=25.0mL+22.03mL=47.03mL.

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