VIEWS: 242 PAGES: 6 CATEGORY: Business POSTED ON: 11/14/2010
Rate Sheet Templates for Windows document sample
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