Black Book Summer Internship
Black Book Summer Internship
SPECIALISATION
FINANCIAL MANAGEMENT
1
DECLARATION
I, Miss. Dhwani Rameshbhai Prajapati hereby declare that the work embodied
in this project work titled
Wherever reference has been made to previous work of others, it has been clearly
indicated as
I, here by further declare that all information of this document has been obtained
and presented in accordance with academic rules and ethical conduct.
Signature
Certified By.
2
CERTIFICATE FROM THE COMPANY
3
CERTIFICATE FROM THE INSTITUTE
Signature:
Date:
Signature:
Date:
4
ACKNOWLEDGEMENT
To complete any project, the help is required from many individuals and an
organization.
I would like to acknowledge the following as being idealistic channels and fresh
dimensions inthe completion of this project.
I take this opportunity to thank Amrit Traders and H.K.I.M.S.R. for providing
this internship program which has provided an opportunity to gain practical
working knowledge in the organization.
My sincere gratitude to Mr. Rishav Patel without their kind direction and proper
guidance this study would have been incomplete.
I would like to thank Prof. Naveen srivastava for his careful guidance which
was extremely valuable for my study.
Lastly, I would like to thank each and every person who directly or indirectly
helped me in the completion of the project especially my parents and peers who
supported me throughout my project.
5
Index
Chapter Particular Page No.
No.
I Introduction 9-21
Background of the study 9
Background of the topic 10-11
Company profile 12
Statement of the problem 13-15
Need of the study 16-17
Scope of the study 18-19
Objectives of the study 20-21
II Research Methodology 22-50
Research design 22
Primary data 23-34
Secondary data 23-34
Method of data collection 35-37
Field work 38-41
Data-analysis techniques 42
III Data Processing and Analysis 43-50
IV Conclusions 51-52
6
List of Chart
7
EXECUTIVE SUMMARY
8
Introduction
9
Background of the topic: Summer Internship
Project(Finance)
Time management.
Invoices management.
Attention to detail to effectively analyze general ledger accounts
and financial statements.
Ability to manage transactions efficiently and accurately.
Checking GST number in Invoices.
10
Time management: Time management is the process of
organizing and planning how to divide your time between
different activities. Get it right, and you'll end up working.
GST Number: You can visit the GST web portal by clicking
www.gst.gov.in. After that go to the SEARCH TAXPAYERS
and click on the "Search by GSTIN" tab. Enter the GST number
and you'll get the info.
11
Company Profile:
Borivali East
Email: [email protected]
12
Statement of the problem:Financial statements
used in evaluating overall financial performance include the
balance sheet, the income statement, and the statement of cash
flows. Financial performance indicators are quantifiable metrics
used to measure how well a company is doing.
13
The 5 types of financial statements you need to know
14
Note to Financial Statements: Notes to the financial statements
disclose the detailed assumptions made by accountants when
preparing a company's: income statement, balance sheet,
statement of changes of financial position or statement of
retained earnings. The notes are essential to fully understanding
these documents.
15
Need of the Study:The conventional method was also
known as corporate finance during the twentieth century. This
strategy was implemented to raise and manage finances for the
firm. The three points listed below were utilised to analyse the
concept of financial management in this method:
16
Planning
The financial manager forecasts how much money the firm will
need to sustain positive cash flow, allocate funds to expand or
add new goods or services, deal with unforeseen occurrences,
and distribute that information with business partners. Capital
expenditures, T&E and personnel, and indirect and operational
expenses may all be divided into categories in planning.
Budgeting
17
Scope of the study:Financial planning is a term
related to the estimation of fund requirements of business and
deciding the sources for acquiring such funds. In simple terms,
financial planning can be termed as the financial blueprint of the
organization for carrying out the future set of operations towards
attaining goals. It is a detailed process that involves framing
strategic financial policies for procurement, deployment and
monitoring of business funds.
18
Proper Balance Between Funds Inflow and Outflow: It
focuses on maintaining proper balance in between the cash
inflow and outflows to ensure optimum liquidity within the
organization. Financial planning regulates all cash transactions,
lending and borrowing by business organization.
19
Objectives of the study:
The main objectives of financial planning which are given below
20
Identifying specific goals and objectives, as well as a timeframe
for achievement.
Selecting critical assumptions to be used in long-range
projections (i.e. inflation, rate of return, marginal tax rates and
mortality)
Identifying possible issues and shortfalls in connection with
each objective and listing recommendations for action.
Reviewing personal net worth with a detailed review of assets
and liabilities.
Titling assets and making recommendations for change.
Projecting short and long-term cash flow, as well as retirement
planning alternatives.
Analyzing college savings goals and making recommendations
for necessary adjustments.
Providing expert assistance with a wide variety of special
projects.
21
Research Methodology
Research design:Accounting means it is a
comprehensive system to analyse communication of financial
transactions. In other words meaning of accounting is a financial
language which assists you in measuring your growth year on
year.It helps to monitor our success through analysing and
summarizing financial transaction records.
22
Primary data: The main sources of funding are retained
earnings, debt capital, and equity capital. Companies use
retained earnings from business operations to expand or
distribute dividends to their shareholders. Businesses raise funds
by borrowing debt privately from a bank or by going public.
23
24
25
26
27
28
29
30
31
32
33
34
Method of data collection: Business Data is one
of the vital assets that your business can have. The more
information you possess about an area (your customers,
competitors, etc.), the better you can understand and affect it.
Each future-oriented company uses some business data
collection methods to analyze decisions, improve results, and
gain competitive advantages.Today’s online landscape provides
a variety of data gathering tools and techniques that are
powerful, innovative, cost-effective or free.
List of the best methods and tools for online data collection in
business and marketing research.Data can help you estimate the
effectiveness of every decision. Thus, you can maximize
resources, optimize workflows, and make your businesses more
profitable.
To build and maintain a successful company, you need to gain
and understand data about your customers’ behavior,
competitor’s strengths, market trends, etc.Now, let’s look at
some of the most effective online ways to gather the data.
35
Competitive Intelligence Tools: If you want to win at your
market and industry one of the crucial things you need is data
intelligence on your competition.Competitive intelligence tools
are quite powerful data collection methods. They are a gold
mine for insights and research on competitors.They allow you to
gather, analyze, and understand data about your competitive
market that includes competitors, products, technologies,
customers, and trends.In our post “25 Best Free Online
Competitor Analysis Tools” you can find a great range of online
tools you can use freely to spy your competitors, spot new
market trends, and find out what’s working within your niche.
36
Open Data Sources: When it comes to free online data
collection methods for your business, open data is a tremendous
solution.Open data are large datasets that are free and available
to anyone with an internet connection.
Governments, independent organizations, some businesses and
agencies are those who build open data for free and easy access.
Open data can be many types – from public data collected and
provided by government agencies to economic trend roundups
from financial organizations and banks.
Open data can give a big boost to your business. It makes you
rethink the way you understand and engage with the world. It
opens great business opportunities, such as giving you ideas for
new products and raising your business productivity.
37
Field work:The field of finance is essential for an entity
to handle its financial affairs effectively. A financial
professional is often responsible for managing investments,
accounts and financial documents. It's important for anyone
considering a career in finance to understand what options they
can pursue to decide if the financial field is right for them. In
this article, we discuss what the field of finance is, explore the
different types of finance and list the financial careers you can
pursue.
38
Public finance:finance is the financial management of a
government entity. It involves the government's social and fiscal
responsibilities of overseeing the sharing of resources, the
stability of the economy, the distribution of income and the
adequacy of social programs. Public finance may refer to taxing,
budgeting, spending and other policies that affect how a
government pays for the public services it provides. One of the
main activities of public finance management is managing
income tax.
39
Public accounting:Public accountants help people and
companies monitor their finances according to accounting
regulations. A public accountant might record business
transactions, audit financial records, prepare tax returns, prepare
financial documents and provide financial consulting services.
They can work in large partnerships or small firms.
40
41
Data analysis techniques: One of the main objectives
of accounting is to identify and distinguish the financial transactions
and to record these transactions in the books of accounts
systematically. Thus, the true nature of every single transactions are
recorded and acknowledged. In the end, every transactions are
recorded in general journal and later to preserve it permanently,
transactions have always been maintained in ledger accounts.
42
Data Processing and
Analysis:
Using data analytics, accountants can help a company:
43
Structure Business Improvements: When an area of the
company isn’t performing up to expectations, data analytics can
pinpoint where improvements might be needed. In order to
create an effective strategy, an accountant may review sales
forecasts, historical sales performance numbers and operating
costs.
Maximize Profits: With the clear insight that data analytics can
provide, a company can make decisions that will build up their
bottom line. To help with this, accountants will look at a number
of data points including past purchasing behaviors, current
market trends, inventory management and customer orders.
44
There are four types of data analysis used in accounting:
45
Tools for Data Analytics in Accounting:
Excel:
Excel is a popular tool for smaller businesses. It’s easy to
navigate for core accounting needs including drafting budgets,
building financial statements and developing balance sheets.
Tableau:
Accountants who work in larger data-sets (e.g. a mid-sized
company) have found Tableau to be a strong and flexible tool.
It’s particularly valued for its’ ability to visualize data.
Power BI:
Power BI combines business intelligence and data visualization.
It’s also a highly connected application as it easily connects with
Excel, Quickbooks, Google Analytics and more so accountants
can use it to aggregate multiple streams of data.
IDEA:
Accountants use IDEA because it’s software that was
specifically built for data analytics. Data can be easily imported
and analyzed quickly, efficiently, and in a user-friendly format.
46
A.I. and Analytics:
A.I. (Artificial Intelligence) holds powerful potential for the
accounting field but when it comes to data analysis it has
limitations. While A.I. systems may be able to analyze large
datasets quickly, a human will still need to critically evaluate,
interpret and create business plans based on that data.
47
All About the Data Processing Cycle
48
Step 1: Collection
The collection of raw data is the first step of the data processing
cycle. The type of raw data collected has a huge impact on the
output produced. Hence, raw data should be gathered from
defined and accurate sources so that the subsequent findings are
valid and usable. Raw data can include monetary figures,
website cookies, profit/loss statements of a company, user
behavior, etc.
Step 2: Preparation
Data preparation or data cleaning is the process of sorting and
filtering the raw data to remove unnecessary and inaccurate
data. Raw data is checked for errors, duplication,
miscalculations or missing data, and transformed into a suitable
form for further analysis and processing. This is done to ensure
that only the highest quality data is fed into the processing unit.
Step 3: Input
In this step, the raw data is converted into machine readable
form and fed into the processing unit. This can be in the form of
data entry through a keyboard, scanner or any other input
source.
49
Step 4: Data Processing
In this step, the raw data is subjected to various data processing
methods using machine learning and artificial intelligence
algorithms to generate a desirable output. This step may vary
slightly from process to process depending on the source of data
being processed (data lakes, online databases, connected
devices, etc.) and the intended use of the output.
Step 5: Output
The data is finally transmitted and displayed to the user in a
readable form like graphs, tables, vector files, audio, video,
documents, etc. This output can be stored and further processed
in the next data processing cycle.
Step 6: Storage
The last step of the data processing cycle is storage, where data
and metadata are stored for further use. This allows for quick
access and retrieval of information whenever needed, and also
allows it to be used as input in the next data processing cycle
directly.
50
Conclusions:
The fundamental objectives of accounting is to maintain accurate,
systematic and permanent transaction records of the business and
could stay retrieved as well as evaluated whenever needed. Such
financial information assist to identify the speed of the growth,
improvement areas as well as to take strong decisions that can be
beneficial to company.
51
Interpretation of the financial statements and data is essential for the
firm’s internal and external stakeholders. With the help of ratio
analysis, we interpret the numbers from the balance sheet and income
statements. Every stakeholder has different interests when it comes to
financial results. Equity investors.
Are more interested in the growth of the dividend payments and the
earnings power of the organization in the long run. Creditors would
like to ensure that they get their repayments on their dues on time.
52