DuPont Analysis Model

DuPont Analysis Model

The DuPont Analysis model provides a more detailed analysis from a standard 3 statement model. On top of the 3 statement model, this includes financial ratios to measure different KPIs of the business and Pyramid analysis to summarizes these ratios over a 5-year period. Included in the template you will find:

• The Income Statement, Balance Sheet, and Cash Flow Statement
• An Assumptions Section with key drivers for the business
• Supporting Schedules Section for PPE and Long-Term Debt
• Financial Ratios and a Pyramid Analysis

First in the DuPont Analysis is the Assumptions sections where assumptions are entered in the cells for the projection periods. All assumptions can be modified to fit specific key drivers of the business to see their impact to the 3 statement model. Up to 3 years of historical data are entered into the income statement, balance sheet and cash flow statement; the following projected years are driven by formulas from the Assumptions section.

The Supporting Schedules section of the DuPont Analysis is all formulas that are tied to the Assumptions and 3 Statement sections, so no editing is necessary. The Financial Ratios section calculates a variety of KPIs that can be used to measure different aspects of the business. Lastly, the Pyramid Analysis provides the financial ratios in a summary format for the projected 5 years.

All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model. Sections are grouped to condense the model to view sections individually.