I need help with the following questions....

see picture for questions...

Using the data presented in the table below for Blue Sky lnc.: 2011 2010 _ $7.550.000 $6,150,000 Cost of Goods 5,750,000 4,550,000 Dereciation 100,000 Sellin: and G&A Ex-enses 730,000 Fixed Exenses 200,000 Lease Exense 150,000 Interest Exense 300,000 Tax Rate 40.00% Shares Outstandin 80,000 Cash 50,000 Marketable Securities 100,000 Accounts Receivable 350,000 Invento 1 250,000 850,000 Preaid EXoenses 120,000 40,000 Plant & Eo-uiment 5,350,000 4,800,000 Accumulated Dereciation 290,000 Lon Term Investments 360,000 Accounts Pa able 380,000 Notes Pa able 100,000 Accrued Exenses 100,000 Other Current Liabilities 180,000 Lon-term Debt 2,500,000 Common Stock 2,000,000 Additional Paid-in-Caital 500,000 Retained Earnins 500,000 Stock rice er share 12 1. Create an Excel workbook containing the Blue Sky's comparable income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet within your workbook. Improve the readability of the data by formatting numbers, headings and columns. Document the appropriate n0te(s) at the bottom of each nancial statement. 2. Calculate and display all appropriate nancial metrics (ratios) for Blue Sky. Provide a narrative (your business assessment) for each metric. Note: Use cell references as applicable for each metric. 3. Create a common-size income statement and balance sheet for 2011 and 2010. These statements should be created on a separate worksheet with all formulas linked directly to the income statement and balance sheet