Using the data presented below for Blue Sky 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 worksheets.

c) Using Excel’s outlining feature, create an outline on the balance sheet that, when collapsed, shows only the subtotals for each section.






Business

You might also like to view...

______________________________ show the time periods that employees are in attendance at the job site and available for work

Fill in the blank(s) with correct word

Business

Twenty-five percent of all resumes received by a corporation for a management position are from recent college graduates. Eighteen resumes were received on a particular day. a.What is the probability that exactly 5 of the resumes are from recent college graduates?b.What is the probability that fewer than 3 of the resumes are from recent college graduates?c.What is the expected number of resumes from recent college graduates?d.What is the variance of the number of resumes from recent college graduates?

What will be an ideal response?

Business

According to the textbook, ________ has developed virtual dressing rooms that use 3D technology.

A. The Gap B. Neiman Marcus C. JC Penney D. Bloomingdale's E. Macy's

Business

The sentence for a criminal offense may be

a. a fine. b. a prison term. c. community service. d. all of these.

Business