Description
Individual Excel Project |
Select an approved company and obtain the financials for the most recent two 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: a. Current ratio b. Acid-test ratio c. Receivable turnover d. Inventory turnover e. Profit margin f. Asset turnover g. Return on Assets h. Return on Common Stockholder’s Equity i. EPS (Earnings Per Share) j. Debt to total Assets ratio k. Times Interest Earned Your analysis should include a comparative analysis that is Intracompany (Horizontal & Vertical analysis for 2 years). No intercompany analysis is required. The project should be done via Excel |
Explanation & Answer
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Road
by Cormac McCarthy
Cant Hurt Me - Master Your Mind and Defy the Odds
by David Goggins
Treasure Island
by Robert Louis
The Point of it All - A Lifetime of Great Loves and Endeavors
by Charles Krauthammer
The King Must Die
by Mary Renault
How to Win Friends and Influence People
by Dale Carnegie
The Mayor of Casterbridge
by Thomas Hardy
A Wrinkle as Time
by Madeleine L'Engle
Animal Farm
by George Orwell