Excel Project

/in /by

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $13/Page
Order Now

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