Qn (b) and (c)

Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Skv Inc.: a) Create Blue Sky's income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Improve the readability of the data by using the format explained on page 49 , so that Excel will display the numbers as if they had been divided by 1,000. Make the appropriate note on the heading of each financial statement. b) On another worksheet, create a statement of cash flows for 2017. All formulas should be linked directly to the source on previous workshcets. c) Using Excel's outlining feature, create an outline on the balance sheet that, when collapsed, shows only the subtotals for each section. Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Skv Inc.: a) Create Blue Sky's income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Improve the readability of the data by using the format explained on page 49 , so that Excel will display the numbers as if they had been divided by 1,000. Make the appropriate note on the heading of each financial statement. b) On another worksheet, create a statement of cash flows for 2017. All formulas should be linked directly to the source on previous workshcets. c) Using Excel's outlining feature, create an outline on the balance sheet that, when collapsed, shows only the subtotals for each