Saturday, 8 October 2022

EXCEL Formulas to be use in VLOOKUP to get multiple match in output

VLOOKUP

Excel VLOOKUP function to look up data in a table that  arranged vertically. Output of VLOOKUP will provide exact and approximate match as per input in formula. Lookup values to be available in the first column of the table to run the VLOOKUP.

Syntax

=VLOOKUP (lookup_value, table_array, column_index_num, [range_lookup])

Arguments 

lookup_value -  value to look from table and must be available in first column of                     table.

table_array – Selection of table.

column_index_num –No of colume which output is require.

range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

COUNTIF

Excel COUNTIF function provides count of cells that meets the given criteria. Criteria supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Syntax 

=COUNTIF (range, criteria)

Arguments 

range - The range of cells to count.

criteria - The criteria that controls which cells should be counted.

ROW

Excel ROW function will provide row number where the formula is written

Syntax 

=ROW ([reference])

Arguments 

reference - [optional] A reference to a cell or range of cells.

IFERROR

Excel IFERROR formula will provide custom output when error is generated and return standard result when no error in input value/formula.

Syntax 

=IFERROR (value, value_if_error)

Arguments 

value - The value, reference, or formula.

value_if_error – input to get when error is generated

Practice file download

Sunday, 25 September 2022

Excel text function || FIND, SEARCH, REPLACE, SUBSTITUTE

FIND

Excel FIND function will provide the position(As a number) of one text string within another text string. FIND is a case-sensitive. Reading is from left to right.

Syntex

                =FIND (find_text, within_text, [start_num])

Arguments 

                Find_text - The text to find.

                Within_text –The input text to search.

                [Start_num]- [optional] The starting position in the text to search. defaults to 1.

SEARCH                                               

Excel SEARCH function will provide the position(As a number) of one text string within another text string. SEARCH is not a case-sensitive. Reading is from left to right.

Syntex

                =SEARCH (find_text, within_text, [start_num])

Arguments 

                Find_text - The text to find.

                Within_text –The input text to search.

                [Start_num] - [optional] The starting position in the text to search. defaults to 1.

REPLACE

Excel REPLACE function will replace a part of text string with different text string. REPLACE is not a case-sensitive

Syntex

                =REPLACE (old_text, start_num, num_chars, new_text)

Arguments 

old_text – selection of text which require replacement.

start_num - The starting location in the text from where replacement require.

num_chars - The number of characters to be replace.

new_text - text to replace old_text with.

SUBSTITUTE

Excel SUBSTITUTE function will replace existing text with new text string in given text. SUBTITUTE function is a case-sensitive.

Syntex

=SUBSTITUTE (text, old_text, new_text, [instance])

Arguments 

text - The text to change.

old_text - The text to replace.

new_text - The text to replace with new text

[instance] - [optional] The instance to replace. If not supplied, all occurrence are replaced. i.e. if 1 is provided then first occurrence is replaced, remaining occurrence  will not change, if 2 is written then only second occurrence is replaced remaining occurrence will not change.

Practice file download

Monday, 19 September 2022

Excel text function || TRIM, PROPER, UPPER, LOWER, LEN, LEFT, RIGHT, MID, CONCATENATE

TRIM

Excel TRIM function will remove all unnecessary space in given text. TRIM function can only  remove regular space(ASCII CODE 32).

    Syntex

    =TRIM(text)

    Arguments 

    Text – word, sentence, paragraph etc

For more details on TRIM function

PROPER

Excel PROPER function will covert first character of given word to capital letter and remaining to small letter and if sentence like structure is given then it will convert all words first character capital and remaining to small.

    Syntex

    =PROPER(text)                                                          

    Arguments 

    Text – word, sentence, paragraph etc

UPPER

Excel UPPER function will convert given text to capital letters.

    Syntax 

    =UPPER(text)

    Arguments 

    Text – word, sentence, paragraph etc

LOWER

Excel LOWER function will convert given text to small letters.

    Syntax 

    =LOWER(text)

    Arguments 

    Text – word, sentence, paragraph etc

LEN

Excel LEN function will provide you a number of character in given text including space.

    Syntax 

    =LEN(text)

    Arguments 

    Text – word, sentence, paragraph etc

LEFT

Excel LEFT function will provide the character from left side of given text. And if the second optional argument is not justified then function give you a left first character from given text.

    Syntax 

    =LEFT(text,[num_chars])

    Arguments 

    Text – word, sentence, paragraph etc

    Optional argument[num_chars] – number of character need to specify how much                character we need in output from left side

RIGHT

Excel RIGHT function will provide the character from right side of given text. And if the second optional argument is not justified then function give you a right single character from given text.

    Syntax 

    =RIGHT(text,[num_chars])

    Arguments 

    Text – word, sentence, paragraph etc.

    Optional argument[num_chars] – number of character need to specify how much                   character we need in output from right side

MID

Excel MID function will provide middle characters from given text.

     Syntax 

    =MID(text,start_num,num_chars)

    Arguments 

    Text – word, sentence, paragraph etc

    Start_num – location of character in number of which we need as a first letter of our             final text.

    Num_chars – Number of character up to which we need text.

CONCATENATE

Excel CONCATENATE is use to join text from two different cells

    Syntax 

    =CONCATENATE(text1,[text2],[text3]...)

    Arguments 

    Text1 – word, sentence, paragraph etc.

    [text2],[text3]...- word, sentence, paragraph etc.

Practice file download



Saturday, 10 September 2022

Statistical functions How to use COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS in excel

COUNT

Excel COUNT function provides count of values that are numbers. Numbers include negative, positive, times, dates, fractions, percentages, and formulas that return numbers. 

    Syntex

    =COUNT (value1, [value2], ...)

    Arguments 

    value1 - An item, cell reference, or range.

    value2 - [optional] An item, cell reference, or range.

 

COUNTA

Excel COUNTA function provides count cells that contain number, text, formula, errors and non-empty cells. COUNTS does not count blank cells.   

    Syntex

    =COUNTA (value1, [value2], ...)                         

    Arguments 

    value1 - An item, cell reference, or range.

    value2 - [optional] An item, cell reference, or range.

 

COUNTBLANK

Excel COUNTBLANK function provides count of cell that is blank

    Syntax 

    =COUNTBLANK (range)

    Arguments 

    range– Selection of input

 

COUNTIF

COUNTIF function provides count of cells that meets the given criteria. Criteria supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

    Syntax 

    =COUNTIF (range, criteria)

    Arguments 

    range - The range of cells to count.

    criteria - The criteria that controls which cells should be counted.

 

COUNTIFS

COUNTIFS function provide count of cells that meets the one or more criteria.

    Syntax 

    =COUNTIFS (range1, criteria1, [range2], [criteria2], ...)

    Arguments 

    range1 - The first range

    criteria1 - The criteria to use on range1.

    range2 - [optional] The second range.

    criteria2 - [optional] The criteria to use on range2.

COUNTIFS will provide only those counts of cells that met the all criteria in given range.

 Practice file download 

Wednesday, 31 August 2022

How to remove unwanted space in excel || TRIM function

Excel TRIM function is use to remove un-necessary space or “NORMALIZE” all spacing from the given text. This TRIM function has only one argument is TEXT.

Syntex.

=TRIM(text)

TRIM function keep only keep single space between two words/letters and remove all leading and trailing spaces.

Limitation of TRIM function

·         TRIM only removes the space with ASCII code character (32) from text.

·         Many time texts may contain with non-breaking space which have ASCII code character (160) that may appear from web page and other document, those non-breaking space cannot remove by TRIM function.

To remove those type of non-breaking space we need to use SUBSTITUTE function with CHAR function in excel  to remove those un-necessary space.

 How??

First it needs to replace by all non-breaking space to regular space in given text by using SUBSTITUTE and CHAR function

Syntax of SUBSTITUTE function

=SUBSTITUTE(text,old_text,new_text,[instance_num])

                text = text which need to TRIM

                old_text = CHAR(160)

                new_text = CHAR(32)

                Optional argument [instance_num] ,which need not to specify

Where CHAR function will represent character ASCII code 160(non-breaking space) and character ASCII code 32(regular space) in the selected text.

In output of SUBSTITUE function, replacement of all non-breaking space to regular space.

last we can use TRIM formula as mention below to get the final text without un-necessary space.

=TRIM(SUBSTITUTE(text,old_text,new_text))

Practice file download

Wednesday, 24 August 2022

How to use RATE formula in excel

RATE formula used to get the rate of interest use to calculate the EMI amount from the 

main input i.e. Loan amount, EMI amount and Number of payments.

    Syntex

    =RATE (nper, pmt, pv, [fv], [type], [guess])


There were total six arguments in RATE formula, out ot which 3 were main arguements and 3 is optional arguments

Main Argument,
    nper - No of payments
    pmt  - Payments amount/EMI
    pv     - Present value/loan amount

Optional arguments,
    fv- Future value; by default it will be 0
    type - 0 or 1, 0 means for payment at the end of period and 1 means payment at the start of period; by default it will be 0
    guess - default to 10% 

Final answer of RATE formula is in %.

   Practice file download 

Sunday, 18 February 2018

Let know bank balance by missed call...

All banks started this. Know your bank account balance by giving a missed call to below numbers…from your registered mobile number. Don’t waste your ATM transactions just to see your balance…

1. Axis Bank – 09225892258
2. Andhra Bank – 09223011300
3. Allahabad Bank – 09224150150
4. Bank of Baroda – 09223011311
5. Bhartiya Mahila Bank – 09212438888
6. Dhanlaxmi Bank – 08067747700
7. IDBI Bank – 09212993399
8. Kotak Mahindra Bank – 18002740110 
9. Syndicate Bank – 09664552255
10. Punjab National Bank -18001802222
11. ICICI Bank – 02230256767
12. HDFC Bank – 18002703333
13. Bank of India – 02233598548
14. Canara Bank – 09289292892
15. Central Bank of India – 09222250000
16. Karnataka Bank – 18004251445
17. Indian Bank – 09289592895
18. State Bank of India – Get the balance via IVR 1800112211 and 18004253800
19. Union Bank of India – 09223009292
20. UCO Bank – 09278792787
21. Vijaya Bank – 18002665555
22. Yes Bank – 09840909000
23. South Indian Bank- 0922300848
24.Bank of Maharashtra- 9222281818
25. Karur Vysya Bank - 09266292666

Friday, 9 February 2018

Useful alopathic medicines

Doctor  પણ રજા પર હોય, દવાખાના બંધ હોય, તો હેરાન થવું પડે છે .મેડિકલ સ્ટોર પણ નજીકમાં ના હોય, તો આ સમસ્યાના નિરાકરણ માટે આપણી સાથે આવશ્યક અમુક દવા જો લઇ જઈએ કે રાખીએ, તો આપણે હેરાન થવું ના પડે અને તાત્કાલીક રાહત પણ મળી રહે. આ ઉદેશ્યથી અમુક પ્રાથમિક એલોપથી દવાનું આપને માર્ગદર્શન આપું છુ. તો અમુક સામાન્ય રોગ અને એની દવાની માહિતી હું આ પોસ્ટમાં આપું છું.

◆શરદી થઈ હોય તો:
Tab. Wicoryl -(10)
OR.
Tab. Diomanic DCA -(10)
(બપોરે-1,રાત્રે-1 ,જમી ને)

◆તાવ આવે તો:
Tab. Nise tablet -(10)
OR.
Tab.calpol 500 -(10)
(બપોરે-1,રાત્રે-1 ,જમી ને)

◆ઉલ્ટી થતી હોય તો:
Tab. Ondem 4mg -(5)
(જરૂર મુજબ લેવી)

◆પેટનો દુ:ખાવો થાય તો:
Tab. Meftal spas -(5)
OR.
Tab.cyclopam-(5)
(જરૂર મુજબ લેવી)
◆ગેસ માટે:
Cap. Omez-D-(10)
(1-સવારે, 1-સાંજે, ભૂખ્યા પેટે.)

◆એસિડિટી થઈ હોય તો : 
Cap. CYRA-D -(10)
(1-સવારે, 1-સાંજે, ભૂખ્યા પેટે.)

◆હાથ, પગ, દાંત, માથાના દુખાવામાં રાહત માટે :
Tab. Acenac-P -(10)
OR.
Tab.Hifenac-p -(10)
(બપોરે-1,રાત્રે-1 ,જમી ને)
નોંધઃ આ દવા જોડે એસિડિટીની દવા લેવી જેથી કરી એસિડિટીનો નાશ થાય.

◆સ્નાયુનો દુખાવો:
Tab.Hifenac-MR -(10)
(બપોરે-1,રાત્રે-1 ,જમી ને)
નોંધઃ આ દવા જોડે એસિડિટીની દવા લેવી જેથી કરી એસિડિટીનો નાશ થાય.

◆પગના દુખાવા માટે  લગાવવા ની ટ્યુબ:
Gel volini -(1)

◆એલર્જી , ખંજવાળ:
Tab. L-Dio 1 -(10)
OR.
Tab.Lazine-(10)
(રાત્રે-1, જામી ને)

◆શ્વાસ માટે:
Tab. Derephylin -(5)
(જરૂર મુજબ લેવી)

◆ચક્કર માટે:
Tab. Stemetil 5mg -(5)
(જરૂર મુજબ લેવી)

◆ગભરામણ થતી હોય તો:
Tab. Sorbitol 5mg -(5)
(જરૂર મુજબ લેવી)

◆નાશ લેવાના પોપટા:
Cap. Carvol plus -(5)
OR.
Cap.Airway-(5)
(સૂંઘવા માટે)
👆નોંધઃ આ દવા પીવા માટે નથી. શરદીમાં નાક બંધ થઈ ગયું હોય, તો રૂમાલમાં નાખી સૂંઘવા માટે છે.

◆સામાન્ય ઝાડા મટાડવા:
Tab. Lopox -(10)
(જરૂર મુજબ લેવી)

◆પાણી જેવા ઝાડા /મરડો મટાડવા માટે :
(Gestric  infection)
Tab. O2 -(10)
OR. 
Tab. Ornof -(10)
(બપોરે-1,રાત્રે-1 ,જમી ને)

◆કાકડા, ગાળાનું ઈન્ફેકશન
(Antibiotic)
Tab. Zathrin 250 -(6)
OR.
Tab.Azee 500 -(3)
(1-સવારે, 1-સાંજે, ભૂખ્યા પેટે.)

◆ મોઢું આવી ગયું હોય તો :
(Mouth ulcer)
Tab. Folib plus -(10)
OR.
Tab.cobadex CZS -(10)
OR.
Tab.Fourtus B-(10)
(બપોરે 1 જમીને)

◆વાગ્યા પર લગાવવાની ટયુબ:
Cream Betadin -(1)

◆મુસાફરીમાં ઉલ્ટીની તકલીફ માટે:
Tab. Avomin -(10)
[ઘણા લોકોને બસની અથવા મુસાફરીની એલર્જી હોય છે. આવા વ્યક્તિને ચક્કર આવે અને પછી ઉલ્ટી થાય. એવું ના થાય એના માટે આ દવા પી ને પછી જ બસમાં બેસવું.】

ખાસ નોંધ: ઉપરોક્ત દવા દર્શાવેલ ડોઝ પ્રમાણે જ લેવી. કોઈ એક રોગ માટે જે દવા લખેલી છે, તે દવાના નીચે  ઓપ્શનના બ્રાન્ડ  નેમ આપ્યા છે. કોઈ એક જ બ્રાન્ડ લેવી.
આ દવા 18 થી 60 ની ઉંમર ની વ્યક્તિ માટે છે. આ દવા કાયમી ના લેવી. કામચલાઉ ઉપયોગ માટે જ છે. આપ કોઈ ભયંકર બીમારીથી પીડાતા હોવ, તો આ દવા તમારા ફેમિલી ડૉક્ટરને પૂછીને લેવી.
             આ ઉપરાંત ફર્સ્ટ એઇડ બોક્સ જોડે રાખી શકાય, જેમાં થોડું  રૂ,  Betadin cream, જાળી વાળી પટ્ટી, ડેટોલ, બેન્ડ એઈડ, વગેરે રાખી શકાય.

Friday, 4 August 2017

Fundamental of Equity

Earnings per Share (EPS)
This ration indicates the profits available to equity share holders per share, this helps to determine the market price of equity share
Earnings per share= Profit after Tax/No. of equity share.

Dividend per share(DPS)
The amounts of profits distributed to share holders per share is known as DPS and may be calculates as follows:
Dividend per share= Amount declared as dividend/No. of equity shares

Dividend payout ratio (DP Ratio)
The DP ratio is ratio betweens the DPS and EPS of the firm i.e. it refers to the proportion of the EPS which has been distributed by the company as dividends. Dividend payout ration may be calculates as follows:
Dividend payout ratio=Dividend per share/ Earnings per share*100

Price to Earnings Ratio(PE Ratio)
The PE Ratio indicates the expectation of the equity investors about of the firm. The PE ratio is one of the most widely used measures of financial analysis in practice and calculated as follows,
Price to earning ratio= Market price of share/Earning per share.

Return on Equity(RoE)
The RoE Examines profitability from the prospective of the equity investors by relating profits available for the equity share holders with the book value of the equity investment.
Return on equity= Profit after Tax/Net Worth*100

Yield
The Yield is defined as the rate of return on the amount invested. With the reference to equity shares, the yield may be defined as the rate of return on the market piece of equity shares.
Earning yield ration=Earnings per share/Market price per share
Dividend yield ration=Dividend per share/Market price per share

Price to Book value ratio
The book value of share provide a floor below which the market price of share is not expected  to fail. Shares which have lower PB Ratio may be considered as a ‘Safer” investment and vice versa.
Price to Book Ratio= Market price per share/Book value per share

Intrinsic value
The actual value of a company or an asset based on an underlying perception of its true value including all aspects of business in terms of both tangible and intangible factors. The value may or may not be same as the current market value. The true economic worth of the share is its intrinsic value. The fundamental analyst finds out intrinsic value of a share by using formula:
Intrinsic value= Earnings per share * Price to Earnings ratio.




Saturday, 29 July 2017

Personal interview preparation

Interview are one of the most popularly use device for employee selection. Interviews vary in the extent to which the question are structured, from a totally unstructured and free-wheeling conversation, to a structured interview in which an applicant is asked a predetermined list of question in a specified order.

TIPS FOR INTERVIEW

DO’S in interview
  • Do the research about the company and the profile in question
  • Dress professionally
  • Show enthusiasm with body language
  • Listening attentively and responding carefully will ease you at PI
  • Don’t sound self-centered/overconfident
  • Your tone must balanced
  • Ask yourself “what is the question really asking”
  • Keep informative and short answers
  • Give positive answers
  • Negative conversations don’t give a good impression to the interviewer.

Don’t in interview
  • Being late for the interview
  • Eat, drink, smoke or chew gum even if the interviewer does so
  • Fiddle with your keys, hair, tie, watch, pen or any other item
  • Keep your hands in your pockets or fold your arms across your chest
  • Bringing up the issue of salary and benefit
  • Not looking at interviewer
  • Criticizing your campus or previous employer

Preparation for most commonly asked question:

Kindly introduce yourself or tell us something about yourself or can you run as through your profile

What is your greatest strength?
With this question, the interviewer seeks to find out if;
  • Your strength align with the company’s needs (Functional qualities)
  • You can do the job and perform like a rock star (Functional qualities)
  • You have qualities skills, and/or experience that set you apart from the competition
  • You are someone who will make an excellent addition to the team(attitudinal qualities/Team work)

To find your strength
  • Brainstorm: Sit down and make a list of your top strengths – aim for at least 10 and be creative. Banish your modest internal editor to another room. Jot down everything that comes to mind.  You can delete later if you like. This can include talents,  Experience, Soft skills, Education/Training etc. Probable strength can be being analytic, team player, good at Java programming etc. Avoid clinched strength like hardworking and sincere.
  • Focus: Narrow your list down to least five strength that you are comfortable discussing (or could get comfortable discussing with a little bit of practice). The more, the better. You may not talk about all of these strengths in every interview, but it’s good to have options.
  • Prepare Examples: Develop at least one example to illustrate each of your strengths


What is your greatest weakness?
What your interviewer is really trying to do with this question-beyond identifying any major red flags- is to gauge your self-awareness and honesty.

Commonly made mistakes while answering this question are
1.  Trying to turn a negative into a positive.
You will find many people who advise you to “turn a negative into a positive”  by sharing a supposed weakness that is actually quality in an employee. A few examples: I am too much of a perfectionist, I work too hard sometimes, I care too much about my work.
Clear idea. At this point, though, it’s an old trick and the interviewer sees right through it. In fact, this approach will likely made her think you are hiding something.

2.  Not answering the question
Many candidate say that they can’t think of any weakness of theirs, this reflects lack of introspection or raises a suspicion that you are hiding something.

3.  Reveal a weakness that makes you a wrong candidate for the profile
Weakness like “I am not a team player”, I have issues with authority”,”I struggle to make it on time” are a clear NO.

To answer this question,

1.  Be honest:  Don’s say anything just because your friend said this once and got away with that. That should genuinely be an aspect of your quality which you are (or want to) to work upon.

2.  Pick an acceptable weakness:- Not being a perfectionist can work for a sales job, but for an advertisement profile.  Hating math can work for an HR profile but not an accountant. Hence it is important to understand profile before answering this question

3.  Show that you are working on it and share results if any.

Where do you see yourself in five years?

If asked this question, be honest and specific about your future goals, but consider this: A hiring manager wants to know
  • If you’ve set realistic expectation for your career. Many candidates have mentioned their goal to be CEO in five years. This will certainly kill all your chances to qualify the interview
  • If you have an ambition (i.e. this interview isn’t the first time you are considering the question)
  • If the profile aligns with your goals and growth. Your best is to think realistically about where this position could take you and answer along those lines.
  • If you will stick with your company for at least 2 years. So if you have ambitions which have nothing to with this company or this sector, this will likely go against you. Also if you have any entrepreneurial ambition, interview might not be the right time to express it.

What are your hobbies/interest/passion?

Question like these could from a number of concern the employer might have such as your overall health and energy level, your mentality, or how you might engage and entertain clients and coworkers.

Avoid
Avoid hobbies which do not portray good picture of you like surfing internet, partying, sleeping, while computer gaming can make you suitable for certain kind of profile, it is not suitable for most of jobs. Any kind of illegal activity is to be avoided at all costs

The best way to respond
Do make sure that your answers are genuine e.g. don’t drag about fitness regime if you are not in great shape. But focus on answers that demonstrate a positive quality of yours
  • Exercise and health related activities: it’s true that exercise and fitness related hobbies can demonstrate health, energy, vitality, and the ability to manage stress. Older candidate should make some points of this sort if possible. Sports like golf, tennis can be useful ways to interact with clients and build relationships.
  • Volunteering and community participation: you might mention your volunteer work or community activity like coaching child etc. volunteer work shows high character and a concern for someone other than yourself.
  • Professional development and continuing education: Professional development activities are another potentially rich area of sharing how you use your spare time. Maybe you take classed or seminars, read journals, or complete online tutorial that enhance skills related to your job.
  • Reading: Be sure you know your genre well and aware of the latest publications in the same even if you have not read them all.

Why  should we hire you?

This interview question seems forward , but if you are asked it, you are in luck: there is no better setup for you to sell yourself and your skill to the hiring manager. Your job here  is to craft an answer that covers there things: that you can not only do the work, you can deliver great result; that you will really fit in with the team and culture; and that you had be better hire than any of the other candidates.

Why do you want this job?
Again companies want to hire people who are passionate about the job, so you should have a great answer why you want the position. First identify a couple of key factors that make the role great fit for you(e.g., “I love customer support because I love the constant human interaction and the satisfaction that comes from the helping someone solve a problem”), then share why you love the company.
It’s important to know well about the company and the profile so that you answer this question with concrete facts.

Tell me about a challenge or conflict you have faced at work and how you deal with it.
In asking this interview question, your interviewer wants to get the sense of how you will respond to conflict, anyone can seem nice and pleasant in a job interview, but what will happen if you are hired and soon develop profession conflicts with other departments/team members.
Again, you will want to use the S-T-A-R method , being sure to focus on how you handle the situation professionally and productively, and ideally closing with a happy ending, like how you come to a resolution or compromise.


Saturday, 15 July 2017

Goods and Service tax

Good and service tax is a single tax on goods and service. It has subsumed central indirect taxes like excise duty, countervailing duty and service tax and indirect taxes like Value Added Tax, octroi and entry tax, purchase tax and entertainment tax. Introduction of GST will not affect direct tax system,

Commodities outside GST
The government of india will continue to charge excise duty on all petroleum & natural gas products, tobacco and opium products. GST on above product will applicable on later stage, which will be decided by GST council.
Only alcohol has been kept out of purview of GST. Thus, existing central and state taxes will continue to apply  on alcohol.

GST Rate
GST rate has not been capped. It has been decided by the GST council and will be reviewed by the council from time to time.

Compensation to states
Parliament has agreed to compensate states for any loss of revenues, on account of change in taxation system to GST, for a period of five years. A shift to new taxation system initially reduces the tax compliance among people and thus, in initial years the revenue of state governments may reduce. However, in the long run, GST will lead to increase in revenue of state governments.

Benefits of Introducing GST
  1. As GST is a uniform taxation system applicable throughout the country, GST will create uniform market across the country and make taxation transparent and hassle-free.
  2. GST has subsumed many taxes and thus, GST has made taxation system simple and reduced the cost of complying the taxation system.
  3. The earlier system of numerous tax departments hampered inter-department coordination and made tax evasion possible. GST will drastically increase the tax base and reduce tax evasion.
  4. After introduction of GST, Most of the goods will cheaper, the rate of tax under GST is less as compared to the tax rates existing earlier. In fact, the GST rate for essential commodities is 0%.
  5. The reduction in tax burden will reduce the price of goods, lower the production cost and improve exports. Thus, in the long run, implementation of GST will create a large number of jobs.
  6. Service are presently taxed at 15%. The GST rate for most of the service is around 18%. Thus, service are expected are to be costlier.
  7. Bigger beneficiary of GST is going to logistics industry since truck used to spend days altogether at the state tax barriers. These barriers will not become redundant and it will make movement of good at lease 60% quicker and a lot cheaper
  8. Because of all these reasons , GST in expected to add 2% to india’s GDP growth rate

Rate of GST
The Goods and Service Tax has goods and service categorized under the following slab rates

NO TAX
Goods 
No tax will be imposed on items like fresh meat, fish, chicken, eggs, butter milk. Cued, natural honey, fresh fruits and vegetables, flour, besan, bread, Prasad, salt, bindi, sindoor, stamps, judicial papers, printed books, newspapers, bangles, handloom etc.
Services
Hotels and lodges with tariff below Rs 1000. Grandfathering service has been exempted under GST.

5%
Goods
Items such as fish fillet cream, skimmed milk powder, branded paneer, frozen vegetables, coffee, tea, spices, pizza bread, rusk, sabudana, kerosene, coal, medicines, stent, lifeboat will attract tax of 5%.
Services
Transport service(Railways, air transport), small restaurant will be under the 5% category because their main input is petroleum products, which is outside GST ambit.

12%
Goods
Frozen meat products, butter, cheese, ghee, dry fruits in packaged form, animal fat, sausage, fruit juices, namkeen, ayurvedic medicines, tooth powder, agarbatti, colouring books, picture books, umbrella, sewing machine, cellphones will be under 12% tax slab.
Services
Non-AC hotels, business class air ticket, fertilizers, work contracts will fall under 12 percent GST tax slab.

18%
Goods
Most items are under this tax slab which include flavoured refined sugar, pasta, cornflakes, pastries and cakes. Preserved vegetables, jams, sauces, soups, ice cream. Instant food mixes, mineral water, tissues, envelopes, note books, steel products, printed  circuits, camera, speakers and monitors.
Services
AC hotels that serve liquor, telecom service, IT services, branded garments and financial service.

28%
Goods
Chewing gum, molasses, chocolate not containing cocoa, pan masala, aerated water, paint. Deodorants, shaving creams, after shave, hair shampoo. dye, sunscreen wallpaper ceramic tiles, water heater, dish heater, weighing machine, ATM, vending machine, vacuum cleaner, shavers, hair clippers, automobiles, motorcycles, aircraft for personal use, will attract 28% tax- the highest under GST system
Services
5-star hotels, race club betting, cinema will attract tax 28 percent tax slab under GST

3%
Goods
Gold, silver and diamonds are placed in the category of 3% while rough diamonds would attract a nominal rate of 0.25%

Criticism of GST
A good GST was expected to yield major economic benefits, adding  2 percentage points to the growth rate. Unfortunately, what is on the table will not deliver that result thought it will be an improvement on the present system

It does achieve the objective of creating an indirect-tax system in which both the central and the state tax on any single commodity will be levied on the same base, and at the same rate throughout the country, while observing the value-added tax(VAT) principle of full set-off for earlier-stage taxes and zero-rating for exports. Other taxes like the central sales tax, octroi, entry tax etc., will be abolished from a taxation perspective this created a single national market for each commodity.

The GST will also address the complaint of domestic producers that they are at a disadvantage compared to imports, because the latter escape the burden of state taxes, although they do pay an additional duty equal to the central value-added tax(Cenvat). Once the GST is in place, import will be subject to GST at the rate as domestic products, thus ensuring a truly level-playing filed for domestic producers competing against imports.

Unfortunately, the GST being proposed departs from the experts view that an ideal GST should have a few exempted commodities and a single rate for all commodities. Lest such an ideal dismissed as academic, let us consider what countries actually do. According to the international monetary fund(IMF). 152 countries have now adopted the VAT, and of those , 69 have a single rate, with some exemption.  Admittedly, this means as many as 83 countries have multiple rates, but they don’t have anywhere near the number of rater we are considering.

Does this matter? The answer is a definite yes. The merit of a single rate is that evasion can only occur through “Under declaration”  of sales, which is more easily tracked, especially as we move towards electronic payments system. Multiple rates create incentives for deliberately mis-declaring items so they fall in a lower-rate slab. Inevitably, this creates scope for tax disputes and harassment/corruption. The proposal approved by the GST council will multiply the possibility.

Three exclusion from the GST are indefensible. These are electricity, real estate and petroleum products. It has been agreed that petroleum could into the GST list at the end of five years. A similar agreement is necessary for electricity and real estate. Extending the GST to real estate would encourage investment since real-estate development is an important part of fixed capital information. At present, taxes paid construction inputs, including steel, cement, paint, doors, and windows etc. cannot be credited against the GST to be paid on output from the factories/offices generating taxable goods and services. Bringing real estate under GST  would help these activities. It will help to discourage the use of black money in real-estate transactions.

Apart from this, the complex nature of compliance structure actually makes tax compliance more difficult then before.
The incremental burden of compliance shall vary for different classes of business. The service sector would be worst his as the benevolence of centralized would be taken away. Taxpayer would be required to get registered in every state from where he provides service. The number of fillings would increase from 2 to minimum 37 in a year for each registration, considering GSTR-1, GSTR-2 and GSTR-3 are treated as 3 returns. In case input service distributor and  Tax Deducted at source registration are obtained in a state. The number could go up by another 24 filings a year for each registration.
The service sector erstwhile was exposed only to the central authorities would now have to face the state authorities as well, leading to increased compliance costs.

Large manufacturers are already filling monthly Excise, Value Added Tax and Central Sales Tax returns and hence the pinch of increased compliance would felt to lesser extent. The factory level Excise and VAT registration within a state can now be consolidated into a single state-wide registration.

The micro and small sector, enjoying Excise duty exemption up to 1.5 crore, shall be heavily impacted as the registration threshold has been brought down to 10 lack as per Model GST Act. A composition scheme has been proposed for taxpayers having turnover up to 50 lacs, which provides for quarterly filling of returns. Such composition Taxpayer shall not eligible for input tax credit and would not be able to issue tax invoice. According to us, not many tax payers would wish to remain outside the credit chain. Apart from composition Taxpayers, quarterly filing relaxation has not been extended to other businesses and hence majority businesses shall have comparatively more fillings.


One area of concern is the online matching of input tax credit and reversal of credit or demand in case of mismatch. This process may turn out to be  the most irksome part of compliance. Keeping track of mismatches, tallying the same with books of accounts, accounting treatment of the same and dealing with non-compliant vendors may require a team in self. Problems similar to TDS returns filing in income tax may be expected during initial years, with monthly matching details and GST compliance rating being made available, compliant taxpayer would surely be preferred as business partners.