Choose a publicly traded company nbsp home depotpart ago to

Reference no: EM13358467

Choose a publicly traded company: Home Depot

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.

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

The final report should include a 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 business and the status of financial condition such as Line of business, Competitive positions, and Profitability History (going back five years). Do not turn in a sloppy, rapidly completed report. All papers should have a title page, a table of contents, a statement of purpose, footnotes or endnotes, or a bibliography or reference. The due date for submitting your project is the last date of the class. You will use Assignment manager to submit your project.

Reference no: EM13358467

Questions Cloud

Web servers and processorsif web servers do not need the : web servers and processorsif web servers do not need the fastest processors. yet when we look at the manufacturers and

What negative can you see about buying microsoftit used to : what negative can you see about buying microsoft?it used to be said no one was ever fired for buying ibm. in the 1990s

Provide some detailed information on the following- how : provide some detailed information on the following- how does a business stay ahead of technological advances?- what are

Ldquohow is the traditional use of the concept of : ldquohow is the traditional use of the concept of patriarchy by feminist researchers on violence against women limited?

Choose a publicly traded company nbsp home depotpart ago to : choose a publicly traded company nbsp home depotpart a.go to compustat research insights reuterrsquos thomson financial

Economic formulas are available to compute annual payments : economic formulas are available to compute annual payments for loans. suppose that you borrow an amount of money p and

Piecewise functions are sometimes useful when the : piecewise functions are sometimes useful when the relationship between a dependent and an independent variable cannot

Qestion evaluate e-5 using two approachese-x 1 ndash x : question evaluate e-5 using two approachese-x 1 ndash x x22 ndashx33-----ande-x 1exnbsp 11xx22 x33

Question recall the velocity of the falling parachutist can : question recall the velocity of the falling parachutist can be computed byvt gm1-e-cmxcnbspuse first order error

User Account

All Pages