Explore BrainMass

Lowe's Home Improvements - Preparing Income Chart and Profit Sales

As the fund manager for a large mutual fund, you are preparing for a conference call with all your major investors. You plan to e-mail everyone with an attachment that will serve as a guide for the upcoming call. You know investors' time is limited, so you want to be focused in your brief report. Because there are numerous figures to discuss, you will be including 1 or more charts all in the same document.

For each of the following points, prepare both a paragraph of commentary and an appropriate chart to support it.

- Find the last 4 years' sales or net income data for a major retail corporation.
- Calculate profit as a percentage of sales; be careful to place the decimal point correctly.
- Prepare a paragraph of explanation/interpretation of the data as if this were a small part of a lengthy report to potential investors.
- Prepare a chart to display all the information in a meaningful way

Solution Preview

Please see the attached Excel sheet.

- Find the last 4 years' sales or net income data for a major retail corporation.
The last 4 year's sales and net income data for Lowe's Home Improvements has been found and shown on the excel sheet. The sales have increased from 2007 to 2008 and have slightly declined in 2009, but have sharply declined in 2010. The net income has however, steadily declined from $3105 million in 2007 to $1783 in 2010. The period shows the effort of Lowe to keep up the sales of the company. It has

- Calculate profit as a ...

Solution Summary

The response is given in 383 words of explanation of how to find sales and income and interpret data in addition to an Excel attachment holding the required calculations and charts.