apple vs samsung Financial Analysis EXCEL

You must then obtain the financials for the most recent three-year period. Based on the company financials:

1. Prepare a Horizontal Analysis for all 3 financial statements.
2. Prepare a Vertical Analysis for the Balance Sheet and Income Statement.
3. Prepare a Ratio Analysis for each of the following:
   1. Current ratio
   2. Acid-test ratio
   3. Receivable turnover
   4. Inventory turnover
   5. Profit margin
   6. Asset turnover
   7. Return on Assets
   8. Return on Common Stockholder’s Equity
   9. EPS (Earnings Per Share)
   10. Debt to total Assets ratio
   11. Times Interest Earned

   The financial statements for the project can be retrieved at the assigned company’s website or at sec.gov. You must use the most recent 2 years for your analysis.

The analysis should include a comparative analysis that is Intracompany (Horizontal & Vertical analysis for 2 years) and Intercompany (by way comparison of Ratios to a Major Competitor for the most recent year). Possible explanations for major differences should be provided. You must use a formula for all numbers that require a calculation (ratio, total, difference, etc.).

The project should be done via Excel and Write a paper describing what you did.

any questions please ask

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.