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

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

Significance, significance of operation research in modern management

significance of operation research in modern management

Modeling process, What are the basic 5 elements of modeling process

What are the basic 5 elements of modeling process

one tailed test diagrams - hypothesis testing, Normal 0 false ...

Normal 0 false false false EN-IN X-NONE X-NONE

Presentation - report writing presentation , Presentation After  the c...

Presentation After  the completion of any  research  project the concept  techniques  and results  of the  research  projects  should  be presented to the  audience of interes

Steps involved in hypothesis testing of the mean , Statement of Hypothesis...

Statement of Hypothesis The  two hypothesis  i  ,e,  null hypothesis  (H 0 ) and Alternative Hypothesis (H 1 ) are so  constructed  that if  one is  correct the other  is wron

International trade, why does south africa regulate int''l trade

why does south africa regulate int''l trade

Analyzing marketing problems and cases , Cases are generally based on certa...

Cases are generally based on certain issues and problems. Diagnostic, analytical and decision making skills help in case solution. A case study or case based assessment is designed

requirements and characteristics of a good table , Requirements and Charac...

Requirements and Characteristics of a good table In the words  of Mr. Harry Jerome a good statistical table  is a triumph of ingenuity and  technique masterpiece of economy  o

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