Question

In: Finance

1. An airline is considering the purchase of an Airbus A-320neo which offers improved fuel efficiency...

1. An airline is considering the purchase of an Airbus A-320neo which offers improved fuel efficiency over the previous generation of narrow-body aircraft. The list price of the A-320 is $110 million, but the airline will receive a 30% discount off of list (typical in the airline industry). The finance department estimates the aircraft will generate a positive net cash flow of $7 million in the first year increasing by 5% annually owing to the aircraft’s fuel efficiency. The airline plans to operate the aircraft for 15 years, then sell it in year 16 for an estimated net cash price of $40 million. The airline targets a return on invested capital of 10% annually (use this rate rather than the interest rate to discount future cash flows). Note: This computation is easiest to perform using MS Excel. Develop a discounted cash flow analysis using Excel and present your recommendations. Copy and paste the Excel spreadsheets into your problem set answers (do not just use Excel’s built-in formulas). There are many Excel formats that could be used, including a built-in template. Here is one format that can be used.

Year NCF (Millions $) Discount Factor PV (millions $)
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

Solutions

Expert Solution


Related Solutions

An airline expects to purchase two million gallons of jet fuel in one month and decides...
An airline expects to purchase two million gallons of jet fuel in one month and decides to use heating oil futures for hedging. Suppose that the jet fuel standard deviation is 0.0313, the standard deviation of the stock price is 0.0263, and the correlation between futures and stock prices is  0.928. What is the optimal hedge ratio? - please explain step by step
A US airline company will purchase 400,000 gallons of jet fuel after one month and the...
A US airline company will purchase 400,000 gallons of jet fuel after one month and the company wants to do cross hedging using heating oil futures. The standard deviation of monthly changes in the spot price of jet fuel is (in cents per gallon) 300; the standard deviation of monthly changes in the futures price for the heating oil futures contract is (in cents per gallon) 407. The coefficient of correlation between the jet fuel price changes and the futures...
1. The thermal efficiency of a Rankine power cycle may be improved by i. Superheating the...
1. The thermal efficiency of a Rankine power cycle may be improved by i. Superheating the steam ii. Reheating the steam between high and lower pressure sections of the turbine iii. Regenerative Feedwater Heating iv. Insulating the turbine and decreasing the entropy production during the expansion process v. Incorporating a Rankine cycle power system as part of a cogeneration system a. Items i), ii), and iv) only b. Items i), iii), and v) only c. Items ii), iv) and v)...
1. The thermal efficiency of a Rankine power cycle may be improved by i. Superheating the...
1. The thermal efficiency of a Rankine power cycle may be improved by i. Superheating the steam ii. Reheating the steam between high and lower pressure sections of the turbine iii. Regenerative Feedwater Heating iv. Insulating the turbine and decreasing the entropy production during the expansion process v. Incorporating a Rankine cycle power system as part of a cogeneration system a. Items i), ii), and iv) only b. Items i), iii), and v) only c. Items ii), iv) and v)...
Adams Airline Company is considering expanding its territory. The company has the opportunity to purchase one...
Adams Airline Company is considering expanding its territory. The company has the opportunity to purchase one of two different used airplanes. The first airplane is expected to cost $14,790,000; it will enable the company to increase its annual cash inflow by $5,100,000 per year. The plane is expected to have a useful life of five years and no salvage value. The second plane costs $34,400,000; it will enable the company to increase annual cash flow by $8,600,000 per year. This...
1) ABC Ltd is considering a project which will require the purchase of a machine for...
1) ABC Ltd is considering a project which will require the purchase of a machine for RO1,000,000 at time zero, this machine will have a scrap value at the end of its four - year life: this will be equal to its written - down value. (25% declining balance writing - down allowance on the machine each year). Corporation tax, at a rate of 30% of taxable income, is payable. ABC Ltd's required rate of return is 12%. Operating cash...
Summarizing Bivariate Data (1) The data in table below represent airline fuel cost per gallon (in...
Summarizing Bivariate Data (1) The data in table below represent airline fuel cost per gallon (in dollars) for the US domestic and international carriers with scheduled service by month from July 2014 to December 2014. Month Domestic (x) International (y) July 3 2.84 August 2.98    2.84 September 2.89 2.81 October 2.69 2.67 November 2.58 2.55 December 2.3 2.3 (a) Find the correlation coefficient value r. (b) If we wish to predict international cost using the domestic cost, identify response...
Your firm is contemplating the purchase of a new model commercial airplane which is more fuel...
Your firm is contemplating the purchase of a new model commercial airplane which is more fuel efficient that the models your firm is currently flying. On the basis of capital budgeting techniques that we have learned and used, thus far, what are the factors that you will consider in deciding whether or not to purchase and add the newer model planes to your fleet. Explain thoroughly.
1. Three different makes of cars were tested for fuel efficiency. For each make of car...
1. Three different makes of cars were tested for fuel efficiency. For each make of car eighteen automobiles were randomly selected and subjected to standard driving procedures. Using the data from the following results compute the between treatments estimate of σ² and the within treatments estimate of σ². At the α=.05 level of significance, can the null hypothesis, that all fuel economies are the same, be rejected? Construct the ANOVA table for this data. (Use the formulas to compute the...
Sway's Back Store is considering a project which will require the purchase of $1 million in...
Sway's Back Store is considering a project which will require the purchase of $1 million in new equipment. The equipment will be depreciated straight-line to $200,000 over the 5-year life of the project. The first-year sale from this project is estimated at $800,000, then it keeps growing at a 5% rate. The variable cost is always 50% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT