How to make a Debt in Capital Structure in Excel? Download this Debt in Capital Structure Excel worksheet now!
We provide a Debt in Capital Structure template that will professionalize your way of administration. Using this financial worksheet guarantees you will save time, cost and efforts!
The following factors are included:
- Tax rate
- Debt in the capital structure
- EBIT
- Interest
- Profit before taxes
- Taxes
- Profit after taxes
- Dividends
- Total payments to security holders
- Required return on debt
- Required return on equity
- Market value of debt
- Market value of equity
- Market value of the firm
- Book value of debt
- Book value of equity
- Book value of the firm
- Return on total capital
- Return on equity
- Number of shares outstanding
- Price per share
- Earnings per share
- Price-earnings ratio
- Book value debt ratio
- Market value debt ratio
- Weighted average cost of capital
- Free cash flow
- Market value of the firm
Download this Debt Capital Structure Excel worksheet now!
Fast, safe and easy!