Compares consecutive balance sheet years to map cash movements dynamically. 7. Ratio Analysis
Several online vendors now offer a as a standalone product for a nominal fee (often $5–$20 per report). They pull from nationwide databases and deliver a clean Excel file within 1–2 hours.
Comparative snapshot of assets, liabilities, and shareholders' equity .
In the evolving landscape of corporate finance and banking, Credit Monitoring Arrangement (CMA) data remains the backbone of loan appraisal for working capital facilities. As businesses scale in 2026, the need for accurate, updated, and flexible financial reporting has intensified. cma data report in excel format new
: Ensure Form V (MPBF) and Form VII (Ratios) pull directly from the Balance Sheet and Operating Statement to avoid manual entry errors .
This is the most critical calculation in the entire CMA report. Following standard banking guidelines (such as the Tandon or Nayak Committee recommendations), this formula determines the maximum amount of working capital a bank can lend to the business based on its current assets and liabilities. 6. Fund Flow Statement
Do you need assistance calculating a like DSCR or MPBF? Compares consecutive balance sheet years to map cash
: Long-term secured and unsecured loans. Net Worth : Share capital, reserves, and surplus. 4. Comparative Statement of Current Assets & Liabilities
: Use this to project realistic revenue growth over a 2-year horizon. =(Ending_Value / Beginning_Value) ^ (1 / Number_of_Years) - 1 Dynamically Reference Data Across Sheets
CMA data refers to a detailed report containing the of a business, usually spanning five years: two years of actual audited figures, one year of provisional/estimated data, and two years of projections. They pull from nationwide databases and deliver a
: Measures short-term liquidity (ideally 1.33 or higher).
: Link your Operating Statement rows dynamically ( =Gross Revenue - Total Expenses ).
To ensure consistency across tabs, apply a uniform horizontal layout from Column C onward: : Line Item Serial Number Column B : Financial Particulars Column C : Audited Year 1 (e.g., FY 2024) Column D : Audited Year 2 (e.g., FY 2025) Column E : Revised Estimates Current Year (e.g., FY 2026) Column F : Projection Year 1 (e.g., FY 2027) Column G : Projection Year 2 (e.g., FY 2028) Step 3: Embed Automated Financial Formulas
: Analyzes the movement of working capital and helps determine the operating cycle.
Apply to turn this cell green if balanced, and bright red if it fails. Step 4: Program the MPBF Calculations