fpna

Claude and Codex Agent Skill (plus standalone CLI) that audits existing Excel spreadsheets and financial models for correctness defects: formula errors, broken references, off-by-one ranges, totals that don't reconcile or cross-foot, circular references, and data-quality risks. Audit-only; never rewrites your workbook.

Power BI FP&A analytics portfolio with finance dashboards, DAX models, prepared data, QA notes, and executive reporting products.

经营管理导向财务分析看板：用 Python 将财务报表与业务明细转化为可离线运行的 FP&A 管理驾驶舱，含风险检测、杜邦分析、营运资本、利润中心与投资敏感性分析。

End-to-end SaaS FP&A: driver-based revenue forecast (backtested), budget-vs-actuals variance bridge, scenario planning, and a Power BI dashboard.

A practical FP&A operating cockpit for management reporting, month-end close, variance analysis, scenarios, and finance transformation.

Excel FP&A and business control model for a synthetic renewable energy portfolio using Power Query, variance analysis, scenario modeling, and dashboard reporting.

Budget vs actual variance dashboard: SQL (CTEs, exception flagging) + Excel conditional formatting + Power BI drill-through guide. FP&A portfolio project.

FP&A / BI portfolio project — P&L modelling, ratio analysis, and an interactive margin dashboard (synthetic data).

Power BI dashboard analyzing Hamburg public expenditure trends and category-level changes from 2010 to 2012.

End-to-end FP&A and business performance analysis project using SQL Server and Power BI to evaluate revenue trends, profitability, cost behavior, financial KPIs, and strategic business insights through interactive dashboard visualization.

Monthly ops and finance KPI scorecard with targets, variances, and RAG status. Sample Excel file.

Credit risk monitoring dashboard for CFO review. Built anomaly detection for revenue variance and financial risk KPIs using Python, Power BI. Automated monthly variance reporting for finance leadership.

Live financial-statements dashboard from an Excel workbook

End-to-end Business & Data Analytics projects using SQL, Excel, and BI tools. Focused on Operations, Product, and Pricing insights.

Working capital pack: AR/AP aging, inventory days, cash conversion cycle, and cash tied in NWC. Sample Excel file.

Monthly FP&A flash: Actual vs Budget vs Forecast, margin and OpEx variances, and a COGS rate vs volume split. Sample FY2026 file — fictional company.

Capex investment case: timed spend, volume lift and cost savings, NPV, IRR, and payback. Sample Excel file.

Driver-based P&L forecast: volume × price, COGS drivers, OpEx by cost center, plan vs reforecast. Sample Excel file.

Local-first CLI for token-spend and technical finance workflows

Fictional SaaS feature investment Go/No-Go case: decision memo + NPV/IRR model + sensitivity & KPI monitoring.