Choose Your File

Upload your filled SEC_Input_Template.xlsx and all fields will be automatically mapped to the form. You can then review, edit, and generate the PPTX.

Advisory Workflow
From raw client input to a lender-ready narrative in one controlled workspace.
A cleaner experience for structuring, validating, shaping and exporting investor-grade materials without the visual clutter of a generic internal tool.
01
Import
09
Workstreams
PPTX
Final Output
Execution Standard
Built to feel less like an admin form and more like a polished deal room for analysts, associates and partners.
Structured Intake
Company facts, transaction terms, financials and ownership captured in a single editorial flow.
Decision Clarity
Each module now reads like a curated workstream instead of a dense spreadsheet wrapper.
Presentation Finish
Visual hierarchy, spacing and contrast tuned for an institutional finance audience.
Choose Your File
Choose your file
or drag and drop — accepts .xlsx files
How it works
  • Upload your filled SEC_Input_Template.xlsx
  • All cells are read and mapped to form fields (Input sheet + Credit Metrics fallback)
  • Review the data in each section, make edits if needed
  • Click Generate PPTX to create the one-pager

Supported cells: C2-C7 (company), C10-C17 (exec summary), C19-C24 (transaction), D24-F32 (group financials), C97-C100 (entity names/consolidation), D102-F119 (solo+borrower financials), C34 (footnote), C36-C48 (ownership), C51-C55 (products), B65-E70 (exports), B76-C95 (terms), B143-E148 (banks)

Company Information

Basic information about the borrower and the facility being arranged.

Borrower Details

Executive Summary

Suggested 5 bullets (expandable to 8): 1) Sector & track record, 2) Group companies, 3) Export profile, 4) Shareholders, 5) Facility details. Keep each under 200 characters for best layout.

Summary Bullets

Transaction Information

Key details about the transaction structure.

Transaction Details

Financial Data

Three entities, three years each. Charts use Group Consolidated data. KPI table shows all entities with data. Monetary values in 000s, percentages as decimals (0.15 = 15%).

Fiscal Year Labels
Group Consolidated (VUK) — used for charts
Year 1
Year 2
Year 3
Revenue (000s)
EBITDA (000s)
EBITDA Margin (decimal)
Net Debt (000s)
ND / EBITDA (ratio)
Interest Coverage (ratio)
DSCR (ratio)
Export Revenue % (decimal)
Footnotes & Consolidation

Ownership Structure

Define the corporate hierarchy: UBO → Holding → Subsidiaries. First subsidiary is treated as the Borrower.

Corporate Hierarchy
Subsidiaries (first = Borrower)
Ownership Narrative

Products & Operations

Slide 1 shows 2 bullets: Product Description + Revenue Split. Slide 2 shows all sections as detailed text. Each field gets a bold title in the PPTX.

Product Details

Export Geography

Define export destinations as percentage of total revenue. Chart will show "Destination — X%" format. Shares should sum to ~1.0.

Export Destinations
Destination Volume Share (0-1)

Terms & Conditions

Indicative terms for the facility. Each row becomes a row in the terms table.

Term Sheet
Label Value

Bank Exposure & Collateral (Group Consolidated)

Group consolidated banking relationships and exposure details. A footnote will appear below the table in the PPTX.

Banks
Bank Name Limit Outstanding Collateral
Totals
Footnote (appears below bank table in PPTX)

Financial Analysis

Data flows automatically from Transform to Analysis. No manual input required here.

Data Source

Financial data is auto-populated from the Transform module after file processing.

Waiting for data from Transform...

Financial Modeling & Valuation

DCF, Trading Comps, Precedent Transactions, LBO Screen — all-in-one valuation toolkit.

Load Financial Data

Financial Analysis data is synced automatically to populate assumptions.

Growth & Margin Assumptions
WACC Components
US 10Y Treasury
Damodaran implied ERP
CDS-implied
Sector-specific
Duff & Phelps micro/small-cap
Auto: Interest / Total Debt
Auto: Total Debt / Equity
Terminal Value & DCF Settings
Long-term GDP growth (USD)
Turkish mid-market industrial
LBO Quick Screen Parameters
Method Weighting
Anchor value if terminal assumptions are robust
Market-based triangulation
Control-value reference set
Configure assumptions and click "Run Valuation Model" to generate projections.
5-Year Financial Projections (TRY 000)
Revenue & EBITDA Forecast
Run the valuation model to see DCF analysis, WACC breakdown, and sensitivity tables.
WACC Calculation
Free Cash Flow to Firm Schedule
Enterprise Value Bridge
Sensitivity: WACC vs Terminal Growth Rate (Enterprise Value, TRY 000)
Comparable Companies
CompanyEV/EBITDAEV/RevenueP/E
Valuation Discounts (Turkish Private Company)
Private company, no market
Mid-market adjustment
Only for international peers
Precedent Transactions
TargetAcquirerYearEV/EBITDAEV/Revenue
Run the valuation model to see LBO returns analysis and debt paydown schedule.
Entry
Exit
Debt Paydown Schedule
IRR Sensitivity: Entry Multiple vs Exit Multiple
Run the valuation model to see the football field, tornado chart, and scenario analysis.
Valuation Football Field (TRY 000)
Sensitivity Tornado (EV Impact, TRY 000)
Scenario Analysis

Capital Advisory Workspace

Simple first screen with point-in-time view. Use year and perspective filters to move between company and group context.

Loading...
Workspace Context

Capital Timeline

Year-by-year events up to the selected as-of year. Keeps history contextual and avoids data overload.

Loading...

Capital Transactions

Deals and financing events with simple year/type/search filters.

Loading...

Capital Structure Map

Simple org and role view for holdco, borrower and subsidiaries as of selected year.

Loading...

Financial Data Transformation

Upload client financial files (VUK Excel, BDR PDF, Mizan) and automatically transform into the standardized VUK Raw Data format.

One Pager + Analysis + Valuation alanlarini tek tikla gercekci test senaryosuyla doldurur.

1. Upload Financial Document

Drop file here or click to browse
Supports: .xlsx .xls .pdf (VUK, IFRS/BDR, Mizan)
Eşleşmeyi Düzelt
Alternatif eşleşmeler:
Manuel VUK kodu gir:

Generate One-Pager

Review validation status and generate the PPTX presentation.

Forecast Engine

Request sector, macro, valuation, credit and modeling insights through the SEC Forecast Engine.

Checking...
SEC Finance in Seconds

Forecast Engine

Web search, TCMB macro data, sector playbooks, financial ratio computation — all with real-time data.

Presentation Verbal Assistant

Secure RAG workflow: ingest company folders, retrieve relevant evidence, generate verbal sections with citations, then complete human review.

1) Secure Ingestion
2) Brief, Retrieval, Generation
3) Human Review & Finalize

Forecast Engine

Connected

Forecast context is live

Request financial evaluation, assumption checks, or metric explanations.