Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribed

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.787

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

Portfolio Performance Measurement And Benchmarking

Authors: Jon Christopherson, David Carino, Wayne Ferson

1st Edition

0071496653, 978-0071496650

More Books

Students also viewed these Finance questions

Question

Methods of Delivery Guidelines for

Answered: 1 week ago