Question

In: Finance

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 start of year)b
Pretax profit $ 339
Tax 136 (40% of pretax profit)
Net income $ 203

a Assets at the end of 2018 were $3,600,000.

b Debt at the end of 2018 was $620,000.

BALANCE SHEET, YEAR-END
(Figures in $ thousands)
Assets $ 3,800 Debt $ 620
Equity 3,180
Total $ 3,800 $ 3,800

a. What is the implied level of assets at the end of 2020? (Do not round your intermediate calculations. Enter your answer in thousands.)

b. If the company pays out 50% of net income as dividends, how much cash will Drake's need to raise in the capital markets in 2020? (Do not round your intermediate calculations. Enter your answer in thousands.)

c. If Drake's is unwilling to make an equity issue, what will be the debt ratio at the end of 2020? (Do not round your intermediate calculations. Round your answer to 2 decimal places.)

Solutions

Expert Solution

Dreake's Bowling Alley
Year 2018 Year 2019 Year 2020
Asset at Year End                3,600,000                    3,800,000                        4,340,000.0
Average Asset                    3,700,000                        4,070,000.0 Inproportion to 2020 sales
Debt at Start pf The year                       620,000                              620,000
Interest @5% of SOY debt                         31,000                                31,000
Amt in $'000
Proforma Income Statement Year 2019 Year 2020 Remarks
Sales                        1,480                           1,628 10% increase over 2019, 40 % of Average assets
Costs                        1,110                           1,221 10% increase over 2019,
Interest                             31                                 31
Pretax Profit                           339                               376
Tax 40%                           136                               150
Net Income                           203                               226
Dividend paid 50% of Net income in 2020                               113
Addition to Retained Earning                               113
Ans a.
As the sales in 2020 is $1,628,000., the average asset of 2020 would be
=$1628000/40%=$4,070,000. Now the start of the year asset =$3,800,000
So End of 2020 Asset =2*4070000-3800000=$4,340,000
Ans b.
Let US make the Proforma Balance sheet of end of 2020
Assets Amt $'000 Liab & Equity Amt $'000 Remarks
Assets                        4,340 Debt 620
Equity 3293 $113,00 addition to reatined earning
Additional Capital                                      427 Balancing Amt
Total Assets                        4,340 Total Liab & Equity                                   4,340
Assuming the current debt remains unchanges, the balancing amount will be the new capital
So Drake needs to Raise $427,000 in the capital market to fund the sales increase
Ans c.
If no new equity is issued, the total $427,000 will be raised as debt.
In that case total Debt will be =$620,000+$427,000= $                1,047,000
So Debt Ratio at the end of 2020 will be =1047000/4340000=0.24 (Total Debt /Total Asset)

Related Solutions

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...
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)...
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%...
South Sea Baubles has the following (incomplete) balance sheet and income statement. BALANCE SHEET AT END...
South Sea Baubles has the following (incomplete) balance sheet and income statement. BALANCE SHEET AT END OF YEAR (Figures in $ millions) Assets 2015 2016 Liabilities and Shareholders' Equity 2015 2016 Current assets $ 96 $ 170 Current liabilities $ 62 $ 78 Net fixed assets 860 960 Long-term debt 630 810 INCOME STATEMENT, 2016 (Figures in $ millions) Revenue $ 1,980 Cost of goods sold 1,060 Depreciation 380 Interest expense 246 a&b. What is shareholders’ equity in 2015 and...
South Sea Baubles has the following (incomplete) balance sheet and income statement. BALANCE SHEET AT END...
South Sea Baubles has the following (incomplete) balance sheet and income statement. BALANCE SHEET AT END OF YEAR (Figures in $ millions) Assets 2015 2016 Liabilities and Shareholders' Equity 2015 2016 Current assets $ 90 $ 140 Current liabilities $ 50 $ 60 Net fixed assets 800 900 Long-term debt 600 750 INCOME STATEMENT, 2016 (Figures in $ millions) Revenue $ 1,950 Cost of goods sold 1,030 Depreciation 350 Interest expense 240 a&b. What is shareholders’ equity in 2015 and...
The following are the income statement and balance sheet of company X as at year 2015....
The following are the income statement and balance sheet of company X as at year 2015. Income Statement Sales 20,077,000 Cost of goods sold 14,985,000 Other Expenses 2,399,000 Depreciation 655,000 EBIT 2,038,000 Interest 362,000 Taxable income 1,676,000 Tax (40%) 670,400 Net income 1,006,600 Balance Sheet Assets Liability and Equity Current Assets Current liabilities Cash 365,040 Account payable 715,680 Account Receivable 1,534,680 Notes payable 1,446,400 Inventory 1,238,500 Total current liabilities 2,162,080 Total current assets 3,138,220 Fixed Assets Long-term debt 3,825,000 Net...
Calculate the following from the year of 2019 Balance Sheet AND Income Statements for GOOGLE and...
Calculate the following from the year of 2019 Balance Sheet AND Income Statements for GOOGLE and APPLE. You can find both readily available freely online to the public. Return on Equity (Net Income / Shareholders Equity) Return on Assets (Net Income / Assets) Return on Invested Capital (Earnings BEFORE interest ad taxes X 1 - Tax Rate) / ( Interest Bearing Debt + Shareholders Equity) Profit Margin (Net Income / Sales) Gross Margin (Gross Profit / Sales) Price to Earnings...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT