This Excel file allows you to estimate the cost of capital of a firm that has Preferred Stock outstanding. It helps you unlever and relever the relevant betas to determine the cost of capital (WACC) under the target capital structure.
