I thought this could a useful thing to invite our learned readers to make an objective start to analysing wannabe Ozjet Airlines' likely financial performance over the next 5 years.
I have basically laid out 4 tables here for people to add elements to and modify as required. Please ensure you sum the columns after making your changes. Just copy and paste from previous post.
Let's see if we can determine how Ozjet might perform. You can add as many lines as required but no silly stuff please because we could get some really useful insight here.
==============================================
Profit/Loss Statement AUD ( $A) 60 Seats 737-200
Period 10 June 05 - Start Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Revenue
-pax tkt sales
-grants
Expenses
- fuel
- direct labour
- contract labour
- depreciation
- property rent
- equip leases
- airways charges
- overheads
Net Profit
Tax
Profit
=============================================
=============================================
Balance Sheet
Period 10 June 05 - Start Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Assets
Current Assets
-cash at bank
Non-Current Assets
- aircraft
less accum depr
- equip
less accum depr
Net Assets
Liabilities
Current Liabilities
- employee prov
Non Current Liabilities
- employee prov
Net Liabilities
Capital
Retained Earnings
Equity
==============================================
==============================================
Statement of Cash Flows
Period 10 June 05 - Start Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Inflows
Cash from Investment
Cash from Operations
Outflows
Cash to Operations
Cash to acquire Assets
Net Cash Flow In/(out)
==============================================
==============================================
Performance
Period 10 June 05 - Start Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Pax
RPK
Cost/Ask (Cents)
# Airplanes
# FT Employees
# FT Employees/Airpl
==============================================
Notes and Assumptions: (add as required)
1.
2.
==============================================
Thanks to all who contribute.