Question

In: Finance

As you can determine from the attached financial statements (balances are at year end), the return...

As you can determine from the attached financial statements (balances are at year end), the return on equity (ROE) declined significantly from 2013 to 2015. Decompose ROE into the five component ratios (for each year) and offer a thoughtful explanation for the decline. (When calculating ratios that use balance sheet items, please use the year-end numbers. Do not use averages. For example, when calculating a ratio that uses total assets, use the balance sheet number provided for that year. Do not use the average [(beginning + end)/2].

2013 2014 2015
Revenue 5400 7760 8123
Cost of goods Sold 4170 6050 6579
Selling, Gen. Admin
expenses 590 931 1123
Depreciation 50 50 75
Operating Income 590 729 346
Interest 28 49 56
Earnings before Tax 562 680 290
Taxes 174 211 90
Net Income 388 469 200
Cash 50 60 30
Accts. Receivable 720 730 690
Inventory 430 590 600
Net Property, Plant &
Equip. 2500 3060 3320
Total Assets 3700 4440 4640
Current Liabilities 1110 1550 1650
Long Term Debt 400 700 800
Total Liabilities 1510 2250 2450
Stock equity 2190 2190 2190
Total Liabilities and equity 3700 4440 4640

Solutions

Expert Solution

Financial Statement Data 2013 2014 2015
Sales 5,400.0 7,760.0 8,123.0
EBIT 590.0 729.0 346.0
Interest Expense (Non-0perating) 28.0 49.0 56.0
Tax Expense 174.0 211.0 90.0
Net Income (Income for Primary EPS) 388.0 469.0 200.0
Assets 3,700.0 4,440.0 4,640.0
Equity 2,190.0 2,190.0 2,190.0
2013 2014 2015
Pre-Interest Pretax Margin (EBIT ÷ Sales) 10.9% 9.4% 4.3%
Asset Turnover (Sales ÷ Average Assets) 1.46 1.75 1.75
Interest Burden [(EBIT - Interest Expense) ÷ EBIT] 95.3% 93.3% 83.8%
Tax Efficiency [1 - (Tax Expense ÷ (EBIT - Interest Expense))] 69.0% 69.0% 69.0%
Equity Multiplier (Average Assets ÷ Average Equity) 1.69 2.03 2.12
Return on Equity 17.7% 21.4% 9.1%

1. The Pre Interest Pre Tax Margin has declined from 10.9% in 2013 to 4.3% in 2015. Looking at the Income statement, COGs has increase from 77% in 2013 to 81% of sales in 2015. Selling and Admin expenses have increase from 11% to 14% of sales. This has contributed greatly to decline in EBIT % to sales even though sales have increased during these years.

2. Asset turnover indicates the amount of sales a company generates for each dollar of assets . The ratio has increased from 1.46 to 1.75 in 2014 but it has remained same in 2015 despite increase in assets and sales. This indicates there was no increase in amount of sales generated for each dollar of assets.

3. Interest burden ratio or Interest coverage ratio is used to determine how easy it is for the company to pay its interest expense. Higher the ratio, higher is the companies paying capacity. The comapny's Interest burden ratio has come down as EBIT of the company has decreased from 2013 to 2015, while interest expense is increasing in absolute terms.

4. Tax Efficiency ratio has no change. It has not impacted the decrease in ROE

5. Equity Multiplier is ratio calculated to measure company's financila leverage. Higher equity multiplier means company has more debt than equity to finance its assets. The equity mulitiplier has increase from 1.69 to 2.12 from 2013 to 2015, which means company has borrowed more debt which results in higher interest expense leading to lower Net income and hence decrease in overall ROE of the company.


Related Solutions

Company A released financial statements for year end 2021. The financial statements were consolidated financial statements,...
Company A released financial statements for year end 2021. The financial statements were consolidated financial statements, which combined results of their own business, with the results of Company B. Based on this information, what type of business combination occurred on the date these two companies combined ? A) Statuatory Acquisition B) Statuatory Consolidation C) Statuatory Merger D) Hostile Takeover
The following information as at the year-end date is extracted from the Freddy Corporation's financial statements:...
The following information as at the year-end date is extracted from the Freddy Corporation's financial statements: December 31 2019 ($) 2018 ($) Cash 95,000 27,000 Accounts receivable 92,000 80,000 Allowance for doubtful accounts (4,500) (3,100) Inventory 155,000 175,000 Prepaid expenses 7,500 6,800 Land 90,000 60,000 Buildings 287,000 244,000 Buildings - Accumulated depreciation (32,000) (13,000) Machinery 50,000 60,000 Machinery- Accumulated depreciation (30,000) (25,000) Leased equipment* 28,594 - Leased equipment - Accumulated depreciation (9,531)                          - 729,063 611,700 Accounts payable 90,000 84,000 Accrued...
A company’s financial records report the following accounts and balances at the end of the year:...
A company’s financial records report the following accounts and balances at the end of the year: Accounts payable $ 4,000 Accounts receivable    4,700 Cash 14,100 Common stock      5,600 Dividends      2,200 Interest expense 18,500 Notes payable     5,200 Prepaid insurance     2,700 Retained insurance     2,400 Service revenue 25,000 What would the company show as its total credits on its trial balance? a) $39,800 b) $43,400 c) $36,600 d) $42,200 e) $44,400
Missing amounts from financial statements The financial statements at the end of Wolverine Realty’s first month...
Missing amounts from financial statements The financial statements at the end of Wolverine Realty’s first month of operations are as follows: By analyzing the interrelationships among the four financial statements, determine the proper amounts for the missing items. Use the minus sign to indicate cash outflows, cash payments, and decreases in cash in the Statement of Cash Flows. Wolverine Realty Income Statement For the Month Ended April 30, 20Y0 Fees earned $ Expenses:      Wages expense $304,000      Rent expense 107,000      Supplies...
Missing amounts from financial statements The financial statements at the end of Atlas Realty’s first month...
Missing amounts from financial statements The financial statements at the end of Atlas Realty’s first month of operations follow: By analyzing the interrelationships among the four financial statements, determine the missing amounts. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign. Use the minus sign to indicate cash outflows, cash payments, and decreases in cash in the Statement of Cash Flows. Atlas Realty Income Statement For the Month...
Missing Amounts from Financial Statements The financial statements at the end of Atlas Realty's first month...
Missing Amounts from Financial Statements The financial statements at the end of Atlas Realty's first month of operations follow: Required: Analyze the interrelationships among the four financial statements and enter the missing amounts. If an amount is zero, enter "0". Atlas Realty Income Statement For the Month Ended May 31, 2018 Fees earned $400,000 Expenses: Wages expense $ Rent expense 48,000 Supplies expense 17,600 Utilities expense 14,400 Miscellaneous expense 4,800 Total expenses 288,000 Net income $ Atlas Realty Retained Earnings...
Missing Amounts From Financial Statements The financial statements at the end of Paradise Realty's first month...
Missing Amounts From Financial Statements The financial statements at the end of Paradise Realty's first month of operations are shown below. PARADISE REALTY Income Statement For the Month Ended November 30, 20Y3 Fees earned $149,300 Operating expenses: Wages expense $ (a) Rent expense 14,400 Supplies expense 12000 Utilities expense 8,100 Miscellaneous expense 4,950     Total operating expenses (69,300) Net income $ (b) PARADISE REALTY Statement of Stockholders' Equity For the Month Ended November 30, 20Y3 Common Stock Retained Earnings Total Balances,...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year...
Attached are the financial statements (Balance Sheet/Income Statement) for Lost Cause, Inc, Inc for the year ended December 31, 2018. Assume the following (all as of 12/31/18): a. Beta was 1.60 b. There are 3,756,000 shares outstanding c. There are 4,256,000 shares authorized d. There are 500,000 shares in Treasury e. The share price was $78.50share. f. The overall market return was 9.0% g. The risk-free rate of return is 2.5% h. The amount in current maturities ($3,500) of LTD...
Explain why return on equity, calculated using the financial statements, generally differs from the return on...
Explain why return on equity, calculated using the financial statements, generally differs from the return on the stock calculated using CAPM.
Larime Corp. is forecasting 20X2 near the end of 20X1. The estimated year-end financial statements and...
Larime Corp. is forecasting 20X2 near the end of 20X1. The estimated year-end financial statements and a worksheet for the forecast are given below. Management expects the following next year. An 9% increase in revenue. Price cutting will cause the cost ratio (COGS/sales) to deteriorate (increase) by 2% (of sales) from its current level. Expenses will increase at a rate that is three quarters of that of sales. The current accounts will increase proportionately with sales. Net fixed assets will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT