Air Taxi - Build and Operate Business Plan Model (Excel XLSB)

AIRLINE INDUSTRY EXCEL DESCRIPTION

This product (Air Taxi - Build and Operate Business Plan Model) is an Excel template (XLSB) with a supplemental Zip archive file document, which you can download immediately upon purchase.

The flying taxi market is ready for takeoff, changing the travel experience forever. Fin-wiser’s AIR TAXI FM helps users to assess the financial viability of the Air Taxi business by capturing all the essential inputs related to construction, operation, and financing.

The Model includes assumptions related to:

1. Development cost, Construction costs and Developer’s Fee
2. Passenger Services (Passenger Yield, Passenger Traffic and Passenger Load Factor and Capacity)
3. Variable O&M cost per vehicle (divided into 8 subheads such as staff, electricity, consumables, transport and fuel) and other fixed costs (SPV, insurance, land lease, community payment, management fee & more)
4. Flexible Funding Profile – Cash equity, Bridge Loan, Bank Debt, DSRA and Bank overdraft
5. Working Capital Assumptions related to accounts receivables and payables
6. Straight Line and Accelerated Depreciation option
7. Annuity, Sculpted Debt and Even Principal Repayment options
8. Inflation and Indexation
9. VAT during construction and operations phase
10. Decommissioning cost and reserve, if required

Model Output includes:

1. Project IRR & NPV
2. Equity IRR & NPV
3. Minimum and Average DSCR
4. LLCR and PLCR
5. Equity Payback Period
6. Cash Waterfall
7. Debt Service Profile
8. Integrated Financial Statements
9. Fully Integrated Dashboard

Model Package includes:

1. Excel-based financial model (Excel binary format XLSB, as the primary document)

2. Model Heat Map (included in the secondary ZIP) – The file includes a heat map of the model with color codes on:
•  F: Unique formula
• 

Source: Best Practices in Airline Industry, Integrated Financial Model Excel: Air Taxi - Build and Operate Business Plan Model Excel (XLSB) Spreadsheet, Fin-Wiser Advisory