Need help :Complete the following tables (Data provided below)-

Here again is the formula for WAGE. For simplieiw the term for preferred stock has been removed: E _ D I E + E + D E + D WAGE: EDK-ic} 1. Go to hggthatswaeeeom and enter the ticker symbol for the stool: you selected and click on the tab entitled "Calculate WAGE." 2. Complete the following tables: Name ofCompan''Stook CHEVRUN CORPORATION Ticker Symbol From the hitngfthatswaeooomf results for your company: WAGE Cost of debt, in CAPM Components Historical market Il'l, m Assumed 11% Assume-'1 3% 3. Using data in the table conrm the aeemaey ufthe site's WAGE calculaen: - - E Weight of Eqmty m Weighted Average . Ee Cost ef Equity Weight of Debt i e + n Pie-Tax Weighted . in Average Ceet of Debt AHTax Weighted . - - Cast of Debt Weightai Average eet of Capital You have searched for CVX - Chevron Corporation Their WACC = 6.90% Because Component Value Description 3 re : _ 0. 54s Btimated Cost of Debt [lnteresthebt] _ 30. 3896 Btimated Tax Rate [TaxesfPretax Income} Percentage of Financing from Debt [DebUEnterpn'se Value] Cost of Equity, per the CAPM Model: rs = ['1' + BUM - rt} 610996 Percentage of Financing from Equity.I [Market CapJEnterpr'ise Value} The figures above were calculated using the following averages from the Income Statement and Balance Sheet: in 5M: 1233132016 12I31!2015 12f31f2014 3 Yr. Av_ ShorUCurrent Long Term Debt $10,840,000 $4,921,000 $3,?90,000 $5,519,000 $35,286,000 $33,622,000 $24,023,000 S30,9?8,65? The Weighted Average Cost of Capital (WAGE) is one of the most important measures in corporate finance. According to Wikipedia ' ' The weighted average cost of capital (WACC) is the rate that a company is expected to pay on average to all its security holder; , to finance its assets. Balance Sheet Min-mars hmsusar-ds Period Ending 12I'31I'2El16 12I'S1QEI15 12I'31.I"e'.|2|14 Current Assets Cashnd ISash EqLiuaHis BBBBJIIDD 11.E|22.EIDD 12.?BEJIIDB ShurtTerrn Imam-ems 13ml! Billlillli 122nm NetFJenei-uatls 14.E|92.EIDD 12.EEEI.EIDD 1E.?3Ei.|IIDB Inventor; 5.11 ELEIIII BBB-till]! B.5E|5.EIIJB mature-11.515535 3.1El?.IIIIJD 3.!EIEI4JIIDD 5.?34JIIDB Total ELI-rent Assets 25.61am: 311.130.1111] 112.232.5011 Long Tenn Inueshnerns 32.?35JIIIJD 29.522JIIIJD ZBJEDJJDB HapeityP'lantaml Equipment 1SE.3I]5.IJEIJ 1EEI.E-5.EIIIJ 183.1?3Il-DB Sendai! 4.531JIIDD 4.EBB.EIDD 4.593JIIDB in'langa Assets _ _ _ Amumulaed Arm-thann _ _ _ Otira'issels - _ _ Deferred Long Termrssel Charga BEBBJIIDD B.155.E||]D BEBEIJIIDB Total Assets 353.113.1191] 251.543.1191] IEEHEEEI-D Current liabilities Ame-urns Payable 211.915.1101: 211511111011 213.133.1100 Shemcmmt Long Term Debt 1n.s4n.nnu 4.9211111: 3.?EIEIJIIIJD CHCurrent Lidilitia- - _ _ Total Cu'rent Liabilities 31.135.11.11 25.151111] 31.52am LengTemnem 3523511011 33112211011 21112111101: omerLiaewuee 1.2131101: 1.9351101: 3.1121111: Deferred Long Term Liability ChangE 39.03am 131131111011 15.15am mm Imens: 1.1531101: 111111101: 1.1331111: Total Liabilities 111.523.0011 111.521.1101 113.553.1101 Stockholders' Equity Misc. Shades Options "Hams- - - - Hedeerrhie F'refen'ed Sin-ck _ _ Preferred Stud: - - - Cowman 311ml: 1.832JIIDB 1.832.E||I3 1.832JIIDE Retained Earnings 1?3.IJ4B.IJDB 181.5?BJJDB 1E-t.EIB?.IJD Treasury SIB-ck 41.834JJDB 42.193JIIDB 42.?33J1D Gap Stlplus 1.595.|]|]t3 1.33|].|]|]t3 1E.E|4'1.|]D maa-{Minuet E1:,I1.Ii't'_.r 4.|]33.EIDB 4.531JIIII3 -5.|]EID.EID Tcltal Stockholiw Equity 115.55EiJJDB 152.?1EJJDB 155.|J23.|]D HetTangite Assets 145.5?5JEI-D 143.123.3011 15D.435.DDB