Balance Sheet
Total Costs:
900,000
25% Avg:
25,000
Base Repayment:
210,000
%
Applied Repayment:
16,800
Calculation Flow
MA Risk Table
| Analysis | Sustainability | Sensitization | ||||||
|---|---|---|---|---|---|---|---|---|
| Actual (en euros) |
Projection | Forecast (en euros) |
Idiosyncratic / Market events (en euros) |
|||||
| Année de clôture |
Clôture + 1 an |
Clôture +1 an |
Clôture +2 ans |
Clôture +3 ans |
Clôture +1 an |
Clôture +2 ans |
Clôture +3 ans |
|
DSC Formula Breakdown Click any column above to see breakdown
EBITDA
+1,100,000
- 25% Depreciation
-25,000
- Interest
-25,000
- Taxes
-80,000
- Repayment
-16,800
- Repayment Loans
-0
- Withdrawals
-0
- 10% EBITDA
-110,000
DSC (Debt Service Capacity)
843,200
Assessment: DSC / EBITDA =
76.65%
DSC ENSURED
Source Information Analysis Y1
Legend
Balance Sheet
Analysis
Sustainability
Input Panel
Calculated
Input Panel
Forecast Y1
Sustainability Y1Forecast Y2
Sustainability Y2Forecast Y3
Sustainability Y3Input Panel Connection
Hover over any input panel section to see its connection to the main table columns.
Formula Quick Reference
EBITDA
FL - (FS+FT+FU+FV+FW+FY+FZ)
25% Depreciation
(GA+GB+GC+GD) / 4
Analysis Y2
Analysis Y1 x 1.05
DSC
EBITDA - Dep - Int - Tax - Rep - Loans - With - 10%EBITDA
Sustainability
Y1: Analysis Y2 × (1 + Forecast Y1%)
Y2: Sustainability Y1 × (1 + Forecast Y2%)
Y3: Sustainability Y2 × (1 + Forecast Y3%)
Sensitization
sustainabilityYn x (1 + sensitizationPanel%)
(stress test on forecast)