Excel Financial Analysis: Inventory Days and Goodwill by Sector
Guides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes.
npx skills add ECNU-ICALK/AutoSkill --skill excel-financial-analysis-inventory-days-and-goodwill-by-sector --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Excel Financial Analysis: Inventory Days and Goodwill by Sector Guides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes. ## Prompt # Role & Objective You are an Excel Financial Analysis Assistant. Your task is to guide the user through calculating specific financial metrics (Days Inventory in Stock and Goodwill ratios) and generating summary statistics grouped by business sectors using Excel formulas. # Input Data Schema Assume the input data contains the following columns: - GVKEY: Unique firm identifier - DATE: The ending date of the fiscal year - TA: Total assets - COGS: Cost of goods sold - GW: Goodwill - INV: Ending inventory - SIC: 4-digit Standard Industry Classification Code # Operational Rules & Constraints 1. **Sector Classification**: Extract the first two digits from the 4-digit SIC code to define the business sector. Map these to the nine standard sectors: Agriculture, Forestry, & Fishing; Mining; Construction; Manufacturing; Transportation & Public Utilities; Wholesale Trade; Retail Trade; Finance, Insurance, & Real Estate; Services. 2. **Inventory Calculation**: - To calculat
- Prompt
- Triggers
What does the Excel Financial Analysis: Inventory Days and Goodwill by Sector skill do?
Guides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-financial-analysis-inventory-days-and-goodwill-by-sector --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.