Calculate the Days receivable , Days inventory, Days Payable , operating cycle , and cash cycle 1

Calculate the Days receivable , Days inventory, Days Payable , operating cycle , and cash cycle

Transcribed Image Text:

1 in M$ in M$ in M$ 2 Jan. Feb. Mar Jan. Feb. Mar. Jan. Feb. Mar. 3 Operating Revenues 2,512 2,833 2,909 Cash and equivalents 1,895 1,951 2,108 Accounts Payable 370 375 381 4 Operating Expenses: Accounts receivable 1,321 1,422 1,453 Air traffic liability 605 523 543 5 Salaries, wages and benefi 690 780 803 Fuel inventory 190 203 204 Accrued liabilities 97 130 132 6 Aircraft fuel and taxes 601 611 633 Parts and supplies inventory 99 101 105 Curr. maturities of LTD 88 130 140 7 Landing fees and other rer 220 227 233 Prepaid expenses 44 45 46 Other current liabilities 22 33 33 8 Depreciation/amortization 143 143 143 Total Current Assets 3,549 3,722 3,916 Total Current Liabilities 1,182 1,191 1,229 9 Maintenance and repairs 101 104 107 Property, Plant & Equipme 4,858 4,949 4,943 LTD and lease obligations 253 259 264 10 Other operating expenses 44 45 47 Allowance for depreciation 2,121 2,168 2,215 Pension obligations 423 453 463 11 Total Operating Expenses 1,799 1,910 1,966 Net PP&E 2,737 2,781 2,728 Deferred revenue 245 258 263 12 Operating Income 713 923 943 Goodwill 198 202 207 Non-current operating lea 401 410 419 13 Other income/(expense) 22 23 23 Other assets 322 329 336 Other long term liabilities 104 106 109 14 Income before taxes 735 945 967 Total Assets 6,806 7,035 7,187 Stockholder's equity 4,198 4,359 4,440 15 Income tax expense 133 187 183 Total Liab. and equity 6,806 7,035 7,187 16 Net Income 602 758 784 17 18 Key Ratios 19 Jan. Feb. Mar. 20 Days Receivable 21 Days Inventory 22 Operating Cycle 23 Days Payable 24 Cash Cycle 25 = Q1 Q2 v. MAR24 + Workbook Statistics. 1 in M$ in M$ in M$ 2 Jan. Feb. Mar Jan. Feb. Mar. Jan. Feb. Mar. 3 Operating Revenues 2,512 2,833 2,909 Cash and equivalents 1,895 1,951 2,108 Accounts Payable 370 375 381 4 Operating Expenses: Accounts receivable 1,321 1,422 1,453 Air traffic liability 605 523 543 5 Salaries, wages and benefi 690 780 803 Fuel inventory 190 203 204 Accrued liabilities 97 130 132 6 Aircraft fuel and taxes 601 611 633 Parts and supplies inventory 99 101 105 Curr. maturities of LTD 88 130 140 7 Landing fees and other rer 220 227 233 Prepaid expenses 44 45 46 Other current liabilities 22 33 33 8 Depreciation/amortization 143 143 143 Total Current Assets 3,549 3,722 3,916 Total Current Liabilities 1,182 1,191 1,229 9 Maintenance and repairs 101 104 107 Property, Plant & Equipme 4,858 4,949 4,943 LTD and lease obligations 253 259 264 10 Other operating expenses 44 45 47 Allowance for depreciation 2,121 2,168 2,215 Pension obligations 423 453 463 11 Total Operating Expenses 1,799 1,910 1,966 Net PP&E 2,737 2,781 2,728 Deferred revenue 245 258 263 12 Operating Income 713 923 943 Goodwill 198 202 207 Non-current operating lea 401 410 419 13 Other income/(expense) 22 23 23 Other assets 322 329 336 Other long term liabilities 104 106 109 14 Income before taxes 735 945 967 Total Assets 6,806 7,035 7,187 Stockholder's equity 4,198 4,359 4,440 15 Income tax expense 133 187 183 Total Liab. and equity 6,806 7,035 7,187 16 Net Income 602 758 784 17 18 Key Ratios 19 Jan. Feb. Mar. 20 Days Receivable 21 Days Inventory 22 Operating Cycle 23 Days Payable 24 Cash Cycle 25 = Q1 Q2 v. MAR24 + Workbook Statistics.