andreworia
- 66 skills
- 0 followers
- 8 hours ago last updated
- ▌ Process Redesign · andreworiaMaps a core process end to end with Lean value-stream analysis and redesigns it to remove waste and fix broken handoffs.
- ▌ Hypothesis Design · andreworiaBuilds an answer-first plan by stating disprovable hypotheses and, for each, the "what would prove me wrong" test and the exact analysis that settles it, so the team tests instead of boiling the ocean.
- ▌ Insight Synthesis · andreworiaTurns raw findings into ranked insights by laddering each finding up the so-what chain from observation to implication to the action it demands.
- ▌ Pyramid Storyline · andreworiaStructures an argument using the Pyramid Principle and SCQA so the recommendation lands in the first 60 seconds, with every supporting line grouped MECE beneath one governing thought.
- ▌ Issue Tree Builder · andreworiaDecomposes one big question into a MECE issue tree or hypothesis tree of testable sub-questions, with branches ranked by impact so the team analyzes what matters first.
- ▌ Objection Handling · andreworiaPrepares for a hostile room by pre-morteming the pushback, surfacing the hardest questions your recommendation will face, and drafting a tight, evidence-backed answer to each.
- ▌ Problem Definition · andreworiaTurns a vague symptom or an over-broad brief into a one-page SCQA problem statement and a single decision-shaped key question the work must answer.
- ▌ Competitor Analysis · andreworiaReads industry structure with Porter's Five Forces and profiles rivals on capability and cost, giving a clear view of who you compete with and how attractive the industry really is.
- ▌ Cost Driver Analysis · andreworiaDecomposes cost changes into volume, rate, and mix effects to identify the true root cause of cost escalation or decline.
- ▌ Where To Play How To Win · andreworiaBuilds a linked strategy choice cascade (winning aspiration, where to play, how to win, capabilities, management systems) so a direction is coherent and internally reinforcing, not a list of ideas.
- ▌ Zero Based Budget Builder · andreworiaBuilds a zero-based budget for a cost center by requiring every line item to be justified from first principles rather than rolled forward from the prior year.
- ▌ Revenue Build · andreworiaBuilds 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 revenue with Base/Bull/Bear scenario toggles. Use when someone needs a bottom-up revenue model, an ARR build, or a driver-based forecast for planning or a board deck. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
- ▌ Unit Economics · andreworiaBuilds 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 retention grid. Use when someone needs unit economics, an LTV/CAC analysis, a payback model, or a cohort retention build. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
- ▌ Scenario Manager · andreworiaBuilds 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 workbook. Use when someone wants an auditable scenario toggle instead of Excel's hidden Scenario Manager. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
- ▌ Output Summary Tab · andreworiaDesigns 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.
- ▌ Sensitivity Tables · andreworiaBuilds 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. Use when someone wants to see how an output (NPV, IRR, EPS, margin) moves as one or two inputs change. Do not trigger for editing an existing workbook through the Claude for Excel add-in.
- ▌ Pivot Table Builder · andreworiaSpecifies 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.
- ▌ Sensitivity Tornado · andreworiaRanks 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.
- ▌ Formula Audit Checker · andreworiaProvides 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.
- ▌ Data Cleaning For Excel · andreworiaTurns 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.
- ▌ Assumption Registry Builder · andreworiaCreates 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 sensitivity rank from Data Table outputs.
- ▌ Inputs Calcs Outputs Design · andreworiaEnforces 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.
- ▌ Model Architecture Template · andreworiaDefines 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 content is added.
- ▌ Company Teardown · andreworiaReverse-engineer a target's business model, unit economics, growth drivers, and risk profile from disclosed and inferred data. Use at the start of any sell-side or buy-side mandate, before drafting a CIM section, pitching coverage, or building a financial model. Built around revenue decomposition, cost-structure analysis, capital intensity, and concentration risk.
- ▌ Ic Memo Drafting · andreworiaDraft an investment committee memo covering deal thesis, business quality summary, diligence findings, risk matrix, returns analysis, and recommendation -- in the format senior investment professionals expect.
- ▌ Lbo Returns Analysis · andreworiaBuild a structured LBO returns analysis with bear/base/bull scenarios, MOIC and IRR sensitivity to entry multiple and leverage, and covenant headroom assessment.
- ▌ Cim Red Flag Reviewer · andreworiaRead a sell-side CIM the way a sharp buyer's MD reads it — surfacing quality-of-earnings risks, narrative gaps, and unsupported claims. Use on the buy-side when evaluating a teaser or CIM, on the sell-side as a pre-launch stress test, or when preparing IOI / LOI logic. Built around quality-of-earnings, concentration, sustainability, working capital and capex realism, and narrative pressure-testing.
- ▌ Priced Round Dilution · andreworia bundleA founder wants to compare simple priced-equity financing scenarios. Produces A pre/post-money and ownership bridge with explicit instrument exclusions.
- ▌ Trading Comps Builder · andreworiaConstruct a clean trading comps universe with disciplined peer selection, calendarization, EBITDA adjustments, and outlier treatment. Use when building the comps page of a valuation deck, framing a minority valuation reference, or pressure-testing a public-market reference range. Built around peer comparability, metric normalization, and the difference between a peer and a peer-shaped distractor.
- ▌ Valuation Triangulator · andreworiaBuild a defensible valuation range across DCF, trading comps, precedent transactions, LBO, and premiums paid. Use when pricing a sell-side mandate, framing a buy-side bid, preparing a fairness-style readout, or pressure-testing an IC valuation page. Built around methodology triangulation, the football field, and the bridge from enterprise value to equity value per share.
- ▌ Startup Valuation Brief · andreworia bundleAn early-stage company needs a supportable valuation discussion. Produces A method-selection memo, assumptions ledger and defensible scenario range.
- ▌ Accretion Dilution Tester · andreworiaRun a defensible accretion/dilution analysis with the financing, synergy, and tax mechanics that actually move EPS. Use when pricing an M&A transaction with a public-company acquirer, framing a stock-vs-cash consideration mix, or stress-testing IC and board materials. Built around purchase-price mechanics, financing mix, synergy timing, tax shield, intangible amortization, and disciplined sensitivity.
- ▌ Capital Allocation Advisor · andreworiaRanks competing uses of capital (reinvest in the core, M&A, debt paydown, buyback, dividend, cash buffer) by value creation, scoring each on its return spread over cost of capital subject to leverage, liquidity, and covenant constraints. Triggers on "capital allocation", "use of cash", "deploy capital", "buyback vs debt", "where to invest excess cash", "reinvest or return", "allocation framework", "capital plan".
- ▌ Earnings And Filings Teardown · andreworiaExtracts the financially material content from 10-K, 10-Q, and 8-K filings and earnings call transcripts into a structured one page brief with a source location on every number. Triggers when someone asks to tear down a filing or earnings release, summarize a 10-K or 10-Q, pull KPIs guidance and risks from a transcript, or brief the CFO on what a company reported.
- ▌ Precedent Transaction Screener · andreworiaBuild a screened, cycle-adjusted set of M&A precedents that actually inform pricing. Use when building the precedent page of a valuation deck, pressure-testing a control-premium thesis, or framing a buy-side bid against historical comparables. Built around screening discipline, cycle and structure adjustments, and synergy calibration.
- ▌ Data Ink Reducer · andreworiaStrips non-data ink from charts and slides using the data-ink ratio principle, so the remaining marks all carry meaning and the slide reads cleaner.
- ▌ Action Title Writer · andreworiaRewrite topic-label slide titles into headline action titles that state the so-what. Use when titles name the subject instead of delivering the message.
- ▌ Ghost Deck Skeleton · andreworiaProduces a ghost deck (skeleton) of empty slides with action titles and exhibit placeholders, so the storyline is agreed before any time is spent on design.
- ▌ Board Narrative Scqa · andreworiaStructure the through-line of a board pack using SCQA and the Pyramid Principle so the deck argues one clear story instead of reporting disconnected pages.
- ▌ Chart Type Selection · andreworiaPicks the right chart type for your data and your message using a decision tree, so the chart proves the point instead of just showing numbers.
- ▌ Decision And Ask Page · andreworiaBuild the decision page that converts the recommendation into a specific, votable ask, with options considered, the recommended option, and what approval commits the board to.
- ▌ Executive Summary Page · andreworiaBuild the one-page executive summary that opens a board pack, stating the governing thought, the three to five proof points, and the ask so a director who reads only this page is fully informed.
- ▌ Chart To Message Mapper · andreworiaTurns a raw chart into a message-driven exhibit by adding the action title, the one highlight, the labels that matter, and removing everything that does not serve the point.
- ▌ Color Encoding For Data · andreworiaApplies color to a chart so it encodes meaning and directs attention, using preattentive contrast, sequential and categorical palettes, and accessibility checks.
- ▌ Framework Slide Designer · andreworiaDesigns a clean framework slide (2x2, value chain, process flow, pyramid, matrix) that communicates a structured idea without clutter or false precision.
- ▌ Partner Review Checklist · andreworiaRuns a deck through a partner-grade review checklist covering story, titles, exhibits, layout, and consistency, returning a prioritized fix list before review.
- ▌ Waterfall And Bridge Charts · andreworiaBuilds waterfall (bridge) charts that explain how a starting value became an ending value through a sequence of additions and subtractions.
- ▌ Theme Color Binder · andreworiaBinds shape and text fills to theme color slots instead of hard-coded RGB so a single re-theme updates the whole deck.
- ▌ Brand Palette Guard · andreworiaRestricts a deck to the approved brand palette with one accent rule so slides stop drifting into off-brand or rainbow colors.
- ▌ PPTX Export And PDF · andreworiaConverts slide size and aspect ratio and exports a deck to PDF, image, or video with the settings that survive the trip. Not for designing the slides themselves.
- ▌ Slide Accessibility · andreworiaMakes a deck usable with a screen reader and compliant for a regulated client — alt text, reading order, slide titles, contrast, table headers, captions. Not for general visual polish.
- ▌ Excel To Native Chart · andreworiaTurns a block of Excel or pasted data into a clean, native, editable PowerPoint chart rather than a pasted image or screenshot.
- ▌ Placeholder Discipline · andreworiaMoves floating text and objects into the layout's real title, body, and content placeholders so the deck inherits template styling automatically.
- ▌ Brand Compliance Auditor · andreworiaAudits a finished deck against the brand and template and returns a flagged list of every off-brand and off-template element.
- ▌ Deck File Size Optimizer · andreworiaCuts a bloated .pptx down by finding what is actually heavy — cropped pixels, uncompressed images, embedded media, orphan masters — and removing it without visible quality loss. Not for speeding up a slow-running animation.
- ▌ Iconography Style Keeper · andreworiaUnifies mismatched icons into one consistent system in the brand style, matching weight, fill, corner, and color.
- ▌ Master And Layout Mapper · andreworiaMaps every slide onto the correct master layout with the right placeholders so the deck is structurally on-template before any styling.
- ▌ Build A Potx From Scratch · andreworiaConstructs a corporate .potx from nothing — slide master, layout set, theme colour and font schemes, placeholders — so decks built on it inherit the brand automatically. Not for fixing a deck against a template that already exists.
- ▌ Logo And Lockup Compliance · andreworiaRestores the correct logo lockup with brand clear space and minimum sizing wherever the wrong logo, color, or crop appears.
- ▌ Speaker Notes And Handouts · andreworiaSets up the notes master, handout master, and the print and PDF routes so a deck ships a usable speaker script and a readable leave-behind. Not for writing the notes content itself.
- ▌ Imagery And Photo Treatment · andreworiaApplies a single image treatment, aspect ratio, and duotone or filter rule so photos stop clashing in crop, color, and style.
- ▌ Font Embedding And Fallbacks · andreworiaEmbeds the brand fonts in a .pptx and sets a fallback stack so the deck does not reflow on a machine that lacks them. Not for choosing the typefaces or the type scale.
- ▌ Reskin To Template Converter · andreworiaRebuilds an off-brand deck on the approved template, recolored and retyped, preserving the content while changing the skin.
- ▌ Grid Margin Safe Zone Alignment · andreworiaRestores a consistent grid, even margins, and a respected safe zone so elements stop drifting past the template's edges.
- ▌ Theme Font And Type Scale Enforcer · andreworiaReplaces rogue fonts and random sizes with the brand heading and body fonts on a consistent type scale.
- ▌ Title Footer Page Number Consistency · andreworiaAligns titles and makes footers, dividers, and page numbers consistent so a long deck reads as one document.