Build leveraged buyout Excel models with IRR and MOIC using openpyxl formulas.
npx skills add https://github.com/loteiron/ZeusAgent --skill lbo-model-loteiron
Please help me install this Agent Skill. Skill: lbo-model Source: https://github.com/loteiron/ZeusAgent/tree/main/optional-skills/finance/lbo-model Command: npx skills add https://github.com/loteiron/ZeusAgent --skill lbo-model-loteiron
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings like ws["D20"] = "=B5*B6" into a template workbook, never hardcoding computed values. After filling all sections, run a recalculation script to validate formulas before delivering the .xlsx file.
IRR uses a cash flow series with the investment as negative and exit proceeds as positive across consecutive periods, or XIRR with dates. MOIC equals total proceeds divided by total investment, formatted as a multiple like 0.00x.
Excel's DATA TABLE function does not work reliably with openpyxl. Instead, write explicit formulas in each cell using mixed references like $A5 and B$4 so values vary across the grid, and use odd dimensions such as 5x5 with the base case centered.
Circularity occurs when interest references ending debt balances that depend on cash flow, which itself depends on interest. Break the loop by calculating interest on beginning balances instead of average or ending balances.
Standard conventions use blue font for hardcoded inputs, black for formulas, purple for same-tab cell links, and green for cross-sheet references. Fills stay minimal with dark blue section headers, light blue column headers, and white calculation cells.
rebyteai-templateAnalyze SEC EDGAR filings for financial statements and insider trading data.
davpatel605-beepGenerate PowerPoint presentations from financial models with python-pptx.
MicroTools-HubGenerate formula-driven multi-sheet Excel financial models from assumptions.
KaakatiConstruct DCF, LBO, comparable companies, and three-statement financial models.
