Loading...
Loading...
Found 49 Skills
Excel spreadsheet toolkit for creating, reading, and manipulating .xlsx files. Supports formulas, formatting, charts, and financial modeling with industry-standard conventions. Use for data analysis, financial models, reports, and spreadsheet automation.
Create and update pitch decks, one-pagers, investor memos, accelerator applications, financial models, and fundraising materials. Use when the user needs investor-facing documents, projections, use-of-funds tables, milestone plans, or materials that must stay internally consistent across multiple fundraising assets.
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.
Financial analysis expertise for financial modeling (DCF, LBO, M&A), valuation, financial statement analysis, capital allocation, treasury management, and corporate finance decisions. Use when building financial models, analyzing statements, or making investment decisions.
QUERY LENGTH LIMIT EXCEEDED. MAX ALLOWED QUERY : 500 CHARS
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.
End-to-end real estate investment analysis skill. Use when users ask to analyze a property deal, run the numbers on a rental, evaluate real estate investments, build a pro forma, compare markets, calculate cap rate, cash-on-cash return, IRR, NOI, DSCR, equity multiple, or GRM. Also triggers on: BRRRR analysis, house hack evaluation, short-term rental (STR/Airbnb) analysis, commercial underwriting, multifamily deal analysis, syndication waterfall modeling, Monte Carlo simulation for real estate, sensitivity analysis on a deal, 1031 exchange planning, cost segregation analysis, depreciation calculations, real estate tax strategy, market comparison and scoring, rental property screening, deal screening, investor report generation, real estate financial modeling, property type comparison, rent-to-price analysis, development feasibility, land analysis, value-add underwriting, API integration for real estate data (Zillow, Redfin, AirDNA, Mashvisor, ATTOM, Rentcast, Census), or any real estate investment financial analysis task.
Perform break-even analysis to determine the sales volume or revenue needed to cover all costs. Use this skill when the user needs to calculate break-even point, assess margin of safety, evaluate operating leverage, or decide pricing and volume trade-offs — even if they say 'how many units do we need to sell', 'when will we be profitable', or 'what happens if we lower the price'.
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".
Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making
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.