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

Assignment Help:

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.  

 


Related Discussions:- Chart the historical prices based on the monthly data

Standara deviation - measure of dispersion , STANDARA DEVIATION Standa...

STANDARA DEVIATION Standard  deviation  is the  square  root of the  arithmetic  average of  squares of all  the deviations from the  mean. In short  it may  be defined  as th

B. A paper mill produces two grades of paper viz., b. A paper mill produces...

b. 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 pape

Ranganathan''s principles, Ranganathan's Principles: Perhaps it would ...

Ranganathan's Principles: Perhaps it would be worthwhile to consider the Five Laws of Library Science of Dr. S. R. Ranganathan as the basic guidelines for formulating the obje

Assignment problem, a c++ program to implement assignment problem??????????...

a c++ program to implement assignment problem???????????

Describe the service tax law in usa and concept of negative, Question 1 ...

Question 1 X Ltd. has Unit C which is not functioning satisfactorily. The following are the details of its fixed assets: Asset Date of acquisiti

Testing operation research model, After testing the model and its solutio...

After testing the model and its solution the next step of the study is to establish control over the solution by proper feedback of the information on variables which deviated

Inherent limitation concerning mathematical expressions, Operation reac Inv...

Operation reac Involves the use of mathematical models, equations and similar other mathematical expressions. Assumptions are always incorporated in the derivation of an equa

Line balancing methods - heuristic approach, Line Balancing Methods - Heuri...

Line Balancing Methods - Heuristic Approach  Heuristic mean serving to find i.e. to find out discover things for oneself. Heuristic describes a particular approach to problem so

Scope of operations research, Scope of the OR techniques can be derived ...

Scope of the OR techniques can be derived in followings various importance fields: 1. In Agriculture : With the explosion of population and consequent shortage of food O

Operation research, different classification of models in operation researc...

different classification of models in operation research

Write Your Message!

Captcha
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