Generate institutional-quality DCF valuation models in Excel with sensitivity analysis.
npx skills add https://github.com/zangjeicy/Hermes --skill dcf-model-zangjeicy
Please help me install this Agent Skill. Skill: dcf-model Source: https://github.com/zangjeicy/Hermes/tree/main/optional-skills/finance/dcf-model Command: npx skills add https://github.com/zangjeicy/Hermes --skill dcf-model-zangjeicy
This skill solves the complexity and inconsistency of manual financial modeling by providing a structured, formula-driven framework for building institutional-quality Discounted Cash Flow (DCF) valuations in Excel.
Use the dcf-model skill to build a five-year valuation model for the company with ticker symbol AAPL using the latest available financial data.
High-intent search queries and answers about installing and using this skill.
You can build a DCF valuation model in Excel by programmatically generating financial projections, WACC calculations, terminal value estimations, and enterprise-to-equity value bridges. The process creates a structured, formula-driven framework for institutional-quality analysis.
Yes, you can automatically generate sensitivity tables for discounted cash flow analysis. The modeling framework programmatically populates 5x5 sensitivity tables to stress-test your valuation assumptions across varying inputs.
You run Bear, Base, and Bull scenario planning for equity valuation using built-in dynamic consolidation logic. The framework supports multi-scenario analysis to compare intrinsic equity value outcomes across different financial projection cases.
Yes, you need openpyxl to create formula-based financial models in Excel. The openpyxl dependency is required for programmatic spreadsheet manipulation and to ensure adherence to strict formula-based modeling standards.
The best way to automate revenue projections and FCF builds for investment banking is using a programmatic modeling skill. It applies structured financial projections directly into Excel, generating fully linked, audit-ready schedules for intrinsic equity valuation.
Yes, this DCF modeling approach works for public company valuation using a ticker symbol. You can source the latest available financial data for a specific ticker to generate a complete five-year intrinsic valuation model.
hvkshetryModel revenue build-up, margin progression, WACC derivation, and terminal value for DCF valuations.
rpoole-devAutomate DCF model creation with SEC filings and analyst reports.
auldsyababuaBuild Excel financial models with DCF, sensitivity, Monte Carlo, and scenario analyses.
JoelLewisEstimate intrinsic company value using DCF, DDM, multiples, and residual income models.
