Cashback Offer from 16th to 19th October 2021. Get Flat 10% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question DetailsNormal
$ 85.00

1) a spreadsheet containing your horizontal and vertical analysis

Question posted by
Online Tutor Profile
request

You will submit two files: 1) a spreadsheet containing your horizontal and vertical analysis (and perhaps your ratios) and 2) a word document containing your essay.

Choose a publicly traded company and perform an expanded analysis on the financial statements. Please use the most current 10K statements available on www.sec.gov http://www.sec.gov or annual statements in finance.yahoo.com http://finance.yahoo.com.

Part 1: Please complete the following for your chosen firm in an Excel spreadsheet:

1. Horizontal and vertical analysis of the Income Statements for the past three years (all yearly balances set as a percentage of total revenues for that year).

2. Horizontal and vertical analysis of the Balance Sheets for the past three years (all yearly balances set as a percentage of total assets for that year).

3. Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman’s Z-score.

 

Part 2: The Paper:

 5-6 pages in length.

 Include a proper introduction and conclusion.

 

Your paper should provide your reader with an overall understanding of the financial health of your chosen firm including the following:

 

o Discussion of the ratio analysis results, including rationale for the ratios chosen.

o Discussion of all horizontal and vertical analysis.

o Discussion of four items from the management discussion of the firm that support the conclusion formed in your discussion of the financial results.

Available Answer
$ 85.00

[Solved] 1) a spreadsheet containing your horizontal and vertical analysis

  • This solution is not purchased yet.
  • Submitted On 19 Dec, 2015 07:08:01
Answer posted by
Online Tutor Profile
solution
thanks for buying this t...
Buy now to view the complete solution
Other Similar Questions
User Profile
goodj...

1) a spreadsheet containing your horizontal and vertical analysis

Thanks for buying this tutorials 1) a spreadsheet containing your horizontal and vertical analysis...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35