Explore BrainMass

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 4, 2020, 12:40 am ad1c9bdddf

    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.