1. Use Cases
  2. Financial Modeling

Financial Modeling Use Cases

Build financial models for investment analysis, budgeting, and forecasting.

Overview

Build sophisticated financial models using Tickerdata to pull real company data automatically.

Use Case: Revenue Forecasting

Project future revenue based on historical trends.

// Historical Revenue Data
=TICKERDATA("AAPL", "Revenue", 2023)
=TICKERDATA("AAPL", "Revenue", 2022)
=TICKERDATA("AAPL", "Revenue", 2021)
=TICKERDATA("AAPL", "Revenue", 2020)
=TICKERDATA("AAPL", "Revenue", 2019)

// Historical Growth Rates
=TICKERDATA("AAPL", "3 YR Revenue GPS", "ttm")
=TICKERDATA("AAPL", "5 YR Revenue GPS", "ttm")

// Project next year
=Current_Rev * (1 + Growth_Rate)

Use Case: Margin Analysis

Track and project profit margins over time.

// Gross Margin trend
=TICKERDATA("AAPL", "Gross Profit Ratio", 2023)
=TICKERDATA("AAPL", "Gross Profit Ratio", 2022)
=TICKERDATA("AAPL", "Gross Profit Ratio", 2021)

// Operating Margin trend
=TICKERDATA("AAPL", "Operating Income Ratio", 2023)
=TICKERDATA("AAPL", "Operating Income Ratio", 2022)

// Net Margin trend
=TICKERDATA("AAPL", "Net Income Ratio", 2023)
=TICKERDATA("AAPL", "Net Income Ratio", 2022)

Use Case: Three-Statement Model

Build an integrated financial model linking income statement, balance sheet, and cash flow.

// Income Statement data
=TICKERDATA("AAPL", "Revenue", 2023)
=TICKERDATA("AAPL", "Net Income", 2023)
=TICKERDATA("AAPL", "EPS", 2023)

// Balance Sheet data
=TICKERDATA("AAPL", "Total Assets", 2023)
=TICKERDATA("AAPL", "Total Liabilities", 2023)
=TICKERDATA("AAPL", "Total Equity", 2023)
=TICKERDATA("AAPL", "Cash And Cash Equivalents", 2023)
=TICKERDATA("AAPL", "Total Debt", 2023)

// Cash Flow data
=TICKERDATA("AAPL", "Operating Cash Flow", 2023)
=TICKERDATA("AAPL", "Capital Expenditure", 2023)
=TICKERDATA("AAPL", "Free Cash Flow", 2023)
=TICKERDATA("AAPL", "Dividends Paid", 2023)

Model Linkages

// Income Statement → Balance Sheet
Retained_Earnings = Prior_RE + Net_Income - Dividends

// Income Statement → Cash Flow
CFO_Start = Net_Income

// Balance Sheet → Cash Flow
Change_in_WC = Current_WC - Prior_WC

Warning

Three-statement models are complex. Start simple and add complexity gradually.

Use Case: Scenario Analysis

Model different business scenarios:

ScenarioRevenue GrowthMargin ChangeWeight
Bear5%-2%25%
Base10%0%50%
Bull15%+2%25%
// Probability-weighted outcome
=Bear_Value*0.25 + Base_Value*0.50 + Bull_Value*0.25

Use Case: Quarterly Trend Analysis

Track quarterly performance:

// Q1-Q4 Revenue for a year
=TICKERDATA("AAPL", "Revenue", 2023, "Q1")
=TICKERDATA("AAPL", "Revenue", 2023, "Q2")
=TICKERDATA("AAPL", "Revenue", 2023, "Q3")
=TICKERDATA("AAPL", "Revenue", 2023, "Q4")

// Calculate sequential growth
=(Q2 - Q1) / Q1

Use Case: Peer Comparison Model

Compare financial performance across peers:

MetricAAPLMSFTGOOGL
Revenue=TICKERDATA("AAPL", "Revenue", "ttm")=TICKERDATA("MSFT", "Revenue", "ttm")=TICKERDATA("GOOGL", "Revenue", "ttm")
Net Margin=TICKERDATA("AAPL", "Net Profit Margin", "ttm")……
ROE=TICKERDATA("AAPL", "ROE", "ttm")……

Best Practices

  1. Start with actual data - Use Tickerdata to pull real numbers as your base
  2. Document assumptions - Make it clear what you’re projecting vs. actual
  3. Build in flexibility - Use named ranges and input cells
  4. Sanity check - Compare your projections to analyst estimates
  5. Version control - Save different model versions as you refine

Next Steps