Order For Similar Custom Papers & Assignment Help Services

Fill the order form details - writing instructions guides, and get your paper done.

Posted: March 20th, 2017

Finicial Problems

  
You have $100,000 to invest in 4 stocks. Pick each stock from a different sector (for example, technology, energy, consumer products, automotive). 
Prepare the following using Excel. Make sure that your spreadsheets are well formatted, clear and understandable. Feel free 
1) Identify the expected returns using Yahoo Finance. Look at current stock price, expected stock price in one year and the annual dividend. The expected stock price in one year less the current stock price plus the annual dividend gives you the return on your investment (expected appreciation in stock price plus the annual dividend you received). Divide this by the initial investment to get the return on your investment.
2) Once you have the expected return for each stock, identify the overall expected return. This is the return of all stocks weighted by the portion they constitute of your total investment. See slide 13-12 (from Chapter 13).
3) Develop the expected return for your portfolio of stocks using the Capital Asset Pricing Model. See slide 13-41. Assume the risk free rate is 2.6% (approximate US Treasury 10 yr bill rate). Assume the market risk premium is 6.7% (long term average stock market return, including dividends). Because of this, you do not need to add in the dividend yield of your stocks, unlike what I said in class. Calculate the average return for your portfolio of stocks. Compare the returns for each stock and the overall portfolio to what you calculated in 1) above. 
4) Are there any reasons why one set of values may be different from the other? If the expected returns from 1) above are higher than those calculated in 3), it may be due to recent favorable conditions for the stack which are resulting in strong estimates for the stock price one year from now. See if you can find any reasons for possible differences.

Order | Check Discount

Paper Writing Help For You!

Special Offer! Get 20-25% Off On your Order!

Why choose us

You Want Quality and That’s What We Deliver

Professional Writers

We assemble our team by selectively choosing highly skilled writers, each boasting specialized knowledge in specific subject areas and a robust background in academic writing

Discounted Prices

Our service is committed to delivering the finest writers at the most competitive rates, ensuring that affordability is balanced with uncompromising quality. Our pricing strategy is designed to be both fair and reasonable, standing out favorably against other writing services in the market.

AI & Plagiarism-Free

Rest assured, you'll never receive a product tainted by plagiarism or AI-generated content. Each paper is research-written by human writers, followed by a rigorous scanning process of the final draft before it's delivered to you, ensuring the content is entirely original and maintaining our unwavering commitment to providing plagiarism-free work.

How it works

When you decide to place an order with Nurscola, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.