A Discounted Cash Flow Analysis Problem

An Outpatient Radiology Center has been presented with a proposal to offer a new diagnostic procedure that would require the purchase of a new ultrasound unit. This piece of equipment offers physicians the opportunity to diagnose many types of peripheral blood flow and blood clotting disorders. You have been asked by the Center's 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 $5\%$ discount rate for projects of this risk level, and that they will initially 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 equipment is expected to generate gross revenues of $$160,000$ each year in the first two years and is expected to be $$200,000$ each year in the next two years, followed by $$275,000$ in the fifth year. The services will be paid for by third parties and there is a demand for this new service. Since the third$-$party payers will pay less than the full charge, assume that deductions from revenue to average $20\%$ of gross revenues in each of the five years. The equipment cost is $$475,000$ and will cost $$40,000$ to install. After five years the equipment will be retired, and it is expected that it could be sold for $$47,500.$

The costs for the service include part$-$time staffing costs of $$15,000$ and supply costs of $$9,000$ in each of the first two years. For the following two years, salaries are expected to be $$19,000$ and supplies are estimated to be $$13,000$; and in the last year five, salaries are expected to be $$26,000$ and supplies are expected to be $$20,000.$ The equipment is under warranty in the first year so there is no extra fee paid. A maintenance contract costing $$6,000$ per year will be paid in years $2$ through $5.$

Required:

Use the template spreadsheet and $8-$step process to enter the above assumptions in the appropriate cells.

Compute the Net Present Value of Future Cash Flows, and the Internal Rate of Return. Highlight in yellow those two answers on your spreadsheet. Note those answers in the table below so that they are in both places.

Note at the bottom of the schedule whether this is an attractive project from a purely financial point of view based upon the numbers that you calculated on the spreadsheet. Why did you make that decision? Note your answers in the table below so that they are in both places.