Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can help me convert this calculations to excel? i already posted the question and got this answer but they require us to put it in
Can help me convert this calculations to excel? i already posted the question and got this answer but they require us to put it in excel.
Petronas company Return Page first we calculate perayear return by (P + G- Po rioolhere is price at - year gend A Revedend font precrow your price for Mayleank Ranking Reburn (%) 13.65% 5.2011 1.72 %. 14.81% 14.86%. 30.28./. - 3.897 -2.487 4.36 10 5.867 5.857 29.8.). -- 10.787 0.79% 10.064 2010 2011 2012 2013 2014 2015 2016 2011 2018 2019 42.75-7 22.49.). Continously, compounded annual retwem Returun 4( 14712 (147,? 114 rue)) An - for Maybank fa (1.1365)11.0172)61:148114101486 [9 676) (1.0436) (1022) (1.296) (1.0079) Mean Return for Plean Return Risk deviation Petronas company 9.63% Standard duriation is a measure of rush can be calculated by funding Standard Varanelay) = (standard deviation (o) 7) Varrance - Eki - mean? 2 by formula n 2 mean 7 mean retur is! n may May bansk 2 For may may o? (13.65-8. 2) - ( 1.72-8. 2) + (14.81-8.2) + (14.86-8.2)2 + (-3.89 -8.2) 7 (4.36-8, 272 12:2-8-2)+(29.8-6-2)+(0.79-8-2) 9 29.16 t ul.gg f 43.69 + 44.35+14616 + 14.74 + 36+ Dikt 466 56+ 54.90 g 97.516.) J 97.51 9.87% (30.48 -9.63) (-2.48-9.63) 2+ (5.86-9.63)2 + (-5.85-9.63) + (-10.78 +1 9.63) + (10.8 - 9.635 19.44 1096-93 + 165.37p 434 727 146.65+ 14, 21+ 239.63+ 416.56 +1.36 3 For petronas 22-9 + 2 9 281.65 (-1.)2 Standard duration 287.65 / = 16.787Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started