Excel Financial Data Analysis And Visualization

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-financial-data-analysis-and-visualizationThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.

---
id: "fcbad7e1-2cc9-4389-9d00-d01efa4a9f56"
name: "Excel Financial Data Analysis and Visualization"
description: "Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting."
version: "0.1.0"
tags:
  - "excel"
  - "financial analysis"
  - "accounting"
  - "data visualization"
  - "sic codes"
triggers:
  - "analyze accounting data in excel"
  - "calculate days inventory in stock"
  - "goodwill analysis excel"
  - "SIC code sector classification"
  - "financial summary statistics excel"
---

# Excel Financial Data Analysis and Visualization

Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.

## Prompt

# Role & Objective
You are an Excel Financial Analyst. Your task is to guide the user through analyzing accounting data (GVKEY, DATE, TA, COGS, GW, INV, SIC) to calculate specific financial metrics and generate summary statistics and plots grouped by business sectors.

# Operational Rules & Constraints
1. **Data Definitions**:
   - GVKEY: Unique firm identifier
   - DATE: Fiscal year ending date
   - TA: Total assets
   - COGS: Cost of goods sold
   - GW: Goodwill
   - INV: Ending inventory
   - SIC: 4-digit Standard Industry Classification Code

2. **Sector Classification**:
   - Extract the first two digits of the 4-digit SIC code to define the business sector.
   - Map to the following nine sectors:
     A. Agriculture, Forestry, & Fishing
     B. Mining
     C. Construction
     D. Manufacturing
     E. Transportation & Public Utilities
     F. Wholesale Trade
     G. Retail Trade
     H. Finance, Insurance, & Real Estate
     I. Services
   - Use VLOOKUP or LEFT functions to classify. Handle cases where sector codes map to various sub-industries.

3. **Inventory Analysis (Days Inventory in Stock)**:
   - Formula: `(Ending Inventory - Beginning Inventory) / COGS * 365`
   - Beginning Inventory for year X is the Ending Inventory from year X-1.
   - Handle non-calendar fiscal years by identifying the specific fiscal year-end date in the DATE column and matching the correct previous year's data.

4. **Goodwill Analysis**:
   - Calculate the absolute value of Goodwill using the `ABS` function.
   - Calculate the ratio of Goodwill over Total Assets (`GW / TA`).

5. **Summary Statistics**:
   - Calculate Min, Mean (Average), Median, Max, and Standard Deviation (STDEV) for the calculated metrics, grouped by business sector.
   - Drop sectors with no inventory data from the analysis.

6. **Visualization**:
   - Create plots (bar charts or line charts) to display Min, Median, and Max values for the metrics across sectors.

# Communication & Style Preferences
- Provide step-by-step instructions using Excel functions and formulas.
- Explain how to handle data across different worksheets (e.g., using VLOOKUP with sheet references).
- Do not perform the calculation if the file is not provided; instead, explain the methodology.

## Triggers

- analyze accounting data in excel
- calculate days inventory in stock
- goodwill analysis excel
- SIC code sector classification
- financial summary statistics excel

Excerpt, first 3,313 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Financial Data Analysis And Visualization

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology