AMBA
✓English
日本語
한국어
Tiếng Việt

English

日本語
한국어
Tiếng Việt

Appearance

Playbook: Senior Financial Analyst & Controller ​

Role: Senior Financial Analyst & Controller
Domain: Corporate Finance, Management Accounting, Cash Flow Auditing & Valuation
Capability Packs: financial_modeling, data_inspection

1. Business Overview ​

The Senior Financial Analyst & Controller assists executive leadership, CFOs, and controllers in solving complex financial challenges:

  • Audit and reconcile multi-account general ledgers, payment gateways, and banking statements.
  • Build dynamic 3-statement models (P&L, Balance Sheet, Cash Flow), sensitivity analyses, and Discounted Cash Flow (DCF) valuations.
  • Optimize Net Working Capital (NWC), evaluate debt covenants, and mitigate cash flow volatility.

All computations run deterministically using embedded local engines and standardized formulas, guaranteeing zero mathematical hallucinations.

2. Input Files (Sources) ​

Add source data files to the project's Sources (files you add are kept in sources/uploads/):

  • Q2_Financial_Statements.xlsx: Balance sheets, income statements, and cash flow schedules.
  • Bank_Statements_and_Invoices.csv: Transaction logs and merchant settlement records.
  • Annual_Budget_Plan.xlsx: Departmental OPEX and CAPEX projections.

3. Prompt Example ​

markdown
Load the financial statements and transaction statements from Sources into the analytical database.
1. Reconcile recorded revenue against actual cash receipts, identifying all unmatched variances.
2. Calculate key financial metrics: EBITDA, Net Profit Margin, ROE, Debt-to-Equity (D/E), and Net Working Capital.
3. Build a 12-month rolling cash flow forecast and export the model to `reports/Financial_Analysis_Model.xlsx`.
4. Compile an executive summary for the Board of Directors as `reports/Executive_Financial_Briefing.pdf`.

4. Expected Deliverables (reports/) ​

  1. reports/Financial_Analysis_Model.xlsx:
    • Sheet 1 — Dashboard & KPI: Visual summary of liquidity, solvency, and profitability ratios.
    • Sheet 2 — 3-Statement Model: Dynamically linked P&L, Balance Sheet, and Cash Flow schedules.
    • Sheet 3 — Reconciliation & Variance: Detailed audit trail and exception log.
  2. reports/Executive_Financial_Briefing.pdf: A concise executive briefing highlighting cash flow risks and capital allocation recommendations.