Preview

Rosalez Company Perform Horizontal Analysis

Satisfactory Essays
Open Document
Open Document
633 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Rosalez Company Perform Horizontal Analysis
ACC 561 - Week 3 - Assignment – WileyPLUS

Brief Exercise 13-4
Using these data from the comparative balance sheet of Rosalez Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.)

Increase or (Decrease)

Dec. 31, 2012

Dec. 31, 2011

Amount

Percentage
Accounts receivable

$ 488,200

$ 360,000

$128,200

36 %
Inventory

$ 818,100

$ 601,200

$216,900

36 %
Total assets

$3,173,600

$2,774,300

$399,300

14 %

Brief Exercise 13-5
Using these data from the comparative balance sheet of Rosalez Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.)

Dec. 31,

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The data in the schedule is a display of vertical analysis because the individual asset items are expressed as a percentage of total assets. The following schedule is a display of what type of analysis?…

    • 685 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Fnt Task 1

    • 1124 Words
    • 3 Pages

    A horizontal analysis Income Statement was performed for Company G utilizing financial data from income statements in 2011 and 2012. A listing of ratios used, calculations and year-to-year comparison follows.…

    • 1124 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Listed below you will find a quick analysis of the company using productivity, Liquidity and solvency ratios. This analysis is accompanied by vertical and horizontal analysis. These analysis gives anyone inquiring a good picture of the company’s overall performance. This analysis is also a good way to determine the company’s financial standings for the said years.…

    • 1990 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    Xacc280 Week 9 Final

    • 2678 Words
    • 11 Pages

    The vertical analysis of the financial statements compares financial data including assets, liabilities, and equity on a yearly basis. A vertical analysis is used most frequently to monitor annual changes. One of the biggest benefits of a vertical analysis is if gives a company the ability to evaluate the comparison between the total net sales and the cost of goods sold. Illustration 1 shows vertical analyses for 2004 and 2005 (select financial data) for Coca-Cola and PepsiCo, Inc. performances.…

    • 2678 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    There are three ways to analyze financial statements there is the vertical analysis, which uses the base percentage to express the assets or liabilities and stockholders’ equity. Horizontal analysis or the trend analysis is how someone can evaluate the financial statement over a period. With this method, one can determine an increase or decrease in assets liabilities or stockholders equity. This can be done in percentage or totals Horizontal analysis is used primarily with an intercompany comparison. Ratio analysis is when one uses three comparisons to look at the financial statements it would look at industry average intracompany and intercompany. Ratio expresses the mathematical relationship in a percentage either a rate or a proportions. It depends on if you are a Short-term creditor or a stockholder which method will be most beneficial for the necessary information to make a sound decision. This information can be overwhelming so careful study and practice is important when analyzing finical statements.…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    To any company whether small or a large corporation, the financial analysis is very important in order for a successful business. This will determine if the company is healthy enough to invest or even to see where you are weak in the financial part of the business. It is the company’s responsibility to present accurate analysis of their financial reports. What I hope to present to you is information that you will help see the comparison of both companies within their financial standings. In this report I will present a vertical analysis and a horizontal analysis, and ratio analysis. I will also try to provide some strategies…

    • 1114 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Week 5

    • 796 Words
    • 4 Pages

    1. Liquidity ratios. Edison, Stagg, and Thornton have the following financial information at the close of business on July 10:…

    • 796 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    To be able to compare company’s performance we will be evaluating three years period from year to year, for which Horizontal technique will be used; and comparing it with results of company’s biggest competitor. Vertical Analysis technique will be used as a standard way for comparison. Then to see how company does in comparison to the competition, we will use Ratio Analysis in which biggest competitor’s numbers will be reviewed. It is important to have several different analyses to see the entire picture and later to be able to understand where company is and what actions shall be chosen for the improvement of financial situation.…

    • 8425 Words
    • 34 Pages
    Powerful Essays
  • Satisfactory Essays

    Xacc Checkpoint Wk 7

    • 278 Words
    • 2 Pages

    o Two measures of horizontal analysis—compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities…

    • 278 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Acc 291 Essay Example

    • 1170 Words
    • 5 Pages

    Next is the horizontal and vertical analysis for the balance sheet, which has been condensed.…

    • 1170 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Lapa Rios seeks to support the local economy. It opens its doors to Caminos de Osa, a group of entrepreneurs from the Osa Peninsula looking to strengthen their businesses by learning best practices from more experienced companies. LR spent just over US $2.6 million from October 2001 to August 2005, with 24.2% of the total known expenditures going into the local peninsula economy, whereas 20% could not be categorised, with the information available, as either within the peninsula or…

    • 80 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    TopGallant has four divisions which are The Bluegrass Auto Division, Sunnyvale, Steelville and TopGallant’s High Sails Consulting (College for America, 2016). Each of these divisions have business unctions to facilitate the activites that are done. Those business functions are;…

    • 146 Words
    • 1 Page
    Good Essays
  • Good Essays

    Acc 291 Weekly Reflection

    • 380 Words
    • 2 Pages

    The second topic of this week was in regards to financial statement analysis. What this means is using financial statements in three different ways of comparison. The three ways are intracompany, industry and intercompany. The analysis of financial statements can be viewed horizontally, vertically or with ratios. Horizontally refers to over course of time, vertically refers to the change in figures, the difference between current and base amounts. The different ratios will help when determining a company’s profitability, liquidity and solvency.…

    • 380 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Home Page

    • 1246 Words
    • 4 Pages

    Introduction: | Below is business memorandum to the CEO of Company G. Below is a chart that full meets the expectations of the task that was give. Each ratio is explained and the formulas used are listed along with the ratio finding. 1. That information is used to understand what our current trend and if it indicates a strength, weakness, no concern. Final Justification of identification of each ratio or trend as a strength, weakness, or no concern is given. 2. No outside sources where used to find the industry data quartiles because those numbers where already given on the attached “Statement Analysis Template Sheet” and we have assumed that the facts are current. | | |…

    • 1246 Words
    • 4 Pages
    Good Essays
  • Good Essays

    There are three types of financial statement analysis; for example, (1) Horizontal Analysis, (2) Vertical Analysis, and (3) Ratio Analysis. First, the horizontal analysis is also known as trend analysis, which views the behavior of an individual financial statement items over several accounting, which may be several quarters within the same fiscal year or several different years; however, the analysis of a given item may focus on absolute dollar amount, according to Edmonds, T.P., Olds, P.R., McNair, F.M., and Tsay. (2010). Moreover, “percentage analysis sidesteps the materiality problems of comparing different size companies by measuring changes in percentages rather than absolute amount; in other words, each change is converted to a percentage of the base year.”( Edmonds et al 2010, p. 326). Second, as Edmonds et al stated, vertical analysis of an income statement also known as a common size statement, involves converting each income statement component to a percentage of sales; however, vertical analysis suggest examining only one period, which is useful to compare common size income statements for several years; which also involves converting each balance sheet component to a percentage of total assets. Third, “ratio analysis involves the study of various relationships between different items reported in a set of financial statement; for example, net earnings reported on the income statement may be compared to total assets reported on the balance sheet; however, analysis calculate many different ratios for a wide variety of purposes.” (Edmonds, et al, 2010).…

    • 485 Words
    • 2 Pages
    Good Essays