1. On separate worksheets, create a common-size income statement and a common-size balance sheet. You should be able to do these statements fairly quickly. For each common size statement, calculate just one formula and use copy-paste-special to copy and paste the formula into all accounts. The formatting on common size statements should be identical to that in the original worksheets (only numbers format will differ).

2. Using the Excel outliner, create an outline on the cash flow statement and the balance sheet such that, when collapsed, the statements show only the subtotal for each section.

27 29 30 32