Solved Question: Assume that you are the project manager at Textron Aviation (TXT)

Get premium Solution to all your Homework Assignments exclusively on writerkingdom. We have CFA/MBA writers to provide customized model answers to your every academic problem

Compare

Description

Question:

Assume that you are the project manager at Textron Aviation (TXT). Textron Aviation products include corporate and business, personal, and military aircraft. For purposes of this discussion, you have knowledge that in recent years most of Textron Aviation’s military products have, where possible, been outfitted with Winglets. Further, the design of these wing components has evolved to make them more efficient and maximize the fuel savings they provide. Textron Aviation flight operations manager reports finding that the addition of Winglets to an existing aircraft offers fuel savings of approximately 3% of the gas bill, or 150,000 gallons of jet fuel per year (Aviation Partners, Inc., n.d.). At a cost of $1.06 per gallon (which for simplicity, we will assume to be stable), this is a significant source of cost-reduction which accrues to the end user over the useful life of an aircraft. While the useful life of the corporate craft is 30 years, Textron’s research indicates that clients typically use a 10-year planning horizon, at most.

Answer:

Part A

  • Since saving is 150,000 gallons of fuel will be saved and cost per gallon is $1.06 so per year saving would be 159,000.
  • These savings are in future value so in order to get saving in present value, we have to discount it with 15% (given)
  • All future values are discounted and sum of all value comes out to be 797,984
  • So potential cost saving will be 797,984 over the period of 10 years

15% 150000 150000 Discount 1.06 1.06 1.06900 104545.081 159000 159000 138260.87 <=D2/(1+$B$1)A2 120226.843 < D3/(1+$B$1)^A3 2 3 150000 4 150000 1.06 1900 5 150000 6 150000 1.06159000 68740.0877 7 150000 8 150000 1.06 15900051977.382 9 150000 All these future SaVing values have saving values have been discounted 90908.766 1.0690 79051.1009 1.065900 59773.9893 1.0659000 45197.7235 rate given in B1 to see total saving in present value 10 150000 1.06 159000 39302.3683 -D11/(1+SB$1)AA11 Sum 1590000797,984

Part B

the potential financial benefit to Textron of adding winglets

= Additional revenue they can charge ( total cost saving by user) – Cost of winglets

= 797,984 – 556,000

241,984

Part C)

Concerns we have to look for

  • Resources that we will be using for this project is less valuable elsewhere ( means getting return lower than return from this project)
  • We are getting the return of 26% but we are not considering other factors like whether production process will change the cost.
  • Change of fuel price will impact the saving so will additional revenue due to winglet

Part D)

As of now our NPV is positive and it is

= 797,984 – 556,000 = 241,984

In order to make our NPV zero, we need to find the discount factor that makes NPV zero

556,000= \frac{CF1}{(1+DF)^1} + \frac{CF2}{(1+DF)^2} + \frac{CF3}{(1+DF)^3}+ ......\frac{CF10}{(1+DF)^10}

So, in excel using goal seek it is found that df is 26%.

Goal seek: Set the value = 556,000 in E12 by changing B1to g the t discount rate.

Importance: Since the rate is higher than 15% means the

  • project is viable and diversion of resources can be done from the project which has the lower return than 26%.
  • Sustainability will be there even when revenue is dropped because we are getting higher return than minimum discount rate i.e. 15%
  • Even when fuel price decrease is acceptable (up to 0.7385, using goal seek )

Reviews

There are no reviews yet.

Be the first to review “Solved Question: Assume that you are the project manager at Textron Aviation (TXT)”

Your email address will not be published. Required fields are marked *