Determine the irr for both projects

Assignment Help Cost Accounting
Reference no: EM13499206

Calculations: Analytic Methods for Financial Decision Making

Determining how to make a capital investment decision using financial techniques is an essential aspect of long-term financial decision making.

To prepare for the Calculations, review the sections of Chapter 7 ("The Investment Decision") from your Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applications textbook that explain how to analyze capital investment decisions using financial techniques. (The pertinent section of Chapter 7 to review for each type of Calculation is identified in the below list of Calculations.) Then, read scenario #15 (Goodbar Practice) on page 298, which contains the information that you will use to populate and perform the Calculations.

Complete the following Calculations and submit your completed Calculations in an Excel spreadsheet with three tabs-one tab for each of the following Calculations and with that particular tab reflecting only the result of that particular Calculation.

1. Determine the payback for both projects.

Note: For detailed information on how to perform this type of Calculation, review the section "Payback Method" and Exhibit 7-2 "Cash flows for two alternative project investments" and Exhibit 7-3 "Calculation of payback year for two alternative investments" on pages 278 and 279, respectively, of the Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applications textbook.

2. Determine the IRR for both projects.

Note: For detailed information on how to perform this type of Calculation, review the section "Unequal cash flows" and Exhibit 7-8 "Using Excel to Calculate the IRR...that yields unequal operating cash flows..." (This can also be used for equal cash flows) on page 288 of the Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applications textbook.

3. Determine the NPV at a cost of capital of 12 percent for both projects. Which project should be chosen? Explain.

Note: For detailed information on how to perform this type of Calculation, review the section "Using spreadsheets to calculate NPV" and Exhibit 7-6 "Using Excel to calculate the net present value of unequal annual cash flows" (This can also be used for equal annual cash flows) on page 286 of the Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applications textbook.

Questions Cloud

 The ashford university library contains company profiles : Using the concepts from this course, you will analyze the strengths and weaknesses of the company and write a report either recommending or not recommending purchase of the company stock. Find the volume flow rate of the gas : A venturi meter is a device for measuring the speed of a fluid within a pipe. The drawing shows a gas flowing at a speed v2 through a horizontal section of pipe whose cross-sectional area A2 = 0.0600 m2. Find the volume flow rate Q of the gas How long does it take the cable to unwrap : Starting from rest, a constant force F = 100 N is applied to the free end of a 45-{\rm m} cable wrapped around the outer rim of a uniform solid cylinder, How Long does it take the cable to unwrap Compute the magnitude and the direction of magnetic field : A group of particles is traveling in a magnetic field of unknown magnitude and direction. compute the magnitude and the direction of the magnetic field Determine the irr for both projects : Determine the NPV at a cost of capital of 12 percent for both projects. Which project should be chosen? Explain. Find how far does the point where the two wires meet move : Two steel wires of the same length, one with radius r and the other with radius 4r, are connected together, end to end, and tied to a wall. How far does the point where the two wires meet move Obtain the density of the liquid : A U-shaped tube is partly filled with water and partly filled with a liquid that does not mix with water. what is the density of the liquid How fast does the water move through the nozzle : A garden hose of inner radius 1.1 cm carries water at 1.8 m/s. The nozzle at the end has radius 0.25 cm. How fast does the water move through the nozzle Determine the overall magnification of the system : Two converging lenses having focal lengths of f1 = 10.9 cm and f2 = 20.0 cm are placed d = 50.0 cm apart. What is the overall magnification of the system

Write a Review

Question we care is an outpatient surgical clinic that was

question we care is an outpatient surgical clinic that was profitable for many years but medicare has cut its

Question a firm has established standards as givendirect

question a firm has established standards as givendirect material 3 pounds 4pound 12 per unitdirect labor 2 hours

Case sanders cycle company job order costingsanders cycle

case sanders cycle company job order costingsanders cycle company is a family-owned bicycle manufacturing company

Capital intensive method labor intensive method

Explain the circumstance under which the Sanchez Company should employ each of the two manufacturing methods.

Using the direct method of presenting cash flows

Using the direct method of presenting cash flows from operating activities, prepare a Statement of Cash Flows in accordance with AASB 107 for the year ended 30 June 2012, including a reconciliation of cash flows arising from operating activities a..

Explain how cvp analysis may be helpful in evaluating

Explain how full-absorption costing can be abused by management to misstate financial results and Explain how CVP analysis may be helpful in evaluating whether it will be smart to buy a new machine that would reduce labor costs by 60%.

On 31st december 2011 rollo company held the subsequent

on 31st december 2011 rollo company held the subsequent short-term investments in its portfolio of available-for-sale