Chart the historical prices based on the monthly data, Operation Research

Choose a publicly traded company (NYSE, AMX, or OTC) that interests you. If you don't know how to choose a company, think of IBM, DELL computer, Nike, Apple computer, GM, Ford, Nokia, Home Depot, and on and on. Think of the companies that make things you use everyday. Choose one from them. 

Part A.

Go to COMPUSTAT Research Insights, Reuter's, Thomson Financial Service, or Bloomberg Financial (E-Trade Financial Learning Center has them all) or any other financial database such as Yahoo Finance to download the historical closing prices (five years) of your company on the monthly basis (twelve data points a year).  Use Microsoft Excel or any other program to chart the historical prices based on the monthly data. (Getting to know these financial databases is one of the objectives of this project)   

Part B.

Based on the financial statements of the latest available annual report, calculate the following financial ratios using only one year data. If the ratios are not available, please explain why. For example, Citibank doesn't have inventory because it's a financial company.   

(Please use spreadsheet software (MS Excel) for this part and show your calculation)  

Current ratio

Quick ratio

Inventory Turnover

Fixed assets turnover

Total assets turnover

Total debt to total assets

Profit margin on sales

Return on total assets

Return on common equity

Price/earnings ratio

Market/book ratio  

The final report should include a chart of monthly stock price movements described in part A and the financial ratios in part B above.  


Posted Date: 4/1/2013 6:48:44 AM | Location : United States

Related Discussions:- Chart the historical prices based on the monthly data, Assignment Help, Ask Question on Chart the historical prices based on the monthly data, Get Answer, Expert's Help, Chart the historical prices based on the monthly data Discussions

Write discussion on Chart the historical prices based on the monthly data
Your posts are moderated
Related Questions
Classification of documents by information Characteristics: The schemes of classification advocated by Hanson and Grogan are mainly based on the information characteristics of

Important of Probability The  various practical applications  of the  theory  of probability are: a.The fundamental  laws of statistic viz   the law  of statistical regular

Machine  Tabulation This methods  of tabulating information  is generally used in  case of extensive  large scale  surveys. Mechanical sorting and tabulating equipments and su

Institutional Characteristics:  An approach to an understanding of the fields of interest of individuals to be served and of the organisation as a whole could begin by acquiri

what is meant by Application Areas of Linear Programming?

C++ code for assignment problem

Periodical Article A periodical is a publication that is  published  periodically like  a newspaper a magazine  and a journal. Usually  periodicals have  volume numbers  and n

This is a  procedure of determining  the potential if any for improving each  of the non basic variables in terms of the objective function. To determine  this  potential  each of