RATIO ANALYSIS

profileRaoof.
Exapmle3.xlsx

Cash Flow Statement

Cash Flow for Qantas
CASH FLOW Notes 2015 ($) Millions 2016 ($) Millions Notes 2017 ($) Millions 2018 ($) Millions
CASHFLOW FROM OPERATING ACTIVITIES
Cash receipts from customers $5,176.7 $5,567.4 $5,657.1 $6,099.7
Cash payments to suppliers & employees -$4,785.6 -$5,118.6 -$5,131.2 -$5,366.0
Cash generated from operations $391.1 $448.8 $525.9 $733.7
cash payments for business transformation expense -$82.5 -$110.0 -$121.8 -$44.8
Finance income received $18.8 $11.4 $17.0 $19.2
Finance cost paid -$109.3 -$151.7 -$147.2 -$137.7
Net Cash from Operating activities B6 $218.1 $198.5 B6 $273.9 $570.4
CASHFLOW FROM INVESTING ACTIVITIES
Acquisition of property, plant and equipment -$577.3 -$713.4 -$436.7 -$546.5
Proceeds from disposal of property, plant and equipment $147.4 $418.4 D1 $188.0 $7.7
Aquisitition of intangible assets -$60.3 -$46.8 -$37.2 -$44.4
Acquisition of subsidiary, net of cash acquired F1 $3.2 -$2.3 F1 NA NA
Advances of loans to joint venture -$23.8 NA NA NA
Proceeds from loans to joint venture $8.2 NA NA NA
Payments for other deposits -$72.9 -$49.1 -$48.4 -$56.8
Proceeds from other deposits $2.6 $4.2 $1.2 $77.0
Dividends from equity accounted investees NA NA $1.5 NA
Net cash used in investing activities (excluding aircraft operating lease refinancing) NA NA -$331.6 -$563.0
Aircraft operating lease refinancing NA NA NA -$5.7
Net cash used in investing activities -$572.9 -$389.0 -$331.6 -$568.7
CASH FLOWS FROM FINANCING ACTIVITIES
Proceeds from borrowings $910.7 $875.8 $557.0 $356.9
Repayments of borrowings -$525.4 -$713.6 -$1,098.9 -$307.1
payments of transaction costs related to borrowing -$34.9 -$10.1 -$13.1 -$6.0
Redemption of convertible notes -$74.7 NA NA NA
net proceeds from share issue NA $151.9 $931.4 NA
Net Paymwnt for share buy-backs NA NA E4 NA -$5.3
Equity distributions paid to non-controlling interests F5 -$17.8 -$41.9 F5 -$38.2 -$47.1
Repayments of loans from associate -$4.2 NA NA NA
Proceeds from non-controlling interests F5 $336.0 $1.1 F5 NA NA
Payments of transaction costs relating to non-controlling interests -$8.8 NA NA NA
Net cash from financing activities $580.9 $263.2 $338.2 -$8.6
Net increase in cash and cash equivalents $226.1 $72.7 $280.5 -$6.9
Cash and cash equivalents at 1 July $783.8 $1,028.5 $1,123.8 $1,396.1
Effect of exchange rate fluctuations on cash and cash equivalents $18.6 $22.6 -$8.2 $26.3
Cash and cash equivalents at 30 June E2 $1,028.5 $1,123.8 E2 $1,396.1 $1,415.5

&"Verdana,Italic"&9This Cash Flow Statement is intended as a GUIDE ONLY and DOES NOT constitute financial advice, please verify and discuss your financial statements with a qualified accountant, solicitor or financial advisor.

Using this Cash Flow Statement

Using this Cash Flow Statement
This cash flow statement contains a list of suggested profit items and expenses a typical business may have. You can edit these items by removing or adding rows and typing in your own items. To get started enter the financial year at the top of the sheet and enter your opening balance figure in the first column. Please note: This statement assumes all figures are GST inclusive. Formulas When you enter your figures, the sheet will automatically calculate your totals and net profit at the bottom. If you are adding or removing rows please double-check your figures to ensure the calculations have been preserved. Calculations Gross profit/net sales equals Sales minus cost of goods sold minus any other expenses related to the production of a good or service. Net profit equals Gross profit/net sales minus Total expenses. This Cash Flow statement is intended as a GUIDE ONLY and DOES NOT constitute financial advice, please verify and discuss your financial statements with a qualified accountant, solicitor or financial advisor.
This Cash Flow statement has been developed by business.gov.au, the Australian Government's principal business resource, located within the Department of Industry. Copies of the latest version of this spreadsheet can be downloaded from www.business.gov.au. If you need further information, assistance or referral about a small business issue, please contact us on 13 28 46.