1: Use an Excel spreadsheet to calculate each of the ratios listed in the table. Be sure to show your work.

2: Briefly comment in your Excel spreadsheet on the appropriateness of Boeing and the other competitors as an aspirant company for comparison.

3: In your Excel spreadsheet, compare each calculated ratio to the industry ratios given in the table. Briefly explain whether the calculated ratio would be viewed positively or negatively relative to the industry and why

Transcribed Image Text:

sas AIR, INC. 2014 Income Statement $40,259,230 29,336,446 Sales Cost of goods sold 5,105,100 Other expenses 1,804,220 $ 4,013,464 Depreciation EBIT 630,520 Interest $ 3,382,944 1,353,178 $ 2,029,766 Taxable income Taxes (40%) Net income $ 6 10,000 Dividends 1,419,766 Add to retained earnings SaS AIR, INC. 2014 Balance Sheet Assets Liabilities and Equity Current assets Current liabilities Cash $ 456,435 $ 929,005 2,121,350 $ 3,050,355 Accounts payable Accounts receivable 733,125 Notes payable Inventory 1,073,180 Total current liabilities Total current assets $ 2,262,740 Long-term debt $ 5,500,000 Fixed assets Shareholder equity Net plant and equipment $17,723,430 Common stock Retained earnings Total equity Total liabilities and equity $ 400,000 11,035,815 $11,435,815 $19,986,170 Total assets $19,986,170