Prepare a trend analysis of operating ratios

Assignment Help Corporate Finance
Reference no: EM13211496

Your grandparents have been left a substantial amount of money and want to invest in a company. Your grandfather trusts you to make a recommendation, but he also wants to see the reasoning behind your choice.

You have an idea of which company to choose, and you decide to prepare 3 sets of documents for your grandparents to consider: business analysis, combined income and cash flow statement, and trend analysis.

Business Analysis

Select a public company that trades on either the NYSE or the NASDAQ. Perform a business analysis (both external and internal) for your company using the most recent information fromvarious sources. Possible sources include the following:

  • Annual report or form 10-K
  • Magazine or newspaper articles
  • Company Web sites
  • Government information
  • Industry information
  • Rating agencies
  • Analyst reports
  • Internet articles

Your analysis should be approximately 4 pages long with abstract and conclusion Be sure to cite your sources using APA guidelines.

Combined Income and Cash Flow Statement

Download the company's most recent annual report from its Web site or the company's form 10-K from the U.S. Securities and Exchange Commission (SEC) Web site (www.sec.gov).

  • Confirm that the firm's income, dividends, and other capital transactions explain the change in equity for the most recent year. (You may need to consult the statement of shareholders' equity.)
  • Confirm that the firm's cash flow statement begins with the same net income amounts found in the income statement.
  • Confirm that the firm's cash flow statement shows a change in cash that is equal to the difference between cash shown on the balance sheet at the beginning and end of the year. In Excel, construct a combined income statement and cash flow statement.
  • Write 1-2 paragraphs that answer the following:
    • What would you do if you found there was a huge difference in the net income amounts and the reported cash flow amounts?
    • How could technology limit the likelihood of this happening again?

Trend Analysis

Finally, prepare a trend analysis of operating ratios for at least 3 years' worth of financial data. Prepare the analysis in Excel. You may wish to create a common-sized income statement first, but it isn't required.

If you adjusted for any nonrecurring items in step 1, explain the adjustments in a separate Word document. Use any other information in your company's annual report to explain the change in revenues, gross margin percentage, and operating margin percentage. Add this information to the Word document.

Please provide all references and in-text citations

Reference no: EM13211496

Questions Cloud

Prepare a memo for the human resources manager : Prepare a memo for the Human Resources Manager and List four specific items relating to bereavement leave that will have to be addressed in the policy to ensure compliance with the standards in each jurisdiction.
What are the historical returns for markets : What are the historical returns for markets and what are the advantages and disadvantages of investing in each type of market?
Explain what is the molecular formula of maleic acid : Maleic acid contains 41.4% carbon, 3.47% hydrogen, and 55.1% oxygen by mass. A 0.030-mol sample of this compound weighs 2.61 g.
Compute the molar mass that would be obtained : Calculate the molar mass that would be obtained from the actual experimental data under the following conditions. The unknown is methyl propyl ether (CH3OC3H7)
Prepare a trend analysis of operating ratios : Prepare a trend analysis of operating ratios for at least 3 years' worth of financial data and perform a business analysis (both external and internal) for your company using the most recent information fromvarious sources.
Compute the molar mass that would be obtained : Calculate the molar mass that would be obtained from the actual experimental data under the following conditions. The unknown is methyl propyl ether (CH3OC3H7)
Explain the half-reactions and the respective standard : Based on the half-reactions and their respective standard reduction potentials below, which addition to an aqueous solution containing Fe(NO3)2 will result in a reaction under standard-state conditions?
Correlation between the above variables and sales : Create a scatterplot between the variable that you selected in requirement 2 and sales. Properly label your chart - Regression Mastery Problem
Explain shorthand notation for the galvanic cell reaction : The shorthand notation for the galvanic cell reaction Fe3+(aq) + 2 I-(aq) ? Fe2+(aq) + I2(s) requires an inert electrode on A) only on the right side of the salt bridge

Reviews

Write a Review

Corporate Finance Questions & Answers

  How many ties and scarfs should the firm

Computation of quantity to obtain required profit per process - How many ties and scarfs should the firm make to maximize its profit if they obtain $3?

  What is the payback period for project

Find the Weighted Average Cost of Capital and if Google wanted to lower their WACC, what could they do

  Compute the amount to be reported as income taxes payable

In 2012, Amirante Corporation had pretax financial income of $168,000 and taxable income of $120,000. The difference is due to the use of different depreciation methods for tax and accounting purposes. The effective tax rate is 40%. Compute the am..

  Evaluate the year-1 free cash flow

Evaluate the Year-1 Free Cash Flow in US$ for this US-based MNE -When typing in answers, do NOT use commas, currency units or %

  Selecting the correct option for expected return

Given the following data for 3 stocks, A,B,& C, and portfolios of these stocks. The stocks' returns are positively but not perfectly positively correlated with othe,

  Discuss whether leah is performing in a professional manner

Occasionally, Leah's clients will call her at the office during regular office hours. -Discuss whether Leah is performing in a professional manner. -What would you do if you were Leah? -What would you do if you were Leah's supervisor and this came..

  Identify key inflection points in the companys stock price

Select a puplicly listed company of your choosing. Identify key inflection points in the company's stock price going back three years. Analysis and discuss the impact of the various events which lead to these stock price movements.

  Find the expected return on siebling''s common stock

Select the best option of Investment among various interest compounding and find the expected return on Siebling's common stock?

  Find what is your profit

Do you buy or sell £1,000,000 in the forward market and describe what is your profit in £s if you are correct and the spot rate is £1.00/US$1.65 in a year's time?

  What is the projects payback period

What is the project's net investment outlay at Year 0 and what are the project's operating cash flows in Years 1, 2, and 3?

  How much would you pay for the stock

Evaluate how much do you need to save from year 30 to 50 to accumulate enough for your retirement fund, if the ROR is 10%

  Problem on prospect theory

Rex is a smart fellow. Rex gets an A in a course 80 percent of the time. Still, he likes his leisure, only studying for final exam in half of the courses he takes.

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