A Surgery Center is faced with the option of starting a new eye program. The new program requires purchasing a special microscope for the operating room. This microscope offers physicians the opportunity to do multiple types of procedures. You've been asked by the Centers administrator to use the techniques of preparing a discounted cash flow analysis to evaluate it from an economic point of view by computing the Net Present Value and Internal Rate of Return.

Assumptions:

For your analysis assume that the Center uses a 6% discount rate for projects of this risk level, and that they will use a five-year time horizon. This is a tax-exempt not-for-profit organization so there will not be any income tax effects to consider in the calculations.

The business after buying the microscope is expected to generate gross revenues of $85,000 in the first two years and is expected to grow to $110,000 per year for each of the next three years. The services will be reimbursed by third parties and there is a demand for this new service. Deductions from revenue are expected to average 50% of gross revenues in each of the five years. The equipment cost is $110,000 and will cost $15,000 to install. After five years the equipment will be retired and it is expected that it could be sold for $20,000.

The costs for the service include part-time staffing costs of $7,000 and supply costs of $3,000 in each of the first two years. For the last three years, salaries are expected to be $8,000 and supplies are estimated to be $4,000 in each of those last three years. The equipment is under warranty in the first year so there is no extra fee paid. A maintenance contract costing $3,000 per year will be paid in years 2 through 5.

Required:

Set up the spreadsheet by inputting the above assumptions in the appropriate cells.

Summarize your answer in the following table and note whether this is an attractive project from a purely financial point of view.

Summarize your answer in the following table:

Description	Your Answer
Net Present Value of Cash Flows:
Internal Rate of Return:
Is this an attractive project from a purely financial point of view based upon the numbers that you calculated above. Note why you made that decision: