In: Finance
Below is the explanation how we have gone about this problem and excel screenshots of both the formulas used in excel sheet and the final results of excel file.
Since, we are not given with the ROIC number which would be crucial for our calculation, our first step would be to calculate that. For that, we have used the base case Growth of 3% and Reinvestment Rate of 10%.
ROIC =
Thus, using this ROIC and new reinvestment rate we have calculated new growth rate. That has been applied to calculate Operating profit in both the cases. From that, FCF has been calculated as follows:
FCF1 = Operating Profit1 * (1 - Reinvestment Rate)
Then, we have used the formula to calculate the value of firm.