Du Pont analysis

Total liabilities and shareholder’s equity $ 2,502,992

a. Perform a Du Pont analysis on Green Valley. Assume that the industry average ratios are as follows:Total margin 3.5%Total asset turnover 1.5Equity multiplier 2.5Return on equity (ROE) 13.1%

b. Calculate and interpret the following ratios:Industry Average Return on assets (ROA) 5.2% Current ratio 2.0 Days cash on hand 22 daysAverage collection period 19 daysDebt ratio 71 %Debt-to-equity ratio 2.5Times interest earned (TIE) ratio 2.6Fixed asset turnover ratio 1.4

c. Assume that there are 10,000 shares of Green Valley’s stock outstanding and that some recently sold for $45 per share.What is the numbers price/earnings ratio?What is its market/book ratio?

18.1 Suncoast Healthcare is planning to acquire a new x-ray machine that costs $200,000. The business can either lease the machine using an operating lease or buy it using a loan from a local bank. Suncoast’s balance sheet prior to acquiring the machine is as follows:Current assets $ 100,000 Debt $ 400,000Net fixed assets 900,000 Equity 600,000Total assets $1,000,000 Total claims $1,000,000a. What is Suncoast’s current debt ratio?b. What would the new debt ratio be if the machine were leased? If it is purchased?c. Is the financial risk of the business different under the two acquisition alternatives?

18.2 Big Sky Hospital 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 lease the equipment. Assume that the following facts apply to the decision:By 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.Big Sky’s marginal tax rate is 40 percent.The bank loan would have an interest rate of 15 percent.If leased, the lease (rental) 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.b. Assume now that the salvage value estimate is $300,000, but all other facts remain the same. What is the new NAL? The new IRR?

18.3 HealthPlan Northwest must install a new $1 million computer to track patient records in its three service areas. It plans to use the computer for only three years, at which time a brand new system will be acquired that will handle both billing and patient records. The company can obtain a 10 percent bank loan to buy the computer or it can lease the computer for three years. Assume that the following facts apply to the decision:The computer falls into the three-year class for tax depreciation,so the MACRS allowances are 0.33, 0.45, 0.15, and 0.07 in Years1 through 4, respectively.The company’s marginal tax rate is 34 percent.Tentative lease terms call for payments of $320,000 at the end of each year.The best estimate for the value of the computer after three years of wear and tear is $200,000.a. What are the NAL and IRR of the lease? Interpret each value.b. Assume now that the bank loan would cost 15 percent, but all other facts remain the same. What is the new NAL? The new IRR?

18.4 Assume that you have been asked to place a value on the ownership position in Briarwood Hospital. Its projected profit and loss statements and equity reinvestment (asset) requirements are shown below (in millions):

2005 2006 2007 2008 2009Net revenues $225.0 $240.0 $250.0 $260.0 $275.0Cash expenses 200.0 205.0 210.0 215.0 225.0Depreciation 11.0 12.0 13.0 14.0 15.0Earnings before interest and taxes (EBIT) $ 14.0 $ 23.0 $ 27.0 $ 31.0 $ 35.0Interest 8.0 9.0 9.0 10.0 10.0Earnings before taxes (EBT) $ 6.0 $ 14.0 $ 18.0 $ 21.0 $ 25.0Taxes (40 percent) 2.4 5.6 7.2 8.4 10.0

Net profit $ 3.6 $ 8.4 $ 10.8 $ 12.6 $ 15.0

Asset requirements $ 6.0 $ 6.0 $ 6.0 $ 6.0 $ 6.0

Briarwood’s cost of equity is 16 percent. The best estimate for Briarwood’s long-term growth rate is 4 percent.a. What is the equity value of the hospital?b. Suppose that the expected long-term growth rate was 6 percent. What impact would this change have on the equity value of the business? What if the growth rate were only 2 percent?