Free Templates for Menus

Document Sample
Free Templates for Menus Powered By Docstoc
					Instructions for the Microsoft Excel Templates

Be advised, the worksheet and workbooks are not protected.

Extensive detail and information is contained within the manual.

Striking the "F1" key or following the path "Windows>Excel Help" will invoke the Office Assistant and bring up one of
several help menus.

You should enter your name, course ID, date, and instructor's name into the cells at the top of the page.

Each page contains a page footer with a Page # of Page ## as well as time and date to assist in assembly of multiple pages.


Each worksheet contains the identification of the problem or exercise.

All formatting should have been accomplished to provide satisfactory presentation. See the text for additional assistance in
formating.

If more than one page is required by the problem, the page breaks are preset.

In general, the yellow highlighted cells are the cells which work and effort should be presented.

Place the proper account title in the cell where the word "Account title" appears on the template.

Place the value in the cell where the word "Value" or "Amount" appears on the template. A formula may be placed in some
of these cells.

Write a formula into cells where the word "Formula" appears. In these cells, an amount calculated can be entered. An amount
can be placed in these cells.

Place the explanation for the entry in the cell where the word "Text Explanation" appears on the template.

Insert the account number where "Acct Nbr" appears on the template during posting.

Insert the journal reference where "JOURN #" appears on the template during posting.

Insert the title in the cell where "TITLE" appears on the template.

The print area is defined to fit onto 8 1/2" X 11" sheets in portrait or landscape mode as required.

The gray filled cells define the perimeter of the problem and the print area.

The problem is formatted for whole dollars with comma separations (no cents) except where required.

The display may have "Freeze Pane" invoked so column titles remain visible during data entry.

Negative values may be shown as ($400) or -$400.

Consider using "Split" panes to assist in copy and paste of data.



                       dfba5269-c1d5-432c-90f4-e42046d3d8e7.xls, Page 1 of 4, 11/18/20107:23 PM
Much of the exercises and problems can have data entered by the "look to" or "=A34" type formula where cell A34 contains
the data to be entered. This precludes typing and data entry errors.




                     dfba5269-c1d5-432c-90f4-e42046d3d8e7.xls, Page 2 of 4, 11/18/20107:23 PM
     Name:                                                         Date:
 Instructor:                                                   Course:
Financial Accounting, Fifth Edition by Kimmel, Weygandt, and Kieso
Solving Financial Accounting Problems Using Microsoft Excel for Windows
                              by Rex A Schildhouse
P12-7A, Prepare a statement of cash flows—indirect method, and compute cash-based ratios.
Presented below are the financial statements of Trahan Company.
                                                TRAHAN COMPANY
                                              Comparative Balance Sheets
                                                     December 31
                 Assets                                               2010         2009
                 Cash                                                    $38,000      $20,000
                 Accounts receivable                                      33,000       14,000
                 Merchandise inventory                                    27,000       20,000
                 Property, plant, and equipment                           60,000       78,000
                 Accumulated depreciation                                (32,000)     (24,000)
                 Total                                                 $126,000     $108,000
                 Liabilities and Stockholders’ Equity
                 Accounts payable                                        $24,000      $15,000
                 Income taxes payable                                      7,000        8,000
                 Bonds payable                                            27,000       33,000
                 Common stock                                             18,000       14,000
                 Retained earnings                                        50,000       38,000
                 Total                                                 $126,000     $108,000

                                               TRAHAN COMPANY
                                                 Income Statement
                                       For the Year Ended December 31, 2010
                 Sales                                                                    $242,000
                 Cost of goods sold                                                        175,000
                 Gross profit                                                               67,000
                 Selling expenses                                        $18,000
                 Administrative expenses                                   6,000            24,000
                 Income from operations                                                     43,000
                 Interest expense                                                            3,000
                 Income before income taxes                                                 40,000
                 Income tax expense                                                          8,000
                 Net income                                                                $32,000

                                                   Additional data:
 1. Dividends declared and paid were               $20,000
 2. During the year equipment was sold for                $8,500          cash. This equipment cost   $18,000
    originally and had a book value of              $8,500       at the time of sale.
 3. All depreciation expense is in the selling expense category.
 4. All sales and purchases are on account.




                       dfba5269-c1d5-432c-90f4-e42046d3d8e7.xls, Page 3 of 4, 11/18/20107:23 PM
       Name:                                                       Date:
 Instructor:                                                   Course:
Financial Accounting, Fifth Edition by Kimmel, Weygandt, and Kieso
Instructions:
(a) Prepare a statement of cash flows using the indirect method.
                                                 TRAHAN COMPANY
                                                Statement of Cash Flows
                                         For the Year Ended December 31, 2010
                   Cash flows from operating activities
                   Net income                                                                   Amount
                   Adjustments to reconcile net income to net cash
                       provided by operating activities
                   Title                                                 Amount
                   Title                                                 Amount
                   Title                                                 Amount
                   Title                                                 Amount
                   Title                                                 Amount                      0
                   Title                                                                        Formula

                  Cash flows from investing activities
                  Title                                                                         Amount

                  Cash flows from financing activities
                  Title                                                       Amount
                  Title                                                       Amount
                  Title                                                       Amount
                  Title                                                                         Formula

                  Title                                                                         Amount
                  Title                                                                         Amount
                  Title                                                                         Formula

                                                Calculation here as desired
                                                Calculation here as desired

(b) (1) Compute the current cash debt coverage ratio.

                                     Amount        +          Amount
          Amount           ÷                                                  =       Formula     Times
                                                Number

(b) (2) Compute the cash debt coverage ratio.

                                     Amount        +          Amount
          Amount           ÷                                                  =       Formula     Times
                                                Number

(b) (3) Compute the free cash flow.

                Amount           -       Amount           -       Amount          =        Formula




                          dfba5269-c1d5-432c-90f4-e42046d3d8e7.xls, Page 4 of 4, 11/18/20107:23 PM

				
DOCUMENT INFO
Description: Free Templates for Menus document sample