RATIO ANALYSIS

profileRaoof.
Exapmle4.xlsx

Cash Flow Statement

Cash Flow for Qantas
CASH FLOW Notes 2015 ($) Millions 2016 ($) Millions Notes 2017 ($) Millions Notes 2018 ($) Millions
CASH FLOW FROM OPERATIONAL ACTIVITIES
Cash incoming
Cash receipts from customers $17,239 $17,723 $16,947 $18,039
Cash payments to suppliers & employees (excl. cash payments to employees for wage free bonus, redundencies & related costs -$14,747 -$14,600 -$13,982 -$14,393
Cash generated from operations $2,492 $3,123 $2,965 $3,646
cash repayments to employees for redundencies & reltaed costs -$251 -$90 -$50 -$42
Cash payments to employee for Turnaround, Wage Freeze and Record Results bonuses NA -$53 -$87 -$74
interest received $85 $64 $37 $41
Interest paid -$281 -$227 -$164 -$161
Dividends received from investments accounted for under the equity method $5 $4 $7 $6
Income tax paid -$2 -$2 -$4 -$3
Net Cash from Operating activities 21 $2,048 $2,819 21A $2,704 21A $3,413
CASH FLOW FROM INVESTING ACTIVITIES
Payments for property, plant and equipment and intangible assets -$1,359 -$1,618 -$1,368 -$1,959
Interest paid and capitalised on qualifying assets 4 -$17 -$24 4 -$45 4 -$44
Payments for the acquisition of controlled entities, net of cash acquired -$7 NA NA NA
Payments for investments accounted for under the equity method -$58 -$39 -$16 -$2
Net receipts for aircraft assigned to investments accounted for under the equity method $266 NA NA NA
Proceeds from disposal of property, plant and equipment $194 $509 $34 $17
Proceeds from disposal of controlled entities, net of cash disposed $28 NA NA $17
Net loan repayment from investments accounted for under the equity method $9 $27 NA NA
Net cash used in investing activities (excluding aircraft operating lease refinancing) -$944 $1,145 -$1,395 -$1,971
Aircraft operating lease refinancing NA -$778 -$651 -$230
Net Cash used in Investing Activities -$944 -$1,923 -$2,046 -$2,201
CASH FLOWS FROM FINANCING ACTIVITIES
Payments for capital return NA -$505 NA NA
Payments for share buy-back NA -$500 -$366 -$751
Payments for treasury shares -$1 -$75 -$198 -$162
Proceeds from borrowings $796 NA $419 $668
Repayments of borrowings -$2,276 -$807 -$453 -$802
Proceeds from sale and finance leaseback of non-current assets $275 NA NA NA
Net receipts/(payments) for aircraft security deposits and hedges related to debt -$8 $62 $8 NA
Dividends paid to shareholders NA NA -$261 -$249
Dividends paid to non-controlling interests -$4 NA -$3 NA
Net cash used in financing activities -$1,218 -$1,825 -$854 -$1,296
Net decrease in cash and cash equivalents held -$114 -$929 -$196 -$84
Cash and cash equivalents at the beginning of the year $3,001 $2,908 $1,980 $1,775
Effects of exchange rate changes on cash and cash equivalents $21 $1 -$9 $3
Cash and cash equivalents at the end of the year 8 $2,908 $1,980 8 $1,775 15 $1,694

&"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.