PowerPoints slides :People Express

Soeavam007
DataSpreadsheet.xlsx
Home>Business & Finance homework help>Economics homework help>PowerPoints slides :People Express

Data

Period Capacity growth rate (%/year) Passenger growth (%/year) Aircraft Aircraft Acquisitions Load Factor Breakeven Load Factor Peoples Fare Average Competitor Fare Total Employees Employees Per Plane Hiring Employee Turnover Marketing Market Share (Fraction) Reported Service Quality Revenues ($ M/year) Net income Revenues ($ M/year) Breakeven Revenues ($ Million/Year) Passengers Carried Breakeven Passengers Load Factor Breakeven Load Factor Aircraft Aircraft Acquisitions Available Seat Miles Passengers Carried Load Factor Fleet costs Total Employees Rookie Fraction Hiring Employee Turnover Employee Turnover Net Change in Employees Average workweek Productivity ('000 Rev Pass Miles/Year/Employee) Reported Service Quality Value per Employee Assets Debt Equity Revenues ($ M/year) Fleet costs Service Marketing Interest Total Operating Costs Depreciation Net income Net Aircraft Purchases Net Cash Flow before financing Peoples Fare Average Competitor Fare Scope of Service Reported Service Quality Passenger growth (%/year) Market Share (Fraction) Marketing Average Competitor Fare Competitors Service Scope Competitor quality Stock Price Earnings per Share Outstanding Shares Market Value of Firm ($ Million) Cumulative Net Income ($ Million) Cumulative Market Value Employees Per Plane (Don Burr Strategy) Average Workweek of 40 hours Operating Profit Return on Assets Profit Margin Sales/Assets Cost of Capital Profit Margin strategic minimum Leverage Ratio Leverage Ration strategic maximum TIE (Times Interest Earned) Ratio TIE Ratio strategic minimum Sales/Assets strategic minimum Cash Flow from Operations Cash Flow From Investing Cash Flow from Financing Net Cash Flow Assets Debt Equity Interest Expense Interest Income Points RoA - Cost of Capital Leverage Ratio TIE Ratio Service Scope Price Violations/Quarter (not RoA)
Year 0 Qtr 4 0 0 3 0 0.57 0.54 0.09 0.16 165 55 9 9 3.2 0.002 1 32.3 1.5 32.3 30.8 359 342.1 0.57 0.54 3 0 693 359 0.57 16.5 165 0.2 9 9 0 0.06 43.16 2179 1 45.5 29.5 21.9 7.7 32.3 16.5 6.9 3.2 2.3 28.9 1.9 1.5 0 3.4 0.09 0.16 0.6 1 0 0.002 3.2 0.16 1 0.7 1.88 0.1 4 7.5 0 7.5 55 40 3.8 0.13 0.12 1.09 0.1 0.05 3.83 4 1.65 2 1.00 3.4 0 0 3.4 29.5 21.9 7.7 2.3 0
Year 1 Qtr 1 0 0 3 0 0.53 0.47 0.1 0.16 186 62 30 9 1.7 0.002 0.99 33.2 4 33.2 29.2 369 324.6 0.53 0.47 3 0 693 369 0.53 16.5 186 0.35 30 9 21 0.05 54.62 1984 0.99 45.5 29.5 21.4 8.1 33.2 16.5 6.9 1.7 2.3 27.3 1.9 4 0 5.8 0.1 0.16 0.8 0.99 0 0.002 1.7 0.16 1 0.7 1.88 0.25 4 7.5 0 7.5 55 40 6.3 0.21 0.19 1.13 0.1 0.05 3.64 4 2.74 2 1.00 5.9 -0.1 6 11.8 29.5 21.4 8.1 2.3 0 2 0 0 0 0 0
Year 1 Qtr 2 0 27.31 4 1 0.43 0.29 0.115 0.16 243 61 70 13 2.3 0.002 0.94 45.3 14.7 45.3 30.6 394 265.7 0.43 0.29 4 1 924 394 0.43 16.5 243 0.41 70 13 57 0.05 56.85 1621 0.94 137.4 39.1 25.8 13.3 45.3 16.5 7.8 2.3 2.1 28.7 1.8 14.7 40 -23.4 0.115 0.16 0.9 0.94 27.31 0.002 2.3 0.16 1 0.7 6.38 0.85 4.33 25.5 1 26.5 55 40 16.8 0.43 0.37 1.16 0.1 0.05 2.94 4 8.00 2 1.00 16.5 -39.9 56.4 33 39.1 25.8 13.3 2.1 0 2 0 0 0 0 0
Year 1 Qtr 3 100 38.97 5 1 0.37 0.27 0.13 0.159 300 60 90 32 2.8 0.002 0.83 56.2 16.1 56.2 40 432 307.9 0.37 0.27 5 1 1155 432 0.37 22 300 0.41 90 32 58 0.11 57.3 1438 0.83 149.8 48.5 29.8 18.6 56.2 22 10.2 2.8 2.6 37.6 2.4 16.1 40 -21.4 0.13 0.159 0.95 0.83 38.97 0.002 2.8 0.159 1 0.7 8.41 0.89 4.56 36.4 4.7 41 55 40 18.7 0.39 0.33 1.16 0.1 0.05 2.61 4 7.19 2 1.00 18.5 -39.9 58.4 37 48.5 29.8 18.6 2.6 0 2 0 0 0 0 0
Year 1 Qtr 4 80 33.36 5 0 0.41 0.31 0.14 0.159 344 69 90 46 3.3 0.002 0.71 65.5 16.1 65.5 49.4 468 352.9 0.41 0.31 5 0 1155 468 0.41 27.5 344 0.44 90 46 44 0.13 56.55 1359 0.71 144.3 47.7 26.2 21.5 65.5 27.5 12.6 3.3 3 46.4 3 16.1 0 19.2 0.14 0.159 0.98 0.71 33.36 0.002 3.3 0.159 1 0.7 9.52 0.88 4.56 43.3 8.7 52 55 40 19.1 0.40 0.29 1.37 0.1 0.05 2.22 4 6.37 2 1.00 19.1 0.1 19 38.2 47.7 26.2 21.5 3 0 2 0 0 0 0 0
Year 2 Qtr 1 0 14.26 6 1 0.35 0.26 0.14 0.159 420 70 130 54 3.4 0.002 0.63 67.9 16.9 67.9 51 485 364 0.35 0.26 6 1 1386 485 0.35 27.5 420 0.41 130 54 76 0.13 54.26 1154 0.63 116.2 57 30 27 67.9 27.5 14.5 3.4 2.6 48 3 16.9 40 -20.1 0.14 0.159 0.99 0.63 14.26 0.002 3.4 0.159 1 0.7 8.79 0.89 4.76 40 12.7 52.8 55 40 19.5 0.34 0.29 1.19 0.1 0.05 2.11 4 7.50 2 1.00 19.9 -40 59.9 39.8 57 30 27 2.6 0 2 0 0 0 0 0
Year 2 Qtr 2 66.67 20.33 7 1 0.32 0.27 0.14 0.159 477 68 120 63 3.6 0.003 0.61 71.3 10.5 71.3 60.8 509 434 0.32 0.27 7 1 1617 509 0.32 33 477 0.3 120 63 57 0.13 51.44 1069 0.61 104.9 66.1 34.9 31.2 71.3 33 17.6 3.6 3 57.2 3.6 10.5 40 -25.9 0.14 0.159 0.99 0.61 20.33 0.003 3.6 0.159 1 0.7 9.26 0.53 5.01 44.1 17 61 55 40 13.5 0.20 0.19 1.08 0.1 0.05 2.12 4 4.50 2 1.00 14.1 -40 54.1 28.2 66.1 34.9 31.2 3 0 2 0 0 0 0 0
Year 2 Qtr 3 57.14 17.61 7 0 0.33 0.31 0.14 0.159 469 67 65 72 3.7 0.003 0.61 74.5 4.6 74.5 69.9 532 498.9 0.33 0.31 7 0 1617 532 0.33 38.5 469 0.26 65 72 -7 0.15 50.42 1133 0.61 84.3 65 33.2 31.8 74.5 38.5 20 3.7 3.5 65.7 4.1 4.6 0 8.7 0.14 0.159 1 0.61 17.61 0.003 3.7 0.159 1 0.7 8.02 0.23 5.01 40.2 19.6 59.8 55 40 8.1 0.12 0.11 1.15 0.1 0.05 2.04 4 2.31 2 1.00 8.7 0 8.7 17.4 65 33.2 31.8 3.5 0 2 0 0 0 0 0
Year 2 Qtr 4 0 21.28 7 0 0.35 0.31 0.14 0.159 464 66 65 70 3.9 0.003 0.64 78.4 8.9 78.4 69.5 560 496.5 0.35 0.31 7 0 1617 560 0.35 38.5 464 0.24 65 70 -5 0.15 50.51 1206 0.64 105.6 64 30.8 33.2 78.4 38.5 19.7 3.9 3.3 65.5 4.1 8.9 0 13 0.14 0.159 1 0.64 21.28 0.003 3.9 0.159 1 0.7 9.89 0.44 5.01 49.5 20.7 70.3 55 40 12.2 0.19 0.16 1.23 0.1 0.05 1.93 4 3.70 2 1.00 13 0 13 26 64 30.8 33.2 3.3 0 2 0 0 0 0 0
Year 3 Qtr 1 0 20.37 7 0 0.36 0.31 0.14 0.159 466 67 65 64 4.1 0.003 0.68 82.4 13.2 82.4 69.2 589 494.3 0.36 0.31 7 0 1617 589 0.36 38.5 466 0.23 65 64 1 0.14 50.84 1264 0.68 138.5 63 27.6 35.5 82.4 38.5 19.5 4.1 3.1 65.2 4 13.2 0 17.2 0.14 0.159 1 0.68 20.37 0.003 4.1 0.159 1 0.7 12.84 0.66 5.01 64.3 23 87.3 55 40 16.3 0.26 0.20 1.31 0.1 0.05 1.77 4 5.26 2 1.00 17.2 0 17.2 34.4 63 27.6 35.5 3.1 0 2 0 0 0 0 0
Year 3 Qtr 2 0 20.46 7 0 0.38 0.31 0.14 0.159 476 68 65 55 4.3 0.003 0.73 86.6 17.5 86.6 69.1 619 493.5 0.38 0.31 7 0 1617 619 0.38 38.5 476 0.22 65 55 10 0.12 50.84 1301 0.73 182.4 62 23.5 38.5 86.6 38.5 19.6 4.3 2.8 65.1 3.9 17.5 0 21.5 0.14 0.159 1 0.73 20.46 0.003 4.3 0.159 1 0.7 16.96 0.88 5.01 84.9 26.3 111.2 55 40 20.3 0.33 0.23 1.40 0.1 0.05 1.61 4 7.25 2 1.00 21.4 0.1 21.3 42.8 62 23.5 38.5 2.8 0 2 0 0 0 0 0
Year 3 Qtr 3 0 20.52 7 0 0.4 0.31 0.14 0.159 493 70 65 48 4.6 0.003 0.77 91.1 21.8 91.1 69.3 650 494.7 0.4 0.31 7 0 1617 650 0.4 38.5 493 0.19 65 48 17 0.1 50.32 1319 0.77 233 61.1 18.7 42.3 91.1 38.5 20 4.6 2.4 65.4 3.9 21.8 0 25.7 0.14 0.159 1 0.77 20.52 0.003 4.6 0.159 1 0.7 22.13 1.09 5.01 110.9 30.7 141.5 55 40 24.2 0.40 0.27 1.49 0.1 0.05 1.44 4 10.08 2 1.00 25.7 0 25.7 51.4 61.1 18.7 42.3 2.4 0 2 0 0 0 0 0
Year 3 Qtr 4 0 16.94 7 0 0.42 0.31 0.14 0.159 497 71 50 46 4.7 0.003 0.8 94.9 25.3 94.9 69.6 678 497.4 0.42 0.31 7 0 1617 678 0.42 38.5 497 0.17 50 46 4 0.09 50.26 1365 0.8 279.2 60.1 13.3 46.8 94.9 38.5 20.7 4.7 1.9 65.8 3.8 25.3 0 29.1 0.14 0.159 1 0.8 16.94 0.003 4.7 0.159 1 0.7 27.48 1.26 5.01 137.6 36.1 173.8 55 40 27.2 0.45 0.29 1.58 0.1 0.05 1.28 4 14.32 2 1.00 29.1 0 29.1 58.2 60.1 13.3 46.8 1.9 0 2 0 0 0 0 0
Year 4 Qtr 1 0 17.22 7 0 0.44 0.31 0.14 0.158 495 71 45 46 5 0.003 0.82 99 29.6 99 69.4 707 495.7 0.44 0.31 7 0 1617 707 0.44 38.5 495 0.16 45 46 -1 0.09 50.78 1427 0.82 349.1 59.2 7 52.2 99 38.5 20.9 5 1.3 65.6 3.8 29.6 0 33.4 0.14 0.158 1 0.82 17.22 0.003 5 0.158 1 0.7 34.61 1.48 5.01 173.4 42.4 215.8 55 40 30.9 0.52 0.31 1.67 0.1 0.05 1.13 4 23.77 2 1.00 33.4 0 33.4 66.8 59.2 7 52.2 1.3 0 2 0 0 0 0 0
Year 4 Qtr 2 0 17.05 7 0 0.46 0.3 0.14 0.158 495 71 45 46 5.2 0.003 0.84 103.2 34.4 103.2 68.9 737 491.9 0.46 0.3 7 0 1617 737 0.46 38.5 495 0.07 45 46 -1 0.09 51.65 1491 0.84 398.2 58.2 -0.1 58.4 103.2 38.5 20.8 5.2 0.7 65.2 3.7 34.4 0 38.1 0.14 0.158 1 0.84 17.05 0.003 5.2 0.158 1 0.7 39.38 1.71 5.01 197.3 49.8 247.1 55 40 35.1 0.60 0.34 1.77 0.1 0.05 1.00 4 50.14 2 1.00 38.1 0 38.1 76.2 58.4 0 58.4 0.7 0 2 0 0 0 0 0
Year 4 Qtr 3 0 16.5 7 0 0.47 0.3 0.14 0.158 449 64 0 46 5.4 0.003 0.84 107.5 39.2 107.5 68.3 768 487.7 0.47 0.3 7 0 1617 768 0.47 38.5 449 0.03 0 46 -46 0.1 53.28 1711 0.84 448.3 57.3 -8.2 65.5 107.5 38.5 20.8 5.4 0 64.6 3.6 39.2 0 42.8 0.14 0.158 1 0.84 16.5 0.003 5.4 0.158 1 0.7 44.25 1.96 5.01 221.7 58.4 280.1 55 40 39.2 0.68 0.36 1.88 0.1 0.05 0.87 4 100.00 2 1.00 42.8 0 42.8 85.6 65.5 0 65.5 0 0 2 0 0 0 0 0
Year 4 Qtr 4 0 15.68 7 0 0.49 0.29 0.14 0.158 407 58 0 42 5.6 0.004 0.82 111.7 45.6 111.7 66.1 798 472.2 0.49 0.29 7 0 1617 798 0.49 38.5 407 0.15 0 42 -42 0.1 55.65 1961 0.82 565.5 56.4 -17.4 73.8 111.7 38.5 18.8 5.6 -0.4 62.5 3.6 45.6 0 49.2 0.14 0.158 1 0.82 15.68 0.004 5.6 0.158 1 0.7 50.65 2.28 5.01 253.7 68.2 321.9 55 40 46 0.82 0.41 1.98 0.1 0.05 0.76 4 100.00 2 1.00 49.2 0 49.2 98.4 73.8 0 73.8 0 0.4 2 0 0 0 0 0
Year 5 Qtr 1 0 14.59 7 0 0.51 0.28 0.14 0.158 428 61 60 39 5.8 0.004 0.78 115.8 51.7 115.8 64 827 457.4 0.51 0.28 7 0 1617 827 0.51 38.5 428 0.33 60 39 21 0.09 56.99 1932 0.78 699 55.6 -27.7 83.3 115.8 38.5 17.1 5.8 -0.9 60.5 3.5 51.7 0 55.3 0.14 0.158 1 0.78 14.59 0.004 5.8 0.158 1 0.7 56.76 2.58 5.01 284.3 79.6 364 55 40 52.6 0.95 0.45 2.08 0.1 0.05 0.67 4 100.00 2 1.00 55.2 0.1 55.1 110.4 83.3 0 83.3 0 0.9 2 0 0 0 0 0
Year 5 Qtr 2 0 13.13 10 3 0.37 0.2 0.14 0.158 536 54 150 42 6 0.004 0.73 119.6 55 119.6 64.5 854 461 0.37 0.2 10 3 2310 854 0.37 38.5 536 0.4 150 42 108 0.08 57.18 1593 0.73 701.8 84.7 -16.2 100.9 119.6 38.5 18 6 -1.4 61.1 3.5 55 120 -61.5 0.14 0.158 1 0.73 13.13 0.004 6 0.158 1 0.7 59.96 2.7 5.1 300.4 92.5 392.9 55 40 56.4 0.67 0.47 1.41 0.1 0.05 0.84 4 100.00 2 1.00 58.5 -120 178.5 117 100.9 0 100.9 0 1.4 2 0 0 0 0 0
Year 5 Qtr 3 120 40.3 13 3 0.31 0.24 0.13 0.158 683 53 200 53 12.2 0.004 0.69 122.2 28 122.2 94.2 940 724.8 0.31 0.24 13 3 3003 940 0.31 55 683 0.36 200 53 147 0.08 56.54 1377 0.69 304.5 113.4 0 113.3 122.2 55 22.5 12.2 -0.8 88.9 5.3 28 120 -86.7 0.13 0.158 1 0.69 40.3 0.004 12.2 0.158 1 0.7 32.01 1.31 5.34 163.3 106.3 269.6 55 40 28.8 0.25 0.24 1.08 0.1 0.05 1.00 4 100.00 2 1.00 33.3 -120 153.3 66.6 113.4 0 113.3 0 0.8 2 0 0 0 0 0
Year 5 Qtr 4 92.31 42.49 13 0 0.35 0.31 0.13 0.157 782 60 175 75 13.5 0.004 0.66 135.2 14.4 135.2 120.8 1040 929.1 0.35 0.31 13 0 3003 1040 0.35 71.5 782 0.24 175 75 100 0.1 56.47 1329 0.66 166 111.6 -4 115.6 135.2 71.5 28.7 13.5 0 113.7 7.1 14.4 0 21.5 0.13 0.157 1 0.66 42.49 0.004 13.5 0.157 1 0.7 21.21 0.67 5.34 113.3 113.3 226.6 55 40 14.4 0.13 0.11 1.21 0.1 0.05 0.97 4 100.00 2 1.00 21.5 0 21.5 43 115.6 0 115.6 0 0 2 0 0 0 0 0
Year 6 Qtr 1 0 51.49 13 0 0.39 0.32 0.13 0.157 779 60 75 78 15.3 0.005 0.65 152.6 26.2 152.6 126.4 1174 972.3 0.39 0.32 13 0 3003 1174 0.39 71.5 779 0.19 75 78 -3 0.1 56.64 1506 0.65 235.2 109.9 -10.2 120.1 152.6 71.5 32.9 15.3 -0.2 119.4 7 26.2 0 33.2 0.13 0.157 1 0.65 51.49 0.005 15.3 0.157 1 0.7 34.44 1.23 5.34 184 116.9 300.9 55 40 26.4 0.24 0.17 1.39 0.1 0.05 0.92 4 100.00 2 1.00 33.2 0 33.2 66.4 120.1 0 120.1 0 0.2 2 0 0 0 0 0
Year 6 Qtr 2 0 36.5 13 0 0.43 0.33 0.13 0.157 776 60 75 78 16.7 0.005 0.65 166.5 39.3 166.5 127.2 1281 978.7 0.43 0.33 13 0 3003 1281 0.43 71.5 776 0.17 75 78 -3 0.1 57.39 1650 0.65 329.4 108.1 -18.9 127 166.5 71.5 32.7 16.7 -0.5 120.4 6.9 39.3 0 46.2 0.13 0.157 1 0.65 36.5 0.005 16.7 0.157 1 0.7 48.04 1.84 5.34 256.6 123.5 380.1 55 40 39.8 0.37 0.24 1.54 0.1 0.05 0.85 4 100.00 2 1.00 46.2 0 46.2 92.4 127 0 127 0 0.5 2 0 0 0 0 0
Year 6 Qtr 3 0 30.72 13 0 0.46 0.33 0.13 0.156 774 60 75 78 17.9 0.006 0.64 179.3 51.5 179.3 127.9 1379 983.5 0.46 0.33 13 0 3003 1379 0.46 71.5 774 0.17 75 78 -3 0.1 58.41 1783 0.64 414.2 106.4 -29.8 136.2 179.3 71.5 32.6 17.9 -0.9 121.1 6.8 51.5 0 58.2 0.13 0.156 1 0.64 30.72 0.006 17.9 0.156 1 0.7 60.18 2.41 5.34 321.5 133.3 454.8 55 40 52.4 0.49 0.29 1.69 0.1 0.05 0.78 4 100.00 2 1.00 58.3 -0.1 58.4 116.6 136.2 0 136.2 0 0.9 2 0 0 0 0 0
Year 6 Qtr 4 0 27.4 13 0 0.49 0.33 0.13 0.156 771 59 75 77 19.2 0.006 0.63 191.6 63.3 191.6 128.3 1474 987.1 0.49 0.33 13 0 3003 1474 0.49 71.5 771 0.22 75 77 -2 0.1 59.1 1911 0.63 495.2 104.8 -42.9 147.7 191.6 71.5 32.5 19.2 -1.5 121.7 6.7 63.3 0 69.9 0.13 0.156 1 0.63 27.4 0.006 19.2 0.156 1 0.7 71.7 2.96 5.34 383.1 146.2 529.2 55 40 64.8 0.62 0.34 1.83 0.1 0.05 0.71 4 100.00 2 1.00 70 -0.1 70.1 140 147.7 0 147.7 0 1.5 2 0 0 0 0 0
Year 7 Qtr 1 0 23.59 13 0 0.52 0.33 0.13 0.155 824 63 130 77 20.3 0.006 0.61 202.9 74.3 202.9 128.6 1561 989.1 0.52 0.33 13 0 3003 1561 0.52 71.5 824 0.23 130 77 53 0.09 59.3 1894 0.61 568.6 103.1 -58.1 161.2 202.9 71.5 32.4 20.3 -2.1 122 6.5 74.3 0 80.9 0.13 0.155 1 0.61 23.59 0.006 20.3 0.155 1 0.7 82.08 3.48 5.34 438.5 162 600.5 55 40 76.4 0.74 0.38 1.97 0.1 0.05 0.64 4 100.00 2 1.00 80.8 0.1 80.7 161.6 161.2 0 161.2 0 2.1 2 0 0 0 0 0
Year 7 Qtr 2 0 19.47 13 0 0.55 0.34 0.13 0.155 872 67 130 82 21.3 0.007 0.59 212.8 81.8 212.8 130.9 1637 1007.2 0.55 0.34 13 0 3003 1637 0.55 71.5 872 0.2 130 82 48 0.09 59.24 1878 0.59 575.5 101.5 -74.6 176.1 212.8 71.5 34.6 21.3 -2.9 124.5 6.4 81.8 0 88.3 0.13 0.155 1 0.59 19.47 0.007 21.3 0.155 1 0.7 88.78 3.83 5.34 474.3 180.5 654.9 55 40 84.7 0.83 0.40 2.10 0.1 0.05 0.58 4 100.00 2 1.00 88.2 0.1 88.1 176.4 176.1 0 176.1 0 2.9 2 0 0 0 0 0
Year 7 Qtr 3 0 12.93 13 0 0.56 0.34 0.13 0.154 885 68 100 87 22 0.007 0.58 219.7 87 219.7 132.7 1690 1020.7 0.56 0.34 13 0 3003 1690 0.56 71.5 885 0.19 100 87 13 0.1 59.12 1910 0.58 567.4 99.9 -92.1 192 219.7 71.5 36.6 22 -3.7 126.3 6.3 87 0 93.3 0.13 0.154 1 0.58 12.93 0.007 22 0.154 1 0.7 92.58 4.07 5.34 494.6 201 695.6 55 40 90.7 0.91 0.41 2.20 0.1 0.05 0.52 4 100.00 2 1.00 93.3 0 93.3 186.6 192 0 192 0 3.7 2 0 0 0 0 0
Year 7 Qtr 4 0 7.85 13 0 0.57 0.34 0.13 0.154 896 69 100 88 22.4 0.007 0.58 224 91.3 224 132.7 1723 1020.7 0.57 0.34 13 0 3003 1723 0.57 71.5 896 0.19 100 88 12 0.1 59.02 1923 0.58 574.8 98.4 -110.4 208.8 224 71.5 37.2 22.4 -4.6 126.4 6.2 91.3 0 97.5 0.13 0.154 1 0.58 7.85 0.007 22.4 0.154 1 0.7 95.16 4.27 5.34 508.4 222.7 731.2 55 40 95.9 0.97 0.43 2.28 0.1 0.05 0.47 4 100.00 2 1.00 97.5 0 97.5 195 208.8 0 208.8 0 4.6 2 0 0 0 0 0
Year 8 Qtr 1 0 5.7 13 0 0.58 0.34 0.13 0.153 907 70 100 90 22.7 0.007 0.58 227.2 94.7 227.2 132.5 1747 1019.1 0.58 0.34 13 0 3003 1747 0.58 71.5 907 0.18 100 90 10 0.1 58.93 1928 0.58 578.1 96.8 -129.3 226.1 227.2 71.5 37.6 22.7 -5.5 126.3 6.1 94.7 0 100.8 0.13 0.153 1 0.58 5.7 0.007 22.7 0.153 1 0.7 96.96 4.43 5.34 518 245.6 763.6 55 40 100.2 1.04 0.44 2.35 0.1 0.05 0.43 4 100.00 2 1.00 100.8 0 100.8 201.6 226.1 0 226.1 0 5.5 2 0 0 0 0 0
Year 8 Qtr 2 0 4.38 13 0 0.59 0.34 0.13 0.153 916 70 100 91 23 0.007 0.58 229.6 97.5 229.6 132.1 1766 1016.4 0.59 0.34 13 0 3003 1766 0.59 71.5 916 0.18 100 91 9 0.1 58.85 1929 0.58 580.3 95.3 -148.7 244 229.6 71.5 38.1 23 -6.5 126.1 6.1 97.5 0 103.6 0.13 0.153 1 0.58 4.38 0.007 23 0.153 1 0.7 98.45 4.56 5.34 526 269.2 795.3 55 40 104 1.09 0.45 2.41 0.1 0.05 0.39 4 100.00 2 1.00 103.6 0 103.6 207.2 244 0 244 0 6.5 2 0 0 0 0 0
Year 8 Qtr 3 0 3.51 13 0 0.59 0.34 0.13 0.152 924 71 100 92 23.2 0.007 0.59 231.7 100 231.7 131.7 1782 1012.7 0.59 0.34 13 0 3003 1782 0.59 71.5 924 0.18 100 92 8 0.1 58.76 1928 0.59 581.8 93.8 -168.6 262.4 231.7 71.5 38.5 23.2 -7.4 125.7 6 100 0 106 0.13 0.152 1 0.59 3.51 0.007 23.2 0.152 1 0.7 99.73 4.68 5.34 532.8 293.6 826.5 55 40 107.4 1.14 0.46 2.47 0.1 0.05 0.36 4 100.00 2 1.00 106 0 106 212 262.4 0 262.4 0 7.4 2 0 0 0 0 0
Year 8 Qtr 4 0 2.92 13 0 0.6 0.34 0.13 0.152 932 72 100 92 23.3 0.007 0.59 233.4 102.3 233.4 131.1 1795 1008.4 0.6 0.34 13 0 3003 1795 0.6 71.5 932 0.18 100 92 8 0.1 58.62 1926 0.59 582.4 92.4 -188.9 281.2 233.4 71.5 38.8 23.3 -8.4 125.2 5.9 102.3 0 108.1 0.13 0.152 1 0.59 2.92 0.007 23.3 0.152 1 0.7 100.75 4.79 5.34 538.3 318.6 856.9 55 40 110.7 1.20 0.47 2.53 0.1 0.05 0.33 4 100.00 2 1.00 108.2 -0.1 108.3 216.4 281.2 0 281.2 0 8.4 2 0 0 0 0 0
Year 9 Qtr 1 0 2.48 13 0 0.6 0.33 0.13 0.152 939 72 100 93 23.5 0.007 0.59 234.8 104.3 234.8 130.4 1806 1003.4 0.6 0.33 13 0 3003 1806 0.6 71.5 939 0.18 100 93 7 0.1 58.49 1924 0.59 583.8 90.9 -209.5 300.4 234.8 71.5 39.1 23.5 -9.4 124.7 5.8 104.3 0 110.1 0.13 0.152 1 0.59 2.48 0.007 23.5 0.152 1 0.7 101.82 4.88 5.34 544 344.2 888.2 55 40 113.7 1.25 0.48 2.58 0.1 0.05 0.30 4 100.00 2 1.00 110.1 0 110.1 220.2 300.4 0 300.4 0 9.4 2 0 0 0 0 0
Year 9 Qtr 2 0 2.11 13 0 0.6 0.33 0.13 0.151 945 73 100 94 23.6 0.007 0.6 236 106.3 236 129.7 1816 998 0.6 0.33 13 0 3003 1816 0.6 71.5 945 0.18 100 94 6 0.1 58.38 1922 0.6 585.9 89.5 -230.5 320 236 71.5 39.4 23.6 -10.5 124.1 5.7 106.3 0 112 0.13 0.151 1 0.6 2.11 0.007 23.6 0.151 1 0.7 102.94 4.97 5.34 550 370.3 920.2 55 40 116.8 1.31 0.49 2.64 0.1 0.05 0.28 4 100.00 2 1.00 112 0 112 224 320 0 320 0 10.5 2 0 0 0 0 0
Year 9 Qtr 3 0 1.77 13 0 0.61 0.33 0.13 0.151 950 73 100 94 23.7 0.007 0.6 237.1 108.1 237.1 129 1824 992 0.61 0.33 13 0 3003 1824 0.61 71.5 950 0.17 100 94 6 0.1 58.27 1919 0.6 588.5 88.1 -251.8 339.9 237.1 71.5 39.7 23.7 -11.5 123.4 5.6 108.1 0 113.7 0.13 0.151 1 0.6 1.77 0.007 23.7 0.151 1 0.7 104.06 5.06 5.34 556 396.8 952.8 55 40 119.6 1.36 0.50 2.69 0.1 0.05 0.26 4 100.00 2 1.00 113.7 0 113.7 227.4 339.9 0 339.9 0 11.5 2 0 0 0 0 0
Year 9 Qtr 4 0 1.47 13 0 0.61 0.33 0.13 0.15 955 73 100 95 23.8 0.007 0.6 238 109.8 238 128.1 1830 985.6 0.61 0.33 13 0 3003 1830 0.61 71.5 955 0.17 100 95 5 0.1 58.16 1916 0.6 591.3 86.7 -273.4 360.2 238 71.5 39.9 23.8 -12.6 122.6 5.5 109.8 0 115.3 0.13 0.15 1 0.6 1.47 0.007 23.8 0.15 1 0.7 105.18 5.14 5.34 562 423.9 985.8 55 40 122.4 1.41 0.51 2.75 0.1 0.05 0.24 4 100.00 2 1.00 115.3 0 115.3 230.6 360.2 0 360.2 0 12.6 2 0 0 0 0 0
Year 10 Qtr 1 0 1.22 13 0 0.61 0.33 0.13 0.15 960 74 100 96 23.9 0.007 0.6 238.7 111.4 238.7 127.2 1836 978.8 0.61 0.33 13 0 3003 1836 0.61 71.5 960 0.17 100 96 4 0.1 58.07 1913 0.6 594.4 85.4 -295.4 380.7 238.7 71.5 40.1 23.9 -13.7 121.8 5.4 111.4 0 116.9 0.13 0.15 1 0.6 1.22 0.007 23.9 0.15 1 0.7 106.29 5.21 5.34 567.9 451.3 1019.2 55 40 125.1 1.46 0.52 2.80 0.1 0.05 0.22 4 100.00 2 1.00 116.8 0.1 116.7 233.6 380.7 0 380.7 0 13.7 2 0 0 0 0 0
Year 10 Qtr 2 0 0.97 13 0 0.61 0.32 0.13 0.15 964 74 100 96 23.9 0.007 0.6 239.3 113 239.3 126.3 1840 971.6 0.61 0.32 13 0 3003 1840 0.61 71.5 964 0.17 100 96 4 0.1 57.97 1910 0.6 597.7 84.1 -317.5 401.6 239.3 71.5 40.3 23.9 -14.8 121 5.3 113 0 118.3 0.13 0.15 1 0.6 0.97 0.007 23.9 0.15 1 0.7 107.36 5.29 5.34 573.6 479.2 1052.8 55 40 127.8 1.52 0.53 2.85 0.1 0.05 0.21 4 100.00 2 1.00 118.3 0 118.3 236.6 401.6 0 401.6 0 14.8 2 0 0 0 0 0
Year 10 Qtr 3 0 0.7 13 0 0.61 0.32 0.13 0.149 967 74 100 96 24 0.006 0.61 239.7 114.4 239.7 125.3 1844 964 0.61 0.32 13 0 3003 1844 0.61 71.5 967 0.17 100 96 4 0.1 57.86 1906 0.61 600.8 82.7 -340 422.7 239.7 71.5 40.5 24 -15.9 120.1 5.3 114.4 0 119.6 0.13 0.149 1 0.61 0.7 0.006 24 0.149 1 0.7 108.38 5.35 5.34 579 507.4 1086.5 55 40 130.3 1.58 0.54 2.90 0.1 0.05 0.20 4 100.00 2 1.00 119.7 -0.1 119.8 239.4 422.7 0 422.7 0 15.9 2 0 0 0 0 0
Year 10 Qtr 4 0 0.48 13 0 0.61 0.32 0.13 0.149 971 75 100 97 24 0.006 0.61 240 115.7 240 124.3 1846 956.2 0.61 0.32 13 0 3003 1846 0.61 71.5 971 0.08 100 97 3 0.1 57.77 1902 0.61 603.9 81.4 -362.6 444.1 240 71.5 40.6 24 -17 119.1 5.2 115.7 0 120.8 0.13 0.149 1 0.61 0.48 0.006 24 0.149 1 0.7 109.34 5.41 5.34 584.2 536 1120.2 55 40 132.7 1.63 0.55 2.95 0.1 0.05 0.18 4 100.00 2 1.00 120.9 -0.1 121 241.8 444.1 0 444.1 0 17 2 0 0 0 0 0
Market Value 584.2
Points
RoA - Cost 80 +
Violations 0 -
Total 80
Breakdown
Violations # Quarters
Leverage Ratio 0
TIE Ratio 0
Service Scope 0
Price 0

Charts

Growth Rates

Value per Employee (Thousands $/Person)

Income Statement (Millions $)

Net Cash Flow Before Financing (Millions $)

Scope of Service Competitive Positions

Service Quality - Competitive Position

Price - Competitive Position

Market Value (Millions $)

Return on Capital compared to the Cost of Capital (%)

Return on Sales (%)

Capital Structure: Leverage Ratio (Total Assets/Equity)

Aircraft Fleet (No of Aircraft)

Capital Structure: Safety in Repaying Debt (Earnings/Interest Expense)

Sales/Assets Efficiency in generating sales from assets

Marketing (Millions $)

Cash Flow (Millions $)

Revenues (Millions $)

Balance Sheet (MIllions $)

Load Factors (Seats Occupied/Total Seats)

Employees per Plane

Hiring Decisions (in People)

Service Quality

Average Hours Worked per Week