HomeworkLib
Question

Please help with questions 8-10, they need to be done in Excel, so please attach the...

Please help with questions 8-10, they need to be done in Excel, so please attach the screenshots from the Excel.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

I have answered 4 parts a,b,c,d of question 8 as per policy.

Please see the screenshot of the solutionDay Mon Tues Wed Thurs ABC 31 32.5 51 53 52.5 51 53 52.1 0.84 31.5 32 SUM(C3:C7)/5 32 Mean Variance 0.5 10 Using the formula of logarithmic return : Rt In(St/St-1) VAR.P(C3: Volatility-Annualized standard deviation of log returns Volatility 12 13 Mean Log returns ABC 15 16 17 AVERAGE(E16:E19) 18 19 20 VAR.P(E16:E19) Mon Tues Wed 3.85% -0.95% 2.90% 4.73% 1.53% 4.65% 1.57% 0.75% 0.473676452 0.54305729 SQRT(E22) -SQRT (F22) Fri Mean log 0.96% Daily Variance 0.0008799 0.001156515 COVARIANCE.P(C16:C20,D16:D20) Daily variance*No. of trading days) E21*255 0.2243694 0.294911228 96628 0.034007567 Covariance 0.000664379 23 24 STDEV.P(E16:E19) 25 26 Correlation 0.823262856 CORREL(C16:C20,D16:D20)

0 0
Add a comment
Know the answer?
Add Answer to:
Please help with questions 8-10, they need to be done in Excel, so please attach the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Can someone please help me with this, it's supposed to be done in Excel Geico is...

    Can someone please help me with this, it's supposed to be done in Excel Geico is looking at using an ad in Roadrunner Magazine to reach motorcycle owners to sell them insurance. Facts: Selling Price: $750.00 Profit Contribution Margin: 35% of selling price Advertising Cost: 231,000 readership @ $9,100 ad placement cost, plus ad production cost of $3,500 Historical Response Rate:.04% Questions: 1. Will this be profitable using the assumptions above? 2. What would ROI (ROMI) be? 3. How many...

  • ***Java Project*** Please upload the entire code and attach the screenshots of the code. The screenshots help me to write the code, so please attach that. Thank you so much. If you could use the comme...

    ***Java Project*** Please upload the entire code and attach the screenshots of the code. The screenshots help me to write the code, so please attach that. Thank you so much. If you could use the comment to explain the code, it would be perfect! Thank you so much~ Design and code a Swing GUl for a two-player tic-tac-toe (noughts and crosses) game on a 3 x 3 game board. The JFrame should use a BorderLayout with a JLabel in the...

  • Please solve this problem in Excel and attach Excel when finished. Thank you!! 9. Prepare a...

    Please solve this problem in Excel and attach Excel when finished. Thank you!! 9. Prepare a flowchart that describes going to the library to study for an exam. Your flowchart should include these items:finding a place at the library to study: checking to see if you have your book paper, highlighter, and so forth: traveling to the library: and the possibility of moving to another location if the place you chose to study starts to get crowded.

  • I need help with questions 5-8 please the full instructions are given on the screenshot. So...

    I need help with questions 5-8 please the full instructions are given on the screenshot. So as a rule, when the denominator is a second order polynomial with no real roots, the numerator should be a first-order polynomial. Now try to find A, B, and C. Find A by multiplication and substitution trick. Find B and C by equating the corresponding coefficients of = 0,1,2 in left and right. Find the poles and zeros of problems 5, 6 and 7....

  • In order to do this assignment, you must use EXCEL and attach the EXCEL Worksheet This...

    In order to do this assignment, you must use EXCEL and attach the EXCEL Worksheet This is a REAL WORLD SCENARIO (Please use relevant, realistic numbers-think of this as an actual /true scenario) You are in a business hat organizes paries You are planning to host a Halloween Party 1.Come up with a creative name and theme for the party 2 List all the expenses that you would incur on this party. Classfiy those expenses as fixed or variable 3....

  • please help! need done in an hour 8) Circle the strongest acid (proton donor) in the...

    please help! need done in an hour 8) Circle the strongest acid (proton donor) in the following threesomes. (3pts) (a) H3C-C-OH CH3CH2-OH -o-CH H3C-C-O-CH3 ni ci vora (b) CO2H CO2H CO2H (c) CH3 CN

  • Please the instructor said we need to submit this in excel please . Someone did it...

    Please the instructor said we need to submit this in excel please . Someone did it it for me without excel and told me to put it in excel but I can’t figure it out please I need this in Excel and all the calculation need to use excel formulas please. I attached what has been done but I need it Excel please using excel formulas to do the calculations. Thank you so much According to the National Center for...

  • need help on this question please ? ??? 2209 PID233. done by adding methyl groups to...

    need help on this question please ? ??? 2209 PID233. done by adding methyl groups to the genes, so that fene is inactive c. Why is "silencing" of a gene a significant event in terms of leading to disease such as cancer н adenine guanine tolecule continued)

  • Please show the excel simulation model so I can recreate it. If I see it done...

    Please show the excel simulation model so I can recreate it. If I see it done correctly, I can recreate it and give it more practice. Thank you so much for your help! Case Study w Suppose you are a recent business student graduate who is planning to offer personal financial advice to clients. In preparation for this business venture, you developed the following financial planning model. 30 Lesson 11 Basic Scenario : Date Age Current Salary Current Portfolio Annual...

  • NOTE: please mention the name and roll# on center of the circuit as done in question...

    NOTE: please mention the name and roll# on center of the circuit as done in question provided. please attach the screenshot. i need CIRCUIT DIAGRAM and TRUTH TABLE for all gates using MULTISIM software. "no hand written" Name: Balaaj Khan Khuwaja Roll# 1845104 Home Activity: By using Multisim, design 8-bit magnitude comparator with the help of 7485 ICs. Comment your name and roll number on design suite and attach the screen shot at the end of this experiment.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT