Project 01 · Financial AI · Local LLM Systems
Cadence: private financial intelligence from public earnings call transcripts.
A working local-first AI tool that turns an earnings call transcript into a structured executive dashboard in about 60 seconds, fully on-device, with no cloud API call.
Premise: public companies file 4 earnings calls a year, over 2,000 S&P 500 calls annually, each 15,000–25,000 words of dense forward guidance, risk disclosures, management tone, and KPI prints. Today the options are bad: manual analyst review (2–4 hours per call, subjective, can't scale across a portfolio), expensive analyst-product subscriptions (Bloomberg, FactSet, AlphaSense), or cloud-API LLMs that send market-sensitive transcripts to a third party. Each option fails on at least one of speed, cost, privacy, or scale.
A working local-first AI dashboard: ingest a transcript (.txt or .pdf) and return a structured executive view in about 60 seconds on a CPU-only laptop, no GPU required. Output: executive summary with green / amber / red sentiment badge, KPI cards (sentiment, confidence, theme count, risk count), theme-importance bar chart, risk-severity heat chart, bull / bear case decomposition, and evidence quotes with tag pills. Stack: Streamlit + Ollama running Qwen2.5 7B-Instruct + Python PDF parser + JSON-schema constrained decoding + Plotly. The product point is the local-first tradeoff: cloud APIs answer faster (about 5s against 2–4 min) and reason more deeply, while local inference keeps the transcript on the machine, runs at zero marginal cost, holds up offline, and gives full control over prompt and schema. North-star: time-to-insight per call. Counters: summary accuracy, hallucination rate, schema-drift incidents, analyst-override rate.
Concept for
Bloomberg
FactSet
S&P Global
AlphaSense
Morgan Stanley
Snowflake
Local LLM · Financial AI · Privacy-first AI
60s time-to-insight · $0 per call
Project 02 · Digital Transformation · Financial Services
Vanguard: cost-to-income transformation at a mid-cap bank.
Eighteen-month digital-operating-model transformation at a Canadian mid-cap bank, recovering about $300M / yr in run-rate cost-to-serve through self-serve-by-default journey routing.
Premise: Canadian mid-cap banks (Laurentian, EQB and similar in the $30–70B asset range, the cohort having thinned after the CWB and HSBC Canada acquisitions) sit at cost-to-income ratios in the 60%+ range, against below 50% for top-quartile peers and 40–50% for leading digital banks (directional, from public filings and practitioner interviews). They already spend on technology; the gap is an operating model that still routes 70%+ of customer journeys through branch and call-center while challengers route 80%+ through self-serve. Recovering even half the gap means roughly $300M / yr in run-rate cost-to-serve at this scale.
Vanguard is an 18-month digital-operating-model transformation: a cost-to-serve diagnostic by customer journey (originations, servicing, claims-of-error, lending decisions), target-state operating model design with self-serve-by-default routing, vendor and platform strategy (cloud-core vs. legacy mainframe), and an agile pilot program on the three highest-volume journeys. North-star: cost-to-income ratio movement (basis points) by quarter. Counter-metrics: NPS by journey (cannot decline by more than 2 pts), digital-channel adoption rate by segment, and operational-risk-event frequency. Wedge: replatform the originations journey first, where the ROI is clearest and the risk surface is best contained.
Engagement for
Oliver Wyman
McKinsey FS
BCG FSP
EY-Parthenon FS
Cost-to-serve · Operating model · Digital
$300M / yr run-rate target
Project 03 · Markets · Strategy & Product
Manifold: standing up a new market for a market-maker.
A Strategy & Product market-entry engagement: take an electronic market-maker into North American natural gas, financially-settled basis first, by clearing every operational, regulatory, and infrastructure launch-blocker before the first quote.
Premise: a leading electronic market-maker wants into North American natural gas. The pricing edge is the easy part. Entry is gated by three things a trading model never touches: a market structure that trades as an exchange-and-OTC hybrid priced off Henry Hub plus a lattice of basis hubs; an operational and regulatory stack (CFTC position limits, large-trader reporting, ISDA onboarding, and, for physical, FERC and pipeline scheduling); and connectivity, curve construction, and risk systems that have to speak basis, not just outright. The pricing model is the straightforward part. The launch risk sits in the plumbing around it.
Manifold runs the entry as a sequenced Strategy & Product engagement rather than a big-bang launch: shadow the desk and map the microstructure, scope the operational, regulatory, and technical integration against a single go-live date, then ship a thin-slice pilot, one liquid hub, financially-settled and cleared only, with physical deferred behind its own gate. Each workstream resolves to a weekly go / no-go with named launch-blockers, routed through a readiness frame of three gates and three states each. North-star: time-to-first-quote on a single hub. Counter-metric: zero physical exposure in the pilot, so delivery obligations stay out of scope until they earn their own gate.
Concept for
Jane Street
Citadel Securities
Optiver
IMC
DRW
Market structure · Strategy & Product · Market entry
1 hub · financially-settled pilot
Project 04 · Commercial Due Diligence · B2B SaaS / PE
Cipher: commercial diligence on a $400M vertical-SaaS target.
Four-week commercial diligence sprint on a $400M-ARR vertical-SaaS target: TAM triangulation, cohort retention read, competitive-moat test, partner-grade IC memo.
Premise: a North American mid-market PE acquirer is evaluating a $400M-ARR vertical SaaS company serving construction-trades businesses. Three things are unverified in the seller's materials: (1) the TAM number assumes the trades-software TAM is undifferentiated, when in fact the addressable wedge is 25% of the headline figure; (2) NRR of 122% is real, but cohort-level retention is degrading at the lower end of the customer base, signaling pricing-power compression; (3) the competitive moat is described as "feature breadth" but reference calls suggest the moat is actually integration-density with a fragmented field-service tooling ecosystem.
Cipher is a four-week commercial diligence sprint: customer reference call program (40 calls, weighted by ACV cohort), bottom-up TAM triangulation against three independent data sources, win/loss analysis against the four most-cited competitors, and a pricing-power test using the seller's own discount-and-uplift data. The deliverable is a partner-grade memo with a bear/base/bull recommendation and explicit deal-modifier flags (price chip, structure change, walk-away). North-star deliverable: a recommendation the IC can vote on without further analytical work; a clear answer to "what would have to be true."
Engagement for
Bain DD
OC&C
L.E.K.
EY-Parthenon
DD · TAM · Competitive moat
$400M target · 4-week sprint
Project 05 · Fintech SaaS · Agentic AI
Copilot Ledger: agentic bookkeeping for SMBs.
Agentic SMB bookkeeping built around the licensed accountant: signed audit trail, materiality-routed approval queue, channel-led GTM through firms.
Premise: SMB bookkeeping is a $25B+ category in North America, dominated by QuickBooks Online (about 80% share) and a long tail of bank-rule-based reconciliation. The category is overdue for an agentic rewrite, though the dominant pattern (full-autonomy "AI accountant") gets the regulatory model wrong: in the US and Canada, signed financial statements require a licensed accountant of record. The product wedge keeps that accountant as the signer and makes them 5× faster on the low-judgment 80% of the work.
Copilot Ledger is an agentic AP/AR + close + reconciliation product designed around the licensed accountant. Agents take responsibility for transaction categorization, vendor matching, and invoice intake; humans approve materiality-flagged exceptions, sign the close, and respond to client questions. Every agent action emits a signed audit trail (action + supporting documents + accountant reviewer ID) so the work product is defensible to the IRS, CRA, and PCAOB-style audits. GTM is channel-led: licensed-accountant firms (Intuit ProAdvisor, CPA.com partner channel) sell into their SMB book of business. North-star: close days saved per accountant per month. Counters: material misstatement rate per 10,000 transactions (cannot exceed manual baseline), audit-trail completeness, and accountant-override rate.
Concept for
Intuit
Sage
Xero
FreshBooks
Agentic AI · Channel GTM · Audit-grade
$25B SMB accounting TAM
Project 06 · Cloud Data · Marketplaces
Lakehouse Marketplace: governed data exchange across clouds.
Cross-cloud governed data exchange: usage-based metering, clean-room privacy by default, agent-aware policy enforcement at query time.
Premise: every Fortune 1000 enterprise runs 50–500 ongoing data exchanges; median time-to-production is 14 weeks at $80K–$300K per exchange per year. Platforms like Snowflake Marketplace, AWS Data Exchange, and Databricks Marketplace solved discovery; they stop short of the four hard problems that follow: cross-cloud federation, regulated-data clean rooms, producer-side monetization, and (newly urgent) agent-aware policy enforcement at query time.
Turns data sharing into a six-minute listing: usage-based metering at the credit-consumption level, clean-room privacy by default, cross-cloud federation as the architectural default, and a query-time policy plane that lets producers grant AI agents the same access as humans without losing row/column-level controls or lineage. Producer console treats every dataset as a SKU; consumer experience is "subscribe in 30s, query in 5min." Every agent query carries a signed audit record back to the data owner: the policy layer is the moat that makes regulated-data sharing safe enough to scale. North-star: compute revenue attributable to shared listings ($M / quarter). Liquidity counters: % listings with > 5 active subscribers, time-to-first-query, clean-room workloads / quarter, and policy-violation incidents per million queries (audited monthly). Wedge: convert customers' largest in-flight bilateral data exchanges into platform-listed SKUs.
Concept for
Snowflake
Databricks
AWS
Microsoft
Sharing · Clean rooms · Governance
$2.9B ARR ceiling
Project 07 · D2C Insurance · Post-sale Lifecycle
Lifeline: the customer account as a renewable product surface.
Post-sale customer account run as a product surface owned by Product: life-event signals turn into coverage-gap nudges and cross-sell loops, NRR > 118%.
Premise: D2C insurers spend $400–$900 fully-loaded CAC per bind, absorb heavy early lapse, and convert under 6% into a second product over the lifetime. Every life event that should change coverage (marriage, child, mortgage, salary jump, divorce, claim) is observable in the customer's life and invisible to the carrier; the customer account UI is a PDF download and a billing date. Cross-product attach sits in the marketing budget instead of the product surface, and claims, the moment of highest emotional bandwidth, run through ops as a cost center when product could treat them as a growth event.
Lifeline turns the post-sale surface into a product owned by Product, not Marketing. Three surfaces, one event spine: the customer account shows current coverage against detected life context with one-tap adjust within risk class; the CS console shows the same context with a drafted next-best-action, audit-trailed; the claim flow is instrumented as the highest-NPS moment in the product. Open-banking, payroll, and customer-declared signals enter as signed envelopes; an immutable audit ledger doubles as the experimentation substrate, regulator-grade. North-star: net revenue retention on the existing book, audited monthly against a hold-out cohort: NRR > 118% from book actions alone. Counters: coverage-gap precision > 92%, cancel-save rate > 22% (catches nudge fatigue), claim-NPS > 65.
Concept for
PolicyMe
Wealthsimple
Lemonade
Ladder
Lifecycle · Retention · Cross-sell
$118M / yr per-carrier uplift
Project 08 · Search & Ads · Agentic Commerce
Atlas: when search becomes action.
Parallel ad auction over agent-readable inventory, with cryptographic receipts and a 35% publisher revenue share, capturing the $12B / yr stranded as agents replace clicks.
Premise: search ads rest on assumptions that are breaking: a human reads the SERP, a click signals real intent, and publishers share the upside. By 2027–28, projected ≥30% of high-intent commercial sessions will be at least partially agent-mediated (Gartner / eMarketer agent-commerce forecasts); ad and publisher revenue from those sessions is currently zero.
Atlas is a parallel ad platform: human SERP (existing inventory, defended) and agent inventory (a new auction over agent-readable units). Agents return cryptographically-signed receipts for downstream conversions, so verified attribution becomes a contractual artifact. Publishers whose content informed an agent's answer collect a defined revenue share (a 35% pool, daily-granular, exposed in a publisher console). North-star: verified agent-mediated conversions / week. Counter: brand-safety incidents per million impressions, capped at 1.5. Sequencing: publish the open Agent Ad Protocol before the bidder ships; own the standards layer first, the auction second.
Concept for
Google
Microsoft (Bing)
OpenAI
Anthropic
Adobe
Ads · Agentic commerce · Standards-first
$12B / yr stranded value
Project 09 · Creator Economy · Marketplaces
Loop: creator monetization that compounds.
Mid-tail creator earnings as a financial product: viewer-subscription-funded floor with ±10% next-month prediction SLA, brand-safety AI defensible to a CMO.
Premise: mid-tail creators (50K–2M followers) on short-form platforms earn $400–$2,800 / month at a coefficient of variation north of 0.7. Their churn comes from financial-planning collapse rather than low reach: 18–25% quarterly churn forces platforms to spend 2–4× LTV reacquiring replacement supply. Unpredictability is the real driver.
Loop turns creator earnings into a stable monthly floor: predicted within ±10%, funded from viewer subscriptions, with brand-safety AI that's defensible to a CMO. Treat earnings as a financial product: stable floor + variable upside (performance ads + brand sponsorships, matched at content-embedding level). Per-creator algorithmic transparency in a console committing to ±10% on next-month floor. Recommender PM craft: balance creator/viewer/advertiser metrics as one objective. North-star: median mid-tail subscription floor ($/mo). Counters: brand-safety incidents per million impressions (CMO leaves at 2.0); floor-prediction accuracy (> 92%); paired-cohort q-churn (< 12% vs 22% control).
Concept for
Meta
TikTok
YouTube Shorts
Snap
Marketplace · Recommender · Brand-safety AI
$235B / yr mid-tail flow
Project 10 · Cloud FinOps · Enterprise SaaS
Aperture: workflow-shaped FinOps for enterprise infrastructure.
Multi-account enterprise cloud-cost intelligence sequenced as a workflow product (commitment engine, chargeback inverter) rather than a dashboard. Audit pressure becomes the wedge.
Premise: Fortune 500 cloud spend has crossed $400B / yr aggregate, growing 25–35% YoY. The dominant tooling pattern (cloud-native cost dashboards plus a long tail of FinOps point tools) has plateaued in value capture: enterprises that have run a FinOps program for > 18 months still report 25–40% of cloud spend as untagged, mis-allocated, or under-utilized. The next-leg unlock is workflow-shaped intelligence that converts cost insight into named owner actions with named due dates.
Aperture is a workflow-shaped FinOps product: a commitment engine that converts on-demand spend into right-sized reserved + savings-plan portfolios with named-owner accountability and chargeback rails by business unit; a chargeback inverter that lets engineering leaders see their team's cloud spend the same way Finance sees the bill; and a tagging lookahead that flags untagged resources at provision time, before the month-end audit. Audit pressure (SOC 2, ISO 27001, cloud-spend disclosure under SEC Reg S-K) becomes the wedge that converts the buying center from "cost saver" to "compliance lever." North-star: committed-vs-on-demand spend mix by quarter. Counters: tag completeness at provision, untagged spend / total spend, and time-to-fixed once a savings opportunity is named.
Concept for
Snowflake
Datadog
CloudHealth
Apptio
FinOps · Workflow · Compliance wedge
$400B / yr aggregate spend
Project 11 · Private Equity · Fund Commitments
Keystone: commit or pass on a $2.5B mid-market buyout Fund V.
A six-week LP underwrite of a buyout re-up: track-record decomposition, public-market-equivalent (PME) benchmarking, and a value-creation attribution, delivered as a sized commit/pass to the investment committee.
Premise: a pension plan's private-equity program is offered a $75M commitment to Fund V of an incumbent North American lower-mid-market buyout manager. A re-up is the default; the diligence job is to falsify it. Three priors must be priced independently: a 56% fund-size step-up ($1.6B to $2.5B) that tends to compress relative returns and can invite style drift up-market; a realized return stack still leaning 40% on multiple expansion, a tailwind that's hard to count on in a higher-rate regime; and a largely-unrealized Fund IV whose 1.7x TVPI is still a paper mark.
Keystone underwrites the manager rather than the marketing: an independently rebuilt deal-by-deal cash-flow model (KS-PME, direct alpha, loss ratio, gross-to-net bridge), a value-creation attribution decomposing gross value into revenue, margin, multiple, and deleveraging, and a terms-and-team review (GP commitment, key-person, succession, fee/carry). North-star deliverable: a commit/pass the IC can vote on, backed by an independent track-record model rather than the GP's marked TVPI, with a portfolio-construction covenant and a side-letter ask list attached.
Investor lens for
OMERS
CPP Investments
CDPQ
OTPP
Fund DD · PME · Value-creation attribution
$75M commitment · $2.5B fund
Project 12 · Private Equity · Co-Investments
Fulcrum: underwriting a co-investment in a $520M buyout.
An independent LBO underwrite of a fee-free, carry-free co-investment alongside a sponsor: operating case, leverage and returns model, and a sensitivity that locates where the deal breaks, as a go/no-go.
Premise: a sponsor on the LP's approved-funds list offers a $40M co-investment alongside its $260M equity check in the $520M-EV buyout of a North American specialty-distribution platform, at 10.0x EBITDA and 5.0x leverage. A no-fee, no-carry co-invest lets the LP keep the gross deal return instead of the fund's 1.75% fee and 20% carry, an edge worth roughly 7-8% of IRR (Cambridge Associates) that holds net only for a diversified, independently-underwritten co-invest book, on the sponsor's clock.
Fulcrum rebuilds the LBO straight from the data room: an operating case lifting EBITDA from $52M to about $78M over five years on 6% revenue growth plus 150 bps of margin, an equity value bridge separating EBITDA growth from multiple change and debt paydown, and a sensitivity grid across exit multiple and EBITDA CAGR. North-star deliverable: a go/no-go that clears the hurdle under a one-turn-down exit and a higher-for-longer rate path, with operational value as the largest bar in the bridge, ahead of leverage, conditioned on a rate hedge and information rights.
Investor lens for
OMERS
CPP Investments
CDPQ
PSP Investments
Co-investment · LBO model · IRR / MOIC
$40M check · 2.3x base case
Project 13 · Industrial AI · Energy & Operations
Wellhead: industrial AI for upstream operations.
Physics-informed edge AI for oil and gas operations, with regulator-ready ESG signing built in; survives 30+ days disconnected and learns across operators on aggregated gradients rather than raw telemetry.
Premise: 1.2M producing wells operate globally, and unplanned downtime runs into the tens of billions a year across heavy industry. The 2018–2023 pure-ML wave failed because reservoir engineers reject outputs they can't mechanistically defend. Methane regulation has hit calendar deadlines (EPA NSPS OOOOb/c, EU Methane Reg, OGMP 2.0) that require operator-signed emissions lineage, and operators file that separately today. The disconnect between operational AI and regulator-grade ESG is the gap.
Wellhead closes it: a physics-informed failure-prediction runtime (not black-box ML), edge-deployed so it survives connectivity loss, with signed ESG telemetry co-produced at inference time. Cross-operator learning happens on aggregated gradients, never raw reservoir data, so competitive sensitivity is preserved. North-star: unplanned downtime avoided per well per year. Counter-metrics: reservoir engineer approval rate on recommended workovers, regulator audit-pass rate on methane filings.
Engagement for
EY Climate Tech
Bain PI
BCG
Industrial AI · ESG compliance · Edge deployment
$50–80B / yr downtime opportunity
Project 14 · Energy Transition · Utilities / ESG
Tideway: energy-transition capital allocation for an integrated utility.
A six-month, 10-year capital-allocation plan for a North American integrated utility, re-optimizing roughly $40B of capex against a three-objective frontier of carbon avoided, rate impact, and regulator sign-off.
Premise: a North American integrated utility ($25B revenue, 85 TWh/yr generation, 6M customer accounts) is facing the energy-transition trilemma: a 2035 net-zero-electricity regulatory pathway (federal Clean Electricity Regulations + tightening provincial commitments), rate-payer affordability constraints (politically and contractually capped), and an aging gas-peaker fleet that's both essential for reliability and a regulatory liability. Their current 10-year plan over-indexes on solar utility-scale because that's the cleanest unit cost in isolation; what it misses is the downstream cost of grid balancing, which makes the actual marginal abatement cost 2.5× the headline LCOE.
Tideway is a six-month strategic engagement: a 10-year capital allocation plan that re-optimizes against a three-objective frontier (MtCO₂ avoided, $/customer rate impact, regulator-signoff probability). Workstreams: scenario modeling across nine generation-mix futures, technology-bet sequencing (storage vs. small modular reactors (SMR) vs. demand-response vs. transmission), regulator-engagement strategy with the provincial energy board, and a stakeholder-impact sequencing plan that orders changes to land politically. North-star: cumulative MtCO₂ avoided per $B capex, optimized along the affordability constraint. Counter-metrics: grid-reliability index (cannot deteriorate vs. baseline), median rate-payer bill impact %.
Engagement for
McKinsey Sustainability
BCG Climate & Sustainability
Bain ESG
Accenture Sustainability
Energy transition · Capital allocation · Regulator
10-yr plan · $40B capex re-shaped
Project 15 · Public Sector · Healthcare Operations
Helm: provincial wait-times reduction across a six-hospital cohort.
A nine-month operations engagement across six Ontario hospitals to bring admitted-patient ED length-of-stay toward the 8-hour provincial target by fixing downstream bed-flow, discharge governance, and triage.
Premise: Ontario emergency departments saw 90th-percentile ED-LOS for admitted patients above 48 hours in 2024 against an 8-hour provincial target (HQO); worst-quartile sites materially worse; admitted-patient hallway-wait incidents have grown materially over three years. The Ministry of Health has set a tightened total-time-in-ED target as a measurable component of the next provincial budget cycle. The wait-time problem sits downstream in bed-flow, EMR-driven discharge friction, and a triage protocol that hasn't been re-tuned to current case-mix.
Helm is a nine-month operations engagement across six hospitals in two Ontario Health Teams (OHTs): patient-flow modeling at the asset level (ED → admission → discharge → bed-turn), discharge-readiness governance (medical reconciliation + transport + community-care intake), and a re-tuned triage protocol calibrated to 2025 case-mix. The work product is operational: visual-management boards in each ED, a daily flow huddle with clinical and ops leadership, and a discharge-readiness lookahead that moves bed turns earlier in the day. North-star: median total time-in-ED for admitted patients across the cohort, audited against the prior 90-day baseline. Counter-metric: 30-day readmission rate and a Maslach Burnout Inventory (MBI) burnout score, both held flat as guardrails.
Engagement for
McKinsey Public Sector
Deloitte Public Sector
BCG Public Sector
Bain PI Healthcare
Throughput · Patient flow · Policy
Admitted ED-LOS < 8h target
Project 16 · Healthcare · Patient Experience
Patient Experience: what moves "would you recommend".
A key-driver analysis on 2.3M patient-experience survey responses, built from raw public data in SQL, finding which drivers move the recommendation rate and where to act first.
Premise: for a high-touch service, the useful question is which experience drivers actually move the recommendation rate, and where a limited budget should go first. The lowest-scoring dimension is often a weaker lever than it looks.
Built on the public CMS HCAHPS survey (about 4,800 hospitals and 2.3M completed responses) entirely in DuckDB and SQL, with no BI tool. A standardized key-driver regression ranks nurse communication as the strongest driver of recommendation, shows quietness as the lowest-scoring yet weaker lever, flags early-warning states, and ties each recommendation to cited research (AHRQ, Doyle et al. 2013, Reichheld 2003). North-star: the share of patients who would definitely recommend.
Relevant to
IQVIA
Healthcare analytics
Patient-centered research
DuckDB · SQL · Key-driver regression
CMS HCAHPS · 2.3M responses
Project 17 · Enterprise systems · CRM data quality
Concord: gating a CRM release on data quality.
A CRM / Opportunity-to-Engagement data-quality and release-testing console, built end to end in C# and SQL, that validates records against governed reference data, isolates what a release broke, triages the defects, and gates the release.
Premise: before a monthly CRM release goes live, someone has to answer whether it broke any records, which ones and why, and whether the open-defect backlog is healthy enough to promote. The useful artifact is a single call: ship it, watch it, or hold it.
Concord models a CRM pipeline in SQL (accounts, opportunities through the O2E stages, governed stage and currency reference data, and a defect register with a full OPEN to VALIDATED lifecycle). It holds two snapshots, a known-good baseline and a release candidate, runs seven data-quality rules against each, and treats any failure present in the candidate but not the baseline as a regression the release introduced. Each regression is triaged into the defect register, the release is gated OK / WATCH / HOLD by worst severity, and release-health KPIs (backlog, cycle time, validation rate) are reported. North-star: no high-severity regression reaches production. Rules map to the DAMA data-quality dimensions.
Relevant to
Deloitte BIS
CRM operations support
Data governance
C# · SQL · SQLite
UAT & regression · defect triage
Project 18 · Manufacturing · MES & support
Takt: monitoring and supporting a shop floor.
A manufacturing-execution (MES) monitor built end to end in C# and SQL that tracks production KPIs and defect genealogy, then turns them into a per-line support verdict an engineer can act on.
Premise: at the end of a shift an MES has to answer which machine lost the most time and why, whether quality held, whether a work order has quietly stalled, and if a defect surfaces later, which units and which work order it traces back to.
Takt models the shop floor in SQL (work centers, work orders, a production-event log, and a defect table for genealogy), computes the core MES metrics in SQL (OEE decomposed into availability, performance and quality per Nakajima, a downtime Pareto, first-pass yield), then runs a support pass that turns the metrics into a per-work-center verdict of OK, WATCH or HOLD with the reason attached. Concepts map to SEMI E10/E79 equipment states and the ISA-95 MES reference model. North-star: no quality excursion or stalled work order goes unflagged.
Relevant to
MES & operations support
Production analytics
Defect triage
C# · SQL · SQLite
OEE · defect genealogy · triage
Project 19 · Energy transition · Investment underwriting
Solstice: underwriting a solar-plus-storage asset.
A project-finance investment model for a 200 MW solar-plus-storage asset, built in Excel and Python: it constructs the 30-year cash flow, sculpts the debt, and returns the unlevered and levered numbers an investment committee needs to commit equity.
Premise: before an investment committee commits equity to a renewable asset, someone has to answer the returns (unlevered and levered), whether the debt service holds, what moves the equity IRR, and how much carbon the asset abates. The useful artifact is an auditable model plus a one-page recommendation.
Solstice builds a 30-year cash flow from generation, a 20-year contracted PPA with a merchant tail, a storage capacity payment, opex and capex; sizes and amortizes the debt with an annual DSCR; and computes the unlevered IRR and NPV, the levered equity IRR and MOIC, and the minimum DSCR. A sensitivity isolates the two swing factors, PPA price and capex, and a decarbonization read ties return to tonnes abated. On the base case: 9.5% unlevered IRR, 14.9% levered equity IRR, 1.9x minimum DSCR, and about 4.9 Mt CO2 abated over life. North-star: a disciplined, auditable underwrite an IC can act on.
Relevant to
Brookfield
Energy-transition investing
Infrastructure
Excel · Python
DCF · IRR · DSCR · sensitivity
Project 20 · Real estate · Acquisition underwriting
Cornerstone: underwriting a real-estate acquisition.
A real-estate acquisition model in Excel and Python: a 200-unit multifamily pro forma from rents through to NOI, a cap-rate valuation, amortizing debt with DSCR, and a hold-period exit, returning the levered and unlevered numbers an investment committee needs.
Premise: to underwrite a property acquisition, an analyst builds the pro forma, values it on a cap rate, sizes the debt, runs the hold and the exit, and answers the only question that matters: do the returns clear the bar, and what breaks them. The useful artifact is an auditable model plus a one-page recommendation.
Cornerstone builds NOI from gross rent through vacancy, other income, and opex; values entry and exit on cap rates; sizes and amortizes the loan with an annual DSCR and debt yield; and computes unlevered IRR, levered IRR, equity multiple, and cash-on-cash, with a sensitivity isolating exit cap and rent growth. On the base case, a $47M buy at a 6.0% going-in cap returns a 12.6% levered IRR, an 8.6% unlevered IRR, a 1.74x equity multiple, and a 1.50x minimum DSCR, with the exit held flat to entry so the return comes from NOI growth, not cap compression. North-star: a disciplined underwrite an IC can act on.
Relevant to
Desjardins Capital Markets
Real estate IB
Acquisitions
Excel · Python
NOI · cap rate · DSCR · IRR
Project 21 · Energy · Solar performance engineering
Helios: operating a solar plant against its contract.
A utility-scale PV performance engine in Python: an expected-energy model for a 100 MW single-axis-tracker plant, the Performance Ratio and yield metrics owners and lenders track, an energy-loss waterfall, a capacity test that isolates excusable losses, and a fleet view that flags the plants drifting below guarantee.
Premise: a solar performance engineer is paid to hold a plant to the energy model it was financed on. The work is measuring delivered energy against expected, attributing every lost megawatt-hour to a cause, separating operator-controllable losses from excusable ones, and flagging the plants drifting below guarantee. The useful artifact is an auditable model plus a performance report.
Relevant to
SOLV Energy
Utility-scale solar O&M
Performance engineering
Python · NREL PVWatts
PR · specific yield · loss accounting