The Financial Model with Debt Template contains the following Excel sheets and sections:
- Monthly Cash Flow Model: Forecast of Sales Growth, Revenue, Operating Cost and Capital Expenditure. The template also contains an annual summary of the calculations.
- Debt Model: An example of debt calculations split into several tranches over time. The template estimates the interest and principal repayments and contains such features as a payment grace period.
- Equity Returns: Calculations of unlevered (pre-debt) and levered (post-debt) Returns on Investment based on an EBITDA Multiplier.
- Balance Sheet and Debt: The template includes an annual summary of Assets and Liabilities, including Debt and Depreciation Calculations.
Click on product images for screenshots of the template.
Learn More: How to Create an Excel Financial Model with Debt Financing