Good afternoon,
In the project you need to download financial statements in your file. Clean them up so all cells with numbers are formatted as numbers.
And when you calculate a ratio in a cell you need to type = sign and use reference cells from your statements.
For example, look at 1-Short-Term-solvency tab in the example file.
The students used cells B4, B5 and B24 from the HD-Balane_Sheet tab: (cash and cash equivalents+receivables)/total liabilities.
This is a proper way to use Excel and build financial models. You can always check if your formula and calculations are correct and you can verify that you are using proper inputs
Measuring Corporate Performance. Financial Statement Analysis.
The goal of this assignment is to expand your understanding of the uses of financial statement information. This project is based on the information provided in Ch. 28 - Financial Analysis. We will examine the financial performance of McDonalds and one of its competitors. You will need to select a competitor.
Obtain Financial Statements and market data (current stock price, number of shares outstanding) for the two companies from its Hoovers dataset (easy and available through the library website), company's website, finance.yahoo.com, money.msn.com, SEC.gov, or Edgar (also easy and available through the library website).
Calculate following ratios and measures for McDonalds and the company you selected and compare them to the industry ratios. McDonalds is usually classified as q a Quick Service Restaurant, but depending on the competitor you pick, you may be able to justify another industry classification. Here are the ratios that you will need to calculate:
- Performance Measures:
- Market Value Added (MVA)
- Market-to-book ratio
- Economic Value Added and Profitability Measures:
- EVA
- Return on Capital (ROC)
- Return on Assets (ROA)
- Return on Equity (ROE)
- Measuring Efficiency - Asset Management or Turnover Measures:
- Assets Turnover
- Fixed Assets Turnover
- Inventory Turnover
- Average days in inventory
- Receivables Turnover
- Average Collection period
- Analyzing the return on Assets
- Profit Margin
- Operating Profit Margin
- The Du Pont System
- Measuring Financial Leverage - Long term Solvency Measures
- Long Term Debt Ratio
- Long Term Debt-Equity Ratio
- Total Debt Ratio
- Times Interest Earned
- Cash Coverage Ratio
- Measuring Liquidity - Short-Term Solvency or Liquidity Measures
- NWC to Total Assets Ratio
- Current Ratio
- Quick Ratio
- Cash Ratio
- Growth measures:
- Payout Ratio
- Sustainable Growth
For each ratio, comment on how it would be viewed relative to the competitor or industry. You cannot just say that a ratio is higher than average or lower than average; you must explain WHAT the ratio means and WHY the value would be viewed either positively or negatively
For example, suppose you calculate the inventory turnover ratio. How would you interpret the ratio? How dos your company compare to the industry averages for this ratio? Is it better to have higher or lower inventory turnover in this industry or does it not matter so much?
You will need to find Cost of Capital for the McDonalds' industry to calculate EVA. This is the link to the dataset with different industries' Costs of Capital (WACC):
Deliverables:
Provide an Executive Summary and a report in Excel on Moodle with Financial Statements and all formulas in a following format:
|
Performance Measure / Ratio
|
McDonalds
|
Competitor
|
Industry Average Comment
|
|
Performance Measures:
|
|
MVA
|
|
|
|
|
Market-to-Book Ratio
|
|
|
|
|
Economic Value Added and Profitability Measures:
|