Description
Part One: Spreadsheet
For this assignment you will select to work on EITHER Polaris or Arctic Cat. Depending on which you choose, access the firm’s financial statements for fiscal years ending after December 31, 2014, from the firm’s website (Polaris.com & Arcticcat.com) or the SEC database (www.sec.gov). Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm (Polaris or Artic Cat) in an Excel spreadsheet:
- Horizontal and vertical analysis of the income statements for the past two years (all yearly balances set as a percentage of total revenues for that year) for both firms.
- Horizontal and vertical analysis of the balance sheets for the past two years (all yearly balances set as a percentage of total assets for that year) for both firms.
- Ratio analysis (eight ratios of your choosing) for the past two years PLUS a measurement for the creditworthiness of both firms as measured by Altman’s Z-score.
Review both videos: Performing Vertical Analysis using Excel and Performing Horizontal Analysis using Excel, which demonstrate the completion of vertical and horizontal analysis using Excel. If you would like some additional guidance on the spreadsheet requirement of the portfolio project, please watch the video. Note that the video does not discuss adding the 8 required ratios to your spreadsheet; however, you are required to submit your company ratios on this spreadsheet as well as the vertical/horizontal analysis.
Part Two: Paper/Essay
With the company that was chosen in part one, your paper must:
- Be 4-6 pages in length.
- Include a proper introduction and conclusion.
- Include a reference page.
- Provide a comparative analysis of the financial health of both firms. Your paper should provide your reader with an overall understanding of the financial health of the companies including the following:
- Discussion of the ratio analysis results, including rationale for the ratios chosen.
- Discussion of all horizontal and vertical analysis from above.
- Discussion of four items from the management discussion of the firm that support the conclusion formed in your discussion of the financial results.
Finally, read through the Portfolio Project Part Two Grading Rubric in the Module 8 folder that will be used to grade your assignment—you will get a feeling for expectations by doing so. Your instructor is here to help you through this project. If you have questions, please let your instructor know. He or she may be willing to take a quick look at your horizontal and vertical analysis to give you feedback in advance since you will not have had much experience on that calculation prior to the project. Always communicate right away with your instructor when you need assistance!
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello, please use below final copies. Ignore the 2 above.
Running head: POLARIS INDUSTRIES INC.
Polaris Industries Inc.
Name
Course
Professor
Date
1
POLARIS INDUSTRIES INC.
2
Introduction
Polaris Industries Inc. is a brand that has established itself in the automobile industry.
The firm is involved in the engineering, designing, manufacturing and the marketing of
power sports vehicles globally. The firm has four primary segments include the adjacent
global markets, the aftermarkets, off-Road Vehicles, and the Motorcycles. The firm also
offers various accessories and replacement parts for both the motorcycles and the multiple
vehicles. Polaris was incorporated in the year 1954 and has its headquarters in Medina,
Minnesota. Conversely, Polaris Industries is found in the cyclical consumer sector and the
recreational vehicles industry. It is estimated to have 11,000 full-time employees. Ratio,
vertical and horizontal analysis provides an in-depth understanding of the company, the Z
Altman score, and management discussion also offers more information about Polaris
industries.
Ratio analysis
Liquidity ratio is used to establish the ability of a company to meet its short-term
obligations. The current ratio and the quick ratio are the common liquidity ratios used. The
former is obtained by dividing the current assets by the current liabilities (Khidmat &
Rehman, 2014). Inventory is subtracted from the number of existing assets and then divided
by the current liabilities to obtain the latter. It is evident that Polaris had a current ratio of
1.11 in 2017 and 1.24 in 2016. The quick ratio was 0.42 in 2017 and 0.46 in 2016. The
current ratio is above a value of one hence the firm can pay up its current liabilities.
However, the quick ratio paints a different picture as it has a value that is below one.
Solvency is used to gauge the level of debt in a company. The time's interest earned,
and the debt to total assets are the two ratios used to establish the leverage position of any
particular company. The latter is found by dividing the number of total liabilities by the
POLARIS INDUSTRIES INC.
3
amount of total assets whereas the fo...