Loading...
Loading...
Found 44 Skills
This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions
Use this skill when building, auditing, or optimizing spreadsheet models in Excel or Google Sheets. Triggers on formula writing, pivot table creation, dashboard design, data validation, conditional formatting, macro/VBA scripting, Apps Script automation, financial modeling, what-if analysis, XLOOKUP/INDEX-MATCH lookups, array formulas, and workbook architecture. Covers advanced Excel and Google Sheets for analysts, finance professionals, and operations teams.
Calculate Altman Z-Score to predict corporate bankruptcy probability from financial ratios. Use this skill when the user needs to assess a company's financial distress risk, screen for bankruptcy-prone firms, or evaluate credit worthiness — even if they say 'bankruptcy prediction', 'financial distress score', or 'Z-score analysis'.
Discounted cash flow (DCF) valuation model built from Longbridge financial data — historical FCF (operating cash flow minus capex), projected FCF with growth assumptions, WACC (Beta / risk-free rate / equity risk premium), terminal value, intrinsic value vs current price, and margin of safety. Triggers: "DCF", "现金流折现", "内在价值", "自由现金流", "WACC", "折现率", "安全边际", "终值", "现金流贴现", "現金流折現", "內在價值", "自由現金流", "折現率", "安全邊際", "DCF model", "discounted cash flow", "intrinsic value", "free cash flow", "WACC", "discount rate", "margin of safety", "terminal value", "Gordon growth".
Pricing completo de opciones europeas y americanas. 9 metodos: Black-Scholes, Binomial CRR, Trinomial, Monte Carlo (antithetic) + Longstaff-Schwartz, Bjerksund-Stensland 2002 / BAW (American closed-form), Heston 1993 (vol estocastica, sonrisa via Fourier), Bates 1996 (Heston + Merton jumps, crash risk), greeks (BS), implied vol, P(ITM) y P(Profit). Disenado para backtesting: cada funcion es flat Python vectorizado con numpy (sin abstracciones), usa math.erfc (no scipy). BS 2.4 us/op, BS2 3.6 us, Heston 400 us, Binomial N=500 5.6 ms. CLI con 15 modos mas validate y bench. Time complexity O(1) para todos los closed-form.
QUERY LENGTH LIMIT EXCEEDED. MAX ALLOWED QUERY : 500 CHARS
Manages financial risks through quantitative analysis, modeling, and mitigation strategies.
PPC financial calculator and modeling tool. CPA, ROAS, CPL calculations, break-even analysis, impression share opportunity sizing, budget forecasting, LTV:CAC ratio analysis, and MER (Marketing Efficiency Ratio) assessment. Requires zero API access. Works with pasted data from exports. Use when user says PPC math, ad calculator, break-even, budget forecast, ROAS calculator, CPA calculator, impression share, LTV CAC, or MER.
Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, ....
Comprehensive Excel spreadsheet creation, editing, and analysis using openpyxl and xlwings supporting formulas, formatting, data analysis, charts, and financial model color coding. Use when asked to "create a spreadsheet", "edit this Excel file", "analyze spreadsheet data", "preserve Excel formulas", "create financial model", or "recalculate formulas". Implements industry-standard color conventions (blue=inputs, black=formulas, green=internal links, red=external links, yellow=key assumptions) and zero formula error requirements. Works with .xlsx, .xlsm, .csv, .tsv files for professional spreadsheet workflows.
Use when modeling unit economics, calculating burn rate, building financial projections, pricing analysis, revenue forecasting, or any CFO-level financial decisions