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% |