Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need these tables in Excel format with solved values so i can copy paste it on MS office B D E F G H

image text in transcribed

image text in transcribed

i need these tables in Excel format with solved values so i can copy paste it on MS office

B D E F G H Returns Year Centrica PIC Centrica PIC 1 2 2 > 3 4 4 2002 5 Market Portfolio, M 3940.4 National Express Group Plc Market Portfolio, M 5 2003 4476.9 6 6 2004 7 2005 4814.3 5618.8 16620.0 , LE SIE10/E9)-1 e 2006 8 2006 9 2007 o 2007 10 2008 11 11 2009 1 2010 12 2010 12 2014 13 2011 13040 14 2012 152045 15 2013 16 2017 16 2014 17 2018 17 2015 224.7 151.5 199.5 205.8 1235.5 327.6 292 1293 256.1 1260 268.1 12170 317.8 12916 1291.6 348.3 309.6 1292.5 204 223.5 133.1 136.1 National Express Group Plc 292.6 187.4 337.7 465.2 12512 1451.7 545.4 607.1 aco 168.8 202 207.1 1226 243.6 1216 1216.1 12065 206.5 lona 1290.9 254.9 301.9 337.8 366.2 393.9 IEC22 sea78 6620.8 6156 6456.9 MA 4434.2 5420 5412.9 500g 5899.9 5572.3 5897.8 157101 6749.1 6566.1 162423 6242.3 7142.8 7687.8 6728.1 7542.4 = (C5/C4)-1 = (C6/C5)-1 = (C7/C6)-1 =(C8/C7)-1 =(C9/C8)-1 =(C10/09)-1 LICHCL1 =(C11/C10)-1 =(C12/C11)-1 =(C13/C12)-1 Leto =(C14/C13)-1 Lic IC141,1 FC15/C14)-1 =(C16/015)-1 - C16/6151.1 =(C17/C16)-1 =(C18/017)-1 =(C19/C18)-1 =(C20/C19)-1 =(C21/C20-1 =(D5/D4)-1 =(D6/05)-1 =(07/D6)-1 =(D8/07)-1 =(D9/D8)-1 =(D10/09)-1 =(D11/D10)-1 =(D12/D11)-1 =(D13/D12)-1 LIDL121.1 =(D14/D13)-1 -1015101111 =(D15/D14)-1 -1016/01511 =(D16/D15)-1 FI017/0161.1 =(D17/D16)-1 =(D18/D17)-1 =(D19/D18)-1 =(D20/D19)-1 =(D21/D20-1 =(E5/E4)-1 = (E6/E5)-1 = (E7/E6)-1 =(E8/E7)-1 =(E9/E8)-1 FIE/E81-1 = |=(E11/E10)-1 = (E12/E11)-1 =(E13/E12)-1 ACTO =(E14/E13)-1 =(E15/E14)-1 LEASE 14.1 Licn66151 =(E16/E15)-1 =(E17/E16)-1 FIF 17/E161.1 = (E18/E17)-1 1=(E19/E18)-1 1=(E20/E19)-1 =(E21/E20)-1 ICECS1 18 2016 19 2017 20 2018 21 2019 22 23 24 25 26 27 28 29 Standard Deviation : Total risk: 0 Variance: o Covariance Beta: B = Cov (Re, Rm)/Var (Rm) Systematic Risk: Bom? Unsystematic Risk = 0' - Bo? ESTDEV.S(F5:F21) =STDEV.S(G5:621) ESTDEV.S(H5:H21) =F23^2 =G23^2 =H2342 =COVARIANCE.S(F5:F21, SH$5:$H$21) COVARIANCE.S(G5:621,SH$5:SH$21) =COVARIANCE.S(H5:H21, SH$5:$H$21) =F25/SH$24 =G25/SH$24 =H25/H24 =F26^2*SH$24 =G26^2*SH$24 =F23-F27 =G23-G27 : B D E F H G G Returns Year Centrica Plc Centrica Plc 1 2 3 4 2002 5 2003 National Express Group Plc Market Portfolio, M 6 2004 7 224.7 151.5 199.5 205.8 5 235.5 2025 327.6 200 293 REC 256.1 CO 268.1 2170 317.8 291.6 348.3 2005 309.6 292.5 204 204 223.5 133.1 7 2005 os 8 2006 2007 9 2007 100g 10 2008 11 2009 11 long 12 2010 12 2010 1212011 13 2011 14 2012 2015 15 2013 16 2014 17 2015 18 2016 19 2017 20 2018 21 2019 22 23 24 25 26 National Express Group Plc 292.6 187.4 337.7 465.2 A5 451.7 SA 545.4 607.1 co 168.8 2021 207.1 2426 243.6 216.1 2161 206.5 290.9 254.9 301.9 337.8 366.2 393.9 Market Portfolio, M 3940.4 4476.9 4814.3 5618.8 8600 6620.8 SAEG 6456.9 14243 4434.2 54100 5412.9 5000 5899.9 55792 5572.3 5897 5897.8 6749.1 6566.1 6242.3 =(C5/C4)-1 =(C6/C5)-1 = (C7/C6)-1 =(C8/07)-1 =(09/C8)-1 =(C10/09)-1 CUCI =(C11/C10)-1 =(C12/C11)-1 LiCt C111 =(C13/C12)-1 LICC1211 =(C14/C13)-1 LicSICAL IF(C15/C14 -1 LC16C151.1 =(C16/C15)-1 =(C17/016)-1 =(C18/017)-1 =(C19/C18)-1 =(C20/C19)-1 1=(C21/C20)-1 IF(D5/D4)-1 =(06/05)-1 =(07/D6)-1 =(D8/07)-1 =(09/08)-1 =(010/09)-1 =(D11/010)-1 =(012/011)-1 LO1.1 =(D13/D12)-1 I=(D14/D13)-1 =/ Fin15/01411 =(D15/014)-1 1016/015.1 =(D16/D15)-1 = ED17/0161-1 =(D17/D16)-1 |=(D18/D17)-1 =(D19/018)-1 =(D20/D19)-1 =(021/D20)-1 =(E5/E4)-1 =(E6/E5)-1 =(E7/E6)-1 =(E8/E7)-1 LICE1 LEON I=(E9/E8)-1 I=(E10/E9)-1 LiceCROLL =(E11/E10)-1 =(E12/E11)-1 1/12/2011 =(E13/E12)-1 FIFA/F121.1 I=(E14/E13)-1 1.1515141.1 I=(E15/E14)-1 FIF 16/5151.1 I=(E16/E15)-1 I.CA/61611 I=(E17/E16)-1 | =(E18/E17)-1 =(E19/E18)-1 =(E20/E19)-1 =(E21/E20)-1 7142.8 7687.8 6728.1 7542.4 136.1 Standard Deviation : Total risk: 0 Variance: o Covariance Beta: B = Cov (Re, Rm)/Var (Rm) Systematic Risk: Bo? Unsystematic Risk = 0'- B on? ESTDEV.S(F5:F21) ESTDEV.S(G5:621) =STDEV.S(H5:H21) =F23^2 =G2312 =H2342 =COVARIANCE.S(F5:F21,SH$5:SH$21) ECOVARIANCE.S(G5:621,SH$5:SH$21) =COVARIANCE.S(H5:H21,SH$5:$H$21) =F25/$H$24 =G25/$H$24 =H25/H24 =F26^2*$H$24 =G26^2SH$24 =F23-F27 =G23-G27 27 28 29 30 31 32 Coefficient of correlation Coeffcient of Determination =CORREL(F5:F21, SH$5:SH$21) =F3042 =CORREL(G5:21,$H$5:SH$21) =G3042

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_2

Step: 3

blur-text-image_3

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

Bond Pricing And Yield Curve Modeling A Structural Approach

Authors: Riccardo Rebonato

1st Edition

1107165857,1316731022

More Books

Students also viewed these Finance questions

Question

A typical value function is concave due to risk aversion.

Answered: 1 week ago