Iinvestment finance

profileAllen
assignvcel.xlsx
Home>Business & Finance homework help>Accounting homework help>Iinvestment finance

wja is

Ticker WJA CN Equity millions of dollars
Company Westjet Airlines Ltd
Start Date 20061231
End Date 20141231
Periodicity A
Currency CAD
Filing Status Mnemonic MR
Filing Most Recent
Units MLN
Field Mnemonic FY 2014 FY 2013 FQ3 2013 FY 2012 FY 2011 FY 2010 FY 2009 FY 2008 FY 2007 FY 2006
For the period ending 42004 41639 41547 41274 40908 40543 40178 39813 39447 39082
most recent most recent most recent original restated restated original restated original restated
Revenue SALES_REV_TURN 3907.54 3659 3596.42 3427.409 3071.54 2607.294 2281.12 2549.506 2127.156 1751.269
  Cost of Revenue IS_COGS_TO_FE_AND_PP_AND_G 2259.2 2172.585 1856.632 1558.764 1466.921 1649.67 1255.439 1083.332
Gross Profit GROSS_PROFIT 1337.22 1254.824 1214.908 1048.53 814.199 899.836 871.717 667.937
  Operating Expenses IS_OPERATING_EXPN 947.78 879.104 958.357 857.176 603.643 607.049 536.722 432.346
Operating Income IS_OPER_INC 462.33 396.83 389.44 375.72 256.551 191.354 210.556 292.787 334.995 235.591
  Interest Expense IS_INT_EXPENSE 43.52 48.9 60.911 70.914 67.706 76.078 75.749 70.196
  Foreign Exchange Losses (Gains) IS_FOREIGN_EXCH_LOSS -1.48 -1.061 -2.485 -2.579 12.306 -30.587 12.75 -0.032
  Net Non-Operating Losses (Gains) IS_NET_NON_OPER_LOSS -16.06 -12.348 -9.881 -10.446 -6.252 -7.453 -26.174 0.946
Pretax Income PRETAX_INC 422.33 373.83 363.46 340.229 208.006 133.465 136.796 254.749 272.67 164.481
  Income Tax Expense IS_INC_TAX_EXP 101.6 97.837 59.304 43.268 38.618 76.243 79.837 49.805
Income Before XO Items IS_INC_BEF_XO_ITEM 308.33 269.44 261.86 242.392 148.702 90.197 98.178 178.506 192.833 114.676
  Extraordinary Loss Net of Tax XO_GL_NET_OF_TAX 0 0 0 0 0 0 0 0
  Minority Interests MIN_NONCONTROL_INTEREST_CREDITS 0 0 0 0 0 0 0 0
Net Income NET_INCOME 289.67 272 261.86 242.392 148.702 90.197 98.178 178.506 192.833 114.676
  Total Cash Preferred Dividends IS_TOT_CASH_PFD_DVD 0 0 0 0 0 0 0 0
  Other Adjustments OTHER_ADJUSTMENTS 0 0 0 0 0 0 0 0
Net Inc Avail to Common Shareholders EARN_FOR_COMMON 261.86 242.392 148.702 90.197 98.178 178.506 192.833 114.676
  Abnormal Losses (Gains) IS_ABNORMAL_ITEM 2.24 6.043 6.106 -0.536 -3.87 0.701 -1.873 3.561
  Tax Effect on Abnormal Items IS_TAX_EFF_ON_ABNORMAL_ITEM -0.78 -2.1151 -2.1371 0.1876 -0.41 -0.25 -11.139 -5.0497
Normalized Income NORMALIZED_INCOME 263.31 246.32 152.6709 89.8486 93.898 178.957 179.821 113.1873
Basic EPS Before Abnormal Items IS_BASIC_EPS_CONT_OPS 2 1.82 1.09 0.62 0.71 1.39 1.39 0.87
Basic EPS Before XO Items IS_EARN_BEF_XO_ITEMS_PER_SH 2.36 2.05 1.99 1.79 1.06 0.62 0.74 1.39 1.49 0.88
Basic EPS IS_EPS 2.36 2.05 1.99 1.79 1.06 0.62 0.74 1.39 1.49 0.88
  Basic Weighted Avg Shares IS_AVG_NUM_SH_FOR_EPS 130.41 135.1743 139.9026 144.8525 132.13 128.6901 129.7093 129.5854
Diluted EPS Before Abnormal Items IS_DIL_EPS_CONT_OPS 2.37 2.03 1.98 1.81 1.09 0.62 0.71 1.37 1.37 0.87
Diluted EPS Before XO Items IS_DIL_EPS_BEF_XO 1.98 1.78 1.06 0.62 0.74 1.37 1.47 0.88
Diluted EPS IS_DILUTED_EPS 1.98 1.78 1.06 0.62 0.74 1.37 1.47 0.88
  Diluted Weighted Avg Shares IS_SH_FOR_DILUTED_EPS 131.52 135.9641 140.6387 145.0801 132.2618 129.9752 131.6102 129.7097
Reference Items
Accounting Standard ACCOUNTING_STANDARD IAS/IFRS IAS/IFRS CA GAAP CA GAAP CA GAAP CA GAAP CA GAAP
EBITDA EBITDA 695.86 603.57 584.28 561.121 431.302 361.816 351.859 429.272 462.218 347.033
EBITDA Margin (T12M) EBITDA_MARGIN 17.81 16.5 16.25 16.3716 14.0419 13.8771 15.4248 16.8375 21.7294 19.8161
Gross Margin GROSS_MARGIN 37.06 36.6114 39.5537 40.2153 35.6929 35.2945 40.9804 38.1402
Operating Margin OPER_MARGIN 11.83 10.85 10.7 10.9622 8.3525 7.3392 9.2304 11.4841 15.7485 13.4526
Profit Margin PROF_MARGIN 7.89 7.36 7.04 7.0722 4.8413 3.4594 4.3039 7.0016 9.0653 6.5482
Actual Sales Per Employee ACTUAL_SALES_PER_EMPL 442703.3066 430127.4331 379132.4706 362600.5405 412074.6727 #N/A N/A #N/A N/A
Dividends per Share EQY_DPS 0.45 0.4 0.38 0.28 0.2 0.05 0 0 0 0
Total Cash Common Dividends IS_TOT_CASH_COM_DVD 49.97 37.549 27.9805 7.2426 0 0 0 0
Interest Income IS_INT_INC 18.3 18.391 15.987 9.91 5.601 25.485 24.301 13.815
Capitalized Interest Expense IS_CAP_INT_EXP #N/A N/A #N/A N/A #N/A N/A 0 2.132 #N/A N/A #N/A N/A
Research & Development Expense IS_RD_EXPEND 0 0 0 0 #N/A N/A #N/A N/A #N/A N/A #N/A N/A

wja bs

Ticker WJA CN Equity millions of dollars
Company Westjet Airlines Ltd
Start Date 20031231
End Date 20121231
Periodicity A
Currency CAD
Filing Status Mnemonic MR
Filing Most Recent
Units MLN
Field Mnemonic FY 2012 FY 2011 FY 2010 FY 2009 FY 2008 FY 2007 FY 2006 FY 2005 FY 2004 FY 2003
For the period ending 41274 40908 40543 40178 39813 39447 39082 38717 38352 37986
original restated restated original restated original restated restated original restated
Assets
  Cash & Near Cash Items BS_CASH_NEAR_CASH_ITEM 1408.199 1243.605 1159.316 1005.181 820.214 653.558 377.517 259.64 148.532 241.384
  Short-Term Investments BS_MKT_SEC_OTHER_ST_INVEST 0 0 0 0 0 0 0 0 0 0
  Accounts & Notes Receivable BS_ACCT_NOTE_RCV 37.576 34.122 17.518 27.654 16.837 15.009 12.645 8.022 12.814 11.781
  Inventories BS_INVENTORIES 35.595 31.695 26.095 26.048 17.054 10.202 8.2 6.259 5.382 3.764
  Other Current Assets BS_OTHER_CUR_ASSET 153.425 115.277 82.344 58.799 61.742 39.019 57.704 45.655 28.347 19.928
Total Current Assets BS_CUR_ASSET_REPORT 1634.795 1424.699 1285.273 1117.682 915.847 717.788 456.066 319.576 195.075 276.857
  LT Investments & LT Receivables BS_LT_INVEST 0 0 0 0 0 0 0 0 0 0
  Net Fixed Assets BS_NET_FIX_ASSET 1985.599 1911.227 1989.522 2307.566 2269.79 2213.063 2158.746 1803.497 1601.546 1140.226
    Gross Fixed Assets BS_GROSS_FIX_ASSET 3263.635 3040.353 2952.795 2913.181 2757.067 2609.055 2430.369 2008.583 1857.519 1286.041
    Accumulated Depreciation BS_ACCUM_DEPR 1278.036 1129.126 963.273 605.615 487.277 395.992 271.623 205.086 255.973 145.815
  Other Long-Term Assets BS_OTHER_ASSETS_DEF_CHRG_OTHER 126.221 137.752 109.185 68.454 83.065 53.371 111.715 90.019 80.733 59.775
Total Long-Term Assets BS_TOT_NON_CUR_ASSET 2111.82 2048.979 2098.707 2376.02 2352.855 2266.434 2270.461 1893.516 1682.279 1200.001
Total Assets BS_TOT_ASSET 3746.615 3473.678 3383.98 3493.702 3268.702 2984.222 2726.527 2213.092 1877.354 1476.858
Liabilities & Shareholders' Equity
  Accounts Payable BS_ACCT_PAYABLE 460.003 307.279 287.71 231.401 249.354 168.171 121.157 100.052 91.885 82.822
  Short-Term Borrowings BS_ST_BORROW 164.909 158.907 178.445 171.967 166.116 173.367 154.076 116.581 103.869 65.631
  Other Short-Term Liabilities BS_OTHER_ST_LIAB 562.941 475.671 373.307 350.867 324.374 249.068 189.251 160.264 108.695 89.624
Total Current Liabilities BS_CUR_LIAB 1187.853 941.857 839.462 754.235 739.844 590.606 464.484 376.897 304.449 238.077
  Long-Term Borrowings BS_LT_BORROW 574.139 673.054 851.714 1051.912 1186.895 1257.634 1292.619 1046.409 905.631 596.546
  Other Long-Term Liabilities BS_OTHER_LT_LIABILITIES 512.318 488.55 388.571 298.627 265.973 186.074 163.397 119.633 77.382 61.423
Total Long-Term Liabilities NON_CUR_LIAB 1086.457 1161.604 1240.285 1350.539 1452.868 1443.708 1456.016 1166.042 983.013 657.969
Total Liabilities BS_TOT_LIAB2 2274.31 2103.461 2079.747 2104.774 2192.712 2034.314 1920.5 1542.939 1287.462 896.046
  Total Preferred Equity BS_PFD_EQY 0 0 0 0 0 0 0 0 0 0
  Minority Interest MINORITY_NONCONTROLLING_INTEREST 0 0 0 0 0 0 0 0 0 0
  Share Capital & APIC BS_SH_CAP_AND_APIC 614.899 630.408 647.637 704.578 513.078 506.457 489.904 468.706 412.446 376.081
  Retained Earnings & Other Equity BS_RETAIN_EARN 857.406 739.809 656.596 684.35 562.912 443.451 316.123 201.447 177.446 204.731
Total Equity TOTAL_EQUITY 1472.305 1370.217 1304.233 1388.928 1075.99 949.908 806.027 670.153 589.892 580.812
Total Liabilities & Equity TOT_LIAB_AND_EQY 3746.615 3473.678 3383.98 3493.702 3268.702 2984.222 2726.527 2213.092 1877.354 1476.858
Reference Items
Accounting Standard ACCOUNTING_STANDARD IAS/IFRS IAS/IFRS CA GAAP CA GAAP CA GAAP CA GAAP CA GAAP CA GAAP CA GAAP CA GAAP
Shares Outstanding BS_SH_OUT 132.2568 138.2806 142.9584 144.3594 127.9136 129.5716 129.6487 129.5751 125.497 123.882
Number of Treasury Shares BS_NUM_OF_TSY_SH 0 0 0 0 0 0 0 0 0 0
Amount of Treasury Shares BS_AMT_OF_TSY_STOCK 0 0 0 0 0 0 0 0 0 0
Pension Obligations BS_PENSION_RSRV 0 0 0 #N/A N/A #N/A N/A #N/A N/A #N/A N/A #N/A N/A #N/A N/A #N/A N/A
Operating Leases BS_FUTURE_MIN_OPER_LEASE_OBLIG 956.577 1161.047 1366.015 1613.35 1613.35 1487.676 1237.791 839.217 838.407 602.39
Capital Leases - Short Term ST_CAPITAL_LEASE_OBLIGATIONS 0 0.075 0.108 0.744 0.395 0.375 0.356 2.466 #N/A N/A #N/A N/A
Capital Leases - Long Term LT_CAPITAL_LEASE_OBLIGATIONS 0 3.174 3.249 3.358 0.713 1.108 1.483 1.69 #N/A N/A #N/A N/A
Capital Leases - Total BS_TOTAL_CAPITAL_LEASES 0 3.249 3.357 4.102 1.108 1.483 1.839 4.156 #N/A N/A #N/A N/A
Options Granted During Period BS_OPTIONS_GRANTED 1.8745 1.8565 2.0241 3.0111 1.9745 1.6898 5.9807 4.4742 2.9279 2.9057
Options Outstanding at Period End BS_OPTIONS_OUTSTANDING 3.8509 7.3508 8.0834 11.5218 11.9182 12.2262 15.0462 11.4287 10.6821 9.8098
Net Debt NET_DEBT -669.151 -411.644 -129.157 218.698 532.797 777.443 1069.178 903.35 860.968 420.793
Net Debt to Equity NET_DEBT_TO_SHRHLDR_EQTY -45.4492 -30.0422 -9.9029 15.7458 49.5169 81.844 132.6479 134.7976 145.9535 72.4491
Tangible Common Equity Ratio TCE_RATIO 38.4624 38.3285 37.9915 39.5113 32.6695 31.831 29.5624 30.2813 31.4215 39.3275
Current Ratio CUR_RATIO 1.3763 1.5126 1.5311 1.4819 1.2379 1.2153 0.9819 0.8479 0.6407 1.1629
Cash Conversion Cycle CASH_CONVERSION_CYCLE -55.0174 -49.5605 -51.5089 -50.5246 -40.8156 -36.9443 -32.6091 -32.6427 -37.0837 -43.856
Pure Retained Earnings BS_PURE_RETAINED_EARNINGS 793.296 668.978 600.34 699.202 601.024 455.365 316.123 201.447 177.446 204.731
Goodwill BS_GOODWILL 0 0 0 0 0 0 0 0 0 0
Number of Employees NUM_OF_EMPLOYEES 7742 7141 6877 6291 6187 #N/A N/A #N/A N/A #N/A N/A #N/A N/A #N/A N/A