Synthetische Hafenwerk — Refinanzierung
Eine Anschlussfinanzierung vor Fälligkeit zeigt Ersatzdarlehen, Cash-Tilgung und verbleibende Lücke.
EURk · Base · Model horizon: 2026-01-01 – 2031-12-31
Financial risks · Forecasts depend on assumptions. Investing can result in a total loss.
Published models are independently created by users. Scenarios and forecasts are hypothetical and depend on assumptions; actual outcomes may differ substantially. BalanceCheat does not verify or endorse the accuracy or reasonableness of user models and does not provide personalized investment advice. These tools support modeling, education, research and discussion. Do not base investment decisions solely on a published model. Investing can result in a total loss. Authors must comply with applicable laws, including relevant investment-recommendation and conflict-of-interest disclosures. Labels and disclaimers do not create a regulatory exemption.
At a glance
Required Funding
0 EURk2031 · BaseLiquidity headroom
6,870.47 EURk2031 · BaseGross debt
0 EURk2031 · BaseFinancing & Debt Schedule · Base
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Gross debt | 2,850 | 2,200 | 2,200 | 2,200 | 0 |
| Net debt | -1,029.63 | -2,131.81 | -3,388.62 | -4,792.66 | -6,370.47 |
| Cash & Cash Equivalents | 3,879.63 | 4,331.81 | 5,588.62 | 6,992.66 | 6,370.47 |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Undrawn committed facilities | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 |
| Available liquidity | 4,879.63 | 5,331.81 | 6,588.62 | 7,992.66 | 7,370.47 |
| Liquidity headroom | 4,379.63 | 4,831.81 | 6,088.62 | 7,492.66 | 6,870.47 |
| Required Funding | 0 | 0 | 0 | 0 | 0 |
| Funding need | 0 | 0 | 0 | 0 | 0 |
Interest / repayment
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Interest expense | 175.58 | 166.79 | 165 | 165 | 150.99 |
| Draws | 0 | 2,200 | 0 | 0 | 0 |
| Repayments | 150 | 2,850 | 0 | 0 | 2,200 |
Debt schedule
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Closing balance · Senior term loan | 2,850 | 0 | 0 | 0 | 0 |
| Interest expense · Senior term loan | 175.58 | 152.82 | 0 | 0 | 0 |
| Draws · Senior term loan | 0 | 0 | 0 | 0 | 0 |
| Repayments · Senior term loan | 150 | 2,850 | 0 | 0 | 0 |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Closing balance · Loan 1 | 0 | 0 | 0 | 0 | 0 |
| Interest expense · Loan 1 | 0 | 0 | 0 | 0 | 0 |
| Draws · Loan 1 | 0 | 0 | 0 | 0 | 0 |
| Repayments · Loan 1 | 0 | 0 | 0 | 0 | 0 |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|
| Closing balance · Replacement Senior term loan | 0 | 2,200 | 2,200 | 2,200 | 0 |
| Interest expense · Replacement Senior term loan | 0 | 13.98 | 165 | 165 | 150.99 |
| Draws · Replacement Senior term loan | 0 | 2,200 | 0 | 0 | 0 |
| Repayments · Replacement Senior term loan | 0 | 0 | 0 | 0 | 2,200 |
Refinancing · Base
| Metric | Value |
|---|---|
| Refinancing need · Synthetische Anschlussfinanzierung (EURk) | 2,712.7 |
| Replacement financing · Synthetische Anschlussfinanzierung (EURk) | 2,200 |
| Cash impact · Synthetische Anschlussfinanzierung (EURk) | -512.7 |
| Refinancing need (EURk) | 4,912.7 |
| Replacement financing (EURk) | 2,200 |
| Interest change (EURk) | 481.2 |
| Net debt change (EURk) | 288.72 |
| Cash impact (EURk) | -288.72 |
| Net leverage change (×) | 0.07 |
| Metric | Value |
|---|---|
| Refinancing gap · Synthetische Anschlussfinanzierung | 112.7 |
| Refinancing gap | 2,312.7 |
Annual · Base
| Metric | 2026 Actual | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|---|
| Revenue (EURk) | 12,000 | 12,960 | 13,996.8 | 15,116.54 | 16,325.87 | 17,631.94 |
| Cost of goods sold (EURk) | -6,960 | -7,516.8 | -8,118.14 | -8,767.6 | -9,469 | -10,226.52 |
| Gross profit (EURk) | 5,040 | 5,443.2 | 5,878.66 | 6,348.95 | 6,856.86 | 7,405.41 |
| Other operating income (EURk) | 0 | 0 | 0 | 0 | 0 | 0 |
| SG&A (EURk) | -2,280 | -2,462.4 | -2,659.39 | -2,872.14 | -3,101.91 | -3,350.07 |
| Depreciation & amortization (EURk) | -540 | -540 | -540 | -540 | -540 | -540 |
| EBITDA (EURk) | 2,760 | 2,980.8 | 3,219.26 | 3,476.81 | 3,754.95 | 4,055.35 |
| EBIT (EURk) | 2,220 | 2,440.8 | 2,679.26 | 2,936.81 | 3,214.95 | 3,515.35 |
| Interest expense (EURk) | -150 | -175.58 | -166.79 | -165 | -165 | -150.99 |
| Earnings before tax (EURk) | 2,070 | 2,265.22 | 2,512.47 | 2,771.81 | 3,049.95 | 3,364.36 |
| Taxes (EURk) | -517.5 | -566.3 | -628.12 | -692.95 | -762.49 | -841.09 |
| Net income (EURk) | 1,552.5 | 1,698.91 | 1,884.35 | 2,078.85 | 2,287.46 | 2,523.27 |
| Revenue growth (%) | 8 | 8 | 8 | 8 | 8 | 8 |
| Gross margin (%) | 42 | 42 | 42 | 42 | 42 | 42 |
| Metric | 2026 Actual | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|---|
| Change in receivables | -116.89 | -94.18 | -138.73 | -139.54 | -156.04 | -168.53 |
| Change in inventory | -87.57 | -70.55 | -103.93 | -104.54 | -116.9 | -126.25 |
| Change in payables | 60.74 | 48.93 | 72.08 | 72.5 | 81.08 | 87.56 |
| Change in other working capital | 4.44 | 3.58 | 5.27 | 5.31 | 5.93 | 6.41 |
| D&A add-back | 540 | 540 | 540 | 540 | 540 | 540 |
| Other non-cash items | 0 | 0 | 0 | 0 | 0 | 0 |
| Cash flow from operations | 1,953.21 | 2,126.7 | 2,259.05 | 2,452.59 | 2,641.53 | 2,862.46 |
| Capital expenditure | -780 | -780 | -780 | -780 | -780 | -780 |
| Cash flow from investing | -780 | -780 | -780 | -780 | -780 | -780 |
| Debt issuance | 0 | 0 | 2,200 | 0 | 0 | 0 |
| Debt repayment | 0 | -150 | -2,850 | 0 | 0 | -2,200 |
| Revolver draw / (repayment) | 0 | 0 | 0 | 0 | 0 | 0 |
| Dividends paid | -310.5 | -339.78 | -376.87 | -415.77 | -457.49 | -504.65 |
| Cash flow from financing | -310.5 | -489.78 | -1,026.87 | -415.77 | -457.49 | -2,704.65 |
| Change in cash | 862.71 | 856.92 | 452.18 | 1,256.82 | 1,404.04 | -622.19 |
| Free cash flow | 1,173.21 | 1,346.7 | 1,479.05 | 1,672.59 | 1,861.53 | 2,082.46 |
| Metric | 2026 Actual | 2027 | 2028 | 2029 | 2030 | 2031 |
|---|---|---|---|---|---|---|
| Cash & Cash Equivalents | 3,022.71 | 3,879.63 | 4,331.81 | 5,588.62 | 6,992.66 | 6,370.47 |
| Accounts receivable | 1,578.08 | 1,672.26 | 1,810.99 | 1,950.52 | 2,106.56 | 2,275.09 |
| Inventory | 1,182.25 | 1,252.8 | 1,356.73 | 1,461.27 | 1,578.17 | 1,704.42 |
| Accounts payable | 819.95 | 868.88 | 940.96 | 1,013.46 | 1,094.54 | 1,182.1 |
| Other current assets | 180 | 190.74 | 206.57 | 222.48 | 240.28 | 259.5 |
| Other current liabilities | 240 | 254.32 | 275.42 | 296.64 | 320.37 | 346 |
| Long-term debt | 3,000 | 2,850 | 2,200 | 2,200 | 2,200 | 0 |
| Required revolving funding | 0 | 0 | 0 | 0 | 0 | 0 |
| Property, plant & equipment | 6,240 | 6,480 | 6,720 | 6,960 | 7,200 | 7,440 |
| Other non-current assets | 360 | 360 | 360 | 360 | 360 | 360 |
| Other non-current liabilities | 120 | 120 | 120 | 120 | 120 | 120 |
| Total current assets | 5,963.04 | 6,995.43 | 7,706.09 | 9,222.89 | 10,917.67 | 10,609.48 |
| Total assets | 12,563.04 | 13,835.43 | 14,786.09 | 16,542.89 | 18,477.67 | 18,409.48 |
| Book equity | 8,383.1 | 9,742.23 | 11,249.71 | 12,912.79 | 14,742.76 | 16,761.38 |
| Total liabilities & equity | 12,563.04 | 13,835.43 | 14,786.09 | 16,542.89 | 18,477.67 | 18,409.48 |
Modeling Rationale
Die Refinanzierung verändert den bestehenden Schuldenplan; sie ist kein unabhängiges zweites Modell.
Key assumptions
Ausgangsdarlehen EUR 3m, Fälligkeit Januar 2029. Ersatzfinanzierung EUR 2,2m im Dezember 2028 zu 7,5%; EUR 400k Cash-Tilgung und keine Gebühren.
Notes
Vollständig synthetische Daten eines fiktiven Unternehmens. Keine realen Emittenten oder Marktdaten. Übung: Ersatzbetrag reduzieren und Refinancing Gap, Cash Impact und Zinsänderung prüfen.
Published inputs and structure
Input data uses full functional-currency amounts. Rates retain their native percentage convention. Result tables state their display units in the caption or beside each metric.
- Calendar
Calendar (4)
- Actual Years
- 1
- Calculation
- annual
- Fiscal Year End
fiscalYearEnd (2)
- Day
- 31
- Month
- 12
- Start Year
- 2026
- This line currently uses the existing Simple assumptions.
This line currently uses the existing Simple assumptions. (6)
- Calendar
calendar (2)
- Actual Years
- 1
- Start Year
- 2026
- Currency
- EUR
- Name
- Synthetische Hafenwerk
- Opening debt
opening (13)
- Accounts payable
- 759208.52359209
- Accounts receivable
- 1461187.2146119
- Total assets
- 11242526.636225
- Cash & Cash Equivalents
- 2160000
- Long-term debt
- 3000000
- Equity Value
- 7141095.890411
- Inventory
- 1094672.7549467
- Other current assets
- 166666.66666667
- Other current liabilities
- 222222.22222222
- Other non-current assets
- 360000
- Other non-current liabilities
- 120000
- Property, plant & equipment
- 6000000
- Revenue
- 11111111.111111
- Type
- industrial
- Year view
years (6)
- 0
0 (13)
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Dividend payout / net income
- 20
- Revenue
- 12000000
- SG&A / revenue
- 19
- Tax rate
- 25
- 1
1 (20)
- Ar Adjustment
- 0
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Equipment Purchase
- 0
- Extra DA
- 0
- Extra Dividend
- 0
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Inventory Adjustment
- 0
- Dividend payout / net income
- 20
- Revenue
- —
- Scenario Borrowing
- 0
- Scenario Repayment
- 0
- SG&A / revenue
- 19
- Tax rate
- 25
- 2
2 (20)
- Ar Adjustment
- 0
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Equipment Purchase
- 0
- Extra DA
- 0
- Extra Dividend
- 0
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Inventory Adjustment
- 0
- Dividend payout / net income
- 20
- Revenue
- —
- Scenario Borrowing
- 0
- Scenario Repayment
- 0
- SG&A / revenue
- 19
- Tax rate
- 25
- 3
3 (20)
- Ar Adjustment
- 0
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Equipment Purchase
- 0
- Extra DA
- 0
- Extra Dividend
- 0
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Inventory Adjustment
- 0
- Dividend payout / net income
- 20
- Revenue
- —
- Scenario Borrowing
- 0
- Scenario Repayment
- 0
- SG&A / revenue
- 19
- Tax rate
- 25
- 4
4 (20)
- Ar Adjustment
- 0
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Equipment Purchase
- 0
- Extra DA
- 0
- Extra Dividend
- 0
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Inventory Adjustment
- 0
- Dividend payout / net income
- 20
- Revenue
- —
- Scenario Borrowing
- 0
- Scenario Repayment
- 0
- SG&A / revenue
- 19
- Tax rate
- 25
- 5
5 (20)
- Ar Adjustment
- 0
- Capital expenditure
- 780000
- Depreciation & amortization
- 540000
- Long-term debt
- 3000000
- Days inventory outstanding
- 62
- Days payable outstanding
- 43
- Days sales outstanding
- 48
- Equipment Purchase
- 0
- Extra DA
- 0
- Extra Dividend
- 0
- Gross margin
- 42
- Revenue growth
- 8
- Interest rate
- 5
- Inventory Adjustment
- 0
- Dividend payout / net income
- 20
- Revenue
- —
- Scenario Borrowing
- 0
- Scenario Repayment
- 0
- SG&A / revenue
- 19
- Tax rate
- 25
- Objects
Objects (0)
- Driven by Advanced Model
Driven by Advanced Model (0)
- Financing
Financing (5)
- Auto Repay
- false
- Automatic
- true
- Facilities
facilities (2)
- Facility 1
facility-1 (10)
- Comment
- Commitment
- 3000000
- Id
- facility-1
- Loans
loans (1)
- Facility 1 loan 1
facility-1-loan-1 (8)
- Amortization
- 150000
- Comment
- Events
events (0)
- Id
- facility-1-loan-1
- Maturity date
- 2029-01-01
- Name
- Senior term loan
- Opening debt
- 3000000
- Interest rate (%)
- 6
- Maturity date
- 2029-01-01
- Name
- Senior term facility
- Priority
- 1
- Start date
- —
- Status
- committed
- Type
- term
- Seed rcf
seed-rcf (10)
- Comment
- Commitment
- 1000000
- Id
- seed-rcf
- Loans
loans (1)
- Seed rcf loan 1
seed-rcf-loan-1 (8)
- Amortization
- 0
- Comment
- Events
events (0)
- Id
- seed-rcf-loan-1
- Maturity date
- —
- Name
- Loan 1
- Opening debt
- 0
- Interest rate (%)
- 7
- Maturity date
- —
- Name
- Committed working capital line
- Priority
- 1
- Start date
- —
- Status
- committed
- Type
- revolver
- Minimum Cash
- 500000
- Version
- 1
- Refinancing
Refinancing (2)
- Cases
cases (1)
- Seed refi
seed-refi (12)
- Active
- true
- Amount / quantity
- 2200000
- Cash Paydown
- 400000
- Comment
- Date
- 2028-12-01
- Equity Value
- 0
- Fees
- 0
- Id
- seed-refi
- Name
- Synthetische Anschlussfinanzierung
- Replacement financing
replacement (8)
- Amortization
- 0
- Commitment
- 2200000
- Facility Id
- —
- Maturity date
- 2031-12-01
- Model detail
- new
- Name
- Replacement Senior term loan
- Interest rate (%)
- 7.5
- Type
- term
- Source Facility Id
- facility-1
- Source Loan Id
- facility-1-loan-1
- Version
- 1
Report model
Reports are private. A valid investment-recommendation report temporarily hides author text while the financial model remains available. Previously reviewed and approved text is not hidden again automatically; new evidence and formal notices remain reviewable. Do not include unnecessary personal information.
Related models
IONOS Group (IOS) — Hosting, Cloud & Cash Generation 2026–2030
IOSA financial model and stock analysis of IONOS Group SE (Xetra: IOS), covering revenue, profitability and cash flow forecasts from 2026 to 2030. Explore how recurring web hosting revenue, cloud growth, infrastructure investment and restructuring affect EBITDA, EBIT and free cash flow. The model includes linked financial statements, Base, Bear and Bull scenarios, and an EV/EBIT valuation framework. Key assumptions are explained directly in the model and can be adjusted or forked.
SUSS MicroTec (SMHN) — Backlog, Cash Flow & Stock Analysis 2026–2030
SMHNA linked financial model of SUSS MicroTec’s Advanced Backend and Photomask businesses. Explore how order conversion, equipment mix, development spending and customer advances affect revenue, EBITDA, EBIT and cash across Base, Bear and Bull cases. Stock Analysis links a 2028 EV/EBIT framework to the operating model.
PVA TePla (TPE) — Stock Analysis & Operating Scenarios 2026–2030
TPEExplore PVA TePla through linked 2026–2030 financial projections, DCF and Stock Analysis. Metrology and Material Solutions delivery assumptions drive earnings, project working capital and explicit funding across Base, Bear and Bull. Native Comment buttons explain revenue, margins, capex and borrowing; reported FY2023–2025 statements are embedded as historical references. Start from audited FY2025 balances, inspect the reasoning, change a driver and fork the model for your own analysis.
Synthetic Valuation Works — football field
A connected comparison of DCF, synthetic trading multiples and synthetic acquisition multiples.