Calculate selected ratios and obtain industry averages

Assignment Help Financial Management

Reference no: EM13883301 , Length: 3

Requirements

(1) Select a company and copy/paste its financial statements

Select a public corporation from US (other than a financial institution or utility such a telephone, electric or gas company), and find its financial statements at https://moneycentral.msn.com. Avoid companies that show Net Losses in either of the last two years:

On the menu of topics at the top, click on "Investing", "Stocks". In the "Name or Symbol" box, type in the name or the stock symbol of the company you have selected. Under "Research" and "Financial Results" in the column on the left, select "Statements". In the dropdown menu select each of the three financial statements and copy/paste them onto separate pages of a single Word document.

(2) Calculate selected ratios and obtain industry averages for comparison

For each of the financial statement ratios listed below calculate the ratio for the current year and for the prior year. (Note that in most textbooks, some of the ratios call for averaging the beginning and ending balances. However, for this project, use only the year's ending balances.) After calculating the ratio, compare your calculations with the industry ratio as shown in Moneycentral's "Key Ratios" under "Financial Results". Note that there are six or seven groups of ratios in which these ratios might be contained:

A. Current Ratio

B.Inventory turnover
(not applicable to service companies)

C.Debt to Equity ratio (Total liabilities divided by Total equity)

D.Net Profit Margin (Net Income as a percentage of Sales)

E. Return on Equity

F. Price earnings ratio (P/E Ratio) [Divide the current market price from a recent newspaper listing by the "basic" earnings-per-share shown on the most recent year's income statement.

Note: The Price/Earnings Ratio (PE Ratio) changes daily with the stock price.

(3) Using Microsoft Word, write a paper (three to five typewritten pages, 1½ line spacing) containing the following:

(a) A paragraph which describes the primary business activity of the company

(b) A table listing the financial statement ratios listed above in which you list ratio figures for the most recent full year, prior year and industry average.

(c) A paragraph for each of the ratios listed above in which you explain what the ratio means and how it should be interpreted, and comment on the trend from last year to this (favorable or unfavorable), and how your company's current year compares with the average for its industry.

(d) Earnings Per Share trend is the principal benchmark for investors. Use Excel to present a bar graph showing Earnings Per Share for the last three to five years (EPS figures for several years are generally shown in the Annual Report).

(e) After commenting on each ratio individually, write a summary paragraph which presents your assessment of (1) the company's liquidity and debt situation, and (2) its profitability.

(f) State your opinion about the company's ability to generate a positive cash flow from operations. Refer to the trend in the Net Cash Provided by Operating Activities as shown in your company's Statement of Cash Flows.

(g) Find a recent (less than 6 months old) news article about your company that been published either in print media or on some internet website other than the company's own website, and write a paragraph in which you cite the article's title, author, publication and date, and summarize what the article is about.

In addition to Moneycentral, the following websites might contain recent news articles for the company you selected:
https://quote.yahoo.com

Reference no: EM13883301

Questions Cloud

Workpaper elimination entries for a downstream sale : Frazer Corporation purchased 60 percent of Minnow Corporation's voting common stock on January 1, 20X1, at an underlying book value.

What item are you going to make and sell : What is the total amount of money you are willing to invest in this business and what item are you going to make and sell? Why?

Write about computer security affects you at school : Write about computer security affects YOU at school and in your personal life. You may be surprised at how many things you do that depend on some aspects of secure computer records and communications, like banking, grades, e-mail, timesheets, libr..

What is your plan for reducing inpatient falls : JC has given you 5 months to improve your fall precautions and will be revisiting your facility in 2 months. What is your plan for reducing inpatient falls? Please use at least two evidence based practices that have proven to reduce inpatient fall..

Calculate selected ratios and obtain industry averages : Calculate selected ratios and obtain industry averages for comparison and select a company and copy/paste its financial statements

Companies to compare- boston consulting group and adobe : Companies to compare: Boston Consulting Group, Adobe, and Intel. Your team has been charged to examine organizations that promote diversity

What are some forces operating in society : What are some forces operating in society that reduces the likelihood of a society becoming a more high-synergy society

What are the various components of a diverse workforce : What are the various components of a diverse workforce? What is diversity management? How can firms benefit from implementing diversity management programs

What is sustainability in the hospitality industry : Sustainability http://www.4hoteliers.com/features/article/6618 and Why Go Greenhttp://green.hotelscombined.com/Gyh-The-Business-Case-For-Sustainability.php. What is sustainability in the hospitality industry? What is the history of sustainabil..

User Account

All Pages