Income Statement Analyzer
Calculate an income statement waterfall, profit margins, and interest coverage from five manually entered figures.
How it works
Enter revenue, cost of goods sold, operating expenses, interest expense, and a tax rate from 0% to 100%. Keep all amounts in the same currency, scale, and reporting period. Example: revenue 1,000, cost of goods sold 600, operating expenses 250, interest 30, and tax rate 25% produce gross profit 400, operating income 150, pretax income 120, tax 30, and net income 90.
The results also show gross margin of 40%, operating margin of 15%, net margin of 9%, and interest coverage of 5 for that example. Margins divide each profit measure by revenue. Coverage divides operating income by interest expense. The displayed coverage bands are fixed descriptions of the ratio.
Change an input to compare another arithmetic scenario. A negative pretax result remains negative, and the same entered tax percentage is applied algebraically. This does not establish tax refund eligibility or predict future company results.
When browser storage is available, entered figures may be saved locally for a later visit. Review the source statement and its definitions before comparing companies or reporting periods.
Step by step
- Enter four income statement amounts and the tax rate.
- Use one currency, scale, and reporting period for all amounts.
- Review the waterfall, margins, and interest coverage band.
Worked example
Enter revenue of 1,000, cost of goods sold of 600, operating expenses of 250, interest expense of 30, and a tax rate of 25%. Use the same currency, scale, and reporting period for every amount.
The calculation gives gross profit 400, operating income 150, pretax income 120, modeled tax expense 30, and net income 90. Gross, operating, and net margins are 40%, 15%, and 9%. Interest coverage is 5, at the boundary of the band above 2 through 5.
When to use this analyzer
Use this analyzer to calculate a compact income statement summary from amounts you enter, or to compare arithmetic scenarios with consistent inputs.
Use reported statements and their accounting definitions for company analysis. Other tools can examine cash flow or valuation measures that this waterfall does not calculate.
Common entry mistakes
Mixing currencies, scales, or reporting periods makes the waterfall and ratios inconsistent. Check whether source figures are stated in units, thousands, or millions.
Operating expense definitions differ across companies. Check which items are included before comparing their margins or coverage ratios.
Formulas and assumptions
Gross profit = revenue − cost of goods sold
Operating income = gross profit − operating expenses
Pretax income = operating income − interest expense
Modeled tax = pretax income × tax rate ÷ 100
Net income = pretax income − modeled tax
Gross margin = gross profit ÷ revenue × 100
Operating margin = operating income ÷ revenue × 100
Net margin = net income ÷ revenue × 100
Interest coverage = operating income ÷ interest expense
Revenue and expense amounts must be finite and nonnegative. The tax rate must be from 0% to 100%. Margins are undefined at zero revenue, and coverage is undefined at zero interest expense. Use a consistent currency, scale, and reporting period.
Assumptions and limitations
This analyzer is a manual five input summary, not a complete income statement or accounting standards review. It omits other income, unusual items, and differences in line item definitions. The tax calculation applies the entered rate to positive or negative pretax income; it does not establish actual tax treatment, refunds, deferred taxes, or loss carryforwards. Fixed interest coverage bands are descriptive ratio ranges, not credit or company quality judgments. Results are calculations from the entered figures, not forecasts.
Key terms
- Gross profit
- Revenue remaining after subtracting cost of goods sold.
- Pretax income
- Pretax income is the result after subtracting interest expense from operating income.
- Interest coverage and bands
- Operating income divided by interest expense. The fixed bands describe this ratio and do not rate a company’s credit or quality.
Compare related calculations
Gross margin and net margin tools focus on individual ratios. This analyzer shows how entered revenue moves through costs, operating expenses, interest, and modeled tax.
Free cash flow and valuation tools use different statement measures. Check each tool’s inputs before comparing results.
FAQ
What figures does the analyzer use?
Enter revenue, cost of goods sold, operating expenses, interest expense, and a tax rate from 0% to 100%. Use amounts from the same reporting period and in the same currency and scale. The analyzer calculates a simplified income statement waterfall, three margins, and interest coverage.
How are profit and margin results calculated?
Gross profit is revenue less cost of goods sold. Operating income subtracts operating expenses, and pretax income subtracts interest expense. The tax calculation applies the entered rate to pretax income. Each margin divides its profit measure by revenue and is undefined when revenue is zero.
What do the interest coverage bands mean?
Coverage is operating income divided by interest expense. The fixed bands are above 5, above 2 through 5, above 1 through 2, and at or below 1. They describe this ratio only. They are not credit ratings, safety measures, or judgments about a company.
Why might a margin or coverage result be unavailable?
When revenue is zero, the three margins are undefined because their denominator is zero. When interest expense is zero, interest coverage is undefined. The waterfall amounts can still be calculated from the other entered figures.
Can I compare different assumptions?
Yes. Change one entered amount at a time to see the arithmetic effect on the results. This is a scenario calculation using your inputs, not a forecast of future revenue, costs, or company performance.
Related tools
Compare gross margin and net profit margin for focused ratio calculations. Free cash flow yield uses cash flow measures, while discounted cash flow tools model future cash flows with additional assumptions.