Since the formatting of the templates is not

This preview shows page 1 - 4 out of 16 pages.

through formatting for common presentation. Since the formatting of the templates is not protected by any password, you may change any of the formatting found in the templates to meet your desires. Where a yellow highlighted cell shows titles such as "Formula" you may enter the appropriate formula or enter a numerical value appropriate for that step of the challenge. Most of the values necessary for the appropriate formula are located on the template in cells with borders or in other yellow highlighted cells. The formula may be a simple "Look to" formula, an equal sign and a cell reference, "=E27" or more complex as "=E27*5," or something similar to the time-value-of-money formula. These are addressed in the tutorial text provided for Microsoft Excel.
Image of page 1

Subscribe to view the full document.

Where a yellow highlighted cell shows "Text" enter the appropriate text for that step of the challenge. This may be a memorandum entry for a journal entry or a lengthy text answer discussing the results of an analysis of a company's financials. These titles can simply be typed over. Where a yellow highlighted cell shows titles such as "Journal Number" or "Journ #" you should enter the appropriate number provided in the template and in the text for that step of the challenge. In general this will appear in instances such as "Record the following events in General Journal number six." The print area is defined to fit onto 8 1/2" × 11" sheets in portrait or landscape mode as required. Margins are generally set to no less than 1/2" so most printers can print them without a problem. If you printer cannot accept margins less than 1" you may have to reformat the margins through Page Setup. The display may have "Freeze Pane" invoked so column titles remain visible during data entry. This can be removed by utilizing the View menu and selecting "Unfreeze Panes" under "Freeze Panes." When negative values are required, enter them by starting with a minus sign, "-". Negative values may be shown as ($400) or -$400. Negative values in formulas can be created by putting a minus sign in front of the cell reference - "=E10*-E11" will return a negative value if both cells E10 and E11 contain positive values. Microsoft Office and Microsoft Excel are products of, and copyrighted by, Microsoft Corporation, One Microsoft Way, Redmond, Washington 98052-6399
Image of page 2
987b4adf2e74f9aa851952442c0257ad6d48389e.xlsx, E4-4 Solution, Page 3 of 16, 03/03/2016, 09:54:19 Name: Solution Date: Instructor: Course: Administrative expenses Officers' salaries $4,900 Depreciation of office furniture and equipment 3,960 Cost of goods sold 63,570 Rent revenue 17,230 Selling expenses Transportation-out 2,690 Sales commissions 7,980 Depreciation of sales equipment 6,480 Sales 96,500 Income tax 7,580 Interest expense 1,860 Instructions: outstanding for 2012 total 40,550 (000 omitted). WEBSTER COMPANY Multi-Step Income Statement For the Year Ended December 31, 2012 (In thousands, except earnings per share) Sales $96,500 Cost of goods sold 63,570 Gross profit 32,930 Operating Expenses Selling expenses Sales commissions $7,980 Depreciation of sales equipment 6,480 Transportation-out 2,690 $17,150 Administrative expenses Officers' salaries 4,900 Depreciation of office furniture and equipment 3,960 8,860 26,010 Income from operations 6,920
Image of page 3

Subscribe to view the full document.

Image of page 4
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern