Comprehensive financial analysis of a public corporation

Assignment Help Financial Management
Reference no: EM13174627 , Length: Words 2000

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

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

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.

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

5.) 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




Use 2-3 ratios per diagnostic category. 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.

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:

  1.  

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. Cut and paste them in your report. 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. Find industry financial ratios online (eg. Yahoo.com) and compare your corporation's ratios to these industry 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;

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

Reference no: EM13174627

Questions Cloud

Departure of this minority : The departure of this minority from France after Louis XIV revoked the edict of Nantes led to economic difficulties
Discuss what should be the research topic and why : discuss how well each company meets your criteria. Also, rank the three companies based off this information and discuss which one is your top choice and why.
Health and beauty brand : Pick a health and beauty brand and item you use regularly; for example, shampoo, shaving cream, moisturizer, razor blades, etc. Imagine this brand is extending its reach to a new target audience with a new product.
What is the npv for the project? : If the firm uses a discount rate of 17.5 percent, what is the NPV on this project? what is the NPV of this investment?
Comprehensive financial analysis of a public corporation : Would you invest your financial capital in the selected firm as a shareholder and would you invest your human and intellectual capital in the firm as an employee?
Determine product price : A firm produces a product with a fully allocated average cost equal to $20. If the price elasticity of demand for the product is -5,what should the product price be set at
What factors affected national income : WHAT FACTORS AFFECTED NATIONAL INCOME, UNEMPLOYMEY RATE AND INFLATION RATE WHAT FACTORS EFFECT EACH OF THESE ECONOMIC VARIABLES?
Examine the influence of the vibration on the grain size : Examine the influence of the vibration on the grain size, microstructure and mechanical properties of aluminium-silicon alloys (Al-Si) during solidification.
Identify and describe components of communication process : Identify and describe the components of the communication process? How can knowing the components in the communication process help a person become a more effective communicator?

Reviews

Write a Review

Financial Management Questions & Answers

  Size-up hcm using historical ratio analysis

Value the business from the potential buyer's (Great Wall) viewpoint, considering the changes that it will make, explaining fully.

  Report annual cash flows

Briefly explain why you are using the computational method chosen. (Hint: you will need to decide to use the APV or WACC formula.

  Prepare a wac io and po tranche

Prepare a WAC IO and PO tranche to give a 5.75% deal coupon. Create a PAC class (A-1) with an initial collar of 50%-200% PPC, assuming base case defaults.

  Prepare a cash-flow budget and a profit budget

Prepare a cash-flow budget and a profit budget for Gringotts Ltd on the basis of Strategy 1. The budgets should be split into quarterly intervals showing cash-flow and profit forecasts for each individual quarter.

  Compute the npv for project

Compute the NPV for Project

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Prepare the business income statement for the period

Prepare the business Income Statement for the period. Prepare the Statement of Changes in Equity for the period. Prepare the classified Balance Sheet at the end of the period.

  Explain the important characteristics of this index

Develop an insight into the pricing of financial instruments

  Prepare the consolidated financial statements

Prepare all consolidation adjustment entries required to prepare the consolidated financial statements as at 30 June 2011.  Provide a brief heading for each adjustment that you prepare.

  What are factors affecting the capital structure of company

Calculate the NPV and IRR for the project from the standpoint of the parent company. What are your recommendations for the proposal?

  Consumers awareness and concerns

Collecting and using personal data: consumers' awareness and concerns

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

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