2024 FINANCE ASSIGNMENT Assignment Help
Assignment 4 Question 4 is composed of two parts The DuPont Formula defines the net return on 2023
Assignment 4-(Question 4 is composed of two parts.) The DuPont Formula defines the net return on shareholders ‘Equity as a function of the following components: Operating Margin A Asset Turnover Interest Burden Financial Leverage Income Tax Rate Using only the data in the table below: a. Calculate each of the five components listed above for 2010 and 2014, and calculate the return on equity (ROE) for 2010 and 2014, using all of the five components. Show calculations. b. Briefly discuss the impact of the changes in asset turnover and financial leverage on the change in ROE from 2010 to 2014. Income State Data 2010 2014 Revenues $542 $979 Operating Income $38 $76 Depreciation and Amortization $3 $9 Interest Expense $3 $0 Pretax Income $32 $67 Income Taxes $13 $37 Net Income After Tax $19 $30 Balance Sheet Data 2010 2014 Fixed Assets $41 $70 Total Assets $245 $291 Workign Capital $123 $157 Total Debt $16 $0 Total Shareholders’ Equity $159 $220 5- David Wright CEA. An analyst with River Investment is considering buying a Montrose Cable Company corporate bond. He has collect the following balance sheet and income statement information for Montrose as shown in Exhibit 10.10 He has also calculated the three ratios shown in EXHIBIT 10.11. Which indicate that the bond is currently rated “A” according to the firm’s internal bond rating criteria shown in Exhibit 10.13. Wright has decided to consider some off-balance –sheet items in his credit analysis, as shown in Exhibit 10.12. Specifically. Wright wishes to evaluate the impact of each of the off-balance-sheet items on each of the ratios found in Exhibit 10.11. a. Calculate the combined effect of the three of balance sheet items in the Exhibit 10.12 on each of the following three financial ratios shown in Exhibit 10.11 1-EBITDA/interest expense. 2- Long-term debt/equity. 3-Current assets/current liabilities. The bond is currently trading at the credit premium of 25 basis points. Using the internal bond-rating criteria in Exhibit 10.13, Wright wants to evaluate whether or not the credit yield premium incorporates the effect off-balance-sheet items. b. State and justify whether or not the current credit yield premium compensates Wright for the credit risk of the bond based on the internal bond-rating criteria found in Exhibit 10.13. Exhibit 10.10 Montrose Cable Company Year Ended March 31, 2011 {Use Thousands} Balance sheet . Current assets $4,735 Fixed assets 43,225 Total assets 47,960 Current liabilities 4,500 Long-term debt 10,000 Total liabilities 14,500 Shareholder’s equity 33,460 Total liabilities and Shareholder’s equity 47,960 Income Statement . Revenue $18,500 Operating and administrative expenses $14,050 Operating income $4,450 Depreciation and amortization $1,675 Internet expense $942 Income before income taxes $1,833 Taxes $641 Net income $1,192 Exhibit 10.11 Selected Ratios and Credit Yield Premium Data for Montrose . EBITDA/interest expense 4.72 Long-term debt/equity 0.30 Current assets/ Current liabilities 1.05 Credit yield premium over U.S. Treasuries 55 basis points Exhibit 10.12 Montrose off-balance-sheet items · Montrose has guaranteed the long-term debt (principal only0 of an unconsolidated affiliate. This obligation has a present value of $995,000. · Montrose has sold $500,000 of accounts receivable with recourse at a yield of 8 percent. · Montrose is a lessee in a new noncancelable operating leasing agreement to finance transmission equipment. The discount value of the lease payments is $6,144,000 using an interest rate of 10 percent. The annual payment will be 1,000,000. Exhibit 10.13. Blue River Investments: Internal Bond-Rating Criteria Credit Yield Interest Coverage Current Ratio premium over {EBITDA/interest Leverage Long[Current assets/ U.S. Treasuries Bond Rating Expense} -term debtequityCurrent liabilities] in basis points AA 5.00 to 6.00 0.25 to 0.30 1.15 to 1.25 30 bps A 4.00 to 5.00 0.30 to 0.40 1.00 to 1.15 50 bps BBB 3.00 to 4.00 0.40 to 0.50 0.90 t0 1.00 100bps BB 2.00 to 3.00 0.50 to 0.60 0.75 to .090 125bvps 6- . Over the long run, you expect dividends for BBC in Problem 4 to grow at 8 percent and you require 11 percent on the stock. Using the infinite period DDM, how much would you pay for this stock? 7- The Shamrock Dogfood Company (SDC) has consistently paid out 40 percent of its earnings in divi- dends. The company’s return on equity is 16 percent. What would you estimate as its dividendgrowth rate? 8- – What P/E ratio would you apply if you learned that SDC had decided to increase its payout to50 percent? (Hint: This change in payout has multiple effects.)