Financial Ratios Dashboard — Google Sheets (20+ Pre-Loaded Ratios)

Stop manually calculating financial ratios from messy spreadsheets. This Google Sheets dashboard instantly computes 20+ essential ratios using just ticker and revenue data — no financial degree required. What's included: • 6 industry sectors pre-loaded (Tech, Healthcare, Energy, Consumer, Financials, Industrials) with 5 companies each — 30 real-world examples ready to analyze • 20+ automated ratio calculators: P/E, P/B, Debt/Equity, Current Ratio, ROE, ROA, Net Profit Margin, Operating Margin, FCF Margin, Asset Turnover, Inventory Turnover, Days Sales Outstanding, EPS Growth, Revenue Growth, Gross Margin, EBITDA Margin, Dividend Yield, Payout Ratio, Interest Coverage, Working Capital Ratio • Color-coded output: green (strong), yellow (moderate), red (weak) based on industry-specific benchmarks • Input sheet: enter only Ticker, Revenue, Net Income, Total Assets, Total Liabilities, Total Equity, Operating Income, EBITDA, FCF, Inventory, Accounts Receivable, Market Cap, Dividend per Share, Shares Outstanding — 14 inputs generate 20+ ratios • Comparison mode: compare up to 5 companies on any ratio with instant bar charts • Step-by-step user guide embedded as a hidden sheet — explains what each ratio measures and how to interpret values • No VBA, no macros — just clean array formulas that update automatically Perfect for: retail investors screening stock ideas, small family offices reviewing portfolio holdings, and independent traders doing fundamental analysis. Works entirely in Google Sheets — no software installation needed. Format: Editable Google Sheets file link sent after purchase (works in Excel with minimal adjustments for array formulas).

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing