Qts wrt CMA data preparation

This query is : Resolved

Querist : Anonymous

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?

Rahul Gupta

Rahul Gupta (Expert)
Follow

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

Message likes : 2 times

Querist : Anonymous

Querist : Anonymous (Querist)

10 July 2010 thanks very much for the elaborate explanations!!

Upgrade to CAclubindia Pro. Subscribe Now!