Sinu AI-oskuste, juhiste ja promptide käsiraamat.
Abstract contracts into structured, page-cited records covering parties, term, change-of-control, termination and risk flags.
Audit a deal data room against a standard diligence checklist and surface missing, stale, or inconsistent items as a traffic-light gap report.
Review environmental, social and governance exposures from the materials provided and score the top issues with an overall ESG rating.
Turn seller-provided financials into a clean, add-back-adjusted LTM EBITDA with a transparent reported-to-normalized bridge.
Review legal and regulatory diligence — corporate records, litigation, licensing and change-of-control — into a jurisdiction-specific risk assessment.
Review operational diligence and quality-of-earnings to surface operational gaps and build a 100-day post-close plan.
Build and maintain a structured single-family-office relationship profile — principals, advisers, jurisdictions, asset mix and pain points.
Produce a family-office × service coverage matrix to surface white space and concentration across the whole book.
Creates a structured assumption register for any Excel model with columns for name, category, base value, source, Bull/Bear values, sensitivity rank, and owner, plus a formula for computing sensitivit…
Turns pasted or exported data with mixed formats, blank rows, or duplicates into a clean, consistently formatted range ready for analysis. Use it right after pasting raw data into a worksheet.
Provides a systematic audit checklist for Excel model formula logic, hardcoded values, circular references, and error handling, with step-by-step instructions for using Excel's native auditing tools.
Enforces the three-tab separation principle for any Excel model, producing a full design for a dedicated Inputs tab, one or more Calculations tabs, and a clean Outputs tab with a conventions checklist…
Defines the master tab structure, naming conventions, color codes, number formats, and print area setup for any new strategy or finance Excel model, serving as the structural template before any conte…
Designs the executive summary tab of an Excel model with KPI tiles, a narrative block, a sensitivity summary, and an assumption log, formatted for print or screenshot use in a board pack.
Specifies and builds a pivot table from a flat data range, choosing rows, columns, values, and filters. Use it when you have raw tabular data and need a summary view without building it cell by cell.
Builds a driver-based revenue forecast .xlsx with live formulas across separate drivers, build, and output tabs plus checks, rolling a customer or units schedule (beginning, adds, churn, ending) into…
Builds a Base/Bull/Bear scenario switching layer for a model in a .xlsx with a live selector, CHOOSE or INDEX assumption links, a side-by-side output comparison, and a recalc check, then delivers the…
Builds one- and two-variable sensitivity (Data Table) analysis on a model output in a .xlsx with live formulas and a recalc check, then delivers the workbook.
Ranks variable sensitivities to a key output and builds a tornado chart by swinging each input over a defined range, computing output impact, and producing a horizontal bar chart data structure.
Builds a unit-economics and cohort .xlsx with live formulas across separate assumptions, cohort, and output tabs plus checks, computing CAC, LTV, LTV/CAC, and CAC payback from a monthly cohort retenti…
Produce a full investment-committee memo from a deal's data, with a standard section structure and every quantitative claim tied to a source.
Write a professional quarterly LP letter covering fund metrics, deployment, portfolio performance, outlook, and capital activity from fund data provided.
Assess a company's readiness for a public listing across financials, governance, equity story and process — with a gap list and timeline.
Review a draft investor press release against securities disclosure rules and return a compliance verdict with specific required edits.
Plan the distribution of a finalized investor press release across wire services, exchange notifications, media, owned channels and timing.
Assess whether an event, news item or rumor is material enough to require disclosure, and recommend urgency, channel and next steps.
Turn an approved draft press release into a wire-ready, exchange-formatted publication package with a pre-publish checklist.
Draft a publication-ready corporate press release from a topic and supplied facts, with placeholders for anything that cannot be verified.
Generate explainable service-gap and cross-sell recommendations for a family-office relationship, with every recommendation traceable to a rule.
Draft a concise, personalized deal-sourcing email that weaves in specific financials and a clear ask, tailored to founder, broker, or intermediary.
Rank LP prospects by mandate fit, staleness, and commitment size, then draft the next personalized outreach for the strongest targets.
Plan and draft a five-touch email sequence with rotating copywriting frameworks for deal sourcing or LP fundraising, each touch adding new value.
Roll up next-action urgency across the investor-outreach funnel and surface the consultation calendar so nothing goes cold.
Draft tailored proposal text for a family-office service recommendation, grounded in the relationship profile and the specific gap being addressed.
Design deal structure and bid tactics — consideration mix, earnouts, escrow, risk allocation, and a competitive bid ladder.
Identify and prioritize strategic and financial buyers for a sell-side process, with mandate fit and first-round outreach targets.
Produce a clean, decision-ready company profile covering business model, key financials, sector multiples, signals, and the M&A angle.
Draft advisor-grade, human-approved outreach to corporate development and M&A contacts, with a concrete synergy hook and a follow-up cadence.
Build a five-year discounted cash flow valuation with explicit assumptions, a WACC bridge, an equity bridge, and a sensitivity grid.
Score the synergy fit between a specific buyer and target across five weighted dimensions, producing a composite score and a clear recommendation.
Create a concise two-page investment teaser for co-investor or LP distribution, with an option to blind names.
Build a post-close integration plan with a day-one checklist, 30-60-90-day milestones by workstream, synergy tracking, and governance.
Draft a clear, non-binding letter of intent for an acquisition, with valuation, structure, conditions, and exclusivity.
Build and prioritise a buyer/acquirer long list for a sell-side M&A mandate, with fit rationale and outreach angle for each name.
Shape the equity story and CIM narrative for a sell-side mandate — value drivers, growth thesis and defensible positioning.
Score buyer-target compatibility across seven weighted synergy dimensions to produce a composite score and a clear buy/pass recommendation.
Apply trading and precedent-transaction multiples to derive an EV range, with an implied-EV table, equity bridge, and a defensible headline range.
Analyze reverse mergers, RTOs, CPC qualifying transactions, and SPAC/de-SPAC combinations, anchored in filings and distinguishing facts from open items.
Quantify revenue and cost synergies between a buyer and target, with timelines, costs to achieve, NPV, and the post-synergy effective multiple.
Find acquisition targets that match a buyer's mandate, ranked by fit, with transparent size and ownership evidence and next diligence steps.
Build an asset-based borrowing base by collateral pool and return eligible collateral, advance rates, reserves, availability and overadvance.
Classify each covenant, compute actual-versus-threshold headroom, project the first breach, and recommend lender action.
Draft an investment-committee-ready lender credit memo with recommendation, structure, risk analysis, covenants and monitoring plan.
Screen a private-credit opportunity for mandate fit, coverage, structure and key risks, returning a pursue/review/decline decision.
Evaluate a private-credit portfolio for weighted yield, expected loss, concentration breaches and rebalancing suggestions.
Monitor a private-credit book against budget and underwriting case, producing a prioritized watchlist with triggers and actions.
Build contractual lender cash flows and pricing for a debt facility, returning the schedule, lender yield/IRR and sensitivities.
Size a leveraged capital structure across senior, unitranche, mezzanine, seller note and revolver, with leverage, coverage and refinance sensitivity.
Score obligor default risk and facility loss severity, returning an internal grade, PD, LGD, EAD, expected loss and the key drivers.
Extract credit-document terms into a structured table with citations, flagging exceptions, ambiguities and gaps against the approved term sheet.
Underwrite a property-backed or direct-lending private-credit deal — LTV, coverage, security, covenants and a risk-adjusted pricing view.
Value a private-debt instrument on a market-participant DCF basis with a mark bridge and sensitivities to yield, PD and recovery.
Model going-concern and liquidation recoveries by tranche, identify the fulcrum security, and report LGD under base, downside and severe cases.
Build a 13-week liquidity view and compare workout paths on probability- and time-adjusted recovery, cash needs, consents and risks.
Deliver a fast Go / No-Go / Dig-deeper verdict on a deal, backed by concrete evidence on valuation, quality, and risk.
Build a five-year base-case leveraged buyout model with editable assumptions, a returns summary, and a sensitivity grid.
Surface and rank deal opportunities that match a fund mandate across check size, sector, geography, and deal type.
Score companies by their likelihood of a sale in the next twelve months and rank the best targets for outreach.
Screen a private-equity opportunity against a fund's mandate and return a structured go/no-go with the key diligence questions to pursue.
Compute levered and unlevered IRR, MOIC, and equity multiple, then decompose returns into a value-creation bridge.
Map national or standard industry-classification codes to a firm's internal sector and sub-sector taxonomy and to named business verticals for screening.
Build a tight, defensible set of transaction and trading comparables to benchmark EV/EBITDA and EV/Revenue multiples.
Run structured research on a company, sector or theme from the sources provided and synthesize findings with citations.
Search, summarize and extract structured data from SEC EDGAR filings the user provides, with citations back to the source filing.
Analyze institutional ownership from SEC Form 13F filings the user supplies to explain fund positions, concentration and activist stakes.
Analyze corporate press releases the user provides to extract material information, classify event types and assess likely market impact.
Rank capital projects across a property or portfolio by return and urgency, flagging projects that compete for the same crew or capital budget.
Surface environmental exposures on a property that could affect value, financeability or exit, sorted by severity with next-step recommendations.
Read lease documents and produce structured lease abstracts with key economic and legal terms, page-level citations and red-flag callouts.
Surface material operating-expense variances against budget or prior period and infer the likely driver of each, prioritized by size.
Read property condition and inspection reports to build a prioritized deferred-maintenance and improvement plan with cost and timing estimates.
Recommend a staged rent plan for renewals and new leases by identifying under-priced units against market, with estimated income impact and churn risk.
Turn a raw rent roll into a clean occupancy and income snapshot with unit-level detail, lease status and red flags.
Score each tenant's renewal likelihood from lease economics and tenure, then prioritize retention outreach for the highest-risk tenants.
Review title, zoning and land-use records for a property to surface encumbrances, entitlement gaps and material exposures before closing.
Track legal-entity filing obligations, deadlines and FATCA/CRS/W-8 readiness across multiple jurisdictions for a family-office structure.
Citation-aware tax-law Q&A with provenance over ingested forms, legislation and treaties (RAG) — every answer cites its source.
Activate for ANY pitch deck analysis, feedback, or review request. Triggers include: "analyze this deck", "review my pitch deck", "critique my pitch", "feedback on my slides", "is my deck investor rea…
Model cap table dilution, SAFE conversion, and exit waterfall across scenarios. Triggered by: "/venture-capital-intelligence:cap-table-waterfall", "model my cap table", "simulate dilution", "SAFE conv…
Scan a company or sector for deal-sourcing signals across 6 dimensions. Triggered by: "/venture-capital-intelligence:deal-sourcing-signals", "scan signals for X", "what signals is X showing", "deal so…
Activate for ANY equity, legal, or term sheet question related to startup investing or fundraising.
Run deterministic financial models for startup valuation and SaaS health analysis.
Compute fund KPIs (TVPI, DPI, IRR, MOIC), model carried interest and management fees, and generate LP quarterly update narratives.
Deterministic Python-scored startup screening with full audit trail. Use when you need a reproducible, weighted-score verdict on a startup — not just a qualitative opinion.
Run TAM/SAM/SOM market sizing with top-down and bottom-up methods, competitive landscape, and tech stack analysis.
Activate for ANY startup evaluation, investment screening, or company assessment. Triggers include: "evaluate this startup", "screen this company", "should I invest in X", "is this a good investment",…
Model a venture financing round — pre/post-money, option pool, SAFE conversions and founder/investor dilution across the cap table.