Common$-$Size Financial Statement Analysis Using Excel

Completing this activity will help you learn to:

create Excel formulas using cell references.

create absolute cell references to perform calculations efficiently and correctly.

apply conditional formatting to highlight cells based on criteria that you specify.

items relative to overall sales. You also want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount.

Required:

Download spreadsheet CommonSizeCaseData$-21$a$92$b$.$xlsx

analysis. Further, you will use conditional formatting to visually differentiate between cells that reflect increases and cells that reflect decreases over a specified percentage.

HINT: STEP$-$BY$-$STEP WALKTHROUGH

have no data.

create just one formula in cell B$2$ that can be copied and pasted to all cells? Note that there are negative values in the Financial Statement Data sheet. Choose the correct formula.

I. $=$'Financial Statement Data'!$B$2/\text{'}$Financial Statement Data'!B$2$

II$.=$'Financial Statement Data'!B$2/\text{'}$Financial Statement Data'!$B$2$

III. $=$'Financial Statement Data'!B$2/\text{'}$Financial Statement Data'!B$$2$

IV$.=$'Financial Statement Data'!B$2/\text{'}$Financial Statement Data'!$B$2$