Reference no: EM133058519

Ferrari, the famous high-performance automotive group, launched its initial public offering (IPO) on October 20, 2015. Although the share price had initially risen to over 57 per share, by the end of the year it had settled to 48. Ferrari had been owned by Fiat (Italy), and had never calculated its own cost of capital before, one independent of Fiat. It now needed to, and one of its first challenges was estimating its beta. With only two months of trading to base it on, the corporate treasury group had started with what were considered 'comparable firms', which for Ferrari, meant firms in the luxury goods industry, not automotive. Luxury goods were historically less volatile than the market, so the initial guess on Ferrari's beta was 0.90. 

Using the following assumptions, answer the questions below:

What is the Ferrari's cost of equity in euros?

k_e=k_rf+β(k_m -k_rf)

Market risk premium = (k_m - k_rf)

What is Ferrari's weighted average cost of capital?

WACC =  ( kd (1-tax) * D/(D+E)) + ( k_e * E/(D+E))

Please use excel.