Evaluating Aircraft Upgrade Projects for QAN: Project A vs. Project B

Introduction

In the wake of the pandemic’s end, airlines are preparing to meet a surge in demand for travel. To address this challenge, QAN (fictional company) is considering two major upgrade projects: Project A and Project B. To make informed decisions and mitigate risks, QAN has engaged Rachel Consulting Limited to conduct comprehensive market research. This essay explores the financial feasibility of these projects by analyzing their discounted payback periods, taking into account initial costs, revenues, working capital, operating expenses, depreciation, salvage values, taxes, and the cost of capital.

Project Overview

Project A involves an initial investment of $800 million, while Project B requires an initial outlay of $650 million. The additional revenues generated by each project are $250 million (Project A) and $200 million (Project B) annually from year 1 to year 10. Both projects will also incur working capital expenses, with Project A incurring $100 million and Project B incurring $120 million immediately. This working capital will be recovered at the end of the respective projects. Operating costs for both projects are estimated at 35% of the generated revenue throughout the 10-year period. The projects will be depreciated on a straight-line basis over a decade to reach a zero book value. Additionally, QAN anticipates asset sales of $125 million (Project A) and $100 million (Project B) at the end of year 10. The applicable tax rate is 30%, and the cost of capital for both projects is 7%.

Discounted Payback Period Calculation

The discounted payback period is a critical metric that evaluates how long it takes to recoup the initial investment while considering the time value of money. It helps gauge the risk and feasibility of a project by incorporating the cost of capital.

Project A

Initial Outlay: $800 million

Annual Cash Inflow: $250 million

Initial Working Capital: -$100 million (recovered at project end)

Operating Expenses: 35% of Revenue

Salvage Value: $125 million

Tax Rate: 30%

Cost of Capital: 7%

Using the provided financial data and formulas, we can calculate the discounted payback period for Project A. The calculations involve discounting each year’s cash inflow and subtracting the initial investment and initial working capital to determine when the cumulative cash flows turn positive. After performing these calculations, the discounted payback period for Project A is determined.

Project B

Initial Outlay: $650 million

Annual Cash Inflow: $200 million

Initial Working Capital: -$120 million (recovered at project end)

Operating Expenses: 35% of Revenue

Salvage Value: $100 million

Tax Rate: 30%

Cost of Capital: 7%

Similar calculations are performed for Project B to determine its discounted payback period.

Conclusion

In conclusion, evaluating Project A and Project B’s discounted payback periods provides insights into the financial feasibility and risk associated with each upgrade project. By considering initial costs, annual cash inflows, working capital, operating expenses, depreciation, salvage values, taxes, and the cost of capital, QAN can make informed decisions regarding which project aligns better with its financial goals and risk appetite. This analysis underscores the importance of strategic financial planning in making successful investment decisions, especially in the dynamic post-pandemic aviation industry.