The basic requirement is to undertake a general financial analysis comparing Qantas Airline (ASX Code: QAN) financial position and performance in the Financial Years Ended 30 June 2013 and 2014 compared to that of Virgin Australia (ASX Code: VAH) over the same period. (Note: students are to use the 'Consolidated' data in conducting their analysis.) The anaysis should consider the ratio categories of : profitability, asset efficiency,liquidity,capital structure, andmarket performance. note that for those 2013 ratios which involve Balance Sheet figures students will require the 2013 annual statements (in adition to the 2014 report) to provide the 2013 beginning of year balance sheet figures. the assignment will contain two main elements: SHEDULE(s) of relevant ratios and other useful calculations A detailed calculation of relevant ratios and other useful calculations should be included as one or more appendices prepared using EXCEL or a similar spreadsheet. students are advised to show the formulae used in determining particular ratios and other figures. data items (for example 'Sales Revenue' or 'Total Assets') should be entered in a single cell in a specially designated 'data area' in the spreadsheet, with any calculation referencing the relevant data cell.

Read less