This reference workbook details the mathematical frameworks used to calculate the Day 1 liquidity injection of Factoring, its associated capital costs, and its impact on corporate profit margins.
Kamal holds a $2,000,000 invoice due in 90 days. He assigns it to a Factor with an 85% Advance Rate.
| Cell | Data Label | Forensic Input Value |
|---|---|---|
| B2 | Gross Invoice Value | $2,000,000 USD |
| B3 | Factor Advance Rate | 85% |
| B4 | Factor Reserve (Rebate) Rate | 15% |
Immediate Day 1 Liquidity (Cell B5):
Logic: $2M × 85% = $1,700,000 USD Cash Today.
This immediate injection saves Kamal from the Open Account Cash Conversion Cycle trap, allowing him to fund operations instantly.
Factoring is not free. The Factor charges a 1% Service Fee on the gross invoice, plus a 6% annualized Discount Rate on the cash advanced for the 90-day wait.
| Cell | Data Label | Forensic Input Value |
|---|---|---|
| C2 | Gross Invoice Value | $2,000,000 USD |
| C3 | Service Fee (Flat %) | 1.0% |
| C4 | Annual Discount Rate | 6.0% |
| C5 | Cash Advanced | $1,700,000 USD |
| C6 | Days Outstanding | 90 Days |
Total Factoring Cost (Cell C7):
Logic: ($2M × 1%) + ($1.7M × (6%/360) × 90) = $20,000 + $25,500 = $45,500 USD Total Fee.
The $45,500 is the price Kamal pays to pull the cash forward 90 days.
On Day 90, Munich Wire Works pays the full $2M to the Factor. The Factor recovers their $1.7M advance, deducts their $45,500 in fees, and wires the remainder to Kamal.
| Cell | Data Label | Forensic Input Value |
|---|---|---|
| D2 | Gross Invoice Paid to Factor | $2,000,000 USD |
| D3 | Day 1 Advance Distributed | -$1,700,000 USD |
| D4 | Total Factoring Cost | -$45,500 USD |
Day 90 Final Rebate to Kamal (Cell D5):
Logic: $2,000,000 - $1,700,000 - $45,500 = $254,500 USD Final Wire. Kamal's total cash received for the $2M trade is $1,954,500.
This reference workbook details the financial models used to execute Supply Chain Finance (Reverse Factoring) to protect upstream suppliers, and the high-yield ROI of Dynamic Discounting.
Kamal (the Buyer) owes his African supplier $1,000,000 on Day 90. If the supplier factored it locally, it would cost them 12%. Kamal sets up an SCF portal allowing the supplier to use Kamal's credit rating at a 2% annualized rate.
| Cell | Data Label | Forensic Input Value |
|---|---|---|
| E2 | Trade Payable Value | $1,000,000 USD |
| E3 | Days to Maturity | 90 Days |
| E4 | Local African Factor Rate (Annual) | 12% |
| E5 | Kamal's Tier-1 SCF Rate (Annual) | 2% |
Supplier Savings Algorithm (Cell E6):
Logic: Local Cost ($30,000) - SCF Cost ($5,000) = $25,000 USD Saved by Supplier. Kamal secures his supply chain's survival without using a single dollar of his own cash.
Kamal holds $5,000,000 in excess corporate cash earning 1% in a checking account. Instead of using a bank for SCF, he offers the supplier an early payment directly from his own treasury at a 1.5% absolute discount on the invoice.
| Cell | Data Label | Forensic Input Value |
|---|---|---|
| F2 | Trade Payable Value | $1,000,000 USD |
| F3 | Dynamic Discount Rate (Flat) | 1.5% |
| F4 | Kamal's Treasury Cash Outlay | $985,000 USD |
Treasury ROI Generation (Cell F5):
Logic: $1,000,000 × 1.5% = $15,000 USD Pure Risk-Free Profit.
Kamal transforms his lazy treasury cash into a high-yield asset by taking the $15k discount that would have otherwise gone to a commercial bank.
Evaluating Kamal's Cash Conversion Cycle before and after implementing Dual-Sided Liquidity optimization (Factoring Receivables + SCF on Payables).
| Cell | Data Label | Baseline (Without Finance) | Optimized (With Finance) |
|---|---|---|---|
| G2 | Days Sales Outstanding (DSO) | 90 Days | 1 Day (Factored) |
| G3 | Days Inventory Outstanding (DIO) | 30 Days | 30 Days |
| G4 | Days Payable Outstanding (DPO) | 10 Days (Supplier demanded cash) | 90 Days (SCF Backed) |
CCC Calculation = DIO + DSO - DPO (Cell G5):
Logic (Baseline): 30 + 90 - 10 = 110 Days (Trapped Cash).
Logic (Optimized): 30 + 1 - 90 = -59 Days (Negative CCC). By mastering liquidity, Kamal generates cash 59 days *before* he has to pay it out, unlocking infinite scaling potential.