Coyote Inc. analyzing the implications of profitability (attached file)

profileDice
q.xlsx

Sheet1

Coyote Inc.
Income Statement
For the Year Ended 2011
Net Sales 1,833,000
Cost of Goods Sold 1,072,000
Gross Profit 761,000
Selling Expenses 279,000
General and Administrative Expenses 175,000
Depreciation Expense 14,000 468,000
Operating Profit 293,000
Other Income (Expense)
Interest Income 13,000
Interest Expense (16,000) (3,000)
Pre-tax Income 290,000
Income Tax Expense 116,000
Net Income Neo 174,000

Sheet2

Sheet3