Financial Modeling Use Cases

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)

// Historical Revenue Data
=TICKERDATA.DATA("AAPL", "Revenue", 2023)
=TICKERDATA.DATA("AAPL", "Revenue", 2022)
=TICKERDATA.DATA("AAPL", "Revenue", 2021)
=TICKERDATA.DATA("AAPL", "Revenue", 2020)
=TICKERDATA.DATA("AAPL", "Revenue", 2019)
// Historical Growth Rates
=TICKERDATA.DATA("AAPL", "3 YR Revenue GPS", "ttm")
=TICKERDATA.DATA("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 Margin", 2023)
=TICKERDATA("AAPL", "Gross Profit Margin", 2022)
=TICKERDATA("AAPL", "Gross Profit Margin", 2021)
// Operating Margin trend
=TICKERDATA("AAPL", "Operating Profit Margin", 2023)
=TICKERDATA("AAPL", "Operating Profit Margin", 2022)
// Net Margin trend
=TICKERDATA("AAPL", "Net Profit Margin", 2023)
=TICKERDATA("AAPL", "Net Profit Margin", 2022)

// Gross Margin trend
=TICKERDATA.DATA("AAPL", "Gross Profit Margin", 2023)
=TICKERDATA.DATA("AAPL", "Gross Profit Margin", 2022)
=TICKERDATA.DATA("AAPL", "Gross Profit Margin", 2021)
// Operating Margin trend
=TICKERDATA.DATA("AAPL", "Operating Profit Margin", 2023)
=TICKERDATA.DATA("AAPL", "Operating Profit Margin", 2022)
// Net Margin trend
=TICKERDATA.DATA("AAPL", "Net Profit Margin", 2023)
=TICKERDATA.DATA("AAPL", "Net Profit Margin", 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", "Common Dividends Paid", 2023)

// Income Statement data
=TICKERDATA.DATA("AAPL", "Revenue", 2023)
=TICKERDATA.DATA("AAPL", "Net Income", 2023)
=TICKERDATA.DATA("AAPL", "EPS", 2023)
// Balance Sheet data
=TICKERDATA.DATA("AAPL", "Total Assets", 2023)
=TICKERDATA.DATA("AAPL", "Total Liabilities", 2023)
=TICKERDATA.DATA("AAPL", "Total Equity", 2023)
=TICKERDATA.DATA("AAPL", "Cash And Cash Equivalents", 2023)
=TICKERDATA.DATA("AAPL", "Total Debt", 2023)
// Cash Flow data
=TICKERDATA.DATA("AAPL", "Operating Cash Flow", 2023)
=TICKERDATA.DATA("AAPL", "Capital Expenditure", 2023)
=TICKERDATA.DATA("AAPL", "Free Cash Flow", 2023)
=TICKERDATA.DATA("AAPL", "Common 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:

Scenario	Revenue Growth	Margin Change	Weight
Bear	5%	-2%	25%
Base	10%	0%	50%
Bull	15%	+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

// Q1-Q4 Revenue for a year
=TICKERDATA.DATA("AAPL", "Revenue", 2023, "Q1")
=TICKERDATA.DATA("AAPL", "Revenue", 2023, "Q2")
=TICKERDATA.DATA("AAPL", "Revenue", 2023, "Q3")
=TICKERDATA.DATA("AAPL", "Revenue", 2023, "Q4")
// Calculate sequential growth
=(Q2 - Q1) / Q1

Use Case: Peer Comparison Model

Compare financial performance across peers:

Metric	AAPL	MSFT	GOOGL
Revenue	`=TICKERDATA("AAPL", "Revenue", "ttm")=TICKERDATA.DATA("AAPL", "Revenue", "ttm")`	`=TICKERDATA("MSFT", "Revenue", "ttm")=TICKERDATA.DATA("MSFT", "Revenue", "ttm")`	`=TICKERDATA("GOOGL", "Revenue", "ttm")=TICKERDATA.DATA("GOOGL", "Revenue", "ttm")`
Net Margin	`=TICKERDATA("AAPL", "Net Profit Margin", "ttm")=TICKERDATA.DATA("AAPL", "Net Profit Margin", "ttm")`	…	…
Return On Equity	`=TICKERDATA("AAPL", "Return On Equity", "ttm")=TICKERDATA.DATA("AAPL", "Return On Equity", "ttm")`	…	…

Best Practices

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

Next Steps

Build a DCF Valuation Model
Explore Stock Screening to find candidates