Start-up Airlines Proforma Excel Model Template
Originally published: 07/05/2018 15:28
Last version published: 18/07/2019 19:52
Publication number: ELQ-93566-8
View all versions & Certificate
certified

Start-up Airlines Proforma Excel Model Template

This was a financial model for a start-up airlines to raise funds from the investors and banks.

Description
It is a prof-forma for a start-up airline . It contains various inputs for revenue, COGS, operating expenses, capex etc.

It Includes:
- 5-year monthly and annual Income Statement
- 5-year monthly and annual Balance Sheet
- 5-year monthly and annual Cash Flow Statement.

The Revenue, Cost of Revenue, S, G &A Expenses and Depreciation Schedule tabs are for calculation of various items that feed in Income Statement, Balance Sheet and Cash Flow Statement.

The excel model also includes valuation, break-even, cap tables and different charts & graphs. The valuation sheet calculates NPV and EBITDA multiple valuation of business and also shows IRR to the investors. The break-even sheet is for calculating load factor at which the business will break-even. The charts tab different graphs to show different financial metrics like forecast Revenue, EBITDA, Net Profit, Net Worth during the 5-year forecast period.
The input tab contains all the assumptions in yellow cells. Any change in those cells will automatically flow to the entire model.

Objectives: To create proforma for a start-up

Use if: Creating pro-forma for a start-up which has not yet started operations

Don't use if: Proforma for a start-up which need historical figures to be added.

Note: Remember to unlock the model with the password included in the "Instructions" tab.

This Best Practice includes
1 Financial Model in Excel

Acquire business license for $89.00

Add to cart

Add to bookmarks

Discuss


4.0 / 5 (3 votes)

please wait...