budget-forecasting-engine
Driver-based budgeting and forecasting skill with rolling forecast support and variance analysis
Driver-based budgeting and forecasting skill with rolling forecast support and variance analysis
Capital investment appraisal skill with NPV, IRR, payback, and real options analysis
Daily, weekly, and monthly cash forecasting skill with scenario analysis and liquidity stress testing
Public company comparable analysis skill with peer selection, multiple calculation, and football field visualization
Discounted Cash Flow model builder for comprehensive company valuations with WACC calculation, terminal value estimation, and sensitivity analysis
Macroeconomic indicator monitoring and analysis skill with trend identification and forecasting
Automated financial dashboard and KPI visualization skill with executive reporting capabilities
Fraud risk assessment skill based on the fraud triangle with red flag detection
Foreign exchange exposure analysis and hedging strategy skill with hedge effectiveness testing
Industry and competitive analysis skill with Porter's Five Forces and market structure analysis
Leveraged Buyout model construction skill for private equity transaction analysis
M&A merger model construction skill with accretion/dilution analysis and synergy modeling
Stochastic simulation skill for financial modeling with probability distributions and risk quantification
Multi-state and international tax calculation skill with nexus analysis
Integrated three-statement financial model builder linking income statement, balance sheet, and cash flow statement with circular reference handling
XBRL financial statement tagging and SEC filing preparation skill
Analyze market compensation data and establish competitive pay structures
Analyze exit interview data and identify retention insights and patterns
Evaluate technical options with scoring matrix, trigger Gate 4 for significant decisions
Update Margin Dashboard with Fidelity balance data and calculate margin-living strategy metrics. Monitors margin balance, interest costs, coverage ratios, and scaling thresholds. Triggers safety alerts for large draws and provides time-based scaling recommendations. Use when updating margin, balances, coverage ratio, or margin strategy analysis.
Sync dividend data from Fidelity CSV to Dividends sheet. Reads dividend.csv from notebooks/updates/, calculates actual dividends received (shares × amount per share), writes to input area (rows 2-46), then clicks Add Dividend button to process. Triggers on sync dividends, update dividends, dividend tracker, layer 2 income, or monthly dividend analysis.
Run Monte Carlo simulations for Finance Guru portfolio strategy. USE WHEN user mentions monte carlo OR run simulation OR stress test portfolio OR probability analysis OR income projections OR margin safety analysis. Supports 4-layer portfolio (Growth, Income, Hedge, GOOGL) with auto-detection of current values from Fidelity CSV.
Import and sync broker CSV portfolio data to Google Sheets DataHub. Supports multiple brokers (Fidelity, Schwab, Vanguard, etc.). USE WHEN user mentions import broker data OR sync portfolio OR update positions OR CSV import OR portfolio-sync OR working with Portfolio_Positions CSVs. Handles position updates, SPAXX/margin validation, safety checks, and formula protection.
Detect flood events by comparing water levels to thresholds. Use when determining if flooding occurred, counting flood days, aggregating instantaneous data to daily values, or classifying flood severity.