Financial statement analysis

Apr 30th, 2014
DreamIt
Category:
Business & Finance
Price: $40 USD

Question description

Financial Statement Analysis Mini-Project

The financial analysis project is designed to develop your ability to (1) understand and analyze

published financial reports and (2) make a recommendation to investors regarding the financial

condition of a public company.

This project can be completed entirely in Microsoft Excel. You should use Mergent Online to download

the appropriate financial statements, and can include those statements in the Excel file with cell

references in the formulas to guard against mathematical errors.

It is important to fully address the question being asked. When answering the questions, make sure

to double-check your calculations. Be sure to include your results as well as a detailed

explanation/interpretation of the information.

Any use of outside reference materials should be cited.

The bulk of your grade will be based on your ability to perform the requested analyses and provide an

accurate interpretation of the results. Financial analysis includes not just the ability to obtain the

correct results, but also the ability to describe and interpret what the results mean in terms of

increasing the understanding of the available data.

Primary: Starbucks (SBUX) (PICK A DIFFERENT COMPANY, THIS IS JUST AN EXAMPLE)

Competitor: Select a competitor from those identified by Mergent Online

1. Calculate the following ratios needed to assess liquidity and interpret the results. This should

include the last 3 years of ratios for the company and the last 3 years of ratios for the

competitor. What trends are there? (approx. 1/2 page single spaced 12 pt. in Word doc)

a. Current Ratio

b. Acid-Test (Quick) Ratio

c. Receivables Turnover

d. Inventory Turnover

e. Asset Turnover

2. Calculate the following ratios needed to assess long-term debt-paying ability and interpret the

results. This should include the last 3 years of ratios for the company and the last 3 years of

ratios for the competitor. What trends are there? (approx. 1/2 page single spaced 12 pt. in Word doc)

a. Times Interest Earned

b. Debt to Total Assets Ratio

c. Book Value per Share

3. Calculate the following ratios needed to assess profitability and interpret the results. This

should include the last 3 years of ratios for the company and the last 3 years of ratios for the

competitor. What trends are there? (approx. 1/2 page single spaced 12 pt. in Word doc)

a. Profit Margin on Sales

b. Rate of Return on Assets

c. Rate of Return on Common Stock Equity

d. Earnings per Share

e. Payout Ratio

4. Which company would you invest in? What are the reasons for your decisions? This should be

based on financial analysis and significant facts. (approx. 1 page single spaced 12 pt. in Word doc)


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Maryland
PREMIUM TUTOR

Studypool has helped 1,244,100 students

5 Reviews


Summary
Quality
Communication
On Time
Value
ashleyisgod
Nov 26th, 2016
" Top quality work from this guy! I'll be back! "
Molly_Moon
Nov 4th, 2016
" AMAZING as always! "
Hemapathy
Oct 12th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Sep 29th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Sep 20th, 2016
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors