Delta Airlines

Ratio Analysis

Input Worksheet

$\frac{3}{6}\frac{?}{24}$

Gray cells will be calculated for you. You do not need to enter anything into them. When inputting the Q$1$ to Q$4$ data ensure that it is chronologically accurate with the end of Q$4$ being the se

Enter amounts into the yellow cells only.

Be sure to enter industry averages for the ratio calculations on the other pages of the spreadsheet by replacing every cell which contains red font. Use your elgebrale skills you have already mastered to calculate the deviation or the variance of your company's ratio with the industry$/$peer company's avarage.

$\backslash$table$[[$Line ltem,$\backslash$table$[[$Beginning$],[$of Year$]]],[$Inventory$,],[$Total assets,$],[$Owners$\text{'}$ equity,$],[$Number of common shares,$]]$

$\backslash$table$[[$Line Item,Q$1,$Q$2,$Q$3,$Q$4,$Annual$],[$Current assets,,,,,$$0$