Question

In: Finance

Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment....

Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment. The equipment, which cost $600,000, has an expected life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and contractual allowances, in its first year of use. Thus, net revenues for Year 1 are estimated at 15 x 250 x $80= $300,000

Labor and maintenance costs are expected to be $100,000 during the first year of operation, while utilities will cost another $10,000. The cost for expendable supplies is expected to average $5 per procedure during the first year. Cash overhead will increase by $5,000 in Year 1. All costs and revenues, except depreciation, are expected to increase at 5 percent inflation rate per year after the first year.

The equipment falls into the MACRS five-year class for tax depreciation and is subject to the following depreciation allowances:

Year

Allowance

1

0.20

2

0.32

3

0.19

4

0.12

5

0.11

6

0.06

The hospital’s tax rate is 40 percent, and its corporate cost of capital is 8%.

You can use Excel to complete this problem. If you do, please submit your homework document and the Excel file.

a. Estimate the project’s net cash flows over its five-year estimated life. Hint: complete the following table.

0

1

2

3

4

5

Equipment cost

Net revenue

Less:

  Labor & Maintenance

  Utilities costs

  Supplies

  Incremental overhead

  Depreciation

    Income before taxes

Taxes (40%)

    Project’s net income

Plus: Depreciation

Plus: Net salvage value

b. What’s the project’s NPV?

c. What’s the project’s IRR?

Solutions

Expert Solution

0 $

1 $

2 $

3 $

4 $

5 $

Equipment cost

(60000)

Net revenue

300000 315000 330750 347288 364652

Less:

  Labor & Maintenance

100000 105000 110250 115763 121551

  Utilities costs

10000 10500 11025 11576 12155

  Supplies

18750 19688 20672 21705 22791

  Incremental overhead

5000 5250 5513 5788 6078

  Depreciation

120000 192000 114000 72000 66000

    Income before taxes

46250 (17438) 69291 120455 136078

Taxes (40%)

18500 (6975) 27716 48182 54431

    Project’s net income

27750 (10463) 41574 72273 81647

Plus: Depreciation

120000 192000 114000 72000 66000

Net Cash Flow

(600000) 147750 181538 155574 144273 282047

pre tax equipment salvage value = $ 200000

MACRS equipment salvage value (600000*.06 (dep year 6)) = $ 36000

$200000 - $36000 = $ 164000

Taxes 40% = $ 65600

After tax equipment salvage value = Salvage value - tax paid on gain

= $200000 - 65600 = $134400

Projects NPV

YEAR 0 1 2 3 4 5
CASH FLOW (600000) 147750 181538 155574 144273 282047
DISCOUNT RATE 8%

DISCOUNTED CASH FLOW

= CF/(1+r)n

600000 136805 155161 123471 106083 191869
NPV(Sum of DCF) $113389

The projects Cost of capital at 8%

NPV = PV of the cashflows - Initial investments

NPV = 147750/(1.08) + 181538/(1.08)2 + 155574/(1.08)3 ....

The projects IRR

YEAR 0 1 2 3 4 5
CASH FLOW (600000) 147750 181538 155574 144273 282047
IRR 14.40%

Related Solutions

Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment....
Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment. The equipment, which cost $600,000, has an expected life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses...
Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment....
Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment. The equipment, which cost $600,000, has an expected life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses...
California Health Center, a for �profit hospital, is evaluating the purchase of new diagnostic equipment. The...
California Health Center, a for �profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of 5 years and an estimated pretax salvage value of $200,000at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project�s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and contractual...
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment,...
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of five years and an estimated pre-tax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project's life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and contractual...
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment,...
California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000 has an expected life of five years and an estimated pre-tax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project's life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and contractual...
14.7- California Health Center, a for �profit hospital, is evaluating the purchase of new diagnostic equipment....
14.7- California Health Center, a for �profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of 5 years and an estimated pretax salvage value of $200,000at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project�s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and...
14.7 California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The...
14.7 California Health Center, a for-profit hospital, is evaluating the purchase of new diagnostic equipment. The equipment, which costs $600,000, has an expected life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and...
Capital Budgeting California Health Center, a for-profit hospital, is evaluating the purchase of a new diagnostic...
Capital Budgeting California Health Center, a for-profit hospital, is evaluating the purchase of a new diagnostic equipment, which costs $600,000 and has an expected life of five years.   Average investments in inventory and accounts receivable will be $50,000 and $200,000 respectively, while the average accounts payable balance will be $30,000. The expected before-tax salvage value of the equipment after five years’ use is $200,000. The equipment will produce an annual revenue of $300,000 each year in years 1-3, and $350,000...
Amaro Hospital, a not-for-profit institution not subject to income taxes, is considering the purchase of new...
Amaro Hospital, a not-for-profit institution not subject to income taxes, is considering the purchase of new equipment costing $25,000 to achieve cash savings of $6,250 per year in operating costs. The estimated useful life is 10 years, with no residual value. The minimum expected return is 14%. What is the internal rate of return(%)? (Note: Use Excel's IRR function to calculate the answer.)
The General Hospital is evaluating new office equipment offered by 2 companies. In each case the...
The General Hospital is evaluating new office equipment offered by 2 companies. In each case the interest rate is 15% and the useful life of the equipment is 4 years. Use incremental analysis benefit cost ratio pW to determine the company from which you should purchase the equipment Company A, Company B First cost $ 15,000 $ 25,000 Annual M&R cost $ 1,600 $ 800 Annual benefit $ 8,000 $ 3,000 one-off cash flow $ 1,200. $ 900. (both saved...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT