Calculate Percentage Changes in Excel Financial Statements


show more Calculating percentage changes in financial statements provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Financial Analysis show less
please wait ...

Calculating percentage changes in financial statements

When you analyze a company's performance, it's often useful to see how much the company's revenue or expenses have increased or decreased since the last month quarter or year. Some company's annual reports include calculations indicating these changes, but if they don't, you can create formulas to calculate that difference quickly and easily, especially if you store your data using an Excel table. So the first step is to input your data into an Excel table. I have one here in my Percentage Change worksheet. I have the values for operating cost, selling, general and administrative, basically operating costs and expenses for fiscal year 2008 and fiscal year 2007.

Once again, my goal is to calculate the percentage change from 2007 to 2008. To do that, you create a formula, where you subtract the previous year's value from the current year value and then divide it by the previous year to calculate the change. So when you put that into operation, you type in =, the pr...

Calculating percentage changes in financial statements
Video duration: 2m 54s 2h 18m Intermediate

Viewers:

Calculating percentage changes in financial statements provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2007: Financial Analysis

Subject:
Business
Software:
Excel
Author:
please wait ...