CMA Data Software
What it Comprises of and Selection Criteria
Comprises of:
As an Independent CMA data Software, CMSV+: As an independent, Non-interlinked; CMA data software
Export Sheet+: Auto Conversion of Financial & CMA data, to excel sheet
Selection Criteria:You may opt only for, this
An Independent CMA data Software,
when you are of the view and opinion that your financial work
shall only be related to and restricted to
existing units only and as for their CMA renewal and normal enhancement
However, if you feel that you shall as well be working for project financing as for
- Proposed Units,
- Expansion/Diversification Plans,
- Major Working Capital Enhancement,
- Finding out a Viability for a Project,
- Different and Divergent category of Project Working,
and Various other criteria.
Important Features-Highlights-Input Criteria
CMSV+: CMA data Software (Non-interlinked and Independent Mode)
Find out, how it is a Complete and Total Solution
Find out, how it is a Complete and Total Solution
General:
If you so want, we can provide you with only CMA data software, which is an independent software, all on its own.
If you so want, we can provide you with only CMA data software, which is an independent software, all on its own.
It is having full-fledged and complete facilities, for all detailed calculation and workings of profitability and balance sheet, all on its own.
Format:
3+10 i.e. 3 years actuals and 10 years projections.
Flexibility to choose any combination of workings, as among 3+10, say 2+7, 1+5, etc
3+10 i.e. 3 years actuals and 10 years projections.
Flexibility to choose any combination of workings, as among 3+10, say 2+7, 1+5, etc
Basis:
It provides trends and pattern as evidenced in the past during last 3 years - for all
It provides trends and pattern as evidenced in the past during last 3 years - for all
- Income elements,
Cost elements,
Current assets and
Current liabilities,
Calculate Mode:
As, YES or No - separately for each
As under NO – straight way put-up the amount, as you feel it OK and proper
As, YES or No - separately for each
- Income elements,
Cost elements,
Current assets and
Current liabilities,
As under NO – straight way put-up the amount, as you feel it OK and proper
Simple and Easy to Use:
All this coupled with lot of convenience and ease of workings, being
Very importantly All in the SAME SCREEN itself with No traversing around at all.
All this coupled with lot of convenience and ease of workings, being
- 1. All calculations,
- 2. All CMA data reports and
- 3. Three pages detailed Appraisal Analysis
Very importantly All in the SAME SCREEN itself with No traversing around at all.
Design:
- Nicely designed in to 8 input screens, with depicting/showing of
important and relevant ratios thereto itself, in input screen,
in a running mode, with data entry at each field.
Profitability: Independent and Complete Workings
Profitability: Independent and Complete WorkingsAs for, all income elements and cost elements
(a) Regular Revenue elements: Revenue/Income and Expenses/Cost
(b) WIP and Finished Goods Stocks
(c) Term Borrowings: Interest and Repayments
(d) Depreciation Charges and Gross Block/Net Block
(e) Intangibles write off and carried over
(f) Tax Calculations:
(b) WIP and Finished Goods Stocks
(c) Term Borrowings: Interest and Repayments
(d) Depreciation Charges and Gross Block/Net Block
(e) Intangibles write off and carried over
(f) Tax Calculations:
(a) Regular Revenue elements: Revenue/Income and Expenses/Cost
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In-built and complete calculation, with Multiple and Varied Options,
In-built and complete calculation, with Multiple and Varied Options,
Initially, at every income element and cost element,
Get a CLUE, from trend/pattern as evidenced during last 3 years; in terms of
Get a CLUE, from trend/pattern as evidenced during last 3 years; in terms of
- (a) as, %age to Net Sales Value
- (b) as, %age to Net Sales Value of Output/Production (most considered)
- (c) as, %age to Main/Raw Material Cost
- (d) as, %age to Export Sales
- (e) as, %age of Increase/Decrease over Previous Year
- (f) as, the amount of income/expense, itself
Listing of All Revenue elements: Income/Expenses elements
- Revenue/Income
- Sales Realization,
- Other Operating Income I and II
- Miscellaneous Income I and II
- Expenses/Cost
- Main/Raw Material – Imported
- Main/Raw Material – Indigenous
- Other Material
- Packing Material
- Consumables, Stores and Spares
- Fuel Cost
- Power/Electricity Cost
- Royalty and Other Charges
- Repairs and Maintenance Expenses
- Other Manufacturing/Operating Expenses
- Administrative and General Expenses
- Selling and Distribution Expenses
As a major aspect, - in a running mode, with data entry at each field,
it would be showing the resultant
the reasonability and acceptance of profitability.
it would be showing the resultant
- GP – Amount and %age to Net Sales (2nd operating screen)
- EBIDTA – Amount and %age to Net Sales (2nd operating screen)
- PBT – Amount and %age to Net Sales (3rd operating screen)
- PAT – Amount and %age to Net Sales (3rd operating screen)
- Cash Accruals – Amount and %age to Net Sales (3rd operating screen)
the reasonability and acceptance of profitability.
(b) WIP and Finished Goods Stocks
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
Calculating of WIP and finished goods stocks, is made highly simplified and easy.
Calculating of WIP and finished goods stocks, is made highly simplified and easy.
As you get in to screen, you are made known of the
holding structure of WIP and finished good stocks
as evidenced during the past 3 years.
WIP - in terms of days and Finished Goods – in terms of month
holding structure of WIP and finished good stocks
as evidenced during the past 3 years.
WIP - in terms of days and Finished Goods – in terms of month
Taking a CLUE there from, as about the past 3 years existent holding structure,
just enter the holding period intended for WIP and finished goods
with the flexibility of adopting varying holding period for
just enter the holding period intended for WIP and finished goods
with the flexibility of adopting varying holding period for
- 1st year – Current Year Estimates
- 2nd year – Next Year Projections
- 3rd year and onwards – Following Year Projections
As you exit the screen,
you will find all the workings placed,
getting stocks of WIP and finished goods for all the years.
you will find all the workings placed,
getting stocks of WIP and finished goods for all the years.
Importantly,
workings are fully auto and in-built and value of stocks of WIP and finished goods will get adapted and adjusted, all on its own; at any point of time, as you change any of its relative component, say sales, raw material cost, other material cost, change in cost of utilities and manufacturing overheads, etc
workings are fully auto and in-built and value of stocks of WIP and finished goods will get adapted and adjusted, all on its own; at any point of time, as you change any of its relative component, say sales, raw material cost, other material cost, change in cost of utilities and manufacturing overheads, etc
(c) Term Borrowings: Interest and Repayments:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In-built and complete calculation,
In-built and complete calculation,
- As both under Existing and Proposed Category, for
- (a) Any Number of Term Loans,
- (b) Any Number of Equated Loans,
- (c) Any Number of Debentures/Bonds,
- (d) Any Number of Unsecured Loans/Deposits,
It will calculate and work-out, all on its own and provides,
- As separately for each of above 4 types of borrowings, for
- (a) Interest Charges – (P&L)
- (b) Repayment – Instalment due within next 12 months (Current Liabilities)
- (c) Repayment – As falling beyond next 12 months (Borrowings)
As under appraisal analysis;
it works out DSCR, Interest Coverage, ROCE, RONW, etc
it works out DSCR, Interest Coverage, ROCE, RONW, etc
(d) Depreciation Charges and Gross Block/Net Block:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In-built and complete calculation for depreciation,
under various depreciable categories,
as under both existing and proposed category.
In-built and complete calculation for depreciation,
under various depreciable categories,
as under both existing and proposed category.
Full-fledged depreciation workings with, selection/choice of
for each/individual item of the depreciation category/depreciable assets
- (a) Depreciation Method (SLM/WDV)
- (b) Depreciation Rate
- (c) Part Consideration
- (d) Starting WDV for IT, if differing
for each/individual item of the depreciation category/depreciable assets
It provides separate, depreciation workings, as separately for
- (a) Profitability
- (b) IT purpose
It also provides for full-fledged and complete working for
Capitalization of
Capitalization of
- (a) P&P Expenses
- (b) Contingencies
- (c) Capital WIP
It will calculate and work-out, all on its own and provides, for
- (a) Depreciation Charges (P&L)
- (b) Gross Block (Balance Sheet)
- (c) Cumulative Depreciation (Balance Sheet)
- (d) Net Block (Balance Sheet)
(e) Intangibles write off and carried over:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In-built and complete calculation for intangibles as
In-built and complete calculation for intangibles as
- (a) P&P expenses
- (b) Technical Know-how Fees/Expenses
- (c) Developmental Expenses, etc
- (a) Write-off, of each intangible assets to P&L
- (b) Balances as c/f, of each intangible assets to Balance Sheet
(f) Tax Calculations:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In General Parameters,
you are asked to specify the Constitution of this working.
In General Parameters,
you are asked to specify the Constitution of this working.
There are 2 options
- (a) Detailed tax working with consideration of
- Tax Holiday
- Losses c/f
- Deprecation adjustment, as per IT working of depreciation
- User-defined Deduction (similar to 80I)
- User-defined Deduction (similar to 80HHC)
- with the Applicable Slab and Rate, as per selected Constitution
- Default IT Slabs and Rates
could be altered by you, at any point of time and be SET AS DEFAULT
- Further, for Partnership Constitution,
you may/may not opt for the Calculation and Consideration of- Partners Remuneration and
Interest on Capital to Partners
- Partners Remuneration and
- (b) Calculate IT on PBT, at your Specified Rate and Surcharge
Balance Sheet: Current Assets and Current Liabilities
(a) Current Assets:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES;
In-built and complete calculation, with Multiple and Varied Options,
In-built and complete calculation, with Multiple and Varied Options,
As under Calculate Mode – YES; Calculating of
- Stocks/Inventory of
- Raw Material - Imported
- Raw Material - Indigenous
- Other Material
- Packing Material
- Consumables, Stores and Spares
- WIP Stocks (referred in earlier para)
- Finished Goods Stocks (referred in earlier para)
- Debtors/Receivables of
- Domestic Receivables
- Exports Receivables
- Current Expenses (prepaid, etc)
As you get in to screen, you are made known of the
Holding/periodicity structure for
All the above referred Category of Stocks and Receivables
as evidenced during the past 3 years.
Holding/periodicity structure for
All the above referred Category of Stocks and Receivables
as evidenced during the past 3 years.
Taking a CLUE there from, as about the past 3 years existent holding structure,
just enter the holding period intended for
All the above referred Category of Stocks and Receivables;
with the flexibility of adopting varying holding/periodicity structure for
just enter the holding period intended for
All the above referred Category of Stocks and Receivables;
with the flexibility of adopting varying holding/periodicity structure for
- 1st year – Current Year Estimates
- 2nd year – Next Year Projections
- 3rd year and onwards – Following Year Projections
As you exit the screen,
you will find all the workings placed,
getting it separately for each category of current assets.
you will find all the workings placed,
getting it separately for each category of current assets.
Importantly, workings are fully auto and in-built and value of stocks and receivables, will get adapted and adjusted, all on its own; at any point of time, as you change any of its relative component, say sales, raw material cost, other material cost, change in cost of utilities, manufacturing overheads, etc
Furthermore, it provides for, more than sufficient,
various other categories of current assets, as
various other categories of current assets, as
- Advance from Suppliers
- Current Expenses
- Cash and Bank Balances
- Investments in Govt. Securities
- Investments in FD
- User Defined – Misc./Other Current Assets 1
- User Defined – Misc./Other Current Assets 2
- User Defined – Misc./Other Current Assets 3
- User Defined – Misc./Other Current Assets 4
- User Defined – Misc./Other Current Assets 5
- User Defined – Misc./Other Current Assets 6
Importantly - in a running mode, with data entry at each field, it would be showing the resultant current ratio, enabling you to correct it further, as may be required.
(b) Current Liabilities
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES; Calculating of
- Sundry/Trade Creditors of
- Raw Material - Imported
- Raw Material - Indigenous
- Other Material
- Packing Material
- Consumables, Stores and Spares
- Advance from Customers
- Domestic Sales
- Exports Sales
- Current Expenses (outstanding, etc)
As you get in to screen, you are made known of the
Holding/periodicity structure for
All the above referred Category of Sundry/Trade Creditors
as evidenced during the past 3 years.
Holding/periodicity structure for
All the above referred Category of Sundry/Trade Creditors
as evidenced during the past 3 years.
Taking a CLUE there from, as about the past 3 years existent periodicity structure,
just enter the periodicity intended for
All the above referred Category of Sundry/Trade Creditors;
with the flexibility of adopting varying holding/periodicity structure for
just enter the periodicity intended for
All the above referred Category of Sundry/Trade Creditors;
with the flexibility of adopting varying holding/periodicity structure for
- 1st year – Current Year Estimates
- 2nd year – Next Year Projections
- 3rd year and onwards – Following Year Projections
As you exit the screen,
you will find all the workings placed,
getting it separately for each category of current liabilities.
you will find all the workings placed,
getting it separately for each category of current liabilities.
Importantly, workings are fully auto and in-built and value of sundry/trade creditors, will get adapted and adjusted, all on its own; at any point of time, as you change any of its relative component, say raw material cost, other material cost, change in cost of utilities, manufacturing overheads, etc
Instalment due within next 12 months, will get Auto Placed
if opted Calculate Mode – Yes; under Borrowings
if opted Calculate Mode – Yes; under Borrowings
Furthermore, it provides for, more than sufficient,
various other categories of current liabilities, as
various other categories of current liabilities, as
- Income Tax Payable
- Dividend/Drawings Payable
- Statutory Liabilities
- User Defined – Misc./Other Current Liabilities 1
- User Defined – Misc./Other Current Liabilities 2
- User Defined – Misc./Other Current Liabilities 3
- User Defined – Misc./Other Current Liabilities 4
- User Defined – Misc./Other Current Liabilities 5
- User Defined – Misc./Other Current Liabilities 6
Additionally, you will find here the following
Importantly - in a running mode, with data entry at each field, it would be showing the resultant current ratio, enabling you to correct it further, as may be required.
- Bank Borrowings – Applicant Bank
- Bank Borrowings – Other Bank
- Short Term Borrowings from others
Balance Sheet: Borrowings and Non-Current Liabilities
Borrowings and Non-Current liabilities:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES,
If opted YES, for Term Borrowing workings, then
It will calculate and work-out, all on its own and provides,
with data entry at each field, it would be showing the resultant
TOL/TNW (Non-Quasi)
TOL/TNW (Quasi)
enabling you to correct it further, as may be required.
If opted YES, for Term Borrowing workings, then
It will calculate and work-out, all on its own and provides,
- As separately for each of 4 types of borrowings,
- (a) Repayment – Instalment due within next 12 months (Current Liabilities)
- (b) Repayment – As falling beyond next 12 months (Borrowings)
- User Defined – Other Non-Current Liabilities 1
- User Defined – Other Non-Current Liabilities 2
- User Defined – Other Non-Current Liabilities 3
- User Defined – Other Non-Current Liabilities 4
- User Defined – Other Non-Current Liabilities 5
with data entry at each field, it would be showing the resultant
TOL/TNW (Non-Quasi)
TOL/TNW (Quasi)
enabling you to correct it further, as may be required.
Balance Sheet: Fixed Assets and Net Worth
(a) Fixed Assets and Other Non-Current Assets:
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – NO, straight put-up the amount, as you feel OK
As under Calculate Mode – YES,
various other categories of Non-Current assets, as
- If opted YES for Depreciation workings, then
- (a) Gross Block – Gets Auto Filled
- (b) Cumulative Depreciation – Gets Auto Filled
- (c) Net Block – Gets Auto Filled
- If opted YES for Intangible Assets workings, then
- (a) Balances as c/f, of each intangible assets – Gets Auto Filled
various other categories of Non-Current assets, as
- Fixed Assets related
- Capital WIP
- Advance for Capital Goods
- Investments related
- Deposits-Advances, etc
- Investments, etc
- Investment in Afflicates/Associates
- User-Defined Non-Current Assets, category
- Receivables > 6 months
- Other Non-Current Assets 1
- Other Non-Current Assets 2
- Other Non-Current Assets 3
(b) Net Worth and Other Surpluses:
It provides of Auto Calculation of c/f P&L account balance and
facilitates to give deduction thereto as
facilitates to give deduction thereto as
- Dividend/Drawings
- Other Deduction 1
- Other Deduction 2
Furthermore, it provides, for
with data entry at each field, it would be showing the resultant
TOL/TNW (Non-Quasi)
TOL/TNW (Quasi)
enabling you to correct it further, as may be required.
- User Defined – General Reserve 1
- User Defined – General Reserve 2
- User Defined – Cash Subsidy/Others
- User Defined – Other Misc. Surpluses
with data entry at each field, it would be showing the resultant
TOL/TNW (Non-Quasi)
TOL/TNW (Quasi)
enabling you to correct it further, as may be required.
CMA data Reports, Financial Highlights and Appraisal Reports
Output Reports
(A) All CMA data reports, in the prescribed format (3+10 year format)
(A) All CMA data reports, in the prescribed format (3+10 year format)
- Auto Generated, when linked
- Form II – Operating Statement
- Form III – Analysis of Balance Sheet
- Form IV – Comparative Statement of Current Assets and Current Liabilities
- Form Va – MPBF Method I
- Form Vb – MPBF Method II
- Form Vc – Turnover Method
- Form VI – Funds Flow Statement
- Additionally, you could also create
- Form I - Particulars of the Existing Limits from the Banking System
- Form II Part A - Information relating to production such as Quantity, Value,
- etc., for the year and estimates thereof for the next 2 years
- Besides, the above CMA data reports, you are further provided with
(B) Summarized Financial Highlights: (3+10 year format)
- (a) As for, Profit and Loss Account, with important and relevant ratios
- (b) As for, Balance Sheet, with important and relevant ratios
(C) Appraisal Reports: (3+10 year format)
- Both, as at input level and as output reports
- (a) Ratios as related to P&L
- – including Composition, Pattern and Structure of P&L
- (b) Ratios as related to Balance Sheet
- – including Leverage (non-Quasi and Quasi), DSCR, ISCR, ROCE,
RONW, Assets Turnover, Movement of Net worth, etc
- – including Leverage (non-Quasi and Quasi), DSCR, ISCR, ROCE,
- (c) Ratios as related to Balance Sheet, with important and relevant ratios
- – including Current Ratio, Holding and Periodicity Structure,
Permissible Finance, Excess Borrowings, Short Borrowings,
and certain other very much relevant working capital ratios.
- – including Current Ratio, Holding and Periodicity Structure,
- (a) Ratios as related to P&L
Presentation of Demo Video, CMSV+
(Independent and Non-Link mode) No Data Input and Linked Mode, under the next TAB – Project Finance Software
(You better opt for Full Screen view; (a) for more clarity and (b) to get view, as alike that of Actual Software)
1. Important Features-Highlights-Input Criteria
2. Presentation of Demo Video, Export Sheet+
2. Presentation of Demo Video, Export Sheet+
Important Features-Highlights-Input Criteria
No Data Input Criteria, for Add-on Packages: Fully Auto, when linked
Important:
- Data input – Not required
- Data input is just restricted only to
- Main – parent package in the series i.e. IFPRSV+
- No data input is further required or asked for any of the add-on packages
- Export Sheet+: when linked,
- No data input called for conversion to excel sheet
- Financials and CMA data, gets auto converted to excel sheet
- As for, Financial Reports and CMA data Reports
- As for, Financial Reports and CMA data Reports
- As for, Financial Reports and CMA data Reports
- As for, Financial Reports and CMA data Reports
Output Reports: Excel Converted
Financial Reports (3+10 year format)
Financial Reports (3+10 year format)
- Auto Converted to excel sheet
- ALL Financial Reports and Ratio Analysis
- ALL Supporting Reports, thereto
CMA data Reports (3+10 year format)
- Auto Converted to excel sheet
- ALL CMA data Reports
- ALL Appraisal Reports
Presentation of Demo Video, Export Sheet+
(You better opt for Full Screen view; (a) for more clarity and (b) to get view, as alike that of Actual Software)
Status of this Project
Finance Software Series
It is not a matter of saying here or taking a pride,
but it is our most gentle and utmost humble submission,
that for very sure, nowhere or from anywhere, here in India,
you will find this effective and sure solution for Project Finance, which is so simplified and easy in working for a simple/small/easy project and yet having 100% straight suitability and adaptability for a much difficult, detailed, intricate and complex project working.
but it is our most gentle and utmost humble submission,
that for very sure, nowhere or from anywhere, here in India,
you will find this effective and sure solution for Project Finance, which is so simplified and easy in working for a simple/small/easy project and yet having 100% straight suitability and adaptability for a much difficult, detailed, intricate and complex project working.
Once acquainted, you could complete your project financial workings within 10-15 minutes, for sure. for all categories and type of projects.
