Calculate the ratios based on the financial statement

Assignment Help Financial Management
Reference no: EM131007641

Preparation:

Select a U.S. public company and obtain electronically the annual financial statement information (e.g. from 10-K filings) for that company for the most recent five fiscal years (minimum). While it is not necessary for you to print these financial statements, you may find it helpful to print certain sections to assist in responding to the questions (e.g. the four financial statements, certain footnotes, business summary, segment information, MD&A, etc.). It would be beneficial for you to select a company with which you have some level of understanding and for which the required financial data required to complete this group project is available for at least five years. I encourage you to read all the requirements before finalizing your company selection, so you can be confident you will be able to fulfill all of the requirements in a capable manner with the company you are choosing.

Requirements:

1.

(a) Which company did you choose?

(b) Provide a brief introduction to your company, which should include the following elements:

(1) presenting its background/history;

(2) describing its primary line(s) of business;

(3) identifying the industry in which it operates and providing a brief overview of the industry;

(4) listing some of its closest competitors and providing basic financial data to offer some perspective into these companies' operations; and

(5) explaining some of the key economic, demographic, cultural, and/or political trends that present both opportunities and threats for your selected company in the years ahead.

2. Prepare the following financial statement schedules:

a. Summary balance sheet information for a minimum of five years for your company and at least one competitor. Include common size ratios as part of this schedule in an appropriate format.

b. Summary income statement information for a minimum of five years for your chosen company and at least one competitor. Include year-over-year and cumulative average growth rates for each income statement line item in an appropriate format as well as appropriate common size ratios for each year of information provided.

Please be sure to include appropriate headers for each of the statements, and take care to preserve formatting to ensure the financial statements are easily readable. Relative to each of the financial statements, provide a succinct written evaluation of the company's change in financial position (or performance) over the years presented (e.g. time-series) and relative to the selected competitor(s) (e.g., cross-sectional).

3. Calculate the following ratios based on the financial statement information provided in Section Two for a minimum of five years and comparable ratios for at least one competitor (note: you may need to obtain additional "beginning balance" F/S data to calculate certain ratios including an "average"):

a. Profitability ratios (six total): return on assets, return on common equity, profit margin, gross profit margin, free cash flow on common equity, free cash flow over sales

b. Activity ratios (six total): asset turnover, inventory turnover, accounts receivable turnover, days inventory held, days sales outstanding (A/R)

c. Short-Term Liquidity (two total): current ratio, quick ratio

d. Long-Term Liquidity (two total): long-term debt-to-assets, operating cash flow to total liabilities, interest coverage

For each of the above ratio categories (e.g. profitability ratios, activity ratios, etc.), provide a succinct, but professionaly, written summary evaluating the company's financial position (or performance) in the current year as compared to the previous years (time-series) and relative to the selected competitor(s) performance (cross-sectional).

4. Using the financial statement trends you highlighted above and additional financial information from the most recent 10-K as necessary, forecast the company's earnings (income statement) for a minimum of three years. In addition, forecast operating cash flows, free cash flows, total assets and book value (assets - liabilities) for each of the three forecasted years.

Hint: using disaggregated segment and/or product line information will allow for more accurate forecasting. Provide a brief written summary, which outlines your forecasting assumptions.

5. Using the forecasts completed in the preceding section, estimate the company's valuation using the discounted cash flows (DCF) approach. As a second valuation approach, use an appropriate P/E multiplier to estimate the future share prices of the company based on each of the three years' forecasted earnings from Section Four. Provide a brief written statement explaining why you chose the corresponding P/E ratio(s) and discount rate(s) used in these valuation analyses. In addition, provide a recommendation (buy, hold, sell) based on the calculated equity valuation.

Attachment:- Assignment.rar

Reference no: EM131007641

Questions Cloud

Discuss the diathesis-stress model : Discuss the diathesis-stress model as it pertains to schizophrenia. Explain the causal factors associated with the disorder
Explain how different levels of technology have shaped : Explain how different levels of technology have shaped the development of five types of human societies over time. Describe how people in each of those societies use available technology as part of their way of life
Determine the principal stresses and draw the mohr circle : For a critical three-dimensional state of stress where, sx = 45,000, sy = 25,000, sz = -50,000, txy = 4000, tyz = 2000, and tzx = -3500 psi, determine the principal stresses and draw the Mohr circle representation of the state of stress.
Pros side of the confirmation proposal : Write approx 1500 Words essay on Pros side of the confirmation proposal. Why it is important. Describe.
Calculate the ratios based on the financial statement : Identifying the industry in which it operates and providing a brief overview of the industry - listing some of its closest competitors and providing basic financial data to offer some perspective into these companies' operations.
Describe how a quasi-experimental design : Describe how a quasi-experimental design, specifically a simple time-series design, might be used by the scientist as part of the program evaluation. Be sure to provide details regarding relevant procedures and measures for this type of design
A foreign policy created after the civil war : Introduce your paper with your previously crafted thesis statement.Discuss two (2) international events involving the US military from the past five (5) years that can be traced back to a foreign policy created after the Civil War.Discuss three (3) a..
Write a short paper dealing with the structure : Write a short paper dealing with the structure/function of the cell type you selected. Focus on interesting aspects of the cell, how it differs from "typical" cell" and what further information would be interesting based on future research.
The women''s movement in the united states : The last part of the question as the book doesn't provide any other arguments other than suffrage that answer the last part of the question. also is woman suffrage movement the same as reformist?By the late 1800s, the women's movement in the United S..

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  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.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

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

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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