O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Dollar and Percent Changes in Statement Analysis

Another way of viewing changes over time in income statements and balance sheets is by means of dollar changes and percentage changes (see Figure 6.6). To express changes over time in terms of dollars, you consolidate two reports into one by showing—for each category—the difference in dollars between the two. Or you might decide to consolidate the information by dividing each category in one report by the same category in the other. This expresses changes over time as percentages.

Figure 6.6. With comparative balance sheets and income statements, you can better focus on changes over time by calculating year-to-year differences.

Assessing the Financial Statements

It's nearly always satisfying ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required