In: Accounting
|
A HCA hospital in Colorado plans to obtain a new MRI that costs $1.5 million and has |
|||||||
|
an estimated four-year useful life. It can obtain a bank loan for the entire amount and buy the MRI, |
|||||||
|
or it can obtain a guideline lease for the equipment. Assume that the following facts apply to the decision: |
|||||||
|
- The MRI falls into the three-year class for tax depreciation, so the MACRS allowances are 0.33, 0.45, |
|||||||
|
0.15, and 0.07 in Years 1 through 4, respectively. |
|||||||
|
- Estimated maintenance expenses are $75,000 payable at the beginning of each year whether the MRI is |
|||||||
|
leased or purchased. |
|||||||
|
- HCA's marginal tax rate is 40 percent. |
|||||||
|
- The bank loan would have an interest rate of 15 percent. |
|||||||
|
- If leased, the lease payments would be $400,000 payable at the end of each of the next four years. |
|||||||
|
- The estimated residual (and salvage) value is $250,000. |
|||||||
|
a. What are the NAL and IRR of the lease? Interpret each value. |
|||||||
a)
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
| Cost of owning | |||||
| Net Purchase price | $ 15,00,000 | ||||
| Maintenance Expenses | $ 75,000 | $ 75,000 | $ 75,000 | $ 75,000 | |
| Tax Savings on Maintenance Expenses | $ -30,000 | $ -30,000 | $ -30,000 | $ -30,000 | |
| Depreciation Tax savings | $ -1,98,000 | $ -2,70,000 | $ -90,000 | $ -42,000 | |
| Salvage Value | $ -2,50,000 | ||||
| Tax on Salvage Value | $ 1,00,000 | ||||
| Net Cash Flow | $ 15,45,000 | $ -1,53,000 | $ -2,25,000 | $ -45,000 | $ -1,92,000 |
| Cost of leasing | |||||
| Lease Payment | $ 4,00,000 | $ 4,00,000 | $ 4,00,000 | $ 4,00,000 | |
| Tax Savings on Lease Payments | $ -1,60,000 | $ -1,60,000 | $ -1,60,000 | $ -1,60,000 | |
| Maintenance Expenses | $ 75,000 | $ 75,000 | $ 75,000 | $ 75,000 | |
| Tax Savings on Maintenance Expenses | $ -30,000 | $ -30,000 | $ -30,000 | $ -30,000 | |
| Net Cash Flow | $ 45,000 | $ 2,85,000 | $ 2,85,000 | $ 2,85,000 | $ 2,40,000 |
| Net Advantage of leasing | |||||
| PVF @15% or 9% after tax | 1.0000 | 0.9174 | 0.8417 | 0.7722 | 0.7084 |
| Present Value of Cost of Owning | $ 10,44,489 | ||||
| Present Value of Cost of leasing | $ 9,36,441 | ||||
| Net Advantae of Leasing | $ 1,08,048 | ||||
Net advantage of Leasing = $108,048
The IRR of the above cash flow is
| Year | Particulars | Amount |
| 0 | Cost of Asset | $14,70,000 |
| 1 | Lease Rental+Taxsavings on Depreciation | $ -6,28,000 |
| 2 | Lease Rental+Taxsavings on Depreciation | $ -7,00,000 |
| 3 | Lease Rental+Taxsavings on Depreciation | $ -5,20,000 |
| 4 | Lease Rental+Taxsavings on Depreciation+Salvage avlue after tax | $ -5,92,000 |
| IRR at 9%guess (after tax) | 24.57% |