Valuation of your portfolio and companies and reevaluation based on any changes you have made in your portfolio.

This is part 2 in my project, and I have done the part 1 already. I will send it to you as a reference to complete the following question. All the information and data need to be real and the latest. The above four questions need to be answered in the four excel examples and have a brief summary respectively, which I will attach them later. In this part, I have picked up 5 stocks in part 1, so my professor requires me to use the same stock in part 2 as well. Deliverable: 1. Using the stocks in your initial portfolio, prepare a valuation of each stock and the initial portfolio using zero, constant or variable growth models with a market return at 8% and at 12%. [Note that the growth rate must be less than the required rate of return.] Make sure you list the date of the valuation and the closing share price of your firm’s stock. Each firm’s required rate of return will depend on its beta. 2. Is the stock of each of these companies over or undervalued? 3. What is the expected return using the CAPM model? 4. Prepare a time series ratio analysis (liquidity, activity, debt, and profitability). Identify any events during the period that may have caused the stocks’ prices to increase or decrease, explaining how these events affect the stocks’ prices.

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.

Open chat
Hello. Welcome to Quality Academic Help. How can we help you?