The data needed for each calculation
A company reports revenue of $1,000,000, COGS of $600,000, operating expenses before D&A of $220,000, D&A of $80,000, interest of $40,000, tax of $20,000, net income of $40,000, 20,000 shares, a $30 share price, a $0.60 dividend per share, and beginning and ending assets of $700,000 and $900,000. Its budget was revenue of $950,000, COGS of $570,000, operating expenses before D&A of $210,000, and D&A of $80,000. A quick answer calls EBITDA $120,000 and the operating budget variance $50,000 favorable. Both are wrong because EBITDA also adds back interest and tax, and the budget result must include expense variances as well as the revenue variance.
The raw facts support every metric, but each metric uses a different denominator or adjustment. The schedule puts those facts in one fixed order before the calculations begin.
Adjustments, denominators and variance signs
Use net income after all listed charges as the starting point for EBITDA. Use weighted-average common shares for EPS, and use average total assets when the asset balance changes during the period. Selecting ratios and measuring profitability supplies related profit ratios. Liquidity and solvency ratios uses the same care with the period and balance-sheet denominators. This chapter adds valuation, shareholder-distribution, efficiency, and budget comparisons. No GAAP rule gives a universal good-or-bad cutoff for these ratios or variances. If EBITDA is publicly presented as a non-GAAP measure, SEC Regulation G requires the most directly comparable GAAP measure and a reconciliation.
Each line follows from the kind of number it measures. Earnings are adjusted for excluded charges, per-share measures use shares, turnover uses average assets, and variances must be signed according to their effect on operating income.
| Line | How it is found | Why |
|---|---|---|
| Net income | Revenue − COGS − operating expenses before D&A − D&A − interest − tax | Starts with earnings after all listed charges |
| EBITDA | Net income + tax + interest + depreciation and amortization | Removes the four excluded charges |
| EPS | Net income ÷ weighted-average common shares | Converts earnings to one share |
| Price-to-earnings | Market price per share ÷ EPS | Compares the share price with one period of earnings |
| Dividend payout | Dividends per share ÷ EPS | Shows the share of earnings distributed |
| Average total assets | (Beginning assets + ending assets) ÷ 2 | Matches the period's sales with the assets used during the period |
| Asset turnover | Net sales ÷ average total assets | Measures sales generated per asset dollar |
| Revenue variance | Actual revenue − budget revenue | More revenue is favorable |
| Expense variance | Budget expense − actual expense | Less expense is favorable |
| Operating income variance | Actual operating income − budget operating income | Checks the combined effect of all operating lines |
🔑 RULE: EBITDA adds back interest, income tax, depreciation, and amortization to net income. Price-to-earnings equals market price per share divided by EPS; dividend payout equals dividends per share divided by EPS; asset turnover equals net sales divided by average total assets. For variances, more revenue and less expense are favorable; no universal GAAP threshold exists for these ratios or variances.
The schedule separates earnings adjustments, per-share calculations, asset efficiency, and budget effects.
Building earnings, ratios and variances
Trace each amount to the situation. First build net income from the income statement, then add back the excluded items for EBITDA. Use the same net income for EPS, price-to-earnings, and dividend payout. Average the two asset balances before calculating turnover. For the budget, show revenue as actual less budget and expenses as budget less actual. Then compare operating income as a final check.
The income statement creates the earnings base, and the addbacks produce EBITDA without adding back the same item twice. The shareholder and asset ratios then use that base or the stated balance amounts. The budget lines explain why actual operating income differs from budget.
| Line | How it is found | Why | Amount |
|---|---|---|---|
| Revenue | Given actual sales | Starting operating amount | $1,000,000 |
| Less: COGS | Given actual COGS | Cost of goods sold | ($600,000) |
| Less: operating expenses before D&A | Given actual operating expense | Other operating cost before D&A | ($220,000) |
| Less: D&A | Given actual D&A | Depreciation and amortization charge | ($80,000) |
| Less: interest | Given actual interest | Financing cost | ($40,000) |
| Less: tax | Given actual tax | Income tax charge | ($20,000) |
| Net income | $1,000,000 − $600,000 − $220,000 − $80,000 − $40,000 − $20,000 | Earnings available to common shareholders | $40,000 |
| EBITDA | $40,000 + $20,000 + $40,000 + $80,000 | Adds back tax, interest, and D&A | $180,000 |
| EBIT | EBITDA − D&A | Earnings before interest and tax | $100,000 |
| Pretax income | EBIT − interest | Earnings before tax | $60,000 |
| EPS | $40,000 ÷ 20,000 shares | Earnings per share | $2.00 |
| Price-to-earnings | $30 ÷ $2.00 | Share price divided by EPS | 15.0x |
| Dividend per share | $12,000 ÷ 20,000 shares | Converts total dividends to a per-share amount | $0.60 |
| Dividend payout | $0.60 ÷ $2.00 | Portion of earnings paid as dividends | 30% |
| Average total assets | ($700,000 + $900,000) ÷ 2 | Average asset base | $800,000 |
| Asset turnover | $1,000,000 ÷ $800,000 | Sales per average asset dollar | 1.25x |
| Revenue variance | $1,000,000 − $950,000 | More actual revenue is favorable | $50,000 F |
| COGS variance | $570,000 − $600,000 | More actual COGS is unfavorable | $30,000 U |
| Operating expense variance | $210,000 − $220,000 | More actual expense is unfavorable | $10,000 U |
| D&A variance | $80,000 − $80,000 | No change from budget | $0 |
| Budget operating income | $950,000 − $570,000 − $210,000 − $80,000 | Budget operating result | $90,000 |
| Actual operating income | $1,000,000 − $600,000 − $220,000 − $80,000 | Actual operating result | $100,000 |
| Total operating income variance | $50,000 F − $30,000 U − $10,000 U + $0 | Ties the line variances to the total | $10,000 F |
💎 CHECK: Actual operating income of $100,000 minus budget operating income of $90,000 equals $10,000 favorable. This matches the sum of the detailed variances.
The check confirms that the detailed operating variances tie to the difference between actual and budget operating income.
Lower operating expenses change results
Keep every worked-example fact except actual operating expenses before D&A, which are now $200,000. Because this is an actual expense line, it changes EBITDA, EBIT, pretax income, net income, EPS, price-to-earnings, dividend payout, and the operating expense and total budget variances. The share price, dividends, asset balances, and D&A do not move.
A lower actual operating expense raises each downstream earnings amount and makes the expense variance favorable instead of unfavorable. It does not change asset turnover because neither sales nor the asset balances changed.
| Line | How it is found | Amount |
|---|---|---|
| Revenue | Given actual sales | $1,000,000 |
| COGS | Given actual COGS | ($600,000) |
| Operating expenses before D&A | Changed actual fact | ($200,000) |
| EBITDA | Net income + tax + interest + D&A | ? |
| D&A | Given actual D&A | ($80,000) |
| EBIT | EBITDA − D&A | ? |
| Interest | Given actual interest | ($40,000) |
| Pretax income | EBIT − interest | ? |
| Tax | Given actual tax | ($20,000) |
| Net income | Pretax income − tax | ? |
| Weighted-average shares | Given shares | 20,000 |
| EPS | Net income ÷ shares | ? |
| Market price per share | Given price | $30 |
| Price-to-earnings | Price ÷ EPS | ? |
| Total dividends | Given dividends | $12,000 |
| Dividend per share | Dividends ÷ shares | $0.60 |
| Dividend payout | Dividend per share ÷ EPS | ? |
| Beginning and ending assets | Given balances | $700,000 and $900,000 |
| Average total assets | (Beginning + ending) ÷ 2 | ? |
| Asset turnover | Sales ÷ average assets | ? |
| Revenue variance | Actual revenue − budget revenue | ? |
| COGS variance | Budget COGS − actual COGS | ? |
| Operating expense variance | Budget operating expense − actual operating expense | ? |
| D&A variance | Budget D&A − actual D&A | ? |
| Total operating income variance | Actual operating income − budget operating income | ? |
The answers fill the changed earnings lines and the affected variance lines.
Practice
EBITDA, EBIT, pretax income, and net income, in that order, are ____.
EPS and price-to-earnings, in that order, are ____.
Dividend payout and asset turnover, in that order, are ____.
The revenue, COGS, operating-expense, D&A, and total operating-income variances, with F/U labels where needed, are ____.
EBITDA, valuation and budget calculations
Each question turns on a specific schedule line: EBITDA addbacks, price-to-earnings from EPS, the total budget variance, or average assets for turnover. Every wrong choice represents a particular calculation error.
The questions change the raw facts but not the schedule order. Keep the numerator, denominator, and favorable sign convention separate.
Practice
A company has net income of $90,000, interest expense of $30,000, income tax expense of $20,000, and depreciation and amortization of $60,000. What is EBITDA?
A company reports net income of $240,000, 60,000 weighted-average shares, and a market price of $48 per share. What is the price-to-earnings ratio?
Budgeted revenue is $800,000 and actual revenue is $860,000. Budgeted operating expenses are $500,000 and actual operating expenses are $530,000. What is the net operating income variance?
A company has sales of $900,000, beginning total assets of $500,000, and ending total assets of $700,000. What is asset turnover?
A higher share price changes P/E
Was: The company had revenue of $1,000,000, COGS of $600,000, operating expenses before D&A of $220,000, D&A of $80,000, interest of $40,000, tax of $20,000, net income of $40,000, 20,000 shares, a $30 market price, $12,000 of dividends, beginning assets of $700,000, ending assets of $900,000, and the stated budget.
Now: The market price per share is $36 instead of $30. Which schedule lines move, and which way?
Answer: Only the price-to-earnings line moves. EPS remains $2.00, so P/E rises from 15.0x to 18.0x. EBITDA remains $180,000, net income remains $40,000, payout remains 30%, turnover remains 1.25x, and the total budget variance remains $10,000 favorable.
Applying the schedule to financial data
A FAR task-based simulation can present an income statement, share and market-price data, beginning and ending asset balances, and a budget-versus-actual operating schedule. The working cells can ask for EBITDA, EPS, price-to-earnings, dividend payout, average assets, asset turnover, each line variance, and the total operating income variance. The calculated cells remain blank while the source figures stay visible.
The same schedule prevents a change in one source fact from being overlooked in a downstream metric. The summary keeps that order available when several exhibits must be read together.
The metric and variance calculation sequence
- Build net income from revenue, COGS, operating expenses, D&A, interest, and tax.
- Add tax, interest, and D&A back to net income for EBITDA.
- Divide net income by weighted-average shares for EPS, then divide market price by EPS for P/E.
- Divide dividends per share by EPS for dividend payout.
- Average beginning and ending total assets, then divide sales by that average for asset turnover.
- Calculate revenue as actual minus budget and expenses as budget minus actual.
- Add the signed line variances and compare actual operating income with budget operating income.
- Check that both totals agree.
The order links the profitability work from Selecting ratios and measuring profitability, the denominator discipline from Liquidity and solvency ratios, and the performance calculations in Performance metrics and budget variances. A matching total is the final evidence that no expense sign or downstream line was missed.
Unlock the full lesson and continue reading
Signup to continue reading this lesson and unlimited access questions, flashcards, AI notes, and more

