# Finance Excel Assignments | Online Homework Help

Estimating the expected return and standard deviation of Facebook stock

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

Computer Facebook’s expected daily return and the standard deviation using its realized return (Please watch the Class video for page 21 of CH5 for more instructions).

1. Collect historical price data.

You will begin by collecting historical stock price data for the company.  Historical stock prices are available on the internet through at the http://finance.yahoo.com website.  At this website, you will put the ticker symbol for your company in the symbol box and press “go”.  At this point, you will see a page that has financial information about your company.  On the left-hand side of the screen, there will be a series of option which you can choose to get more information about your company.  At this point, you want to look under “quotes” and choose “historical prices”.  The ticker of Facebook is FB.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

At this point, you will be given some options about the time period and frequency of the data you are collecting.  You want daily data beginning January 1, 2015, and ending June 30, 2019.  Once you have specified this time period, push the “get prices” button.  After the historical price information appears, you will see the option “download to spreadsheet” at the bottom of the historical price table.  Select this option to bring the information into an excel file.

1. Calculate daily returns.

The formula to compute daily returns is as follows:

(P2-P1)/P1 =

1. Estimate the expected rate of return and Standard deviation.

The excel function for the expected rate of return is   “=average ()”

The excel function for the standard deviation is “=stdev()”

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Problems 1 and 6 were wrong, I got a 75%
Customer 462485, October 16th, 2022
Excellent work. Looking forward to working with your in the future.
Customer 463467, November 11th, 2022
SEO
Great work.Recommendable
Customer 463647, May 14th, 2023
Health Care
Met expectations. Thank you.
Customer 454755, June 30th, 2020
Interior Decoration
Excellent work! We look down to your future contribution
Customer 463463, November 16th, 2022
GOOD work.
Customer 463105, June 27th, 2022
Other
Michelle is a great writer! Assignment on time.
Customer 463427, October 1st, 2022
Excellent work!
Customer 463463, October 13th, 2022
ENG 111
looks very good
Customer 464369, June 25th, 2023
Transportation & Logistics
The revisions needed were done in time. The paper was informative
Customer 463473, October 31st, 2022
Ethics
Writer did do a good job in answering my question and assignment!
Customer 454777, July 8th, 2020
Good calculations
Customer 462327, June 28th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend