For this analysis, you are to first complete theExcel file
(attached). You are evaluating ticker (HPP). donotuse Disney, DIS. Just change the ticker in the Excel file to HPP.
Follow the instructions on Sheet1 to go to the webpage(s) for the data. Copy/type the relevant data items into the workbook/file. Complete the cells to calculate the intermediate steps and the firm’s WACC.
You are then to write one to two pages (do not go over two pages, and do not allow Word to add an extra blank page to your file) of analysis, using the included template,
Analysis template
(the template includes dummy text, but use the format. You can add headings and use single space, if you want.). Your analysis should answer:
- What is the company, and what does it do?
- What is the beta and cost of equity for this firm? What does the beta (and resulting cost of equity) mean for the firm, relative to the market and/or other similar firms? g. Is the beta/cost high, low, moderate? What does this resulting cost of equity mean for the company?
- What is the cost of debt for this firm (this is an area that I made easier)? What does this mean for the firm, relative to the market and/or other similar firms? What does this resulting cost of equity mean for the company?
- How much debt/equity does the firm have and what does this mean, in general?
- What is the resulting WACC, and what does this (how does this impact) the firm? What does WACC mean (in general), and what does this specific WACC mean for this firm?
- Any other relevant information.
You do not have to simply answer these points in this order. Write a narrative of your analysis and answer them in what you write up. This should be in the language of a report to your boss, the CFO of the company, a quick read of the analysis of your company.