banner_ad

Qts wrt CMA data preparation

This query is : Resolved 

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
10 July 2010 Pls ans these Qts. wrt CMA:

1)If no specific info is given by mgmt for a expense/income then can we use trend() or forecast() function of excel to project data for that exp./income?

2) Does the CMA format vary from bank to bank?

3)finally, does the bank give their format(forms 1 to 6) in soft copy wherein we can enter the co's data? or the applicant has to create the forms based on the hard copy given by bank?


10 July 2010 The answers to your questions are >

1. Yes definitely you can use the trend function. The projected figures are decided by you only. You can take anything, the only point is that there should be logic of everything. If trend is followed, then its ok, if trend is not followed then why not. Its not so that that if amount is increasing , then you have to put the increasing amount in next years too. If you believe it will reduce in next years, then you can put decreasing value too.

2. Generally CMA format varies from Bank to Bank. however, for financial part there are no major changes , just minor one. Also, on an overall, the difference in the formats are just cosmetic and in presentation only. Broadly all the formats requires more or less the same information.

3. For soft copy of format, i am doubted that bank can have it. In case, they have then it will be good. However, you can have the the hard copy, and the formats provided here can be modified little bit in order match them with the bank's format. I hope there are some minor changes only.

Regards

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
10 July 2010 thanks very much for the elaborate explanations!!


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro

Similar Resolved Queries


loading


Unanswered Queries



CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news



Answer Query



Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details