Perform a vertical analysis on the income statements

Assignment Help Financial Management
Reference no: EM131807640

Financial Analysis

Purpose :  To help familiarize you with the financial reporting of a real company in order to further your understanding of the chapter material.

This case focuses on the financial statement analysis of Columbia Sportswear. Recall from this chapter that stakeholders use numerous ways to anatyze and so better understand the financial position and results of operations of a company. Tools such as vertical and horizontal analyses are available; in addition, financial ratios can be used to gain further insight into areas such as liquid¬ity and profitability.

Other measures include earnings per share and ratios that consider the share price of the company. Finally, nonfinancial information provides additional insights into the per¬formance and financial position of the company. We will now apply some of the analytical tools contained in the chapter. Refer to the Columbia Sportswear annual report found in Appendix A.

Requirements

1. Perform a vertical analysis on the income statements (Consolidated Statements of Operations) for all three years. Discuss your results. What benefit do you see in performing this analysis? Perform a horizontal analysis of the balance sheets (Consolidated Balance Sheets) for both years. Discuss your results. What benefit do you see in performing this analysis?

2. Look at the income statements (Consolidated Statements of Operations). Can you find the Basic EPS for each fiscal year presented? Has the Basic Earnings per Share increased or decreased each year? Why do you think the Basic EPS has been changing?

3. Determine the liquidity of Columbia Sportswear by computing the net working capital, current ratio, and quick ratio at December 31. 2012, and December 31, 2011. Has Columbia Sportswear's liquidity improved or deteriorated? Compute the return on sales and the return on equity ratio for 2012 and 2011. Use end¬ing equity balance instead of average for 2011. Has Columbia Sportswear's profitability improved or deteriorated?

4. The market price for a share of Columbia Sportswear's common stock was $53.36 on December 31, 2012. Using this price, determine the price-earnings ratio and the dividend yield at December 31, 2012 (the dividends per share can be found on the Consolidated Statements of Stockholders' Equity). What do your results mean?

Assume that the industry average PE ratio was 20 times earnings and the dividend yield was 1.8% for the industry. Evaluate your results against the industry averages.

Reference no: EM131807640

Questions Cloud

What are the formulas and processes to allocated joint costs : the constant gross-margin percentage method, and physical measures methods that use data such as weight or volume
Alternative hypotheses in order to test the claim : You suspect that an unscrupulous employee at a casino has tampered with a die; that is, he is using a loaded die. In order to test this claim.
What was his monthly loan payment : (a) What was his monthly loan payment? (b) What must he have paid (in addition to his regular 120th monthly payment) to pay the remaining balance of his loan?
Determining the uniform annual investment : Assuming 5% interest, what uniform annual investment will he have to make on the girl's 8th through 17th birthdays?
Perform a vertical analysis on the income statements : Perform a vertical analysis on the income statements (Consolidated Statements of Operations) for all three years.
Prepare a multiple-step income statement : Prepare a multiple-step income statement, in proper form, for the year ended December
What is the amount of the final payment : If interest on the unpaid balance is computed at 11/2% per month, how many payments will there be, and what is the amount of the final payment?
What is the final single payment : Immediately after the second payment, the terms of the agreement are changed to allow the balance due to be paid off in a single payment the next year.
Penalty charges for this early payment of the loan : If there are no penalty charges for this early payment of the loan, how much will the car cost the new buyer?

Reviews

Write a Review

Financial Management Questions & Answers

  Calculate the firms after-tax cash flow from operations

Moby Dick Corporation has sales of $4,648,300; income tax of $572,362; the selling, general and administrative expenses of $281,006; depreciation of $365,527; cost of goods sold of $2,686,120 and interest expense of $189,656. Calculate the firm’s aft..

  What is profitability ratio and liqidity ratio

What is Profitability Ratio and Liqidity Ratio? and Why would someone chose to look into the Profitability and Liquidity of a Nursing Home?

  What personal tax rate would make investors equally

If the corporate tax rate is 30 percent, what personal tax rate would make investors equally willing to receive the dividend or to let Carlson invest money

  What is the profit margin-determine the equity ratio

After reviewing the firm’s financial statements, it was determined that the firm’s ROE was 15%. The debt ratio is 30%, and the total asset turnover TAT, is 2.4 times. What is the profit margin? First you must determine the equity ratio ______%, and o..

  Coupon bond paying semiannual interest is reported

A coupon bond paying semiannual interest is reported as having an ask price of 111% of its $1,000 par value. If the last interest payment was made one month ago and the coupon rate is 7%, what is the invoice price of the bond? (Do not round intermedi..

  Assets as percentage of total assets in balance sheet

Which institution, University of Texas and a local bank, do you expect to have more tangible assets as a percentage of total assets in its balance sheet? And why?

  Discount rate be before you would reject the project

A project that costs $69,215.00 to install will provide annual cash flows of $20,000.00 for each of the next 12 years. Calculate the NPV if the discount rate is 29.10%? How high can the discount rate be before you would reject the project (i.e. What ..

  Local convention center to help pay for maintenance.

Berklin County has a deal with the local convention center to help pay for maintenance. The county will pay $4817 each month and increase its payment by 0.5% each subsequent month. The county has committed to paying this maintenance for 10 years. How..

  Compute the cost of preferred stock

Medco Corporation can sell preferred stock for $90 with an estimated flotation cost of $2. It is anticipated the preferred stock will pay $8 per share in divide. a. Compute the cost of preferred stock for Medco Corp

  The incremental total cash flow in year

A firm plans to build a plant on land it owns. The firm paid $200,000 for the land 30 years ago. Its current market value is $2,000,000. Construction costs, including machinery, will require an initial outlay of $20,000,000.  The tax rate is 40%. The..

  Calculate return on common equity for fiscal

Do you think financial managers should develop a strategic plan for their company? Why? Calculate return on common equity (ROCE) for fiscal X6 and X7. Disaggregate ROCE into net operating profit margin, net operating asset turnover and leverage.

  Value should be included in initial cost of hotel project

The Green Tomato purchased a parcel of land six years ago for $389,900. At that time, the firm invested $128,000 grading the site so that it would be usable. The firm has no loans or mortgages secured by the property. What value should be included in..

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