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)

Do you want your assignment written by the best essay experts? Then look no further,Order Now, and enjoy an amazing discount!!

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your paper today and save 7% with the discount code HOME7