RIYA- Report - fvgh PDF

Preview

Summary

fvgh...

Description

Module Subject : Business Statistics Module leader: Mr. Mohammed Irfan Topic: Data Analysis Report

School Of Law Auro University

Submitted By: Riya Shah Course: BBA LLB Enrolment No.: 312018009 Session: 2018-2023

Address: Auro University “Earthspace”, Hazira Road, Opposite ONGC, Surat- 394510, Gujarat

1

Acknowledgement

I take this opportunity to express our profound gratitude and deep regards to this institute for exemplary guidance, monitoring and constant encouragement throughout the completion of this project topic. The blessing, help and guidance given by them time to time shall carry me a long way in the journey of life on which we are about to embark. I have taken efforts in this project. However, it would not have been possible without the kind support and help of many individuals and organizations. I would like to extend my sincere thanks to all of them. My thanks and appreciations also go to my colleague in developing the project and people who have willingly helped me out with their abilities. I am obliged to students of College for the valuable information provided by them in their respective fields. This too, is an integral part of a journal or paper being published wherein I as an author, declare that my work is original and would not attract plagiarism or copyright issues. Riya Shah BBA LLB (Sem. III)

2

CONTENTS INTRODUCTION........................................................................................................................................................... 4 HDFC BANK.............................................................................................................................................................. 4 MARUTI SUZUKI...................................................................................................................................................... 4 YES BANK................................................................................................................................................................. 4 AXIS BANK............................................................................................................................................................... 5 SBI BANK.................................................................................................................................................................. 5 INDUSTRIAL & ECONOMIC GROWTH.....................................................................................................................6 HDFC BANK.............................................................................................................................................................. 6 MARUTI SUZUKI...................................................................................................................................................... 6 SBI BANK.................................................................................................................................................................. 7 AXIS BANK............................................................................................................................................................... 7 YES BANK................................................................................................................................................................. 8 DESCRIPTIVE STATISTICS.........................................................................................................................................9 INTERPRETATION....................................................................................................................................................9 CORRELATION............................................................................................................................................................ 11 REGRESSION............................................................................................................................................................... 11 CONCLUSION............................................................................................................................................................. 14

3

INTRODUCTION HDFC BANK HDFC Bank Ltd. is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. It has a base of 104,154 permanent employees as of 30 June 2019. HDFC Bank is India’s largest private sector lender by assets. It is the largest bank in India by market capitalisation as of February 2016. HDFC Bank was incorporated in 1994, with its registered office in Mumbai, Maharashtra, India. Its first corporate office and a full service branch at Sandoz House, Worli were inaugurated by the then Union Finance Minister, Manmohan Singh. As of June 30, 2019, the Bank's distribution network was at 5,130 branches across 2,764 cities. The bank also installed 4.30 Lakhs POS terminals and issued 235.7 Lakhs debit cards and 85.4 Lakhs credit cards in FY 2017. HDFC Bank provides a number of products and services including wholesale banking, retail banking, treasury, auto loans, two wheeler loans, personal loans, loans against property, consumer durable loan, lifestyle loan and credit cards. Along with this various digital products are Payzapp and SmartBUY HDFC Bank's Parivartan initiative has spent ₹443.8 crore towards CSR in 2018-19. featured for the 6th consecutive year

HDFC Bank was

MARUTI SUZUKI Maruti Suzuki India Limited, formerly known as Maruti Udyog Limited, is an automobile manufacturer in India. It is a 56.21% owned subsidiary of the Japanese car and motorcycle manufacturer Suzuki Motor Corporation. As of July 2018, it had a market share of 53% of the Indian passenger car market. Maruti Suzuki manufactures and sells popular cars such as the Ciaz, Ertiga, Wagon R, Alto K10 and Alto 800, Swift, Celerio, Swift Dzire, Baleno and Baleno RS, Omni, baleno, Eeco, Ignis, S-Cross, Vitara Brezza and newly launched S-Presso small SUV. The company is headquartered at New Delhi. Maruti Udyog Limited was founded by the Government of India in 1981, only to merge with the Japanese automobile company Suzuki in October 1982. The first manufacturing factory of Maruti was established in Gurgaon, Haryana, in the same year. Maruti Suzuki has 1,820 sales outlets across 1,471 cities in India. The company aims to double its sales network to 4,000 outlets by 2020.[59] It has 3,145 service stations across 1,506 cities throughout India. Maruti's dealership network is larger than that of enough known companies combined. Maruti Suzuki has three manufacturing facilities in India.[21] All manufacturing facilities have a combined production capacity of 1,700,000 vehicles annually. The Brand Trust Report published by Trust Research Advisory, a brand analytics company, has ranked Maruti Suzuki in the thirty seventh position in 2013 and eleventh position in 2014 among the most trusted brands of India

YES BANK Yes Bank Limited is an Indian private sector bank, founded by Rana Kapoor and Ashok Kapur in 2004. It primarily operates as a corporate bank, with retail banking and also asset management as subsidiary functions. Yes Bank Limited derives most of its revenues through arranging syndicated loans and through corporate banking. It operates as three entities - Yes Bank, Yes Capital and Yes Asset Management Services. As per the banks website as well as information published, these are bifurcated as:

4

     

Corporate and Institutional Banking Commercial Banking Investment Banking Corporate Finance Financial Marketing Retail Banking

As on 30 June 2019, Yes Bank had 1,122 branches and 1,220 ATMs in India. es Bank has equities listed on the Bombay Stock Exchange and National Stock Exchange of India and has bonds listed on London stock exchange. Yes Bank was listed in the stock exchanges of India post its IPO in May 2005 at an issue price of Rs.45. It was awarded Bank of the Year India, The Banker London - 2015

AXIS BANK Axis Bank is the third-largest bank in India offering a wide assortment of financial products. The bank has its head office in Mumbai, Maharashtra. It has 4,050 branches, 11,801 ATMs and 4,917 cash recyclers spread across the country as of 31 March 2019 and nine international offices. The bank employs over 55,000 people and had a market capitalization of ₹ 1.31 trillion (US$19 billion) (as on 31 March 2018). It sells financial services to large and mid-size corporates, SME and retail businesses. The bank was founded in December 1993, as UTI Bank, opening its registered office in Ahmedabad and corporate office in Mumbai. UTI Bank began its operations in 1993, after the Government of India allowed new private banks to be established. The first branch was inaugurated on 2 April 1994 in Ahmedabad by Dr. Manmohan Singh, the then finance minister of India. The bank has nine international offices with branches at Singapore, Hong Kong, Dubai (at the DIFC), Shanghai, Colombo and representative offices at Dhaka, Dubai, Sharjah and Abu Dhabi, which focus on corporate lending, trade finance, syndication, investment banking and liability businesses. Axis Banks's equity shares are listed on the Bombay Stock Exchange and National Stock Exchange of India. The company's global depository receipts (GDRs) are listed on the London Stock Exchange

SBI BANK The State Bank of India (SBI) is an Indian multinational, public sector banking and financial services statutory body. It is a government corporation statutory body headquartered in Mumbai, Maharashtra. SBI is ranked as 236th in the Fortune Global 500 list of the world's biggest corporations of 2019. It is the largest bank in India with a 23% market share in assets, besides a share of one-fourth of the total loan and deposits market. The bank descends from the Bank of Calcutta, founded in 1806, via the Imperial Bank of India, making it the oldest commercial bank in the Indian subcontinent. The Bank of Madras merged into the other two "presidency banks" in British India, the Bank of Calcutta and the Bank of Bombay, to form the Imperial Bank of India, which in turn became the State Bank of India in 1955. SBI provides a range of banking products through its network of branches in India and overseas, including products aimed at non-resident Indians (NRIs). SBI has 16 regional hubs and 57 zonal offices that are located at important cities throughout India. SBI was ranked 216th in the Fortune Global 500 rankings of the world's biggest corporations for the year 2018. The equity shares of SBI are listed on the Bombay Stock Exchange, where it is a constituent of 5

the BSE SENSEX index, and the National Stock Exchange of India, where it is a constituent of the CNX Nifty.

INDUSTRIAL & ECONOMIC GROWTH Industrial and economic growth of the company is calculated by a comparative analysis of the company’s revenue from operations and net profit of the preceding years. Such analysis is made by comparative analysis inside the company as well.

HDFC BANK The profit of the company in the Year 2018-19 was 18,56,08,500. This is the net profit i.e., profit after tax, dividend and every other expense. The same for the year 2019-20 is 22,01,03,800. So now basically there was a increase in the profit of the company by 18.58% Total assets for the bank for the year 2018-19 was 11,03,18,61,700 and for the year 2019-20 was 13,28,00,73,600. So now there is increase in the assets of the firm by 20.38% 14,000,000,000

13,280,073,600

12,000,000,000 11,031,861,700 10,000,000,000 8,000,000,000 6,000,000,000 4,000,000,000 2,000,000,000

220,103,800 0 2018-19

0

0

2019-20 Profit

Column1

MARUTI SUZUKI The profit of the company in the Year 2018-19 was 7,721.80. This is the net profit i.e., profit after tax, dividend and every other expense. The same for the year 2019-20 is 7,500.60. So now basically there was a decline in the profit of the company by 2.86 % Total assets for the bank for the year 2018-19 was 59,370.10 and for the year 2019-20 was 62,931.80. So now there is increase in the assets of the firm by 5.99% 70000 60000 59370.1

62931.8

50000 40000 30000 20000 10000

7721.8

0 Year 2018-29

7500.6 0

Year 2019-20 Net profit

0

Column1

6

SBI BANK The profit of the company in the Year 2018-19 was -4,55,62,802. This is the net profit i.e., profit after tax, dividend and every other expense. The same for the year 2019-20 is 2,29,96,391. So now basically there was a decline in the profit of the company by 50% Total assets for the bank for the year 2018-19 was 36,16,43,30,029 and for the year 2019-20 was 38,88,46,70,631. So now there is increase in the assets of the firm by 7.52% 45,000,000,000 40,000,000,000

38,884,670,631

35,000,000,000 36,164,330,029 30,000,000,000 25,000,000,000 20,000,000,000 15,000,000,000 10,000,000,000 5,000,000,000 0 -45,562,802 2018-19 -5,000,000,000

22,996,391 2019-20 Profit

00

00

Column1

AXIS BANK The profit of the company in the Year 2018-19 was 45,58,112. This is the net profit i.e., profit after tax, dividend and every other expense. The same for the year 2019-20 is 5,03,85,889. So now basically there was a decline in the profit of the company by 1005.4% Total assets for the bank for the year 2018-19 was 7,03,70,33,671 and for the year 2019-20 was 8,14,04,59,676. So now there is increase in the assets of the firm by 15.68%% 9,000,000,000 8,000,000,000

8,140,459,676

7,000,000,000 7,037,033,671 6,000,000,000 5,000,000,000 4,000,000,000 3,000,000,000 2,000,000,000 1,000,000,000 0 4,558,112 2018-19

50,385,889 2019-20 Profit

0

0

Column1

7

YES BANK The profit of the company in the Year 2018-19 was 4,23,32,200. This is the net profit i.e., profit after tax, dividend and every other expense. The same for the year 2019-20 is 1,70,92,658. So now basically there was a decline in the profit of the company by 59.22% Total assets for the bank for the year 2018-19 was 3,12,44,96,536 and for the year 2019-20 was 3,80,85,96,097. So now there is increase in the assets of the firm by 21.89%. 4,000,000,000

3,808,596,097

3,500,000,000 3,000,000,000

3,124,496,536

2,500,000,000 2,000,000,000 1,500,000,000 1,000,000,000 500,000,000 0 42,332,200 2018-19

17,092,658 2109-20 Profit

0

0

Column1

DESCRIPTIVE STATISTICS 8

HDFC BANK Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness

AXIS BANK

YES BANK

SBI BANK

1106.161774

MARUTI SUZUKI 6805.910134

694.9365703

163.5539257

2038.206899 19.47571422

5.043853553 1111.640015 1064.219971

34.03548582 6875.425049 6846.2907

4.515000004 694.975006 661.599976

4.18063086 177.4000015 184.25

78.46394712

529.4679021

70.23691663

65.03535348

6156.590997 -0.917445934 0.044522191

280336.2593 -0.397606581 -0.425125205

4933.224458 -0.969953292 -0.10184456

4229.597202 -1.083139452 -0.221674081

2075.48999 0 302.9710111 91791.43358 40.53872531 -6.346926347

INTERPRETATION Mean – Simple or arithmetic average of a range of values or quantities, computed by dividing the total of all values by the number of values. Analysing the table we know that the average stock price is highest of that of Maruti Suzuki and the lowest is that of Yes bank. In comparison of all the banking companies, highest is that of SBI Bank. Median - The "median" is the "middle" value in the list of numbers. To find the median, your numbers have to be listed in numerical order from smallest to largest, so you may have to rewrite your list before you can find the median. Each company has its own middle value. The comparison of the same isn’t feasible. However on the exact same date the highest closing stock price was that of Maruti Suzuki. Mode - The "mode" is the value that occurs most often. If no number in the list is repeated, then there is no mode for the list. By looking at the table we can clearly identify which company has which stock value as the most repeating one. Standard Deviation - The standard deviation is similar to the mean deviation in that here too the deviations are measured from the mean. It is calculated as the square root of variance by determining the variation between each data point relative to the mean. If the data points are further from the mean, there is a higher deviation within the data set; thus, the more spread out the data, the higher the standard deviation. The company which has higher standard deviation is Maruti Suzuki which means the data set of this company is more spread out. Kurtosis - Kurtosis is a statistical measure that is used to describe the distribution or peakedness of frequency distribution. Distributions with large kurtosis exhibit tail data exceeding the tails of the normal distribution. Distributions with low kurtosis exhibit tail data that are generally less extreme than the tails of the normal distribution.

9

In the above table, each company represents negative kurtosis except for the SBI Bank. Skewness - A distribution is said to be 'skewed' when the mean and the median fall at different points in the distribution, and the balance (or centre of gravity) is shifted to one side or the other-to left or right. If one tail is longer than another, the distribution is skewed. A left-skewed distribution has a long left tail. Left-skewed distributions are also called negatively-skewed distributions. That’s because there is a long tail in the negative direction on the number line. The mean is also to the left of the peak. A right-skewed distribution has a long right tail. Right-skewed distributions are also called positive-skew distributions. That’s because there is a long tail in the positive direction on the number line. The mean is also to the right of the peak.

CORRELATION Correlation is a measure of association between two or more variables. When two or more variables very in sympathy so that movement in one tends to be accompanied by corresponding movements in the other variable(s), they are said to be correlated. Correlation can be classified as Positive & Negative, Linear & Non-Linear, Simple Variable & Multiple. If both the variables move in the same direction, we say that there is a positive correlation, On the other hand, if the variables are varying in opposite direction, we say that it is a case of negative correlation. 10

CORRELATION MARUTI SUZUKI

SBI BANK

-0.377918731 0.220323362

1 -0.218457536

1

0.828216102

-0.233496107

0.107068645

1

-0.502887298

0.633862098

-0.316208195

-0.109070687

HDFC BANK HDFC BANK MARUTI SUZUKI SBI BANK AXIS BANK YES BANK

AXIS BANK

YES BANK

1

1

So now basically analysing the table we can easily figure out that there exists positive correlation between HDFC & SBI, AXIS and HDFC, YES BANK & MARUTI SUZUKI, AXIS and SBI. The rests are in negative correlation with each other. Also this is the case of multiple correlation because there are 5 variables which needs to be related with each other.

REGRESSION It refers to the statistical technique of modelling the relationship between two or more variables. In general sense, regression analysis means the estimation or prediction of the unknown value of one variable from the known value(s) of the other v...