E-trade financial learning center

Assignment Help Corporate Finance

Reference no: EM13551488

Choose a publicly traded company 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 to chart the historical prices (like the one below) based on the monthly data.

2122_Financial statements.png

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

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

Chart of monthly stock price movements described in part A and the financial ratios in part B above.

Based on the materials provided in the annual report and business news from The Wall Street Journal, as well as the financial information from any other sources, such as Datastream, Reuters, and Bloomberg Financial, explain as much as you can the movement of your stock during the last twelve months. Your report should start with a description of the businessand the status of financial condition such as Line of business, Competitive positions, and Profitability History (going back five years).

Reference no: EM13551488

Questions Cloud

The acquisition was successful home depot company : The acquisition was successful Home Depot Company

Inpatient and outpatient revenue and expense : Budget assumptions for this exercise include both inpatient and outpatient revenue and expense.

Market interest rates can hurt saving institutions : What changes in market interest rates can hurt saving institutions? why? what can saving institutions do to minimize their problems? explain the kind of market interest rate changes that might help saving institutions.

A financial adviser working for an international mutual fund : A financial adviser working for an international mutual fund

E-trade financial learning center : Calculate the financial ratios using only one year data. Citibank doesn't have inventory because it's a financial company.

Estimate the gravitational acceleration at surface of mars : if the mass of Mars is 0.107 times that of Earth, and its radius is 0.530 that of Earth, estimate the gravitational acceleration g at the surface of Mars

Source of capital target market portfolio : Source of Capital Target Market Portfolio

Estimate what quantity of ice melts : A 4.60-g lead bullet at 34.0°C is fired at a speed of 260 m/s into a large block of ice at 0°C, in which it becomes embedded. What quantity of ice melts

What is the final temperature of the water-horseshoe system : A 1.50-kg iron horseshoe initially at 610°C is dropped into a bucket containing 17.0 kg of water at 26.0°C. What is the final temperature of the water-horseshoe system

User Account

All Pages