Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello! I am really confused about which exce formulas to use to compute all of these. Thank you!! Date Liquidating Value Daily Log Return 1000

image text in transcribed
Hello! I am really confused about which exce formulas to use to compute all of these. Thank you!!
Date Liquidating Value Daily Log Return 1000 950 800 890 980 9/16/18 9/18/18 9/19/18 9/20/18 You have the following dates with cormesponding liquidating values of your portfolio on that day. Please compute the following (whille showing your excel formula): 1. The daily log return 2. The average daily log return 3. The volatility (standard deviation) of the daily log returns 4. The daily log return converted to annual 5. The daily volatility converted to annual 6, The risk free rate (use 3%) 7. The Sharpe Ratio Please show your excel formulas, thank you

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

Personal Finance Building Your Future

Authors: Robert B. Walker, Kristy P. Walker

1st edition

9780077861728, 978-0073530659

More Books

Students also viewed these Finance questions