Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Total debt/Total assets | 0.5 | 0.5 | 0.3 | 0.8 | 0.8 | 0.8 | 0.9 | 0.7 | 0.7 |
Debt fuding of assets= | 50% | 50% | 30% | 80% | 80% | 80% | 90% | 70% | 70% |
So, Pref.& equity funding | 50% | 50% | 70% | 20% | 20% | 20% | 10% | 30% | 30% |
a. Financial leverage: |
Debt funding assets decreased in Year 3(30%) , after being on par with equity(50%) in yrs. 1&2. |
After yr.3, it increased to 80% in Yr.4 & remained so in the yrs. 5&6 , showing a further increase to 90% in Yr.7 , after which , the level of funding decreased to 70% |
Coverage ratios |
Interest coverage: |
Year 1 shows a negative EBIT, when interest expenses are not covered at all.Interest coverage expressed as no.of times the EBIT, has increased in Yrs. & 3--the maximum being in Yr. 3 --when debt funding of assets , is also at the lowest(30%).It slumped to 0.5 times when the proportion of debt funding increased heavily, again to increase in yrs. 5&6. After a slight decrease in Yr. 7, the interest coverage increased in the last 2 yrs. |
Pref. div. coverage: |
There is no preference capital upto Year 3. From yr. 4, the total coverage ratio is decreased in all the years, showing declaration of preference dividends , in all the years. |
b. | |||||||||
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Debt fuding of assets= | 50% | 50% | 30% | 80% | 80% | 80% | 90% | 70% | 70% |
Preferred funding | 30% | 40% | 40% | 50% | 60% | 30% | |||
Equity funding(the balance) | 50% | 50% | 70% | -10% | -20% | -20% | -40% | -30% | 0% |
From the above,it is clearly that from Year 4 , equity has not participated in asset formation. Equity might have been very negligible in the capital structure.Instead, preferred capital had been used to fund asset acquisitions. |
c. |
Interest expenses are larger -- as the debt amount is more than preferred capital ,in all the years(given 0 tax rate) |
Also, the combined coverage ratios ,not only, follow the same pattern as for interest coverage of EBIT, but also , the difference between the two coverage times is very small, in all the years except the last 2 yrs. |
2.b&c.. Year | 1 | 2 | 3 | 4 | 5 | 6 |
Return on Assets:(Net Income+((1-Av.Tax rate)*Int.exp.))Av.Total assets | ||||||
Pretax Income | 1.2 | 3.93 | 1.24 | 1.72 | 1.03 | 0.95 |
Income Tax | 0.42 | 1.38 | 0.43 | 0.6 | 0.36 | 0.33 |
Av.IT Rate(2/1) | 35% | 35% | 35% | 35% | 35% | 35% |
1.Net Income | 2.53 | 0.81 | 1.12 | 0.67 | 0.62 | |
Int.exp. | 3.62 | 3.83 | 3.9 | 4.52 | 3.97 | |
2.((1-35%)*Int.exp.) | 2.35 | 2.49 | 2.54 | 2.94 | 2.58 | |
Beg. Total assets | 86.52 | 108.25 | 112.47 | 112.4 | 106.21 | |
End. Tot. assets | 108.25 | 112.47 | 112.4 | 106.21 | 103.18 | |
3.AV.=(Beg.+End.)/2 | 97.39 | 110.36 | 112.44 | 109.31 | 104.70 | |
Return on assets=(1+2)/3 | 5.01% | 2.99% | 3.25% | 3.30% | 3.06% | |
Return on Equity=Net Income/Av. Common equity | ||||||
1.Net Income | 2.53 | 0.81 | 1.12 | 0.67 | 0.62 | |
Beg. Total equity | 27.38 | 40.49 | 40.21 | 29.61 | 29.1 | |
End. Tot.equity | 40.49 | 40.21 | 29.61 | 29.1 | 29.29 | |
2.AV.=(Beg.+End.)/2 | 33.94 | 40.35 | 34.91 | 29.36 | 29.20 | |
Return on Equity=(1/2) | 7.46% | 2.01% | 3.21% | 2.28% | 2.12% | |
a.The return on assets formula used by the analyst measures the operating income generated against the average total used during the year. | ||||||
The return on equity formula measures the final net income generated & available to common equity, against the average equity funds employed & used during the year. |
Please answer P2.5 (first pic) and P.2.9 (second and third pic) P25 Samsonite Corporation: Review the...
What would be my answer for the liquidity ratios The first blue box? hes385r3_Financial_Performance_Worksheet_Week_4 Review View AutoSave OFF A S Home Insert DrawPage Layout Times New Roman 12 Paste BIV A B4 X v fx BALANCE SHEET Comments Formulas A A Q-Search Sheet Share EAY- O 4 Data = = 2 Wrap Text Merge & Center General $ % 3 E 48 2X Delete Format Sort & Filter Find A Select ideas Sensitivity Formatting as Table X Styles Hillside, Inc....
the third picture is the question the 2 first are the informations We were unable to transcribe this imageEAST COAST YACHTS 2010 Balance Sheet Current liabilities S 24,546,000 Current assets 11,232,000 Accounts payable Cash and equivalents Accounts receivable Inventories Other 0,208,000 Notes payable 22,656,000 Accrued expenses 6,185,000 S 49,456,000 184,000 Total current liabilities 55,280,000 $146,560,000 $146,560,000 Total current assets Long-term debt Fixed assets Total long-term liabilities $462,030,000 (114,996,000) Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment...
Based on the following balance sheet and income statement. Identify all financial ratios listed for each year. *Feel free to just do the first year! I need to check to make sure my answers are appropriate. Thanks! ANNUAL BALANCE SHEET ($ Thousands) 31-Dec-15 31-Dec-16 31-Dec-15 31-Dec-16 ASSETS Profitability Ratios (in %) Cash & Short-Term Investments $17.11 $25.05 Return on equity Net Receivables $1.62 $1.84 Return on assets Inventories $42.72 $39.68 Return on invested capital Prepaid Expenses $0.00 $0.00 Profit margin...
This question is based on the information provided in the abbreviated year-end Income Statement and abbreviated year-end Balance Sheet for NMC Corporation shown below. NMC Corporation Income Statement for the Calendar Year (January 1 - December 31) Thousands of dollars (except stock price, earnings per share, and dividends per share) Net sales $3000 Cost and expenses: $2734 EBIT $266 Less interest expense: $66 Earnings before taxes $200 Taxes $80 Net income before preferred dividends $120 Dividends to preferred stockholders $8...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 2015: December 31 2017 2016 2015 Total assets $4,800,000 $4,400,000 $4,000,000 Notes payable (8% interest) 2,250,000 2,250,000 2,250,000 Common stock 250,000 250,000 250,000 Preferred 4% stock, $100 par (no change during year) 500,000 500,000 500,000 Retained earnings 1,574,000 1,222,000 750,000 The 2017 net income was $372,000, and the 2016 net income was $492,000. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 20Y5: December 31 2017 2016 2015 Total assets $244,000 $220,000 $196,000 Notes payable (8% interest) 80,000 80,000 80,000 Common stock 32,000 32,000 32,000 Preferred 6% stock, $100 par 16,000 16,000 16,000 (no change during year) Retained earnings 83,360 59,840 48,000 The 2017 net income was $24,480, and the 2016 net income was $12,800. No dividends on common stock were...
The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $233,000 $210,000 $187,000 Notes payable (8% interest) 80,000 80,000 80,000 Common stock 32,000 32,000 32,000 Preferred 7% stock, $100 par 16,000 16,000 16,000 (no change during year) Retained earnings 80,620 58,730 48,000 The 20Y7 net income was $23,010, and the 20Y6 net income was $11,850. No dividends on common stock were declared between...
please answer question E please answer A to E please 4-24 6x 3x 66 DUPONT ANALYSIS A firm has been experiencing low profitability in recent years. Per- form an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 3x Fixed assets turnover Debt-to-capital...
w Connolly - Outlo Course: BU-1152-05 Financial My Home CengageNOWV2 Online teachi.. Cengage Learning Dyese Hoodie eBook Show Me How Calculator Print Item Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 2015: December 31 2017 2016 2015 Total assets $5,200,000 $5,000,000 $4,800,000 Notes payable (6% Interest) 2,500,000 2,500,000 2,500,000 Common stock 250,000 250,000 250,000 Preferred 2.5% stock, $100 par (no change during year) 500,000 500,000 500,000 Retained...
Required information [The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year $ 980,000 2,780,000 3,620,000 260,000 7,640,000 9,560, 000...