com um clique
capital-allocation
// Deep dive into capital deployment, buybacks, dividends, and shareholder yield
// Deep dive into capital deployment, buybacks, dividends, and shareholder yield
Verify Daloopa MCP connection and show available skills
Build an industry comp sheet Excel model with deep operational KPIs
Build a multi-tab Excel financial model
Generate an institutional-grade investment banking pitch deck (HTML)
Initiate coverage — generate both research note (HTML) and Excel model (.xlsx)
Generate a professional Word document research note
| name | capital-allocation |
| description | Deep dive into capital deployment, buybacks, dividends, and shareholder yield |
| argument-hint | TICKER |
Perform a deep dive into capital allocation for the company specified by the user: $ARGUMENTS
Before starting, read ../data-access.md for data access methods and ../design-system.md for formatting conventions. Follow the data access detection logic and design system throughout this skill.
Follow these steps:
Look up the company by ticker using discover_companies. Capture:
company_idlatest_calendar_quarter — anchor for all period calculations below (see ../data-access.md Section 1.5)latest_fiscal_quarter../data-access.md Section 4.5Get the current stock price, market cap, and shares outstanding for {TICKER} (see ../data-access.md Section 2 for how to source market data in your environment).
If market data is unavailable, note that market-derived metrics (yields, etc.) cannot be computed and proceed with Daloopa data only.
Calculate 8 quarters backward from latest_calendar_quarter. Pull:
Share Count & Buybacks:
Dividends:
Cash Flow:
Balance Sheet:
M&A / Investments:
Calculate for each quarter where data is available:
Shareholder Returns:
FCF Deployment:
Leverage:
Share Count Dynamics:
Search SEC filings for capital allocation strategy and context. Try multiple searches:
Extract:
Analyze the 8-quarter trend:
Honestly assess whether capital allocation is creating or destroying value:
Assess whether the company is adequately reinvesting in its business or funding returns at the expense of long-term competitiveness.
Pull reinvestment metrics (8 quarters):
Assess reinvestment adequacy:
Value creation vs extraction verdict:
Save to reports/{TICKER}_capital_allocation.html using the HTML report template from ../design-system.md. Write the full analysis as styled HTML with the design system CSS inlined. This is the final deliverable — no intermediate markdown step needed.
Structure the report with these sections:
<h1>{Company Name} ({TICKER}) — Capital Allocation Analysis</h1>
<p>Generated: {date}</p>
<h2>Summary</h2>
{2-3 sentences: How does this company deploy its capital? Key takeaways.}
<h2>Current Snapshot</h2>
<table>
| Metric | Value |
| Market Cap | $XXX |
| Trailing 4Q FCF | $XXX |
| FCF Yield | X.X% |
| Shareholder Yield | X.X% |
| Net Debt / EBITDA | X.Xx |
| Remaining Buyback Authorization | $XXX |
</table>
<h2>Cash Flow & FCF (8 Quarters)</h2>
<table>
| Metric | Q1 | Q2 | ... | Q8 |
{OCF, CapEx, FCF, FCF Margin % — with Daloopa citations}
</table>
<h2>Share Repurchases & Dividends (8 Quarters)</h2>
<table>
| Metric | Q1 | Q2 | ... | Q8 |
{Buyback $, Dividends $, Total Return, Share Count — with Daloopa citations}
</table>
<h2>Shareholder Yield Analysis</h2>
<table>
| Metric | Q1 | Q2 | ... | Q8 |
{Buyback Yield, Div Yield, Total Yield, FCF Payout Ratio}
</table>
<h2>Leverage & Balance Sheet (8 Quarters)</h2>
<table>
| Metric | Q1 | Q2 | ... | Q8 |
{Cash, Debt, Net Debt, Net Debt/EBITDA — with Daloopa citations}
</table>
<h2>Capital Allocation Framework</h2>
{Management's stated priorities from filings, with document citations}
<h2>Reinvestment Assessment</h2>
<table>
| Metric | Q1 | Q2 | ... | Q8 |
{R&D, R&D % Rev, CapEx, CapEx % Rev, key growth KPIs — with Daloopa citations}
</table>
{Analysis: Is the company adequately reinvesting? R&D/CapEx trends vs growth KPI trends. Value creation vs extraction verdict.}
<h2>Buyback Discipline Analysis</h2>
{Analysis of buyback timing vs price, share count reduction trend, authorization remaining}
<h2>M&A Activity</h2>
{Any acquisitions from filings, deal sizes, strategic rationale}
<h2>Key Observations</h2>
<ul>{3-5 bullet points on capital allocation quality, trends, and implications}</ul>
All financial figures must use Daloopa citation format: <a href="https://daloopa.com/src/{fundamental_id}">$X.XX million</a>
Tell the user where the HTML report was saved.
Highlight the key capital allocation story (e.g., "AAPL returned $XX billion to shareholders over the last year, a X.X% shareholder yield, with buybacks accelerating").