Horizontal, Vertical and Ratio Analysis
5 minutes
5 Questions
In the Certified Fraud Examiner (CFE) framework, financial statement analysis is a core tool for detecting fraud. Three primary techniques are Horizontal Analysis, Vertical Analysis, and Ratio Analysis. Horizontal Analysis (also called trend analysis) compares financial statement line items across multiple periods. Each item is expressed as a percentage change from a base year, e.g., revenue grew 8% from Year 1 to Year 2. Fraud examiners look for unusual fluctuations, such as revenue rising sharply while cost of goods sold stays flat, or receivables growing faster than sales. These anomalies may signal fictitious revenues, improper capitalization, or timing manipulation. Vertical Analysis (common-size analysis) expresses each line item as a percentage of a key base figure within a single period. On the income statement, items are shown as a percentage of net sales; on the balance sheet, as a percentage of total assets or total liabilities and equity. This allows comparison across companies of different sizes and highlights structural shifts. For example, if cost of sales drops from 65% to 50% of revenue without a clear business reason, examiners may suspect understated expenses or inflated sales. Ratio Analysis measures relationships between two financial statement items to assess liquidity, leverage, profitability, and efficiency. Key ratios include the current ratio, quick ratio, debt-to-equity, gross profit margin, receivable turnover, inventory turnover, and days sales outstanding. Fraud indicators arise when ratios deviate from industry norms or historical patterns, for instance, a rising receivable collection period alongside booming sales may suggest fictitious customers or channel stuffing. The Beneish M-Score and Altman Z-Score are composite ratio models often used to flag manipulation risk. Together, these techniques help CFEs identify red flags, prioritize audit areas, and build evidence. They do not prove fraud by themselves but direct investigators toward transactions, journal entries, and documents requiring deeper examination, supporting a disciplined, evidence-based approach to detecting financial statement fraud.
Horizontal, Vertical and Ratio Analysis: A Complete CFE Exam Guide (Financial Statement Fraud)
1. Why This Topic Matters for the CFE Exam
Horizontal, vertical and ratio analysis are the core analytical techniques the ACFE Fraud Examiners Manual presents for detecting financial statement fraud. They appear in the Financial Transactions and Fraud Schemes section of the CFE Exam, and they are heavily tested because they bridge accounting knowledge and investigative reasoning. Examiners expect you to (1) know the definitions, (2) perform simple calculations, (3) interpret what a change or ratio implies, and (4) connect unusual results to specific fraud schemes such as fictitious revenue, concealed liabilities, improper asset valuation, timing differences and improper disclosures.
In practice, these tools are important because financial statement fraud is usually hidden inside numbers that look plausible in isolation. Fraudsters can manipulate a single account, but it is very difficult to keep every related account, percentage and ratio consistent at the same time. Analysis exposes the relationships that stop making sense. The ACFE emphasizes that the analysis itself does not prove fraud; it identifies red flags and anomalies that direct the fraud examiner toward areas requiring further inquiry, document examination and interviews.
2. What Financial Statement Analysis Is
Financial statement analysis is the process of comparing amounts within and across financial statements to identify trends, relationships and inconsistencies. The three principal methods tested on the CFE Exam are:
Horizontal analysis (also called trend analysis): compares line items across two or more periods and expresses the change in dollars and as a percentage of a base year.
Vertical analysis (also called common-size analysis): expresses each line item as a percentage of a key base figure within the same statement for a single period.
Ratio analysis: measures the relationship between two different financial statement amounts to evaluate liquidity, efficiency, leverage and profitability, and then compares those ratios over time or against industry norms.
Each technique asks a different question. Horizontal analysis asks: How did this item change over time? Vertical analysis asks: What proportion of the whole does this item represent? Ratio analysis asks: Is the relationship between these two items reasonable?
3. Horizontal Analysis: How It Works
Horizontal analysis places the financial statements of two or more periods side by side. A base period is chosen (usually the earlier year), and for each line item you compute:
Dollar change = Current period amount minus Base period amount
Percentage change = (Current period amount minus Base period amount) divided by Base period amount, multiplied by 100
Example: Sales were 2,000,000 last year and 2,500,000 this year. The dollar change is 500,000 and the percentage change is 500,000 divided by 2,000,000 = 25 percent.
The analytical power comes from comparing the percentage changes of related accounts. If sales increase 25 percent, you would normally expect cost of goods sold, accounts receivable and perhaps commission expense to move in a roughly similar direction. Red flags identified through horizontal analysis include:
- Revenue growing sharply while cost of sales stays flat or declines (possible fictitious revenue or capitalized costs).
- Accounts receivable growing much faster than sales (possible fictitious sales recorded as receivables, or channel stuffing).
- Inventory growing faster than cost of sales (possible inventory overstatement).
- Large unexplained decreases in expenses or liabilities (possible concealed liabilities or improper deferrals).
- Sudden changes in reserves, allowances or accrued liabilities around period end.
A key exam point: percentages matter more than raw dollars. A small dollar change in a small account can be a huge percentage change, and the ACFE notes that the fraud examiner should focus on changes that are significant in percentage terms or inconsistent with related accounts, not simply the largest dollar amounts.
4. Vertical Analysis: How It Works
Vertical analysis converts a statement into percentages so that the size of the company no longer matters. Every line item is divided by a base figure that is set at 100 percent:
- On the income statement, the base is net sales (revenue). Cost of goods sold, gross profit, each operating expense and net income are each shown as a percentage of net sales.
- On the balance sheet, the base is total assets for the asset side and total liabilities plus equity for the other side (these are equal, so total assets is commonly cited as the base).
Example: If net sales are 1,000,000 and cost of goods sold is 650,000, then COGS is 65 percent of sales and gross margin is 35 percent. If the following year COGS is 60 percent of sales with no change in pricing or product mix, the examiner should ask why.
Vertical analysis is especially useful for:
- Comparing companies of different sizes, or comparing a company with industry averages.
- Spotting shifts in the structure of the statements, such as receivables rising from 10 percent to 18 percent of total assets.
- Detecting expense categories that shrink as a percentage of sales while sales rise, which may indicate improper capitalization of expenses.
The ACFE emphasizes that vertical analysis is most effective when the percentages are then compared across several periods, which is essentially combining vertical and horizontal thinking.
5. Ratio Analysis: How It Works
Ratio analysis measures relationships between two statement items. The Fraud Examiners Manual presents a core set of ratios that you should memorize, including their formulas and what fraud schemes can distort them.
Liquidity ratios
Current ratio = Current assets divided by Current liabilities. Measures ability to pay short-term obligations. Fraud effect: concealing liabilities or inflating current assets (fictitious receivables, overstated inventory) will increase the ratio. Embezzlement of cash will decrease it.
Quick ratio (acid-test ratio) = (Cash + Marketable securities + Receivables) divided by Current liabilities. Excludes inventory and prepaid items, so it is a stricter liquidity test. Because inventory is excluded, a company with a healthy current ratio but a weak quick ratio may be carrying bloated or overstated inventory.
Activity (efficiency) ratios
Receivable turnover = Net sales on account divided by Average net receivables. Shows how many times receivables are collected during the period. Fictitious sales recorded to receivables that are never collected cause receivables to balloon and turnover to fall.
Collection ratio (days sales outstanding) = 365 divided by Receivable turnover. Shows the average number of days to collect. A rising collection ratio is a classic red flag of fictitious or premature revenue recognition, or of uncollectible accounts not being written off.
Inventory turnover = Cost of goods sold divided by Average inventory. Shows how quickly inventory is sold. Overstated ending inventory (which simultaneously understates COGS) causes this ratio to decrease.
Average number of days inventory in stock = 365 divided by Inventory turnover. A rising figure may indicate obsolete inventory not written down, or inflated inventory counts.
Asset turnover = Net sales divided by Average total assets. Measures how efficiently assets generate revenue. Capitalizing expenses as assets inflates total assets and depresses this ratio unless sales are also inflated.
Leverage ratio
Debt to equity ratio = Total liabilities divided by Total equity. Measures reliance on borrowed funds. Companies with loan covenants tied to this ratio have a motive to conceal liabilities, which lowers the ratio and makes the company appear safer.
Profitability ratio
Profit margin = Net income divided by Net sales. Fictitious revenue, understated expenses and overstated inventory (lower COGS) all increase the profit margin. An unusually stable or steadily rising margin in a volatile industry can itself be a red flag of earnings management.
Interpreting ratios
No ratio is good or bad in a vacuum. The examiner compares each ratio to (1) the same company in prior periods, (2) industry benchmarks, and (3) the examiner's expectations given known business events. The critical skill is reasoning through direction: if a fraudster inflates the numerator, the ratio rises; if the denominator is inflated, the ratio falls. Many CFE questions are really tests of this numerator-denominator logic.
6. Linking the Techniques to Financial Statement Fraud Schemes
The ACFE classifies financial statement fraud into five main categories. Here is how analysis helps detect each:
Fictitious revenues: Horizontal analysis shows revenue outpacing COGS; receivables rise disproportionately; receivable turnover drops; collection ratio rises; profit margin rises.
Timing differences (improper revenue recognition): Unusual revenue spikes in the last period of the year, followed by heavy returns or credits early the next year; receivables elevated at year end.
Concealed liabilities and expenses: Current ratio and quick ratio improve; debt to equity falls; expenses as a percentage of sales fall in vertical analysis; asset turnover may fall if costs are capitalized.
Improper asset valuation: Inventory turnover falls; days inventory in stock rises; receivables grow without corresponding sales growth; fixed assets grow as a percentage of total assets without visible expansion.
Improper disclosures: Analysis of the numbers alone may not reveal these, which is why the ACFE stresses reading notes, related-party information and management discussion alongside the quantitative work.
7. Limitations You Must Know
Examiners frequently test the limits of these techniques:
- Analysis identifies anomalies, not proof of fraud. Legitimate causes (new product lines, acquisitions, accounting policy changes, economic conditions) must be ruled out.
- Ratios depend on accurate underlying data; if both numerator and denominator are falsified proportionally, the ratio may look normal.
- Industry comparisons can mislead if the peer group or accounting methods differ.
- Small companies and single-period data provide a weak basis for trend analysis.
- Percentage changes on a small base can be exaggerated and should be judged for materiality and relevance.
8. How to Answer Exam Questions on This Topic
Step 1: Identify which technique the question is testing. Keywords help: percentage change from the prior year or trend signals horizontal analysis; percentage of total assets or percentage of net sales or common-size signals vertical analysis; a named relationship such as current ratio or inventory turnover signals ratio analysis.
Step 2: Recall the exact formula and the correct base. The most common error is dividing by the wrong figure. Horizontal percentage change always divides by the base (prior) year, not the current year. Vertical analysis of the income statement always uses net sales; of the balance sheet, total assets.
Step 3: Perform the computation carefully. Write out the numerator and denominator before dividing. Watch for averages: receivable turnover and inventory turnover use average balances when beginning and ending amounts are both given.
Step 4: Reason about direction when asked for interpretation. Ask: which account did the fraud scheme inflate or deflate, and is that account in the numerator or denominator? Then determine whether the ratio rises or falls.
Step 5: Choose the answer that fits the ACFE's conservative framing. The correct option typically describes the result as a red flag requiring further investigation, not as conclusive evidence of fraud.
9. Exam Tips: Answering Questions on Horizontal, Vertical and Ratio Analysis
Tip 1: Memorize the formula list cold. Current ratio, quick ratio, receivable turnover, collection ratio, inventory turnover, average days inventory in stock, debt to equity, profit margin and asset turnover. Expect at least one direct calculation.
Tip 2: Know what the quick ratio excludes. Inventory and prepaid expenses are excluded. If an answer option includes inventory in the quick ratio numerator, it is wrong.
Tip 3: For horizontal analysis, the prior year is always the denominator. A change from 100 to 150 is a 50 percent increase, not 33 percent.
Tip 4: For vertical analysis, remember the two bases. Income statement equals net sales at 100 percent; balance sheet equals total assets at 100 percent. Questions often test whether you know that gross profit percentage is a vertical analysis figure.
Tip 5: Practice the direction logic with fictitious revenue. Fictitious sales recorded to receivables increase sales (numerator of receivable turnover) but increase receivables even more over time because they are never collected, so turnover falls and collection days rise. This is one of the most tested scenarios.
Tip 6: Concealed liabilities improve liquidity and leverage ratios. If a question describes a company that failed to record payables, expect the current ratio to be overstated and debt to equity understated.
Tip 7: Overstated inventory does two things at once. It increases current assets and decreases cost of goods sold, so the current ratio rises, inventory turnover falls, gross margin rises and profit margin rises. Questions may ask for any one of these effects.
Tip 8: When a question says a ratio alone proves fraud, that answer is wrong. The ACFE consistently teaches that analysis identifies anomalies that warrant follow-up through documents, interviews and other procedures.
Tip 9: Compare related accounts, not isolated figures. If an answer option identifies a red flag based on a relationship (sales up 30 percent while COGS up 2 percent), it is usually the best answer compared with an option that cites a single number without context.
Tip 10: Watch for distractor terminology. Horizontal analysis may be called trend analysis; vertical analysis may be called common-size analysis; the collection ratio may be called days sales outstanding or average collection period; the quick ratio may be called the acid-test ratio. Recognize all synonyms.
Tip 11: Read numbers in the question stem twice. Exam writers sometimes present beginning and ending balances and expect you to average them, or present total sales when the formula calls for credit sales. Use the data given exactly as the ACFE formula requires.
Tip 12: Eliminate answers that confuse cause and effect. A ratio changing does not cause fraud; a fraud scheme causes the ratio to change. Answer options that reverse this logic are distractors.
10. Quick Reference Summary
Horizontal analysis: Compare across periods; percentage change = (current minus base) divided by base; look for related accounts moving inconsistently.
Vertical analysis: Compare within one period; income statement base is net sales, balance sheet base is total assets; look for shifts in proportion over time or versus industry.
Ratio analysis: Liquidity (current, quick), activity (receivable turnover, collection ratio, inventory turnover, days inventory, asset turnover), leverage (debt to equity), profitability (profit margin); reason through numerator and denominator effects of each fraud scheme.
Core principle: These tools reveal where the numbers stop fitting together. The fraud examiner uses them to target further investigation, never as stand-alone proof. Master the formulas, the bases, the direction logic and the limitations, and you will handle any CFE question on this topic with confidence.
Horizontal, vertical and ratio analysis are the core analytical techniques the ACFE Fraud Examiners Manual presents for detecting financial statement fraud. They appear in the Financial Transactions and Fraud Schemes section of the CFE Exam, and they are heavily tested because they bridge accounting knowledge and investigative reasoning. Examiners expect you to (1) know the definitions, (2) perform simple calculations, (3) interpret what a change or ratio implies, and (4) connect unusual results to specific fraud schemes such as fictitious revenue, concealed liabilities, improper asset valuation, timing differences and improper disclosures.
In practice, these tools are important because financial statement fraud is usually hidden inside numbers that look plausible in isolation. Fraudsters can manipulate a single account, but it is very difficult to keep every related account, percentage and ratio consistent at the same time. Analysis exposes the relationships that stop making sense. The ACFE emphasizes that the analysis itself does not prove fraud; it identifies red flags and anomalies that direct the fraud examiner toward areas requiring further inquiry, document examination and interviews.
2. What Financial Statement Analysis Is
Financial statement analysis is the process of comparing amounts within and across financial statements to identify trends, relationships and inconsistencies. The three principal methods tested on the CFE Exam are:
Horizontal analysis (also called trend analysis): compares line items across two or more periods and expresses the change in dollars and as a percentage of a base year.
Vertical analysis (also called common-size analysis): expresses each line item as a percentage of a key base figure within the same statement for a single period.
Ratio analysis: measures the relationship between two different financial statement amounts to evaluate liquidity, efficiency, leverage and profitability, and then compares those ratios over time or against industry norms.
Each technique asks a different question. Horizontal analysis asks: How did this item change over time? Vertical analysis asks: What proportion of the whole does this item represent? Ratio analysis asks: Is the relationship between these two items reasonable?
3. Horizontal Analysis: How It Works
Horizontal analysis places the financial statements of two or more periods side by side. A base period is chosen (usually the earlier year), and for each line item you compute:
Dollar change = Current period amount minus Base period amount
Percentage change = (Current period amount minus Base period amount) divided by Base period amount, multiplied by 100
Example: Sales were 2,000,000 last year and 2,500,000 this year. The dollar change is 500,000 and the percentage change is 500,000 divided by 2,000,000 = 25 percent.
The analytical power comes from comparing the percentage changes of related accounts. If sales increase 25 percent, you would normally expect cost of goods sold, accounts receivable and perhaps commission expense to move in a roughly similar direction. Red flags identified through horizontal analysis include:
- Revenue growing sharply while cost of sales stays flat or declines (possible fictitious revenue or capitalized costs).
- Accounts receivable growing much faster than sales (possible fictitious sales recorded as receivables, or channel stuffing).
- Inventory growing faster than cost of sales (possible inventory overstatement).
- Large unexplained decreases in expenses or liabilities (possible concealed liabilities or improper deferrals).
- Sudden changes in reserves, allowances or accrued liabilities around period end.
A key exam point: percentages matter more than raw dollars. A small dollar change in a small account can be a huge percentage change, and the ACFE notes that the fraud examiner should focus on changes that are significant in percentage terms or inconsistent with related accounts, not simply the largest dollar amounts.
4. Vertical Analysis: How It Works
Vertical analysis converts a statement into percentages so that the size of the company no longer matters. Every line item is divided by a base figure that is set at 100 percent:
- On the income statement, the base is net sales (revenue). Cost of goods sold, gross profit, each operating expense and net income are each shown as a percentage of net sales.
- On the balance sheet, the base is total assets for the asset side and total liabilities plus equity for the other side (these are equal, so total assets is commonly cited as the base).
Example: If net sales are 1,000,000 and cost of goods sold is 650,000, then COGS is 65 percent of sales and gross margin is 35 percent. If the following year COGS is 60 percent of sales with no change in pricing or product mix, the examiner should ask why.
Vertical analysis is especially useful for:
- Comparing companies of different sizes, or comparing a company with industry averages.
- Spotting shifts in the structure of the statements, such as receivables rising from 10 percent to 18 percent of total assets.
- Detecting expense categories that shrink as a percentage of sales while sales rise, which may indicate improper capitalization of expenses.
The ACFE emphasizes that vertical analysis is most effective when the percentages are then compared across several periods, which is essentially combining vertical and horizontal thinking.
5. Ratio Analysis: How It Works
Ratio analysis measures relationships between two statement items. The Fraud Examiners Manual presents a core set of ratios that you should memorize, including their formulas and what fraud schemes can distort them.
Liquidity ratios
Current ratio = Current assets divided by Current liabilities. Measures ability to pay short-term obligations. Fraud effect: concealing liabilities or inflating current assets (fictitious receivables, overstated inventory) will increase the ratio. Embezzlement of cash will decrease it.
Quick ratio (acid-test ratio) = (Cash + Marketable securities + Receivables) divided by Current liabilities. Excludes inventory and prepaid items, so it is a stricter liquidity test. Because inventory is excluded, a company with a healthy current ratio but a weak quick ratio may be carrying bloated or overstated inventory.
Activity (efficiency) ratios
Receivable turnover = Net sales on account divided by Average net receivables. Shows how many times receivables are collected during the period. Fictitious sales recorded to receivables that are never collected cause receivables to balloon and turnover to fall.
Collection ratio (days sales outstanding) = 365 divided by Receivable turnover. Shows the average number of days to collect. A rising collection ratio is a classic red flag of fictitious or premature revenue recognition, or of uncollectible accounts not being written off.
Inventory turnover = Cost of goods sold divided by Average inventory. Shows how quickly inventory is sold. Overstated ending inventory (which simultaneously understates COGS) causes this ratio to decrease.
Average number of days inventory in stock = 365 divided by Inventory turnover. A rising figure may indicate obsolete inventory not written down, or inflated inventory counts.
Asset turnover = Net sales divided by Average total assets. Measures how efficiently assets generate revenue. Capitalizing expenses as assets inflates total assets and depresses this ratio unless sales are also inflated.
Leverage ratio
Debt to equity ratio = Total liabilities divided by Total equity. Measures reliance on borrowed funds. Companies with loan covenants tied to this ratio have a motive to conceal liabilities, which lowers the ratio and makes the company appear safer.
Profitability ratio
Profit margin = Net income divided by Net sales. Fictitious revenue, understated expenses and overstated inventory (lower COGS) all increase the profit margin. An unusually stable or steadily rising margin in a volatile industry can itself be a red flag of earnings management.
Interpreting ratios
No ratio is good or bad in a vacuum. The examiner compares each ratio to (1) the same company in prior periods, (2) industry benchmarks, and (3) the examiner's expectations given known business events. The critical skill is reasoning through direction: if a fraudster inflates the numerator, the ratio rises; if the denominator is inflated, the ratio falls. Many CFE questions are really tests of this numerator-denominator logic.
6. Linking the Techniques to Financial Statement Fraud Schemes
The ACFE classifies financial statement fraud into five main categories. Here is how analysis helps detect each:
Fictitious revenues: Horizontal analysis shows revenue outpacing COGS; receivables rise disproportionately; receivable turnover drops; collection ratio rises; profit margin rises.
Timing differences (improper revenue recognition): Unusual revenue spikes in the last period of the year, followed by heavy returns or credits early the next year; receivables elevated at year end.
Concealed liabilities and expenses: Current ratio and quick ratio improve; debt to equity falls; expenses as a percentage of sales fall in vertical analysis; asset turnover may fall if costs are capitalized.
Improper asset valuation: Inventory turnover falls; days inventory in stock rises; receivables grow without corresponding sales growth; fixed assets grow as a percentage of total assets without visible expansion.
Improper disclosures: Analysis of the numbers alone may not reveal these, which is why the ACFE stresses reading notes, related-party information and management discussion alongside the quantitative work.
7. Limitations You Must Know
Examiners frequently test the limits of these techniques:
- Analysis identifies anomalies, not proof of fraud. Legitimate causes (new product lines, acquisitions, accounting policy changes, economic conditions) must be ruled out.
- Ratios depend on accurate underlying data; if both numerator and denominator are falsified proportionally, the ratio may look normal.
- Industry comparisons can mislead if the peer group or accounting methods differ.
- Small companies and single-period data provide a weak basis for trend analysis.
- Percentage changes on a small base can be exaggerated and should be judged for materiality and relevance.
8. How to Answer Exam Questions on This Topic
Step 1: Identify which technique the question is testing. Keywords help: percentage change from the prior year or trend signals horizontal analysis; percentage of total assets or percentage of net sales or common-size signals vertical analysis; a named relationship such as current ratio or inventory turnover signals ratio analysis.
Step 2: Recall the exact formula and the correct base. The most common error is dividing by the wrong figure. Horizontal percentage change always divides by the base (prior) year, not the current year. Vertical analysis of the income statement always uses net sales; of the balance sheet, total assets.
Step 3: Perform the computation carefully. Write out the numerator and denominator before dividing. Watch for averages: receivable turnover and inventory turnover use average balances when beginning and ending amounts are both given.
Step 4: Reason about direction when asked for interpretation. Ask: which account did the fraud scheme inflate or deflate, and is that account in the numerator or denominator? Then determine whether the ratio rises or falls.
Step 5: Choose the answer that fits the ACFE's conservative framing. The correct option typically describes the result as a red flag requiring further investigation, not as conclusive evidence of fraud.
9. Exam Tips: Answering Questions on Horizontal, Vertical and Ratio Analysis
Tip 1: Memorize the formula list cold. Current ratio, quick ratio, receivable turnover, collection ratio, inventory turnover, average days inventory in stock, debt to equity, profit margin and asset turnover. Expect at least one direct calculation.
Tip 2: Know what the quick ratio excludes. Inventory and prepaid expenses are excluded. If an answer option includes inventory in the quick ratio numerator, it is wrong.
Tip 3: For horizontal analysis, the prior year is always the denominator. A change from 100 to 150 is a 50 percent increase, not 33 percent.
Tip 4: For vertical analysis, remember the two bases. Income statement equals net sales at 100 percent; balance sheet equals total assets at 100 percent. Questions often test whether you know that gross profit percentage is a vertical analysis figure.
Tip 5: Practice the direction logic with fictitious revenue. Fictitious sales recorded to receivables increase sales (numerator of receivable turnover) but increase receivables even more over time because they are never collected, so turnover falls and collection days rise. This is one of the most tested scenarios.
Tip 6: Concealed liabilities improve liquidity and leverage ratios. If a question describes a company that failed to record payables, expect the current ratio to be overstated and debt to equity understated.
Tip 7: Overstated inventory does two things at once. It increases current assets and decreases cost of goods sold, so the current ratio rises, inventory turnover falls, gross margin rises and profit margin rises. Questions may ask for any one of these effects.
Tip 8: When a question says a ratio alone proves fraud, that answer is wrong. The ACFE consistently teaches that analysis identifies anomalies that warrant follow-up through documents, interviews and other procedures.
Tip 9: Compare related accounts, not isolated figures. If an answer option identifies a red flag based on a relationship (sales up 30 percent while COGS up 2 percent), it is usually the best answer compared with an option that cites a single number without context.
Tip 10: Watch for distractor terminology. Horizontal analysis may be called trend analysis; vertical analysis may be called common-size analysis; the collection ratio may be called days sales outstanding or average collection period; the quick ratio may be called the acid-test ratio. Recognize all synonyms.
Tip 11: Read numbers in the question stem twice. Exam writers sometimes present beginning and ending balances and expect you to average them, or present total sales when the formula calls for credit sales. Use the data given exactly as the ACFE formula requires.
Tip 12: Eliminate answers that confuse cause and effect. A ratio changing does not cause fraud; a fraud scheme causes the ratio to change. Answer options that reverse this logic are distractors.
10. Quick Reference Summary
Horizontal analysis: Compare across periods; percentage change = (current minus base) divided by base; look for related accounts moving inconsistently.
Vertical analysis: Compare within one period; income statement base is net sales, balance sheet base is total assets; look for shifts in proportion over time or versus industry.
Ratio analysis: Liquidity (current, quick), activity (receivable turnover, collection ratio, inventory turnover, days inventory, asset turnover), leverage (debt to equity), profitability (profit margin); reason through numerator and denominator effects of each fraud scheme.
Core principle: These tools reveal where the numbers stop fitting together. The fraud examiner uses them to target further investigation, never as stand-alone proof. Master the formulas, the bases, the direction logic and the limitations, and you will handle any CFE question on this topic with confidence.
Test mode:
CFE - Horizontal, Vertical and Ratio Analysis Example Questions
Test your knowledge of Horizontal, Vertical and Ratio Analysis
Question 1
Booking fictitious credit sales that remain uncollected tends to shorten the average number of days needed to collect accounts receivable, a pattern a fraud examiner can spot through ratio analysis.
Question 2
In vertical analysis of an income statement, each line item is expressed as a percentage of net sales, which serves as the base figure of 100 percent.
Question 3
A fraud examiner compares three years of financial statements. Horizontal analysis shows sales rising modestly, with accounts receivable growing in line with sales. Vertical analysis shows repairs and maintenance expense falling sharply as a percentage of sales, while property, plant and equipment rises as a percentage of total assets. Fixed asset turnover also declines. The board approved no new capital projects during the period. Which scheme do these results MOST strongly suggest?
Unlock Premium Access
Certified Fraud Examiner (CFE)
- Access to ALL Certifications: Study for any certification on our platform with one subscription
- 3404 Superior-grade Certified Fraud Examiner (CFE) practice questions
- Unlimited practice tests across all certifications
- Detailed explanations for every question
- CFE: 5 full exams plus all other certification exams
- 30-Day Money-Back Guarantee: Full refund within 30 days if unsatisfied
- Risk-Free: 7-day free trial with all premium features!
More Horizontal, Vertical and Ratio Analysis questions
19 questions (total)