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.

want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount.

Required:

Download spreadsheet CommonSizeCaseData$-03$a$4$d$3.$xlsx

formatting to visually differentiate between cells that reflect increases and cells that reflect decreases over a specified percentage.

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

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$