Analyze disruptive innovation stocks with Sourcetable AI. Track breakthrough technologies, calculate growth valuations, and identify the next generation of market leaders automatically.
Andrew Grosser
February 16, 2026 • 16 min read
February 2020: Tesla trades at $135 (pre-split $675). Wall Street consensus: overvalued at 5× revenue with erratic profitability. Cathie Wood's ARK Invest publishes a bull case of $1,400 ($7,000 pre-split) based on exponential EV adoption curves, autonomous driving platform value, and battery cost declines hitting Wright's Law trajectories. Her model: global EV sales grow from 2.2M (2019) to 40M by 2025, Tesla captures 20% share, autonomous taxi networks generate $0.70/mile in platform fees, and energy storage scales to 15% of revenue. Calculate 2025 revenue: (8M vehicles × $45K ASP) + (2M robo-taxis × 30K miles/year × $0.70) + ($90B energy/services) = $462B. Apply 7× revenue multiple (SaaS-like margins from software) = $3.2T market cap = $1,500/share (7× pre-split). Now build this analysis for 40 disruptive stocks across genomics, fintech, AI, and robotics simultaneously.
Excel can't handle disruptive growth modeling at scale. You need TAM (total addressable market) projections that compound at 40-80% annually—not linear growth, exponential S-curves where adoption accelerates then plateaus. Model Wright's Law cost reductions: every doubling of cumulative production drops costs by 15-25%, requiring you to track unit volumes and calculate logarithmic cost curves. Build DCF models with negative current cash flows but 60% revenue CAGR for 5 years, then 25% for years 6-10, requiring you to write nested IF statements for multi-stage growth. Track non-financial KPIs: monthly active users (MAUs), platform take rates, genomic sequencing costs per genome, battery capacity installed (GWh), autonomous miles driven. Compare 15 genomics companies using CRISPR efficacy rates, pipeline drug counts, and time-to-market metrics that don't exist in 10-Ks. Then stress-test: what if adoption is 3 years slower? Revenue multiples compress from 10× to 4×? Suddenly your $1,500 Tesla target becomes $320. Sourcetable handles this chaos. Upload your disruptive watchlist with TAM data, financial projections, KPIs, ask "Which companies are tracking ahead of their adoption curves?" Get instant insights. Request "Build a DCF for this stock assuming 50% revenue growth for 5 years" and it's done in seconds, not hours. sign up free.
Traditional spreadsheet analysis of disruptive growth stocks involves building complex financial models with multiple scenario analyses, tracking dozens of key performance indicators across different time horizons, and constantly updating assumptions as new data emerges. You're toggling between tabs for different companies, manually copying earnings data, writing nested IF statements to calculate addressable market penetration rates, and struggling to visualize which innovations are actually gaining commercial traction.
Sourcetable eliminates this friction entirely. The AI understands growth investing terminology and automatically performs the calculations that matter for disruptive companies. Ask 'What's the revenue CAGR for my AI stocks over the past 3 years?' and get instant answers with visual breakdowns. Request 'Compare gross margin expansion across my genomics watchlist' and see formatted tables highlighting which companies are achieving operational leverage.
The platform excels at handling the unique metrics disruptive growth investors need. While Excel requires you to manually calculate customer acquisition costs, lifetime value ratios, research intensity percentages, and technology adoption S-curves, Sourcetable's AI recognizes these concepts and computes them automatically from your raw data. Upload quarterly reports and simply ask 'Which companies are improving their unit economics?' The AI analyzes CAC/LTV ratios, identifies trends, and presents findings in clear visualizations.
For investors tracking multiple innovation themes simultaneously—maybe 15 AI stocks, 12 genomics companies, 8 fintech disruptors, and 10 clean energy plays—Sourcetable becomes indispensable. Instead of maintaining separate Excel workbooks for each sector with hundreds of formulas that break when you add new data, you have one intelligent workspace where natural language queries instantly surface insights across your entire universe. 'Show me all companies with accelerating revenue growth and expanding gross margins' returns exactly what you need in seconds, not hours of manual filtering and formula debugging.
Cathie Wood's approach to disruptive innovation investing has generated significant attention because it identifies companies at inflection points—moments when new technologies transition from niche applications to mainstream adoption. These opportunities can deliver 10x or even 100x returns, but only if you can identify the right companies before the market fully prices in their potential. Sourcetable gives you the analytical tools to spot these opportunities faster and with greater confidence.
Disruptive growth analysis requires tracking metrics that traditional value investors ignore. You need to calculate revenue growth acceleration (not just growth rate, but whether growth itself is speeding up), gross margin expansion trajectories, R&D efficiency ratios, and customer cohort retention curves. In Excel, each of these requires custom formulas, careful cell referencing, and constant maintenance as you add new quarterly data.
Sourcetable's AI understands these concepts natively. Upload a company's financial history and ask 'Is revenue growth accelerating?' The AI automatically calculates quarter-over-quarter and year-over-year growth rates, computes second derivatives to measure acceleration, and presents a clear answer with supporting visualizations. For a genomics company growing revenue from $50M to $75M to $120M over three quarters, Sourcetable instantly identifies this as strong acceleration (50% growth followed by 60% growth) and highlights it as a positive signal.
One of Cathie Wood's core principles is focusing on massive addressable markets—technologies that could disrupt trillion-dollar industries. Calculating market penetration rates and projecting adoption curves typically requires building elaborate scenario models in Excel with multiple assumptions about market size, growth rates, competitive dynamics, and technology adoption timelines.
With Sourcetable, you can upload market research data and company revenues, then ask 'What's the current market penetration for autonomous vehicle technology?' The AI calculates the percentage of total addressable market captured, projects future penetration based on historical adoption curves, and generates S-curve visualizations showing when mainstream adoption might accelerate. For an electric vehicle company with $30B in annual revenue facing a $5 trillion global auto market, Sourcetable instantly shows 0.6% penetration and can model scenarios where penetration reaches 5%, 10%, or 20% over different time horizons.
Disruptive growth investors typically monitor 30-50 companies across multiple innovation themes. Each company reports earnings on different schedules, uses different accounting treatments, and focuses on different key performance indicators. Maintaining this in Excel means dozens of linked workbooks, manual data entry after each earnings release, and constant formula errors when structures change.
Sourcetable centralizes everything in one intelligent workspace. Upload your entire watchlist with historical financials, then ask portfolio-wide questions: 'Which companies beat revenue expectations last quarter?' or 'Show me all stocks where gross margins expanded by more than 200 basis points year-over-year.' The AI instantly scans your entire dataset, performs the calculations, and returns ranked results. When new earnings data arrives, simply paste it in and ask updated questions—no formula maintenance required.
Understanding which companies are winning in emerging technology races requires comparing competitive metrics: Who's growing faster? Who has better unit economics? Who's achieving operational leverage as they scale? In Excel, this means building comparison tables with multiple companies in columns and dozens of metrics in rows, then manually updating each cell and trying to spot patterns.
Sourcetable makes competitive analysis conversational. With data for multiple AI chip companies loaded, ask 'Compare revenue growth and gross margins across my semiconductor watchlist.' The AI generates a formatted comparison table instantly, highlighting leaders in each category. Follow up with 'Which company has the best combination of growth and profitability?' and get an intelligent analysis that considers multiple factors simultaneously. For investors comparing NVIDIA's 200%+ revenue growth at 70% gross margins against AMD's 80% growth at 50% margins, Sourcetable clearly shows NVIDIA's superior positioning.
Valuing disruptive growth companies requires projecting future cash flows under different scenarios: What if revenue growth continues at 50% annually? What if it decelerates to 30%? What if gross margins expand to 60% as the company achieves scale? Traditional Excel models become enormous, with separate tabs for bull, base, and bear cases, each containing hundreds of linked formulas.
Sourcetable simplifies scenario modeling through natural language. Upload a company's current financials and ask 'Project revenue for 5 years assuming 40% annual growth with 300 basis points of annual gross margin expansion.' The AI builds the projection instantly and calculates implied valuations at different multiples. Change your assumptions by simply asking 'Now show me 30% growth instead'—no need to rebuild formulas or hunt for the right cells to modify. For a fintech company at $500M revenue today, Sourcetable can instantly show scenarios ranging from $2.5B (30% CAGR) to $3.8B (50% CAGR) in five years.
Implementing Cathie Wood's disruptive growth strategy in Sourcetable follows a straightforward process that replaces hours of Excel work with minutes of intelligent conversation. Here's how to build and maintain a disruptive innovation portfolio using AI-powered analysis.
Start by identifying the disruptive themes you want to track. Cathie Wood focuses on five major innovation platforms: artificial intelligence, genomic sequencing, blockchain technology, robotics and automation, and energy storage. Within each theme, you'll identify 10-20 companies that are technology leaders or emerging challengers.
Create a simple spreadsheet with your watchlist: company names, ticker symbols, sectors, and innovation themes. Upload this to Sourcetable. Unlike Excel where this becomes a static reference table, Sourcetable treats your watchlist as a living database you can query intelligently. Ask 'How many AI companies am I tracking?' or 'Show me all genomics stocks' and get instant answers.
For each company on your watchlist, gather historical financial data: quarterly revenue, gross profit, operating expenses, R&D spending, and cash flow. Also collect key operating metrics specific to each business model—monthly active users for software companies, genomic tests processed for sequencing businesses, energy storage capacity for battery manufacturers.
Import this data into Sourcetable by copying from your existing sources or uploading CSV files. The AI automatically recognizes financial statement structures and organizes data appropriately. No need to format columns perfectly or write VLOOKUP formulas to link data across sheets—Sourcetable understands relationships between companies, time periods, and metrics automatically.
With your data loaded, start asking analytical questions. 'Calculate year-over-year revenue growth for all companies' generates a complete table showing growth rates. 'Which companies have revenue growth above 40%?' filters to high-growth names. 'Show me gross margin trends over the past 8 quarters' creates visualizations for each company showing whether margins are expanding (a sign of operational leverage) or contracting (potential competitive pressure).
For more sophisticated analysis, ask about composite metrics: 'Calculate the Rule of 40 score for my SaaS companies' (revenue growth rate plus free cash flow margin). Sourcetable performs the calculation automatically. A company growing 50% with -5% FCF margin scores 45—above the 40 threshold indicating healthy growth efficiency. You can then ask 'Rank companies by Rule of 40 score' to identify the best-positioned businesses.
Cathie Wood's strategy emphasizes identifying companies at inflection points where growth is accelerating, not just maintaining steady rates. This requires calculating second-order metrics—the rate of change of growth rates themselves.
Ask Sourcetable: 'Which companies show accelerating revenue growth over the past 4 quarters?' The AI calculates sequential growth rates, identifies where each quarter's growth exceeded the previous quarter's, and highlights companies in acceleration mode. For example, a company growing 30%, then 35%, then 42%, then 48% shows clear acceleration—a powerful bullish signal. Sourcetable identifies this pattern automatically while Excel would require complex formulas comparing each quarter's growth to the prior quarter's growth.
Within each innovation theme, you want to identify leaders and laggards. Ask 'Compare all AI chip companies on revenue growth, gross margin, and R&D intensity.' Sourcetable generates a comparison table with all three metrics for each company, making it easy to spot which businesses combine strong growth with improving profitability and sustained innovation investment.
Follow up with synthesis questions: 'Which AI company has the best overall profile?' The AI considers multiple factors and provides a reasoned analysis. For a portfolio containing NVIDIA (150% growth, 70% margins, 20% R&D), AMD (80% growth, 50% margins, 25% R&D), and Intel (5% growth, 45% margins, 15% R&D), Sourcetable clearly identifies NVIDIA's superior combination of growth and profitability despite lower R&D intensity.
Disruptive growth stocks trade on future potential, not current earnings. Valuation requires projecting revenues several years forward and applying appropriate multiples based on growth rates and market positioning.
Upload current stock prices and shares outstanding, then ask 'What's the implied valuation if this company reaches $5 billion in revenue at a 10x sales multiple?' Sourcetable calculates the total enterprise value ($50B) and can compare it to current market cap to show potential upside. For scenario analysis, ask 'Show me valuations under 30%, 40%, and 50% annual growth scenarios'—the AI generates a comparison table with projected revenues and valuations under each assumption.
As companies report earnings and release new data, maintaining your analysis in Excel means hunting down the right cells and updating formulas across multiple sheets. In Sourcetable, simply paste new quarterly data and re-ask your questions. 'Show me updated growth rates' recalculates everything instantly with the new information included.
Set up regular analytical routines: After each earnings season, ask 'Which companies beat revenue expectations?' and 'Show me quarter-over-quarter growth acceleration.' Sourcetable becomes your analytical partner, handling calculations while you focus on investment decisions. The AI remembers your data structure, so you're never rebuilding formulas or fixing broken references.
Disruptive growth investing applies across multiple innovation sectors and investor types. Here are specific scenarios where Sourcetable's AI-powered analysis delivers immediate value for investors following Cathie Wood's methodology.
An investor wants to identify which AI companies are positioned to dominate the next wave of artificial intelligence applications. They're tracking 25 companies across AI chips, cloud AI services, enterprise AI software, and AI-powered robotics. Each company reports different metrics—chip companies focus on data center revenue and inference performance, software companies track ARR and net retention rates, robotics companies measure units deployed and utilization rates.
Using Sourcetable, they upload financial data and operating metrics for all 25 companies spanning the past 3 years. They ask: 'Which AI companies show both accelerating revenue growth and expanding gross margins?' Sourcetable analyzes the entire dataset and identifies 7 companies meeting both criteria. Follow-up question: 'Of those 7, which have the highest R&D intensity?' The AI instantly ranks them by R&D spending as a percentage of revenue, revealing which companies are reinvesting most aggressively in future innovation.
The investor then asks 'Create a scatter plot showing revenue growth versus gross margin for all AI companies.' Sourcetable generates the visualization in seconds, clearly showing which companies occupy the desirable top-right quadrant (high growth, high margins). A semiconductor company growing 180% annually at 72% gross margins stands out dramatically compared to a software company growing 40% at 65% margins. This visual analysis, which would take 30 minutes to build in Excel, takes 10 seconds in Sourcetable.
A biotechnology investor believes genomic sequencing will transform healthcare over the next decade, similar to how smartphones transformed communications. They want to identify which sequencing companies are capturing market share as the technology moves from research applications to clinical diagnostics and eventually to consumer wellness.
They upload data for 8 genomics companies including quarterly test volumes, revenue per test, total addressable market estimates, and competitive positioning data. In Excel, analyzing adoption curves requires building complex models with S-curve functions, market penetration calculations, and scenario analyses across multiple tabs.
In Sourcetable, they simply ask: 'What's the current market penetration for clinical genomic testing?' The AI calculates that current annual test volumes represent approximately 2.3% of the estimated addressable market of patients who could benefit from genomic testing. Follow-up: 'Project test volumes if penetration reaches 10% over 5 years.' Sourcetable calculates the implied annual test volume (a 4.3x increase) and shows revenue implications for each company based on their current market share.
The investor then asks 'Which companies are gaining market share?' Sourcetable analyzes each company's test volume growth relative to overall market growth, identifying two companies growing faster than the market (indicating share gains) versus three growing slower (losing share). This competitive dynamic analysis, requiring complex relative growth calculations in Excel, happens conversationally in Sourcetable.
A growth investor is analyzing fintech companies disrupting traditional banking and payment systems. These businesses often operate at losses while growing rapidly, making traditional valuation metrics like P/E ratios useless. Instead, the investor needs to evaluate unit economics: customer acquisition cost (CAC), lifetime value (LTV), payback periods, and cohort retention curves.
They're tracking 12 fintech companies across digital banking, payment processing, and lending platforms. Each company reports slightly different metrics—some disclose CAC directly, others report marketing spend that must be divided by new customer additions. Some provide LTV calculations, others require building models from average revenue per user and retention data.
Using Sourcetable, the investor uploads all available data and asks: 'Calculate LTV/CAC ratio for all companies where data is available.' The AI recognizes different data formats, performs appropriate calculations, and returns a ranked list. A digital bank with $250 LTV and $50 CAC shows a healthy 5.0x ratio, while a lending platform with $180 LTV and $90 CAC shows a concerning 2.0x ratio (below the 3.0x threshold for sustainable unit economics).
Follow-up question: 'Show me trends in customer acquisition cost over the past 8 quarters.' Sourcetable generates line charts for each company. The investor immediately sees that two companies have CAC rising 40%+ (concerning—customer acquisition is getting more expensive), while three companies show declining CAC (positive—they're achieving efficiency as they scale). This trend analysis would require building separate charts for each company in Excel; Sourcetable creates all visualizations in one query.
An investor wants to build a concentrated portfolio of 15-20 disruptive growth stocks following Cathie Wood's high-conviction approach. They need to balance exposure across different innovation themes while overweighting their highest-conviction ideas and managing overall portfolio volatility.
They upload their watchlist of 40 potential holdings with quality scores (based on growth rates, margins, competitive positioning), conviction levels (high/medium/low), and volatility data (standard deviation of returns). In Excel, portfolio optimization requires complex formulas, constraint modeling, and often external optimization tools.
In Sourcetable, they ask: 'Recommend a 15-stock portfolio with maximum 30% in any single innovation theme and position sizes ranging from 3% to 10% based on conviction levels.' The AI analyzes the data, applies the constraints, and suggests a portfolio allocation. High-conviction AI stocks get 8-10% allocations, medium-conviction genomics stocks get 5-6%, and lower-conviction energy storage positions get 3-4%.
The investor then asks 'What's the weighted average revenue growth rate of this portfolio?' Sourcetable calculates that the proposed portfolio has a weighted average growth rate of 67% annually—significantly higher than market averages and consistent with a disruptive growth mandate. Follow-up: 'Show me the theme allocation breakdown.' The AI presents a clear chart: 35% AI, 25% genomics, 20% fintech, 15% energy storage, 5% robotics—well-diversified across innovation platforms while maintaining concentrated positions in highest-conviction themes.
If your question is not covered here, you can contact our team.
Contact Us