FMP
Jun 12, 2025 11:40 AM - Parth Sanghvi
Image credit: Financial Modeling Prep (FMP)
Investors routinely ask:
“How do I adjust P/E for cyclical swings?”
“What qualifies as a healthy Debt to Equity in manufacturing?”
“How can ROE reveal hidden capital allocation strengths?”
In this guide, we'll cover:
Formula deep dives with working examples
Advanced adjustments (forward vs. trailing P/E, tangible book value, net vs. gross debt)
Sector‑specific benchmarks and why they matter
Common pitfalls and how to avoid them
Live data integration using Financial Modeling Prep APIs
Actionable screening workflows
One authoritative external reference for further reading
When you standardize financial metrics across companies, you strip away scale bias and uncover genuine value or risk. Basic ratio checks can flag:
Overvalued names trading at unsustainable multiples
Leverage traps that magnify market downturns
Operational inefficiencies hidden in broad averages
But only rigorous ratio analysis—adjusted for industry cycles, accounting quirks, and one‑off events—will keep you ahead.
Long‑tail keyword: how to use adjusted financial ratios to compare cyclical industries
P/E Ratio (TTM) = Current Share Price ÷ EPS (Trailing Twelve Months)
Example: If ABC Ltd trades at ₹1,200 and reported EPS of ₹80 over the last 12 months, P/E = 1,200 ÷ 80 = 15×.
Trailing P/E: Uses actual past 12‑month earnings—best for stable, non‑cyclical firms.
Forward P/E: Uses consensus analyst forecasts—useful for high‑growth or turnaround stories.
Cyclically Adjusted P/E (CAPE): Average of the last 5-10 years' earnings to smooth commodity or economic cycles.
Pro Tip: For cyclical sectors like energy or materials, compute CAPE by averaging EPS over a full cycle. See Investopedia's Ratio Analysis for methodology.
➡️ Investopedia: Cyclically Adjusted Price‑Earnings (CAPE) Ratio
Tech: Investors pay for growth—forward P/E of 25×-30× is common.
Energy: Use CAPE to avoid misclassifying peaks/ troughs—average P/E often near 12×.
Financials: Regulatory and interest‑rate cycles mean trailing P/E ratios can swing dramatically—compare to 5‑year averages.
One‑off Items: Exclude unusual gains/losses (e.g., asset sales) to get normalized EPS.
Share Count Changes: Dilution from option exercises lowers per‑share EPS—adjust for weighted average shares outstanding.
API Automation: Automate rolling P/E pulls (trailing, forward, CAPE) via Financial Modeling Prep's Ratios TTM Statement Analysis API to keep your screens current.
🔗 Fetch Trailing & Forward P/E with Ratios TTM API
P/B Ratio = Market Price per Share ÷ (Total Shareholders' Equity ÷ Shares Outstanding)
Example: XYZ Corp trades at ₹500, with shareholders' equity of ₹2 billion and 4 million shares:
- Book value per share = 2,000 million ÷ 4 million = ₹500
- P/B = 500 ÷ 500 = 1.0×
Reported Book: Includes intangible assets (goodwill, patents).
Tangible Book: Excludes intangibles—better for asset‑heavy firms or liquidation scenarios.
Tangible Book Value = Total Equity - Intangible Assets
Tangible P/B = Price per Share ÷ (Tangible Book per Share)
Banks & Insurance: Tangible P/B < 1.2× often flags value names; watch for goodwill impairments.
Manufacturing: Asset write‑downs can distort reported book—lean on tangible book for accurate replacement costs.
Tech & Pharma: High intangible base means reported P/B can exceed 10×; focus instead on revenue multiples.
Off‑Balance Obligations: Leases or pension deficits aren't always fully captured—adjust book value downward if material.
API Tip: Pull granular equity line items (including goodwill) via the Full Financials as Reported API for precise P/B and tangible P/B calculations.
🔗 Access SEC‑filed Equity Details with Full Financials API
Debt to Equity = Total Liabilities ÷ Shareholders' Equity
Example: Total liabilities ₹60 billion, equity ₹40 billion → Debt to Equity = 60 ÷ 40 = 1.5×.
Gross Debt: All interest‑bearing liabilities (short + long term).
Net Debt: Gross debt minus cash & cash equivalents—better gauge of true leverage.
Net Debt to Equity = (Total Debt - Cash) ÷ Equity
Sector | Gross D/E | Net D/E | Notes |
Utilities | 1.2-1.5× | 1.0-1.3× | Stable cash flows justify higher debt |
Manufacturing | 0.5-1.0× | 0.3-0.8× | Cyclical revenue—avoid peaks |
Technology | 0.2-0.5× | 0.1-0.4× | Cash‑rich balance sheets |
Debt Maturity Profile: Short‑term roll‑over risk vs. long‑dated bonds.
Interest Coverage: Combine with EBIT/interest expense to ensure buffer.
Off‑Balance Leases: Capitalize operating leases for a truer leverage picture.
ROE = Net Income ÷ Average Shareholders' Equity
Example: Net income ₹8 billion, average equity ₹32 billion → ROE = 8 ÷ 32 = 25%.
Profit Margin = Net Income ÷ Revenue
Asset Turnover = Revenue ÷ Total Assets
Equity Multiplier = Total Assets ÷ Equity
ROE = Margin × Turnover × Multiplier
Component | Formula | Insight |
Profit Margin | NI ÷ Revenue | Operating efficiency |
Asset Turnover | Revenue ÷ Assets | Asset utilization |
Equity Multiplier | Assets ÷ Equity | Degree of financial leverage |
One‑Off Gains: Strip out non‑recurring profits (asset sales, legal settlements).
Provision Reversals: Watch for aggressive write‑backs that inflate net income.
API Workflow: Pull multi‑year net income and equity figures via the Ratios TTM API to track ROE trends and spot anomalies early.
🔗 Analyze ROE Trends with Ratios TTM API
Value‑Plus‑Quality: Targets undervalued firms with sustainable returns.
Low‑leverage Growth: Focuses on growth names with strong balance sheets.
Strategy | Filter Criteria |
Value + Quality | P/E < 12, P/B < 1.3, ROE > 15%, Net D/E < 0.6 |
Defensive Stability | P/E < 14, Debt/Equity < 0.8, Interest Coverage > 5×, ROE 8-12% |
Growth at Reasonable | Forward P/E < 20, ROE > 18%, Asset Turnover > 1.2× |
API Pulls: Schedule daily pulls of P/E, P/B, ROE, Debt to Equity via the Ratios TTM API.
Back‑Test: Compare historical filter performance to refine thresholds.
Dashboard: Use live data to trigger alerts when any metric breaches your criteria.
Data Collection:
Fetch P/E, P/B, ROE, Debt/Eq for S&P 400 Industrials using Ratios TTM API.
Retrieve cash and debt breakdown with Full Financials API.
Apply Filters:
P/E < 13, Tangible P/B < 1.2, Net D/E < 0.7, 3‑yr avg. ROE > 14%.
Results:
Identified six names; deep dive revealed two with strong free cash flow and manageable maturities in 2026-27.
This workflow shaved 80% off your initial research time, leaving you free to focus on management quality and growth catalysts.
For a deep exploration of forward vs. trailing P/E considerations, see CFA Institute's Financial Analysis Techniques:
➡️ CFA Institute: Financial Analysis Techniques
Get Your API Key: Sign up at Financial Modeling Prep's developer portal.
Build Your Model: Leverage Ratios TTM and Full Financials APIs.
Refine Monthly: Adjust your screening filters based on evolving sector norms and macro conditions.
Start automating your ratio analysis today and transform raw financial statements into actionable investment insights.
Nov 22, 2024 5:08 AM - Parth Sanghvi
Fundamental analysis is one of the most essential tools for investors and analysts alike, helping them assess the intrinsic value of a stock, company, or even an entire market. It focuses on the financial health and economic position of a company, often using key data such as earnings, expenses, ass...
Dec 17, 2024 8:58 AM - Sanzhi Kobzhan
Tesla, one of the world’s most talked-about electric vehicle manufacturers, attracts a lot of attention from investors and market watchers. By examining a snapshot of Tesla’s financial ratios—such as those provided by FinancialModelingPrep’s Ratios API—we can get a clearer picture of the company’s f...
Dec 22, 2024 7:59 AM - Sanzhi Kobzhan
When it comes to cutting-edge software and data analytics, Palantir Technologies (NYSE: PLTR) is often front and center. But for many investors, it’s important to consider alternative or complementary stocks in the same sector that may offer robust growth potential. As PLTR looks expensive (overvalu...