Delta Airlines

Ratio Analysis

Input Worksheet

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 skills you have already mastered to calculate the deviation or the variance of your company's ratio with the industry. Please help to complete the table below