Credit Monitoring Analysis Report (CMA) for Bank Loan/Finance (CC or TL)

Hello CA fraternity. Greetings.

I have been working in the field of Bank Audits and Project Financing of the businesses for a quite while now. 

While working within the bank, i got to learn about requirements of the bank for Fresh DPR and CMA reporting. This format will help you all for such needs.

The format includes MPBF calculation that enables you to control the DPR.

This format could be used for the CMA reporting or Project report for Bank Finance (both for Cash credit & Term Loan). The PDF sample is attached. Excel of this document is also available with all the formulas. 

Thank you.

CA Ashish Udeep