RATIO ANALYSIS
Raoof.
Exapmle2.xlsxBalance Sheet
| Balance Sheet for Qantas | |||||||
| BALANCE SHEET | Notes | 2015 ($) Millions | 2016 ($) Millions | Notes | 2017 ($) Millions | Notes | 2018 ($) Millions |
| CURRENT ASSETS | |||||||
| Cash & cash equivalents | 8 | $2,908 | $1,980 | 8 | $1,775 | 15A | $1,694 |
| Accounts Receivables | 9 | $959 | $795 | 9 | $784 | 8 | $908 |
| other financial assets | 20C | $613 | $229 | 20C | $100 | 20C | $474 |
| Inventories | $322 | $336 | $351 | $351 | |||
| Assets classified as 'held for sale' | 10 | $136 | $17 | 10 | $12 | 9 | $118 |
| Other | $111 | $101 | $97 | 13 | $167 | ||
| Total Current Assets | $5,049 | $3,458 | $3,119 | $3,712 | |||
| NON-CURRENT ASSETS | |||||||
| Receivables | 9 | $134 | $134 | 9 | $123 | 8 | $100 |
| Other financial assets | 20C | $49 | $46 | 20C | $43 | 20C | $112 |
| Investments accounted for under the equity method | $134 | $197 | $214 | $226 | |||
| Property, plans & equipment | 11 | $10,715 | $11,670 | 11 | $12,253 | 10 | $12,851 |
| Intangible Assets | 12 | $803 | $909 | 12 | $1,025 | 11 | $1,113 |
| Deferred tax assets | 13 | $333 | $39 | 13 | NA | NA | |
| Other | $313 | $252 | $444 | 13 | $533 | ||
| Total Non-current assets | $12,481 | $13,247 | $14,102 | $14,935 | |||
| Total assets | $17,530 | $16,705 | $17,221 | $18,647 | |||
| CURRENT LIABILITIES | |||||||
| Accounts payable | $1,881 | $1,986 | $2,067 | $2,295 | |||
| Revenue received in advance | 14 | $3,584 | $3,525 | 14 | $3,685 | 14 | $3,939 |
| interest-bearing liabilities | 15 | $771 | $441 | 15 | $433 | 15b | $404 |
| Other financial liabilities | 20C | $416 | $203 | 20C | $69 | 20C | $34 |
| Provisions | 16 | $818 | $873 | 16 | $841 | 16 | $860 |
| Liabilities classified as 'held for sale' | NA | NA | NA | 9 | $64 | ||
| Total current liabilities | $7,470 | $7,028 | $7,095 | $7,596 | |||
| NON-CURRENT LIABILITIES | |||||||
| Revenue received in advance | 14 | $1,359 | $1,521 | 14 | $1,424 | 14 | $1,446 |
| Interest-bearing liabilities | 15 | $4,791 | $4,421 | 15 | $4,405 | 15B | $4,344 |
| Other financial liabilities | 20C | $68 | $61 | 20C | $56 | 20C | $25 |
| Provisions | 16 | $395 | $414 | 16 | $348 | 16 | $367 |
| Deferred tax liabilities | NA | NA | 13 | $353 | 12 | $910 | |
| Total Non-current liabilities | $6,613 | $6,417 | $6,586 | $7,092 | |||
| Total liabilities | $14,083 | $13,445 | $13,681 | $14,688 | |||
| Net Assets | $3,447 | $3,260 | $3,540 | $3,959 | |||
| Equity | |||||||
| Issued Capital | 17A | $4,630 | $3,625 | 17A | $3,259 | 17A | $2,508 |
| Treasury shares | -$7 | -$50 | -$206 | -$115 | |||
| Reserves | -$66 | -$220 | $12 | $479 | |||
| Retained earnings | -$1,115 | -$100 | $472 | $1,084 | |||
| Equity attributed to Qantas members | $3,442 | $3,255 | $3,537 | $3,956 | |||
| Non-controlling interest | $5 | $5 | $3 | $3 | |||
| Total Equity | $3,447 | $3,260 | $3,540 | $3,959 | |||
&"Verdana,Italic"&9This Balance Sheet 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.
