Capital Structure Optimization Model

Capital Structure Optimization Model

Capital Structure Inputs

Define different Debt-to-Equity (D/E) ratio scenarios and their corresponding Costs of Equity (Re) and Debt (Rd).

This value is used to scale the debt and equity components for calculating their market values (D and E) for each D/E ratio scenario, providing a proportional firm value for comparison.

Capital Structure Scenarios

Add rows to define different Debt-to-Equity (D/E) ratios and their estimated costs of equity (Re) and debt (Rd). Re and Rd typically change as D/E changes.

D/E Ratio Cost of Equity (Re %) Cost of Debt (Rd %) Actions

Scroll to Top