: Critical calculation determining the maximum loan amount a bank can technically offer based on your working capital gap.
A CMA report is a standardized financial presentation that summarizes a company’s financial health. Unlike a simple business plan, a CMA report follows a rigid structure of seven interlinked forms mandated by the Reserve Bank of India (RBI) and widely adopted by banks like SBI, HDFC, and ICICI. ClearTaxhttps://cleartax.in Credit Monitoring Arrangement ( CMA ) - ClearTax
For term loans, banks look for a Debt Service Coverage Ratio between 1.5 and 2.0. Ensure your cash generation covers interest and principal obligations. cma data report in excel format new
: Stick to one clean font family across all sheets. Arial, Calibri, or Segoe UI at 10pt or 11pt work best.
: Ensure the first two years of your report match your audited financial statements exactly. : Critical calculation determining the maximum loan amount
Calculate projected revenue using the previous year's revenue and a growth multiplier: =B4*(1+'Inputs'!$C$2)
How many years of and future projections do you need to include? ClearTaxhttps://cleartax
This sheet mirrors the operating statement's timeline. It tracks assets (current and non-current) and liabilities (shareholder funds, long-term loans, and current liabilities). It ensures the accounting equation remains perfectly balanced across all historical and projected years.
[Master Inputs] ➔ [Operating Statement] ➔ [Balance Sheet] ➔ [MPBF / Ratios / Cash Flow] 1. Particulars of Existing & Proposed Credit Limits
: Balance sheets and P&L for the past 2 years.