How to Prepare CMA data for loan

cma_img

CMA data required for bank loan or working capital loan or for seeking CC limit. But the question is that what is CMA data and How to prepare it? Why bank or financial institute required CMA data? so here is your answer

First of all let us understand what is CMA Data

CMA is short form of Credit Monitoring Arrangement data.CMA data report presented to bank to Show your past, prasent and future Financial position.

CMA covers 7 statement which are as follow

1 Existing and Proposed Funds Limit

In this statement one must show present fund and non fund based credit limit .of the borrower ,their usage limit and history. Which means you should show current financial condition, borrowed fund and proposed fund are covered. In the case , business is new, there is no past records so you need to give proposed data.

2 Operating statement:

In this Second statement one should  required to show past 2 years and future 3  to 5 years ( Proposed) operating statements. You should show Profit before and after Tax and  projection of Sales ,Expenses and profit  for 3 to 5 year as per requirement.

3 Analysis of Balance sheet

In this  third statement one should  required to show past years and future  years projection Data of Balance Sheet. In this statement you should give detailed analysis of Current Assets ,Non current Assets, Fixed Assets ,Cash and Bank Position ,Current liability ,Non Current Liability etc.

4 Comparative statements of current assets and liabilities:

In this  fourth statement you need to show comparative analysis of Current Assets and Current liability . This statement is for working Capital Cycle  for the project period  and capacity of the borrower to meet the future working capital requirement

5 Calculation of MPBF:

MPBF means maximum permissible bank finance. In this calculation you should show the capacity of the borrower to borrow the money, This Calculation is done by two method

1 In the first method lending will allowed  the MPBF 75% of net working Capital GAP

2 In the Second  method lending will allowed  the MPBF 75% of Current Assets less Current Liability

6Fund flow statements:

In this statement you required to give details of the fund flow for current and future projected period. This statement show borrower fund position with the  reference of the working capital analysis given in the MPBF. It shows the Funds Movement of the borrower.

7 Ratio analysis:

This statement is long and important statement of CMA data. It gives Key ratio to the banker and  Based on CMA data prepared  and submitted to the bank . Generally this covers GP ratio ,NP ratio ,Current Raton, DP limit Net worth ,Quick Ratio, turnover ratios,  Debt equity ratios, DSCR etc.

Views : 819

Five steps to get Success

sucess

 

Five steps to get Success

For getting success you need to raise your standards and avoid being a useless slob. The best way to get success is to force yourself to become conscious of your standards, and then to redefine them. There are many useless slob in this world so don’t be one of them. To become successful you need to raise your slandered

Check out following ways to get shiny side of your life

1 Raise your slandered

You need to write down your current standards. Always think about it and and make best try to achieve it once you achieve those slandered .Make a slightly higher standard and fee these process continued

2 Increase your confidence by taking action.

Successful people are more confident   because success is just as dependent on confidence as it is on competence. Do not feel rejected if you do not have desired result instead of it you need to keep trying and do hard work and have confidence. Ultimately you will get success

3 Increase your skill

Always try to lean new and innovative things. Always get updated. A research shows that successful people excel in both cognitive ability and social skills

4 Come out of your Comfort Zone

Remember one thing that real magic is done out of your comfortzone.Those people can’t go outside because they are scared it’s not safe ,its not rewarding etc.But continually doing uncomfortable work  is a critical component of sucess.We know that It’s hard to change your ways or live life differently but I have already said that real magic is done out of your comfort zone

5 Make challenges as opportunity

Understand that failure is not dead end but always keep hoping and trying. Remember that there is always one door open when rest of door are closed. Always try to come out with  creative solutions in you problem

 

 

 

 

Views : 452

Few Microsoft Excel Shortcut

Hi every one,

Microsoft excel is very helpful tool for any work. In today’s competitive e world you must be faster and you must know the shortcut keys to operate excel faster and successfully.

Following are Few Excel shortcut that will be helpful in your day to day life

Shortcut Details
F2 To edit and select the cell
F3 After a Name has been created, F3 will Paste the  names.
F4 To repeat last action.
F5 Go to a specific cell. For example, D7.
F7 To spell check selected text or document.
F11 To create the chart  for selected Data
Ctrl + Shift + ; To enter the current time.
Ctrl + ; To enter the current date.
Alt + Shift + F1 To insert the new worksheet
Alt + Enter To move the  next line while typing the data in the cell, allowing for multiple lines of text in one cell.
Ctrl + 1 To open the Format Cells window.
Ctrl + A To select all contents of the worksheet.
Ctrl + B Bold highlighted selection content
Ctrl + I To Italic highlighted selection Content.
Ctrl + K To insert the link
Ctrl + S To Save the open worksheet.
Ctrl + U To underline highlighted selection.
Ctrl + P To bring up the print dialog box to begin the printing process.
Ctrl + Z Undo last action.
Ctrl + F6 To switch between open workbooks or windows.
Ctrl + Page up Move between work sheets in the same document.
Ctrl + Page down Move between work sheets in the same document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = To create a formula to sum all of the above cells.
Ctrl + ‘ To insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1 To format number in comma format.
Ctrl + Shift + 4 To format number in currency format.
Ctrl + Shift + 3 To format number in date format.
Ctrl + Shift + 5 Format number in percentage format.
Ctrl + Shift + 6 Format number in scientific format.
Ctrl + Shift + 2 Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space To selece the entire column
Shift + Space To selece the entire Raw
Ctrl + – To delete the selected column or row.
Ctrl + Shift + = To insert a new column or row.
Ctrl + Home To move to cell A1.

Views : 1672