CredWisdomConfident Decisions
AFM Paper 3 — AFM Module B & D — Financial Statement Ratios, Working Capital Cycle & Inventory EOQ Weightage: 12 to 15 Marks (High-Frequency AFM Balance Sheet Case Study) 17 mins study
Ratio Analysis, DuPont ROE, Cash Conversion Cycle & EOQ
AFM Paper 3 (AFM Module B & D — Financial Statement Ratios, Working Capital Cycle & Inventory EOQ) — 3 Solved Case Sets & Interactive Calculator
Master the complete Balance Sheet & Cost Management numerical toolkit for JAIIB AFM: Reconstructing Current Assets & Inventory from Current Ratio and Quick Ratio, Inventory/Debtors Velocity, Gross vs Net Operating Cycle (Cash Conversion Cycle), 3-Factor DuPont ROE decomposition, and Wilson’s Economic Order Quantity (EOQ) & Re-order Level.
Switch JAIIB Workbook: Depreciation (SLM Bond Valuation: Current Yield Ratio Analysis Retail Banking: Home Loan LTV Slabs
All 4 Workbooks Step 1: Formula & Regulatory Cheat Sheet
Practice Dynamic AFM Paper 3 Case Studies Core Formulas, Accounting Rules & Examiner Traps
| Concept / Metric | Exact Mathematical Formula | Regulatory / Accounting Norm | Common IIBF Examiner Trap |
|---|---|---|---|
| Liquidity Ratios: Current Ratio & Quick (Acid-Test) Ratio | Current Ratio = Current Assets / Current Liabilities; Quick Ratio = (Current Assets - Inventory - Prepaid Expenses) / Current Liabilities | Difference between Current Assets and Quick Assets is always (Inventory + Prepaid Expenses) | When given Current Ratio (2.5:1), Quick Ratio (1.5:1), and Inventory (₹100 L), the ratio difference (2.5 - 1.5 = 1.0) directly equals Inventory = 1.0 × CL! |
| Gross Operating Cycle & Net Cash Conversion Cycle (CCC) | Gross Operating Cycle = RM Holding Days + WIP Days + FG Days + Receivable Collection Days; Net CCC = Gross Operating Cycle - Creditors Payment Days | Number of Operating Cycles per Year = 365 (or 360) / Net Operating Cycle Days | Payables deferral period (Creditor Days) is subtracted to arrive at Net Cash Conversion Cycle, but excluded from Gross Operating Cycle. |
| 3-Step DuPont Return on Equity (ROE) Identity | ROE = Net Profit Margin (PAT / Sales) × Total Asset Turnover (Sales / Total Assets) × Equity Multiplier (Total Assets / Net Worth) | Note that Net Profit Margin × Total Asset Turnover = Return on Assets (ROA = PAT / Total Assets) | If Debt-to-Total-Assets ratio is 60%, then Equity-to-Total-Assets is 40%, so Equity Multiplier (Assets / Equity) = 1 / 0.40 = 2.50x! |
| Economic Order Quantity (EOQ) & Re-Order Level (ROL) | EOQ = √[(2 × Annual Demand D × Ordering Cost S) / Annual Carrying Cost per Unit H]; ROL = Maximum Usage × Maximum Lead Time | At EOQ, Total Annual Ordering Cost [(D/EOQ) × S] exactly equals Total Annual Carrying Cost [(EOQ/2) × H] | If Carrying Cost is given as a % of Unit Purchase Price (e.g., 10% of ₹80), compute H = ₹8 per unit per year first! |
CASE STUDY SET #1Moderate (IIBF Standard)10 Marks (5 × 2M)
Reconstructing Balance Sheet from Liquidity, Turnover & Leverage Ratios
Official IIBF Case Scenario & Financial Data:
From the financial statements of M/saveri Consumer Products Ltd. for FY 2025-26, the credit analyst extracts the following ratios and figures:
| Ratio / Financial Metric | Value |
|---|---|
| Current Ratio | 2.50 : 1 |
| Quick Ratio (Acid-Test Ratio; Prepaid Expenses = Nil) | 1.30 : 1 |
| Closing Inventory (Stock) | ₹180 Lakhs |
| Inventory Turnover Ratio (based on Cost of Goods Sold & Closing Stock) | 6 Times |
| Gross Profit Margin (on Sales) | 25% of Sales |
| Average Collection Period (assuming 360 days in a year, all Credit Sales) | 45 Days |
Question 1.1 • 2 Marks
What are the Total Current Liabilities (CL) and Total Current Assets (CA) of the company?
A CL = ₹150 Lakhs; CA = ₹375 Lakhs
B CL = ₹180 Lakhs; CA = ₹450 Lakhs
C CL = ₹120 Lakhs; CA = ₹300 Lakhs
D CL = ₹150 Lakhs; CA = ₹330 Lakhs
Correct Answer: Option A — CL = ₹150 Lakhs; CA = ₹375 Lakhs
(Current Ratio - Quick Ratio) × CL = Inventory- Step 1: Current Ratio (2.50) - Quick Ratio (1.30) = 1.20 times Current Liabilities = Inventory (₹180 Lakhs).
- Step 2: Current Liabilities (CL) = ₹180 Lakhs / 1.20 = ₹150 Lakhs.
- Step 3: Total Current Assets (CA) = 2.50 × ₹150 Lakhs = ₹375 Lakhs (and Quick Assets = ₹375 - ₹180 = ₹195 Lakhs).
IIBF Examiner Tip: This ratio-subtraction shortcut solves every Current/Quick Ratio question in under 15 seconds.
Question 1.2 • 2 Marks
What is the Cost of Goods Sold (COGS) and Annual Credit Sales Turnover of the company?
A COGS = ₹1,080 Lakhs; Sales = ₹1,440 Lakhs
B COGS = ₹1,080 Lakhs; Sales = ₹1,350 Lakhs
C COGS = ₹900 Lakhs; Sales = ₹1,200 Lakhs
D COGS = ₹1,200 Lakhs; Sales = ₹1,600 Lakhs
Correct Answer: Option A — COGS = ₹1,080 Lakhs; Sales = ₹1,440 Lakhs
COGS = Inventory × Inventory Turnover; Sales = COGS / (1 - Gross Profit % on Sales)- Step 1: COGS = Inventory (₹180 Lakhs) × 6 = ₹1,080 Lakhs.
- Step 2: Since Gross Profit is 25% of Sales, COGS is 75% (0.75) of Sales.
- Step 3: Annual Sales = ₹1,080 Lakhs / 0.75 = ₹1,440 Lakhs (Gross Profit = ₹360 Lakhs).
IIBF Examiner Tip: Watch the trap: 25% GP on Sales equals 33.33% GP on COGS (₹1,080 / 0.75 = ₹1,440L, NOT ₹1,080 × 1.25 = ₹1,350L)!
Question 1.3 • 2 Marks
What is the closing Trade Receivables (Debtors) balance and the Cash & Bank balance (assuming Quick Assets consist only of Debtors and Cash & Bank)?
A Debtors = ₹180 Lakhs; Cash & Bank = ₹15 Lakhs
B Debtors = ₹168.75 Lakhs; Cash & Bank = ₹26.25 Lakhs
C Debtors = ₹195 Lakhs; Cash & Bank = ₹0 Lakhs
D Debtors = ₹144 Lakhs; Cash & Bank = ₹51 Lakhs
Correct Answer: Option A — Debtors = ₹180 Lakhs; Cash & Bank = ₹15 Lakhs
Debtors = (Annual Credit Sales × Collection Period) / 360; Cash = Quick Assets - Debtors- Step 1: Debtors = (₹1,440 Lakhs × 45 Days) / 360 Days = ₹1,440 / 8 = ₹180 Lakhs.
- Step 2: Total Quick Assets = 1.30 × ₹150 Lakhs CL = ₹195 Lakhs.
- Step 3: Cash & Bank Balance = Quick Assets (₹195 Lakhs) - Debtors (₹180 Lakhs) = ₹15 Lakhs.
IIBF Examiner Tip: 45 days out of 360 days means Debtors Turnover Ratio is 360 / 45 = 8 times.
Question 1.4 • 2 Marks
What is the Net Working Capital (NWC) of the company?
A ₹225 Lakhs
B ₹195 Lakhs
C ₹180 Lakhs
D ₹250 Lakhs
Correct Answer: Option A — ₹225 Lakhs
Net Working Capital (NWC) = Total Current Assets - Total Current Liabilities- Step 1: Total Current Assets = ₹375 Lakhs; Total Current Liabilities = ₹150 Lakhs.
- Step 2: Net Working Capital (NWC) = ₹375 Lakhs - ₹150 Lakhs = ₹225 Lakhs.
IIBF Examiner Tip: Whenever Current Ratio > 1.0, Net Working Capital is positive.
Question 1.5 • 2 Marks
If the company’s Debt-Equity Ratio (Long-Term Debt / Shareholders’ Net Worth) is 1.50 : 1 and Shareholders’ Net Worth is ₹400 Lakhs, what is the Fixed Assets balance (assuming no other non-current assets)?
A ₹775 Lakhs
B ₹1,000 Lakhs
C ₹600 Lakhs
D ₹825 Lakhs
Correct Answer: Option A — ₹775 Lakhs
Long-Term Funds (Net Worth + Long-Term Debt) = Net Fixed Assets + Net Working Capital (NWC)- Step 1: Net Worth = ₹400 Lakhs; Long-Term Debt = 1.50 × ₹400 Lakhs = ₹600 Lakhs.
- Step 2: Total Long-Term Capital Employed = ₹400 + ₹600 = ₹1,000 Lakhs.
- Step 3: Since Long-Term Funds finance Net Fixed Assets + NWC (₹225 Lakhs), Net Fixed Assets = ₹1,000 Lakhs - ₹225 Lakhs = ₹775 Lakhs.
IIBF Examiner Tip: Total Assets = Net Fixed Assets (₹775L) + Current Assets (₹375L) = ₹1,150L = Net Worth (₹400L) + LT Debt (₹600L) + CL (₹150L).
CASE STUDY SET #2Advanced (High-Yield Numerical)10 Marks (5 × 2M)
Operating Cycle, Cash Conversion Cycle (CCC) & 3-Step DuPont ROE Analysis
Official IIBF Case Scenario & Financial Data:
An industrial components manufacturer reports the following working capital holding periods and profitability metrics for FY 2025-26:
| Operating / Financial Metric | Value |
|---|---|
| Raw Material Storage Period | 42 Days |
| Work-in-Process (Conversion) Period | 18 Days |
| Finished Goods Holding Period | 25 Days |
| Average Collection Period from Debtors | 50 Days |
| Average Payment Period to Trade Creditors | 45 Days |
| Annual Sales = ₹2,400 Lakhs | PAT = ₹192 Lakhs | Total Assets = ₹1,600 Lakhs | Equity = ₹640 Lakhs | DuPont Data |
Question 2.1 • 2 Marks
What is the Total Inventory Holding Period and the Gross Operating Cycle (in days)?
A Inventory Period = 85 Days; Gross Operating Cycle = 135 Days
B Inventory Period = 60 Days; Gross Operating Cycle = 110 Days
C Inventory Period = 85 Days; Gross Operating Cycle = 90 Days
D Inventory Period = 67 Days; Gross Operating Cycle = 117 Days
Correct Answer: Option A — Inventory Period = 85 Days; Gross Operating Cycle = 135 Days
Inventory Period = RM + WIP + FG Days; Gross Operating Cycle = Inventory Period + Debtors Collection Days- Step 1: Total Inventory Holding Period = 42 (RM) + 18 (WIP) + 25 (FG) = 85 Days.
- Step 2: Gross Operating Cycle = 85 Days (Inventory) + 50 Days (Debtors) = 135 Days.
IIBF Examiner Tip: Gross Operating Cycle represents total days funds remain locked in current assets before cash realization.
Question 2.2 • 2 Marks
What is the Net Operating Cycle (Cash Conversion Cycle — CCC) and the number of Operating Cycles per year (assuming 360 days)?
A Net CCC = 90 Days; 4.00 Cycles per year
B Net CCC = 135 Days; 2.67 Cycles per year
C Net CCC = 80 Days; 4.50 Cycles per year
D Net CCC = 180 Days; 2.00 Cycles per year
Correct Answer: Option A — Net CCC = 90 Days; 4.00 Cycles per year
Net CCC = Gross Operating Cycle - Creditors Payment Period; Cycles/Year = 360 / Net CCC- Step 1: Net Cash Conversion Cycle = 135 Days - 45 Days (Creditors) = 90 Days.
- Step 2: Operating Cycles per Year = 360 / 90 = 4.00 Cycles per year.
IIBF Examiner Tip: A 90-day (3-month) net operating cycle means working capital requirement is 1/4th (25%) of annual operating expenses.
Question 2.3 • 2 Marks
Using the DuPont data (Sales = ₹2,400 L, PAT = ₹192 L, Total Assets = ₹1,600 L), calculate the Net Profit Margin (%) and Total Asset Turnover Ratio.
A Net Profit Margin = 8.00%; Asset Turnover = 1.50x
B Net Profit Margin = 12.00%; Asset Turnover = 1.50x
C Net Profit Margin = 8.00%; Asset Turnover = 2.50x
D Net Profit Margin = 10.00%; Asset Turnover = 1.20x
Correct Answer: Option A — Net Profit Margin = 8.00%; Asset Turnover = 1.50x
Net Profit Margin = (PAT / Sales) × 100; Asset Turnover = Sales / Total Assets- Step 1: Net Profit Margin = (₹192 Lakhs / ₹2,400 Lakhs) × 100 = 8.00%.
- Step 2: Total Asset Turnover = ₹2,400 Lakhs / ₹1,600 Lakhs = 1.50 times.
IIBF Examiner Tip: Multiplying Net Profit Margin (8.00%) × Asset Turnover (1.50x) gives Return on Assets (ROA) = 12.00%.
Question 2.4 • 2 Marks
What is the Equity Multiplier (Financial Leverage Multiplier) and the Return on Equity (ROE %) under the 3-Step DuPont formula?
A Equity Multiplier = 2.50x; ROE = 30.00%
B Equity Multiplier = 1.50x; ROE = 18.00%
C Equity Multiplier = 2.00x; ROE = 24.00%
D Equity Multiplier = 2.50x; ROE = 20.00%
Correct Answer: Option A — Equity Multiplier = 2.50x; ROE = 30.00%
Equity Multiplier = Total Assets / Equity; ROE = ROA × Equity Multiplier = (PAT / Equity) × 100- Step 1: Equity Multiplier = Total Assets (₹1,600 L) / Equity (₹640 L) = 2.50x.
- Step 2: ROE = 8.00% (NPM) × 1.50 (Asset Turnover) × 2.50 (Equity Multiplier) = 30.00%.
- Step 3: Direct verification: (₹192 Lakhs PAT / ₹640 Lakhs Equity) × 100 = 30.00%.
IIBF Examiner Tip: DuPont analysis shows that the 30% ROE comes from 12% operating ROA amplified 2.5x by financial leverage.
Question 2.5 • 2 Marks
If the company reduces its Debtors Collection Period from 50 days to 32 days (without affecting sales or profit), how will its Net Cash Conversion Cycle and Total Asset Turnover respond?
A Net CCC drops from 90 to 72 days (5 cycles/yr); Asset Turnover & ROA improve
B Net CCC rises to 108 days; Asset Turnover falls
C Net CCC drops to 72 days; ROE falls
D No change in Net CCC or Asset Turnover
Correct Answer: Option A — Net CCC drops from 90 to 72 days (5 cycles/yr); Asset Turnover & ROA improve
Reduced Debtors Days = Lower Working Capital Tied Up = Higher Asset Turnover & Higher ROA- Step 1: Faster collection by 18 days lowers Net CCC from 90 days to 72 days (increasing cycles from 4 to 5 per year).
- Step 2: Less cash tied up in receivables lowers Total Assets required for the same ₹2,400L sales, boosting Asset Turnover, ROA, and ROE.
IIBF Examiner Tip: Working capital efficiency directly drives the second lever (Asset Turnover) of the DuPont ROE model.
CASE STUDY SET #3Moderate (IIBF Standard)10 Marks (5 × 2M)
Inventory Control: Economic Order Quantity (EOQ), Ordering/Holding Cost & Re-Order Level
Official IIBF Case Scenario & Financial Data:
A manufacturing unit consumes 40,000 units of a specialized microchip annually. The purchase price is ₹120 per unit. The cost of placing and receiving one purchase order is ₹500. Annual inventory carrying and storage cost is 10% of the unit purchase price. Normal lead time from supplier is 10 days (Maximum lead time = 15 days; Minimum lead time = 6 days). Normal daily consumption is 110 units (Maximum daily consumption = 140 units; Minimum daily consumption = 80 units).
| Inventory Parameter | Value |
|---|---|
| Annual Demand (D) | 40,000 Units |
| Purchase Price per Unit | Annual Carrying Cost % | ₹120 / unit | 10% p.a. (H = ₹12 / unit / yr) |
| Ordering Cost per Order (S) | ₹500 per order |
| Daily Usage (Min | Normal | Max) | 80 | 110 | 140 Units/day |
| Supplier Lead Time (Min | Normal | Max) | 6 | 10 | 15 Days |
Question 3.1 • 2 Marks
What is the Economic Order Quantity (EOQ) in units (rounded to the nearest whole unit)?
A 1,826 Units
B 2,000 Units
C 1,581 Units
D 1,291 Units
Correct Answer: Option A — 1,826 Units
EOQ = √[(2 × D × S) / H], where H = 10% of ₹120 = ₹12- Step 1: Annual Demand (D) = 40,000; Ordering Cost (S) = ₹500; Holding Cost (H) = 10% of ₹120 = ₹12 per unit.
- Step 2: 2 × D × S = 2 × 40,000 × 500 = 4,00,00,000.
- Step 3: Divide by H (12): 4,00,00,000 / 12 = 33,33,333.33.
- Step 4: Square root: √33,33,333.33 = 1,825.74 -> 1,826 Units.
IIBF Examiner Tip: Always compute H = Carrying Cost % × Purchase Price per unit before taking the square root.
Question 3.2 • 2 Marks
Suppose for operational convenience the company orders in lots of 2,000 units per order. At 2,000 units per order, what are the Annual Ordering Cost, Annual Carrying Cost, and Combined Inventory Cost?
A Ordering Cost = ₹10,000; Carrying Cost = ₹12,000; Total = ₹22,000
B Ordering Cost = ₹12,000; Carrying Cost = ₹10,000; Total = ₹22,000
C Ordering Cost = ₹10,954; Carrying Cost = ₹10,954; Total = ₹21,908
D Ordering Cost = ₹8,000; Carrying Cost = ₹12,000; Total = ₹20,000
Correct Answer: Option A — Ordering Cost = ₹10,000; Carrying Cost = ₹12,000; Total = ₹22,000
Ordering Cost = (D / Q) × S; Carrying Cost = (Q / 2) × H- Step 1: Number of orders per year at Q = 2,000 units: 40,000 / 2,000 = 20 orders.
- Step 2: Annual Ordering Cost = 20 orders × ₹500 = ₹10,000.
- Step 3: Average Inventory = Q / 2 = 2,000 / 2 = 1,000 units; Annual Carrying Cost = 1,000 × ₹12 = ₹12,000.
- Step 4: Total Inventory Cost = ₹10,000 + ₹12,000 = ₹22,000 (compare with EOQ minimum of √(2×40000×500×12) = ₹21,909).
IIBF Examiner Tip: Notice how when Q (2,000) is higher than EOQ (1,826), Carrying Cost (₹12,000) is higher than Ordering Cost (₹10,000)!
Question 3.3 • 2 Marks
What is the Re-Order Level (ROL) in units to prevent stock-outs under worst-case demand and lead time?
A 2,100 Units
B 1,100 Units
C 1,650 Units
D 1,400 Units
Correct Answer: Option A — 2,100 Units
Re-Order Level (ROL) = Maximum Daily Consumption × Maximum Lead Time- Step 1: Maximum Daily Consumption = 140 Units/day.
- Step 2: Maximum Lead Time = 15 Days.
- Step 3: Re-Order Level (ROL) = 140 × 15 = 2,100 Units.
IIBF Examiner Tip: ROL is always set at Max Usage × Max Lead Time so the factory never runs out of raw material.
Question 3.4 • 2 Marks
What is the Minimum Stock Level (Safety / Buffer Stock) maintained by the company?
A 1,000 Units
B 1,620 Units
C 480 Units
D 1,100 Units
Correct Answer: Option A — 1,000 Units
Minimum Stock Level = Re-Order Level (ROL) - (Normal Daily Usage × Normal Lead Time)- Step 1: Re-Order Level (ROL) = 2,100 Units.
- Step 2: Normal Consumption during Normal Lead Time = 110 Units/day × 10 Days = 1,100 Units.
- Step 3: Minimum Stock Level = 2,100 - 1,100 = 1,000 Units.
IIBF Examiner Tip: Memorize: Minimum Level = ROL - (Normal Usage × Normal Lead Time).
Question 3.5 • 2 Marks
Using the Re-Order Quantity (Q = 2,000 units), what is the Maximum Stock Level?
A 3,620 Units
B 4,100 Units
C 3,000 Units
D 2,520 Units
Correct Answer: Option A — 3,620 Units
Maximum Stock Level = ROL + Re-Order Quantity (ROQ) - (Minimum Daily Usage × Minimum Lead Time)- Step 1: ROL + ROQ = 2,100 + 2,000 = 4,100 Units.
- Step 2: Less Minimum Consumption during Minimum Lead Time = 80 Units/day × 6 Days = 480 Units.
- Step 3: Maximum Stock Level = 4,100 - 480 = 3,620 Units.
IIBF Examiner Tip: To reach Maximum Stock, consumption during lead time must be at its MINIMUM (80 × 6 = 480 units).
Live Gemini AI + Cloudflare KV Auto-Merge
Want More Practice on Ratio Analysis? Generate Case Study Set #4
Click to synthesize a brand-new 5-question (10-mark) IIBF numerical case study for AFM Paper 3 on the fly. Every newly generated set is also automatically deduplicated and merged into our global Cloudflare KV question bank.
Step 3: Interactive Calculation Sandbox
Open Full Interactive Cash Conversion & Operating Cycle Engine Try With Your Own Numbers: Live Ratio Analysis Calculator
Modify any input below to watch the step-by-step JAIIB formula outputs update in real time.
Gross Operating Cycle (Inv + Debtors):120 Days
Net Cash Conversion Cycle (CCC):80 Days
Economic Order Quantity (EOQ):1897 Units
Frequently Asked JAIIB Exam Questions (AFM Paper 3)
Why are Prepaid Expenses excluded from Quick Assets when computing the Quick Ratio?
Because Prepaid Expenses (such as advance rent or advance insurance) cannot be converted back into cash to pay off current liabilities; they only represent services to be consumed in future accounting periods.
What is the Debt Service Coverage Ratio (DSCR) benchmark vs Interest Coverage Ratio (ICR)?
Interest Coverage Ratio (EBIT / Interest Expense) only checks whether operating profit covers interest (benchmark ≥ 2.5x–3.0x), whereas DSCR checks whether post-tax cash accruals cover BOTH Interest and Principal repayments (benchmark ≥ 1.50x).
Welcome Back
Sign in to save reports and access premium credit tools.
or continue with
Don't have an account?