📊 Financial Analysis Suite

Cr
Dark
📝 Financial Management
📈 Financial Statements
📐 Ratio & Credit Analytics
🔮 Projections & Stress Testing
📋 Executive Dashboard
📝 Financial Inputs
📊 Debt Roll-Forward
💵 Cash Flow Statement
💰 Fund Flow Statement
📈 Ratio Analysis
📐 Ratio Calculations
🔄 Working Capital Cycle
📊 Projections
🏦 Debt Capacity
📉 Stress & Break-Even
📊 Analytics
🧮 Calculations
📋 Executive Summary

💾 Data Management Auto-saved

No saved profiles
📌 Instructions: Enter values in ₹ Cr. Highlighted cells are auto-calculated. STP of LTD is shown as "STP of Long Term Debt" under DSCR Inputs and included in Current Ratio calculation. Debt Roll-Forward auto-fills from Term Loan & Interest.
Input Field (Editable)
Calculated Field (Auto)
Profit & Loss Account
Balance Sheet
DSCR Inputs (Actual Debt Service)
✅ Balanced

📊 Corporate Debt Roll-Forward & Principal Calculator

Reconciles balance sheet movements and solves for unknown Principal and Fresh Loan parameters.

Financial Parameter Unit Credit Audit Source
Roll-Forward Check: Click "Calculate & Sync" below.
💡 Calculated Principal & Interest sync to DSCR Inputs (editable for manual overrides). The roll-forward check validates: Opening + Fresh Loans − Principal = Closing.

🔧 Defaults: ROI = 10%, Tenure = 32 months.

Calculate ratios to see results.

Calculate ratios to see step-by-step.

💵 Cash Flow Statement

Auto‑generated from P&L and Balance Sheet movements

Calculate ratios to generate cash flow.

Fund Flow Statement shows sources and uses of funds between two balance sheet dates. All components auto-calculate from P&L and Balance Sheet, but you can override any value.

Auto-Calculated Components (Editable)

Fund Flow Inputs
Capex (₹ Cr) -
Auto: Closing FA - Opening FA + Dep
Capex (₹ Cr) -
Auto-calculated
Sale of Fixed Assets (₹ Cr) -
Auto: Opening FA - Dep - Closing FA
Sale of Fixed Assets (₹ Cr) -
Auto-calculated
Dividend Paid (₹ Cr) -
Auto: Opening TNW + PAT - Closing TNW
Dividend Paid (₹ Cr) -
Auto-calculated

Fund Flow Statement (₹ Cr) - Uses Actual Principal from DSCR Inputs

🔄 Working Capital Cycle Analysis

Assess the efficiency of working capital management across the operating cycle

📌 What is Working Capital Cycle? The Working Capital Cycle (also known as the Cash Conversion Cycle) measures the time it takes for a company to convert its investments in inventory and other resources into cash flows from sales. CCC = Debtor Days + Inventory Days − Creditor Days. A shorter cycle indicates better liquidity and operational efficiency.

Calculate ratios to generate Working Capital Cycle analysis.

📊 3-Year Projections (Trend-Based)

Projected financials based on historical trends with back-calculated numbers

Historical CAGR
Historical average
Historical growth rate
Fixed Assets
On Total Debt
Effective rate
🔧 Historical CAGR
Of Previous Term Loan
Auto: Prev + PAT (P&L driven)
Historical avg
Inventory holding
Other current assets
Historical avg
Cash buffer
Historical trend
Trend-based
Trend-based
Trend-based
Loans to Group Cos.
Trend-based
Trend-based

📈 Projected Profit & Loss Account

Input Field (Editable)
Calculated Field (Auto)
Projected Profit & Loss AccountYear 4Year 5Year 6

📊 Projected Balance Sheet

Input Field (Editable)
Calculated Field (Auto)
Projected Balance SheetYear 4Year 5Year 6

📈 Projected DSCR (Debt Service Coverage Ratio) – Including Current Year

⚠️ Working Capital Interest excluded - matches Ratio Calculation panel methodology • Current Year = Actuals (Y3) + 3 Projected Years for trend comparison

DSCR Components (Term Debt Focus)Year 3 (Current)Year 4Year 5Year 6

Run projections to generate the repayment schedule.

🏦 Debt Capacity — Term Loan Eligibility & Maximum Permissible Bank Finance

Term Loan Capacity Calculator + Tandon Committee Methods

🏦 Maximum Term Loan Eligibility Calculator

Calculates the maximum term loan a customer can service based on current or projected financial capacity.
Methodology: Uses EBITDA and DSCR to determine debt capacity, with sensitivity analysis. Toggle below between the current year (latest actuals) and the next three projected years.

Current Year uses latest actuals (Inputs tab); the other options use projected EBITDA, PAT, TNW & Debt (Projections tab)
Repayment period (1-20 years)
Annual interest rate
Lender's minimum DSCR requirement
Industry standard max leverage
Apply a safety buffer (0.5 - 1.0)
Maximum Term Loan
₹ 0.00 Cr
Final figure — least of the 3 methods below, after risk buffer
Current Debt
₹ 0.00 Cr
Total Secured Loans + Unsecured Loan (From Others)
Additional Capacity
₹ 0.00 Cr
Headroom vs. current debt

🏦 Maximum Permissible Bank Finance (Tandon Committee)

Current Assets
₹ 0.00 Cr
Less: CL (excl. BB)
₹ 0.00 Cr
Working Capital Gap
₹ 0.00 Cr
MPBF (Method I)
₹ 0.00 Cr
Method II (Total Current Assets)
MPBF = (75% × CA) − CL
Enter values above
MPBF = ₹ 0.00 Cr
Method III (Cash Budget)
Requires detailed monthly cash flow projection.

📈 MPBF Yearly Analysis

ParticularsNorm

📉 Stress Testing & Break-Even Analysis

Understand resilience to adverse scenarios and identify the operational threshold

🔧 Stress Scenario Parameters

📊 Stress Test Results

Click "Run Stress Test" to see analysis.

📈 Break-Even Analysis

Run stress test to generate break-even chart.

📉 Sensitivity Matrix (PAT Impact)

Run stress test to see sensitivity matrix.

💡 How to interpret: The stress test shows how financial ratios and profitability change under adverse conditions. The break-even point is where operating profit turns zero. Use the sensitivity matrix to understand which variable has the greatest impact.

📊 Analytics • Advanced Credit Intelligence

Traffic Light • Quality of Earnings • Cash Flow Sustainability • WC Diagnostics • Source-Application • Debt Capacity

Auto-runs after Update All Panels. All logic is transparent with formula trace.
Overall Credit Score
--
System Decision
RuleThresholdActualResultLogic

🧮 Overall Credit Score — Item-wise Breakdown & Scoring Logic

ComponentActual ValueScoring Logic (Slab)Slab HitScore

1. Quality of Earnings • PAT vs Cash vs Receivables

2. Cash Flow Sustainability • EBITDA → OCF → FCF → Debt Service → Surplus

Current Year uses latest actuals; projected years use Projections tab

3. Working Capital Diagnostics • Beyond Current Ratio

4. Source & Application of Funds

Where money came from → Where it went • Auto detects diversion

🚩 Red Flags + Auto Narrative

Run analysis...

Stress Quick-View

Base
Sales -15%
Int +2%
WC +30d

5. Debt Capacity Analysis • How much more debt can company take?

🧮 Calculations

Full step-by-step workings for every figure used in Analytics & Executive Summary that isn't already broken down elsewhere — Quality of Earnings, Change in Working Capital, Operating & Free Cash Flow, Cash Conversion Cycle, and Working Capital funding mix.

Calculate ratios to see step-by-step Quality of Earnings & Working Capital calculations.

Uses the same year data as Ratio Analysis — run "Calculate All Ratios" or "Update All Panels" first if this looks empty.

📋 Executive Summary & Financial Health

Board-Ready Comprehensive Analysis with Clear Decision Recommendation

🧾 Executive Summary Credit Memo

Snapshot • Trend • Credit Opinion — computed live from your entered financial data

🏢 Company Overview & Financial Snapshot

Overall Credit Score
--
System Decision
RuleThresholdActualResultLogic

🧮 Overall Credit Score — Item-wise Breakdown & Scoring Logic

ComponentActual ValueScoring Logic (Slab)Slab HitScore

📈 Key Financial Ratios Dashboard

Ratio CategoryCurrent Year2-Year AvgIndustry BenchmarkStatusTrend

💧 Cash Flow Sustainability Summary

EBITDA → OCF → FCF → Debt Service → Surplus • % of Capex & Debt Service needing external finance

Same as Maximum Term Loan Eligibility Calculator

🔀 Source & Application of Funds

Where money came from → Where it went • Auto detects diversion / WC block

🚩 Red Flags + Auto Narrative

System-detected anomalies + Bankable credit narrative (auto-generated)

Red Flags
Auto Narrative
Run analysis...

🔄 Working Capital Cycle Summary

Calculate ratios to see Working Capital Cycle summary here.

📈 Projections Summary (Next 3 Years) — Amounts in ₹ Cr unless stated

Particulars (₹ Cr)Year 4Year 5Year 6CAGR

📋 Debt Repayment Schedule (Current Year + Next 3 Years)

Run projections to generate the repayment schedule.

🏦 Maximum Term Loan Eligibility Summary

Visit the Debt Capacity tab to calculate eligibility, then refresh this summary.

📉 Stress & Break-Even Summary

Run stress test in the dedicated panel to see the summary here.

🩺 Detailed Financial Health Diagnosis

The primary, detailed narrative behind every number below — SWOT, Risk Matrix, and the Board Recommendation all build on this section rather than repeating it.

📊 SWOT Analysis

Restates the Diagnosis above as a strategic snapshot (internal strengths/weaknesses vs. external opportunities/threats) for quick scanning — the Risk Matrix below then rates and acts on it.

💪 Strengths

    ⚠️ Weaknesses

      🚀 Opportunities

        ⚠️ Threats

          ⚠️ Risk Assessment & Mitigation Matrix

          Forward-looking risk rating by category, paired with the specific action recommended to manage each risk. For the underlying facts behind each rating, see the Diagnosis and SWOT sections above.

          🎯 Risk Rating by Category

            ✅ Recommended Mitigation Actions