# Report Structure and Templates This document provides complete page-by-page templates and formatting requirements for the earnings update DOCX report. ## Complete Report Structure **REPORT STRUCTURE:** --- ## PAGE 1: EARNINGS SUMMARY **Top Section - Header:** ``` [COMPANY NAME] ([TICKER]) [QUARTER] [YEAR] EARNINGS UPDATE [Current Date] Rating: [MAINTAIN/RAISE/LOWER] [RATING] Price (as of [date]): $XX.XX Price Target: [OLD → NEW if changed, or MAINTAIN $XXX] ``` **Top Section - Quick Summary Box:** ``` EARNINGS SUMMARY ───────────────────────────────────────────────── Q[X] [YEAR] RESULTS: [BEAT / INLINE / MISS] Reported Est Variance Revenue $X,XXX $X,XXX +$XXX (+X%) EPS (Adj) $X.XX $X.XX +$X.XX (+X%) Key Takeaways: ■ [Takeaway 1 - one sentence] ■ [Takeaway 2 - one sentence] ■ [Takeaway 3 - one sentence] ``` **Main Content - Investment Impact (3-4 bullets):** Use ■ character with **bold headers** and paragraph-length explanations: ``` ■ **Results beat on strong [segment/geography/product], maintaining positive momentum** Q[X] revenue of $X.XB exceeded our $X.XB estimate by X% and consensus by X%, driven primarily by [specific driver]. [Segment] revenue grew X% YoY (vs. our X% estimate), while [segment] grew X% (vs. X% estimate). Management highlighted [specific products/initiatives] as key growth drivers and maintained confident tone on outlook. The beat demonstrates [thesis point], reinforcing our positive view. ■ **Margins expanded XXbps YoY despite [headwind], showcasing operational leverage** [Detailed margin analysis paragraph...] ■ **Guidance raised / maintained / lowered - implies [interpretation]** [Detailed guidance analysis paragraph...] ■ **Maintaining [RATING] with [raised/unchanged] $XXX price target** [Investment conclusion paragraph...] ``` **Bottom Section - Updated Estimates Table:** ``` UPDATED FINANCIAL ESTIMATES ───────────────────────────────────────────────────────────────── FY2024E (OLD) FY2024E (NEW) Change FY2025E (NEW) Revenue ($M) XX,XXX XX,XXX +X% XX,XXX Revenue Growth (%) X.X% X.X% +XXbps X.X% Gross Margin (%) XX.X% XX.X% +XXbps XX.X% EBITDA ($M) X,XXX X,XXX +X% X,XXX EBITDA Margin (%) XX.X% XX.X% +XXbps XX.X% EPS (Adjusted) ($) X.XX X.XX +X% X.XX P/E (x) XX.Xx XX.Xx -X% XX.Xx Note: "E" = Estimate. Old estimates from [prior report date]. Source: Company data, [Firm Name] estimates. ``` --- ## PAGES 2-3: DETAILED RESULTS ANALYSIS Break down results by: ### Revenue Analysis (1 page) - Total revenue beat/miss explanation - Segment/geographic/product breakdown - YoY and sequential trends - Comparison to guidance (if provided) **Table: Quarterly Revenue Progression** ``` Q[X-3] Q[X-2] Q[X-1] Q[X] YoY Chg QoQ Chg Total Revenue ($M) X,XXX X,XXX X,XXX X,XXX +X% +X% [Segment A] ($M) XXX XXX XXX XXX +X% +X% [Segment B] ($M) XXX XXX XXX XXX +X% +X% [Segment C] ($M) XXX XXX XXX XXX +X% +X% Note: Q[X] = [Quarter] [Year] Source: Company reports, [Firm Name] analysis ``` ### Profitability Analysis (1 page) - Gross margin analysis (drivers, trends) - Operating margin analysis - Below-the-line items (interest, tax, etc.) - EPS reconciliation (adjusted vs. GAAP) **Table: Margin Analysis** ``` Q[X-3] Q[X-2] Q[X-1] Q[X] YoY Chg Gross Margin (%) XX.X% XX.X% XX.X% XX.X% +XXbps Operating Margin (%) XX.X% XX.X% XX.X% XX.X% +XXbps Net Margin (%) XX.X% XX.X% XX.X% XX.X% +XXbps Key Drivers: + [Positive driver 1] + [Positive driver 2] - [Negative driver 1] - [Negative driver 2] ``` **Embed 2-3 charts on these pages:** - Chart 1: Quarterly revenue progression - Chart 2: Quarterly EPS progression - Chart 3: Margin trends --- ## PAGES 4-5: KEY METRICS & GUIDANCE ### Business Metrics (1 page) - Customer count, ARPU, units, store count, etc. - Whatever metrics company emphasizes - Comparison to expectations - Trends and outlook **Table: Key Operating Metrics** ``` Q[X-3] Q[X-2] Q[X-1] Q[X] YoY Chg Our Est Var [Metric 1] XXX XXX XXX XXX +X% XXX +X% [Metric 2] XXX XXX XXX XXX +X% XXX +X% [Metric 3] XXX XXX XXX XXX +X% XXX +X% Source: Company reports ``` ### Guidance & Outlook (1 page) - What guidance was provided (if any) - Comparison to prior guidance - Comparison to Street estimates - Our assessment of achievability - Key assumptions **If guidance provided:** ``` MANAGEMENT GUIDANCE vs. ESTIMATES ───────────────────────────────────────────────────────────────── New Guidance Old Guidance Change Street FY2024E Revenue $XX-XXB $XX-XXB Raised $XX.XB FY2024E EPS $X.XX-X.XX $X.XX-X.XX Raised $X.XX Our Take: [Brief assessment of guidance] ``` **Embed 2-3 charts:** - Chart 4: Key metrics trends - Chart 5: Guidance vs. Street comparison - Chart 6: Revenue by segment/geography --- ## PAGES 6-7: UPDATED INVESTMENT THESIS ### Thesis Impact Assessment (1-2 pages) For each key thesis pillar, assess impact of results: ``` ■ **Thesis Pillar 1: [Original thesis statement]** Status: [STRENGTHENED / UNCHANGED / WEAKENED] Q[X] results [supported / challenged] this thesis pillar because [specific evidence from results]. [Detailed analysis of 150-200 words explaining how results impact this specific thesis element.] ■ **Thesis Pillar 2: [Original thesis statement]** [Similar analysis] ■ **Thesis Pillar 3: [Original thesis statement]** [Similar analysis] ``` ### Risks Update (0.5 pages) - Any new risks identified? - Have existing risks been mitigated or worsened? - Brief assessment **Embed 1-2 charts:** - Chart 7: Valuation vs. historical - Chart 8: Estimate revision comparison --- ## PAGES 8-10: VALUATION & ESTIMATES ### Updated Valuation (1-2 pages) **DCF Update:** ``` Updated DCF inputs based on Q[X] results: - Revenue growth FY24E: X.X% → X.X% (raised/lowered) - EBIT margin FY24E: XX.X% → XX.X% - Terminal growth: X.X% (unchanged) - WACC: X.X% (unchanged) Updated DCF fair value: $XXX (prior: $XXX) ``` **Comparable Companies:** ``` [Company] trades at XX.Xx NTM P/E vs. peer median of XX.Xx (-X% discount). Given [rationale], we believe [premium/discount/inline] valuation is warranted. ``` **Price Target Methodology:** ``` Our $XXX price target (prior: $XXX) is based on: - XX% DCF - XX% NTM P/E of XX.Xx (vs. peers at XX.Xx) - XX% EV/EBITDA Implied upside: +XX% from current price of $XXX ``` ### Updated Estimates Detail Provide updated estimates for at least current year and next year: ``` DETAILED ESTIMATE UPDATES ───────────────────────────────────────────────────────────────── FY2024E FY2025E Old New Change New Estimate Revenue ($B) XX.X XX.X +X.X% XX.X [Segment A] XX.X XX.X +X.X% XX.X [Segment B] XX.X XX.X +X.X% XX.X Gross Profit ($B) XX.X XX.X +X.X% XX.X Gross Margin (%) XX.X% XX.X% +XXbps XX.X% EBITDA ($B) X.X X.X +X.X% X.X EBITDA Margin (%) XX.X% XX.X% +XXbps XX.X% Operating Income X.X X.X +X.X% X.X Op Margin (%) XX.X% XX.X% +XXbps XX.X% Net Income ($B) X.X X.X +X.X% X.X EPS - Adjusted ($) X.XX X.XX +X.X% X.XX EPS - GAAP ($) X.XX X.XX +X.X% X.XX P/E (x) XX.Xx XX.Xx XX.Xx EV/EBITDA (x) XX.Xx XX.Xx XX.Xx Source: [Firm Name] estimates ``` **Embed 1-2 charts:** - Chart 9: P/E or EV/EBITDA bands - Chart 10: Price target walk (old → new) --- ## PAGES 11-12: APPENDIX (Optional) ### Detailed Quarterly Models (if space allows) - Income statement detail - Cash flow highlights - Balance sheet highlights ### Call Transcript Highlights (optional) - Key Q&A excerpts - Notable management quotes ### Peer Comparison (if peers have reported) - How results compare to competitors - Market share implications **Embed final charts:** - Chart 11: Peer comparison - Chart 12: Additional supporting charts --- ## FORMATTING REQUIREMENTS ### 1. Page 1 Requirements - Clear rating (MAINTAIN OUTPERFORM, RAISE TO BUY, etc.) - Updated price target prominently displayed - Summary table with old/new estimates - 3-4 paragraph-length bullets with ■ character ### 2. All Tables Requirements - Source line at bottom - Clear column headers - Shading for header rows ### 3. All Charts Requirements - "Figure X - [Title]" caption above - "Source: [Source]" line below - Professional styling ### 4. Year Notation - Use A for actual (Q3'24A) - Use E for estimate (Q4'24E) ### 5. Writing Style - Lead with numbers ("Revenue grew 15% to $1.2B" not "Strong revenue growth") - Use "vs." not "versus" - Be direct and concise - Focus on what's NEW ### 6. Hyperlink Requirements ⭐⭐⭐ - ALL URLs must be clickable hyperlinks in Word - Blue, underlined text that opens on Ctrl+Click - Display text meaningful (not raw URL) - Every source citation should have clickable link where applicable - No plain text URLs - always format as hyperlinks ## Citation Examples for Specific Content ### For Beat/Miss Analysis: ``` Revenue of $2.45B beat consensus of $2.39B by $60M (2.5%)¹ ¹ Bloomberg consensus as of market close November 6, 2024; Company earnings release November 7, 2024 [Hyperlink "earnings release" to: https://investor.company.com/news/q3-2024-earnings] ``` ### For Guidance: ``` Management raised FY2024 revenue guidance to $9.8-10.0B from prior $9.5-9.7B² ² Q3 2024 Earnings Call, November 7, 2024, CFO prepared remarks [Hyperlink "Earnings Call" to: https://seekingalpha.com/article/...] Prior guidance from Q2 earnings call August 8, 2024 [Hyperlink "Q2 earnings call" to August transcript] ``` ### For Key Metrics: ``` Enterprise customers grew 23% YoY to 845, with net revenue retention at 128%³ ³ Q3 2024 10-Q, page 23 [Hyperlink "10-Q" to: https://www.sec.gov/cgi-bin/viewer?accession=...] Q3 2024 Investor Presentation slide 8 [Hyperlink "Investor Presentation" to PDF] ```