dcf-excel-template
by lazytheta
Generate a professional multi-tab DCF valuation Excel model for any public company. Fully automated — Claude gathers all data, calculates WACC, derives betas, sets growth assumptions, and builds the complete model with peer comparison, sensitivity analysis, and dynamic scenario modeling. User only needs to say "build a DCF for [company]". Uses Sales-to-Capital reinvestment methodology, mid-year discount convention, weighted sector betas from Damodaran, SBC deduction, buyback-adjusted shares, and margin of safety. Trigger when user asks to build a DCF, value a stock, or create a valuation model.