Please Show how you got the work!!!!

McCabe decides to estimate the amount of funds QC will have to obtain in 2012. She knows that 2012 is expected to be a big year for the company, particularly as the weak economy increases the sales of fancy foods for entertaining at home. As a result, sales are predicted to increase by 25 percent, to $230 million. Due to the strong demand, the marketing vice president feels any cost increases can easily be passed on, and McCabe estimates that the cost of goods sold (mostly food ingredients) will be $180 million. Cost of goods sold does not include depreciation (estimated at $5 million), and administrative and selling expenses ($15 million). The corporate tax rate is 35 percent.

Part A: Using the data in exhibits C5.1 and C5.2, discuss how Quaker Crackers results compare to its industry. You will need to prepare a pro forma income statement (using the table below) before proceeding.

Income Statement	(in millions)
Sales
Cost of goods sold
Gross profit
Depreciation expense
Advertising and selling expenses
Profits before taxes
Income Taxes
Net income
Current (times)
Quick (times)
Debt (%)
Average collection period (days)
Total asset turnover (times)
Return on Equity (%)

Part B: After entering the calculations in the table above, discuss specific metrics that can be used to analyze working capital performance. Type your two- to three-sentence response below.

Part A: Show changes to the 2012 pro forma balance sheet assuming the company borrows the necessary funds for the capital improvements at an interest rate of 7 percent. Ignore depreciation on the new equipment. Enter your calculations in the table provided below.

Assets	Calculations	Liabilities and Owners Equity	Calculations
Cash and Marketable Securities		Notes payable
Accounts Receivable		Accounts payable
Inventory		Accrued expenses
Current Assets		Current liabilities
Gross Fixed Assets		Long-term debt
Accumulated Depreciation		Common Stock ($10 par)
Net fixed assets		Retained earnings
Total assets		Total liabilities and owners equity

Part B: Does this cause any significant change in the financials? Type your two- to three-sentence response below.

Play the role of a financial analyst and explain your recommended course of action. Type your three- to five-sentence response below.

The Cynsky family controls the company through its ownership of one half of the outstanding stock, with outsiders owning the balance. Should this influence McCabes presentation of her recommendations? What arguments can you make in support of and against McCabes position? Type your four- to five-sentence response below.

Why was the information provided in the second paragraph about competitive companies in the fancy food industry? Type your two- to four-sentence response below.

Price earnings ratio	16
current ratio	1.8
quick ratio	0.6
total debt ratio	53
total asset turnover ratio	1.5
return on equity	8
return on sales	2.5
Average collection period	27
Assets			Liabilities and equity
Cash anf marketbale securities	16,000		Notes paybale	0
acoounts receivable	16,000
invenotry	23,000		Accounts paybale	19,500
current assests	55,000
gross fixed assets	52,000		accrued	6,000
accmulated depreciation	-12,000		current liabilties	25,500
			long term debt	0
net fixed assets	40,000		common stock ($10 par)	40,000
total assets	95,000		Retianed earnings	29,500
			Total liabilties and equity	95,000