FBLA Review: Financial Statement Analysis (Vertical, Horizontal, Ratios)

FBLA – Financial Statement Analysis (Vertical, Horizontal, Ratios)

What This Is (1 short paragraph)

Financial statement analysis is the systematic review of a company’s Income Statement, Balance Sheet, and Statement of Cash Flows to evaluate performance, profitability, and financial health. FBLA competitors must be able to convert raw numbers into vertical & horizontal analyses and calculate key ratios—skills that help a student?run school store decide whether to expand inventory, negotiate better credit terms, or seek a loan.

Key Terms & Formulas (8–12 bullets)

• Vertical Analysis – Expresses each line item as a percentage of a base figure (e.g., every Income Statement item as a % of Net Sales).
• Horizontal Analysis – Measures dollar and percentage change of each line item over multiple periods (? = Current?–?Prior; %? =-÷ Prior).
• Current Ratio – Current Assets ÷ Current Liabilities; gauges short?term liquidity.
• Quick (Acid?Test) Ratio – (Cash + Marketable Securities + Accounts Receivable) ÷ Current Liabilities; excludes inventory.
• Debt?to?Equity Ratio – Total Liabilities ÷ Total Equity; shows financial leverage.
• Gross Profit Margin – (Net Sales – Cost of Goods Sold) ÷ Net Sales × 100%; indicates production efficiency.
• Operating Profit Margin – Operating Income ÷ Net Sales × 100%; reflects core business profitability before interest & taxes.
• Return on Assets (ROA) – Net Income ÷ Average Total Assets × 100%; measures how well assets generate earnings.
• Return on Equity (ROE) – Net Income ÷ Average Shareholders’ Equity × 100%; assesses shareholder value creation.
• Cash Conversion Cycle (CCC) – Days Inventory Outstanding + Days Sales Outstanding – Days Payables Outstanding; tracks cash flow efficiency.
• Common?Size Income Statement – A vertical analysis of the Income Statement; each line item shown as % of Net Sales.
• Trend Analysis – A horizontal analysis that plots %? over several years to spot patterns (e.g., rising COGS vs. stagnant sales).

Step?by?Step / Process Flow (3–6 steps)

1. Gather the statements – Obtain the most recent Income Statement, Balance Sheet, and Cash Flow for at least two consecutive years.
2. Perform vertical analysis – Convert each Income Statement line to a % of Net Sales and each Balance Sheet line to a % of Total Assets. Record the percentages in a “common?size” table.
3. Conduct horizontal analysis – Calculate dollar and % change for every line item between the two periods; highlight items with >?10?% change.
4. Compute key ratios – Plug the appropriate figures into the formulas above (Current Ratio, ROE, etc.). Use average balances when required (e.g., average assets = (Beginning?+?Ending) ÷ 2).
5. Interpret the results – Compare percentages and ratios to industry benchmarks or prior years; identify strengths (e.g., high Gross Margin) and red flags (e.g., declining Current Ratio).
6. Summarize recommendations – Write a concise analysis (?150 words) stating whether the business is financially sound, where improvements are needed, and what actions (e.g., tighten credit, reduce inventory) you would advise.

Common Mistakes (3–5)

• Mistake: Using total assets as the base for vertical Income Statement analysis.
  Correction: The base for Income Statement vertical analysis is Net Sales; total assets is only for Balance Sheet vertical analysis.

• Mistake: Forgetting to average beginning and ending balances for ratios that require “average” (ROA, ROE, Debt?to?Equity).
  Correction: Always compute the average (Beginning?+?Ending) ÷ 2 before inserting into the ratio formula.

• Mistake: Mixing dollar change with percentage change in horizontal analysis (e.g., reporting $5,000 increase as 5?%).
  Correction: Separate the two: ? = Current?–?Prior (dollar) and %? =-÷ Prior × 100%.

• Mistake: Including inventory in the Quick Ratio calculation.
  Correction: Quick Ratio excludes inventory; only cash, marketable securities, and accounts receivable are counted.

• Mistake: Comparing a company’s ratio to an industry average without adjusting for different fiscal year?ends.
  Correction: Align periods or note the timing difference; otherwise the comparison may be misleading.

Exam Insights (2–4)

• Vertical vs. Horizontal – FBLA often asks you to label a table as “common?size” (vertical) or “trend” (horizontal). Remember the base figure: Net Sales for Income Statement, Total Assets for Balance Sheet.
• Ratio “plug?in” – Expect a multiple?choice where you must select the correct formula; watch for distractors that swap numerator/denominator (e.g., Current Assets ÷ Current Liabilities vs. the reverse).
• Benchmarking – Questions may give an industry average (e.g., Current Ratio?=?2.0) and ask whether the firm is “over?leveraged.” Know the direction: a higher Current Ratio = better liquidity, a higher Debt?to?Equity = more risk.
• Role?play tip – If the scenario requires you to advise a “school store,” frame your answer in business?language: “Based on the declining Current Ratio (1.2 vs. industry 1.8), I recommend negotiating longer payment terms with suppliers.”

Quick Check Questions (2–3)

1. A company’s Net Sales = $500,000, COGS = $300,000. What is the Gross Profit Margin?
   Answer: 40%
   Explanation: Gross Profit = $500,000?–?$300,000?=?$200,000; Margin = $200,000 ÷ $500,000 ×?100% = 40%.

2. Current Assets = $120,000; Current Liabilities = $80,000. What is the Current Ratio, and does it meet the industry standard of 1.5?
   Answer: 1.5; Yes, it meets the standard.
   Explanation: Current Ratio = 120,000 ÷ 80,000 = 1.5, exactly the benchmark.

3. Year?1 Total Assets = $400,000; Year?2 Total Assets = $440,000. Net Income for Year?2 = $44,000. Calculate ROA for Year?2.
   Answer: 10%
   Explanation: Average Assets = (400,000?+?440,000) ÷ 2 = 420,000; ROA = 44,000 ÷ 420,000 ×?100%-10.5% (rounded to 10%).

Last?Minute Cram Sheet (10 one?liners)

• Vertical analysis = % of base (Income: Net Sales; Balance: Total Assets).
• Horizontal analysis = ? and %? between periods.
• Current Ratio = Current Assets ÷ Current Liabilities (1.5 is generally healthy).
• Quick Ratio excludes inventory; use only cash, marketable securities, & A/R.
• Debt?to?Equity = Total Liabilities ÷ Shareholders’ Equity; higher = more risk.
• Gross Margin = (Net Sales?–?COGS) ÷ Net Sales ×?100%.
• ROA = Net Income ÷ Average Total Assets ×?100%; ROE = Net Income ÷ Average Equity ×?100%.
• Cash Conversion Cycle = DIO + DSO – DPO; shorter = better cash flow.
• Average balance = (Beginning?+?Ending) ÷ 2 – always use for ROA, ROE, Debt?to?Equity.
• Trap: Swapping numerator/denominator in ratios (e.g., Liabilities ÷ Assets instead of Assets ÷ Liabilities).

Good luck—your analysis skills are the bridge between numbers and strategic decisions!