Working Capital Analysis

Calculate WC, Working Capital Ratio, and Quick Ratio from balance sheet data.

Cash Conversion Cycle

Calculate DSO, DIO, DPO and the Cash Conversion Cycle. Interpret and improve.

13-Week Forecast Build

Build a complete 13-week rolling cash forecast from weekly inflows and outflows.

13-Week Forecast Update

Roll the forecast forward using Week 1 actuals and recalculate Weeks 2-13.

Early Payment Discount Analysis

Calculate effective annual rate of a discount and decide whether to take it.

Supplier Negotiation Scenario

Calculate cash freed by extending DPO across multiple supplier relationships.

Customer Collection Optimization

Quantify cash impact of reducing DSO and calculate ROI of collections automation.

Debt Service Coverage

Calculate EBITDA and cash-based DSC ratios and check covenant compliance.

Covenant Compliance Check

Calculate all financial covenant ratios and identify breaches.

Refinancing Analysis

Compare existing vs. refinanced loan to calculate savings, payback and decision.

CapEx Cash Flow Forecast

Build a 5-year after-tax cash flow forecast for a capital project with MACRS.

CapEx Investment Decision

Rank multiple CapEx projects by NPV and payback period within a budget.

Working Capital During Projects

Calculate incremental WC investment by year and WC recovery at project end.

Tax Effects of CapEx

Calculate MACRS tax shields and after-tax operating cash flows by year.

Cash Bridge Reconciliation

Build a cash bridge: categorize movements into operating, investing, financing.