Question

In: Finance

The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling...

The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 5% of debt at the start of the year. At the end of 2018 debt was $2,400,000 and assets were $6,960,000.

Income Statement

$ in thousands

Sales

$

2,900

(40% of average assets)

Costs

2,175

(75% of sales)

Interest

120

(5% of debt at start of year)

Pretax profit

605

Tax

242

(40% of pretax profit)

Net income

$

363

Balance Sheet

$ in thousands

Net assets

$

7,540

Debt

$

2,400

Equity

5,140

Total

$

7,540

Total

$

7,540

a. What is the expected level of assets at the end of 2020?

b. If the company pays out 50% of net income as dividends, how much cash will Drake need to raise in the capital markets in 2020? Assumes debt remains constant.

c. If Drake is unwilling to make an equity issue, what will be the debt ratio at the end of 2020?

Solutions

Expert Solution

a. Level of sales in 2020 = 2900 *110% = 3190

Let x be level of assets in 2020

3190 = 40% * ( 7540 + x) /2

x =8410

Expected level of assets = 8410

b.

Sales                         3,190
Costs                         2,393 [75 % of sales]
Interest                             120 [2400*5%]
Pre tax profit                             678
Tax                             271 [40% of pretax profit]
Net income                             407
Less: Dividends paid                             203 [50% of net income]
Income to stockholders                             203
Assets 8410 Debt 2400
Existing equity 5140
Net income 203
New equity 667
8410 8410

Amount to be raised in capital markets = 667

c) If it is unwilling to make then it has to raise through debt. Then debt will be = 2400 + 667 = 3067

Debt ratio = 3067/ 8410 = 36.47%


Related Solutions

The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling...
The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 5% of debt at the start of the year. At the end of 2018 debt was $2,400,000 and assets were $6,960,000. (10 points) Income Statement $ in thousands Sales $ 2,900 (40% of...
1. The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s...
1. The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 5% of debt at the start of the year. At the end of 2018 debt was $2,400,000 and assets were $6,960,000. (10 points) Income Statement $ in thousands Sales $ 2,900 (40%...
The following tables summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys....
The following tables summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 5% of debt at the start of the year. INCOME STATEMENT, 2019 (Figures in $ thousands) Sales $ 1,480 (40% of average assets)a Costs 1,110 (75% of sales) Interest 31 (5% of debt at...
The following tables summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys....
The following tables summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 15% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 3% of debt at the start of the year. INCOME STATEMENT, 2019 (Figures in $ thousands) Sales $ 1,080 (40% of average assets)a Costs 540 (50% of sales) Interest 26 (5% of debt at...
Based on the information below create the year end income statement, balance sheet, and cash flow...
Based on the information below create the year end income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in...
Provided below is the incomplete income statement (for 2020) and balance sheet (Dec 31 2019 and...
Provided below is the incomplete income statement (for 2020) and balance sheet (Dec 31 2019 and Dec 31 2020) for SCOTTY Inc. SCOTTY Inc. Income Statement For the year ended Dec. 21, 2020 Net sales $8,953 Cost of goods sold $5,865 Depreciation $? EBIT $? Interest paid $675 Earnings before taxes $? Taxes $400 Net income $705 Dividends paid $? Addition to retained earnings $450 SCOTTY Inc. Balance Sheet as at December 31, 2019 and 2020 2019 2020 2019 2020...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet...
Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet for Hanson Storage from the adjusted trial balance. No additional investments in the company were made during the year. ( really need help with making an income statement, statement of retained earnings, and balance sheet. HANSON PRODUCTS COMPANY Adjusted Trial Balance December 31, 2018 Debit Credit Cash $    14,400 Accounts receivable 35,000 Allowance for doubtful accounts 800 Merchandise inventory 50,400 Office supplies 900 Prepaid...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,090 $ 24,610 Accounts receivable 88,000 76,680 Inventory 39,800 47,940 Prepaid expenses 9,810 15,750 Long-term investments 254,400 210,000 Property, plant, and equipment 540,750 504,000 Less accumulated depreciation 329,600 312,700 Total assets $ 606,250 $ 566,280 Accounts payable $ 9,540 $ 25,500 Accrued liabilities 24,480 17,850 Income taxes payable 53,400 48,300 Bonds payable 176,000 216,000 Common...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,270 $ 25,300 Accounts receivable 88,800 78,100 Inventory 39,800 49,820 Prepaid expenses 9,630 15,450 Long-term investments 247,200 216,000 Property, plant, and equipment 566,500 523,200 Less accumulated depreciation 345,600 324,500 Total assets $ 609,600 $ 583,370 Accounts payable $ 9,720 $ 25,750 Accrued liabilities 25,440 18,190 Income taxes payable 51,900 50,600 Bonds payable 171,200 206,000 Common...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT