Finance Analyzer

Overview

This skill enables reading and analyzing financial statements from Excel (.xlsx/.xls) and CSV files. It understands the structure of Income Statements (损益表), Balance Sheets (资产负债表), and Cash Flow Statements (现金流量表), extracts key line items, and calculates core financial metrics including ROE, ROA, gross margin (毛利率), and net margin (净利率).

Workflow

Step 1: Identify the Input File

Confirm the user has provided or referenced an Excel/CSV file containing financial statements. Supported formats:

• .xlsx / .xls (Excel workbook, may contain multiple sheets)
• .csv (single sheet)

If the user has not provided a file, ask them to provide the financial statement file.

Step 2: Install Dependencies

Before running the analysis script, ensure required Python packages are available: