Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Matrix Your Own Question

Matrix, Tutor

Category: Homework

Satisfied Customers: 419

Experience: Masters

21626334

Type Your Homework Question Here...

Matrix is online now

Matrix please do this for me, need by Sunday evening 8pm est

This answer was rated:

★★★★★

Matrix please do this for me, need by Sunday evening 8pm est please

By walking through a set of financial data for XYZ, this assignment will help you better understand how theoretical stock prices are calculated and how prices may react to market forces such as risk and interest rates. You will use both the CAPM (capital asset pricing model) and the constant growth model (CGM) to arrive at XYZ's stock price.

To receive full credit on this assignment, please show all work, including formulae and calculations used to arrive at financial values.

Assignment Guidelines:

Find an estimate of the risk-free rate of interest (krf). To obtain this value, go to Bloomberg.com(http://www.bloomberg.com/markets/): Market Data and use the "U.S. 10-year Treasury" bond rate (middle column) as the risk-free rate. In addition, you also need a value for the market risk premium. Use an assumed market risk premium of 9.00%. Download the XYZ Stock Information by clicking the link(http://class.aiuniv.edu/LCMSFileShareCommon/bb4/f55/18b/b6a/46c/582/a5d/8fe/c39/baa/7e/FINA310_U3_f1.pdf). Using the information from the XYZ Stock Information document, record the following values: XYZ's beta (ß) XYZ's current annual dividend XYZ's 3-year dividend growth rate (g) Industry P/E XYZ's EPS With the information you recorded, use the CAPM to calculate XYZ's required rate of return (ks). Use the CGM to find the current stock price for XYZ. We will call this the theoretical price (Po). Now use the XYZ Stock Information (http://class.aiuniv.edu/LCMSFileShareCommon/bb4/f55/18b/b6a/46c/582/a5d/8fe/c39/baa/7e/FINA310_U3_f1.pdf) to find XYZ's current stock quote (P). Compare Po and P and answer the following questions: Are there any differences? What factors may be at work for such a difference in the two prices? Now assume the market risk premium has increased from 9.00% to 12% and this increase is due only to the increased risk in the market. In other words, assume the krf and the stock's beta remain the same for this exercise. What will the new price be? Explain. Recalculate XYZ's stock price using the P/E ratio model and the needed info found in the XYZ Stock Information file. Why is the present stock price different from the price arrived at using CGM (Constant Growth Model)? If you used Microsoft Word to arrive at your answers, then you must provide an explanation of the formulas and calculations.

Your submitted assignment (125 points) must include the following:

A double-spaced Word document of 2–3 pages that contains the following: All of the numerical values listed in the assignment guidelines. Your answers to the four questions in the assignment guidelines. The formulas and calculations that you used to arrive at your answers You must include your explanation of how you used Microsoft Excel for your calculations if applicable.

Grading:

You will be graded on the accuracy of your value calculations as well as your demonstrated understanding of CAPM, CGM, and stock analysis.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal ...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.Freshfield, Liverpool, UK

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.DianeDallas, TX

Meet The Experts:

LogicPro

Engineer

Satisfied Customers:

4925

Expert in Java C++ C C# VB Javascript Design SQL HTML