Golden Eagle Airlines Case Study

Question 1The Annual Cash flow idler be surrounded by ?39.040 negative to ?273.180 positive according to pessimistic and optimistic scenarios accordingly, which be the sums of Capital Allowance and Profit after Tax (see link up Excel saddle). This figure is actually influenced by the suspicious parameters that ar given in the case study (Hours Flown, Charter hurt/Hour, tag end Price/Hour, aptitude of Schedules Flights, balance of charter flights and operating(a) Cost/ hr).

Question 2Optimistic vs. Pessimistic% change in enigmatic parameter % change in property flowCapacity of Sch. Flights 60%504%Ticket Price/Hour63%359%Pessimistic vs. OptimisticCapacity of Sch. Flights -38%-83%Ticket Price/Hour -38%-78%As it is depicted in the attached excel file, the higher (more optimistic) the anticipate sizes of the uncertain parameters are the higher the Cash flow order they result in. However, Ticket Price/Hour and Capacity of plan flights seem to be the most of the essence(predicate) since their shift results in signifi quartert change on the Cash flow size. to a greater extent specific, Capacity of Scheduled flight is the parameter with the highest downside effect.

The least strategic uncertain parameters are Operating Cost/hour and Ratio of charter flights.

The above results are indicated by the Range of cash flows between optimistic and pessimistic scenarios (see attached excel file for summary table and one-way data tables) and the relevant crack cocaine diagram provided right below.

From the @RISK regression analysis we can see that the highest coefficient calculated is for Ticket Price/Hour (0,588) and Capacity of scheduled flights (0,531), thus verifying the claim that these two uncertain parameters are the most important, since a change on these parameters endure the highest multiplicative effect on cash flow. Similarly, one can see that the lowest coefficients are for Operating Cost/hour and Ratio of charter flights (-0,133 and 0,074 respectively).

If we vary the two most important parameters to shoot forher (two-way data table) as shown in the table...

If you want to get a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper