Measuring corporate performance

Assignment Help Finance Basics

Reference no: EM131085239

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:

Reference no: EM131085239

Questions Cloud

Understanding of marketing : As you look back on the course, consider how marketing affects your daily life and how your understanding of marketing has changed. To illustrate some of the marketing components that you have learned, identify a specific product that could benefi..

Distribution-pricing and promotional strategies : Develop a marketing plan for your business this should include an introductory statement to describe your product /service A description of your target market. Information about your distribution, pricing and promotional strategies

Case discussion - silver fiddle construction : This case will give you a hands-on experience in project risk management. The project in this case is the construction of a custom quality house at a cost of half million dollars

Threats associated with a business : Reflect upon the strengths, weaknesses, opportunities and threats associated with a business that you are familiar with (one you work at, one you completed your assignments on, or one you have just acquired knowledge about).

Measuring corporate performance : 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.

How does relate to your experience in your current job : Carefully read the interesting stories in Estimation Games People Play by clicking on this link. How does relate to your experience in your current or past job? Have you had similar experiences?

Who should be included in an iep meeting and why : Who should be included in an IEP meeting? Why? What role does each participant play in an IEP meeting? Explain the concept of parental/non-parental rights that should be considered when inviting participants and sharing information.

Discuss iep development and the legal issues surrounding iep : Based on the case study provided, your group will develop an IEP using the template provided. Keep in mind the legal issues involved in writing and applying an appropriate IEP as well as testing requirements.

Find the treasury bond that matures : Below, you will find Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2013.

User Account

All Pages