EXCEL FILE ONLY You will need to collect the stock price data for any 2 companie

May 13, 2021
JAYMIE
finance
0 Comments

EXCEL FILE ONLY
You will need to collect the stock price data for any 2 companies and the stock market of your choice. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks with at least one month’s data from the start of the semester and set them on the spreadsheet. Taking this raw data, compute the monthly returns for both (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.
Next, compute the mean rate of return and the standard deviation of returns for both your stocks. Compute the correlation coefficient for the 2 stocks and the beta value for each stock. Plot the returns of your stocks against each other on a graph within the spreadsheet (y axis for stock a and x axis for stock b).
Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks. Compute the 20 monthly rates of return for the portfolio, the mean rate of return and the standard deviation of returns and the beta value of the portfolio. Finally, within the spreadsheet comment in detail your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks and the overall market.

Features You Can Count On

We have a quality check process in place for every assignment we complete for the students. This process assure that students receive nothing but THE BEST

Your Grades Soar

With our specific and personalized attention, you get the dual benefits of understanding the concepts and fundamentals of your subject and its nuances. And you can always keep up with class room teaching and get good grades too!

Trusted Experts

Our team of experts are drawn from group of academicians who hold doctorates in their chosen fields. They have been teachers all their lives. They understand your needs and can help you with exams, homework and assignments.

Delivery Guarantee

Our online tutors know the importance of handing in tasks on-time and in the format required by each college. Our discipline is reflected in our strict adherence to on-time delivery of your assignments and homework.

24X7 Availability

We draw the best talent in the form of lecturers, professors, online tutors and subject experts from all over the world. For this reason, when ever you may need help, it’s always there for you. Available, reliable and guaranteed.

Privacy Guaranteed

We respect your privacy. We never disclose your personal or contact details to anyone under any circumstances. So, you can communicate with our team confidently and always be 100% assured of complete privacy of all your dealings with us.

Satisfaction Guaranteed

We have built a reputation of offering professional homework and assignment services. We assure you of our continued support for as long as you want it, each time to guarantee you 100% satisfaction.

We're Here For You 24/7

We are known for our impressive quality of work. Students around the globe prefer our assignment writing services as we provide them the excellent features and benefits. Take a look at the alluring features.

Plagiarism-Free Affordable Papers

Money-Back Guarantee

Timely Delivery

Affordable

Zero-Plagiarism Guarantee

Find out More

Our Services

Exquisite Essay Writings specializes with preparation and writing of all your premium writing projects. We mainly deal with academic research and project writing services but offer a wide verity of additional writing services like coursework, dissertation and thesis essay writing. We have a team of highly trained and skilled professionals from every sector and profession thus insuring your projects are handled in the best possible manner. We have been in the academic assistance service since 2008 and managed to build a large network of clients from across the globe and covering practically every sector of business and education available today.

Custom Essay Writing Service

Looking for the best custom assignment writing service online? Relax! exquisiteessaywritings.com is a trustworthy affordable writing service that delivers clients with quality custom assignments.

Creative Essay Writing

Do you feel like you lack the skills to write creative essays? Then you need help. Exquisiteessaywritings.com is the only creative essay writing service that will deliver creativity with a magic touch

Term Paper Writing

Get an excellent grade on any custom term paper writing service. All of our customers remain anonymous throughout the entire ordering process. We guarantee that your education will not suffer.

Research Paper Writing

Looking for a legitimate and trustworthy High School/College custom research paper writing service? That exceeds your expectations to become that number website write papers for you! Well, here it is. Receive high-quality papers, 24/7 support

Annotated Bibliography

Are you looking for someone to write your MLA, APA, Chicago Style annotated bibliography? Good News! hire us, Our annotated bibliography writers are always ready to offer Custom annotated bibliography writing in all fields.

Thesis Writing Service

Are you searching for thesis writing service? Do not blame anyone. The professional PhD/ MA writers at exquisiteessaywritings.com are here to help. Contact support to find out more information about our writing service.

We're Obsessed with Your Privacy

1. Anonymous Chatting

At YourAssignmentHelpers.com, you can communicate directly with your writer on a no-name basis.

2. Secure Payment Methods

We accept only Visa, MasterCard, American Express and Discover for online orders.

3. Complete Confidentiality

Your personal details remain confidential and won’t be disclosed to the writer or other parties.

Testimonials

Have a look at some of the wonderful things people say about us.

Superb

“Believe it or not, but I’m fully satisfied with the essay you’ve written for me. I have got an excellent mark and I’m now convinced in the truth of your promises. Thanks”

Jessica

Good Service

“Thanks for good service and high quality. The research paper was much more than I expected!Thanks”

Jake

Unbelievable

“Unbelievable. The writer followed all my instructions and created a brilliant essay, I would say. What I like most of all, no one suspects even that my essay wasn’t written by me. Thanks”

Jennifer

Thanks

“Thanks. Without you I would not have been a Master of Psychology.”

Sarah

I’m so happy about it

“Just when I was about to give up on my dissertation, my friend advised me to use your service. It was timely advice because I was stuck and didn’t know what to do. Now I am a PhD degree-holder and I’m so happy about it”

Alberto

Great

“I thought paper writing services are the fiction and rip-off for naÃ¯ve students. But when it came to my research paper that was to be handed in in 72 hours , I had no variants. I made the right choice when I ordered my paper from you and I’ll definitely use your services in the future.”

Kyla