Cash & Receivables: Management, Analysis & Optimization

Core Concepts

1. Cash Management: The Lifeblood of Business

Cash is the most liquid asset, but holding too much reduces profitability while shortages cause operational failures. Effective cash management balances liquidity (ability to meet short-term obligations) and profitability (earning returns on excess cash).

Key Components of Cash Management

• Cash Conversion Cycle (CCC): Measures how long cash is tied up in operations. $$\text{CCC}=\text{Inventory Period}+\text{Receivables Period}-\text{Payables Period}$$ Goal: Minimize CCC to free up cash faster.

• Cash Budgets: Forecast inflows (sales, loans) and outflows (expenses, payments) to avoid shortages or surpluses.

  flowchart TD
    A["Sales Revenue"] --> B["Cash Inflows"]
    C["Operating Expenses"] --> D["Cash Outflows"]
    B --> E["Net Cash Flow"]
    D --> E
    E --> F["Ending Cash Balance"]
    F -->|"If Negative"| G["Short-Term Borrowing"]
    F -->|"If Positive"| H["Invest Excess"]

• Bank Reconciliation: Ensures recorded cash matches bank statements by identifying discrepancies (e.g., unrecorded deposits, outstanding checks).

2. Receivables Management: Turning Sales into Cash

Receivables are current assets representing money owed by customers. Poor management leads to bad debts or delayed cash flows.

Key Tools for Receivables Management

In the Real World

1. eSewa’s Cash Flow Challenge

   • eSewa processes millions of transactions daily, requiring real-time cash reconciliation to match digital payments with bank records. A misreconciliation could freeze funds or trigger fraud alerts.
   • Application: Their automated cash budgeting system predicts peak usage (e.g., during Dashain) to ensure liquidity.

2. Khalti’s Receivables Strategy

   • Khalti extends credit-like services (e.g., "Khalti Loan") by analyzing customer transaction history (similar to receivables aging). Overdue loans are marked for collection calls or blacklisting.
   • Application: Their 24-hour payment window for merchants mimics tight credit terms to minimize bad debts.

3. NTC’s Cash Conversion Cycle

   • NTC’s inventory period (telecom equipment storage) and receivables period (billing customers like Ncell) are critical. Delays in collecting prepaid top-ups (receivables) force NTC to optimize billing cycles.
   • Worked Example:
   • Assume NTC’s average inventory period = 45 days, receivables period = 30 days, and payables period = 15 days.
   • CCC = 45 + 30 − 15 = 60 days.
   • Action: NTC could negotiate shorter payment terms with suppliers (reduce inventory period) or offer discounts for early bill payments (reduce receivables period).

Visual 1: Cash Budget for a Kathmandu Retail Shop (Monthly)

Assume Shop Everest (selling electronics) has:

• Opening Cash: ₹500,000
• Sales Revenue: ₹2,000,000 (₹1,500,000 cash + ₹500,000 credit)
• Expenses:
  • Rent: ₹200,000
  • Salaries: ₹300,000
  • Inventory Purchase: ₹800,000 (₹600,000 cash + ₹200,000 credit)
  • Miscellaneous: ₹100,000

Analysis:

• Shop Everest ends with a surplus (₹800K), which could be invested in short-term securities (e.g., NMB Bank’s 8% T-Bills) or used to pay off credit purchases early.

Visual 2: Aging Schedule for Shop Everest’s Receivables

Assume ₹500,000 in outstanding receivables as of June 30, 2024:

Decision:

• ₹140,000 (28%) is at risk; Shop Everest should tighten credit terms (e.g., require 50% upfront for new customers) or factor ₹50,000 to a bank at a 12% discount rate.

Visual 3: The Accounting Cycle for Cash & Receivables

flowchart TD
    A["1. Record Transactions"] --> B["Journal Entries"]
    B --> C["Ledger Postings"]
    C --> D["Trial Balance"]
    D --> E["Adjusting Entries"]
    E --> F["Adjusted Trial Balance"]
    F --> G["Financial Statements"]
    G --> H["Closing Entries"]
    H --> I["Post-Closing Trial Balance"]
    G --> J["Cash Flow Statement"]
    J --> K["Analysis: Liquidity Ratios"]
    K --> L["Decision: Optimize Cash/Receivables"]

Example Journal Entry for Shop Everest:

• Sale on Credit (₹500,000):

  Dr. Accounts Receivable (₹500,000)
  Cr. Sales Revenue (₹500,000)
  

• Collection of Receivables (₹200,000):

  Dr. Cash (₹200,000)
  Cr. Accounts Receivable (₹200,000)
  

Visual 4: T-Account for Cash (Shop Everest)

T-Account for Cash: Cash

Dr (₹) | Cr (₹)

500,000 | 200,000 (Rent) 1,500,000| 300,000 (Salaries) 500,000 | 600,000 (Inventory)

2,500,000 | 1,100,000

Balance: ₹1,400,000 (Dr) Note: The ₹1,400,000 matches the closing balance in the cash budget.

Key Ratios to Master

Worked Example for Shop Everest:

• Net Credit Sales (Year): ₹6,000,000
• Avg. Receivables: ₹500,000
• Receivables Turnover = ₹6,000,000 / ₹500,000 = 12 times/year.
• Average Collection Period = 365 / 12 ≈ 30.4 days.
• Analysis: Shop Everest’s 30-day collection period matches its credit policy, indicating efficient receivables management.

Strategies to Optimize Cash & Receivables

1. Cash Management Strategies

2. Receivables Management Strategies

Exam Tip

1. Numerical Problems (40% Weight)

   • Always show work: Break down CCC, aging schedules, and cash budgets step-by-step.
   • Example Question:

     "A company has inventory of ₹1,000,000 (sold in 60 days), receivables of ₹500,000 (collected in 30 days), and payables of ₹300,000 (paid in 15 days). Calculate CCC and suggest improvements."

     • Solution: CCC = 60 + 30 − 15 = 75 days. Improvement: Negotiate shorter payment terms with suppliers (reduce inventory period) or offer discounts for early payments (reduce receivables period).

2. Ratio Analysis (30% Weight)

   • Memorize current ratio, quick ratio, and receivables turnover formulas.
   • Example Question:

     "Given: Current Assets = ₹2,000,000; Inventory = ₹500,000; Current Liabilities = ₹1,000,000. Calculate quick ratio and interpret."

     • Solution: Quick Ratio = (₹2,000,000 − ₹500,000) / ₹1,000,000 = 1.5:1. Interpretation: The company can cover short-term liabilities even if inventory isn’t sold quickly.

3. Conceptual Questions (30% Weight)

   • Define cash conversion cycle, factoring, and lockbox system.
   • Compare trade credit vs. bank loans for financing receivables.

     Aspect	Trade Credit	Bank Loan
     Cost	Implicit (interest in late fees).	Explicit (interest rates, fees).
     Flexibility	Tied to suppliers.	Independent of suppliers.
     Risk	Lower (supplier relationship).	Higher (loan covenants, collateral).
     Speed	Instant (if approved).	Slow (loan processing).

Final Checklist for Exams: ✅ Cash Budget: Always reconcile opening/closing balances. ✅ Aging Schedule: Flag >90-day receivables as "bad debt risk." ✅ Ratios: Know how to calculate and interpret current ratio, quick ratio, and CCC. ✅ Real-World Tie: Relate answers to eSewa, Khalti, or NTC for contextual marks.