Question

In: Finance

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% 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...
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)...
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...
Group Project – Year 1 Could you do a balance sheet and income statement for below?...
Group Project – Year 1 Could you do a balance sheet and income statement for below? The following list summarizes the transactions that took place during a start up’s first year of operations. Using the information below, prepare a list of the appropriate journal entries, including any necessary adjusting entries, and create a Balance Sheet and Income Statement. Once you have created the financial statements, provide the appropriate closing entries. The startup uses straight line when depreciating long‐term assets and...
1. Shown below is Jensen Company’s projected income statement for year 2017, and the balance sheet...
1. Shown below is Jensen Company’s projected income statement for year 2017, and the balance sheet as of the end of 2016. Pro Forma Income Statement 2017 Balance Sheet Dec. 31, 2016 Dec. 31 2017 Revenues 7,000,000 Cash 30,000 Depreciation 500,000 Inventory 270,000 Other Expenses 5,800,000 Fixed Assets (Net) 4,700,000 Income 700,000 Total Assets 5,000,000 Dividends 500,000 Payables 180,000 LT. Debt 1,820,000 Equity 3,000,000 Liabilities + Equity 5,000,000 Sales are expected to increase from $5 million in 2016 to $7...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT