instructions are in the “guide” document

# excel sheet

“Calexico Hospital plans to invest in a new MRI. The cost of the MRI is $3,000,000. The machine has an economic life of five years, and it will be depreciated over a five‐year life to a $500,000 salvage value. Additional revenues attributed to the new machine will amount to $3,000,000 per year for five years. Additional operating costs, excluding depreciation expense, will amount to $2,000,000 per year for five years. Over the life of the machine, net working capital will increase by $40,000 per year for five years.

Assuming that the hospital is a non‐taxpaying entity, what is the project’s NPV at a discount rate of 8 percent, and what is the project’s IRR? Is the decision to accept or reject the same under either capital budgeting method, or does it differ?”

I have provided the excel document, just plug in equations and numbers.

### Leave a Comment

You must be logged in to post a comment.