Agent Skills by alexzwang1
Showing 40 vetted skills indexed across 1 GitHub repositories.
AlexZWANG1Valuation
Compute DCF and comps valuations with bear, base, and bull scenarios.
AlexZWANG1Portfolio AI Readiness
Ingest quarterly updates and financials to rank AI opportunities by EBITDA impact.
AlexZWANG1Portfolio Monitoring
Ingest Excel, PDF, or CSV financial packages and generate KPI variance analyses.
AlexZWANG1Diligence Meeting Prep
Generate prioritized questions, benchmarks, red flags, and follow-up items for diligence meetings.
AlexZWANG1Deal Screening
Screen deal materials against investment criteria and produce a pass/fail memo.
AlexZWANG1Value Creation Plan
Map revenue, cost, and operational levers to an EBITDA bridge.
AlexZWANG13-statement-model
Automate building and linking integrated Income Statement, Balance Sheet, and Cash Flow models.
AlexZWANG1comps-analysis
Structure public-company comps data and calculations into an Excel workbook.
AlexZWANG1clean-data-xls
Clean and standardize messy Excel and .xlsx spreadsheet data.
AlexZWANG1ppt-template-creator
Convert PowerPoint templates into reusable Skill packages with SKILL.md.
AlexZWANG1deck-refresh
Update numerical values across PowerPoint slides while preserving formatting.
AlexZWANG1ib-check-deck
Identifies and quantifies quality issues in investment banking pitch decks across four dimensions.
AlexZWANG1competitive-analysis
Automates competitive landscape analysis from scoping to slide deck assembly.
AlexZWANG1skill-creator
Automates Claude skill creation with SKILL.md scaffolding, initialization, validation, and packaging workflows.
AlexZWANG1lbo-model
Constructs and validates LOBASICALLY formatted LBO models in Excel templates.
AlexZWANG1dcf-model
Construct a DCF valuation model with WACC, terminal value, and scenario analysis in Excel.
AlexZWANG1audit-xls
Audit spreadsheet formulas for errors, hardcodes, and integrity issues.
AlexZWANG1Earnings Preview
Pull consensus estimates and build bull/base/bear scenarios for earnings previews.
AlexZWANG1Morning Note
Draft morning notes summarizing overnight developments, top calls, key events, and trade ideas.
AlexZWANG1earnings-analysis
Generate structured DOCX earnings update reports with charts and citations.
AlexZWANG1Model Update
Automatically updates financial models with latest earnings, guidance, and macro changes.
AlexZWANG1initiating-coverage
Coordinate five-step equity research initiation workflows with prerequisite checks and artifact handoffs.
AlexZWANG1Merger Model
Build accretion/dilution and pro forma EPS merger models in Excel.
AlexZWANG1pitch-deck
Populate PowerPoint pitch deck templates with data from Excel/CSV files.