Excel for Beginners, A new Add-on for professionals by CA Learning

 

word press slider1.jpg

Microsoft Excel has been a very widely applied spreadsheet software, especially since version 5 in 1993 and due to this popularity; it replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel is a part of Microsoft Office. VisiCalc was the first electronic spreadsheet in the world, which had even helped launch the Apple II as one of the earliest personal computers in business use. With IBM’s entry into the market, VisiCalc was slow to respond as it (IBM) had acquired Lotus 1-2-3 from Lotus Software, which presently is itself a discontinued spreadsheet program. It was the IBM PC’s first killer application, which was hugely popular in the 1980s and contributed significantly to the success of the IBM PC.

 Microsoft Excel is an electronic spreadsheet, which operates on data entered in cells of a table arranged in numbered rows ranging from 1 to 10,48,576 (10,48,576 rows) & lettered columns ranging from A to XFD (16,384 columns). Cells in Excel may contain numeric or text data, or the results of formulas that automatically calculates and displays a value based on the contents of their respective cells. It is an interactive application for entry, arrangement, formatting, study and storage of data in a tabular form, the results of which may be viewed in the form Charts or Sparklines. It not just operates on computers (Windows, macOS) but also on smart phones (Android and iOS) as well; however, in this particular module on “Microsoft Excel for Beginners” we will be dealing with MS Excel (MS Office 2010) running on Windows 7 OS & above. Features of Microsoft Excel developed by Microsoft –

  • Calculation: it has an array of inbuilt functions to solve mathematical, statistical, engineering, financial problems
  • Graphing tools: it can display data entered in the cells of the workbook as Charts varying from column charts to scatter charts or even convert that data into Sparklines with their respective formatting options available
  • Pivot Tables: it allows splitting of data according to the result desired by the user
  • Macro: it allows the user to record steps to a particular problem, which he/she has to apply to similar sets of data repeatedly, by running that respective macro to either the same or any other workbook

 

Excel for Beginners has been prepared with the objective of getting an insight into the basics of Excel. Specially designed for beginners who want to – understand the concepts of Excel, how to perform tasks, shortcuts to perform those tasks, understanding the different methods and to inculcate the easiest one to become a smart and efficient professional. This module is for students who may be

  • in the 10th standard
  • a 10+2 Student
  • a 10+2+3 Student
  • a Student who wishes to utilise his/her summer/winter vacation in learning this Hands on Training (HOT) Course on Excel for Beginners
  • a Chartered Accountancy Student who wishes to brush-up his/her ITT skills in Excel
  • may be an employee even who is an expert in his respective field but wants to perform his Tasks on Excel with ease, accuracy and efficiency

Demo Videos:

As briefed above, the prerequisites of this module are MS Excel (MS Office 2010) Software installed on pre-installed Windows 7 OS & above. This has been prepared based on sequential lectures including case studies for a better overview and conceptual clarity to the student. This module begins with a very brief introduction of MS Excel & its history, the n number of uses with the diversity of users of Excel. Afterward, it makes the Student comfortable with the user interface (UI) of the Excel Spreadsheet; how it looks and what are the different tabs, graphical icons, row bars, column bars, etc. & their implications. Thereafter, case studies have been explained in detail initially with the actual method of performing that task, the different methods to perform those tasks and finally the way it is supposed to be done and all of them with the use of shortcuts. Reiteration of Shortcuts in all the case studies enables the Student to inculcate the habit of using these shortcuts with the use of the easiest method for performing the tasks with speed, accuracy, efficiency, effectiveness and ease at the end of the user. Hope you have an enjoyable journey throughout the course.

If you have any type of query related to excel then You can fill this form. Our Excel Experts will contact you soon.

Thank you for giving your valuable time to this blog

 

Chaitanya Arora

MS Office Expert

CA Learning Faculty

Advertisements

Indian, Foreign Receipt & Accrual

Sec 9 : Income Deemed To Accrue Or Arise In India

In some cases even if the income arises outside India it is deemed to accrue in India, because it can be said to have arisen outside India because of some connection with India.

The definition given u/s 9 is exhaustive, i.e. only the income mentioned below shall be deemed to accrue or arise in India. thus receipts defined u/s 9(1)(i), (ii), (iii), (iv), (v), (vi) & (vii) shall only be deemed to accrue or arise in India

Income which is ‘deemed to accrue or arise’ in India is Indian Income and shall be taxable in the hands of all assessee irrespective of the residential status, i.e. shall be taxable in the hands of a R+OR , a R+NOR and a NR

Judicial Decisions:

  1. Though Sec 9(1) deems even all income accruing or arising abroad directly or indirectly from any source, business connection in India, the liability to tax will be subject to the provisions of any double taxation avoidance agreement falling u/s 90. Similarly the definition of royalty is different as per the Act Sec 9(1)(vii) and as per different DTAA’s, in the case of DTAA being applicable then the definition under the DTAA will prevail [CIT v Davy Ashmore India Ltd [1991] (HC)]
  2. DTAA: for determination of the taxability of the foreign collaborators the provisions of Section 90 of the Act are very relevant. This empowers the Central Government to enter into Double taxation avoidance agreements with the foreign countries.. where there exist a DTAA the tax liability of the assessee is to be determined in accordance with such an agreement as the provisions of the DTAA override the provisions of the Income Tax Act on points covered in the agreement.

CBDT Circular 333 dated 02/04/1982: states that where the DTAA provides for a particular mode of computation of income the same should be followed irrespective of the provision of the Income Tax Act. Where there is no specific provision in the agreement then the Income Tax Act will govern the taxation of income.

Where however even for points mentioned in the agreement if the provisions of the income tax act are more beneficial to the assessee then he has the option to compute income tax as per the provisions of the Act

Thus the tax-ability will depend upon whether there is an applicable DTAA

If there is – then the relevant provisions of the DTAA will override the provisions of the Income Tax Act

If there is no DTAA – the the provisions given below will be applicable

  1. Income from business connection:

Sec 9(1)(i): all income accruing or arising, whether directly or indirectly, through or from any business connection in India, or through or from any property in India, or through or from any asset or source of income in India,or through the transfer of a capital asset situate in India.

PART 1 of the above definition: where by virtue of business connection[1] in India income accrues or arises outside India to any person it is deemed to accrue or arise in India.

Thus business connection involves business carried on by a Non Resident, which yields profits…outside India….. and some activity in India… which contributes to those profits.

Judicial decisions:

  • Business connection may be in many forms for example a branch office in India or an agent appointed in India. The matter in which one has a right of interference comes within the ambit of business connection. It must be a continuous activity between the business of a non resident and the activity in India. Whether there exists a business connection or not has to be determined upon facts & circumstances of each case CIT v R.D. Aggarwal & Co [1965]

    Note: Section 9(1)(i) only tells us whether income is taxable in India or not. It does not tell us how much i.e. it does not help determine the amount of income taxable in India.

    Explanation 1 to Sec 9(1)(i): Exceptions to the rule of business connection

    1. Where all operations are not carried on in India – Explanation 1(a) to Sec 9(1)(i) : Where all the operations are not carried out in India, in such a case the income deemed to accrue or arise in India will only be such income as can be said to have been earned from operations in India.

    For example: Mr John has a shop in Germany. He sends cloth to India to his agent who stitches them into shirts and sends them to Germany. Mr. John earns a profit of Rs 10 lacs in Germany. Now it can be said that some part of the profits earned by Mr John in Germany, were because of the process of stitching carried out in India. Thus proportionate profits must be brought to tax in India, in the hands of John, as per the provisions of Section 9(1)(i) explanation 1(a).

    It is only that portion of the profits which can be reasonably attributed to the operations of the business carried out in India, which is liable to Income Tax. The apportionment is to be made only in case in which the profits and gains are deemed to accrue or arise in India and not to a case in which the actually so accrue or arise or are received in India CIT v Best & Co Ltd [1966](SC)

    1. Purchase of goods for export – Explanation 1(b) to Sec 9(1)(i) : Where a NR, or an agent on his behalf, buys goods from India for the purpose of exporting them no income will have deemed to have accrued to him from conversion of materials purchased for the purpose of export. Thus the activity of purchase is not covered under the provisions of section 9(1)

    For example: Mr John has a shop in Germany. He purchases shirts from India through his agent in India. Mr. John earns a profit of Rs 10 lacs in Germany. Now it can be said that some part of the profits earned by Mr John in Germany, were because of the process of purchase carried out in India. Thus proportionate profits must be brought to tax in India, in the hands of John, as per the provisions of Section 9(1)(i) explanation1(a)., however as per explanation b to the said section the activity of ‘purchase’ is not covered, therefore no part of Mr. John’s income earned in Germany can be said to be ‘deemed to accrue or arise in India’

    Nov 2003:

    XY (P) Ltd., a company having a registered office in Singapore, for the first time has carried out operations during the PY 2015-16 of purchase of goods in India on four occasions. Immediately after purchase, the company exports the same to China. The total value of such exports is Rs 100 lacs, on which it earns profits of Rs 20 lacs before the expenses of Rs 12 lacs, which is directly paid by the head office. The company seeks your advice to its liability to tax in India . How much income for the PY 2015-16 shall be subject to tax in India?

    Form the facts of the case it is clear that XY(P) Ltd is registered in Singapore and we will deem it to be a foreign company which is a non resident of India for the purposes of the income tax Act.

    During the PY 2015-16 the company has purchased goods from India and exported them to China, thus no profit accrues or is received in India. By the plain reading of Sec 9(1) there is some activity between the profits earned by the non resident outside India and the territory of India, however since the transaction only relates to the activity of purchase there is no deemed accrual of income in India, thus no part of the profits will be assess-able in India.

    1. Collection of news and views – Explanation 1(c) to Sec 9(1)(i): where the activity of the NR is restricted to the collection of news and views from India for use for his business of running a news agency or publishing newspapers , magazines or journals abroad. Thus the activity of collecting news and views is also exempt from the provisions of Section 9(1)(i)
    2. Shooting of Cinematography film in India Explanation 1(d) to Sec 9(1)(i) : In case of
    • NR Individual not being a citizen of India
    • NR firms where none of the partners is a citizen of India or resident in India.
    • NR companies where none of the shareholders are citizens of India or resident in India.

    In case of the above no income shall be deemed to accrue or arise in India from activities limited to shooting of cinematographic film in India.

    Example: Mrs. Nair comes to India for the shooting of her film in Hyderabad. She earns Rs 2 crore from showing this film in USA and Rs 1 crore from showing this film in India.

    • Now Rs 1 crore is Indian Income as it is actually accruing in India,
    • Rs 2 crore, Now it can be said that some part of the profits earned by Mr. Nair in USA, were because of the process of ‘Shooting Cinematography film’ was carried out in India. Thus proportionate profits must be brought to tax in India, in the hands of Mr. Nair , as per the provisions of Section 9(1)(i) explanation a., however as per explanation d to the said section the activity of ‘Shooting Cinematography film’’ is not covered, therefore no part of Mr. Nair’s income earned in USA can be said to be ‘deemed to accrue or arise in India’, provided Mr. Nair is not an Indian Citizen.

    When is Business Connection established

    Practically it is for the assessee, the CA/Lawyer or the Department to determine whether there exists a business connection between two enterprises to be able to invoke the provisions of Sec 9(1)(i). This application has been subject to a lot of interpretation & debate. Finance Act 2003 inserted the following definition to help guide the determination of a business connection, but the explanation itself is open to interpretation

    Explanation 2: has been inserted in clause (i) of section 9(1) with effect from 1.4.2004.

    1. ‘Business connection’ shall include any business activity carried out through a person acting on behalf of the non-resident.

    For example – a Non resident appoints an agent in India through whom the activities are carried out by the Non resident in India, then it can be said that the Non resident has a business connection with India and any income earned outside India because of the connection in India will be deemed to accrue or arise in India. Such agent may be a separately incorporated company, firm, individual etc.

    1. He must have an authority, which is habitually exercised to conclude contracts on behalf of the non-resident. However, if his activities are limited to the purchase of goods or merchandise for the non-resident, this provision will not apply.

    For example – a Non resident has given an authority to another person to sign contracts for an on behalf of the non resident, then it can be said that the Non resident has a businesss connection with India and any income earned outside India because of the connection in India will be deemed to accrue or arise in India. However where the activity of the agent are restricted to the purchase of goods on behalf of the non resident then no part of the profits of the non resident shall be deemed to accrue or arise in India.

    • Where he has no such authority, but habitually maintains in India a stock of goods or merchandise from which he regularly delivers goods or merchandise on behalf of the non-resident, a business connection is established.

    For example – a Non resident neither appointed a person as an agent nor has given any authority to sign contracts for an on behalf of the non resident , but a person maintains stocks on behalf of the non resident as supplies the goods on directions of the Non resident, then it can be said that the Non resident has a businesss connection with India and any income earned outside India because of the connection in India will be deemed to accrue or arise in India.

    1. Business connection is also established where he habitually secures orders in India, mainly or wholly for the non-resident.

    The words wholly have not been defined in the act in terms of normal percentages it may be more than 90% [Speciality Magazines (P) Ltd in Re [2005]]

    Exception

    1. “Business connection”, however, shall not be held to be established in cases where the non-resident carries on business through a broker, general commission agent or any other agent of an independent status, if such a person is acting in the ordinary course of his business.
    2. A broker, general commission agent or any other agent shall be deemed to have an independent status where he does not work mainly or wholly for the non-resident.
    3. The new definition of the term ‘business connection’ shall also be applicable to an agent in relation to a non-resident under section 163 of the Act. Consequently, this new definition has been referred to in section 163 also.(Effective from A. Y. 2004-05)

    The new Explanation 3 provides that where a business is carried on in India through a person referred to in (ii), (iii) or (iv) mentioned above, only so much of income as is attributable to the operations carried out in India shall be deemed to accrue or arise in India.

GST BILL

Highlights of the Bill

  • The Bill amends the Constitution to introduce the goods and services tax (GST).
  • Parliament and state legislatures will have concurrent powers to make laws on GST.  Only the centre may levy an integrated GST (IGST) on the interstate supply of goods and services, and imports.
  • Alcohol for human consumption has been exempted from the purview of GST.   GST will apply to five petroleum products at a later date.
  • The GST Council will recommend rates of tax, period of levy of additional tax, principles of supply, special provisions to certain states etc.  The GST Council will consist of the Union Finance Minister, Union Minister of State for Revenue, and state Finance Ministers.
  • The Bill empowers the centre to impose an additional tax of up to 1%, on the inter-state supply of goods for two years or more. This tax will accrue to states from where the supply originates.
  • Parliament may, by law, provide compensation to states for any loss of revenue from the introduction of GST, up to a five year period.

Key Issues and Analysis

  • An ideal GST regime intends to create a harmonised system of taxation by subsuming all indirect taxes under one tax.  It seeks to address challenges with the current indirect tax regime by broadening the tax base, eliminating cascading of taxes, increasing compliance, and reducing economic distortions caused by inter-state variations in taxes.
  • The provisions of this Bill do not fully conform to an ideal GST regime.  Deferring the levy of GST on five petroleum products could lead to cascading of taxes.
  • The additional 1% tax levied on goods that are transported across states dilutes the objective of creating a harmonised national market for goods and services.  Inter-state trade of a good would be more expensive than intra-state trade, with the burden being borne by retail consumers.  Further, cascading of taxes will continue.
  • The Bill permits the centre to levy and collect GST in the course of inter-state trade and commerce.  Instead, some experts have recommended a modified bank model for inter-state transactions to ease tax compliance and administrative burden.

DIFFERENT TYPES OF COST

Cost

“As a noun – The amount of cash or cash equivalent paid or the fair value of other consideration given to acquire an asset at the time of its acquisition or construction.”


Common Cost

“Cost relating to more than one product or service.”


Committed Cost

“Cost arising from prior decisions, which cannot, in the short run, be changed. Committed cost incurrence often stems from strategic decisions concerning capacity with resulting expenditure on plant and facilities. Initial control of committed costs at the decision point is through investment appraisal techniques.”


Avoidable Cost

“Specific cost of an activity or sector of a business that would be avoided if the activity or sector did not exist.”


Conversion Cost

“Cost of converting materials into finished product, typically including direct labour, direct expense and production overhead.”


Direct Cost

“Expenditure that can be attributed to a specific cost unit, for example material that forms part of the product.”


Distribution costs

“Cost of warehousing saleable products and delivering them to customers. These costs are reported in the income of statement.”


Discretionary Cost

“Cost whose amount within a time period is determined by a decision taken by the appropriate budget holder. Marketing, research and training are generally regarded as discretionary costs. Also known as managed or policy costs.”


Fixed Cost

“Cost incurred for an accounting period, that, within certain output or turnover limits, tends to be unaffected by fluctuations in the levels of activity (output or turnover).”

Example: Rent


Joint Cost

“Cost of a process which results in more than one main product.”


Variable Cost

Cost which varies with the output is variable cost.

Example: Direct Material


Semi Variable Cost/Step up cost

This cost considers a combination of fixed cost & variable cost.


Long-term Variable Cost

“All costs are variable in the long run. Full unit costs may be surrogates for long-term variable costs if calculated in a manner which utilizes long-term cost drivers, for example activity-based costing.”


Marginal Cost

“Part of the cost of one unit of product or service that would be avoided if the unit was not produced, or that would increase if one extra unit were produced.”


Notional Cost

“Cost used in product evaluation, decision making and performance measurement to reflect the use of resources that have no actual (observable) cost. For example, notional interest for internally generated funds or notional rent for use of space.”


Opportunity Cost

“The value of the benefit sacrificed when one course of action is chosen in preference to an alternative. The opportunity cost is represented by the foregone potential benefit from the best rejected course of action.”


Prime Cost

“Total cost of direct material, direct labour and direct expenses.”


Product Cost

“Cost of a finished product built up from its cost elements.”


Production Cost

“Prime cost plus absorbed production overhead.”


KAIZEN COSTING FOR CA FINAL STUDENTS

Kaizen costing is a cost reduction approach popular in Japan and now having global implication is explained below.
It is a cost reduction process which aims continuous improvement in manufacturing process. It sets monthly cost reduction target and try to get a target profit based on monthly basis and ultimately achieves annual cost reduction. It was first applied by a Japanese car manufacturer Daihatsu where six plans were involve:
Plan 1- Production, distribution, and Sales Plan(which includes projections of contribution margins from sales).
Plan 2- Projected parts and Materials Costs.
Plan 3– Plant Rationalization Plan(projected reductions in manufacturing variable costs).
Plan 4- Personnel Plan(for direct labor work force and service department personnel).
Plan 5- Facility Investment Plan (capital budget and depreciation).
Plan 6- Fixed Expense Plan(for prototype design costs, maintenance costs, advertising and sales promotion expenses, and general and administrative expenses).
Above six steps become the target profit basis. It aims to reduce both fixed cost and variable cost on the systematic basis on the monthly mode. Prior year data becomes the basis in both type of the cost. Reduction rate adjustment is done based on the target price. It allows management to decide the future cost reduction strategy.