finanzas corporativas practica 1.xlsx

Upload: mario-bermudez-paz

Post on 02-Jun-2018

222 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    1/76

    Operating Activities

    Fiscal year is January-December. All valuesUSD millions.

    2009 2010 2011 2012

    Net Income before Extraordinaries 2.72B 6.56B 20.21B 5.67B

    Depreciation, Depletion & Amortization 8.02B 5.9B 5.38B 6.18B

    Depreciation and Depletion 8.02B 5.9B 5.38B 6.18BAmortization of Intangible Assets - - - -

    Deferred Taxes & Investment Tax Credit (804M) 34M (11.07B) 1.99B

    Deferred Taxes (804M) 34M (11.07B) 1.99BInvestment Tax Credit - - - -Other Funds 3.34B (1.49B) (2.76B) (1.52B)Funds from Operations 13.27B 11B 11.76B 12.31BExtraordinaries - - - -Changes in Working Capital 2.77B 474M (1.97B) (3.27B)Receivables - - - (2.8B)Accounts Payable (1.8B) (704M) (680M) 485MOther Assets/Liabilities 2.24B 2.08B (927M) 451MNet Operating Cash Flow 16.04B 11.48B 9.78B 9.05B

    Investing Activities

    2009 2010 2011 2012Capital Expenditures (4.56B) (4.09B) (4.29B) (5.49B)Capital Expenditures (Fixed Assets) (4.56B) (4.09B) (4.29B) (5.49B)Capital Expenditures (Other Assets) 0 0 0 0Net Assets from Acquisitions 0 0 - -Sale of Fixed Assets & Businesses 382M 1.32B 333M 66MPurchase/Sale of Investments (3.86B) 1.02B 2.07B (1.39B)Purchase of Investments (78.79B) (100.15B) (68.72B) (95.14B)Sale/Maturity of Investments 74.93B 101.17B 70.8B 93.75BOther Uses (26.29B) (29.37B) (35.94B) (40.01B)

    Other Sources 40.8B 38.03B 34.78B 32.52BNet Investing Cash Flow 6.47B 6.91B (3.04B) (14.29B)

    Financing Activities

    2009 2010 2011 2012Cash Dividends Paid - Total 0 0 0 (763M)Common Dividends 0 0 0 (763M)

    http://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flow
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    2/76

    Preferred Dividends 0 0 0 0Change in Capital Stock 2.45B 1.34B 0 (125M)

    Repurchase of Common & Preferred Stk. 0 0 0 (125M)

    Sale of Common & Preferred Stock 2.45B 1.34B 0 0Proceeds from Stock Options 2.45B 1.34B 0 0

    Other Proceeds from Sale of Stock - - - -Issuance/Reduction of Debt, Net (21.84B) (18.56B) (4.33B) 4.43BChange in Current Debt (5.94B) (1.75B) 2.84B 1.21BChange in Long-Term Debt (15.9B) (16.8B) (7.17B) 3.23BIssuance of Long-Term Debt 45.99B 30.82B 35.92B 32.44BReduction in Long-Term Debt (61.89B) (47.63B) (43.1B) (29.21B)Other Funds (3.57B) (7.2B) 92M 159MOther Uses (2.57B) (7.3B) 0 0Other Sources (996M) 100M 92M 159MNet Financing Cash Flow (22.96B) (24.42B) (4.24B) 3.71BExchange Rate Effect 470M (53M) (159M) 51MMiscellaneous Funds 0 0 0 0Net Change in Cash 22M (6.09B) 2.34B (1.49B)Free Cash Flow 11.48B 7.39B 5.49B 2.79B

    http://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/F/financials/cash-flow
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    3/76

    2013

    7.16B

    6.5B

    6.5B-

    (861M)

    (861M)-3.83B16.62B-(6.18B)(5.01B)(595M)

    010.44B

    2013(6.6B)(6.6B)

    000

    (1.75B)(119.99B)118.25B(46.04B)

    34.65B(19.73B)

    2013(1.57B)(1.57B)

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    4/76

    0(213M)

    (213M)

    -0

    -9.66B(2.93B)12.59B40.54B(27.95B)257M

    0257M8.13B(37M)

    0(1.19B)2.27B

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    5/76

    Assets

    Fiscal year is July-June. All valuesUSD millions.

    2010 2011 2012 2013 2014

    Cash & Short Term Investments 36.79B 52.77B 63.04B 77.02B 85.71BCash Only 1.66B 1.65B 2.02B 1.97B 8.67BShort-Term Investments 35.13B 51.12B 61.02B 75.06B 77.04BTotal Accounts Receivable 13.01B 14.99B 15.78B 17.49B 19.54BAccounts Receivables, Net 13.01B 14.99B 15.78B 17.49B 19.54BAccounts Receivables, Gross 13.39B 15.32B 16.17B 17.82B 19.85BBad Debt/Doubtful Accounts (375M) (333M) (389M) (336M) (301M)Other Receivables 0 0 0 0 0Inventories 740M 1.37B 1.14B 1.94B 2.66BFinished Goods 552M 1.08B 831M 1.41B 1.45BWork in Progress 16M 56M 96M 201M 266MRaw Materials 172M 232M 210M 328M 944MProgress Payments & Other - - - - -Other Current Assets 5.13B 5.79B 5.13B 5.02B 6.33BMiscellaneous Current Assets 5.13B 5.79B 5.13B 5.02B 6.33BTotal Current Assets 55.68B 74.92B 85.08B 101.47B 114.25B

    2010 2011 2012 2013 2014

    Net Property, Plant & Equipment 7.63B 8.16B 8.27B 9.99B 13.01B

    Property, Plant & Equipment - Gross 16.26B 17.99B 19.23B 22.5B 27.8B

    Buildings 6.09B 6.52B 6.77B 7.33B 8.87BLand & Improvements 526M 533M 528M 525M 541M

    Computer Software and Equipment 5.67B 6.6B 7.3B 9.24B 11.43B

    Other Property, Plant & Equipment 3.97B 4.34B 4.64B 5.41B 6.97B

    Accumulated Depreciation 8.63B 9.83B 10.96B 12.51B 14.79BTotal Investments and Advances 7.75B 10.87B 9.78B 10.84B 14.6BOther Long-Term Investments 7.75B 10.87B 9.78B 10.84B 14.6BLong-Term Note Receivable 0 0 0 0 0Intangible Assets 13.55B 13.33B 16.62B 17.74B 27.11B

    Net Goodwill 12.39B 12.58B 13.45B 14.66B 20.13BNet Other Intangibles 1.16B 744M 3.17B 3.08B 6.98BOther Assets 1.5B 1.43B 1.52B 2.39B 3.42BTangible Other Assets 1.5B 1.43B 1.52B 2.39B 3.42BTotal Assets 86.11B 109.68B 121.96B 143.49B 172.38B

    Liabilities & Shareholders' Equity

    http://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheet
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    6/76

    2010 2011 2012 2013 2014

    ST Debt & Current Portion LT Debt 1B 0 1.23B 3B 2.56B

    Short Term Debt 1B 0 0 0 2.56B

    Current Portion of Long Term Debt 0 0 1.23B 3B 0

    Accounts Payable 4.03B 4.2B 4.18B 4.83B 7.43BIncome Tax Payable 1.07B 580M 789M 592M 782MOther Current Liabilities 20.05B 24B 26.49B 29B 34.85BDividends Payable 1.13B 1.34B 1.68B 1.92B 2.31BAccrued Payroll 3.28B 3.58B 3.88B 4.12B 4.8BMiscellaneous Current Liabilities 15.64B 19.08B 20.94B 22.97B 27.75BTotal Current Liabilities 26.15B 28.77B 32.69B 37.42B 45.63BLong-Term Debt 4.94B 11.92B 10.71B 12.6B 20.65BLong-Term Debt excl. CapitalizedLeases

    4.94B 11.92B 10.71B 12.6B 20.65B

    Non-Convertible Debt 3.69B 21M 10.71B 12.6B 20.65BConvertible Debt 1.25B 11.9B 0 0 0Capitalized Lease Obligations 0 0 0 0 0Provision for Risks & Charges 0 7.66B 7.85B 9.71B 10.59BDeferred Taxes 229M 1.46B 1.89B 1.71B 2.73BDeferred Taxes - Credit 229M 2.44B 2.59B 2.76B 2.73BDeferred Taxes - Debit 0 979M 693M 1.06B 0Other Liabilities 8.62B 1.81B 1.76B 2.05B 3.01BOther Liabilities (excl. DeferredIncome)

    7.45B 415M 354M 290M 1B

    Deferred Income 1.18B 1.4B 1.41B 1.76B 2.01B

    Total Liabilities 39.94B 52.6B 55.6B 64.54B 82.6BNon-Equity Reserves 0 0 0 0 0Preferred Stock (Carrying Value) 0 0 0 0 0Redeemable Preferred Stock - - - 0 0

    Non-Redeemable Preferred Stock - - - 0 0

    Common Equity (Total) 46.18B 57.08B 66.36B 78.94B 89.78BCommon Stock Par/Carry Value 62.86B 63.42B 65.8B 67.31B 68.37BRetained Earnings (17.74B) (8.2B) (856M) 9.9B 17.71BESOP Debt Guarantee 0 0 0 0 0Cumulative Translation

    Adjustment/Unrealized For. Exch.Gain

    (176M) 205M (101M) (117M) 31M

    Unrealized Gain/Loss MarketableSecurities

    1.23B 1.66B 1.52B 1.86B 0

    Revaluation Reserves 0 0 0 0 0Treasury Stock 0 0 0 0 0Total Shareholders' Equity 46.18B 57.08B 66.36B 78.94B 89.78BAccumulated Minority Interest 0 0 0 0 0Total Equity 46.18B 57.08B 66.36B 78.94B 89.78B

    http://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheethttp://www.marketwatch.com/investing/Stock/MSFT/financials/balance-sheet
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    7/76

    Liabilities & Shareholders' Equity 86.11B 109.68B 121.96B 143.49B 172.38B

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    8/76

    Operating Activities

    Fiscal year is July-June. All valuesUSD millions.

    2010 2011 2012 2013 2014

    Net Income beforeExtraordinaries

    18.76B 23.15B 16.98B 21.86B 22.07B

    Depreciation, Depletion &Amortization

    2.67B 2.77B 2.97B 3.76B 5.21B

    Depreciation and Depletion 1.97B 2.23B 2.29B 2.81B 4.17B

    Amortization of Intangible Assets 707M 537M 675M 949M 1.05B

    Deferred Taxes & Investment TaxCredit

    (220M) 2M 954M (19M) (331M)

    Deferred Taxes (220M) 2M 954M (19M) (331M)Investment Tax Credit - - - - -Other Funds 2.2B 4.08B 10.9B 4.61B 4.65B

    Funds from Operations 23.41B 30B 31.8B 30.21B 31.61BExtraordinaries - - - - -Changes in Working Capital 661M (3B) (174M) (1.38B) 624MReceivables (2.24B) (1.45B) (1.16B) (1.81B) (1.12B)Accounts Payable - 58M (31M) 537M 473MOther Assets/Liabilities 2.9B (1.05B) 829M 697M 1.43BNet Operating Cash Flow 24.07B 26.99B 31.63B 28.83B 32.23B

    Investing Activities

    2010 2011 2012 2013 2014Capital Expenditures (1.98B) (2.36B) (2.31B) (4.26B) (5.49B)Capital Expenditures (FixedAssets)

    (1.98B) (2.36B) (2.31B) (4.26B) (5.49B)

    Capital Expenditures (OtherAssets)

    0 0 0 0 0

    Net Assets from Acquisitions (245M) (71M) (10.11B) (1.58B) (5.94B)

    Sale of Fixed Assets & Businesses - - - - -

    Purchase/Sale of Investments (7.59B) (13.22B) (11.98B) (17.8B) (7.32B)

    Purchase of Investments (30.17B) (35.99B) (57.25B) (75.4B) (72.69B)Sale/Maturity of Investments 22.58B 22.78B 45.28B 57.59B 65.37BOther Uses (1.5B) 0 (394M) (168M) (87M)Other Sources 0 1.03B 0 0 0Net Investing Cash Flow (11.31B) (14.62B) (24.79B) (23.81B) (18.83B)

    Financing Activities

    http://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flow
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    9/76

    2010 2011 2012 2013 2014Cash Dividends Paid - Total (4.58B) (5.18B) (6.39B) (7.46B) (8.88B)Common Dividends (4.58B) (5.18B) (6.39B) (7.46B) (8.88B)Preferred Dividends 0 0 0 0 0Change in Capital Stock (8.96B) (9.13B) (3.12B) (4.43B) (6.71B)Repurchase of Common &

    Preferred Stk. (11.27B) (11.56B) (5.03B) (5.36B) (7.32B)

    Sale of Common & PreferredStock

    2.31B 2.42B 1.91B 931M 607M

    Proceeds from Stock Options 2.31B 2.42B 1.91B 931M 607MOther Proceeds from Sale ofStock

    - - - - 0

    Issuance/Reduction of Debt, Net 190M 5.96B 0 3.54B 6.96B

    Change in Current Debt (991M) (186M) 0 0 500MChange in Long-Term Debt 1.18B 6.15B 0 3.54B 6.46BIssuance of Long-Term Debt 4.17B 6.96B 0 4.88B 10.35BReduction in Long-Term Debt (2.99B) (814M) 0 (1.35B) (3.89B)Other Funds 55M (23M) 93M 199M 232MOther Uses 0 (40M) 0 (10M) (39M)Other Sources 55M 17M 93M 209M 271MNet Financing Cash Flow (13.29B) (8.38B) (9.41B) (8.15B) (8.39B)Exchange Rate Effect (39M) 103M (104M) (8M) (139M)Miscellaneous Funds 0 0 0 0 0Net Change in Cash (571M) 4.11B (2.67B) (3.13B) 4.87BFree Cash Flow 17.52B 19.46B 22.94B 17.12B 17.87B

    http://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flowhttp://www.marketwatch.com/investing/Stock/MSFT/financials/cash-flow
  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    10/76

    Date Open High Low Close Volume Adj Close1/4/2010 10.17 10.28 10.05 10.28 60855800 9.611/5/2010 10.45 11.24 10.4 10.96 215620200 10.241/6/2010 11.21 11.46 11.13 11.37 200070600 10.631/7/2010 11.46 11.69 11.32 11.66 130201700 10.91/8/2010 11.67 11.74 11.46 11.69 130463000 10.93

    1/11/2010 11.9 12.14 11.78 12.11 170626200 11.321/12/2010 11.98 12.03 11.72 11.87 162995900 11.091/13/2010 11.91 11.93 11.47 11.68 154527100 10.921/14/2010 11.65 11.86 11.51 11.76 116531200 10.991/15/2010 11.74 11.76 11.55 11.6 96149800 10.841/19/2010 11.51 11.83 11.46 11.75 65934000 10.981/20/2010 11.68 11.69 11.5 11.51 71649500 10.761/21/2010 11.53 11.62 11.01 11.18 121451400 10.451/22/2010 11.01 11.12 10.41 10.52 161530100 9.831/25/2010 10.73 11.1 10.61 11.03 121621500 10.311/26/2010 11.17 11.46 11.07 11.19 108250500 10.461/27/2010 11.57 11.62 11.22 11.55 105091600 10.791/28/2010 11.9 11.95 11.27 11.41 203320000 10.661/29/2010 11.6 11.61 10.7 10.84 159741200 10.13

    2/1/2010 11.14 11.18 10.93 11.12 82748200 10.392/2/2010 11.26 11.52 11.19 11.39 119714900 10.652/3/2010 11.49 11.66 11.42 11.64 90125500 10.882/4/2010 11.49 11.53 11 11.06 129792200 10.342/5/2010 10.97 11.11 10.49 10.91 181535200 10.22/8/2010 11.09 11.32 10.88 10.97 92031400 10.252/9/2010 11.18 11.22 11.02 11.15 83207100 10.42

    2/10/2010 11.12 11.14 10.9 10.94 73395600 10.222/11/2010 11 11.19 10.88 11.18 65116200 10.452/12/2010 10.92 11.18 10.85 11.12 69465400 10.392/16/2010 11.21 11.38 11.11 11.32 62537500 10.582/17/2010 11.43 11.52 11.35 11.49 65983200 10.742/18/2010 11.41 11.48 11.29 11.38 53406800 10.642/19/2010 11.35 11.4 11.26 11.29 46990000 10.552/22/2010 11.36 11.38 11.18 11.21 41993100 10.482/23/2010 11.18 11.63 11.15 11.6 114688400 10.842/24/2010 11.72 11.88 11.65 11.73 84200800 10.962/25/2010 11.53 11.83 11.4 11.78 83114500 11.01

    2/26/2010 11.83 11.85 11.61 11.74 72368400 10.973/1/2010 11.81 12.42 11.75 12.41 142605500 11.63/2/2010 12.62 12.68 12.18 12.22 193706600 11.423/3/2010 12.46 12.83 12.35 12.69 157004600 11.863/4/2010 12.78 12.8 12.52 12.79 89836800 11.953/5/2010 12.92 13.04 12.83 13 106920600 12.153/8/2010 12.94 12.96 12.79 12.93 78903200 12.083/9/2010 12.83 13.03 12.73 12.8 83934300 11.96

    3/10/2010 12.88 12.95 12.8 12.82 56850600 11.98

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    11/76

    3/11/2010 12.79 12.97 12.75 12.91 59274700 12.073/12/2010 13.02 13.37 12.98 13.34 104771000 12.473/15/2010 13.46 13.63 13.32 13.4 95072200 12.523/16/2010 13.49 13.51 13.32 13.49 74692700 12.613/17/2010 13.55 14.15 13.55 14.1 137318700 13.183/18/2010 14.23 14.54 13.65 13.73 235094400 12.83

    3/19/2010 13.29 13.92 13.04 13.29 252411200 12.423/22/2010 12.98 14 12.81 13.99 170576100 13.083/23/2010 14.17 14.3 13.81 13.9 167002400 12.993/24/2010 13.77 14.05 13.76 13.9 91765400 12.993/25/2010 14.05 14.12 13.76 13.8 88909300 12.93/26/2010 13.89 13.98 13.76 13.86 60400400 12.953/29/2010 13.7 13.88 13.39 13.57 158225000 12.683/30/2010 13.55 13.64 13.18 13.28 142055200 12.413/31/2010 12.82 12.95 12.42 12.57 433659100 11.75

    4/1/2010 12.84 12.95 12.58 12.63 212952100 11.84/5/2010 12.89 12.92 12.76 12.77 88957200 11.934/6/2010 12.78 12.88 12.6 12.7 76423800 11.874/7/2010 12.69 12.82 12.53 12.58 88112400 11.764/8/2010 12.55 12.71 12.34 12.63 77491400 11.84/9/2010 12.73 12.84 12.61 12.72 60408600 11.89

    4/12/2010 12.72 12.81 12.64 12.77 50783100 11.934/13/2010 12.75 12.89 12.71 12.79 71008500 11.954/14/2010 12.92 13.43 12.86 13.35 153602100 12.484/15/2010 13.42 13.88 13.41 13.76 159110500 12.864/16/2010 13.84 13.92 13.3 13.42 149640000 12.544/19/2010 13.38 13.75 13.36 13.6 95855100 12.71

    4/20/2010 13.72 13.94 13.67 13.91 75630700 134/21/2010 14.02 14.15 13.92 14.13 120284000 13.214/22/2010 14 14.23 13.85 14.2 93331100 13.274/23/2010 14.22 14.39 14.11 14.21 92002200 13.284/26/2010 14.39 14.57 14.28 14.46 123029200 13.514/27/2010 14.44 14.5 13.15 13.57 292667400 12.684/28/2010 13.39 13.45 12.9 13.25 208023500 12.384/29/2010 13.45 13.7 13.38 13.58 110114400 12.694/30/2010 13.64 13.73 12.96 13.02 146322900 12.17

    5/3/2010 13.18 13.49 13.18 13.3 106416800 12.435/4/2010 13.07 13.08 12.75 12.85 123207400 12.01

    5/5/2010 12.32 12.7 11.59 12.34 198525600 11.535/6/2010 12.17 12.51 10.59 11.78 237094700 11.015/7/2010 11.95 11.97 10.95 11.51 261066500 10.76

    5/10/2010 12.54 12.56 12.02 12.15 134388700 11.365/11/2010 11.99 12.56 11.85 12.31 125738800 11.55/12/2010 12.57 12.71 12.49 12.68 102657000 11.855/13/2010 12.87 12.87 12.32 12.42 100156000 11.615/14/2010 12.25 12.35 11.87 12.11 105856000 11.325/17/2010 12.08 12.18 11.49 11.95 108686700 11.17

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    12/76

    5/18/2010 12.15 12.18 11.45 11.55 101309100 10.795/19/2010 11.3 11.66 11.11 11.55 132864400 10.795/20/2010 11.04 11.3 10.76 10.8 156449200 10.095/21/2010 10.25 11.3 10.17 11.26 174455100 10.525/24/2010 11.29 11.44 11.01 11.01 90998300 10.295/25/2010 10.47 11.05 10.42 11.02 137858600 10.3

    5/26/2010 11.45 11.82 11.35 11.39 146872000 10.655/27/2010 11.85 12 11.66 11.99 90700800 11.215/28/2010 12.05 12.08 11.62 11.73 78823400 10.96

    6/1/2010 11.5 11.88 11.38 11.41 80977300 10.666/2/2010 11.66 11.87 11.45 11.85 87265300 11.086/3/2010 12.01 12.15 11.81 11.96 79568700 11.186/4/2010 11.69 11.88 11.39 11.5 83480900 10.756/7/2010 11.45 11.5 11.06 11.09 76229000 10.366/8/2010 11.14 11.37 10.89 11.22 81494400 10.496/9/2010 11.36 11.4 11 11.05 74947600 10.33

    6/10/2010 11.21 11.4 11.1 11.39 64799500 10.656/11/2010 11.23 11.47 11.21 11.4 50280600 10.656/14/2010 11.48 11.72 11.4 11.46 58144500 10.716/15/2010 11.55 11.76 11.52 11.7 51790900 10.936/16/2010 11.65 11.77 11.5 11.63 61954100 10.876/17/2010 11.69 11.69 11.33 11.48 69430100 10.736/18/2010 11.56 11.62 11.4 11.46 55417700 10.716/21/2010 11.68 11.8 11.5 11.53 67814300 10.786/22/2010 11.54 11.6 11.18 11.22 73509000 10.496/23/2010 11.23 11.28 11 11.03 83134400 10.316/24/2010 10.99 11.03 10.64 10.78 74449200 10.08

    6/25/2010 10.75 10.77 10.42 10.75 148168400 10.056/28/2010 10.72 10.76 10.43 10.43 57994700 9.756/29/2010 10.12 10.14 9.75 9.88 124866100 9.236/30/2010 10.1 10.52 10.04 10.08 182831300 9.42

    7/1/2010 10.23 10.63 10.02 10.57 153383000 9.887/2/2010 10.58 10.63 10.15 10.28 71607100 9.617/6/2010 10.42 10.57 10.04 10.16 81246900 9.57/7/2010 10.21 10.63 10.17 10.59 72565300 9.97/8/2010 10.72 10.83 10.45 10.62 62355500 9.937/9/2010 10.58 10.94 10.54 10.85 50732700 10.14

    7/12/2010 10.84 11.13 10.83 11.1 56354100 10.37

    7/13/2010 11.47 11.81 11.26 11.66 103923200 10.97/14/2010 11.62 11.92 11.54 11.81 68051400 11.047/15/2010 11.86 11.9 11.51 11.86 66020400 11.087/16/2010 11.75 11.78 11.3 11.34 68905500 10.67/19/2010 11.44 11.57 11.23 11.48 49910000 10.737/20/2010 11.3 11.76 11.25 11.75 53134900 10.987/21/2010 11.82 11.88 11.43 11.55 67645100 10.797/22/2010 11.76 12.22 11.75 12.09 102031500 11.37/23/2010 12.55 12.75 12.35 12.72 161608200 11.89

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    13/76

    7/26/2010 12.82 13.15 12.75 12.94 125770900 12.097/27/2010 13.16 13.18 12.85 13.03 97305400 12.187/28/2010 12.99 13.08 12.86 12.91 59746700 12.077/29/2010 13.03 13.11 12.72 12.97 88510100 12.127/30/2010 12.81 13.01 12.58 12.77 79512400 11.93

    8/2/2010 13.06 13.2 12.94 13.16 77124700 12.3

    8/3/2010 13.08 13.24 12.77 12.91 115202600 12.078/4/2010 13 13.21 12.95 13.11 60875000 12.258/5/2010 13.05 13.05 12.9 12.98 51574800 12.138/6/2010 12.83 13.05 12.8 13.04 54704600 12.198/9/2010 13.12 13.12 12.92 13.05 39072000 12.2

    8/10/2010 12.94 13.03 12.8 12.92 50265100 12.088/11/2010 12.65 12.67 12.33 12.41 68132100 11.68/12/2010 12.03 12.39 11.9 12.27 68017900 11.478/13/2010 12.25 12.37 12.13 12.15 41635500 11.368/16/2010 11.96 12.15 11.88 11.99 59316100 11.218/17/2010 12.2 12.38 12.06 12.16 61043500 11.368/18/2010 12.17 12.29 11.8 12.2 54218100 11.48/19/2010 12.13 12.2 11.83 11.89 61059000 11.118/20/2010 11.85 11.9 11.6 11.77 50806600 118/23/2010 11.84 11.9 11.6 11.61 42449600 10.858/24/2010 11.28 11.49 11.09 11.24 86299200 10.58/25/2010 11.04 11.4 10.95 11.32 78571900 10.588/26/2010 11.4 11.56 11.14 11.17 56953100 10.448/27/2010 11.26 11.72 11.05 11.56 63565200 10.88/30/2010 11.58 11.68 11.35 11.35 33651500 10.618/31/2010 11.27 11.46 11.13 11.29 64984700 10.55

    9/1/2010 11.53 11.89 11.46 11.61 81988800 10.859/2/2010 11.68 11.83 11.57 11.71 39943600 10.949/3/2010 11.88 12.14 11.84 12.07 65243900 11.289/7/2010 12.01 12.07 11.78 11.8 42497600 11.039/8/2010 11.81 11.95 11.7 11.8 40798700 11.039/9/2010 11.96 12.04 11.64 11.75 48528500 10.98

    9/10/2010 11.81 11.99 11.75 11.79 37849800 11.029/13/2010 11.93 12 11.84 11.99 36689700 11.219/14/2010 11.96 12.05 11.89 11.98 39772300 11.29/15/2010 11.93 11.96 11.76 11.87 54102700 11.099/16/2010 12.12 12.53 12.1 12.44 141408500 11.63

    9/17/2010 12.53 12.54 12.34 12.49 68954600 11.679/20/2010 12.55 12.6 12.38 12.57 49812800 11.759/21/2010 12.53 12.75 12.51 12.55 59130900 11.739/22/2010 12.43 12.54 12.29 12.38 53139300 11.579/23/2010 12.26 12.45 12.15 12.31 46866400 11.59/24/2010 12.42 12.57 12.39 12.56 42647800 11.749/27/2010 12.57 12.6 12.46 12.48 28799700 11.669/28/2010 12.48 12.53 12.27 12.52 42671500 11.79/29/2010 12.45 12.5 12.28 12.33 45211800 11.52

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    14/76

    9/30/2010 12.44 12.46 12.2 12.24 42679600 11.4410/1/2010 12.24 12.41 12.12 12.26 54565500 11.4610/4/2010 12.57 12.92 12.53 12.84 95949200 1210/5/2010 13 13.07 12.92 13.01 74701900 12.1610/6/2010 13.06 13.45 13.04 13.24 92326000 12.3710/7/2010 13.32 13.38 13.19 13.32 53526700 12.45

    10/8/2010 13.3 13.72 13.28 13.66 71857700 12.7710/11/2010 13.72 13.9 13.68 13.78 48002800 12.8810/12/2010 13.71 13.85 13.51 13.78 50056400 12.8810/13/2010 13.9 13.91 13.64 13.64 59061900 12.7510/14/2010 13.88 14.01 13.78 13.91 78814100 1310/15/2010 14 14.04 13.61 13.8 61337700 12.910/18/2010 13.75 13.9 13.64 13.88 34852700 12.9710/19/2010 13.63 13.64 13.18 13.32 84614000 12.4510/20/2010 13.45 13.73 13.35 13.64 60800200 12.7510/21/2010 13.78 14.16 13.66 13.81 85365000 12.9110/22/2010 13.86 14.01 13.83 13.95 38003100 13.0410/25/2010 14.05 14.2 14.01 14.15 77370800 13.2210/26/2010 13.97 14.47 13.92 14.36 214814400 13.4210/27/2010 14.34 14.35 14.09 14.23 81025700 13.310/28/2010 14.29 14.32 14.06 14.22 51719400 13.2910/29/2010 14.18 14.23 14.1 14.13 52281900 13.21

    11/1/2010 14.32 14.37 14.16 14.23 56606000 13.311/2/2010 14.32 14.46 14.22 14.43 54691100 13.4911/3/2010 14.48 15.2 14.44 15.18 185667300 14.1911/4/2010 15.51 15.98 15.4 15.86 193232000 14.8211/5/2010 15.98 16.26 15.81 16.21 141539900 15.15

    11/8/2010 16.36 16.49 16.06 16.41 127386000 15.3411/9/2010 16.53 16.58 15.88 16.07 133717300 15.0211/10/2010 16.32 16.71 16.08 16.63 139738200 15.5411/11/2010 16.54 16.66 16.2 16.61 94746200 15.5211/12/2010 16.46 16.53 16.04 16.3 91657100 15.2311/15/2010 16.81 17.41 16.68 17 233268400 15.8911/16/2010 17.19 17.42 16.36 16.51 234481200 15.4311/17/2010 16.76 16.9 16.52 16.68 127748600 15.5911/18/2010 16.77 16.87 16.05 16.12 256937900 15.0711/19/2010 16.02 16.38 15.83 16.28 130323600 15.2211/22/2010 16.26 16.54 16.11 16.2 91288900 15.14

    11/23/2010 16.01 16.16 15.62 15.7 96689100 14.6711/24/2010 15.95 16.06 15.81 15.95 66727700 14.9111/26/2010 15.81 16.18 15.75 16.1 31557200 15.0511/29/2010 16.12 16.12 15.86 16.06 61577500 15.0111/30/2010 15.92 15.99 15.83 15.94 71737400 14.9

    12/1/2010 16.24 16.5 16.14 16.46 100724400 15.3812/2/2010 16.72 16.86 16.63 16.78 82484500 15.6812/3/2010 16.63 16.83 16.6 16.8 67399500 15.712/6/2010 16.66 16.78 16.52 16.65 57290300 15.56

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    15/76

    12/7/2010 16.91 16.92 16.55 16.56 64104300 15.4812/8/2010 16.66 16.73 16.35 16.69 106700000 15.612/9/2010 16.82 16.85 16.66 16.76 47280900 15.66

    12/10/2010 16.68 16.77 16.65 16.73 38196000 15.6412/13/2010 16.65 16.72 16.47 16.47 53899700 15.3912/14/2010 16.5 16.58 16.39 16.42 43070000 15.35

    12/15/2010 16.37 16.66 16.35 16.55 44901200 15.4712/16/2010 16.52 16.77 16.44 16.77 49567600 15.6712/17/2010 16.76 16.85 16.68 16.8 51948100 15.712/20/2010 16.85 16.9 16.63 16.85 41880000 15.7512/21/2010 16.89 17 16.84 16.99 35604000 15.8812/22/2010 17 17.03 16.85 16.99 31602700 15.8812/23/2010 16.9 16.93 16.75 16.78 25730100 15.6812/27/2010 16.72 16.87 16.6 16.87 27703900 15.7712/28/2010 16.83 16.85 16.65 16.73 28413200 15.6412/29/2010 16.67 16.8 16.65 16.74 25556700 15.6512/30/2010 16.72 16.85 16.65 16.69 24055100 15.612/31/2010 16.65 16.83 16.61 16.79 22417600 15.69

    1/3/2011 17.02 17.31 17 17.25 70794200 16.121/4/2011 17.39 17.66 16.96 17.38 106477200 16.241/5/2011 17.31 18.09 17.22 17.89 112378000 16.721/6/2011 18.03 18.29 17.95 18.22 96284400 17.031/7/2011 18.42 18.42 18.08 18.27 99029500 17.08

    1/10/2011 18.43 18.49 18.16 18.31 65348400 17.111/11/2011 18.48 18.49 18.13 18.28 61312500 17.081/12/2011 18.36 18.75 18.29 18.71 66841400 17.491/13/2011 18.81 18.97 18.55 18.68 100459700 17.46

    1/14/2011 18.61 18.75 18.58 18.65 50279400 17.431/18/2011 18.66 18.77 18.61 18.7 39737500 17.481/19/2011 18.71 18.72 17.77 17.9 89216500 16.731/20/2011 17.77 18 17.35 17.78 93501600 16.621/21/2011 17.99 18.11 17.87 17.95 48717700 16.781/24/2011 18.03 18.03 17.75 17.93 51698600 16.761/25/2011 17.86 18.02 17.66 17.89 47155800 16.721/26/2011 17.97 18.43 17.9 18.37 66834100 17.171/27/2011 18.52 18.88 18.33 18.79 67711700 17.561/28/2011 17.79 17.88 15.98 16.27 480879500 15.211/31/2011 16.56 16.64 15.45 15.95 275198200 14.91

    2/1/2011 16.14 16.24 15.85 15.89 178894300 14.852/2/2011 15.91 15.98 15.31 15.4 187008500 14.392/3/2011 15.38 15.78 15.1 15.76 153131300 14.732/4/2011 15.91 15.95 15.64 15.72 79198700 14.692/7/2011 15.84 16.36 15.8 16.11 118132900 15.062/8/2011 16.17 16.26 16.02 16.24 59674500 15.182/9/2011 16.13 16.3 16.02 16.09 61896700 15.04

    2/10/2011 15.99 16.11 15.9 15.95 65334900 14.912/11/2011 16.06 16.51 15.99 16.38 94736400 15.31

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    16/76

    2/14/2011 16.38 16.39 16.02 16.09 69632700 15.042/15/2011 16.03 16.16 15.95 16.1 51612800 15.052/16/2011 16.16 16.18 16 16.05 59843600 152/17/2011 16.01 16.03 15.83 15.97 53727600 14.932/18/2011 15.95 15.99 15.7 15.77 68774000 14.742/22/2011 15.36 15.52 15.08 15.23 97449900 14.23

    2/23/2011 15.02 15.04 14.49 14.86 159528600 13.892/24/2011 14.57 14.99 14.5 14.7 120277400 13.742/25/2011 14.94 15.11 14.85 15.07 78341600 14.082/28/2011 15.29 15.29 14.89 15.05 54120000 14.07

    3/1/2011 15.1 15.12 14.6 14.66 74337200 13.73/2/2011 14.66 14.89 14.62 14.66 67127000 13.73/3/2011 14.9 14.95 14.66 14.76 66720400 13.793/4/2011 14.79 14.79 14.28 14.42 81593400 13.483/7/2011 14.34 14.42 13.98 14.01 105389900 13.093/8/2011 14.02 14.55 14.01 14.47 106699200 13.523/9/2011 14.59 14.6 14.25 14.29 68046300 13.36

    3/10/2011 14.1 14.28 14.01 14.06 107127400 13.143/11/2011 13.9 14.46 13.87 14.36 72249100 13.423/14/2011 14.47 14.64 14.2 14.3 65056100 13.363/15/2011 13.8 14.8 13.75 14.67 108919700 13.713/16/2011 14.73 14.79 13.89 14.18 127862700 13.253/17/2011 14.56 14.58 14.18 14.26 78683000 13.333/18/2011 14.58 14.67 14.43 14.49 64541000 13.543/21/2011 14.7 14.72 14.48 14.59 46486600 13.643/22/2011 14.52 14.57 14.32 14.34 44731700 13.43/23/2011 14.26 14.45 14.02 14.31 64431300 13.37

    3/24/2011 14.4 15.12 14.39 15.04 128201100 14.063/25/2011 15.2 15.2 14.9 15.01 58954600 14.033/28/2011 14.99 15.09 14.83 14.86 41259800 13.893/29/2011 14.83 14.94 14.73 14.84 33301800 13.873/30/2011 14.88 14.97 14.74 14.86 40889600 13.893/31/2011 14.82 14.95 14.71 14.91 41909100 13.93

    4/1/2011 15.03 15.42 14.92 15.16 116247300 14.174/4/2011 15.39 15.74 15.39 15.55 99116600 14.534/5/2011 15.65 15.81 15.55 15.79 72322800 14.764/6/2011 15.91 15.98 15.61 15.73 62315800 14.74/7/2011 15.71 15.82 15.45 15.53 51295100 14.51

    4/8/2011 15.65 15.68 15.16 15.33 51126100 14.334/11/2011 15.27 15.4 14.74 14.86 85626200 13.894/12/2011 14.59 15 14.5 14.91 82591000 13.934/13/2011 15.04 15.05 14.8 14.98 58736600 144/14/2011 14.74 14.85 14.61 14.81 62357700 13.844/15/2011 14.86 14.91 14.61 14.71 47434700 13.754/18/2011 14.51 14.74 14.49 14.62 49822500 13.664/19/2011 14.65 14.79 14.54 14.66 33575500 13.74/20/2011 14.95 15.2 14.84 15.09 70978900 14.1

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    17/76

    4/21/2011 15.23 15.45 15.1 15.43 53181900 14.424/25/2011 15.51 15.59 15.35 15.54 54775800 14.524/26/2011 16.04 16.18 15.66 15.66 166900000 14.644/27/2011 15.85 15.87 15.42 15.58 84380600 14.564/28/2011 15.47 15.7 15.42 15.5 48145500 14.494/29/2011 15.49 15.68 15.4 15.47 40203200 14.46

    5/2/2011 15.52 15.69 15.41 15.45 42185500 14.445/3/2011 15.42 15.56 15.26 15.38 68659100 14.375/4/2011 15.42 15.45 14.97 15.15 71753400 14.165/5/2011 14.97 15.3 14.88 15.08 62502900 14.095/6/2011 15.26 15.37 15.08 15.11 58371200 14.125/9/2011 15.12 15.2 15.02 15.08 33369700 14.09

    5/10/2011 15.13 15.2 15.08 15.15 36633400 14.165/11/2011 15.11 15.35 15.06 15.15 54989600 14.165/12/2011 15.14 15.34 15.12 15.26 48775700 14.265/13/2011 15.22 15.3 15.03 15.08 43317100 14.095/16/2011 15.21 15.32 15.1 15.13 51778600 14.145/17/2011 15.06 15.18 14.82 14.97 65261100 13.995/18/2011 15.01 15.16 14.87 15.12 41278000 14.135/19/2011 15.1 15.17 15.01 15.12 38684200 14.135/20/2011 15.05 15.11 14.97 15 39285300 14.025/23/2011 14.71 14.93 14.65 14.8 49529300 13.835/24/2011 14.84 14.85 14.56 14.66 48890300 13.75/25/2011 14.54 14.66 14.35 14.58 93969200 13.635/26/2011 14.51 14.6 14.4 14.56 45961100 13.615/27/2011 14.55 14.64 14.46 14.6 35654200 13.655/31/2011 14.75 14.92 14.64 14.92 66438900 13.94

    6/1/2011 14.78 14.9 14.2 14.23 91509400 13.36/2/2011 14.26 14.37 14.09 14.18 58588100 13.256/3/2011 13.88 14.22 13.81 14.01 57295900 13.096/6/2011 13.99 14.12 13.86 13.91 54183600 136/7/2011 14.17 14.19 13.94 13.95 73208000 13.046/8/2011 13.96 14.01 13.65 13.7 77161700 12.86/9/2011 13.74 13.87 13.58 13.8 55365400 12.9

    6/10/2011 13.68 13.74 13.33 13.35 96684000 12.486/13/2011 13.14 13.26 12.78 13.14 110748300 12.286/14/2011 13.29 13.56 13.25 13.43 61363200 12.556/15/2011 13.3 13.36 13.05 13.15 88736600 12.29

    6/16/2011 13.05 13.18 12.68 12.83 91842200 11.996/17/2011 12.94 12.95 12.68 12.77 75778900 11.936/20/2011 12.66 13.03 12.65 12.94 51392800 12.096/21/2011 13.08 13.53 13.04 13.32 72508100 12.456/22/2011 13.39 13.5 13.33 13.36 42578600 12.496/23/2011 13.12 13.5 13.06 13.47 59361900 12.596/24/2011 13.52 13.6 13.14 13.24 82743600 12.376/27/2011 13.35 13.55 13.09 13.46 50005900 12.586/28/2011 13.55 13.55 13.25 13.33 54013200 12.46

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    18/76

    6/29/2011 13.41 13.51 13.32 13.42 54105500 12.546/30/2011 13.46 13.97 13.36 13.79 74076900 12.89

    7/1/2011 13.92 14.13 13.73 14.02 66304800 13.17/5/2011 14.07 14.18 13.91 14.1 47019400 13.187/6/2011 14.13 14.13 13.89 13.96 46233600 13.057/7/2011 14.13 14.22 13.9 14.12 66182800 13.2

    7/8/2011 13.86 13.9 13.61 13.88 68539000 12.977/11/2011 13.64 13.69 13.26 13.32 61376200 12.457/12/2011 13.13 13.38 13.12 13.12 57768900 12.267/13/2011 13.3 13.43 13.23 13.27 44328200 12.47/14/2011 13.33 13.4 13.04 13.09 45989000 12.237/15/2011 13.14 13.2 13 13.09 41208600 12.237/18/2011 13.02 13.06 12.63 12.9 66084800 12.067/19/2011 13 13.18 12.86 13.09 53892600 12.237/20/2011 13.19 13.19 12.92 13.08 33450700 12.227/21/2011 13.16 13.32 13.08 13.28 43705600 12.417/22/2011 13.29 13.34 13.15 13.31 26480600 12.447/25/2011 13.04 13.24 13.01 13.17 45334300 12.317/26/2011 13.3 13.44 12.85 12.94 109165800 12.097/27/2011 12.8 12.85 12.3 12.37 113808600 11.567/28/2011 12.4 12.65 12.3 12.32 69884600 11.517/29/2011 12.11 12.42 12 12.21 68621600 11.41

    8/1/2011 12.75 12.81 12.21 12.35 73771800 11.548/2/2011 12.28 12.35 11.82 11.85 97171100 11.088/3/2011 11.92 11.92 11.36 11.65 127291500 10.898/4/2011 11.49 11.51 10.77 10.86 153368800 10.158/5/2011 11.05 11.23 10.32 10.84 139254200 10.13

    8/8/2011 10.02 10.42 9.87 9.93 202155900 9.288/9/2011 10.5 10.95 10.13 10.91 177330900 10.28/10/2011 10.82 10.87 10.32 10.41 119877300 9.738/11/2011 10.48 11.12 10.43 10.94 114926800 10.228/12/2011 11.29 11.31 11 11.06 79279300 10.348/15/2011 11.29 11.37 11.17 11.35 46283800 10.618/16/2011 11.23 11.45 11.05 11.22 53398200 10.498/17/2011 11.34 11.4 10.92 11.11 52262000 10.388/18/2011 10.67 10.7 10.22 10.38 87073500 9.78/19/2011 10.05 10.45 9.9 9.99 87207200 9.348/22/2011 10.39 10.39 9.81 10.01 73424500 9.36

    8/23/2011 10.16 10.32 10.01 10.31 52107600 9.648/24/2011 10.31 10.46 10.13 10.45 53035500 9.778/25/2011 10.53 10.72 10.22 10.28 50166000 9.618/26/2011 10.18 10.53 10.06 10.4 59398700 9.728/29/2011 10.64 10.95 10.61 10.93 48857900 10.228/30/2011 10.87 10.96 10.64 10.87 50345100 10.168/31/2011 11.03 11.3 10.98 11.12 69283600 10.39

    9/1/2011 11.14 11.27 10.81 10.85 64031000 10.149/2/2011 10.53 10.68 10.26 10.42 62021000 9.74

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    19/76

    9/6/2011 10.02 10.27 10 10.22 65558100 9.559/7/2011 10.44 10.58 10.32 10.56 45052800 9.879/8/2011 10.49 10.64 10.27 10.34 45105500 9.669/9/2011 10.11 10.29 9.98 10.05 69911300 9.39

    9/12/2011 9.86 10.14 9.85 10.11 58352000 9.459/13/2011 10.16 10.23 10 10.17 44205300 9.5

    9/14/2011 10.25 10.5 10.04 10.32 70810200 9.659/15/2011 10.45 10.64 10.32 10.63 53843200 9.939/16/2011 10.62 10.69 10.36 10.62 46858900 9.939/19/2011 10.34 10.62 10.3 10.54 41663900 9.859/20/2011 10.61 10.65 10.41 10.42 37706900 9.749/21/2011 10.4 10.51 9.97 9.97 62227400 9.329/22/2011 9.79 10.14 9.43 9.62 115851100 8.999/23/2011 9.46 9.98 9.32 9.86 70702600 9.229/26/2011 9.96 10.09 9.7 10.08 54424800 9.429/27/2011 10.32 10.35 10.09 10.12 65062200 9.469/28/2011 10.18 10.22 9.9 9.93 43567700 9.289/29/2011 10.14 10.15 9.75 10 52634800 9.359/30/2011 9.89 10.01 9.65 9.67 56697200 9.0410/3/2011 9.66 9.92 9.36 9.37 72828100 8.7610/4/2011 9.22 10.13 9.05 10.08 103900000 9.4210/5/2011 10.07 10.59 9.83 10.56 96318100 9.8710/6/2011 10.61 11 10.56 10.99 86277500 10.2710/7/2011 11.04 11.2 10.63 10.69 87812400 9.99

    10/10/2011 10.93 11.23 10.9 11.21 57668200 10.4810/11/2011 11.17 11.29 11.02 11.24 61332000 10.510/12/2011 11.4 11.8 11.38 11.38 82907500 10.64

    10/13/2011 11.39 11.46 11.04 11.34 60021300 10.610/14/2011 11.58 11.67 11.34 11.56 54535700 10.810/17/2011 11.71 11.76 11.32 11.4 53715600 10.6510/18/2011 11.41 11.93 11.27 11.78 66804200 11.0110/19/2011 11.77 11.92 11.46 11.56 69510100 10.810/20/2011 11.66 11.75 11.47 11.7 62145700 10.9310/21/2011 11.86 12.32 11.84 12.26 86636000 11.4610/24/2011 12.31 12.65 12.3 12.51 68986900 11.6910/25/2011 12.58 12.59 12.14 12.43 77049100 11.6210/26/2011 12.09 12.2 11.54 11.87 159678600 11.0910/27/2011 12.29 12.29 11.71 12.08 132526600 11.29

    10/28/2011 11.97 12.07 11.86 12 60363200 11.2210/31/2011 11.8 11.91 11.68 11.68 41740400 10.92

    11/1/2011 11.33 11.39 11.03 11.08 108235700 10.3611/2/2011 11.26 11.28 11.04 11.15 52759200 10.4211/3/2011 11.29 11.39 11.02 11.32 57802200 10.5811/4/2011 11.28 11.39 11.12 11.27 43133100 10.5311/7/2011 11.2 11.3 11.06 11.22 39924300 10.4911/8/2011 11.27 11.68 11.18 11.61 60893400 10.8511/9/2011 11.2 11.38 10.98 11.04 72026000 10.32

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    20/76

    11/10/2011 11.17 11.19 10.9 10.99 50555200 10.2711/11/2011 11.15 11.18 11.05 11.14 32872400 10.4111/14/2011 11.12 11.17 10.98 11.02 30530100 10.311/15/2011 10.93 11 10.82 10.87 43972900 10.1611/16/2011 10.8 10.82 10.5 10.56 49001300 9.8711/17/2011 10.54 10.56 10.07 10.17 69670700 9.5

    11/18/2011 10.28 10.3 10.07 10.1 44422000 9.4411/21/2011 9.99 10.12 9.8 10.05 60890100 9.3911/22/2011 10.02 10.15 9.9 10.09 43750700 9.4311/23/2011 9.97 10.04 9.83 9.83 44958400 9.1911/25/2011 9.81 9.95 9.75 9.75 20118500 9.1111/28/2011 10.15 10.19 9.9 10 57953300 9.3511/29/2011 10.03 10.13 9.92 9.99 40443800 9.3411/30/2011 10.33 10.6 10.17 10.6 66922300 9.91

    12/1/2011 10.51 10.81 10.41 10.59 61397000 9.912/2/2011 10.79 11.1 10.75 10.9 67252600 10.1912/5/2011 11.16 11.42 11.02 11.11 65924700 10.3812/6/2011 11.1 11.19 11 11.05 39786100 10.3312/7/2011 11 11.15 10.88 11.08 45168800 10.3612/8/2011 10.96 11.11 9.84 10.75 82552300 10.0512/9/2011 10.94 11.11 10.87 11.03 48326600 10.31

    12/12/2011 10.87 10.89 10.68 10.85 40777500 10.1412/13/2011 10.92 11.04 10.36 10.48 67905600 9.7912/14/2011 10.33 10.41 10.1 10.15 53224300 9.4912/15/2011 10.31 10.42 10.19 10.25 46636200 9.5812/16/2011 10.32 10.4 10.16 10.25 45962300 9.5812/19/2011 10.25 10.39 9.99 10.02 45068200 9.36

    12/20/2011 10.21 10.38 10.18 10.33 45235100 9.6512/21/2011 10.38 10.74 10.33 10.66 56203100 9.9612/22/2011 10.78 10.98 10.66 10.94 43983100 10.2212/23/2011 10.99 11 10.79 10.95 26953000 10.2312/27/2011 10.87 10.98 10.76 10.81 25444800 10.112/28/2011 10.82 10.84 10.43 10.52 33445100 9.8312/29/2011 10.56 10.75 10.5 10.68 34317000 9.9812/30/2011 10.64 10.79 10.6 10.76 26815800 10.06

    1/3/2012 11 11.25 10.99 11.13 45709900 10.41/4/2012 11.15 11.53 11.07 11.3 79725200 10.561/5/2012 11.33 11.63 11.24 11.59 67877500 10.83

    1/6/2012 11.74 11.8 11.52 11.71 59840700 10.941/9/2012 11.83 11.95 11.7 11.8 53981500 11.03

    1/10/2012 12 12.05 11.63 11.8 121750600 11.031/11/2012 11.74 12.18 11.65 12.07 63806000 11.281/12/2012 12.16 12.18 11.89 12.14 48687700 11.351/13/2012 12.01 12.08 11.84 12.04 46366700 11.251/17/2012 12.2 12.26 11.96 12.02 44398400 11.231/18/2012 12.03 12.37 12 12.34 47102700 11.531/19/2012 12.48 12.72 12.43 12.61 70894200 11.79

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    21/76

    1/20/2012 12.55 12.64 12.45 12.59 43705700 11.771/23/2012 12.69 12.84 12.55 12.66 49379700 11.831/24/2012 12.56 12.86 12.46 12.82 45768400 11.981/25/2012 12.8 12.98 12.7 12.93 54021600 12.081/26/2012 13.03 13.05 12.66 12.79 75470700 11.951/27/2012 11.96 12.53 11.79 12.21 142155300 11.46

    1/30/2012 12.06 12.44 12 12.29 57752600 11.531/31/2012 12.47 12.51 12.2 12.42 46412100 11.652/1/2012 12.73 12.75 12.29 12.33 71669000 11.572/2/2012 12.4 12.43 12.2 12.26 48347600 11.52/3/2012 12.47 12.84 12.39 12.79 78851200 122/6/2012 12.85 13 12.71 12.96 46363300 12.162/7/2012 12.93 12.97 12.83 12.88 39413500 12.082/8/2012 12.91 12.96 12.8 12.84 35352500 12.052/9/2012 12.89 12.9 12.67 12.69 52290500 11.91

    2/10/2012 12.52 12.66 12.37 12.44 52505500 11.672/13/2012 12.74 12.74 12.51 12.54 34474400 11.772/14/2012 12.46 12.58 12.34 12.48 39627900 11.712/15/2012 12.47 12.57 12.33 12.38 38174800 11.622/16/2012 12.38 12.77 12.38 12.74 49164400 11.952/17/2012 12.84 12.88 12.71 12.75 30778000 11.962/21/2012 12.74 12.76 12.46 12.53 38409800 11.762/22/2012 12.49 12.51 12.22 12.28 43326000 11.522/23/2012 12.27 12.44 12.16 12.4 36747600 11.632/24/2012 12.43 12.46 12.19 12.23 31399300 11.482/27/2012 12.11 12.36 11.99 12.3 38703400 11.542/28/2012 12.34 12.35 12.2 12.25 30789000 11.49

    2/29/2012 12.28 12.55 12.25 12.38 62093700 11.623/1/2012 12.48 12.77 12.45 12.66 68262000 11.883/2/2012 12.74 12.94 12.68 12.72 49063500 11.933/5/2012 12.67 12.68 12.41 12.46 28433700 11.693/6/2012 12.23 12.25 12 12.09 57374500 11.343/7/2012 12.21 12.3 12.15 12.24 28440900 11.483/8/2012 12.41 12.55 12.32 12.46 37099100 11.693/9/2012 12.53 12.73 12.48 12.58 36159300 11.8

    3/12/2012 12.57 12.59 12.37 12.43 30275700 11.663/13/2012 12.48 12.72 12.4 12.7 42783600 11.923/14/2012 12.64 12.9 12.63 12.88 47578500 12.08

    3/15/2012 12.9 13.04 12.83 12.9 55286600 12.13/16/2012 12.86 12.9 12.51 12.51 77119600 11.743/19/2012 12.52 12.68 12.48 12.63 52445700 11.853/20/2012 12.48 12.61 12.39 12.54 40214400 11.773/21/2012 12.59 12.67 12.55 12.57 27521400 11.793/22/2012 12.48 12.54 12.24 12.32 50117100 11.563/23/2012 12.31 12.37 12.18 12.32 44755000 11.563/26/2012 12.45 12.5 12.39 12.48 26692200 11.713/27/2012 12.51 12.61 12.3 12.32 35070700 11.56

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    22/76

    3/28/2012 12.35 12.36 12.18 12.32 41051700 11.563/29/2012 12.33 12.52 12.24 12.5 51039700 11.733/30/2012 12.55 12.58 12.4 12.48 36381000 11.71

    4/2/2012 12.5 12.65 12.44 12.62 43966900 11.844/3/2012 12.71 12.95 12.46 12.64 97034200 11.864/4/2012 12.46 12.52 12.32 12.51 51505000 11.74

    4/5/2012 12.38 12.58 12.38 12.47 37939500 11.74/9/2012 12.26 12.29 12.11 12.22 42515300 11.474/10/2012 12.19 12.28 11.65 11.79 77370300 11.064/11/2012 11.99 12.02 11.88 11.91 34724400 11.174/12/2012 11.94 12.13 11.86 12.07 26988800 11.324/13/2012 11.98 12.03 11.84 11.92 39675000 11.184/16/2012 12.01 12.05 11.83 11.88 31903500 11.154/17/2012 11.98 12 11.88 11.91 35981200 11.174/18/2012 11.81 11.85 11.72 11.79 32314000 11.064/19/2012 11.81 11.88 11.58 11.66 48169200 10.944/20/2012 11.71 11.72 11.39 11.41 52631000 10.714/23/2012 11.15 11.4 11.15 11.35 31269200 10.654/24/2012 11.61 11.61 11.36 11.39 38615200 10.694/25/2012 11.51 11.75 11.43 11.73 45185400 11.014/26/2012 11.71 11.93 11.67 11.87 40889300 11.144/27/2012 12.03 12.04 11.52 11.6 83070300 10.884/30/2012 11.42 11.47 11.15 11.28 46156300 10.63

    5/1/2012 11.25 11.34 11.11 11.23 43959200 10.585/2/2012 11.16 11.17 11 11.1 48572900 10.465/3/2012 11.13 11.15 10.85 10.92 40238400 10.295/4/2012 10.84 10.87 10.63 10.67 53268400 10.05

    5/7/2012 10.53 10.79 10.52 10.66 33235200 10.055/8/2012 10.6 10.64 10.4 10.61 46174500 105/9/2012 10.48 10.81 10.41 10.69 54501200 10.07

    5/10/2012 10.83 10.86 10.66 10.71 42526100 10.095/11/2012 10.61 10.83 10.56 10.58 36561300 9.975/14/2012 10.41 10.53 10.3 10.32 50225200 9.725/15/2012 10.34 10.34 10.1 10.15 41886500 9.565/16/2012 10.23 10.43 10.15 10.16 44321300 9.575/17/2012 10.16 10.25 10.01 10.01 49648900 9.435/18/2012 10.08 10.18 9.96 10.01 50572000 9.435/21/2012 10.02 10.23 10 10.2 38134900 9.61

    5/22/2012 10.25 10.4 10.15 10.19 44295700 9.65/23/2012 10.32 10.45 10.22 10.41 75647800 9.815/24/2012 10.5 10.62 10.38 10.59 45334100 9.985/25/2012 10.61 10.68 10.51 10.6 30430800 9.995/29/2012 10.69 10.88 10.68 10.84 43760600 10.215/30/2012 10.73 10.75 10.52 10.66 44592100 10.055/31/2012 10.62 10.68 10.4 10.56 54297000 9.95

    6/1/2012 10.33 10.37 10.06 10.12 68237000 9.546/4/2012 10.15 10.18 9.91 10.04 57305600 9.46

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    23/76

    6/5/2012 10.01 10.24 9.97 10.19 38326200 9.66/6/2012 10.29 10.58 10.27 10.57 50458000 9.966/7/2012 10.73 10.78 10.52 10.55 33846100 9.946/8/2012 10.48 10.68 10.38 10.66 30811600 10.05

    6/11/2012 10.77 10.8 10.45 10.45 35811400 9.856/12/2012 10.47 10.55 10.31 10.5 35130800 9.89

    6/13/2012 10.39 10.49 10.22 10.3 41384200 9.716/14/2012 10.27 10.45 10.21 10.41 37531800 9.816/15/2012 10.4 10.42 10.26 10.35 39442000 9.756/18/2012 10.35 10.4 10.26 10.34 27361000 9.746/19/2012 10.37 10.64 10.35 10.56 37155900 9.956/20/2012 10.58 10.74 10.52 10.65 40810100 10.046/21/2012 10.65 10.68 10.25 10.27 40062800 9.686/22/2012 10.35 10.4 10.18 10.19 56427300 9.66/25/2012 10.13 10.18 9.95 10.01 44297600 9.436/26/2012 10.06 10.08 9.96 10.01 31871900 9.436/27/2012 10.05 10.1 9.97 10.02 33278900 9.446/28/2012 9.93 10.09 9.93 10.09 38648400 9.516/29/2012 9.95 9.98 9.46 9.59 138138600 9.04

    7/2/2012 9.5 9.6 9.3 9.39 63388600 8.857/3/2012 9.53 9.79 9.49 9.6 49629300 9.057/5/2012 9.67 9.74 9.53 9.57 31783900 9.027/6/2012 9.47 9.52 9.4 9.5 30355400 8.957/9/2012 9.46 9.47 9.31 9.45 37441600 8.91

    7/10/2012 9.5 9.55 9.28 9.35 33516600 8.817/11/2012 9.33 9.38 9.26 9.33 32028700 8.797/12/2012 9.26 9.28 9.12 9.13 55111000 8.6

    7/13/2012 9.16 9.32 9.14 9.27 30248300 8.747/16/2012 9.22 9.32 9.15 9.26 28838200 8.737/17/2012 9.28 9.35 9.12 9.34 29510000 8.87/18/2012 9.38 9.52 9.34 9.38 31010000 8.847/19/2012 9.45 9.5 9.33 9.35 33615000 8.817/20/2012 9.28 9.35 9.18 9.21 27968300 8.687/23/2012 9.08 9.21 9.05 9.17 33773800 8.647/24/2012 9.17 9.24 8.95 9.06 53519200 8.547/25/2012 9.17 9.2 8.91 8.97 44338200 8.457/26/2012 9.05 9.11 8.83 8.96 51798900 8.447/27/2012 8.99 9.1 8.88 9 67986800 8.48

    7/30/2012 9.04 9.18 9.01 9.1 40958300 8.587/31/2012 9.13 9.28 9.12 9.24 41360900 8.71

    8/1/2012 9.29 9.42 8.99 9.04 65973000 8.578/2/2012 8.99 9.03 8.82 8.92 45326500 8.458/3/2012 9.02 9.15 8.96 9.09 38631400 8.618/6/2012 9.13 9.21 9.09 9.15 23819100 8.678/7/2012 9.18 9.39 9.18 9.31 43574500 8.828/8/2012 9.25 9.38 9.24 9.35 22630300 8.868/9/2012 9.31 9.46 9.3 9.34 30909800 8.85

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    24/76

    8/10/2012 9.3 9.36 9.23 9.35 19618800 8.868/13/2012 9.35 9.42 9.25 9.4 21122000 8.918/14/2012 9.45 9.66 9.42 9.44 21129500 8.948/15/2012 9.44 9.54 9.41 9.49 21308300 8.998/16/2012 9.5 9.67 9.49 9.59 34323700 9.098/17/2012 9.65 9.66 9.6 9.63 34533900 9.12

    8/20/2012 9.58 9.64 9.51 9.63 38923800 9.128/21/2012 9.65 9.7 9.52 9.53 26281100 9.038/22/2012 9.5 9.56 9.4 9.49 26965500 8.998/23/2012 9.45 9.54 9.42 9.45 23537700 8.958/24/2012 9.42 9.52 9.41 9.49 19574600 8.998/27/2012 9.51 9.52 9.38 9.39 22754200 8.98/28/2012 9.37 9.44 9.31 9.34 23084400 8.858/29/2012 9.33 9.4 9.29 9.32 26115700 8.838/30/2012 9.3 9.34 9.25 9.31 16459400 8.828/31/2012 9.39 9.43 9.31 9.34 28029200 8.85

    9/4/2012 9.37 9.47 9.35 9.41 37965000 8.929/5/2012 9.45 9.62 9.39 9.57 40608800 9.079/6/2012 9.66 9.96 9.66 9.92 67996400 9.49/7/2012 9.95 10.23 9.93 10.14 60617000 9.61

    9/10/2012 10.08 10.28 10.06 10.11 43381300 9.589/11/2012 10.18 10.25 10.13 10.15 28165300 9.629/12/2012 10.25 10.3 10.17 10.21 28046500 9.679/13/2012 10.2 10.38 10.12 10.34 50920200 9.89/14/2012 10.41 10.57 10.39 10.53 55934300 9.989/17/2012 10.27 10.42 10.26 10.39 31922200 9.849/18/2012 10.3 10.45 10.28 10.42 34937000 9.87

    9/19/2012 10.49 10.66 10.45 10.59 42403000 10.039/20/2012 10.48 10.52 10.35 10.44 28755100 9.899/21/2012 10.53 10.54 10.36 10.4 35459800 9.859/24/2012 10.3 10.4 10.26 10.32 28557900 9.789/25/2012 10.35 10.37 10.06 10.09 36866300 9.569/26/2012 9.98 10.12 9.86 10.01 44362600 9.489/27/2012 10.13 10.18 10.02 10.02 25740900 9.499/28/2012 9.99 10 9.81 9.86 44586300 9.3410/1/2012 9.89 10.08 9.88 9.93 33445600 9.4110/2/2012 10.01 10.05 9.71 9.79 63630000 9.2810/3/2012 9.82 10.02 9.76 9.94 51023800 9.42

    10/4/2012 10.06 10.15 9.96 10.11 46855500 9.5810/5/2012 10.17 10.28 10.13 10.16 40693900 9.6310/8/2012 10.06 10.12 9.99 10.05 25473900 9.5210/9/2012 10.21 10.25 10.02 10.1 38235700 9.57

    10/10/2012 10.12 10.12 9.95 9.98 33951600 9.4610/11/2012 10.06 10.26 10.05 10.14 39328700 9.6110/12/2012 10.14 10.25 10.09 10.12 24108500 9.5910/15/2012 10.11 10.25 10.09 10.22 26466500 9.6810/16/2012 10.26 10.32 10.22 10.3 32788400 9.76

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    25/76

    10/17/2012 10.31 10.41 10.26 10.41 29346300 9.8610/18/2012 10.36 10.57 10.33 10.43 44041700 9.8810/19/2012 10.42 10.43 10.13 10.18 40493000 9.6510/22/2012 10.14 10.24 10.03 10.17 39149700 9.6410/23/2012 10.02 10.11 9.97 10 32476500 9.4710/24/2012 10.08 10.29 10.01 10.17 49339800 9.64

    10/25/2012 10.42 10.49 10.28 10.39 59290900 9.8410/26/2012 10.35 10.42 10.22 10.36 43485500 9.8210/31/2012 10.7 11.17 10.6 11.16 137960900 10.62

    11/1/2012 11.19 11.3 10.88 11.25 88770100 10.7111/2/2012 11.31 11.38 11.15 11.17 53399000 10.6311/5/2012 11.15 11.35 11.13 11.25 37995000 10.7111/6/2012 11.33 11.59 11.26 11.42 51232200 10.8711/7/2012 11.25 11.34 11.04 11.06 56674900 10.5311/8/2012 11.07 11.23 10.89 10.9 45948800 10.3811/9/2012 10.76 11.1 10.71 10.93 40703600 10.41

    11/12/2012 11.03 11.16 10.96 10.97 25723100 10.4411/13/2012 10.89 11.1 10.86 11 33342900 10.4711/14/2012 11.02 11.05 10.62 10.67 45664700 10.1611/15/2012 10.57 10.8 10.46 10.57 48879800 10.0611/16/2012 10.58 10.64 10.38 10.5 45346200 1011/19/2012 10.65 10.9 10.65 10.83 39359100 10.3111/20/2012 10.85 11.02 10.76 10.85 34739800 10.3311/21/2012 10.84 11 10.8 10.92 21181700 10.411/23/2012 10.98 11.1 10.96 11.1 16032200 10.5711/26/2012 11.05 11.14 10.97 11.11 26831700 10.5811/27/2012 11.1 11.27 11.1 11.1 37610000 10.57

    11/28/2012 11.05 11.26 10.98 11.25 38496900 10.7111/29/2012 11.32 11.53 11.32 11.53 57289300 10.9811/30/2012 11.52 11.6 11.33 11.45 41329600 10.9

    12/3/2012 11.56 11.7 11.4 11.41 47746300 10.8612/4/2012 11.4 11.44 11.23 11.31 37760200 10.7712/5/2012 11.32 11.4 11.18 11.31 33152400 10.7712/6/2012 11.26 11.31 11.19 11.24 31065800 10.712/7/2012 11.27 11.5 11.26 11.48 38404500 10.93

    12/10/2012 11.41 11.53 11.41 11.47 26025200 10.9212/11/2012 11.51 11.58 11.4 11.49 36326900 10.9412/12/2012 11.52 11.56 11.43 11.47 31099900 10.92

    12/13/2012 11.46 11.5 11.21 11.27 35443200 10.7312/14/2012 11.27 11.27 11.03 11.1 36933500 10.5712/17/2012 11.16 11.41 11.14 11.39 46983300 10.8412/18/2012 11.48 11.68 11.4 11.67 61810400 11.1112/19/2012 11.79 11.85 11.62 11.73 54884700 11.1712/20/2012 11.74 11.8 11.58 11.77 47750100 11.2112/21/2012 11.55 11.86 11.47 11.86 94489300 11.2912/24/2012 11.67 12.4 11.67 12.4 91734900 11.8112/26/2012 12.31 12.79 12.31 12.79 140331900 12.18

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    26/76

    12/27/2012 12.79 12.81 12.36 12.76 108315100 12.1512/28/2012 12.55 12.88 12.52 12.87 95668600 12.2512/31/2012 12.88 13.08 12.76 12.95 106908900 12.33

    1/2/2013 13.23 13.28 13 13.2 75274700 12.571/3/2013 13.24 13.7 13.05 13.46 121284700 12.811/4/2013 13.51 13.61 13.35 13.57 54669900 12.92

    1/7/2013 13.52 13.58 13.35 13.43 43482400 12.791/8/2013 13.38 13.43 13.2 13.35 46336200 12.711/9/2013 13.4 13.6 13.39 13.47 36973900 12.82

    1/10/2013 13.78 13.94 13.68 13.83 84884300 13.171/11/2013 14 14.07 13.9 14 67641200 13.331/14/2013 14.04 14.08 13.86 13.99 46224800 13.321/15/2013 13.91 14.3 13.89 14.3 55425000 13.611/16/2013 14.16 14.25 14.01 14.22 51453400 13.541/17/2013 14.27 14.3 14.07 14.22 44299300 13.541/18/2013 14.1 14.13 13.97 14.11 45716100 13.431/22/2013 14.06 14.19 14 14.17 35467900 13.491/23/2013 14 14.02 13.79 13.88 58122200 13.211/24/2013 13.82 13.98 13.81 13.87 42532700 13.211/25/2013 13.83 13.84 13.64 13.68 53405400 13.021/28/2013 13.49 13.82 13.42 13.78 51189300 13.221/29/2013 13.56 13.61 12.89 13.14 131146500 12.61/30/2013 13.01 13.2 12.89 12.93 59595900 12.41/31/2013 12.86 13.02 12.67 12.95 65844000 12.42

    2/1/2013 13.1 13.13 12.94 13.02 45222500 12.492/4/2013 12.94 13 12.86 12.88 32702200 12.352/5/2013 12.97 13.25 12.94 13.18 39116500 12.64

    2/6/2013 13.13 13.27 13.05 13.2 33520400 12.662/7/2013 13.26 13.31 13 13.07 33987500 12.532/8/2013 13.1 13.16 13.05 13.1 18613300 12.56

    2/11/2013 13.06 13.2 13.02 13.11 17688900 12.572/12/2013 13.12 13.2 13.05 13.08 26243300 12.542/13/2013 13.11 13.14 12.99 13.04 24503600 12.512/14/2013 13 13.17 12.96 13.11 33489000 12.572/15/2013 13.14 13.14 13.01 13.02 32418700 12.492/19/2013 13.04 13.09 12.9 12.99 31089900 12.462/20/2013 12.95 12.98 12.57 12.6 50381800 12.082/21/2013 12.51 12.51 12.3 12.39 43703700 11.88

    2/22/2013 12.44 12.5 12.31 12.48 23866400 11.972/25/2013 12.53 12.57 12.1 12.13 38627200 11.632/26/2013 12.24 12.35 12.11 12.34 29191400 11.832/27/2013 12.35 12.85 12.35 12.76 51569900 12.242/28/2013 12.78 12.87 12.6 12.61 37659400 12.09

    3/1/2013 12.56 12.75 12.38 12.61 38806100 12.093/4/2013 12.55 12.75 12.53 12.75 24337100 12.233/5/2013 12.87 12.98 12.79 12.87 26863200 12.343/6/2013 12.97 13 12.85 12.89 28953400 12.36

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    27/76

    3/7/2013 12.89 12.91 12.77 12.83 27702800 12.33/8/2013 12.94 12.99 12.81 12.98 24715100 12.45

    3/11/2013 12.97 13.4 12.9 13.34 48696900 12.793/12/2013 13.37 13.47 13.17 13.39 46047600 12.843/13/2013 13.37 13.45 13.35 13.4 26467800 12.853/14/2013 13.43 13.45 13.37 13.43 31653300 12.88

    3/15/2013 13.31 13.45 13.26 13.45 62961000 12.93/18/2013 13.16 13.39 12.8 13.26 36877600 12.723/19/2013 13.27 13.35 13.09 13.16 37639900 12.623/20/2013 13.22 13.4 13.18 13.36 32690500 12.813/21/2013 13.25 13.42 13.23 13.26 29740300 12.723/22/2013 13.24 13.31 13.2 13.26 21423900 12.723/25/2013 13.31 13.4 13.26 13.29 27238000 12.753/26/2013 13.35 13.37 13.24 13.31 24236700 12.773/27/2013 13.23 13.25 13.1 13.22 26240600 12.683/28/2013 13.24 13.24 13.1 13.15 25472400 12.61

    4/1/2013 13.01 13.15 12.9 12.9 32961500 12.374/2/2013 13 13.19 12.96 13.01 35189300 12.484/3/2013 13.05 13.05 12.59 12.68 45189000 12.164/4/2013 12.68 12.78 12.45 12.65 29803800 12.134/5/2013 12.43 12.5 12.15 12.44 42605700 11.934/8/2013 12.46 12.83 12.4 12.78 23884700 12.264/9/2013 12.85 12.96 12.75 12.8 29826000 12.28

    4/10/2013 12.87 13.13 12.82 13.12 31089600 12.584/11/2013 13.15 13.58 13.13 13.55 51493300 134/12/2013 13.43 13.55 13.26 13.53 37955000 12.984/15/2013 13.36 13.46 12.91 12.95 55885900 12.42

    4/16/2013 13.17 13.24 13 13.12 36338200 12.584/17/2013 12.97 13.05 12.8 12.93 44583600 12.44/18/2013 12.94 12.98 12.65 12.75 34877900 12.234/19/2013 12.88 12.97 12.75 12.93 26971400 12.44/22/2013 12.97 13.08 12.8 13.06 26082200 12.534/23/2013 13.12 13.45 13.11 13.36 40082600 12.814/24/2013 13.48 13.54 13.12 13.33 46026300 12.784/25/2013 13.4 13.56 13.35 13.47 42016000 12.924/26/2013 13.52 13.76 13.45 13.67 43814900 13.114/29/2013 13.73 13.76 13.57 13.66 20659200 13.14/30/2013 13.66 13.74 13.52 13.71 24858800 13.15

    5/1/2013 13.64 13.78 13.35 13.38 39344800 12.935/2/2013 13.54 13.55 13.38 13.41 33982900 12.965/3/2013 13.58 13.83 13.57 13.83 45933600 13.365/6/2013 13.86 14.15 13.83 14.09 53821400 13.615/7/2013 14.2 14.25 14.09 14.19 42070400 13.715/8/2013 14.15 14.24 14.1 14.21 33334600 13.735/9/2013 14.19 14.26 14.16 14.2 30575000 13.72

    5/10/2013 14.21 14.23 14.02 14.11 30885100 13.635/13/2013 14.1 14.12 13.92 14.01 22758500 13.54

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    28/76

    5/14/2013 14 14.3 13.98 14.27 32390700 13.795/15/2013 14.28 14.77 14.27 14.67 56875000 14.175/16/2013 14.77 14.85 14.6 14.64 40924300 14.145/17/2013 14.79 15.15 14.75 15.08 59729800 14.575/20/2013 15.01 15.23 15 15.05 34580000 14.545/21/2013 15.07 15.22 14.75 14.95 61840300 14.44

    5/22/2013 15.08 15.32 14.86 14.97 67147900 14.465/23/2013 14.5 14.94 14.37 14.81 49128700 14.315/24/2013 14.71 14.88 14.66 14.79 25287100 14.295/28/2013 15.22 15.35 15.1 15.28 59250500 14.765/29/2013 15.27 15.72 15.24 15.63 65167400 15.15/30/2013 15.76 16.02 15.74 15.9 61805000 15.365/31/2013 15.88 16.04 15.68 15.68 52117500 15.15

    6/3/2013 15.93 16.08 15.51 15.89 59017900 15.356/4/2013 15.98 16.09 15.63 15.78 50273400 15.256/5/2013 15.7 15.71 15.18 15.25 64862400 14.736/6/2013 15.25 15.48 15.06 15.44 54819200 14.926/7/2013 15.58 15.76 15.46 15.73 37099500 15.2

    6/10/2013 15.86 15.9 15.6 15.71 29589300 15.186/11/2013 15.52 15.68 15.4 15.51 35360600 14.986/12/2013 15.63 15.71 15.31 15.37 36207400 14.856/13/2013 15.31 15.6 15.18 15.58 34327500 15.056/14/2013 15.52 15.57 15.35 15.37 27186000 14.856/17/2013 15.53 15.72 15.44 15.55 31340000 15.026/18/2013 15.54 15.71 15.44 15.65 25950200 15.126/19/2013 15.6 15.62 15.31 15.32 35997500 14.86/20/2013 15.19 15.28 14.75 14.82 57313900 14.32

    6/21/2013 15.02 15.06 14.59 15 48218100 14.496/24/2013 14.67 14.83 14.3 14.67 58598000 14.176/25/2013 14.85 15 14.84 14.97 34031900 14.466/26/2013 15.16 15.31 15.1 15.29 39595100 14.776/27/2013 15.43 15.7 15.39 15.65 35859600 15.126/28/2013 15.56 15.65 15.44 15.47 45034700 14.95

    7/1/2013 15.61 15.79 15.56 15.74 36012200 15.217/2/2013 15.76 16.21 15.69 16.18 70275900 15.637/3/2013 16.15 16.45 16.14 16.43 38114000 15.877/5/2013 16.53 16.74 16.48 16.7 44728400 16.137/8/2013 16.85 16.93 16.75 16.81 42019600 16.24

    7/9/2013 16.86 16.94 16.72 16.84 33762200 16.277/10/2013 16.76 16.88 16.65 16.72 38162900 16.157/11/2013 16.95 16.99 16.86 16.98 34601800 16.47/12/2013 16.98 17.11 16.97 17.11 27297500 16.537/15/2013 17.24 17.29 17.1 17.12 26663500 16.547/16/2013 16.95 16.95 16.41 16.6 63282600 16.047/17/2013 16.64 16.83 16.62 16.78 27888100 16.217/18/2013 16.82 16.98 16.78 16.93 24606400 16.367/19/2013 16.89 16.89 16.65 16.76 29592500 16.19

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    29/76

    7/22/2013 16.87 17.04 16.83 17.04 28745600 16.467/23/2013 17.16 17.17 16.82 16.94 35016900 16.377/24/2013 17.48 17.68 17.25 17.37 78608500 16.787/25/2013 17.26 17.27 16.88 16.96 51510200 16.397/26/2013 16.92 17.13 16.9 17.02 30356000 16.447/29/2013 17.08 17.19 17.05 17.08 27823400 16.5

    7/30/2013 17.19 17.25 17.06 17.08 25879200 16.57/31/2013 17.09 17.15 16.84 16.88 42156300 16.48/1/2013 17.04 17.21 16.95 17.19 39519600 16.718/2/2013 17.15 17.5 17.12 17.5 32233600 17.018/5/2013 17.44 17.5 17.11 17.19 53813000 16.718/6/2013 17.18 17.23 17 17.03 29014000 16.558/7/2013 16.95 16.96 16.72 16.77 33058100 16.38/8/2013 16.94 17.03 16.87 16.98 26626200 16.58/9/2013 16.95 17.11 16.94 17.02 25625300 16.54

    8/12/2013 16.91 17.14 16.89 17.07 23170600 16.598/13/2013 17.15 17.21 16.96 17.06 22372000 16.588/14/2013 17.04 17.06 16.85 16.89 29255700 16.418/15/2013 16.71 16.73 16.22 16.43 55905300 15.978/16/2013 16.45 16.6 16.22 16.3 30477300 15.848/19/2013 16.29 16.31 16.11 16.12 28013600 15.678/20/2013 16.06 16.36 15.82 16.31 42599300 15.858/21/2013 16.31 16.42 16.11 16.25 34926600 15.798/22/2013 16.29 16.49 16.25 16.41 16464700 15.958/23/2013 16.47 16.52 16.35 16.45 21547100 15.998/26/2013 16.44 16.62 16.38 16.41 24792600 15.958/27/2013 16.16 16.18 15.85 15.88 44005000 15.43

    8/28/2013 15.86 16.15 15.71 16.02 37027600 15.578/29/2013 16.21 16.66 16.15 16.5 47714900 16.038/30/2013 16.58 16.59 16.12 16.19 40290600 15.73

    9/3/2013 16.42 16.54 16.21 16.34 33457700 15.889/4/2013 16.38 17.02 16.37 16.91 69533900 16.439/5/2013 17.1 17.35 17.03 17.3 55979000 16.819/6/2013 17.33 17.34 16.82 17 61718600 16.529/9/2013 17.11 17.41 17.1 17.31 38517000 16.82

    9/10/2013 17.49 17.68 17.37 17.55 45850700 17.069/11/2013 17.5 17.58 17.39 17.54 32902300 17.059/12/2013 17.55 17.56 17.31 17.39 26855400 16.9

    9/13/2013 17.45 17.49 17.28 17.35 21572800 16.869/16/2013 17.53 17.59 17.3 17.35 26976600 16.869/17/2013 17.35 17.45 17.3 17.44 23176300 16.959/18/2013 17.36 17.77 17.34 17.63 45114100 17.139/19/2013 17.75 17.77 17.51 17.66 30748200 17.169/20/2013 17.71 17.71 17.3 17.39 47887900 16.99/23/2013 17.27 17.35 16.98 17.2 42733400 16.729/24/2013 17.23 17.4 17.08 17.26 33787600 16.779/25/2013 17.25 17.4 17.16 17.19 31630300 16.71

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    30/76

    9/26/2013 17.26 17.38 17.12 17.27 32360900 16.789/27/2013 17.17 17.2 17 17.05 34022600 16.579/30/2013 16.77 17.01 16.69 16.87 36511300 16.3910/1/2013 16.93 17.34 16.92 17.19 41817000 16.7110/2/2013 17.09 17.22 16.95 17.21 29527300 16.7210/3/2013 17.11 17.17 16.76 16.95 36628800 16.47

    10/4/2013 16.97 17.14 16.94 17.09 24991600 16.6110/7/2013 16.86 16.95 16.81 16.81 30339600 16.3410/8/2013 16.83 16.85 16.45 16.5 45491300 16.0310/9/2013 16.51 16.74 16.35 16.62 50838200 16.15

    10/10/2013 16.87 17 16.83 16.93 46955700 16.4510/11/2013 17.02 17.12 16.88 17.11 30814200 16.6310/14/2013 16.93 17.25 16.92 17.18 31229600 16.710/15/2013 17.18 17.21 16.95 16.97 39294100 16.4910/16/2013 17.08 17.29 17.03 17.29 33098300 16.810/17/2013 17.24 17.49 17.24 17.46 26889400 16.9710/18/2013 17.52 17.55 17.43 17.53 23022100 17.0410/21/2013 17.59 17.6 17.41 17.5 22159700 17.0110/22/2013 17.55 17.68 17.44 17.6 30226500 17.110/23/2013 17.66 17.71 17.39 17.52 45496200 17.0310/24/2013 18.01 18.02 17.64 17.76 71402500 17.2610/25/2013 17.84 17.85 17.42 17.6 47515700 17.110/28/2013 17.66 17.72 17.52 17.57 37323000 17.0710/29/2013 17.57 17.62 17.41 17.61 36931500 17.1110/30/2013 17.62 17.64 17.25 17.34 39898500 16.9510/31/2013 17.29 17.33 17.1 17.11 38742700 16.72

    11/1/2013 17.24 17.24 16.76 16.89 52493000 16.51

    11/4/2013 16.97 17.01 16.78 17 33974700 16.6111/5/2013 16.89 17.14 16.83 17.09 43517500 16.711/6/2013 17.16 17.2 16.85 16.91 37052400 16.5311/7/2013 16.91 16.92 16.53 16.55 47526900 16.1811/8/2013 16.66 16.87 16.61 16.85 38987300 16.47

    11/11/2013 16.87 17.14 16.73 16.89 29561200 16.5111/12/2013 16.8 16.85 16.66 16.72 31432300 16.3411/13/2013 16.66 17.1 16.64 17.1 39160000 16.7111/14/2013 17.12 17.2 17.01 17.09 35559900 16.711/15/2013 17.13 17.15 17 17.07 33100600 16.6811/18/2013 17.07 17.18 16.92 16.98 31231300 16.6

    11/19/2013 16.99 17.03 16.82 16.87 26841800 16.4911/20/2013 16.89 17.08 16.84 16.92 31077800 16.5411/21/2013 17.01 17.15 16.98 17.09 33042300 16.711/22/2013 17.12 17.14 17 17.01 29789000 16.6211/25/2013 17.1 17.14 16.93 16.94 25125300 16.5611/26/2013 17.05 17.05 16.85 16.87 26440600 16.4911/27/2013 16.86 17.09 16.81 17.03 31559700 16.6411/29/2013 17.06 17.18 17.04 17.08 14918800 16.69

    12/2/2013 17.12 17.2 17.03 17.06 27749600 16.67

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    31/76

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    32/76

    Date Open High Low Close Volume Adj Close1/4/2010 30.62 31.1 30.59 30.95 38409100 27.311/5/2010 30.85 31.1 30.64 30.96 49749600 27.321/6/2010 30.88 31.08 30.52 30.77 58182400 27.151/7/2010 30.63 30.7 30.19 30.45 50559700 26.871/8/2010 30.28 30.88 30.24 30.66 51197400 27.05

    1/11/2010 30.71 30.76 30.12 30.27 68754700 26.711/12/2010 30.15 30.4 29.91 30.07 65912100 26.531/13/2010 30.26 30.52 30.01 30.35 51863500 26.781/14/2010 30.31 31.1 30.26 30.96 63228100 27.321/15/2010 31.08 31.24 30.71 30.86 79913200 27.231/19/2010 30.75 31.24 30.68 31.1 46575700 27.441/20/2010 30.81 30.94 30.31 30.59 54849500 26.991/21/2010 30.61 30.72 30 30.01 73086700 26.481/22/2010 30 30.2 28.84 28.96 102004600 25.551/25/2010 29.24 29.66 29.1 29.32 63373000 25.871/26/2010 29.2 29.85 29.09 29.5 66639900 26.031/27/2010 29.35 29.82 29.02 29.67 63949500 26.181/28/2010 29.84 29.87 28.89 29.16 117513700 25.731/29/2010 29.9 29.92 27.66 28.18 193888500 24.86

    2/1/2010 28.39 28.48 27.92 28.41 85931100 25.072/2/2010 28.37 28.5 28.14 28.46 54413700 25.112/3/2010 28.26 28.79 28.12 28.63 61397900 25.262/4/2010 28.38 28.5 27.81 27.84 77850000 24.562/5/2010 28 28.28 27.57 28.02 80960100 24.722/8/2010 28.01 28.08 27.57 27.72 52820600 24.462/9/2010 27.97 28.34 27.75 28.01 59195800 24.71

    2/10/2010 28.03 28.24 27.84 27.99 48591300 24.692/11/2010 27.93 28.4 27.7 28.12 65993700 24.812/12/2010 27.81 28.06 27.58 27.93 81117200 24.642/16/2010 28.13 28.37 28.02 28.35 51935600 25.132/17/2010 28.53 28.65 28.36 28.59 45882900 25.342/18/2010 28.59 29.03 28.51 28.97 42856500 25.682/19/2010 28.79 28.92 28.69 28.77 44451800 25.52/22/2010 28.84 28.94 28.65 28.73 36707100 25.472/23/2010 28.68 28.83 28.09 28.33 52266200 25.112/24/2010 28.52 28.79 28.38 28.63 43165900 25.382/25/2010 28.27 28.65 28.02 28.6 48735300 25.35

    2/26/2010 28.65 28.85 28.51 28.67 40370600 25.413/1/2010 28.77 29.05 28.53 29.02 43805400 25.723/2/2010 29.08 29.3 28.24 28.46 93123900 25.233/3/2010 28.51 28.61 28.35 28.46 48442100 25.233/4/2010 28.46 28.65 28.27 28.63 42890600 25.383/5/2010 28.66 28.68 28.42 28.59 56001800 25.343/8/2010 28.52 28.93 28.5 28.63 39414500 25.383/9/2010 28.56 29.11 28.55 28.8 50271600 25.53

    3/10/2010 28.86 29.11 28.8 28.97 44891400 25.68

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    33/76

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    34/76

    5/18/2010 28.87 29 28.4 28.6 52690600 25.475/19/2010 28.52 28.69 27.79 28.24 61746700 25.145/20/2010 27.65 27.84 27.04 27.11 87991100 24.145/21/2010 26.63 27.11 26.44 26.84 117596300 23.95/24/2010 26.85 26.86 26.26 26.27 73711700 23.395/25/2010 25.65 26.33 25.38 26.07 98373600 23.21

    5/26/2010 26.23 26.61 24.56 25.01 176684100 22.275/27/2010 25.73 26.36 25.73 26 136433600 23.155/28/2010 25.84 26.12 25.66 25.8 67496900 22.97

    6/1/2010 25.53 26.31 25.52 25.89 76152400 23.056/2/2010 26.06 26.48 25.73 26.46 65718800 23.566/3/2010 26.55 26.93 26.41 26.86 67837000 23.926/4/2010 26.1 26.57 25.62 25.79 89832200 22.966/7/2010 25.82 25.83 25.24 25.29 80456200 22.526/8/2010 25.25 25.26 24.65 25.11 87355000 22.366/9/2010 25.22 25.52 24.75 24.79 87794000 22.07

    6/10/2010 25.13 25.15 24.78 25 78930900 22.266/11/2010 25.04 25.72 24.77 25.66 68057700 22.856/14/2010 25.86 25.96 25.47 25.5 50972400 22.716/15/2010 25.75 26.65 25.74 26.58 81641500 23.676/16/2010 26.47 26.58 26.23 26.32 48698000 23.446/17/2010 26.56 26.67 26.04 26.37 47995500 23.486/18/2010 26.37 26.53 26.17 26.44 52075600 23.546/21/2010 26.78 26.89 25.89 25.95 54625300 23.116/22/2010 26.16 26.45 25.76 25.77 55985400 22.956/23/2010 25.78 25.78 25.22 25.31 61466200 22.546/24/2010 25.46 25.72 24.93 25 85243400 22.26

    6/25/2010 25.05 25.11 24.31 24.53 156256700 21.846/28/2010 24.51 24.61 24.12 24.31 73784800 21.656/29/2010 24.13 24.2 23.11 23.31 119882100 20.766/30/2010 23.3 23.68 22.95 23.01 81050500 20.49

    7/1/2010 23.09 23.32 22.73 23.16 92239400 20.627/2/2010 23.36 23.48 23.05 23.27 62485100 20.727/6/2010 23.7 24.09 23.58 23.82 73592000 21.217/7/2010 23.82 24.32 23.61 24.3 79965300 21.647/8/2010 24.6 24.62 23.97 24.41 50758100 21.737/9/2010 24.33 24.41 24.15 24.27 53806100 21.61

    7/12/2010 24.43 24.89 24.42 24.83 49854200 22.11

    7/13/2010 25.14 25.3 24.9 25.13 61928700 22.387/14/2010 25.5 25.61 25.12 25.44 72808100 22.657/15/2010 25.5 25.59 24.98 25.51 56934700 22.717/16/2010 25.51 25.64 24.88 24.89 65064800 22.167/19/2010 24.96 25.3 24.91 25.23 38181800 22.467/20/2010 24.86 25.48 24.7 25.48 45530700 22.697/21/2010 25.6 25.65 24.98 25.12 73297300 22.377/22/2010 25.51 25.99 25.47 25.84 73016400 23.017/23/2010 25.84 26.02 25.25 25.81 108520100 22.98

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    35/76

    7/26/2010 25.86 26.2 25.8 26.1 67249900 23.247/27/2010 26.14 26.24 25.96 26.16 60672100 23.297/28/2010 26.07 26.19 25.83 25.95 69704800 23.117/29/2010 26.13 26.41 25.6 26.03 69446200 23.187/30/2010 25.75 25.84 25.35 25.81 83534800 22.98

    8/2/2010 25.99 26.38 25.75 26.33 55044600 23.44

    8/3/2010 26.2 26.35 25.97 26.16 56877700 23.298/4/2010 26.15 26.24 25.44 25.73 78531900 22.918/5/2010 25.49 25.58 25.21 25.37 64922100 22.598/6/2010 25.18 25.56 25.02 25.55 55982100 22.758/9/2010 25.55 25.73 25.37 25.61 57096500 22.8

    8/10/2010 25.33 25.34 24.88 25.07 87257700 22.328/11/2010 24.68 24.9 24.56 24.86 76746900 22.148/12/2010 24.42 24.68 24.36 24.49 70240500 21.818/13/2010 24.35 24.67 24.24 24.4 45263500 21.738/16/2010 24.36 24.61 24.3 24.5 40909700 21.818/17/2010 24.71 24.96 24.6 24.71 52912600 22.128/18/2010 24.68 24.95 24.41 24.82 46818900 22.228/19/2010 24.62 24.74 24.21 24.44 54064600 21.888/20/2010 24.31 24.4 24.2 24.23 49560100 21.698/23/2010 24.44 24.64 24.24 24.28 51643000 21.738/24/2010 24.09 24.35 24 24.04 66522500 21.528/25/2010 24 24.22 23.87 24.1 47404800 21.578/26/2010 24.09 24.19 23.79 23.82 49105300 21.328/27/2010 23.88 24.02 23.51 23.93 60939400 21.428/30/2010 23.74 23.82 23.6 23.64 45453100 21.168/31/2010 23.6 23.73 23.32 23.47 66074600 21.01

    9/1/2010 23.67 23.95 23.54 23.9 65235900 21.399/2/2010 23.88 23.95 23.71 23.94 48837100 21.439/3/2010 24.24 24.45 24.2 24.29 64189100 21.749/7/2010 24.1 24.3 23.92 23.96 51928700 21.459/8/2010 24.07 24.2 23.74 23.93 65512400 21.429/9/2010 24.19 24.21 23.99 24.01 46028900 21.49

    9/10/2010 23.98 24.03 23.79 23.85 58284300 21.359/13/2010 24.2 25.29 24.09 25.11 114680400 22.489/14/2010 25.04 25.35 24.89 25.03 87160400 22.419/15/2010 25.1 25.22 24.92 25.12 56201900 22.499/16/2010 25.06 25.37 25.05 25.33 44548300 22.67

    9/17/2010 25.4 25.53 25.08 25.22 70341600 22.589/20/2010 25.28 25.52 25.11 25.43 49838700 22.769/21/2010 25.42 25.42 25.08 25.15 52675700 22.519/22/2010 24.89 24.97 24.36 24.61 94299400 22.039/23/2010 24.51 24.59 24.36 24.43 46201800 21.879/24/2010 24.64 24.8 24.58 24.78 51948800 22.189/27/2010 24.85 24.99 24.59 24.73 43603300 22.149/28/2010 24.8 24.9 24.35 24.68 56041200 22.099/29/2010 24.63 24.66 24.4 24.5 44318900 21.93

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    36/76

    9/30/2010 24.61 24.83 24.36 24.49 61262700 21.9210/1/2010 24.77 24.82 24.3 24.38 62672300 21.8210/4/2010 23.96 23.99 23.78 23.91 98143400 21.410/5/2010 24.06 24.45 23.91 24.35 78152900 21.810/6/2010 24.32 24.54 24.13 24.43 50489700 21.8710/7/2010 24.62 24.75 24.28 24.53 50096100 21.96

    10/8/2010 24.62 24.65 24.37 24.57 41327800 21.9910/11/2010 24.74 24.74 24.5 24.59 27587800 22.0110/12/2010 24.65 24.93 24.43 24.83 50141500 22.2310/13/2010 25.02 25.54 24.89 25.34 75336500 22.6810/14/2010 25.29 25.34 25 25.23 51949100 22.5810/15/2010 25.36 25.55 25.23 25.54 68954800 22.8610/18/2010 25.59 25.95 25.45 25.82 48330500 23.1110/19/2010 25.27 25.37 24.95 25.1 66150900 22.4710/20/2010 25.26 25.4 25.1 25.31 56283600 22.6610/21/2010 25.4 25.54 25.05 25.42 50032400 22.7510/22/2010 25.52 25.54 25.27 25.38 25837900 22.7210/25/2010 25.24 25.35 25.17 25.19 50912400 22.5510/26/2010 25.12 25.97 25.06 25.9 69304200 23.1810/27/2010 25.79 26.11 25.62 26.05 64805500 23.3210/28/2010 26.21 26.38 25.92 26.28 80730300 23.5210/29/2010 27.15 27.2 26.48 26.67 114193200 23.87

    11/1/2010 26.88 27.22 26.7 26.95 61912100 24.1211/2/2010 27.06 27.42 27.02 27.39 54402100 24.5211/3/2010 27.46 27.49 26.96 27.03 110255300 24.211/4/2010 27.41 27.43 27.01 27.14 93599300 24.2911/5/2010 27.17 27.19 26.53 26.85 110953700 24.03

    11/8/2010 26.68 28.87 26.58 26.81 71670800 2411/9/2010 26.81 27.11 26.71 26.95 58538600 24.1211/10/2010 27.01 27.08 26.81 26.94 52277300 24.1211/11/2010 26.68 26.72 26.28 26.68 62073100 23.8811/12/2010 26.47 26.52 26.1 26.27 64962200 23.5211/15/2010 26.33 26.5 26.17 26.2 51794600 23.4511/16/2010 26.04 26.04 25.65 25.81 65339200 23.2511/17/2010 25.9 25.91 25.55 25.57 58299700 23.0311/18/2010 25.71 26.08 25.61 25.84 59514000 23.2711/19/2010 25.8 25.83 25.6 25.69 52423200 23.1411/22/2010 25.65 25.74 25.44 25.73 53350500 23.17

    11/23/2010 25.57 25.6 25.09 25.12 69742500 22.6211/24/2010 25.2 25.46 25.16 25.37 56825900 22.8511/26/2010 25.21 25.41 25.17 25.25 21356500 22.7411/29/2010 25.19 25.42 24.93 25.31 56603600 22.811/30/2010 25.05 25.47 25 25.26 75282100 22.75

    12/1/2010 25.57 26.25 25.56 26.04 74123500 23.4512/2/2010 26.24 26.98 26.2 26.89 91759200 24.2212/3/2010 26.81 27.06 26.78 27.02 52622000 24.3412/6/2010 26.93 26.98 26.76 26.84 36264200 24.17

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    37/76

    12/7/2010 27.08 27.13 26.85 26.87 57860500 24.212/8/2010 26.83 27.24 26.8 27.23 41666800 24.5212/9/2010 27.28 27.34 27.01 27.08 47148300 24.39

    12/10/2010 27.19 27.4 27.11 27.34 37625800 24.6212/13/2010 27.27 27.45 27.17 27.25 47943900 24.5412/14/2010 27.31 27.75 27.26 27.62 64070500 24.88

    12/15/2010 27.53 27.99 27.53 27.85 69634200 25.0812/16/2010 27.76 27.99 27.66 27.99 57680200 25.2112/17/2010 27.92 28.09 27.75 27.9 87456500 25.1312/20/2010 27.95 27.99 27.68 27.81 52811000 25.0512/21/2010 27.85 28.14 27.76 28.07 38153000 25.2812/22/2010 28.01 28.4 27.98 28.19 42252300 25.3912/23/2010 27.97 28.32 27.96 28.3 24902500 25.4912/27/2010 28.12 28.2 27.88 28.07 21652800 25.2812/28/2010 27.97 28.17 27.96 28.01 23042200 25.2312/29/2010 27.94 28.12 27.88 27.97 19502500 25.1912/30/2010 27.92 28 27.78 27.85 20786100 25.0812/31/2010 27.8 27.92 27.63 27.91 24752000 25.14

    1/3/2011 28.05 28.18 27.92 27.98 53443800 25.21/4/2011 27.94 28.17 27.85 28.09 54405600 25.31/5/2011 27.9 28.01 27.77 28 58998700 25.221/6/2011 28.04 28.85 27.86 28.82 88026300 25.961/7/2011 28.64 28.74 28.25 28.6 73762000 25.76

    1/10/2011 28.26 28.4 28.04 28.22 57573600 25.421/11/2011 28.2 28.25 28.05 28.11 50298900 25.321/12/2011 28.12 28.59 28.07 28.55 52631100 25.711/13/2011 28.33 28.39 28.01 28.19 67077600 25.39

    1/14/2011 28.08 28.38 27.91 28.3 62688400 25.491/18/2011 28.16 28.74 28.14 28.66 53322700 25.811/19/2011 28.46 28.68 28.27 28.47 50005900 25.641/20/2011 28.5 28.55 28.13 28.35 58613600 25.531/21/2011 28.4 28.43 28.02 28.02 58080300 25.241/24/2011 28.02 28.56 27.99 28.38 52047800 25.561/25/2011 28.14 28.45 28.12 28.45 42436600 25.621/26/2011 28.51 28.99 28.5 28.78 74628800 25.921/27/2011 28.75 29.46 28.49 28.87 146938600 261/28/2011 28.9 28.93 27.45 27.75 141249400 24.991/31/2011 27.77 27.9 27.42 27.73 65029000 24.97

    2/1/2011 27.8 28.06 27.61 27.99 62810700 25.212/2/2011 27.93 28.11 27.88 27.94 45824000 25.162/3/2011 27.97 27.97 27.54 27.65 60340100 24.92/4/2011 27.7 27.84 27.51 27.77 40412200 25.012/7/2011 27.8 28.34 27.79 28.2 68980900 25.42/8/2011 28.1 28.34 28.05 28.28 34904200 25.472/9/2011 28.19 28.26 27.91 27.97 52905100 25.19

    2/10/2011 27.93 27.94 27.29 27.5 76672400 24.772/11/2011 27.76 27.81 27.07 27.25 83939700 24.54

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    38/76

    2/14/2011 27.21 27.27 26.95 27.23 56766200 24.522/15/2011 27.04 27.33 26.95 26.96 44116500 24.422/16/2011 27.05 27.07 26.6 27.02 70817900 24.482/17/2011 26.97 27.37 26.91 27.21 57207300 24.652/18/2011 27.13 27.21 26.99 27.06 68667800 24.522/22/2011 26.78 27.1 26.52 26.59 60889000 24.09

    2/23/2011 26.53 26.86 26.43 26.59 60234100 24.092/24/2011 26.64 27.06 26.5 26.77 64494200 24.252/25/2011 26.91 26.95 26.5 26.55 53006300 24.052/28/2011 26.69 26.86 26.51 26.58 51379900 24.08

    3/1/2011 26.6 26.78 26.15 26.16 60055000 23.73/2/2011 26.11 26.37 26.04 26.08 48658200 23.633/3/2011 26.26 26.4 26.18 26.2 68271500 23.743/4/2011 26.22 26.24 25.8 25.95 70437200 23.513/7/2011 26.13 26.27 25.55 25.72 64980400 23.33/8/2011 25.77 26.02 25.65 25.91 50549800 23.473/9/2011 25.81 25.98 25.66 25.89 39789100 23.46

    3/10/2011 25.62 25.71 25.35 25.41 66549500 23.023/11/2011 25.41 25.85 25.36 25.68 49905800 23.273/14/2011 25.49 25.76 25.35 25.69 54473400 23.273/15/2011 25.08 25.47 25 25.39 76067300 233/16/2011 25.22 25.28 24.68 24.79 100725400 22.463/17/2011 25.06 25.22 24.75 24.78 62497000 22.453/18/2011 25.06 25.18 24.8 24.8 85486700 22.473/21/2011 25.18 25.58 25.15 25.33 46878100 22.953/22/2011 25.3 25.46 25.23 25.3 30895600 22.923/23/2011 25.23 25.61 25.18 25.54 43969000 23.14

    3/24/2011 25.6 25.87 25.5 25.81 38696700 23.383/25/2011 25.93 25.95 25.59 25.62 57029800 23.213/28/2011 25.66 25.72 25.38 25.41 48973200 23.023/29/2011 25.34 25.52 25.3 25.49 40763500 23.093/30/2011 25.6 25.72 25.5 25.61 41999300 23.23/31/2011 25.6 25.68 25.34 25.39 63233700 23

    4/1/2011 25.53 25.53 25.31 25.48 63114200 23.084/4/2011 25.45 25.66 25.41 25.55 35433700 23.154/5/2011 25.82 26.18 25.74 25.78 73651100 23.364/6/2011 25.98 26.31 25.86 26.15 65581400 23.694/7/2011 26.19 26.26 25.97 26.2 46134700 23.74

    4/8/2011 26.17 26.28 25.96 26.07 39887600 23.624/11/2011 26.19 26.25 25.8 25.98 34286300 23.544/12/2011 25.83 25.85 25.55 25.64 36920400 23.234/13/2011 25.65 25.87 25.56 25.63 38144700 23.224/14/2011 25.42 25.44 25.09 25.42 55239900 23.034/15/2011 25.46 25.56 25.18 25.37 65080400 22.984/18/2011 25.1 25.28 24.72 25.08 58045100 22.724/19/2011 25 25.17 24.87 25.15 38892400 22.794/20/2011 25.54 26 25.51 25.76 61608600 23.34

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    39/76

    4/21/2011 25.79 25.89 25.36 25.52 46892300 23.124/25/2011 25.56 25.62 25.34 25.61 33525100 23.24/26/2011 25.74 26.44 25.67 26.19 69200000 23.734/27/2011 26.3 26.39 26.13 26.38 52689000 23.94/28/2011 26.46 26.87 26.4 26.71 80200000 24.24/29/2011 26.55 26.64 25.36 25.92 319317900 23.48

    5/2/2011 25.94 26 25.48 25.66 89825600 23.255/3/2011 25.6 25.85 25.49 25.81 71892900 23.385/4/2011 25.85 26.25 25.79 26.06 73292300 23.615/5/2011 26.05 26.08 25.68 25.79 55600000 23.365/6/2011 26.07 26.22 25.75 25.87 55993000 23.445/9/2011 25.8 25.96 25.67 25.83 38696400 23.4

    5/10/2011 25.38 25.85 25.25 25.67 120798700 23.265/11/2011 25.65 25.66 25.21 25.36 78600000 22.985/12/2011 25.35 25.39 25.1 25.32 77400000 22.945/13/2011 25.28 25.32 24.95 25.03 66812300 22.685/16/2011 24.96 25.07 24.5 24.57 91350900 22.265/17/2011 24.4 24.7 24.27 24.52 82882100 22.365/18/2011 24.53 24.74 24.25 24.69 53931100 22.515/19/2011 24.85 24.88 24.5 24.72 37783600 22.545/20/2011 24.72 24.87 24.44 24.49 45451500 22.335/23/2011 24.21 24.25 24.03 24.17 52692500 22.045/24/2011 24.2 24.29 24.04 24.15 47691800 22.025/25/2011 24.17 24.31 24.16 24.19 34904200 22.065/26/2011 24.35 25.03 24.32 24.67 78016600 22.55/27/2011 24.68 24.9 24.65 24.76 50251000 22.585/31/2011 24.96 25.06 24.7 25.01 60196300 22.81

    6/1/2011 24.99 25.1 24.37 24.43 74033500 22.286/2/2011 24.49 24.65 24.18 24.22 51487800 22.096/3/2011 24.05 24.14 23.84 23.91 60697700 21.86/6/2011 23.89 24.25 23.77 24.01 54778700 21.896/7/2011 24.09 24.17 23.9 24.06 41112600 21.946/8/2011 23.9 24.02 23.86 23.94 42205000 21.836/9/2011 24.01 24.04 23.82 23.96 42878700 21.85

    6/10/2011 24.02 24.02 23.69 23.71 49327200 21.626/13/2011 23.79 24.19 23.7 24.04 47572500 21.926/14/2011 24.3 24.45 24.19 24.22 42894500 22.096/15/2011 24 24.01 23.67 23.74 49410200 21.65

    6/16/2011 23.75 24.1 23.65 24 57184100 21.896/17/2011 24.22 24.3 23.98 24.26 83320400 22.126/20/2011 24.17 24.66 24.16 24.47 54338400 22.316/21/2011 24.52 24.86 24.4 24.76 49708700 22.586/22/2011 24.6 24.81 24.59 24.65 44287300 22.486/23/2011 24.44 24.65 24.2 24.63 59470400 22.466/24/2011 24.51 24.54 24.19 24.3 101387200 22.166/27/2011 24.23 25.46 24.23 25.2 92044200 22.986/28/2011 25.3 25.92 25.16 25.8 81032100 23.53

  • 8/10/2019 FINANZAS CORPORATIVAS PRACTICA 1.xlsx

    40/76

    6/29/2011 25.71 25.71 25.36 25.62 66051000 23.366/30/2011 25.74 26 25.66 26 52535400 23.71

    7/1/2011 25.93 26.17 25.84 26.02 52906200 23.737/5/2011 26.1 26.15 25.9 26.03 37805300 23.747/6/2011 25.97 26.37 25.96 26.33 48744200 24.017/7/2011 26.49 26.88 26.36 26.77 51946500 24.41

    7/8/2011 26.54 26.98 26.51 26.92 58320700 24.557/11/2011 26.62 26.8 26.49 26.63 43999800 24.287/12/2011 26.55 26.79 26.34 26.54 47319300 24.27/13/2011 26.6 26.96 26.51 26.63 40861800 24.287/14/2011 26.62 27.01 26.36 26.47 46382300 24.147/15/2011 26.47 26.93 26.47 26.78 49132400 24.427/18/2011 26.63 26.9 26.26 26.59 44501900 24.257/19/2011 26.81 27.64 26.78 27.54 86730600 25.117/20/2011 27.28 27.35 26.98 27.06 49795400 24.687/21/2011 27.04 27.31 26.65 27.1 81737400 24.717/22/2011 26.86 27.55 26.68 27.53 76380600 25.17/25/2011 27.26 28.09 27.19 27.91 108482400 25.457/26/2011 27.82 28.15 27.78 28.08 74636500 25.617/27/2011 27.88 27.99 27.2 27.33 71488700 24.927/28/2011 27.29 28.07 27.21 27.72 83761400 25.287/29/2011 27.52 27.71 27.26 27.4 104394800 24.99

    8/1/2011 27.51 27.69 26.75 27.27 61838400 24.878/2/2011 26.98 27.45 26.76 26.8 63883100 24.448/3/2011 26.83 27 26.48 26.92 64581200 24.558/4/2011 26.53 26.87 25.93 25.94 92949500 23.658/5/2011 25.97 26.1 25.23 25.68 112071700 23.42

    8/8/2011 25.02 25.6 24.39 24.48 134257200 22.328/9/2011 24.71 25.62 24.03 25.58 126268900 23.338/10/2011 24.95 25.09 24.1 24.2 127819900 22.078/11/2011 24.5 25.38 24.4 25.19 90690100 22.978/12/2011 25.13 25.34 24.65 25.1 64787100 22.898/15/2011 25.24 25.58 25.15 25.51 56529400 23.268/16/2011 25.22 25.59 25.05 25.35 54251500 23.268/17/2011 25.25 25.7 24.93 25.25 50923700 23.178/18/2011 24.57 25.09 24.03 24.67 105714200 22.648/19/2011 24.41 24.62 23.91 24.05 77397900 22.078/22/2011 24.42 24.49 23.79 23.98 54721000 22.01

    8/23/2011 24.03 24.75 24.03 24.72 59670600 22.688/24/2011 24.65 24.93 24.42 24.9 45329700 22.858/25/2011 25.08 25.16 24.5 24.57 48192000 22.558/26/2011 24.51 25.34 24.42 25.25 71957000 23.178/29/2011 25.53 25.86 25.37 25.84 38863200 23.718/30/2011 25.73 2