Ondi Airlines is interested in acquiring a new aircraft to service a new route. The route will be from Tulsa to Denver. 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 $235. Annual operating costs of the aircraft follow:
The aircraft will cost $120,000,000 and has an expected life of 20 years. The company requires a 12% 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% booking is unrealistic. He believes that the booking rate will be somewhere between 70 and 90%, with the most likely rate being 80%. Recalculate the NPV by using an 80% seating capacity. Should the aircraft be purchased?
- 3. Calculate the average seating rate that would be needed so that NPV will equal zero. Round the seating rate to the nearest percent.
- 4. CONCEPTUAL CONNECTION Suppose that the price per passenger could be increased by 10% without any effect on demand. What is the average seating rate now needed to achieve an NPV equal to zero? What would you now recommend? Round the seating rate to the nearest percent.
1.
Find out the NPV of the aircraft. Also, recommend that the company should buy it or not.
Explanation of Solution
Net Present Value:
The remaining balance of the present value of a project’s inflows and outflows is known as net present value (NPV). It is a discounting model of capital investment decision. A project with a positive NPV increases the wealth of a firm whereas a project with a negative NPV decreases the wealth of a firm.
Use the following formula to calculate NPV of the investment:
Substitute $160,032,7521 for P and $120,000,000 for I in the above formula.
Therefore, net present value of the investment is $40,032,752.
The company should buy the aircraft because NPV is positive.
Working Note:
1. Calculation of expected cash flow:
Calculation of days of operation:
Calculation of revenue per year:
Calculation of annual cash flow:
Calculation of present value of future cash flow:
2.
Find out the NPV of the aircraft if the booking is 80% of seating capacity.
Explanation of Solution
Use the following formula to calculate NPV of the investment:
Substitute $123,171,0662 for P and $120,000,000 for I in the above formula.
Therefore, net present value of the investment is $3,171,066.
The company should buy the aircraft because NPV is positive.
Working Note:
2. Calculation of revised annual cash flow:
Calculation of present value of future cash flow:
3.
Calculate the seating rate at which NPV will equal zero.
Explanation of Solution
Calculate seating rate:
Use the following formula to calculate seats to be sold:
Substitute $55,1873 for revenue per day and $470 for revenue per seat in the above formula.
Therefore, seats to be sold in each trip are 118 seats.
Calculate seating rate:
Use the following formula to calculate the seating rate:
Substitute 118 seats for seats to be sold and 150 seats for total seats in the above formula.
Working Note:
3. Calculation of annual cash flow at which NPV equals 0:
Calculation of annual revenue:
Calculation of revenue per day:
4.
Calculate the seating rate at which NPV will equal zero and the price per passenger is increased by 10%. Also state the recommendations.
Explanation of Solution
Use the following formula to calculate seats to be sold:
Substitute $55,1873 for revenue per day and $5174 for revenue per seat in the above formula.
Therefore, seats to be sold in each trip are 107 seats.
Calculate seating rate:
Use the following formula to calculate the seating rate:
Substitute 107 seats for seats to be sold and 150 seats for total seats in the above formula.
The seating will be between 70% and 90% of the total seating. There is a possibility that the actual seating rate can be lower than the estimated rate. The interval is of 20% and it is most likely that NPV remain positive.
These analyses are drafted with the assumption that all the factors are constant. However, the price of the factors can change during the course of the useful of the aircraft.
Working Note:
4. Calculation of round trip average price:
Want to see more full solutions like this?
Chapter 12 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- A presently owned machine has the projected market value and M&O costs shown below. An outside vendor of services has offered to provide the service of the existing machine at a fixed price per year. If the presently owned machine is replaced now, the cost of the fixed-price contract will be $33,000 per year. If the presently owned machine is replaced next year or any time after that, the contract price will be $35,000 per year. Determine if and when the defender should be replaced with the outside vendor using an interest rate of 10% per year. Assume used equipment similar to the defender will always be available, but that the current equipment will not be retained more than three additional years. Retention Year Market Value, $ M&O Cost, $ per year 32,000 1 25,000 24,000 14,000 25,000 10,000 26,000 4 8000 The defender should be replaced (at the) nowarrow_forwardA presently owned machine has the projected market value and M&O costs shown below. An outside vendor of services has offered to provide the service of the existing machine at a fixed price per year. If the presently owned machine is replaced now, the cost of the fixed-price contract will be $33,000 per year. If the presently owned machine is replaced next year or any time after that, the contract price will be $35,000 per year. Determine if and when the defender should be replaced with the outside vendor using an interest rate of 10% per year. Assume used equipment similar to the defender will always be available, but that the current equipment will not be retained more than three additional years. Retention Year Market Value, $ M&O Cost, $ per Year 0 32,000 — 1 25,000 24,000 2 14,000 25,000 3 10,000 26,000 4 8,000 —arrow_forwardAn existing robot can be kept if $2,000 is spent now to upgrade it for future service requirements. Alternatively, the company can purchase a new robot to replace the old robot. The following estimates have been developed for both the defender and the challenger. The company's before-tax MARR is 15% per year. Based on this information, should the existing robot be replaced right now? Assume the robot will be needed for an indefinite period of time. Defender Challenger Current MV $37,000 Purchase price $55,000 Required upgrade $2,000 Installation cost $6,000 Annual expenses $1,600 Annual expenses $1,100 Remaining useful life 5 years Useful life 9 years MV at end of useful life −$1,600 MV at end of useful life $6000 The AW value of the defender is The AW value of the challenger isarrow_forward
- Click to see additional instructions A company is considering an investment in a new product with a 10-year horizon (product will be sold for 10 years). The upfront investment is $5 million and it is assumed to depreciate on a straight-line basis for 10 years, with no residual value. Fixed costs are assumed to be $550,000 per year. The company estimates variable cost per unit (v) to be $120 and expects to sell each unit for $425. There are no taxes and the required rate of return is 17% per year. Assume that the investment would occur today, and all future cash-flows will occur at the end of each year beginning in one year. What is the annual financial breakeven quantity? [Keep at least 3 decimals for intermediate answers. Round your final answer UP to the next highest WHOLE unit. (ie 421.2 would be rounded to 422)]arrow_forwardPlease help mearrow_forwardMachine replacement decisionA company is considering replacing an old piece of machinery, whichcost $400,000 and has $175,000 of accumulated depreciation to date, witha new machine that has a purchase price of $550,000. The old machinecould be sold for $250,000. The annual variable production costsassociated with the old machine are estimated to be $72,500 per year foreight years. The annual variable production costs for the new machineare estimated to be $24,000 per year for eight years.a. Prepare a differential analysis dated May 29 to determinewhether to continue with (Alternative 1) or replace (Alternative 2)the old machine.b. What is the sunk cost in this situation?arrow_forward
- Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.arrow_forwardCaduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.arrow_forwardNet present value method for a service company Coast-to-Coast Inc. is considering the purchase of an additional delivery vehicle for 70,000 on January 1, 20Y1. The truck is expected to have a five-year life with an expected residual value of 15,000 at the end of five years. The expected additional revenues from the added delivery capacity are anticipated to be 65,000 per year for each of the next five years. A driver will cost 40,000 in 20Y1, with an expected annual salary increase of 2,000 for each year thereafter. The annual operating costs for the truck are estimated to be 6,000 per year. a. Determine the expected annual net cash flows from the delivery truck investment for 20Y120Y5. b. Compute the net present value of the investment, assuming that the minimum desired rate of return is 12%. Use the present value table appearing in Exhibit 2 of this chapter. c. Is the additional truck a good investment based on your analysis? Explain.arrow_forward
- Shao Airlines is considering the purchase of two alternative planes. Plane A has an expected life of 5 years, will cost $100 million, and will produce net cash flows of $30 million per year. Plane B has a life of 10 years, will cost $132 million, and will produce net cash flows of $25 million per year. Shao plans to serve the route for only 10 years. Inflation in operating costs, airplane costs, and fares are expected to be zero, and the company’s cost of capital is 12%. By how much would the value of the company increase if it accepted the better project (plane)? What is the equivalent annual annuity for each plane?arrow_forwardWinthrop Company has an opportunity to manufacture and sell a new product for a five-year period. To pursue this opportunity, the company would need to purchase a plece of equipment for $130,000. The equipment would have a useful life of five years and a $10,000 salvage value. The CCA rate for the equipment is 30%. After careful study. Winthrop estimated the following annual costs and revenues for the new product: Sales revenues: Variable expenses Fixed expenses $250,000 $130,000 $ 70,000 The company's tax rate is 30% and its after-tax cost of capital is 10%. Required: 1. Compute the net present value of the project. (Hint Use Microsoft Excel to calculate the discount factor(s).) (Do not round intermediate calculations and PV factor. Round the final answers to the nearest whole dollar. Negative value should be indicated with minus sign.) 2. Would you recommend that the project be undertaken? 1. Net present value 2 Would you recommend that the project be undertaken?arrow_forwardAir Alberta is considering replacing the firm’s regional jets with a new model, which has a total purchase price of $15 million. The new jets will generate additional revenue of $3.5 million per year for the 20 years of the useful life of the jets. Expected added operational costs of the jets are 25% of revenues. Air Alberta expects to use the new jets for 20 years, at which time, they would be replaced. The company estimates that all the new planes could be sold for a total of $4.7 million (salvage value). The new regional jets have a CCA rate of 25% (d = .25). Air Alberta has a corporate tax rate of 35%. The purchase would require a $2,000,000 increase in net working capital, which would be returned to Air Alberta when it sold the jets after 20 years. Required: Using a discount rate of 15%, calculate the NPV of the new jet purchase. Prepare a short memo and discuss your recommendation on the purchase of the regional jets.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning