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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details