Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to determine the Earnings per share for 2013,2014, 2015 please show how you came to the answer so I understand the calculation, Also

I need to determine the Earnings per share for 2013,2014, 2015 please show how you came to the answer so I understand the calculation, Also please explain how and why each ratio (found on the calculations page has changed over the last three year period, explain how to locate general industry standard, how the ratios compare.

image text in transcribed Alliant Energy Corp. NYSE: LNT Annual Financials for Alliant Energy Corp. Income Statement Fiscal year is January-December. All values USD millions. Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SG&A Expense Research & Development Other SG&A SGA Growth Other Operating Expense Unusual Expense EBIT after Unusual Expense Non Operating Income/Expense Non-Operating Interest Income Equity in Affiliates (Pretax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Pretax Income Pretax Income Growth Pretax Margin Income Tax Income Tax - Current Domestic Income Tax - Current Foreign Income Tax - Deferred Domestic Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) Consolidated Net Income Minority Interest Expense Net Income Net Income Growth Net Margin Growth Extraordinaries & Discontinued Operations Extra Items & Gain/Loss Sale Of Assets Cumulative Effect Accounting Chg Discontinued Operations Net Income After Extraordinaries Preferred Dividends Net Income Available to Common EPS (Basic) 2012 2013 2014 3.09B -15.57% 2.48B 2.09B 3.28B 5.89% 2.64B 2.23B 3.35B 2.24% 2.71B 2.26B 387.9M 411.1M 442.3M 332.9M 370.9M 55M 40.2M 26.07% 6.73% 617.9M 633.5M -63.67% 2.52% 2012 2013 0 0 0 -100.00% 98.2M 99.6M 0 0 0 0 21.9M 30.8M 4M 400,000 41.3M 43.7M 156.7M 172.8M 7.11% ### 165.7M 173.3M 9M 500,000 430.2M 436M 14.51% 1.35% 89.4M 53.9M (58.2M) (52.6M) 174.1M 139.1M 26.5M 32.6M 0 0 0 340.8M 382.1M 0 0 340.8M 382.1M 6.30% ### - 2.36% 644.7M 1.77% ### 2014 101.1M 0 0 34.8M 1.8M 40.4M 180.6M 4.51% 181.6M 1M 440M 0.92% ### 44.3M (10.9M) 88.1M 32.9M 0 395.7M 0 395.7M 3.56% ### (5.1M) (5.9M) (2.4M) 0 0 0 0 0 0 (5.1M) 335.7M 15.9M 324.9M 2.89 (5.9M) (2.4M) 376.2M 393.3M 17.9M 10.2M 364.2M 385.5M 3.23 3.46 EPS (Basic) Growth 5.47% ### 7.12% Basic Shares Outstanding 110.75M 110.8M 110.8M EPS (Diluted) 2.89 3.23 3.46 EPS (Diluted) Growth 5.47% ### 7.12% Diluted Shares Outstanding 110.77M 110.8M 110.8M EBITDA 907.6M 945M 985.9M EBITDA Growth 5.72% 4.12% 4.33% EBITDA Margin ### http://www.marketwatch.com/investing/Stock/LNT/financials?CountryCode=US Alliant Energy Corp. NYSE: LNT Annual Financials for Alliant Energy Corp. Balance Sheet Assets Fiscal year is January-December. All values USD millions. Cash & Short Term Investments Cash Only Short-Term Investments Cash & Short Term Investments Growth Cash & ST Investments / Total Assets Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt/Doubtful Accounts Other Receivables Accounts Receivable Growth Accounts Receivable Turnover Inventories Finished Goods Work in Progress Raw Materials Progress Payments & Other Other Current Assets Miscellaneous Current Assets Total Current Assets Net Property, Plant & Equipment Property, Plant & Equipment - Gross Buildings Land & Improvements Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation Total Investments and Advances Other Long-Term Investments Long-Term Note Receivable Intangible Assets Net Goodwill Net Other Intangibles Other Assets Tangible Other Assets Total Assets Assets - Total - Growth 2012 2013 104.7M 21.2M 83.5M 2014 9.8M - 56.9M 56.9M - 818.42% -90.64% 480.61% 0.97% 0.09% 0.47% 430.9M 176.3M 180.3M (4M) 254.6M 13.42% 7.18 203.9M 103.1M 0 100.8M 0 254.8M 214.4M 994.3M 2012 7.84B 11.59B - 473.3M 174.1M 178.9M (4.8M) 299.2M 9.84% 6.92 211.8M 103.6M 0 108.2M 316.3M 275.5M 1.01B 2013 8.33B 12.31B - 341.9M 84.5M 89.6M (5.1M) 257.4M -27.76% 9.8 223.8M 83.8M 0 140M 420.5M 420.5M 1.04B 2014 8.94B 13.14B - - - - 713.7M 761.1M 810.4M 3.75B 319M 62M 40M 8M 1.59B 1.57B 10.79B 11.33% 3.99B 329.6M 57.5M 7.3M 1.44B 1.42B 11.11B 3.03% 4.2B 344.9M 58.4M 0 0 1.76B 1.74B 12.09B 8.76% 2012 219M 217.5M 1.5M 339.3M 10.09% 48M 413.7M 413.7M 1.02B 3.14B 2013 637.9M 279.4M 358.5M 365M 7.57% 50M 380.4M 380.4M 1.43B 2.98B 2014 324.3M 141.3M 183M 427.9M 17.23% 462.5M 462.5M 1.21B 3.61B 3.14B 2.98B 3.61B 3.14B 0 364M 1.93B 1.93B 0 988.9M 2.98B 0 206.6M 2.11B 2.11B 0 898.8M 3.61B 0 549.2M 2.32B 2.32B 0 753.7M 988.9M 898.8M 753.7M Liabilities & Shareholders' Equity ST Debt & Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt Accounts Payable Accounts Payable Growth Income Tax Payable Other Current Liabilities Dividends Payable Accrued Payroll Miscellaneous Current Liabilities Total Current Liabilities Long-Term Debt Long-Term Debt excl. Capitalized Leases Non-Convertible Debt Convertible Debt Capitalized Lease Obligations Provision for Risks & Charges Deferred Taxes Deferred Taxes - Credit Deferred Taxes - Debit Other Liabilities Other Liabilities (excl. Deferred Income) Deferred Income Total Liabilities Non-Equity Reserves Total Liabilities / Total Assets Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock Common Equity (Total) Common Stock Par/Carry Value Retained Earnings ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain Unrealized Gain/Loss Marketable Securities Revaluation Reserves Treasury Stock Common Equity / Total Assets Total Shareholders' Equity 7.44B 0 69.02% 205.1M 205.1M 0 3.13B 1.1M 1.63B 0 7.63B 0 68.65% 200M 200M 0 3.28B 1.1M 1.78B 0 8.45B 0 69.88% 200M 0 200M 3.44B 1.1M 1.94B 0 - - - 0 0 0 0 0 0 0 0 0 29.07% 3.34B 29.53% 3.48B 28.45% 3.64B Total Shareholders' Equity / Total 30.97% 31.33% Assets Accumulated Minority Interest 1.8M 1.8M Total Equity 3.34B 3.48B Liabilities & Shareholders' Equity 10.79B 11.11B http://www.marketwatch.com/investing/Stock/LNT/financials/balance-sheet 30.11% 1.8M 3.64B 12.09B Alliant Energy Corp. NYSE: LNT Annual Financials for Alliant Energy Corp. Cash Flow Statement Operating Activities Fiscal year is January-December. All values USD millions. Net Income before Extraordinaries Net Income Growth Depreciation, Depletion & Amortization Depreciation and Depletion Amortization of Intangible Assets Deferred Taxes & Investment Tax Credit Deferred Taxes Investment Tax Credit Other Funds Funds from Operations Extraordinaries Changes in Working Capital Receivables Accounts Payable Other Assets/Liabilities Net Operating Cash Flow Net Operating Cash Flow Growth Net Operating Cash Flow / Sales 2012 2013 2014 335.7M 10.57% 387.9M 230.9M 230.9M (20.5M) 934M 0 (92.9M) 72.2M (162.2M) 841.1M 19.70% 27.18% 376.2M 12.06% 411.1M 370.9M 40.2M 210.2M 210.2M (32.3M) 965.2M (234.2M) (150.2M) (84M) 731M -13.09% 22.31% 393.3M 4.55% 442.3M 388.1M 54.2M 193.6M 193.6M (25.1M) 1B (112.5M) 41.7M (154.2M) 891.6M 21.97% 26.61% 2012 (1.16B) 2013 (798.3M) 2014 (902.8M) (1.16B) (798.3M) (902.8M) 0 0 0 Investing Activities Capital Expenditures Capital Expenditures (Fixed Assets) Capital Expenditures (Other Assets) Capital Expenditures Growth Capital Expenditures / Sales Net Assets from Acquisitions Sale of Fixed Assets & Businesses Purchase/Sale of Investments Purchase of Investments Sale/Maturity of Investments Other Uses Other Sources Net Investing Cash Flow -71.98% -37.42% 31.07% -24.36% -13.09% -26.95% 0 0 0 0 (20.3M) 22.9M (1.16B) -77.20% -37.34% 0 0 0 0 (35.4M) 79M (754.7M) 34.69% -23.03% 0 0 0 0 (14.9M) 0 (917.7M) -21.60% -27.39% 2012 (215.2M) (199.3M) (15.9M) 0 2013 (219.7M) (208.3M) (11.4M) (11M) 2014 (236M) (225.8M) (10.2M) 0 0 (211M) 0 0 200M 200M 0 0 - 0 0 548.3M 261.9M 164.7M 11.9M 383.6M 250M 385M 250M (1.4M) (8.9M) (18.9M) (8.9M) (18.9M) 0 0 324.2M 12.3M Net Financing Cash Flow Growth 263.32% -96.21% Net Financing Cash Flow / Sales 10.48% 0.38% Exchange Rate Effect 0 0 Miscellaneous Funds 0 0 Net Change in Cash 9.8M (11.4M) Free Cash Flow (317M) (67.3M) Free Cash Flow Growth -1181.91% 78.77% Free Cash Flow Yield http://www.marketwatch.com/investing/Stock/LNT/financials/cash-flow# 316.3M (138.1M) 454.4M 812.9M (358.5M) (7.1M) (7.1M) 0 73.2M 495.12% 2.18% 0 0 47.1M (11.2M) 83.36% -3.36% Net Investing Cash Flow Growth Net Investing Cash Flow / Sales Financing Activities Cash Dividends Paid - Total Common Dividends Preferred Dividends Change in Capital Stock Repurchase of Common & Preferred Stk. Sale of Common & Preferred StockProceeds from Stock Options Other Proceeds from Sale of Stock Issuance/Reduction of Debt, Net Change in Current Debt Change in Long-Term Debt Issuance of Long-Term Debt Reduction in Long-Term Debt Other Funds Other Uses Other Sources Net Financing Cash Flow Alliant Energy Corp. NYSE: LNT Annual Financials for Alliant Energy Corp. Historical Stock Prices Date Open High Low 7/31/2015 61.46 62.07 7/30/2015 60.25 61.25 7/29/2015 59.85 60.44 7/28/2015 60.19 60.59 7/27/2015 59.37 60.38 7/24/2015 59.19 59.53 7/23/2015 59.87 59.87 7/22/2015 59.62 60.36 7/21/2015 60.18 60.36 7/20/2015 60.43 60.43 7/17/2015 61.12 61.34 7/16/2015 60.47 61.48 7/15/2015 60.19 60.43 7/14/2015 60.24 60.57 7/13/2015 60.27 60.57 7/10/2015 59.59 60.42 7/9/2015 60.58 60.77 7/8/2015 60.53 60.86 7/7/2015 59.39 60.85 7/6/2015 59.04 59.26 7/2/2015 58.51 59.1 7/1/2015 57.89 58.24 6/30/2015 57.89 58.01 6/29/2015 57.81 58.46 6/26/2015 57.23 57.93 6/25/2015 57.72 57.88 6/24/2015 58.01 58.4 6/23/2015 58.97 59 6/22/2015 59.38 59.38 6/19/2015 59.6 59.73 6/18/2015 58.73 59.77 6/17/2015 58.3 58.8 6/16/2015 57.73 58.4 6/15/2015 58.06 58.21 6/12/2015 58.45 58.61 6/11/2015 58.42 58.91 6/10/2015 58.2 58.45 6/9/2015 57.99 58.32 6/8/2015 58.25 58.4 6/5/2015 58.65 58.8 6/4/2015 59.29 59.84 6/3/2015 60.45 60.52 6/2/2015 61.09 61.09 6/1/2015 61.4 61.64 5/29/2015 61.42 61.69 5/28/2015 61.25 61.6 5/27/2015 60.9 61.36 5/26/2015 61.12 61.12 5/22/2015 61.13 61.34 5/21/2015 61.29 61.53 5/20/2015 61.22 61.77 5/19/2015 60.99 61.41 5/18/2015 60.71 61.4 5/15/2015 60.3 61.07 5/14/2015 59.67 60.27 5/13/2015 60.15 60.4 5/12/2015 59.77 60.15 5/11/2015 60.12 60.92 5/8/2015 60.98 61.4 5/7/2015 60.31 60.77 5/6/2015 60.52 60.8 5/5/2015 61.59 61.79 5/4/2015 61.05 62.38 5/1/2015 60.33 61.01 4/30/2015 61.43 61.89 4/29/2015 61.7 62.08 4/28/2015 61.71 62.39 4/27/2015 63.55 63.72 4/24/2015 62.83 63.69 4/23/2015 62.74 63.21 4/22/2015 62.86 63.02 4/21/2015 63.12 63.53 4/20/2015 62.38 63.76 Close Volume Adj Close 61.18 61.51 432200 61.51 60.13 60.97 485000 60.97 59.43 60.42 610300 60.42 59.92 60.54 619000 59.99 59 60.25 592900 59.70264 58.86 59.26 469100 58.72163 58.84 59.17 573900 58.63245 59.61 60.07 416500 59.52427 59.41 59.63 367000 59.08827 59.83 60.25 280800 59.70264 60.43 60.47 680900 59.92064 60.47 61.34 617500 60.78273 59.85 60.4 849700 59.85128 60.12 60.3 481900 59.75218 59.93 60.27 560700 59.72246 59.13 60.09 537000 59.54409 59.43 59.59 401400 59.04863 60.23 60.41 474800 59.86118 59.34 60.78 694100 60.22782 58.51 59.1 566600 58.56308 58.18 59.01 713700 58.4739 57.59 58.13 620700 57.6019 57.45 57.72 876100 57.19562 57.52 57.54 604300 57.01726 57.06 57.84 509800 57.31453 57.3 57.37 529600 56.8488 57.67 57.68 479700 57.15598 58.05 58.12 567500 57.59199 58.89 59.05 345600 58.51354 59.14 59.14 1097800 58.60272 58.64 59.43 700700 58.89009 57.97 58.59 553300 58.05772 57.56 58.28 602300 57.75053 57.68 57.87 458600 57.34426 58.08 58.12 333100 57.59199 58.32 58.79 762900 58.2559 58 58.04 493600 57.51271 57.81 57.81 642300 57.2848 57.96 58.04 467500 57.51271 58.07 58.29 913500 57.76044 58.98 59.06 711200 58.52345 59.37 59.61 722300 59.06845 60.04 60.52 1323300 59.97018 61.09 61.39 633900 60.83228 61.09 61.3 575700 60.7431 61.08 61.46 346800 60.90164 60.62 61.26 653500 60.70346 60.19 60.68 501200 60.12873 60.76 61.21 324400 60.65391 60.96 61.33 287900 60.77283 61.16 61.4 308300 60.84219 60.78 61.26 426300 60.70346 60.64 61.23 559600 60.67373 60.25 61 579200 60.44582 59.63 60.27 465000 59.72246 59.35 59.47 500200 58.92972 59.28 59.9 540100 59.35582 59.9 60.09 627700 59.54409 59.9 60.26 1215900 59.71254 60.11 60.29 572400 59.74227 59.62 60.19 419100 59.64318 60.22 60.44 649700 59.89091 61.03 61.87 1024400 61.30792 60.08 61.01 726700 60.45573 60.2 60.47 1113400 59.92064 61.28 61.76 428100 61.19892 61.33 62.22 603700 61.65474 62.19 62.31 673200 61.19892 62.58 63.33 418300 62.20073 62.57 62.88 785400 61.75875 62.2 62.75 444400 61.63107 62.35 62.6 461400 61.48374 62.38 63.08 586900 61.95519 46.88643 53.37119 61.28885 4/17/2015 4/16/2015 4/15/2015 4/14/2015 4/13/2015 4/10/2015 4/9/2015 4/8/2015 4/7/2015 4/6/2015 4/2/2015 4/1/2015 3/31/2015 3/30/2015 3/27/2015 3/26/2015 3/25/2015 3/24/2015 3/23/2015 3/20/2015 3/19/2015 3/18/2015 3/17/2015 3/16/2015 3/13/2015 3/12/2015 3/11/2015 3/10/2015 3/9/2015 3/6/2015 3/5/2015 3/4/2015 3/3/2015 3/2/2015 2/27/2015 2/26/2015 2/25/2015 2/24/2015 2/23/2015 2/20/2015 2/19/2015 2/18/2015 2/17/2015 2/13/2015 2/12/2015 2/11/2015 2/10/2015 2/9/2015 2/6/2015 2/5/2015 2/4/2015 2/3/2015 2/2/2015 1/30/2015 1/29/2015 1/28/2015 1/27/2015 1/26/2015 1/23/2015 1/22/2015 1/21/2015 1/20/2015 1/16/2015 1/15/2015 1/14/2015 1/13/2015 1/12/2015 1/9/2015 1/8/2015 1/7/2015 1/6/2015 1/5/2015 1/2/2015 12/31/2014 12/30/2014 12/29/2014 12/26/2014 12/24/2014 12/23/2014 12/22/2014 12/19/2014 62 62.61 63.05 62.93 63.11 62.7 62.51 62.59 63.64 63 62.86 62.97 62.48 61.92 61.53 61.9 63.17 63.18 63.58 62.85 62.87 61.68 61.56 60.86 61.13 60.6 60.67 60.55 60.29 61.55 62.3 62.41 62.09 63.45 63.74 64.55 65.54 65.09 64.63 64.5 65.03 63.43 63.36 64.4 64.75 65.82 64.72 65.46 68.49 68.49 69.18 68.68 68.76 70.07 69.22 69.58 69.89 70.01 70.27 70.31 69.37 69.65 68.19 68.16 66.6 66.97 66.8 67.76 66.93 65.96 65.85 66.46 66.68 68.02 69.05 68.15 67.5 66.33 66.31 65.42 65.33 62.56 62.66 63.54 63.27 63.35 63.28 62.62 62.67 63.84 64.14 63.35 63.07 63.38 62.76 62.17 62.25 63.28 63.61 63.92 63.68 63.64 63.5 62.02 62.2 61.13 61.4 61 61.26 61.07 61.55 62.57 62.41 62.68 63.55 63.83 64.85 65.75 65.67 65.11 64.7 65.24 65.11 64.04 64.4 64.98 65.82 66.08 65.96 68.58 68.9 69.18 69.35 69.08 70.15 70.38 70.53 70.48 70.17 70.8 70.57 70.07 69.88 69.67 68.42 68.18 67.93 66.92 67.76 67.89 66.62 66.9 66.67 66.91 68.21 69.05 69.78 68.44 67.57 66.41 66.12 65.88 61.89 61.72 62.74 62.62 62.69 62.28 61.87 61.91 62.55 62.95 62.66 62.16 62.04 61.6 61.19 61.06 61.99 62.5 63.31 62.61 62.38 61.48 61.41 60.76 59.92 60.6 60.12 60.39 60.28 60.07 61.63 61.83 61.61 61.79 63.26 63.62 64.2 64.5 64.34 63.95 64.3 63.43 62.89 63.03 64.22 64.53 64.58 64.45 65.41 67.92 67.75 68.35 67.63 68.56 68.88 69 69.72 69.25 69.9 69.5 68.69 68.83 68.01 67.83 66.56 66.44 66.18 66.51 66.74 65.3 65.42 65.53 65.77 66.39 67.67 67.73 67.45 66.22 65.7 64.93 64.86 62.15 62.37 62.81 63.01 62.74 63.14 62.51 62.52 62.6 63.65 62.91 62.85 63 62.58 61.64 61.3 62.02 62.54 63.43 63.58 62.72 63.02 61.69 61.79 60.52 61.15 60.31 60.67 60.7 60.25 62.2 62.09 62.64 62.41 63.6 63.71 64.37 65.51 65.09 64.61 64.55 65.04 63.42 63.57 64.46 64.66 66.08 64.64 65.78 68.81 68.11 69.11 68.93 68.61 70.32 69.2 70.02 70.17 70.2 70.05 70.07 69.57 69.6 68.32 68.16 66.93 66.47 66.65 67.61 66.56 65.48 65.69 66.5 66.42 67.71 69.32 68.15 67.41 66.31 66.1 65.47 567400 645400 611800 456400 606600 484100 817600 725400 690500 660500 573800 871400 1273900 662800 911800 890500 712600 568600 504800 1358800 708500 775800 679700 664600 730500 704400 835400 977400 1095500 1053500 657500 397200 441400 674300 402100 507500 557500 883800 574100 611300 556700 808900 941500 999800 516700 592200 797100 796700 586500 300900 666200 477500 611800 458000 443000 528800 581200 485100 386400 440700 392400 648900 1000400 845900 627300 454000 453500 554700 1012000 750800 1240600 917500 505400 533300 495900 928200 333400 261300 507000 750100 912200 61.04177 61.25784 61.69 61.88643 61.62125 62.01411 61.39535 61.40517 61.48374 62.51502 61.78822 61.72929 61.87661 61.4641 60.54086 60.20692 60.91409 61.42482 62.29894 62.44627 61.60161 61.89626 60.58997 60.68819 59.44083 60.0596 59.23458 59.58816 59.61763 59.17565 61.09088 60.98284 61.52303 61.29713 62.46591 62.57395 63.22219 64.34186 63.92934 63.4579 63.39898 63.88024 62.28912 62.43645 63.31058 63.50702 64.90169 63.48737 64.60704 67.58301 66.89549 67.87766 67.70087 67.38658 69.06608 67.96605 68.23124 68.37741 68.40664 68.26048 68.27997 67.79274 67.82197 66.57467 66.41876 65.22018 64.77193 64.94734 65.88281 64.85963 63.80723 64.01186 64.80117 64.72321 65.98025 67.54913 66.40902 65.68792 64.61602 64.41138 63.79748 12/18/2014 12/17/2014 12/16/2014 12/15/2014 12/12/2014 12/11/2014 12/10/2014 12/9/2014 12/8/2014 12/5/2014 12/4/2014 12/3/2014 12/2/2014 12/1/2014 11/28/2014 11/26/2014 11/25/2014 11/24/2014 11/21/2014 11/20/2014 11/19/2014 11/18/2014 11/17/2014 11/14/2014 11/13/2014 11/12/2014 11/11/2014 11/10/2014 11/7/2014 11/6/2014 11/5/2014 11/4/2014 11/3/2014 10/31/2014 10/30/2014 10/29/2014 10/28/2014 10/27/2014 10/24/2014 10/23/2014 10/22/2014 10/21/2014 10/20/2014 10/17/2014 10/16/2014 10/15/2014 10/14/2014 10/13/2014 10/10/2014 10/9/2014 10/8/2014 10/7/2014 10/6/2014 10/3/2014 10/2/2014 10/1/2014 9/30/2014 9/29/2014 9/26/2014 9/25/2014 9/24/2014 9/23/2014 9/22/2014 9/19/2014 9/18/2014 9/17/2014 9/16/2014 9/15/2014 9/12/2014 9/11/2014 9/10/2014 9/9/2014 9/8/2014 9/5/2014 9/4/2014 9/3/2014 9/2/2014 8/29/2014 8/28/2014 8/27/2014 8/26/2014 64.55 63 62.61 63.69 63.95 63.82 64.62 64.22 63.66 63.79 64.03 63.61 63.3 62.66 62.29 61.87 62.06 62.21 62.48 62.41 62.38 62.02 61.58 61.81 62.5 63.06 63.49 62.75 61.97 62.89 61.95 62.29 61.91 62 60.43 60.72 60.7 60.34 60.21 60.43 59.69 59.4 58.06 58.21 56.89 57.93 57.45 56.95 56.54 57.36 56.41 56.23 56.52 56.03 55.67 55.44 55.49 55.04 55.38 55.85 56.33 56.81 57.13 57.09 57.55 57.89 57.16 57.3 58.2 57.81 58.22 58.78 59.28 58.55 58.45 58.18 58.48 58.27 57.82 57.32 58.17 65.45 64.23 63.66 63.72 64.36 64.82 65.12 64.92 64.58 64.19 64.26 63.99 63.92 63.9 63.14 62.38 62.06 62.47 62.8 62.68 62.57 62.8 62.21 62.01 62.78 63.06 63.73 63.44 63.19 62.96 63.11 62.53 62.73 62.3 61.91 60.9 61.02 60.88 60.61 60.51 60.49 59.75 59.33 58.23 57.86 58.25 58.89 57.74 57.18 57.73 57.43 56.8 56.81 56.69 56.19 56.38 55.9 55.52 55.46 56.18 56.34 56.96 57.38 57.44 57.7 57.93 57.91 57.78 58.2 58.45 58.22 58.84 59.36 59.28 58.7 58.57 58.69 58.51 58.33 58.03 58.42 63.99 62.71 61.94 62.02 63.35 63.81 63.76 64 63.47 63.3 63.69 63.4 62.89 62.4 62.29 61.77 61.44 61.71 61.73 62.11 62.01 61.74 61.38 61.4 61.7 61.92 62.99 62.63 61.59 61.35 61.95 61.58 61.85 61.57 60.4 59.74 60.25 60.15 59.92 59.8 59.69 58.95 58.04 57.08 56.36 56.58 57.28 56.8 56.42 56.3 56.28 56.15 56.11 55.47 55.59 55.38 55.14 54.95 54.69 55.12 55.72 56.32 56.84 56.94 56.77 57.28 57.1 57.11 56.96 57.56 57.6 58 58.69 58.55 58.1 58.09 57.8 58.04 57.77 57.31 57.37 65.45 64.16 62.76 62.66 63.4 64.31 63.76 64.63 64.48 63.75 64.23 63.97 63.73 63.45 62.87 62.2 61.8 61.86 62.21 62.38 62.55 62.56 62.08 61.77 61.78 62.49 63.43 63.4 62.75 61.79 63.09 61.82 62.39 61.91 61.91 60.4 61.02 60.59 60.36 60.09 59.98 59.7 59.26 58.07 57.74 57.56 58.29 57.15 56.91 56.3 57.39 56.29 56.33 56.45 55.83 55.8 55.41 55.39 55.32 55.21 55.93 56.32 56.96 57.34 57.03 57.51 57.67 57.22 57.09 58.35 57.82 58.07 58.95 59.21 58.48 58.47 58.11 58.49 58.27 57.98 57.43 469800 456100 572600 738300 432800 403000 413500 591400 857500 482100 449000 500900 418300 768700 261500 272400 336500 483200 455300 353800 425400 750500 659300 568300 647600 565500 375800 690600 785200 875000 350200 409700 389900 648200 376900 448500 301100 439400 299000 416200 397500 424400 661900 414700 875500 1016600 967800 567000 598400 435400 703500 449000 441600 675600 602600 1170900 675500 727500 547500 962600 695200 813300 611200 1113900 1006600 391100 614800 517500 631500 477900 599000 717900 507000 705100 334300 552100 692700 374400 453000 383000 343700 63.77799 62.52095 61.15671 61.05926 61.78036 62.66711 62.13116 62.97894 62.83277 62.12142 62.58916 62.3358 62.10193 61.82908 61.2639 60.61102 60.22123 60.2797 60.62076 60.78642 60.95207 60.96182 60.49408 60.192 60.20174 60.89361 61.80959 61.78036 61.14697 60.21149 61.47828 60.24072 60.79616 60.32842 60.32842 58.857 58.96419 58.54868 58.32643 58.06552 57.95923 57.68866 57.26348 56.11358 55.7947 55.62076 56.32617 55.22458 54.99266 54.40321 55.45649 54.39355 54.4322 54.54816 53.94905 53.92006 53.5432 53.52387 53.45623 53.34993 54.04568 54.42254 55.04097 55.40817 55.10862 55.57244 55.72705 55.29222 55.1666 56.38414 55.872 56.11358 56.96393 57.21517 56.50976 56.5001 56.15223 56.51943 56.30684 56.02661 55.49514 8/25/2014 8/22/2014 8/21/2014 8/20/2014 8/19/2014 8/18/2014 8/15/2014 8/14/2014 8/13/2014 8/12/2014 8/11/2014 8/8/2014 8/7/2014 8/6/2014 8/5/2014 8/4/2014 8/1/2014 7/31/2014 7/30/2014 7/29/2014 7/28/2014 7/25/2014 7/24/2014 7/23/2014 7/22/2014 7/21/2014 7/18/2014 7/17/2014 7/16/2014 7/15/2014 7/14/2014 7/11/2014 7/10/2014 7/9/2014 7/8/2014 7/7/2014 7/3/2014 7/2/2014 7/1/2014 6/30/2014 6/27/2014 6/26/2014 6/25/2014 6/24/2014 6/23/2014 6/20/2014 6/19/2014 6/18/2014 6/17/2014 6/16/2014 6/13/2014 6/12/2014 6/11/2014 6/10/2014 6/9/2014 6/6/2014 6/5/2014 6/4/2014 6/3/2014 6/2/2014 5/30/2014 5/29/2014 5/28/2014 5/27/2014 5/23/2014 5/22/2014 5/21/2014 5/20/2014 5/19/2014 5/16/2014 5/15/2014 5/14/2014 5/13/2014 5/12/2014 5/9/2014 5/8/2014 5/7/2014 5/6/2014 5/5/2014 5/2/2014 5/1/2014 57.87 57.85 57.67 57.38 56.97 57.15 56.87 56.42 55.94 55.76 56 55.04 55.34 55.74 56.18 56.91 56.42 57.3 58.68 59.34 58.73 59.42 59.37 59.23 59.07 58.88 58.5 58.71 58.9 58.43 58.89 59.48 58.66 59.15 58.57 58.5 58.69 59.96 60.85 60.1 59.92 59.99 59.39 59.32 59.61 59.73 59.33 58.38 58.32 57.75 57.57 57.11 58.01 58.31 58.53 58.86 58.29 58.02 58.04 58.17 57.71 58.16 57.44 57.43 57.02 56.63 56.71 56.66 57.36 57.27 57.57 57.35 57.34 57.73 58.24 58.84 58.09 58.46 57.53 58.55 58.65 58.3 58.12 58.08 57.71 57.44 57.28 57.22 56.92 56.57 55.89 56.19 55.93 56.23 55.75 56.79 56.91 57.11 57.66 58.86 59.58 59.96 59.51 59.65 59.43 59.27 59.08 58.99 58.91 59.35 58.95 59.2 59.6 59.67 59.28 59.22 58.91 58.82 59.96 60.89 60.88 60.26 60.02 59.96 59.75 59.74 59.79 59.83 59.35 58.64 58.76 57.83 57.54 58.04 58.42 58.74 59.08 58.78 58.21 58.33 58.42 58.37 58.19 57.97 57.58 57.16 57.03 56.75 56.98 57.43 57.56 57.7 57.93 57.63 57.82 58.33 59.09 58.82 58.46 58.53 60.12 58.89 57.75 57.33 57.59 57.15 56.91 56.74 56.46 56.42 55.85 55.6 55.7 55.04 55.08 55.29 55.73 55.38 56.26 56.5 57.31 58.53 58.73 58.77 59.18 59.1 58.99 58.59 58.14 58.25 58.17 58.31 58.42 58.94 58.51 58.7 58.45 58.25 58.25 58.42 60.01 59.88 59.73 59.62 59.39 59.22 58.84 59.31 59.29 58.3 58.06 57.59 57.15 56.55 57.26 58.04 58.29 58.57 58.18 57.68 57.84 57.94 57.67 57.49 57.3 57.22 56.75 56.49 56.35 56.09 56.64 56.97 57.07 57.28 57.12 57.12 57.42 58.25 57.91 57.84 57.53 57.44 57.96 58.12 554300 56.16189 57.57 423100 55.63042 57.8 420300 55.85267 57.63 342300 55.6884 57.43 443600 55.49514 56.86 498000 54.94435 56.89 565900 54.97333 56.69 413200 54.78007 56.42 405000 54.51917 55.86 560700 53.97804 55.8 920700 53.92006 55.9 583100 54.01669 55.12 838800 53.26297 55.36 791600 53.49488 55.91 474100 54.02635 56.52 1010800 54.6158 56.85 1021500 54.93468 56.5 496600 54.59647 57.61 409000 55.66908 58.57 460200 56.59673 59.82 598900 57.3118 58.79 467400 56.32499 59.38 424900 56.89025 59.33 445900 56.84235 59.2 499300 56.7178 58.9 399500 56.43038 58.94 280600 56.4687 58.27 551800 55.82679 58.77 733600 56.30583 58.94 645100 56.4687 58.55 878100 56.09505 59.13 546300 56.65073 59.55 458500 57.05312 59.05 502400 56.57408 59.16 484600 56.67947 58.69 383900 56.22918 58.58 286400 56.12379 58.69 561800 56.22918 60.07 725400 57.55132 60.86 526900 58.30819 60.08 558800 57.5609 59.99 477800 57.47467 59.87 451200 57.3597 59.45 286200 56.95731 59.24 645600 56.75612 59.41 690800 56.91899 59.6 456700 57.10102 59.32 390200 56.83276 58.31 535500 55.86511 58.36 404000 55.91302 57.66 297700 55.24237 57.52 303600 55.10824 57.28 441200 54.8783 58.09 321800 55.65434 58.43 444400 55.98008 58.69 321500 56.22918 58.7 251900 56.23876 58.19 220500 55.75014 58.1 477200 55.66392 58.21 366300 55.76931 58.3 482900 55.85553 57.75 298700 55.32859 57.94 445600 55.51063 57.39 269500 54.98369 57.09 346900 54.69627 56.98 356400 54.59088 56.57 325800 54.19807 56.47 435700 54.10226 56.68 399800 54.30346 57.54 362500 55.1274 57.34 418400 54.93578 57.57 268900 55.15614 57.35 467600 54.94536 57.19 436300 54.79207 57.5 475800 55.08908 58.32 626800 55.87469 58.82 632800 56.35373 57.99 689200 55.55853 58.43 746900 55.98008 57.71 809100 55.29027 58.78 794000 56.31541 4/30/2014 4/29/2014 4/28/2014 4/25/2014 4/24/2014 4/23/2014 4/22/2014 4/21/2014 4/17/2014 4/16/2014 4/15/2014 4/14/2014 4/11/2014 4/10/2014 4/9/2014 4/8/2014 4/7/2014 4/4/2014 4/3/2014 4/2/2014 4/1/2014 3/31/2014 3/28/2014 3/27/2014 3/26/2014 3/25/2014 3/24/2014 3/21/2014 3/20/2014 3/19/2014 3/18/2014 3/17/2014 3/14/2014 3/13/2014 3/12/2014 3/11/2014 3/10/2014 3/7/2014 3/6/2014 3/5/2014 3/4/2014 3/3/2014 2/28/2014 2/27/2014 2/26/2014 2/25/2014 2/24/2014 2/21/2014 2/20/2014 2/19/2014 2/18/2014 2/14/2014 2/13/2014 2/12/2014 2/11/2014 2/10/2014 2/7/2014 2/6/2014 2/5/2014 2/4/2014 2/3/2014 1/31/2014 1/30/2014 1/29/2014 1/28/2014 1/27/2014 1/24/2014 1/23/2014 1/22/2014 1/21/2014 1/17/2014 1/16/2014 1/15/2014 1/14/2014 1/13/2014 1/10/2014 1/9/2014 1/8/2014 1/7/2014 1/6/2014 1/3/2014 58.27 58.42 58.27 58.01 57.99 57.52 57.54 57.86 58.34 58.1 57.21 56.96 56.24 56.55 56.38 56.05 56.41 56.75 56.74 56.52 56.88 56.1 55.78 55.68 55.71 54.68 54.51 53.99 54.19 55.25 55.17 54.95 54.54 54.32 53.23 53.64 53.66 53.39 53.77 54.27 54.1 53.97 53.74 54.11 54.21 53.42 53.81 53.78 53.21 53.64 53.85 53.15 52.48 52.78 51.6 51.25 51.05 50.6 50.93 51.2 52.05 51.33 51.13 50.51 51.13 50.8 51.54 51.64 51.79 51.5 51.52 51.09 51.69 51.5 51.77 51.31 51.05 51.03 50.58 50.19 50.93 58.54 58.67 58.6 58.79 58.1 58.26 57.67 58.04 58.5 58.37 57.96 57.38 56.92 57.37 56.53 56.76 56.57 57.28 56.95 56.87 56.97 56.99 56.02 55.78 56.05 55.03 54.95 54.78 54.44 55.25 55.32 55.47 55.14 54.95 54.25 53.65 53.94 53.73 53.92 54.36 54.32 54.18 54.45 54.32 54.21 54.25 54.12 54.35 53.89 53.95 53.99 53.69 53.21 53.03 52.62 51.75 51.37 51.1 50.95 51.27 52.52 52.19 51.79 51.13 51.18 51.21 51.64 51.82 51.98 51.92 51.63 51.57 51.83 51.64 51.82 51.98 51.55 51.03 51.05 50.58 51 58.04 58.06 57.82 57.76 57.4 57.52 57.16 57.26 57.73 57.84 57.1 56.61 56.24 56.3 55.68 55.47 55.99 56.4 56.52 56.36 56.26 56.04 55.58 55.42 55.2 54.54 54.09 53.97 53.54 54.07 55.01 54.63 54.34 54.06 53.23 53.15 53.43 52.99 53.35 53.59 53.93 53.39 53.5 53.44 53.68 53.02 53.47 53.62 53.16 53.17 53.65 52.93 52.48 52.51 51.51 50.88 50.8 50.38 50.39 50.64 50.91 51.03 50.92 50.51 50.95 50.63 50.74 51.43 51.49 51.4 51.19 51.09 51.14 51.13 51.24 51.01 50.67 50.5 50.58 50 50.42 58.48 58.14 58.36 58.75 57.88 57.81 57.57 57.46 57.73 58.34 57.9 57.1 56.75 56.52 56.37 56.32 56.04 56.44 56.57 56.71 56.56 56.81 55.91 55.71 55.67 54.87 54.5 54.36 53.92 54.25 55.25 55.18 54.7 54.7 54.17 53.31 53.68 53.73 53.39 53.76 54.29 53.51 54.24 53.66 53.77 53.79 53.51 53.75 53.7 53.21 53.86 53.67 53.14 52.64 52.56 51.64 51.29 50.89 50.6 51.03 50.95 51.96 51.75 50.77 51.15 50.98 50.75 51.69 51.79 51.92 51.29 51.44 51.27 51.5 51.35 51.87 51.3 50.79 50.97 50.49 50.69 594500 452400 914300 1026000 717700 491600 420800 284100 609600 309800 594500 593900 1007300 629700 568500 1193300 984600 443700 323000 448100 523800 569300 339400 593200 1210600 415100 662300 1018700 778300 335300 417400 457500 400500 381100 558600 217600 246900 315900 346100 233700 453600 341500 412100 382000 474700 478400 474100 383700 307100 355300 423600 394000 397800 748500 398500 335500 271700 262900 510800 833600 1050100 414500 371100 513400 458100 487800 682300 641100 757100 519900 436800 309600 452600 439600 336400 488100 586100 708900 461500 846300 447200 56.02798 55.70224 55.91302 55.79805 54.97176 54.90528 54.67734 54.57286 54.8293 55.40865 54.99076 54.23095 53.89854 53.6801 53.53763 53.49015 53.22422 53.60411 53.72758 53.86055 53.71809 53.95553 53.10075 52.91079 52.8728 52.113 51.76159 51.62863 51.21073 51.52415 52.47391 52.40743 51.95155 51.95155 51.44817 50.63139 50.9828 51.03028 50.70737 51.05877 51.56215 50.82134 51.51466 50.9638 51.06827 51.08727 50.82134 51.04928 51.00179 50.53641 51.15375 50.9733 50.46993 49.99505 49.91907 49.0453 48.71288 48.33298 48.05755 48.46595 48.38997 49.34922 49.14977 48.21901 48.09554 47.93569 47.71943 48.6033 48.69733 48.81956 48.22718 48.36822 48.20838 48.42464 48.2836 48.77255 48.23658 47.75704 47.92629 47.47496 47.66301 1/2/2014 12/31/2013 12/30/2013 12/27/2013 12/26/2013 12/24/2013 12/23/2013 12/20/2013 12/19/2013 12/18/2013 12/17/2013 12/16/2013 12/13/2013 12/12/2013 12/11/2013 12/10/2013 12/9/2013 12/6/2013 12/5/2013 12/4/2013 12/3/2013 12/2/2013 11/29/2013 11/27/2013 11/26/2013 11/25/2013 11/22/2013 11/21/2013 11/20/2013 11/19/2013 11/18/2013 11/15/2013 11/14/2013 11/13/2013 11/12/2013 11/11/2013 11/8/2013 11/7/2013 11/6/2013 11/5/2013 11/4/2013 11/1/2013 10/31/2013 10/30/2013 10/29/2013 10/28/2013 10/25/2013 10/24/2013 10/23/2013 10/22/2013 10/21/2013 10/18/2013 10/17/2013 10/16/2013 10/15/2013 10/14/2013 10/11/2013 10/10/2013 10/9/2013 10/8/2013 10/7/2013 10/4/2013 10/3/2013 10/2/2013 10/1/2013 9/30/2013 9/27/2013 9/26/2013 9/25/2013 9/24/2013 9/23/2013 9/20/2013 9/19/2013 9/18/2013 9/17/2013 9/16/2013 9/13/2013 9/12/2013 9/11/2013 9/10/2013 9/9/2013 51.61 51.8 51.63 51.57 51.89 51.41 52.27 51.27 51.62 51.57 51.41 51.11 51.11 50.32 51.16 52.11 52.52 52.01 52 51.56 51.67 51.62 51.58 51.79 52.36 52.75 52.6 52.68 53.25 53.16 53.69 53.44 52.85 52.04 52.8 52.86 51.93 52.25 52.29 52.25 52.76 52.32 52.23 52.62 52.47 52.75 51.98 52.21 51.91 51.36 51.33 51.24 49.85 49.85 50.47 50.72 50.66 49.91 49.53 48.84 49.12 49.43 49.83 50.01 49.68 49.45 49.99 50.04 50.26 50.24 49.37 50.2 50.32 49.13 49.04 49.3 48.68 48.98 48.96 48.99 48.56 51.61 51.82 51.93 51.82 51.93 51.82 52.27 51.97 51.62 51.9 51.45 51.81 51.33 51.25 51.19 52.33 52.71 52.72 52 52.25 52.1 52.21 51.8 51.79 52.36 52.76 52.82 52.86 53.35 53.53 53.69 53.66 53.5 52.64 52.97 53.2 52.87 53.48 52.7 52.83 52.76 52.72 52.46 52.93 52.68 53 52.76 52.46 52.38 52.03 51.38 51.32 51.11 50.15 50.47 50.89 50.98 50.66 50.21 49.66 49.49 49.55 49.83 50.12 50.44 49.73 50.29 50.43 50.35 50.43 50.45 50.2 50.62 50.26 49.31 49.64 49.06 49.21 49.07 49.02 48.87 50.69 51.44 51.47 51.1 50.43 51.33 51.54 51.25 50.8 50.58 51.07 50.92 50.83 50.32 50.44 51.27 52.04 51.87 51.59 51.44 51.4 51.13 51.4 51.31 51.43 52.14 52.41 52.45 52.51 52.97 53.16 52.83 52.69 51.5 52.14 52.38 51.03 52 52.04 51.99 52.06 52.16 51.31 52.14 52.17 52.48 51.69 51.83 51.89 51.19 50.92 50.95 49.54 49.54 49.57 49.89 50.52 49.46 49.19 48.84 48.83 49.17 49.11 49.45 49.63 49.3 49.63 50.04 49.8 50.02 49.05 49.33 49.92 48.82 48.87 48.89 48.63 48.6 48.5 48.68 48.17 50.78 51.6 51.6 51.62 51.45 51.75 51.58 51.77 51.26 51.85 51.43 51.33 51.01 51.06 50.5 51.28 52.24 52.55 51.82 52.01 51.82 51.75 51.5 51.61 51.7 52.24 52.62 52.68 52.57 53.11 53.28 53.59 53.44 52.64 52.43 52.92 52.87 52.06 52.41 51.99 52.52 52.54 52.22 52.22 52.56 52.72 52.76 51.99 52.05 51.93 51.3 51.19 51.07 50.01 49.7 50.47 50.88 50.65 49.56 49.36 48.94 49.32 49.4 50.04 50.19 49.55 49.71 50.2 50.05 50.14 50.26 49.36 50.04 50.2 49.02 49.04 48.86 48.63 48.85 48.94 48.72 551700 47.74764 384600 48.51867 291600 48.51867 249200 48.53748 267900 48.37763 237500 48.65971 428900 48.49987 950600 48.67852 662200 48.19897 588900 48.75374 422700 48.35882 525900 48.2648 255100 47.9639 504900 48.01092 757400 47.48436 565400 48.21778 365200 49.12045 245700 49.41194 291100 48.72553 454600 48.90419 463100 48.72553 596100 48.65971 183700 48.42464 457300 48.52807 580100 48.6127 313400 49.12045 369400 49.47776 444600 49.53418 387700 49.43075 607100 49.9385 448900 50.09835 705800 50.38984 634100 50.24879 810600 49.49657 460500 49.29911 490400 49.75984 680200 49.71283 808000 48.9512 524100 49.2803 510000 48.885383 535300 49.38373 404100 49.40254 777100 49.10165 556700 49.10165 600900 49.42135 610300 49.12986 341000 49.16713 446500 48.44957 652400 48.50548 492100 48.39365 376900 47.80655 351600 47.70404 468600 47.59222 585700 46.6044 336400 46.31551 378700 47.03308 404600 47.41516 406200 47.20082 347100 46.18505 409400 45.99867 305800 45.60727 246100 45.96139 692100 46.03594 479000 46.63236 937900 46.77214 548800 46.17573 252000 46.32483 382700 46.78146 411100 46.64168 570600 46.72555 569000 46.83738 946000 45.99867 765300 46.63236 677800 46.78146 839900 45.68182 825600 45.70046 375200 45.53271 244000 45.31838 335300 45.52339 491000 45.60727 437300 45.40225 9/6/2013 9/5/2013 9/4/2013 9/3/2013 8/30/2013 8/29/2013 8/28/2013 8/27/2013 8/26/2013 8/23/2013 8/22/2013 8/21/2013 8/20/2013 8/19/2013 8/16/2013 8/15/2013 8/14/2013 8/13/2013 8/12/2013 8/9/2013 8/8/2013 8/7/2013 8/6/2013 8/5/2013 8/2/2013 8/1/2013 7/31/2013 7/30/2013 7/29/2013 7/26/2013 7/25/2013 7/24/2013 7/23/2013 7/22/2013 7/19/2013 7/18/2013 7/17/2013 7/16/2013 7/15/2013 7/12/2013 7/11/2013 7/10/2013 7/9/2013 7/8/2013 7/5/2013 7/3/2013 7/2/2013 7/1/2013 6/28/2013 6/27/2013 6/26/2013 6/25/2013 6/24/2013 6/21/2013 6/20/2013 6/19/2013 6/18/2013 6/17/2013 6/14/2013 6/13/2013 6/12/2013 6/11/2013 6/10/2013 6/7/2013 6/6/2013 6/5/2013 6/4/2013 6/3/2013 5/31/2013 5/30/2013 5/29/2013 5/28/2013 5/24/2013 5/23/2013 5/22/2013 5/21/2013 5/20/2013 5/17/2013 5/16/2013 5/15/2013 5/14/2013 48.66 49.09 48.95 49.98 50.14 50.45 50.24 49.83 50.61 50.25 50.13 50.75 50.4 50.73 51.5 52 52.45 52.75 52.7 53.12 53.04 52.68 53.19 53.39 53.11 53.34 52.9 52.86 53.06 53.29 53.15 53.71 53.8 53.85 53.84 53.33 53.5 53.46 52.37 52.24 52 50.94 50.68 49.95 49.94 49.34 49.6 50.5 49.81 49.51 49.16 48.33 47.51 47.45 48.52 49.95 49.8 49.92 49.06 48.53 49.34 48.96 49.6 49.2 48.6 49.04 49.5 49.39 49.71 49.81 50.07 51.09 50.8 51.11 52.37 52.36 52.82 52.41 52.78 52.06 51.6 48.97 49.21 49.36 50.32 50.32 50.49 50.66 50.52 50.94 50.73 50.5 50.75 51.16 51.09 51.51 52 52.58 52.82 52.92 53.25 53.24 53.19 53.48 53.41 53.73 53.95 53.28 53.34 53.28 53.71 53.61 53.85 54.04 54.18 54.13 53.96 53.74 53.62 53.41 52.53 52.37 51.58 51.04 50.66 49.95 49.83 50.09 50.73 50.63 50.17 49.6 48.88 48.27 48.19 48.6 50.04 50.22 50.22 49.9 49.47 49.44 49.58 49.65 49.71 49.03 49.04 49.69 49.6 50.2 50.87 50.08 51.22 50.9 51.13 52.91 52.63 52.83 52.95 52.78 53.08 52.1 48.32 48.51 48.56 48.64 49.49 50 49.99 49.79 50.06 49.95 50.01 50.05 50.17 50.4 50.65 51.42 52 52.37 52.39 52.8 52.61 52.68 52.88 52.68 52.59 53.18 52.54 52.76 52.72 53.19 52.91 52.95 53.57 53.63 53.74 53.16 52.95 53.05 52.19 51.94 51.9 50.85 50.44 49.93 49.14 49.34 49.48 49.52 49.44 49.51 49 47.9 47.04 46.79 47.16 48.88 49.49 49.49 49.06 48.37 48.42 48.75 49.1 49.08 48.49 48.5 48.85 48.52 49.26 49.79 48.86 50.19 50.52 49.81 51.12 51.92 52.29 52.36 52.24 51.98 51.6 48.34 1101900 45.04813 48.55 767000 45.24382 49.01 1445000 45.6725 48.79 1000700 45.46748 49.61 465900 46.23164 50.09 347900 46.67895 50.49 338500 47.05172 50.19 565200 46.77214 50.2 410000 46.78146 50.59 291700 47.1449 50.21 386000 46.79078 50.16 441300 46.74419 50.91 367700 47.44311 50.4 270700 46.96784 50.79 346600 47.33129 51.54 483800 48.03021 52.25 302400 48.69186 52.57 415100 48.99007 52.91 410700 49.30692 52.92 391000 49.31623 53.05 377300 49.43738 52.9 387200 49.2976 52.93 292100 49.32555 53.24 416000 49.61445 53.54 247000 49.89401 53.74 737100 50.0804 52.97 614800 49.36283 52.82 719200 49.22304 52.8 632500 49.20441 53.64 440700 49.54921 53.53 359100 49.4476 53.19 473700 49.13353 53.77 349400 49.6693 53.69 470800 49.5954 53.94 175400 49.82633 53.89 262900 49.78014 53.19 401700 49.13353 53.2 463000 49.14277 53.4 608200 49.32752 52.29 465700 48.30217 52.35 378600 48.35759 51.44 364000 47.51699 51.03 399600 47.13826 50.5 319900 46.64868 49.93 241200 46.12215 49.69 216000 45.90045 49.66 506100 45.87274 49.66 692700 45.87274 50.42 663300 46.57478 49.97 413600 46.1591 49.32 409100 45.55867 48.76 405800 45.04138 48.01 266400 44.34857 47.86 603900 44.21002 47.31 564800 43.70196 48.91 276600 45.17994 50.08 245900 46.26071 49.68 252400 45.89122 49.67 311500 45.88198 49.35 195800 45.58638 48.54 194000 44.83816 49.06 471300 45.3185 49.31 296500 45.54943 49.45 443000 45.67876 49.03 571800 45.29079 48.54 466300 44.83816 49.06 651000 45.3185 49.4 574400 45.63257 49.26 419600 45.50324 49.83 705300 46.02978 49.3 565600 45.5402 50.44 327700 46.59325 50.77 440900 46.89809 51.02 591000 47.12902 51.43 475100 47.50775 52.44 431100 48.44073 52.29 325200 48.30217 52.81 353100 48.78251 52.32 198100 48.32988 52.79 483300 48.76404 52.04 456800 48.07123 5/13/2013 5/10/2013 5/9/2013 5/8/2013 5/7/2013 5/6/2013 5/3/2013 5/2/2013 5/1/2013 4/30/2013 4/29/2013 4/26/2013 4/25/2013 4/24/2013 4/23/2013 4/22/2013 4/19/2013 4/18/2013 4/17/2013 4/16/2013 4/15/2013 4/12/2013 4/11/2013 4/10/2013 4/9/2013 4/8/2013 4/5/2013 4/4/2013 4/3/2013 4/2/2013 4/1/2013 3/28/2013 3/27/2013 3/26/2013 3/25/2013 3/22/2013 3/21/2013 3/20/2013 3/19/2013 3/18/2013 3/15/2013 3/14/2013 3/13/2013 3/12/2013 3/11/2013 3/8/2013 3/7/2013 3/6/2013 3/5/2013 3/4/2013 3/1/2013 2/28/2013 2/27/2013 2/26/2013 2/25/2013 2/22/2013 2/21/2013 2/20/2013 2/19/2013 2/15/2013 2/14/2013 2/13/2013 2/12/2013 2/11/2013 2/8/2013 2/7/2013 2/6/2013 2/5/2013 2/4/2013 2/1/2013 1/31/2013 1/30/2013 1/29/2013 1/28/2013 1/25/2013 1/24/2013 1/23/2013 1/22/2013 1/18/2013 1/17/2013 1/16/2013 52.09 51.77 52.64 53.03 52.63 53.31 53.47 52.84 53.25 52.78 52.14 52.36 52.44 52.34 52.11 52.06 51.35 51.41 51.15 50.81 51.36 51.41 51.4 50.97 51.05 50.62 49.95 49.75 50.06 50.03 50.07 49.35 49.09 49.12 49.29 48.92 48.87 48.86 48.65 48.45 48.64 48.62 48.29 48.36 48.13 47.98 48.35 48.4 48.08 47.55 47.55 47.76 47.42 47.36 48.06 47.7 47.54 47.93 46.92 47.17 46.53 46.68 46.44 46.41 46.28 46.1 45.83 45.83 46 45.93 45.89 45.61 45.36 45.84 46.04 45.9 45.89 45.58 45.75 45.5 45.65 52.1 52.11 52.79 53.26 53.12 53.47 53.5 53.11 53.48 53.52 52.99 52.36 53.03 52.66 52.2 52.1 51.93 51.65 51.25 51.37 51.62 51.66 51.56 51.38 51.22 50.92 50.66 50.2 50.25 50.23 50.18 50.23 49.4 49.44 49.51 49.23 49.08 49.23 48.87 48.78 48.86 48.84 48.66 48.44 48.48 48.32 48.39 48.53 48.46 48.05 47.76 47.99 47.88 47.74 48.28 47.98 47.69 48.15 48.02 47.18 47.12 46.84 46.83 46.6 46.42 46.39 46.15 46.17 46.15 46.33 45.99 45.84 45.74 45.94 46.15 46.13 46.04 46.11 45.87 45.74 45.71 51.64 51.65 51.59 52.39 52.29 52.31 53 52.71 52.58 52.6 52 51.87 52.31 51.93 51.57 51.55 51.01 50.96 50.57 50.34 50.63 51.32 51.25 50.87 50.74 50.37 49.72 49.61 49.44 49.71 49.54 49.33 48.84 49.07 48.81 48.67 48.75 48.75 48.52 48.39 48.5 48.5 48.18 47.99 48.13 47.52 47.7 48.09 47.89 47.52 47.09 47.49 47.33 47.04 47.33 47.66 47.34 47.55 46.92 46.73 46.26 46.45 46.44 46.25 46.1 46.01 45.73 45.83 45.78 45.8 45.61 45.48 45.26 45.55 45.71 45.8 45.73 45.58 45.61 45.31 45.45 51.69 52.1 51.71 52.68 53.1 52.52 53.23 52.93 52.67 53.51 52.8 51.97 52.4 52.39 52.18 51.86 51.91 51.18 51.16 51.31 50.65 51.61 51.5 51.38 50.8 50.91 50.64 50.18 49.67 49.93 49.92 50.18 49.34 49.22 48.98 49.16 48.88 49.08 48.66 48.66 48.77 48.77 48.57 48.32 48.46 48.24 47.73 48.26 48.32 47.95 47.71 47.69 47.82 47.42 47.33 47.98 47.58 47.56 48.02 46.94 47 46.61 46.64 46.51 46.38 46.3 46.11 45.97 45.81 46.23 45.84 45.65 45.66 45.72 45.8 45.89 45.84 46.04 45.69 45.65 45.48 406600 261800 347100 327200 532400 738800 587800 262500 443800 848300 588000 330100 787600 319400 754100 228800 173600 539300 548100 394900 527400 363700 360100 492100 421700 323600 511900 375600 522600 287200 322600 459100 274500 252100 264500 393800 277200 374800 506300 314500 478200 360500 351700 331200 335900 658500 538700 408800 480800 348400 823900 570700 346400 521100 507800 404400 551200 473500 779100 682100 595900 437300 321800 265100 248000 228500 678300 474500 351300 573000 542100 804500 774800 619300 612200 517800 424500 571000 450300 496400 397900 47.74792 48.12666 47.7664 48.66242 49.05039 48.51463 49.17048 48.89336 48.65319 49.42912 48.77327 48.00657 47.96962 47.96047 47.76822 47.47528 47.52105 46.85277 46.83446 46.97178 46.36759 47.24642 47.14572 47.03586 46.5049 46.6056 46.35843 45.93732 45.47044 45.70846 45.6993 45.93732 45.16834 45.05849 44.83878 45.00356 44.74724 44.93033 44.54584 44.54584 44.64654 44.64654 44.46345 44.23458 44.36275 44.16135 43.69447 44.17966 44.23458 43.89587 43.67616 43.65785 43.77686 43.41068 43.32829 43.92333 43.55715 43.53884 43.95995 42.97126 43.02619 42.66916 42.69663 42.57762 42.45861 42.38537 42.21144 42.08328 41.9368 42.32129 41.96427 41.79033 41.79948 41.42415 41.49663 41.57818 41.53287 41.71408 41.39697 41.36073 41.2067 1/15/2013 1/14/2013 1/11/2013 1/10/2013 1/9/2013 1/8/2013 1/7/2013 1/4/2013 1/3/2013 1/2/2013 12/31/2012 12/28/2012 12/27/2012 12/26/2012 12/24/2012 12/21/2012 12/20/2012 12/19/2012 12/18/2012 12/17/2012 12/14/2012 12/13/2012 12/12/2012 12/11/2012 12/10/2012 12/7/2012 12/6/2012 12/5/2012 12/4/2012 12/3/2012 11/30/2012 11/29/2012 11/28/2012 11/27/2012 11/26/2012 11/23/2012 11/21/2012 11/20/2012 11/19/2012 11/16/2012 11/15/2012 11/14/2012 11/13/2012 11/12/2012 11/9/2012 11/8/2012 11/7/2012 11/6/2012 11/5/2012 11/2/2012 11/1/2012 10/31/2012 10/26/2012 10/25/2012 10/24/2012 10/23/2012 10/22/2012 10/19/2012 10/18/2012 10/17/2012 10/16/2012 10/15/2012 10/12/2012 10/11/2012 10/10/2012 10/9/2012 10/8/2012 10/5/2012 10/4/2012 10/3/2012 10/2/2012 10/1/2012 9/28/2012 9/27/2012 9/26/2012 9/25/2012 9/24/2012 9/21/2012 9/20/2012 9/19/2012 9/18/2012 45.75 45.75 45.8 45.48 45.19 45.11 45.33 45.16 45.05 43.74 43.5 43.62 43.93 44.5 44.6 44.13 44.86 45.05 44.96 44.02 44.19 44.38 44.75 44.75 44.46 44.49 44.73 44.36 44.41 44.83 44.41 44.37 43.85 44 43.52 43.81 43.99 43.45 43.71 42.6 42.91 43.47 43.3 43.74 42.55 42.87 43.64 43.54 44.03 45.08 44.72 44.31 44.6 44.53 44.75 44.69 45.1 45.55 45.23 44.6 44.63 44.18 44.52 44.32 44.53 44.32 44.09 44.51 44.35 43.57 43.34 43.39 43.07 43.91 43.73 43.84 43.28 43.62 43.68 43.87 43.81 45.87 45.98 45.91 45.7 45.3 45.19 45.33 45.5 45.31 45.14 44.01 44.11 44.11 44.5 44.6 44.76 44.99 45.08 45.23 45 44.4 44.52 44.84 44.89 44.7 44.84 44.83 44.86 44.77 44.83 44.85 44.48 44.3 44.3 44.27 43.98 44.12 43.85 43.76 43.49 43 43.69 43.69 44 44.23 43.37 43.73 43.92 44.08 45.08 44.98 44.72 44.6 44.69 44.76 45.01 45.18 45.66 45.45 45.23 44.86 44.66 44.59 44.62 44.65 44.66 44.47 44.78 44.52 44.18 43.55 43.56 43.51 43.93 44.23 44.02 43.8 43.67 43.75 43.97 43.84 45.56 45.73 45.52 45.33 44.91 44.87 44.93 45.09 44.93 43.73 43.14 43.51 43.49 43.91 44.09 43.94 44.5 44.57 44.68 43.98 43.73 44.11 44.37 44.47 44.34 44.28 44.44 44.19 44.22 44.14 44.24 43.85 43.76 43.93 43.52 43.49 43.61 43.18 43.13 42.44 42.21 42.65 43.13 43.23 42.55 42.77 42.59 43.41 43.48 44.04 44.32 44.01 44.3 44.15 44.3 44.07 44.69 45.04 45.16 44.6 44.48 43.89 44.07 44.11 44.08 44.3 43.99 44.02 44.26 43.49 43.31 43.06 42.95 43.15 43.69 43.63 43.28 43.14 43.56 43.62 43.57 45.81 355600 41.50569 45.81 336500 41.50569 45.75 442400 41.45133 45.69 388700 41.39697 45.3 351700 41.04361 45.08 429600 40.84429 45.09 455600 40.85334 45.42 382200 41.15234 45.16 388300 40.91677 45.14 619300 40.89865 43.91 353700 39.78422 43.56 237900 39.4671 43.89 311400 39.7661 43.97 258900 39.83858 44.43 146400 40.25536 44.53 1025100 40.34596 44.86 353200 40.64496 44.72 433000 40.51811 45.02 831200 40.78992 45 555800 40.7718 43.78 578300 39.66643 44.25 303200 40.09227 44.42 266500 40.2463 44.65 280000 40.45469 44.63 332800 40.43657 44.55 278200 40.36408 44.57 269600 40.3822 44.73 424100 40.52717 44.33 289500 40.16476 44.49 280300 40.30972 44.82 587900 40.60871 44.41 351500 40.23724 44.2 245200 40.04697 44.04 407100 39.902 43.94 457000 39.8114 43.72 294900 39.61207 43.76 813900 39.64831 43.85 605400 39.72985 43.45 394700 39.36744 43.46 683000 39.3765 42.38 603800 38.39798 42.76 834700 38.74227 43.46 699000 39.3765 43.58 565400 39.48523 43.7 831200 39.59395 42.77 526400 38.75133 42.79 358600 38.76945 43.83 334000 39.71174 43.5 390100 39.41274 44.05 828100 39.91106 44.83 679700 40.61778 44.7 483200 40.49999 44.49 203900 39.902 44.49 235700 39.902 44.33 414100 39.7585 44.65 464600 40.0455 44.92 279000 40.28766 45.17 419500 40.51188 45.3 231600 40.62847 45.23 485800 40.56569 44.6 264300 40.00066 44.56 406000 39.96478 44.11 287100 39.56119 44.4 289400 39.82128 44.17 274000 39.615 44.47 456600 39.88407 44.41 425200 39.83025 44.15 587100 39.59707 44.52 416000 39.92891 44.17 758200 39.615 43.49 371500 39.00513 43.2 623400 38.74503 43.39 481000 38.91544 43.24 531600 38.78091 43.85 428400 39.328 43.66 529200 39.1576 43.77 496500 39.25625 43.17 893200 38.71812 43.58 353100 39.08585 43.7 321000 39.19347 43.69 433200 39.1845 9/17/2012 9/14/2012 9/13/2012 9/12/2012 9/11/2012 9/10/2012 9/7/2012 9/6/2012 9/5/2012 9/4/2012 8/31/2012 8/30/2012 8/29/2012 8/28/2012 8/27/2012 8/24/2012 8/23/2012 8/22/2012 8/21/2012 8/20/2012 8/17/2012 8/16/2012 8/15/2012 8/14/2012 8/13/2012 8/10/2012 8/9/2012 8/8/2012 8/7/2012 8/6/2012 8/3/2012 8/2/2012 8/1/2012 7/31/2012 7/30/2012 7/27/2012 7/26/2012 7/25/2012 7/24/2012 7/23/2012 7/20/2012 7/19/2012 7/18/2012 7/17/2012 7/16/2012 7/13/2012 7/12/2012 7/11/2012 7/10/2012 7/9/2012 7/6/2012 7/5/2012 7/3/2012 7/2/2012 44.17 44.57 44.24 44.6 44.82 44.86 45.32 44.62 44.27 44.03 44.51 44.19 44.57 44.73 44.71 44.59 45.38 45.58 45.77 45.85 46.03 46.25 46.2 46.03 45.97 46.03 46.26 46.24 46.94 47.15 47.5 46.33 46.83 47.13 46.83 46.82 46.69 46.47 46.95 47.3 47.09 47.27 46.85 46.71 46.58 46.43 45.46 45.41 45.62 45.55 45.44 45.78 46.14 45.37 44.32 44.65 44.68 44.68 44.9 44.87 45.38 45.33 44.55 44.45 44.52 44.31 44.68 44.8 44.85 44.73 45.38 45.66 45.89 45.93 46.26 46.43 46.45 46.35 46.1 46.18 46.43 46.4 47.14 47.42 47.5 46.58 47.25 47.39 47.44 47.28 47.07 46.47 46.96 47.3 47.65 47.5 47.32 46.99 46.7 46.7 45.87 45.68 45.68 45.61 45.62 45.9 46.27 46.26 43.77 44.19 44.16 44.15 44.57 44.6 44.78 44.52 44.27 44.02 44.08 44.08 44.35 44.43 44.64 44.47 44.52 45.19 45.46 45.64 45.91 45.95 46.04 45.99 45.8 45.86 45.9 46.09 46.24 46.66 46.24 45.94 46.27 46.67 46.83 46.7 46.65 45.87 45.98 46.85 47.07 46.93 46.73 46.5 46.36 45.9 45.34 45.32 45.23 45.18 45.18 45.65 45.84 45.37 43.79 44.19 44.64 44.26 44.64 44.76 44.8 45.33 44.35 44.41 44.08 44.25 44.41 44.51 44.68 44.63 44.62 45.34 45.6 45.77 45.99 46.05 46.27 46.18 45.93 46.07 45.95 46.18 46.25 46.78 46.95 46.56 46.46 46.71 47.25 46.94 46.98 46.19 46.44 46.95 47.5 47.23 47.26 46.86 46.61 46.65 45.75 45.67 45.4 45.45 45.56 45.66 45.93 46.25 740500 345400 272300 231000 313000 316100 299400 638100 612800 670800 650800 298100 290100 317300 346700 337800 435400 268800 452700 262100 215100 322100 583900 576600 469800 287300 328900 474900 619600 291700 737800 585600 616500 494300 328500 479300 333800 425600 514500 275200 370900 372100 474700 500500 328700 493000 285500 335300 315800 266400 378800 281600 318700 423400 39.27419 39.63294 40.03653 39.69572 40.03653 40.14416 40.18003 40.65538 39.77644 39.83025 39.53428 39.68675 39.83025 39.91994 40.07241 40.02757 40.0186 40.66435 40.89753 41.05 41.24732 41.30113 41.49844 41.41772 41.1935 41.31907 41.21144 41.41772 41.4805 41.95585 42.10832 41.75854 41.66885 41.89307 42.37738 42.09935 41.73163 41.02988 41.25195 41.70498 42.19354 41.9537 41.98035 41.62504 41.40296 41.4385 40.63904 40.56797 40.32814 40.37255 40.47027 40.55909 40.79893 41.08318 http://finance.yahoo.com/q/hp?s=LNT&a=06&b=2&c=2012&d=06&e=31&f=2015&g=d Alliant Energy Corp. NYSE: LNT Annual Financials for Alliant Energy Corp. Financial Calculations ($ in billions except per share price) Inputs Stock price Debt Equity Net income Sales Depreciation Interest tax rate Fixed capital expenditure Working capital investment 2013 2014 $ 46.89 $ 53.37 $ 3.36 $ 3.62 $ 3.34 $ 3.48 $ 0.32 $ 0.36 $ 3.09 $ 3.28 $ 0.39 $ 0.41 $ 0.16 $ 0.17 21% 12% $ 0.12 $ 0.80 $ -0.03 $ -0.42 Calculations PE ratio Debt to equity Return on equity Profit margin Free cash flows $ 15.98 $ 16.24 $ 17.62 1.01 1.04 1.08 9.73% 10.47% 10.59% 10.51% 11.10% 11.51% $ 0.50 $ 0.25 $ -0.07 Current Ratio Earnings Per Share (EPS) 0.97 0.71 2015 $ 61.29 $ 3.93 $ 3.64 $ 0.39 $ 3.35 $ 0.44 $ 0.18 10% $ 0.90 $ -0.17 0.86

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: Chris LeachJ LeachRonald Melicher

3rd Edition

0324561253, 9780324561258

More Books

Students also viewed these Finance questions

Question

What are the two basic types of control charts?

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago