What is your summary of this companys financial condition

Reference no: EM131295207

Finance Project

1. Choose a company whose financials you can acquire online or in print. I choose Starbucks

2. Spread 3 years of financials for the company using Excel. Do actual fiscal year ends, not estimated.
It should start off with an introduction or overview in which you provide a brief background of the company, the stock exchange on which it trades, and a timeline for completion. It should also include #4 and #5 below. Attach the balance sheet and income statement to the report.

3. Choose a company whose financials you can acquire online or in print.

4. Spread 3 years of financials for the company using Excel. Do actual fiscal year ends, not estimated.

5. In all calculations, use real numbers from the company's financials, not reported ratios provided by online and other sources. Do all calculations for the most recent 3 years available.

6. Collect stock data-price, shares outstanding, insider ownership, insider transactions, stock repurchase program, options, etc.

7. Calculate financial ratios and compare to industry average. What can you conclude from the ratios? Any warning signs? Anything that stands out? Assume you have been given the directive to analyze the company you selected for possible acquisition or taking a minority position. Prepare the report for the Board of Directors and upper management. I don't provide an example because coming up with an effective format is part of the challenge of the assignment. Be sure to do all calculations for 3 years, using Excel. Use real numbers from the financials, not reported ratios provided by online and other sources. Show the source of the numbers.

8. Perform common size analysis. What does this analysis tell you about your company? Are any trends apparent?

9. Use the extended DuPont equation to provide a summary and overview of your firm's financial condition

10. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method.

11. Estimate the company's WACC.

Prepare the report for the Board of Directors and upper management. This report should be 8-10 pages, double-spaced, plus a bibliography. Include the balance sheet and income statement as attachments and as many other exhibits/attachments as you wish.

12. What is your summary of this company's financial condition?

13. What major factors should the company be aware of as it evaluates possible investment projects in the future?

14. Would you be interested in investing in this company? Why or why not? Are there additional factors that aren't a part of this case that you would investigate before making a decision, & if so, what factors? Note: As with all assignments, the more closely I can follow your methodology and "see" where your numbers come from the better the outcome.

Reference no: EM131295207

Questions Cloud

How much should andrew deposit in the bank now : Andrew has purchased a new car. He wishes to set aside enough money in a bank account to pay the maintenance for the first 5 years. It has been estimated that the maintenance cost of a car is as follows: Assume the maintenance costs occur at the end ..

What would be your long-term average of future stocks return : If the "new normal" for GDP growth is 2% (or less) what would be your long-term average of future stocks returns? Why?

Verify that the sum of all power in the circuit is zero : Consider the circuit of Figure again. Use Multisim to find all of the voltages, currents, and power used or provided. Verify that the sum of all power in the circuit is zero.

What is the theory of social responsibilities : What is the theory of social responsibilities that explains how Americans thought about social responsibility over the years?

What is your summary of this companys financial condition : What is your summary of this company's financial condition? What major factors should the company be aware of as it evaluates possible investment projects in the future?

Price discrimination and the robinson-patman act : Discuss price discrimination and the Robinson-Patman Act? Please provide examples.

Importance of an organization mission : 1. What is the importance of an organization's mission, values, and objectives to planning as a function of management? 2. Explain the concept of management by objectives and explain how it is used in organizations.

State whether parallel combination is linear or nonlinear : State whether the parallel combination is linear or nonlinear, active or passive, and bilateral or nonbilateral.- Find the range of voltages over which the resistor current is at least 10 times as large as the varistor current.

Application-critical thinking in action project : Thus far in the formulation of your argument, you have analyzed claims and evidence. Left alone, these statements have little significance.

User Account

All Pages