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:
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.