Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 442 Weeks Ago, 6 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 23 May 2017 My Price 8.00

Eden Airlines is interested in acquiring a new aircraft to service a new route

Eden Airlines is interested in acquiring a new aircraft to service a new route. The route will be from Dallas to El Paso. The aircraft will fly one round-trip daily except for scheduled maintenance days. There are 15 maintenance days scheduled each year. The seating capacity of the aircraft is 150. Flights are expected to be fully booked. The average revenue per passenger per flight (one-way) is $200. Annual operating costs of the aircraft follow:
Fuel ………………………..$1,400,000
Flight personnel …………... 500,000
Food and beverages ………. 100,000
Maintenance ……………… 400,000
Other ……………………… 100,000
Total ………………………. $2,500,000
The aircraft will cost $100,000,000 and has an expected life of 20 years. The company requires a 14 percent return. Assume there are no income taxes.

Required:
1. Calculate the NPV for the aircraft. Should the company buy it?
2. In discussing the proposal, the marketing manager for the airline believes that the assumption of 100 percent booking is unrealistic. He believes that the booking rate will be somewhere between 70 and 90 percent, with the most likely rate being 80 percent. Recalculate the NPV by using an 80 percent seating capacity. Should the aircraft be purchased?
3. Calculate the average seating rate that would be needed so that NPV will equal zero.
4. Suppose that the price per passenger could be increased by 10 percent without any effect on demand. What is the average seating rate now needed to achieve a NPV equal to zero? What would you now recommend?

Answers

Alpha Geek
(8)
Status NEW Posted 23 May 2017 08:05 AM My Price 8.00

-----------

Attachments

file 1495528745-368660_1_636310491691219471_NPV1.xlsx preview (83 words )
Pe-----------r y-----------ear----------- ea-----------rni-----------ng -----------fro-----------m f-----------lig-----------htA-----------nnu-----------al -----------ope-----------rat-----------ing----------- co-----------stR-----------etu-----------rns----------- re-----------qui-----------red-----------Air-----------cra-----------ft -----------cos-----------tYe-----------arC-----------ash----------- fl-----------owP-----------res-----------ent----------- Va-----------lue----------- of----------- ca-----------shf-----------low-----------Net----------- pr-----------ese-----------nt -----------Val-----------ue(-----------365------------15-----------)*2-----------00*-----------150-----------*2(-----------mul-----------tip-----------ly -----------by -----------2 b-----------eca-----------use----------- of----------- ro-----------und----------- tr-----------ip)-----------Ans-----------wer----------- 1.----------- An-----------swe-----------r 2-----------.Pe-----------r y-----------ear----------- ea-----------rni-----------ng -----------fro-----------m f-----------lig-----------ht -----------on -----------80%----------- se-----------ati-----------ng -----------cap-----------aci-----------tyN-----------PVN-----------PV -----------is -----------neg-----------ati-----------ve -----------so -----------air----------- cr-----------aft----------- sh-----------oul-----------d n-----------ot -----------pur-----------cha-----------sed-----------Ans-----------wer----------- 3.-----------(36-----------5-1-----------5)*-----------209-----------.50-----------76*-----------(15-----------0*8-----------0%)-----------*2P-----------er -----------yea-----------r e-----------arn-----------ing----------- fr-----------om -----------fli-----------ght----------- on----------- 80-----------% s-----------eat-----------ing----------- ca-----------pac-----------ity----------- an-----------d p-----------ric-----------e i-----------ncr-----------eas-----------ed -----------by -----------10%-----------(36-----------5-1-----------5)*-----------(20-----------0*(-----------1+1-----------0%)-----------)*(-----------150-----------*80-----------%)*-----------2Av-----------era-----------ge
Not Rated(0)