Rona Chart
by @linuszz
Decompose Return on Net Assets into component ratios. Use for asset efficiency analysis, capital structure review, and business model comparison.
clawhub install rona-chartπ About This Skill
name: rona-chart description: "Decompose Return on Net Assets into component ratios. Use for asset efficiency analysis, capital structure review, and business model comparison."
RONA Chart
Metadata
Instructions
Analyze Return on Net Assets (RONA) by decomposing into component ratios to identify asset efficiency drivers.Framework
RONA Equation
RONA = (Net Income / Revenue) Γ (Revenue / Net Assets)
or
RONA = Net Profit Margin Γ Asset TurnoverWhere:
Net Profit Margin = Net Income / Revenue
Asset Turnover = Revenue / Net Assets
Extended RONA Tree
RONA (Net Profit / Total Assets)
β
βββ Net Profit Margin
β βββ Gross Margin (Gross Profit / Revenue)
β βββ Operating Margin (Operating Profit / Revenue)
β βββ Net Profit Margin (Net Income / Revenue)
βββ Asset Turnover
βββ Revenue / Net Assets (overall)
βββ Fixed Asset Turnover
βββ Working Capital Turnover
βββ Inventory Turnover
Key Ratios
| Ratio | Formula | Interpretation | |--------|---------|----------------| | Gross Margin | Gross Profit / Revenue | Production efficiency | | Operating Margin | Operating Profit / Revenue | Core business efficiency | | Net Profit Margin | Net Income / Revenue | Overall profitability | | Asset Turnover | Revenue / Net Assets | Asset productivity | | Fixed Asset Turnover | Revenue / Fixed Assets | Fixed asset utilization | | Working Capital Turnover | Revenue / Working Capital | Working capital efficiency | | Inventory Turnover | COGS / Inventory | Inventory efficiency |
Output Process
1. Define scope - What assets to analyze? 2. Gather data - Balance sheet, income statement 3. Calculate ratios - Multi-year average preferred 4. Decompose RONA - Analyze margin and turnover separately 5. Identify drivers - What's impacting asset efficiency? 6. Benchmark - Compare to industry standards 7. Visualize - Waterfall chart or trend line
Output Format
## RONA Analysis: [Company/Business Unit]RONA Decomposition
| Component | Year 1 | Year 2 | Year 3 | Trend |
|-----------|--------|--------|--------|--------|
| Net Profit Margin | X% | Y% | Z% | β¬οΈβ¬οΈβ¬οΈ |
| Gross Margin | X% | Y% | Z% | β¬οΈβ¬οΈβ‘οΈ |
| Operating Margin | X% | Y% | Z% | β¬οΈβ‘οΈβ¬οΈ |
| Asset Turnover | Xx | Yx | Zx | β¬οΈβ¬οΈβ¬οΈ |
| RONA | X% | Y% | Z% | β¬οΈβ¬οΈβ‘οΈ |
Asset Efficiency Metrics
| Metric | Value | Benchmark | Assessment |
|--------|-------|------------|-------------|
| Asset Turnover | Xx | 1.5x | β
Healthy |
| Working Capital Turnover | Yx | 0.8x | β οΈ Low |
| Inventory Turnover | Zx | 0.6x | π΄ Poor |
| Fixed Asset Utilization | X% | Y% | β Below industry |
Component Analysis
[Component 1]: Net Profit Margin
Current: X%
Driver: [What's affecting margin?]
Improvement: [Action needed] [Repeat for Gross Margin, Operating Margin, Asset Turnover]
Waterfall Chart
Revenue
β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββββββ
β $X M (100%) β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββ€
β Gross Margin: 40% β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββ€
β Operating Margin: 25% β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββ€
β Net Profit Margin: 15% β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββ€
β Asset Turnover: 2.0x β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββ
β
Net Income: $Y M
Key Insights
1. [Insight 1] - [Analysis]
2. [Insight 2] - [Analysis]
Strategic Implications
1. [Implication 1] - [Analysis]
2. [Implication 2] - [Analysis]