Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Morton Financial must decide on the percentage of available funds to commit to each of two investments, referred to as A and B, over the next four periods. The following table shows the amount of new...

Date Liquidating Value Daily Log Return 9/16/18 9/18/18 9/19/18 9/20/18 1000 950 800 890 980 You have the following dates with corresponding liquidating values of your portolio on that day. Please...

You have the following dates with corresponding liquidating values of your portfolio on that day. Please compute the following (while showing your excel formula): 1. The daily log return 2. The...

Hello, Can I get some help figuring out the "solution" portion of this excel file. Thank you Ross, Westerfield, and Jordan's Spreadsheet Master Fundamentals of Corporate Finance, 10th edition by Brad...

I need help with an Accounting Payroll Project. I have included all of the necessary instructions and attachments. I would appreciate any help or guidance that I can get. I have to prepare the...

Hello I am really confused on the project below. I have the code made for the NumbersToWordConverter (which I will paste below) but I am having trouble figuring out how to make it compatible to...

Hello, I am really confused about this homework. She did the professor did not provide a trial balance. I need to submit homework by 5:00pm. I really need help as soon as possible. Please try to work...

Hello. I am really confused on this weeks accounting hw. Can someone help please!! Greatly appreciated! Lubricants, Inc., produces a special kind of grease that is widely used by race car drivers....

Using the binomial formula to solve a word problem: A certain company's IT department has found that16%of all visitors to the company website arrive there in error. (They are actually looking for...

Verify Stokes Theorem for the vector field where S is the portion of the surface x^2+y^2+z^2=1 located below the plane z=0. P = yi - zj+zk

Using the data in the Sample Balance Sheet, calculate the current ratio, quick ratio, and the debt ratio What information do these ratios provide? If you were concerned about the result, what advice...

Question 8 1 pts When you need to carry totals forward from one page to the next in a journal: Total the columns and close them to the capital account, so that each of these accounts has a zero...

Merton Ltd. has a $30 million bond obligation outstanding, which it is considering refunding. Though the bonds were initially issued at 10.0 percent, the interest rates on similar issues have...