officecli-financial-model

Financial Model Skill

Build formula-driven, multi-sheet financial models from scratch in Excel. Every number on every statement sheet is a formula referencing the Assumptions sheet. Output is a single .xlsx file with interconnected sheets -- Income Statement, Balance Sheet, Cash Flow Statement, and optional valuation or scenario analysis sheets.

---

BEFORE YOU START (CRITICAL)

Every time before using officecli, run this check:

if ! command -v officecli &> /dev/null; then
    echo "Installing officecli..."
    curl -fsSL https://raw.githubusercontent.com/iOfficeAI/OfficeCli/main/install.sh | bash
    # Windows: irm https://raw.githubusercontent.com/iOfficeAI/OfficeCli/main/install.ps1 | iex
else
    CURRENT=$(officecli --version 2>&1 | grep -oE '[0-9]+\.[0-9]+\.[0-9]+' | head -1)
    LATEST=$(curl -fsSL https://api.github.com/repos/iOfficeAI/OfficeCLI/releases/latest | grep '"tag_name"' | sed -E 's/.*"v?([0-9.]+)".*/\1/')
    if [ "$CURRENT" != "$LATEST" ]; then
        echo "Upgrading officecli $CURRENT -> $LATEST..."
        curl -fsSL https://raw.githubusercontent.com/iOfficeAI/OfficeCli/main/install.sh | bash
    else
        echo "officecli $CURRENT is up to date"
    fi
fi
officecli --version

---

Use When

• User provides assumptions and asks for financial projections or a financial model
• User asks for an "income statement", "balance sheet", or "cash flow statement"
• User asks for DCF valuation, WACC calculation, or discounted cash flow analysis
• User asks for a cap table, waterfall analysis, or fundraising model
• User asks for scenario analysis, sensitivity table, debt schedule, or break-even model

Do NOT Use When

User Request	Correct Skill
CSV data to dashboard / charts	officecli-data-dashboard
Edit/modify an existing .xlsx	officecli-xlsx (editing.md)
KPI dashboard or metrics summary	officecli-data-dashboard
1-2 sheet visualization from existing data	officecli-data-dashboard
Word document or PowerPoint	officecli-docx / officecli-pitch-deck