Submit a single Word document addressing all the questions below and a single excel sheet that contains supporting calculations for all the companies covered by the group

**IMPORTANT FOR WRITER** THERE ARE 5 STUDENTS IN MY GROUP THEREFORE THERE MUST BE A TOTAL OF 5 COMPANIES IN THE ANALYSIS

Submit a single Word document addressing all the questions below and a single excel sheet that contains supporting calculations for all the companies covered by the group to the course website (do not email me the assignment). Make sure to include all the names of your group members on the Word document.This assignment is worth 80 points. Each question below is worth 15 points (75 points total for correctly answering the questions). There are 5 points for the organization, clarity, and professionalism of your writeup.Download the most recent 10-k statement for all the companies from the SEC website and recent price data from your favorite financial website (e.g. Yahoo! Finance). Answer the following questions Questions:
1. Perform ratio analysis to learn how the firms performed over time and relative to one another. Make Sure to include at least one ratio from the following categories: liquidity, asset management, debt management, profitability, and market value. Discuss the ratios and highlight any trends. Based on the ratio analysis, which company is most attractive and why? I suggest you create a table summarizing this information for all the companies covered by your group and include it in the word document.
2. What is the risk profile of the companies in your group? Which company is the riskiest?
(a) What is its cost of equity (CAPM) for each of the companies?
(b) According to the financial statements (management’s discussions in annual reports), what are the biggest risk factors facing the firms in your group? Please discuss these risk factors.
3. What return would you have earned investing in the companies in your group over the past decade(adjust the time frame depending on your company)? Which company had the best performance overall
and on a risk-adjusted basis? I suggest you summarize the information in a table and include it in the word document.
(a) Would you have under or out performed the market by investing in these companies?
(b) What is your opinion on how these firms perform in the next decade or your recommended investment horizon?
4. How have these companies returned cash to their owners (e.g. dividends or buy backs)? If so, how much and for how long? Will pattern continue? If the companies do not currently pay back its investors,when do you expect they will start?
5. What is the overall recommendation to the fund manager? Should the manager invest in all, some or none of the companies analyzed by your group and why?

Don't use plagiarized sources. Get Your Custom Essay on
Submit a single Word document addressing all the questions below and a single excel sheet that contains supporting calculations for all the companies covered by the group
Just from $13/Page
Order Essay

I have attached the instructions as well as a sample template
Uploaded materials

Calculate your order
275 words
Total price: $0.00

Top-quality papers guaranteed

54

100% original papers

We sell only unique pieces of writing completed according to your demands.

54

Confidential service

We use security encryption to keep your personal data protected.

54

Money-back guarantee

We can give your money back if something goes wrong with your order.

Enjoy the free features we offer to everyone

  1. Title page

    Get a free title page formatted according to the specifics of your particular style.

  2. Custom formatting

    Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.

  3. Bibliography page

    Don’t pay extra for a list of references that perfectly fits your academic needs.

  4. 24/7 support assistance

    Ask us a question anytime you need to—we don’t charge extra for supporting you!

Calculate how much your essay costs

Type of paper
Academic level
Deadline
550 words

How to place an order

  • Choose the number of pages, your academic level, and deadline
  • Push the orange button
  • Give instructions for your paper
  • Pay with PayPal or a credit card
  • Track the progress of your order
  • Approve and enjoy your custom paper

Ask experts to write you a cheap essay of excellent quality

Place an order