ModelMonkey for Financial Analysts

ModelMonkey streamlines financial analysis workflows by automating data extraction and research. Instead of manually copying figures from SEC filings or parsing investor presentations, you can describe what you need and let ModelMonkey do the heavy lifting.

This guide covers the ModelMonkey features most relevant to financial analysts:

• Extract data from SEC filings by providing EDGAR URLs
• Analyze uploaded documents like investor presentations and annual reports
• Research companies and markets using web search
• Build financial models with AI-assisted formula creation
• Connect to internal databases for actuals vs. forecast analysis

ModelMonkey can read SEC filings directly from EDGAR URLs and extract the financial data you need. This works with 10-Ks, 10-Qs, 8-Ks, proxy statements, and other public filings.

How to Use It

1. Find the filing on SEC EDGAR (sec.gov/cgi-bin/browse-edgar)
2. Copy the direct URL to the HTML version of the filing
3. Ask ModelMonkey to open the URL and extract specific data

Example Requests

• "Open the 10-K at [EDGAR URL] and extract annual revenue for the last 3 years"
• "Read the 10-Q filing at [URL] and find the gross margin percentage"
• "From this 8-K filing, extract the key financial metrics mentioned"
• "Find the segment breakdown from this annual report"
• "What are the risk factors listed in this 10-K?"

Tips for Best Results

• Use the HTML version of filings (not PDF) for better extraction accuracy
• Be specific about what data you need: "revenue by segment" is better than "financial data"
• For multi-year comparisons, specify the years: "revenue for 2022, 2023, and 2024"

For more details on web access capabilities, see Web Search & URL Access.

Upload investor presentations, earnings reports, credit agreements, or any PDF document for analysis. ModelMonkey extracts text and data, making it searchable and extractable.

Common Use Cases

Investor Presentations

• "Extract the income statement summary from this earnings presentation"
• "Find the guidance figures for next quarter"
• "What are the key strategic initiatives mentioned?"

Annual Reports

• "Pull the five-year financial summary table"
• "Summarize the management discussion and analysis section"
• "Find all mentions of capital expenditure"

Credit Agreements & Contracts

• "Find all debt covenant requirements in this credit agreement"
• "What are the key terms and maturity dates?"
• "Extract the interest rate terms"

Earnings Transcripts

• "Summarize the key points from this earnings call transcript"
• "What did management say about margins?"
• "Find all mentions of guidance or outlook"

How to Upload

1. Click the attachment icon in the message composer
2. Select your PDF file (up to 50MB, 100 pages)
3. Wait for processing to complete
4. Ask questions about the document

For detailed upload instructions, see File Uploads.

Use web search to gather market intelligence, analyst opinions, and recent news. Results can be summarized and added directly to your spreadsheet.

Example Requests

Analyst Coverage

• "Search for recent analyst price targets for AAPL"
• "Find analyst recommendations for Microsoft"
• "What are analysts saying about Tesla's valuation?"

Market Research

• "Search for electric vehicle market size projections"
• "Find recent news about interest rate expectations"
• "What are the major trends in cloud computing spending?"

Competitor Analysis

• "Search for Salesforce's main competitors and their market share"
• "Find recent news about mergers in the fintech space"
• "What are the latest developments in AI chip manufacturing?"

Macroeconomic Data

• "Search for the latest US inflation figures"
• "Find current treasury yield rates"
• "What's the latest GDP growth forecast?"

Search results include titles, descriptions, and links. You can ask ModelMonkey to open specific results for deeper analysis.

ModelMonkey assists with financial model construction by creating formulas, validating calculations, and cross-referencing assumptions with source documents.

Formula Creation

• "Add a DCF calculation using the cash flows in column B and 10% discount rate"
• "Create a CAGR formula for the revenue figures in this range"
• "Add a WACC calculation using the cost of equity and debt in cells D5 and D6"
• "Calculate IRR for these cash flows"

Model Validation

• "Check if the balance sheet balances (assets = liabilities + equity)"
• "Verify that the cash flow statement ties to the change in cash"
• "Are there any circular references in this model?"

Sensitivity Analysis

• "Create a data table showing NPV at different discount rates and growth rates"
• "What happens to the valuation if revenue growth drops to 5%?"
• "Add a scenario analysis section with bull, base, and bear cases"

Cross-Reference with Documents

Upload source documents and verify model assumptions:

• "Compare my revenue assumptions to the guidance in this investor presentation"
• "Verify these margin figures against the latest 10-K"
• "Check if my interest expense matches the credit agreement terms"

If your organization stores financial data in PostgreSQL or BigQuery, you can query it directly from ModelMonkey and combine it with your models.

Example Use Cases

Actuals vs. Forecast

• "Pull last quarter's actuals from our finance database and compare to my forecast"
• "Show me the variance between budgeted and actual expenses by department"
• "What was the actual revenue by product line for Q3?"

Historical Analysis

• "Pull five years of monthly revenue data from our data warehouse"
• "Get historical gross margins by business segment"
• "Show me the trend in operating expenses over the last 8 quarters"

Consolidation

• "Combine subsidiary financials from the database with our holding company model"
• "Pull intercompany eliminations from our consolidation system"

KPI Tracking

• "Get the latest DSO, DPO, and inventory turns from our analytics database"
• "Pull monthly recurring revenue trends from BigQuery"
• "Show me customer acquisition cost over time"

For database connection setup, see External Data Connections.

Verify Extracted Figures
Always spot-check extracted data against the source document, especially for material figures used in investment decisions.

Use Direct URLs
When referencing SEC filings, use the direct URL to the specific document. General company pages require extra navigation.

Upload Before Referencing
Upload PDF documents before asking questions about them. ModelMonkey needs time to process and index the content.

Be Specific About Time Periods
Financial data is time-sensitive. Always specify which quarter, year, or period you're interested in.

Combine Web Research with Document Analysis
For comprehensive due diligence, use web search for recent developments and uploaded documents for detailed analysis.

Save Reference Prompts
Keep a list of your most useful prompts for common tasks like extracting income statements, finding guidance, or calculating ratios.

Cross-Reference Multiple Sources
For critical analysis, verify key figures across multiple sources: the 10-K, earnings presentation, and press release may all contain relevant data.

Ready to dive deeper? Explore these related features:

• Web Search & URL Access — Research and read SEC filings
• File Uploads — Upload PDFs for analysis
• External Data Connections — Connect to financial databases
• Spreadsheet Editing — Build models and run calculations

For advanced SQL queries against connected databases, see SQL Queries.