Do a comprehensive financial analysis

Assignment Help Corporate Finance
Reference no: EM131850627

1.) Research Paper

The objectives/purpose of the research paper project are to enable you to do a comprehensive financial analysis of a publicly traded corporation; and provide you with substantial information for you to make recommendations regarding investing in this corporation.

Your financial analysis report will be driven by a rigorous ratio analysis, and aggressively supplemented with your written analysis, interpretation, and evaluation of the data.

Your research should be strategically driven by two probing questions:

- Would you invest your financial capital in the selected firm as a shareholder?

- Would you invest your human and intellectual capital in the firm as an employee?

Steps in preparation of financial analysis report:

1.) Select a publicly held company - Starbucks

2.) Select a benchmark firm to compare your company against. The benchmark firm is typically the largest competitor. Dunkin Dougnuts

3.) Obtain the firm's balance sheet, income statement, and statement of cash flows for the past 5 years. Download or read the firm's annual report.

4.) Go to: U.S. securities and exchange commission website Search EDGAR

Research EDGAR's database for additional SEC report filings: 8-k, 10-Q.

4.) The following table is the type of Excel or Word table that should be used to gather and report your ratio and financial performance data. Note the 5 financial diagnostic categories that should be used in your analysis.

Financial diagnostic categories

 Chosen company              vs.

 Benchmark competitor

 

 

 

1.)   Liquidity of short-term assets

-Current ratio

-Cash ratio

-Quick ratio

-Current ratio

-Cash ratio

-Quick ratio

 

 

 

2.)   Long-term debt-paying ability

-Debt ratio

-Debt-equity ratio

-Times interest earned

-Debt ratio

-Debt-equity ratio

-Times interest earned

 

 

 

3.)   Profitability

 

 

 

-Net income/sales (profit margin)

-Net income/assets (ROA)

-Net income/shareholder equity  (ROE)

-Net income/sales (profit margin)

-Net income/assets (ROA)

-Net income/shareholder equity  (ROE)

 

 

 

4.)   Asset utilization/ management efficiency

-Total asset turnover

-Inventory turnover   measures

-Accounts receivable turnover

-Total asset turnover

-Inventory turnover   measures

-Accounts receivable turnover

 

 

 

5.)   Market measures

-Price/earnings ratio

-Earnings per common share

-Dividend payout

-Price/earnings ratio

-Earnings per common share

-Dividend payout

 

 

 

Place your ratio calculations in the table for your selected companies-primary company and benchmark competitor. Using 5 diagnostic categories, and 3 ratios to assess each category, results in 15 ratio measures per company that will be compared side by side.

6.) To validate your research, 5 years of data should be analyzed. Calculating ratios for each of the 5 years results in 75 ratios for the subject company and 75 ratios for the benchmark company.

7.) The financial analysis report must be written properly. They must include a title page, a table of contents, and a reference page. For both midterm and final report, information sources from the web, etc. must be cited properly, using APA style.

This means that every table that you cut and pasted or typed from the web must have a source at the bottom of the table AND that citing must also be included in a reference page at the end of the report.

The parts of the research paper are discussed below. The completed report (parts a through h) is due day 7 of week 6. Your project should include:

a. An overview of the corporation.
i. Provide general information regarding the type of business, products and/or services, location of headquarters, name of CEO, number of employees, and countries of operation, etc.

b. The latest financial statements
i. Get the income statement, balance sheet, cash flow statement, and the statement of owners' equity for the past fiscal year. Do not forget to cite the source under each statement.
ii. If you cannot cut and paste them, you may have to type in the information in a table in your report.

c. A summary of each financial statement
i. Take each statement and state the key parts in words. Tell a story from each of the financial statements. For example, for the income statement, the story starts like, "Total Revenues in 2010 were $10 billion, while Cost of Goods Sold were $8 billion, leaving a gross profit margin of $2 billion, or 20 percent of total revenues. After taking out interest and taxes from EBIT, the net income was $0.5 billion, or 5 percent of total revenues."

d. Ratio calculation (include 5 major types of ratios. Refer to chapter 3, Analysis of Financial Statements)
i. Organization of this section is based on the FIVE types of ratios listed in the text book. Calculate the ratios from the financial statements in part c above using Excel or your calculator and present them in a table.
ii. Compare your corporation's ratios to the benchmark's ratios.
iii. Present your results following the five types of ratios discussed in part d.
iv. A table with both corporation and industry ratios is required;
v. The analysis of the ratios is the backbone of this paper, so be sure to discuss each ratio and each category and its implications for your subject company, comparing it to the benchmark company.

e. Discussion of key statistics provided by sources like Yahoo finance.
i. There are many different other statistics available for your corporation. These include market value, beta, and diluted EPS, etc. Discuss some of the key statistics that you think can assist you to determine if this corporation is a good buy or sell.

f. For you to decide if a corporation's stock is a good buy or sell, you must forecast several key variables, including the stock price.
i. Use historical prices (5 years of monthly data recommended) and forecast the stock price for the next year. Use regression analysis, and/or moving average, etc. to create your forecast.
ii. Create a graph from the historical data and show your forecast on the same graph. You can add a trend line to the graph to help you with a forecast. Include the graph in your report.
iii. You need to say specifically what the forecasted value of the stock price is.
iv. You must address the question, "Is this forecast reasonable?" Must you amend your analysis to get a more reasonable forecast?

g. Other information pertinent to the corporation that could affect its future performance and stock price.
i. This could include dividend policy, capital structure, bond ratings, expert opinions on TV, new projects, litigation, regulation, etc. Search for information on the web regarding this corporation. Look at company complaint blogs, etc.

h. Recommendation regarding the future of this corporation.
i. Is the stock a good buy, average buy, or a poor buy (implying a good sell)?
ii. Include a justification of your recommendation based on your analysis and research.

Verified Expert

Please find the enclosed financial report about the company Starbucks, which includes the analysis of financial data of the company and it also includes the ratio analysis. the report also researches the scope of the company related to the investment purpose or not. Total words of the report are 1800 along with the excel which is supported hereby. All the information are correct and complete as per my knowledge. Referencing style used here is the APA style.

Reference no: EM131850627

Questions Cloud

Mines is evaluating ways to increase the company valuation : Montana Mines is evaluating ways to increase the company's valuation over the next five years in order to sell the business.
Complete a case study on a historical or fictional character : With explicit permission from your site supervisor, choose a case, circumstance, or situation at your site. If an appropriate case cannot be obtained.
What is the current wacc for qualtric : The price of Qualtric, Inc. stock is now trading for $50.75 per share and there are currently 113,300 shares outstanding. What is the current WACC for Qualtric,
Prepare a coherently structured draft that follows structure : Prepare a coherently structured draft that follows the structure outlined above. Explain the third problem and provide support for your claims.
Do a comprehensive financial analysis : Do a comprehensive financial analysis of a publicly traded corporation; and provide you with substantial information for you to make recommendations regarding
Bonds has hovered between low and high : Since origination, the yield to maturity on Abbott's bonds has hovered between a low of 6.35% and a high of 9.75%,
Management of nausea and vomiting during pregnancy : What recommendations do you have for management of nausea and vomiting during pregnancy that would apply to Melissa's case?
Interaction of genes with the environment : What does it mean when the experts in the documentary state that obesity is a condition due to the interaction of genes with the environment?
People with celiac disease : Gluten-free diets are essential for people with celiac disease, but a gluten-free diet has also been promoted for weight loss. How could one lose weight

Reviews

len1850627

2/6/2018 1:10:06 AM

g. Other information pertinent to the corporation that could affect its future performance and stock price AND Recommendation regarding the future of the corporation (g and h) YES NO PARTIAL This could include dividend policy, capital structure, bond ratings, expert opinions on TV, new projects, litigation, regulation, etc. Search for information on the web regarding this corporation. Look at company complaint blogs, etc. = 10 points Is the stock a good buy, average buy, or a poor buy (implying a good sell)? Include a justification of your recommendation based on your analysis and research. = 30 points Total Points Awarded ( Possible) = 40 points 40 Grand total points 240

len1850627

2/6/2018 1:09:58 AM

f. For you to decide if a corporation’s stock is a good buy or sell, you must forecast several key variables, including the stock price YES NO PARTIAL Use historical prices (5 years of monthly data recommended) and forecast the stock price for the next year. Use regression analysis, and/or moving average, etc. to create your forecast. = 10 points Create a graph from the historical data and show your forecast on the same graph. You can add a trend line to the graph to help you with a forecast. Include the graph in your report. = 10 points You need to say specifically what the forecasted value of the stock price is. = 5 points You must address the question, “Is this forecast reasonable?” Must you amend your analysis to get a more reasonable forecast? =10 points Total Points Awarded ( Possible) = 35 points 35

len1850627

2/6/2018 1:09:42 AM

Total Points Awarded ( Possible) = 80 points 80 e. Discussion of key statistics provided by sources like Yahoo finance YES NO PARTIAL There are many different other statistics available for your corporation. These include market value, beta, and diluted EPS, etc. Discuss some of the key statistics that you think can assist you to determine if this corporation is a good buy or sell. =15 points Total Points Awarded ( Possible) = 15 points 15

len1850627

2/6/2018 1:09:32 AM

Total Points Awarded (Possible) = 55 points 55 d. Ratio calculation (include 5 major types of ratios) YES NO PARTIAL Organization of this section is based on the FIVE types of ratios listed in the text book. Calculate the ratios from the financial statements in part c above using Excel or your calculator and present them in a table. = 25 points Compute financial ratios for the benchmark and compare your corporation’s ratios to these industry ratios. = 15 points Analyze your results for the five types of ratios. = 40 points

len1850627

2/6/2018 1:09:25 AM

Total Points Awarded ( Possible) = 15 points 15 a. The latest financial statements & Summary of each financial statement. (b and c) YES NO PARTIAL Get the income statement, balance sheet, cash flow statement, and the statement of owners’ equity for the past fiscal year. Create SafeAssign-friendly versions of the financial statements; do not just ‘cut and paste’ them in your report. Do not forget to cite the source under each statement. If you cannot cut and paste them, you may have to type in the information in a table in your report. = 15 points Take each statement and state the key parts in words. Tell a story from each of the financial statements. For example, for the income statement, the story starts like, “Total Revenues in 2010 were $10 billion, while Cost of Goods Sold were $8 billion, leaving a gross profit margin of $2 billion, or 20 percent of total revenues.

len1850627

2/6/2018 1:08:52 AM

Not sure how many pages it will take. Look at attached file. Finance 620 Research Paper Grading Rubric FINC 620 RESEARCH PAPER RUBRIC Objective of Paper: The objectives/purpose of the research paper project are to enable you to do a comprehensive financial analysis of a publicly traded corporation; and provide you with substantial information to make recommendations regarding investing in this corporation. (Total Points = 240): a. An overview of the corporation YES NO PARTIAL Provide general information regarding the type of business, products and/or services, location of headquarters, name of CEO, number of employees, and countries of operation, etc. = 15 points

Write a Review

Corporate Finance Questions & Answers

  Develop a matrix or decision tree in order to compare groups

What are the common decision traps which each group in point (2) is susceptible to? Develop a matrix or decision tree in order to compare the groups. How does the program impact the consumer's "regret"?

  Explain the role of standard deviation in financial analysis

Explain the role of standard deviation in financial analysis. Explain any other uses for standard deviation in a business setting.

  Write memo to friedman and compton highlighting any concerns

Write a brief memo to Friedman and Compton highlighting any concerns that underlie the analyses you have performed in Part 1.

  Discuss the merits of bernsteins arguments

Discuss the merits of Bernstein"s arguments and apprehensions regarding reserves and explain how this perspective can be factored into an analysis of past earnings trends, estimates of future earnings, and the valuation of common stock.

  Financial performance - elk petroleum limited energy

HI5002 - Finance for Business - ELK Petroleum Limited Energy.

  What does a firms beta measure

What happens to the CAPM expected return if the beta increases? If the risk-free rate decreases? If the S&P500 expected return increases?

  Is marge behaving in an ethical manner

Discuss whether the firm is acting in an ethical manner by changing the bonus. Is Marge behaving in an ethical manner?

  What is the effect of a repayment of debt on the firms value

Does debt/equity ratio of a firm change only with the firm's issuance and retirement of debt and equity. - What is the effect of a repayment of debt on the firm's value and on the firm's debt ratio in a perfect market?

  Relationship between statements and cash flow statement

What other financial reports are being referred to? What is the relationship between those other financial statements and cash flow statement?

  Data processing system

This cost of capital was computed based upon the current after-tax cost of equity and debt funds in the bank's capital structure.

  What is its yield to maturity in this situation

Now, assume that the bond has semiannual coupon payments. What is its yield to maturity in this situation?

  What is the after-tax cost of debt for thes firm

What is the after-tax cost of debt for this firm if the marginal tax rate for the firm is 34 percent? What if the bonds are selling at par?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd