Purchase Solution

Prepare a common-size income statement

Not what you're looking for?

Ask Custom Question

Honda Motor COmpany is a Japanese automobile company with sales equivalent to $80 billion. The company's income statement and balance sheet for the year ended March 31,2000, are shown in Exhibits 16A-1 and 16A-2. Monetary amounts are in Japanese yen.

1. Prepare a common-size income statement, that is, one showing component percentages.
2. Compute the following ratios: A. Current ratio. B. Total debt to equity. C. Gross profit margin. D. Return on shareholders' equity (1999 shareholders' equity was 1,764 billion yen)
3. What additional information would help you interpret the percentages and ratios you calculated?

(See attached file for full problem description)

Attachments
Purchase this Solution
Solution Preview

Hi there,

Please see the attached Excel spreadsheet. Also, here is some extra info for your reference:

Common Size I/S: An income statement in which each account is expressed as a percentage of the value of sales. This type of financial statement can be used to allow for easy analysis between companies or between time periods of a company. Common size income statement analysis allows an analyst to determine how the various components of the income statement affect a company's profit.

Current Ratio:

A liquidity ratio that measures a company's ability to pay short-term obligations; calculated by dividing current assets by current liabilities. This also helps to give an idea as to the efficiency of the company's operating cycle. The ratio is mainly used to give an idea about the company's ability to pay back their short-term liabilities (debt and payables) with their short-term assets (cash, inventory, receivables). The higher the current ratio the more capable the company is at paying their obligations. A ratio under 1 suggests that the company is unable at that point to pay off their obligations if they came due. While this shows the company is not in good financial health, it does not necessarily mean it will go bankrupt as there are many ways to access financing but it is not a sign of financial health.

The current ratio can give an idea to the efficiency of a ...

Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • Common size statement for three years of data

    412349 Common size statement for three years of data See attached file. Please prepare the common size statement of the attached Income statement for three years (2010, 2009, 2008).

  • Common size income statement

    Based on those, a solution presented in Excel shows how to prepare a common size income statement. Solution discusses the 14 ratios listed on the attached file and prepare a common-sized income statement for the latest two years at Target.

  • common size balance sheet & income statement

    The solution contains preparation of common size income statement and common size balance sheet for two financial years for comparative purposes.

  • Cmmon size income statement

    The solution explains how to prepare a common size income statement and use it to evaluate the company's performance

  • Common-sized balance sheet

    Common size statements usually are prepared for the income statement and balance sheet, expressing information as follows: * Income statement items - expressed as a percentage of total revenue * Balance sheet items - expressed as a percentage

  • Common size / financial statements

    See attached files. 11.6 - Prepare a common size balance sheet for Intel, 2008 Solve the requirements of Problem 11.5 for the year ended December 27, 2008. 11.12 - Analytical case to complete an income statement and balance sheet using financial

  • Accounting: Common Size Analysis

    Prepare common-size 2012 income statements for each company. 3.

  • Yarrick Company - Common income statement

    Prepare a common-size income statement and analyze the profitability of the company.

  • Common size statements, ROI, ROE

    243714 Common size statements, ROI, ROE Instructions (a) Prepare a vertical analysis of the 2009 income statement data for Douglas Company and Maulder Company in columnar form.

  • Common Size and Ratios

    A common size income statement expresses each income statement item as a percentage of sales. The common size income statement is useful in identifying trends over time within the company, and comparing costs, for example, across companies.

View More Related Solutions