Question

In: Finance

Question 211 pts Garamond Corporation reported the following income statement and balance sheet for the previous...

Question 211 pts

Garamond Corporation reported the following income statement and balance sheet for the previous year:

Balance Sheet

Cash

P   100,000

Inventories

1,000,000

Accounts receivable

500,000

Current assets

P1,600,000

Total debt

P4,000,000

Net fixed assets

4,400,000

Total equity

2,000,000

Total assets

P6,000,000

Total claims

P6,000,000

Income Statement

Sales

P3,000,000

Operating costs

1,600,000

Operating income (EBIT)

P1,400,000

Interest

400,000

Taxable income (EBT)

P1,000,000

Taxes (40%)

400,000

Net income

P   600,000

The company’s interest cost is 10%, so the company’s interest expense each year is 10% of its total debt. While the company’s financial performance is quite strong, its CFO is always looking for ways to improve. The CFO has noticed that the company’s inventory turnover ratio is considerably weaker than the industry average, which is 6.0. The CFO asks what the company’s ROE would have been last year if the following had occurred:

  • The company maintained the sale sales, but was able to reduce inventories enough to achieve the industry average inventory turnover ratio.
  • The cash that was generated from the reduction in inventories was used to reduce part of the company’s outstanding debt. So, the company’s total debt would have been P4 million less the freed-up cash from the improvement in inventory policy. The company’s interest expense would have been 10% of new total debt.
  • Assume equity does not change. (The company pays all net income as dividends.)

What would have been the company’s ROE last year?

Group of answer choices

31.5%

30.3%

27.0%

29.5%

Solutions

Expert Solution

Income Statement given
Sales 30,00,000
Operating costs 16,00,000
Operating income (EBIT) 14,00,000
Interest 4,00,000
Taxable income (EBT) 10,00,000
Taxes (40%) 4,00,000
Net income 6,00,000
Company Inventory Turnover Ratio Sales / Inventory
3000000/100000
Invetory Turnover ratio 3
Industry average 6
Therefore reduce Inventory 50% 1000000 x 50%
Invetory level 500000
Revised Investory TOR 3000000/500000
6
Redused Investory cash used to reduced debt 500000
Debt 4000000
Revised debt 4000000-500000
3500000
Interst on debt will be 3500000 x 10%
350000
Income Statement Revised to find ROE
Sales 30,00,000
Operating costs 16,00,000
Operating income (EBIT) 14,00,000
Interest 3,50,000
Taxable income (EBT) 10,50,000
Taxes (40%) 4,20,000
Net income 6,30,000
ROE Net Income / Share Capital x 100
630000/2000000 x 100
ROE 31.5
ROE Previous Year 31.50%

Related Solutions

For 2017, Permatemp reported the following book income statement and balance sheet, excluding the federal income...
For 2017, Permatemp reported the following book income statement and balance sheet, excluding the federal income tax expense, deferred tax assets, and deferred tax liabilities: Sales $33,000,000 Cost of goods sold -22,000,000 Gross profit $11,000,000 Dividend income 55,000 Tax-exempt interest income 15,000 Total income $11,070,000 Expenses:  Depreciation $800,000  Bad debts 625,000  Charitable contributions 40,000  Interest 455,000  Meals and entertainment 60,000  Other 4,675,000 Total expenses -6,655,000 Net income before federal income taxes $4,415,000 Cash $2,125,000 Accounts receivable $    3,300,000 Allowance for...
For 2017, Permtemp reported the following book income statement and balance sheet, excluding the federal income...
For 2017, Permtemp reported the following book income statement and balance sheet, excluding the federal income tax expenses, deferred tax assets, and deferred tax liabilities: Sales $33,000,000 Cost of Goods Sold (22,000,000) ____________ Gross Profit                                                      $11,000,000 Dividend Income 55,000 Tax-exempt Interest Income 15,000    ____________ Total Income $ 11,070,000 Expenses $  800,000 Bad Debts 625,000 Charitable Contr.    40,000 Interest 455,000 Meals & Entertainment 60,000 Other 4,675,000 _______________ Total Expenses (6,655,000)      ___________ Net loss before federal income taxes $4,415,000 ============ Cash...
Marcus Inc. reported the following Income Statement for 2018 and the comparative balance sheet for 2018...
Marcus Inc. reported the following Income Statement for 2018 and the comparative balance sheet for 2018 and 2017, along with additional information for 2018.   Prepare Maynard's statement of cash flows for the year ended December 31, 2018 using the indirect method and follow the proper format. MARCUS INC. Comparative Balance Sheets 12/31/2018 Assets 2018 2017 Debit Accounts Cash          42,000        33,750 Accounts receivable          70,500        60,000 Inventory          30,000        24,000 Investments (available for sale)          22,250       ...
The balance sheet and income statement for Cruise Corporation are as follows:
The balance sheet and income statement for Cruise Corporation are as follows:                                                                                                                      Balance Sheet as of December 31, 2020                                                                                                                                ASSETS                                                                         LIABILITIES & EQUITY                          Cash & marketable securities $2,000             Accounts payable                    $30,000             Accounts Receivable               35,000             Taxes payable                         9,000             Inventory                                 15,000             Short-term borrowings           12,000             Total current assets                $52,000           Total current liabilities           $51,000             Net P,P & E                              $448,000         Long-term debt                       $200,000             TOTAL ASSETS                         $500,000         Total liabilities                        $251,000                                                                                     Common stock at par             $80,000                                                                                     Additional paid-in capital       $30,000                                                                                     Retained earnings                   $139,000                                                                         TOTAL LIABILITIES & EQUITY             ...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Liabilities are reported on the a. balance sheet b. income statement c. statement of owner's equity...
Liabilities are reported on the a. balance sheet b. income statement c. statement of owner's equity d. statement of cash flows
Question 7 Use the following income statement and balance sheet information to put together a statement...
Question 7 Use the following income statement and balance sheet information to put together a statement of cash flows. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) 2017 Sales $1,242,000 Cost of goods sold $685,000 Gross profit $557,000 Gen'l & admin expense $156,000 Selling & mkt expense $135,000 Depreciation $24,000 Operating income $242,000 Interest $140,000 Income before taxes $102,000 Income taxes (27%) $27,540 Net income $74,460 Dividends paid $25,000 Assets 2017...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet December 31 2021 2020 2019 Cash $ 27,500 $ 23,500 $ 18,500 Accounts receivable 50,500 50,000 48,500 Other current assets 94,500 95,500 65,000 Property, plant, and equipment (net) 530,000 471,500 401,000 $702,500 $640,500 $533,000 Current liabilities $ 71,500 $ 77,500 $ 70,000 Long-term debt 77,500 84,500 46,500 Common shares 318,000 280,000 287,000 Retained earnings 235,500 198,500 129,500 $702,500 $640,500 $533,000 SWIFTY CORPORATION Income Statement...
Question text Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income...
Question text Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Macy's, Inc. Consolidated Statement of Income Fiscal Years Ended ($ millions) February 2, 2013 January 28, 2012 January 29, 2011 Net sales $ 27,686 $ 26,405 $ 25,003 Cost of goods sold 16,538 15,738 14,824 Gross margin 11,148 10,667 10,179 Selling, general and administrative expenses 8,482 8,281 8,260 Impairments, store closing costs and (gain) on sale of leases 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT