Takeover Assignment

sariaro345
Q4Data.xls

Performance Measures

Comparative Results - Industry Detail
Performance Measures for period 4, ind1:
Company Weighted Score Net Profit ($) Stock Price ($) Quality Reliability Cumulative Net Profit ($) Yield per Seat Mile Passenger Load (%) Revenue ($) Aircraft Util. (%) Earnings per Share ($) Cash Balance ($) Loan Balance ($)
Crystal Clear Airlines (a) 79.3 -62129 19.44 70 91.1 -9968 0.187 62 2853486 101 -0.41 0 6182052
ORDER 66 (b) 76.6 -69122 16.16 72 93.9 -89936 0.195 51 2670677 108 -0.45 1039684 426711
Bonomo Airlines (c) 92.5 -301385 19.95 94 98.8 -86919 0.197 70 11479096 98 -1.97 626667 426711
Thor Airlines (d) 73.7 -1444930 18.38 90 98.8 -1089839 0.173 42 8640252 101 -9.01 539681 426711
Soarin' Voyages (e) 65.3 -264403 6.34 69 93.3 -774389 0.177 56 2664111 101 -1.36 0 5900946
Valiant Airlines (f) 72.3 -129832 10.67 78 95.4 -597665 0.187 47 4218040 99 -0.62 348950 839766
Superior Airways (g) 71.7 -1274930 10.75 94 98.8 -3109685 0.185 41 13194807 98 -5.09 1570739 3386711
Hulk Airlines (h) 92.7 -471679 22.7 94 98.8 -31812 0.207 46 13049170 100 -3.01 205362 0
JJC Aviation (i) 69.6 -517882 11.6 85 98 -1079717 0.166 43 5808059 100 -2.8 34244 1151681
Alpha Airlines (j) 62.2 -614307 10.18 62 91.4 -1088705 0.177 48 3494442 98 -4.1 578387 426711
Atom Airlines (k) 82 36623 24.45 59 92.7 247373 0.203 55 3472584 96 0.24 192154 426711
AirOne (l) 68.2 -142627 9.12 69 93.4 -420751 0.185 49 2453926 105 -0.6 1587378 2594851

Decision Measures

Comparative Results - Industry Detail
Decision Measures for period 4, ind1:
Company Training ($) Advertising ($) Cumulative Advertising ($) Promotion ($)
Crystal Clear Airlines (a) 9000 12000 31500 12000
ORDER 66 (b) 4000 3000 14000 3000
Bonomo Airlines (c) 66000 52500 115000 52500
Thor Airlines (d) 50000 65000 189000 65000
Soarin' Voyages (e) 3200 3200 15500 3500
Valiant Airlines (f) 17500 20000 60500 20000
Superior Airways (g) 100000 70000 212500 40000
Hulk Airlines (h) 100000 70000 177500 70000
JJC Aviation (i) 23000 3250 14750 3250
Alpha Airlines (j) 10000 6000 26500 6000
Atom Airlines (k) 1500 3000 14000 2500
AirOne (l) 2000 5000 16500 3000