Planning, sales, accounting, legal, and project management (4.2K skills)
Draft customer announcements for retiring a product, feature, or plan. Match the message length and communication stages to the impact, explaining the reason, key dates, customer disruption, support, and next steps, including cases with no replacement.
Turn a product retirement decision into a practical checklist matched to its scale. Organize work by lifecycle phase, assign responsible teams, and define approval conditions while covering data, contracts, access, and financial obligations.
Prepare customer-facing teams before announcing a product or feature retirement. Create support FAQs, honest replacement comparisons, objection responses, and escalation guidance, with the scope adjusted from a short support note to a broader training pack.
Prepare detailed reports before company earnings announcements. Organize market expectations, company guidance, key performance measures, possible outcomes, and questions for management, with clear source timestamps and explicit gaps in the available evidence.
Build initial research reports on publicly traded companies, connecting an investment thesis with forecasts, valuation, and risks. Organize supporting sources, distinguish evidence from assumptions, and identify missing information and questions requiring further research.
Draft or review formal investment memos for listed stocks. Organize evidence, valuation, downside scenarios, and conditions for revisiting a recommendation into documents suited to investment committees, portfolio managers, clients, or research teams.
Analyze dated events affecting public stocks, such as mergers and spin-offs. Build timelines, compare possible outcomes, and calculate probability-weighted returns when evidence supports them, with downside analysis and a monitoring plan.
Compare a listed company with relevant peers using valuation multiples, ratios linking price or company value to financial measures. Produce reports or editable workbooks covering peer selection, implied prices, data quality, and valuation assumptions.
Build and refresh calendars of events that may affect public stock investments. Track sources, timing confidence, importance, preparation tasks, and decision implications so upcoming earnings, regulatory milestones, and other developments can be reviewed together.
Analyze how a specific event or policy change affects listed companies, sectors, earnings, valuations, and portfolio decisions. Produce a report linking causes to equity impacts, separating evidence from assumptions and outlining scenarios, counterarguments, and monitoring signals.
Create formula-based Excel valuation workbooks for public companies using discounted cash flow, a method that converts future cash flows into present value. Include per-share estimates, assumption sensitivities, source records, and checks that flag model limitations.
Prepare briefs for public-equity investment meetings, including management calls and investment committees. Rank key questions, identify what to listen for, plan follow-ups to vague answers, and organize evidence requests and actions around the investment decision.
Audit existing public equity investment models and spreadsheets for formula errors, source support, assumptions, and scenario quality. Receive a readiness verdict, an issue log, and prioritized fixes showing whether the model supports its intended decision.
Update copies of public-company Excel models using financial disclosures and mapped input cells. Deliver an updated workbook or review workbook, with source references, change logs, unresolved items, and implications for estimates and valuation where the model supports them.
Develop public equity trade pitches for portfolio managers, covering long, short, or paired positions. Explain the difference from market expectations, potential catalysts, gains and losses, risk considerations, and exit rules, while labeling assumptions and missing evidence.
Routes listed-company investment research to specialist skills for earnings analysis, valuation, financial model updates, and portfolio risk reviews. Helps organize evidence, assumptions, and investment theses into reports, models, memos, and monitoring trackers.
Analyze public-company earnings after results are released, combining reported figures, guidance, estimates, and call evidence. Produces source-backed reports that examine recurring profitability, investment implications, key business drivers, and upcoming events to monitor.
Create concise, source-backed profiles of public companies, covering business drivers, key metrics, valuation context, and risks. Identify stale or missing evidence and distinguish reported facts from estimates to provide a baseline for further investment research.
Turn an existing listed-equity investment view into a position size and hedge plan. Compare loss limits, liquidity, protection costs, and smaller positions, then define the exposures to retain and the conditions for changing the plan.
Analyze how changing assumptions affects an existing public-equity model or investment thesis. Build scenarios and sensitivity tables, identify where the thesis breaks, and define evidence or thresholds that would change an investment decision.
Prepare public-company financial data for analysis models by standardizing periods, units, currencies, and account labels. Produce structured tables with source references, validation results, and clear flags for missing data, conflicts, or disclosure changes.
Screen public equity candidates and prioritize further research using company sources, market data, and supplied notes. Organize promising names, watchlist items, evidence gaps, and rejection risks into a concise review or standalone HTML report.
Estimate the size of a market or business opportunity using traceable sources, explicit assumptions, and inspectable calculations. Compare scenarios, show how changing assumptions affects the estimate, and identify the evidence needed to improve confidence.
Turn business and product metrics into KPI updates for weekly, monthly, or quarterly reviews. Compares actual results with targets and prior periods, includes verified explanations for changes, and states what the findings mean for operations.