From financial-analysis
This skill should be used when completing LBO (Leveraged Buyout) model templates in Excel for private equity transactions, deal materials, or investment committee presentations. The skill fills in formulas, validates calculations, and ensures professional formatting standards that adapt to any template structure.
npx claudepluginhub rodaquino-omni/crowtech-healthcare-finance --plugin financial-analysisThis skill uses the workspace's default tool permissions.
---
Provides Ktor server patterns for routing DSL, plugins (auth, CORS, serialization), Koin DI, WebSockets, services, and testApplication testing.
Conducts multi-source web research with firecrawl and exa MCPs: searches, scrapes pages, synthesizes cited reports. For deep dives, competitive analysis, tech evaluations, or due diligence.
Provides demand forecasting, safety stock optimization, replenishment planning, and promotional lift estimation for multi-location retailers managing 300-800 SKUs.
This skill uses templates. Always check for an attached template file first.
Before starting any LBO model:
examples/LBO_Model.xlsx as the starting point.IMPORTANT: When a file like LBO_Model.xlsx is attached, you MUST use it as the template — do not build from scratch. For CrowTech's lower middle-market healthcare targets ($25M-$250M EV), the standard template structure fits most deals.
Office JS (Excel Add-in): Use Excel.run(async (context) => {...}) directly — no Python/openpyxl. Write formulas via range.formulas = [["=B5*B6"]]. No separate recalc step. Use range.format.* for styling. Merged cell pitfall: write value to top-left cell first, then merge + format the full range.
Standalone .xlsx: Use Python/openpyxl. Write formula strings, then run recalc.py.
examples/LBO_Model.xlsx or user template. Don't invent layout.=B4*B5, =SUM())=B9)=Assumptions!B5)#1F4E79, white bold text#D9E1F2, black bold text#F2F2F2 or white#BDD7EE, black bold text3 blues + 1 grey + white. If the template uses its own colors, follow the template.
$#,##0;($#,##0);"-" or $#,##0.00.0%0.0"x" (or 0.00"x" for MOIC/detailed ratios)Before filling formulas: examine template structure, ask user if anything is unclear, confirm key assumptions. For CrowTech deals, confirm entry EV, equity check, debt structure (typically 40-55% leverage for LMM healthcare services), hold period (4-6 yrs), and exit multiple assumption.
[8.0x, 9.0x, 10.0x, 11.0x, 12.0x]). Center cell IRR/MOIC MUST equal the model's actual IRR/MOIC.#BDD7EE) + bold.$A5 for row input, B$4 for column input).python /mnt/skills/public/xlsx/recalc.py model.xlsx
Must return success with zero errors.
#BDD7EE, bold)| Error | What Goes Wrong | How to Fix |
|---|---|---|
| Hardcoding calculated values | Model doesn't update | Use formulas referencing source cells |
| Wrong cell refs after copying | Formulas point to wrong cells | Verify links, use $ anchoring |
| Circular reference errors | Model can't calculate | Use beginning balances for interest |
| Sections don't balance | Totals don't match | Ensure one item is the plug |
| Negative balances impossible | Paying more than available | MAX(0, ...) or MIN |
| IRR/return errors | Wrong signs or ranges | Check signs and formula ranges |
| Sensitivity table same value | Formula not varying | Use mixed references ($A5, B$4) |
| Roll-forwards don't tie | Beginning != prior ending | Verify period links |
| Inconsistent sign conventions | Additions -> subtractions | Follow template's convention |
This skill produces IB-quality LBO models by filling templates with correct formulas, proper formatting, and validated calculations.