MS5130 Applied Analytics in Business and Society- Assignment-1

Author

Rushabh Shah - 24257228

Introduction

Block deals in India refer to large transactions of shares, typically involving a minimum quantity of 500,000 shares or a minimum value of ₹5 crore, executed through a single trade on the stock exchange. These deals are usually conducted by institutional investors, such as mutual funds, insurance companies, and foreign institutional investors, and are executed during a specific trading window.

Block deals are significant because they can influence stock prices and market sentiment. They provide liquidity to the market and allow large investors to buy or sell substantial quantities of shares without causing significant price fluctuations. The National Stock Exchange (NSE) and the Bombay Stock Exchange (BSE) are the primary platforms for block deals in India.

Use of Block Deal in Audit

Block deals play a significant role in financial auditing by providing auditors with valuable insights into large transactions and potential areas of risk. Here are some key points on the use of block deals in audit:

  • Identification of High-Risk Areas: Block deals can help auditors identify high-risk areas within financial statements. By focusing on large transactions, auditors can detect patterns, anomalies, and potential areas of concern that may require further investigation (Accounting Insights, 2024).

  • Efficiency in Auditing: Block deals allow auditors to examine large volumes of transactions efficiently. Instead of reviewing each transaction individually, auditors can focus on specific blocks or clusters of transactions, which can enhance the effectiveness and efficiency of the audit process (Accounting Insights, 2024).

  • Enhanced Accuracy: By using block deals, auditors can gain a more comprehensive understanding of the financial landscape. This approach helps in spotting inconsistencies and areas that warrant further investigation, ultimately leading to more accurate audit results (Accounting Insights, 2024).

  • Regulatory Compliance: Block deals are subject to regulatory requirements and disclosures. Auditors can use information from block deals to ensure that companies comply with relevant regulations and reporting standards (NSE India, 2025).

Use of Block Deals by Investors

Block deals are significant transactions in the stock market, typically involving large quantities of shares. These deals are primarily used by institutional investors, such as mutual funds, insurance companies, and foreign institutional investors, to buy or sell substantial quantities of shares without causing significant price fluctuations. Here are some key points on the use of block deals by investors:

  • Liquidity Management: Block deals provide liquidity to the market, allowing large investors to enter or exit positions without significantly impacting the stock price (Investopedia, 2024).

  • Price Stability: By executing large transactions through block deals, investors can avoid sudden price movements that might occur if the same transactions were conducted in the open market (Financial Express, 2022).

  • Confidentiality: Block deals offer a level of confidentiality, as the identities of the buyers and sellers are not disclosed during the transaction. This can be beneficial for investors who do not want their trading strategies to be publicly known (GetMoneyRich, 2024).

  • Market Sentiment: Block deals can serve as indicators of market sentiment. For example, a large block deal purchase by an institutional investor may signal confidence in a company’s prospects, while a large sale might indicate a lack of confidence (Financial Express, 2022).

Top 10 BUY Deals by Total Transaction Value

Load necessary libraries

library(ggplot2) library(readxl) library(dplyr)

Define the file path

file_path <- “C:/Users/Riddhi/Desktop/Rushabh_Assignment/Assignment_R/Bulk-Deals-01-01-2024-to-31-12-2024._2.xlsx”

Read the Excel file

df <- read_excel(file_path, sheet = 1)

Filter the data to include only rows where Transaction is “Buy”

df_buy <- df %>% filter(Transaction == “Buy”)

Select the top 10 BUY deals by Total Transaction Value

top_10_buy <- df_buy %>% arrange(desc(Total Transaction Value)) %>% head(10)

Create the bar graph for top 10 BUY deals

ggplot(top_10_buy, aes(x = reorder(Security Name, -Total Transaction Value), y = Total Transaction Value)) + geom_bar(stat = “identity”, fill = “green”) + labs(title = “Top 10 BUY Deals by Total Transaction Value”, x = “Security Name”, y = “Total Transaction Value (INR in Mn)”) + theme(axis.text.x = element_text(angle = 90, hjust = 1, size = 8)) # Filter the data to include only rows where Transaction is “Sell” df_sell <- df %>% filter(Transaction == “Sell”)

Select the top 10 SELL deals by Total Transaction Value

top_10_sell <- df_sell %>% arrange(desc(Total Transaction Value)) %>% head(10)

Create the bar graph for top 10 SELL deals

ggplot(top_10_sell, aes(x = reorder(Security Name, -Total Transaction Value), y = Total Transaction Value)) + geom_bar(stat = “identity”, fill = “red”) + labs(title = “Top 10 SELL Deals by Total Transaction Value”, x = “Security Name”, y = “Total Transaction Value (INR in Mn)”) + theme(axis.text.x = element_text(angle = 90, hjust = 1, size = 8))