For the firm, Aurora.Co, with the “Summary and Historical Operating Data” and “Balance Sheet Data”...

Question

For the firm, Aurora.Co, with the “Summary and Historical Operating Data” and “Balance Sheet Data” as the ones shown in the spreadsheet attached (BOX 1 and 2), please calculate the following items:Historical years are XXXXXXXXXXLast twelve-month (LTM) is year 2012. Projected period is XXXXXXXXXX; Terminal Year is 2017.The yearly Sales growth is as shown in the spreadsheet attached, BOX 1: starting with XXXXXXXXXX% sales growth), XXXXXXXXXX% sales growth), LTM (last twelve months XXXXXXXXXX% sales growth), projected XXXXXXXXXX% sales growth), projected XXXXXXXXXX% sales growth), projected XXXXXXXXXX% sales growth), projected XXXXXXXXXX% sales growth) and projected terminal year XXXXXXXXXX% sales growth).The Cost of Goods Sold in 2009 is $1,612 millions.The Gross Profit Margin (Gross Profit/Sales) for each year is as shown in the corresponding row in the spreadsheet attached, BOX 1.EBITDA for 2009 is $491.4 millions.EBITDA Margin (EBITDA/Sales) for each year is as shown in the corresponding row in the spreadsheet attached, BOX 1.EBIT for 2009 is $336.4 millions.EBIT Margin (EBIT/Sales) for each year is as shown in the corresponding row in the spreadsheet attached, BOX 1.Capex for 2009 is $114.4 millions.Capex as a percentage of Sales for each year is as shown in the corresponding row in the spreadsheet attached, BOX 1.Net Working Capital (NWC) in 2012 is $635 millions.NWC as a percentage of Sales for each year is as shown in the corresponding row in the spreadsheet attached, BOX 2.The data is in an Excel sheet that I uploaded.Please answer 10 questions that I upload.

Preeta · Accepted Answer

Meet Aurora.Co
	Aurora. Co, Scenario 1
	BOX 1
	Summary Historical Operating Data
	Fiscal Year ending December 31,				LTM	Projected				Terminal
	( $ in millions )	2009	2010	2011	2012	2013 E	2014 E	2015 E	2016 E	2017 E
	Sales	$2,600.00	$2,899.00	$3,197.60	$3,447.01	$3,705.54	$3,927.87	$4,124.26	$4,289.23	$4,417.91
	% growth	NA	0.115	0.103	0.078	0.075	0.060	0.050	0.040	0.030
	Cost of Goods Sold	$1,612.00	$2,887.69	$3,184.81	$3,433.22	$3,690.71	$3,912.16	$4,107.76	$4,272.07	$4,400.24
	Gross Profit		$11.31	$12.79	$13.79	$14.82	$15.71	$16.50	$17.16	$17.67
	% margin		0.390	0.400	0.400	0.400	0.400	0.400	0.400	0.400
	Selling, General & Admin.		$5.51	$6.08	$6.55	$7.04	$7.46	$7.84	$8.15	$8.39
	EBITDA 	$491.40	$5.80	$6.71	$7.24	$7.78	$8.25	$8.66	$9.01	$9.28
	% margin		0.200	0.210	0.210	0.210	0.210	0.210	0.210	0.210
	Depreciation & Amortization		$1.65	$1.92	$2.07	$2.22	$2.36	$2.47	$2.57	$2.65
	EBIT 	$336.40	$4.15	$4.80	$5.17	$5.56	$5.89	$6.19	$6.43	$6.63
	% margin		0.143	0.150	0.150	0.150	0.150	0.150	0.150	0.150
	Capex	$114.40	$1.16	$1.44	$1.55	$1.67	$1.77	$1.86	$1.93	$1.

For the firm, Aurora.Co, with the “Summary and Historical Operating Data” and “Balance Sheet Data” as the ones shown in the spreadsheet attached (BOX 1 and 2), please calculate the following items:...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment