代写MIDTERM 1代写Java编程

MIDTERM 1

MIDTERM 1 is worth 25% of your grade. The completed work must be uploaded via the Week 6 MIDTERM 1 dropbox by 5pm on Saturday 17-February.

Using the data provided, please calculate the expected July 2024 Enterprise Value per Common Share. Assume a Free Cash Flow growth rate of 3.5%/year for years 1-5, a long-term growth rate of 0% growth rate, and a WACC of 11.8%. Assume the basic weighted average number of shares as at 29 July 2023 is 4,093 million.

On an accompanying word document, saved as a .pdf file;

· Question 1: State what your expected July 31, 2024 Enterprise Value per Common Share is. Ensure that a MS Excel workbook supports your work.

· Question 2: Based on your analysis; state whether a Common Share bought at the 29-July-23 closing price is likely to be a profitable investment, and why.

· Question 3: 2023 has been a period of high inflation; assume that the long-term growth rate is 75% of the expected inflation rate of 2%. Quantify and state what the impact on the Enterprise Value per Common Share would be, and whether this would still be a profitable investment.

Your submission should include the .pdf document, as well as the MS Excel Workbook supporting your statements.