In: Accounting
22) Use the information about Billy's Burgers to answer the following question(s):
Billy's Burgers
Figures in $ millions |
|||
Income Statement |
2015 |
Balance Sheet |
2015 |
Net Sales |
246.0 |
Assets |
|
Costs exc. Dep. |
187.0 |
Cash |
8.0 |
EBITDA |
59.0 |
Accts. Rec. |
21.0 |
Depreciation |
17.2 |
Inventories |
23.0 |
EBIT |
41.8 |
Total Current Assets |
52.0 |
Interest |
12.0 |
Net PP&E |
145.0 |
Pretax Income |
29.8 |
Total Assets |
197.0 |
Taxes |
10.4 |
||
Net Income |
19.4 |
Liabilities and Equity |
|
Accts. Payable |
18.0 |
||
Long-Term Debt |
82.0 |
||
Total Liabilities |
100.0 |
||
Total Stockholders' Equity |
97.0 |
||
Total Liabilities and Equity |
197.0 |
a) Using the percent of sales method, and assuming 20% growth in sales, estimate Billy's Burgers' depreciation for 2016.
b) Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' pretax income for 2016.
c) Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' net income for 2016.
d) Using the percent of sales method, and assuming 20% growth in sales, estimate Billy's Burgers' accounts receivable for 2016.
i) Assuming the sales has been increased by 20%, using percentage of sales method, depreciation shall | |||||||||||
also be increased by 20%. | |||||||||||
Thus Depreciation for the year 2016 = Depreciation for the year 2015 + 20% increase | |||||||||||
= $17.2 millions X 120% = $20.6 milllions | |||||||||||
ii)Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' pretax income for 2016. | |||||||||||
EBIT for year 2016 = EBIT for year 2015 + 20% increase from 2015 | |||||||||||
= $41.8 *120% = $50.16 Millions | |||||||||||
Pretax Income = EBIT for year 2016 - Interest | |||||||||||
= $50.16 million - 12 = $38.16 millions | |||||||||||
iii)c) Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' net income for 2016 | |||||||||||
Net Income = (EBIT - Interest) *(1- Income Tax Rate) | |||||||||||
= ($41.8 million*1.2 - 12)*(1-10.4/29.8) | |||||||||||
$24.84 millions | |||||||||||
d) Using the percent of sales method, and assuming 20% growth in sales, estimate Billy's Burgers' accounts receivable for 2016 | |||||||||||
Accounts Receivable fr year 2016 = Accounts Receivable for year 2015 *120% | |||||||||||
= 21*120% | |||||||||||
$25.2 millions | |||||||||||