Discussion question- Need ASAP

Discusison1-Draft.xlsx

Sheet1

Discussion I: Team Coffee Grind		2015		2016 A				2016 B
Income Statement				%	Additional			%	Additional			2015 Profit:
Sales		17300		10%	1730	19030		20%	3460	20760		Profit	6700	0.387283237
Cost of goods sold	39.00%	10600			39.00%	11659			39.00%	12719			Profit Margin	38.7283236994
Depreciation	31%	3280			31%	3614			31%	6436
EBIT		3450				3933				4448		2016 A:
Interest		680				680				680		Profit	7371	0.3873357856
EBT		2770				4613				5128				39%
Tax	5.4%tax rate	940			5.4%tax rate	1034			5.4%tax rate	1128
Net Income (EAT)		$183,380,000.00	1830			$221,870,770.00	2219			$264,046,440.00	2640	2016 B:
Dividends		450				450				450		Profit	8041	0.3873314066
														39%
Balance Sheet
Assets
Current assets:												Assumptions: Consistant profit margin, dividend payout ration, assets/liabilities all vary proportionately with sales
Cash and securities		350		Added 10% to assets >		385		Added 20% to assets >		420
Accounts receivable		940		Added 10% to assets >		1034		Added 20% to assets >		1128
Inventories		2360		Added 10% to assets >		2596		Added 20% to assets >		2832
Total current assets		3650		Added 10% to assets >		4015		Added 20% to assets >		4380
Net fixed assets		10850				10850				10850
Total assets		14500				14865				15230
Liabilities and owners' equity
Current liabilities
Bank loan		0				-365				730
Accounts payable		1920
Total current liabilities		1920
Long-term debt		3500
Common stock		7500
Retained earnings		1580
Total liabilities and owners' equity		14500				14500				14500