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
Why Two regression Lines Once regression line  cannot  minimize the sum  of square of deviations  for both  the x and Y series  unless the relationship  between  them  indicat


#A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. Determine the optimal assignment. Which operator will have no assignment

Exercise Define the terms used in LPP. Mention the advantages of LPP. What are the assumptions and limitations of LPP? A firm produces three pro

Chi Square  Test Goodness of Fit Chi square test  can be used to find out  how well the  theoretical distribution fit  with the  empirical distribution  of observed distribut

how i make project report on "application of or".i want help from you.can you give me idea to complete this report..

Tied Ranks Equal or Repeated Rank When  two or more  items  have equal values  it is  difficult  to give ranks  to them. In  that case  the items are given  the average of the

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

MEAN DEVIATION Mean  deviation of a series is the arithmetic  average of the  deviations of various  items  from the  median  or mean  of that series. Median is preferred