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 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 start of year)b
Pretax profit $ 514
Tax 103 (20% of pretax profit)
Net income $ 411

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

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

BALANCE SHEET, YEAR-END
(Figures in $ thousands)
Assets $ 2,800 Debt $ 520
Equity 2,280
Total $ 2,800 $ 2,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

Income Statement 2019 Change Change Amount 2020
Sales 1080 15% 162 1242
Cost 540 15% 81 621
Interest 26 15.6 (520*3%)
Pretax Profit 514 605.4
Tax 103 121.08 (605*20%)
Net Income 411 484.32
2019
Asset 2800 Debt 520
Equity 2280
Total 2800 Total 2800
SOLUTION a
Asset
where Opening asset is 2800
Closing Asset be x
Sales = 1242= 0.4
Average Asset (2800+X)/2
1242= 0.4{(2800+x)/2}
1242= 0.4(1400+0.5X)
1242= 560+0.2X
1242-560= 0.2X
682= 0,2X
x=3410
Solution b
If company pays 50% of net income as dividend, it needs 484.32*0.5= 242.16 cash
Solution c
Debt Ratio formula = Total Debt
Total Assets
If company raises above required cash through debt, Total debt = 520+242.16= 762.16
asset as calculated above 3410
therefore Debt ratio in the end of 2020 will be 762.16/3410*100= 22.35%

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 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 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