Explore BrainMass

Explore BrainMass

    Trend Analysis and Forecast for EI DuPont de Nemours & Co.

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

    Trend and Ratio Analysis

    Perform trend and ratio analysis on the following for EI DuPont de Nemours & Co. (DD):

    1. Current assets
    2. Fixed assets
    3. Current liabilities
    4. Long-term liabilities
    5. Owner's equity
    6. Sales revenue
    7. EBIT
    8. EPS

    Project this into three years.

    The balance sheet is attached.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:30 pm ad1c9bdddf
    https://brainmass.com/business/finance/trend-analysis-and-forecast-for-ei-dupont-de-nemours-co-282121

    Attachments

    Solution Preview

    The key to trend analysis is finding the percentage change from one year to the other. Usually, the previous year is used as the base.

    For example, let's say that you are conducting trend analysis for the years 2001 and 2002. When you fins the percentage ...

    Solution Summary

    If you are asked to project into the future, the easiest way to do so is to calculate the average percentage change and carry it across to the fore casted years.

    For example, let's say you are given the figures for 2006, 2007 and 2008 and you are asked to forecast for 2009 and 2010. After you find the percentage change for 2006. 2007 and 2008, take the average of the percentage change. Then grow the 2008 amount by the average for 2009. Then for 2010, the 2009 amount is grown by the average percentage change.

    SEE THE ATTACHED EXCEL FILE FOR NUMERICAL SOLUTION.

    $2.19

    ADVERTISEMENT