Docstoc

Rate Sheet Templates for Windows - Excel

Document Sample
Rate Sheet Templates for Windows - Excel Powered By Docstoc
					Instructions for the Microsoft Excel Templates

Advisory - The worksheets are not protected. You can over type any data within the worksheets. If you
over type important data you can usually restore it by referencing your textbook.


Detail and information on Excel 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.

Type your name into the cell to the right of the "Name" cell. Your name will appear on each printed sheet.

Type your course identity or instructor identity into the cell to the right of "Course." This information
will appear on each printed sheet.

It is recommended that you enter the due date of your assignment in the cell to the right of the "Date" cell.

If the workbook requires more than one printed sheet, your name, course, date, and the first exercise or
problem line will appear on each sheet.

If the workbook requires more than one printed sheet page breaks are already set for normal bond - 8
1/2 X 11" paper.

The print area of the exercise or problem is defined by the grey filled cells. These grey filled cells are
the cells immediately outside the print area.

Each worksheet will also contain a footer that includes the exercise or problem identity, the tab you
printed, the page of pages, the time, and date you printed the worksheet.

The exercises and problems may be presented slightly different than in your textbook. This is to
facilitate better utilization by the formulas available to you with Excel.

Cells that contain data that can be used by the formulas of Excel in the solution of the exercise or
problem are usually framed with black lines to help you identify those values.

Place an account name or title, such as "Cash," where "Account" or "Account title" appear.

Place a line title, such as "Net income," where "Title" or "Text Title" appear.

Place a value, such as "8.50," where "Amount" or "Value" appears.
Place a number, such as "3," where "Number" or "Quantity" appears.

The terms "Amount" and "Value" generally refer to values such as $85.97 while the terms "Number"
and "Quantity" refer to the numerical refer to 3 units or 5 years.

Where text or memorandum lines are desired for journal entries, a line below the journal entry is
provided.
When an exercise or problem requires a text entry, such as "Based on the information, which option
would you recommend?" a formatted text box is provided. This is usually identified with "Enter your
text answer here" or "Place text answer here" type text. Simply click into the cell and over type the

Insert the account number where "ACCT #" appears on the template during posting.

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

The cells of the exercises and problems are already formatted for the data. No adjustment should be necessary.

Dates should be entered as "06/06/08." This will ensure that Excel will present it properly.

Negative values should be preceded by a "-" (negative sign). Negative values may be shown as ($400)
vice -$400.

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




e "Date" cell.
uld be necessary.
          Name: Solution
        Course:
           Date:
P12-1A – Compute annual rate of return, cash payback, and net present value
Managerial Accounting, 4th Edition, by Weygandt, Kieso, and Kimmel
Solving Managerial Accounting Problems Using Microsoft Excel for Windows
           by Rex A Schildhouse

Problem P12-1A The Three Stooges partnership is considering three long-term capital investment proposals. Each
investment has a useful life of 5 years. Relevant data on each project are as follows:

                                         Project Moe                       Project Larry                  Project Curly
                 Capital investment:       $150,000                           $160,000                       $200,000
                      Salvage value:              $0                                $0                             $0
          Annual net income:
                 Year:        1               13,000                             18,000                          27,000
                              2               13,000                             17,000                          22,000
                              3               13,000                             16,000                          21,000
                              4               13,000                             12,000                          13,000
                              5               13,000                              9,000                          12,000
                            Total:           $65,000                            $72,000                         $95,000

Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is:                15%

Instructions:
(a) Compute the cash payback period for each project. (Round to two decimals.)

             Project Moe
                     Depreciation = Area for formula
             Cash payback period = Area for formula

                    Project Larry                                                                  Project Curly
Depreciation =                                                             Depreciation =
                   Area for formula                                                               Area for formula

              Annual               Cumulative                                                 Annual                      Cumulative
                      Depreciation                                                                     Depreciation
   Year        Cash                   Cash                                      Year           Cash                          Cash
                        Value:                                                                           Value:
              Inflow:                Inflow:                                                  Inflow:                       Inflow:
     1         Amount     Amount       Formula                                   1              Amount     Amount               Formula
     2         Amount     Amount       Formula                                   2              Amount     Amount               Formula
     3         Amount     Amount       Formula                                   3              Amount     Amount               Formula
     4         Amount     Amount       Formula                                   4              Amount     Amount               Formula
     5         Amount     Amount       Formula                                   5              Amount     Amount               Formula

Area for formula                                                           Area for formula
Area for formula                                                           Area for formula
Area for formula                                                           Area for formula




      FileName: 6d21d2b3-2502-4670-9559-5a32fa2c97c7.xls, Tab: Problem P12-1A, Page 5 of 6, 11/14/2010, 12:55 PM
          Name: Solution
        Course:
           Date:
P12-1A – Compute annual rate of return, cash payback, and net present value
(b) Compute the net present value for each project. (Round to nearest dollar.)

                                                 Project Moe                Project Larry              Project Curly
                         Discount           Cash                         Cash                      Cash
              Year        Factor            Inflow         PV           Inflow          PV        Inflow           PV

               1           Formula         Amount          Formula       Amount       Formula       Amount          Formula
               2           Formula         Amount          Formula       Amount       Formula       Amount          Formula
               3           Formula         Amount          Formula       Amount       Formula       Amount          Formula
               4           Formula         Amount          Formula       Amount       Formula       Amount          Formula
               5           Formula         Amount          Formula       Amount       Formula       Amount          Formula
             Total                        Formula          Formula       Formula      Formula       Formula         Formula
                              Capital investment:          Amount                     Amount                        Amount
           Positive (negative) net present value:          Formula                    Formula                       Formula

(c) Compute the annual rate of return for each project. (Round to two decimals.) (Hint: Use average annual net income in
your computation.)

                       Project Moe Area for formula

                      Project Larry Area for formula

                      Project Curly Area for formula


(d) Rank the projects on each of the foregoing bases. Which project would you recommend?

                                                                         Net        Annual
                                  Project            Cash Payback      Present      Rate of
                                                                        Value       Return
                               Project Moe              Number         Number       Number
                               Project Larry            Number         Number       Number
                               Project Curly            Number         Number       Number

Enter your text answer here.




     FileName: 6d21d2b3-2502-4670-9559-5a32fa2c97c7.xls, Tab: Problem P12-1A, Page 6 of 6, 11/14/2010, 12:55 PM

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:242
posted:11/14/2010
language:English
pages:6
Description: Rate Sheet Templates for Windows document sample