The free excel model is created to calculate the WACC (Weighted Average Cost of Capital) for a group of companies. The WACC for each entity is calculated based on CAPM (Capital Asset Pricing Model). The group WACC is then calculated as the average between 2 approaches.
The first approach calculates the WACC by considering the proportion of each company's total assets in relation to the total assets of all the companies included in the calculation. This method takes into account the relative size of each company within the group when determining the overall WACC.
The second approach uses the same methodology as the first approach, but instead of considering total assets, it focuses on the total equity of the company.
For every company, the user needs to fill in the debt financing and gather financial data such as the risk-free rate, risk premium, beta, interest rate, corporate tax rate, and projected inflation rate for the local currency in each location or country.
Additionally, the user needs to input the total assets and equity for each company. Please only input data in the green cells
