Download "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: On-Balance Sheet Operating Leases - Financial Statements and Valuation Next video: 抵抗高通胀美国国债 Series I Bonds 手把手带你买收益率超过7%还无风险

抵抗高通胀美国国债 Series I Bonds 手把手带你买收益率超过7%还无风险

抵抗高通胀美国国债 Series I Bonds 手把手带你买收益率超过7%还无风险

Channel: 小夏和老麦

On-Balance Sheet Operating Leases - Financial Statements and Valuation

On-Balance Sheet Operating Leases - Financial Statements and Valuation

Channel: Mergers & Inquisitions / Breaking Into Wall Street

Accounting Basics Explained Through a Story

Accounting Basics Explained Through a Story

Channel: Leila Gharani

What is project finance?

What is project finance?

Channel: Financial modeling

Mergers and Acquisitions (M&A) - a challenging finance job❓ M&A analyst interview / M&A process

Mergers and Acquisitions (M&A) - a challenging finance job❓ M&A analyst interview / M&A process

Channel: Voice of Passionate Professionals

Calculate INCOME TAX for 2024! | Ankur Warikoo Hindi

Calculate INCOME TAX for 2024! | Ankur Warikoo Hindi

Channel: warikoo

Full Financial Accounting Course in One Video (10 Hours)

Full Financial Accounting Course in One Video (10 Hours)

Channel: Tony Bell

THIS can CHANGE the TAX on your CAR! | Ankur Warikoo #shorts

THIS can CHANGE the TAX on your CAR! | Ankur Warikoo #shorts

Channel: warikoo

PROFITS of a FOOD vs NON-FOOD COMPANY! | Ankur Warikoo #shorts

PROFITS of a FOOD vs NON-FOOD COMPANY! | Ankur Warikoo #shorts

Channel: warikoo

3 statement financial model

3 statement model

cash flow statement

cfa candidate resources

cfa level 1

cfa level 2

finance career

financial modeling

financial modeling for beginners

financial modeling in excel

how to get into investment banking

income statement

investment banking

investment banking analyst

investment banking pay

investment banking salary

mba vs cfa

sanjay saraf

the wallstreet school

valuation school

warikoo

what is investment banking

00:00:00

Hello everyone, I am Parth and welcome to

00:00:02

D Valuation School. In

00:00:05

this particular session of the financial modeling series of Valuation School,

00:00:07

now we will really start

00:00:09

plotting our numbers in our

00:00:11

financial model. Stay tuned till the end in this session if you

00:00:14

want to learn real new

00:00:17

thing. Feel me there are many people

00:00:19

who have seen the old videos

00:00:21

but have not subscribed our channel

00:00:24

and did not like the video.

00:00:26

Neetu understand d YouTube algorithm

00:00:28

work so please subscribe our channel and

00:00:30

like d video if you really like it. And

00:00:33

consider sharing it with your friends and

00:00:35

colleagues if you really find it useful before you

00:00:38

start this session and if you are watching this session for the

00:00:41

first time then I would highly

00:00:43

recommend you to watch the other three sessions

00:00:46

because the learning there is what I

00:00:48

In this particular session I will apply the whole without

00:00:50

you knowing going from very

00:00:53

basic in terms of formatting in terms

00:00:54

of setting in everything and this particular

00:00:57

session will be date ho c plot r

00:01:01

financial statement in the excel and c

00:01:03

will also perform same sort Of analysis,

00:01:05

in the next video I will go deep

00:01:08

dive into financial analysis of other

00:01:10

particular companies, so

00:01:13

let's start, you must have noticed that

00:01:16

Excel is open in front of me, the entire

00:01:18

black cell is open, I have already prepared some sheet or

00:01:21

I am not doing anything like this, I really

00:01:23

want you to learn how to make it from scratch.

00:01:25

When I complete the solution, I will complete the

00:01:28

complete model here for today's

00:01:30

session. I will

00:01:32

definitely put this particular sheet in this

00:01:34

link. So date you know you can refer it while

00:01:37

performing your on exercise ok I would

00:01:40

highly recommend you

00:01:42

a possible start doing along with me if

00:01:45

you are watching this video on mobile please don't

00:01:47

watch it watch it on laptop if you don't have time right now

00:01:49

keep it serious later You can see later, there is no

00:01:51

problem, okay, let's

00:01:53

start,

00:01:56

what do I have to do, today I have decided

00:02:00

that I will

00:02:01

plot my historical statement using the example of Tata Motors.

00:02:03

Now I have two

00:02:06

options. The number one is that I

00:02:12

download the annual reports of last 5 years of Tata Motors balance sheet

00:02:14

and punch them manually one by one [

00:02:19

Music]

00:02:23

Investment Banking is

00:02:26

fine, it is not to be reduced, it is being reduced very smartly

00:02:31

for that. I have two options to

00:02:33

do smart work, it is okay but I

00:02:36

will do smart work in that too, if you do

00:02:43

n't know then please look carefully, this is a

00:02:46

very good website, here it

00:02:49

is necessary for you to have a unit, give a search

00:02:53

for Tata Motors, if you do

00:02:55

Tata Motors, then this is Will give you the

00:02:58

complete financial statement and its complete

00:03:00

financial details Awards

00:03:01

Prose Word Not

00:03:04

Naval Come Down Come Down Come Down

00:03:08

This is the quarterly results,

00:03:11

here you can see the PDF of the quarterly results,

00:03:12

how you will get the PDF for

00:03:15

D Portal

00:03:23

[Music ]

00:03:37

And I will download it,

00:03:49

export here, Excel has been

00:03:56

downloaded, I will

00:03:59

tell you about some of the things that have been downloaded

00:04:04

and the data sheet. Okay, so first of all let's move on to the number and the

00:04:09

annual report that we downloaded.

00:04:13

So my annual report is being downloaded

00:04:16

over here this is my annual report

00:04:20

okay

00:04:23

welcome down welcome down welcome down welcome

00:04:25

down tu de point where they have

00:04:28

given the financial statement

00:04:40

ended here or the audit opinion is

00:04:43

financial control blah blah blah blah And

00:04:47

this is my balance sheet from page number 193, you have to

00:04:50

keep this thing in mind, 193 OK, this is

00:04:59

my cash flow statement on 193 1946 and there is

00:05:01

something below that, what is this, what is it, I do

00:05:04

n't need it,

00:05:09

so initially I need pages 193 to 196. The

00:05:14

entire data is relevant for me,

00:05:16

so what can you do

00:05:21

[Music]

00:06:06

And just download this one

00:06:08

you download, once you download it,

00:06:14

this excel will appear in front of you, now

00:06:17

my half an hour is over,

00:06:18

once the data is available to me If it is in Excel

00:06:20

then I can easily manage it. I can

00:06:23

format it easily. In my reliable

00:06:25

or whatever is my preferred way of working,

00:06:27

look here, this is my balance sheet.

00:06:29

This is my income statement.

00:06:33

This is my cash. Flow statement has come,

00:06:38

my cash flow statement has come and

00:06:41

this is my change your equity but it is not very relevant,

00:06:42

then half of your

00:06:46

battle is gone, you see the other

00:06:48

videos which other people tell, they are

00:06:50

a- One by one you know first go here then

00:06:52

come here then copy this and paste it one by

00:06:53

one from there this is not

00:06:55

possible it is not the most visible even of

00:06:57

working I will not pretend neither I do it myself

00:06:59

nor I suggest someone else to

00:07:01

do this because what will happen, I

00:07:03

tell the region when you will be

00:07:05

working in investment bank so it will be

00:07:08

working in valuation profile very

00:07:09

very research you have these resources where

00:07:12

you can one click and The entire

00:07:15

capital is like you.

00:07:17

Okay, something that I was telling you is

00:07:20

capital like you. Here,

00:07:22

within one click, you can get the entire balance sheet,

00:07:23

its statement here

00:07:25

in Excel, so there, this donkey is

00:07:27

working as a laborer. There is no logic honestly okay

00:07:29

apart from this so I close this also

00:07:33

so this will be my first way of you know

00:07:36

pulling data of D company you excel but this is

00:07:40

again not a very preferable way so

00:07:42

many complications here you You

00:07:44

will understand further that

00:07:45

my most preferred way, sir, is

00:07:49

what we had downloaded from Excel, we had downloaded the

00:07:51

data from the screener,

00:07:53

moved it over,

00:07:58

whenever you exported the data from the screener to

00:08:02

Excel, then you got

00:08:06

some data like this with certainty. If it is downloaded

00:08:14

then some such data will come or it may not come

00:08:17

then you are only concerned with the columns in the data sheet, apart from this

00:08:23

we do not have to do it on any other seat, for

00:08:25

now ok nine you need to

00:08:28

understand, first of all in this sheet you will Do

00:08:30

n't make any changes, this is not what I wrote,

00:08:33

so don't need you make any other kind of change

00:08:36

in date particular this particular sheet

00:08:39

number van OK nine we move a little bit will

00:08:41

just move on and what we will do is just

00:08:45

adjust it a little bit

00:08:48

Here I write

00:08:50

financial and give an arrow to

00:08:54

it, I go to type color and I will put

00:08:58

dark color which is my preferred color, always

00:09:01

two,

00:09:03

okay, I do that

00:09:04

and here I put a seat and

00:09:08

insert,

00:09:09

here I write historical.

00:09:18

I do it brother, it is reduced like this, there should be an

00:09:24

investment bank,

00:09:43

financial analysis and what not, they will all

00:09:46

come here in the data, whatever raw data I will bring

00:09:49

on the sheet, all that raw data will

00:09:51

come after this sheet, this sheet will blacken, okay nine

00:09:55

once. From

00:09:58

my mouth, this is historical. First of all, what we have to

00:10:01

reduce is the alt

00:10:03

wvgrid lines. I took out the entire alt

00:10:07

web.

00:10:10

I did this by going to alt web live. I selected a column

00:10:14

alt ho and packed it in 1.15 and

00:10:18

its region. Already

00:10:20

I have told in the previous video, if you haven't

00:10:22

seen then please go to the I button and

00:10:24

watch the old video first, don't start with this,

00:10:26

actually bhaiya, disaster for you, I do, I want a

00:10:29

holistic learning of all my

00:10:31

YouTube students, okay nine

00:10:35

votes, I need you do

00:10:37

me. Always starting

00:10:49

okay nine

00:10:52

I do a little bit first of all I

00:10:55

plot some data points

00:10:58

how do I upload that into the data points we will see

00:10:59

so I write it here

00:11:02

years okay what is happening right one thing

00:11:06

and

00:11:08

will run home We will not touch from the beginning till the end,

00:11:11

our caliber will work, I have seen

00:11:14

man, there are many students, don't do

00:11:18

this, it will

00:11:22

become very appealing

00:11:26

[Music]

00:11:35

1.5 1.2

00:11:38

Okay, so this is my year, whenever you have,

00:11:42

whenever you reduce further. In investment banks

00:11:44

and you get client's data,

00:11:46

then first of all bring the data to your

00:11:49

modeling sheet and bring this data to

00:11:51

this sheet, like we

00:12:02

will try to link the data sheet right now. First of all,

00:12:07

here I write, first of all, the

00:12:10

heading will go, what is it, then by giving equal to

00:12:12

double,

00:12:16

historical

00:12:18

financial statement statement

00:12:25

bracket space,

00:12:28

then double and

00:12:30

I selected and and I go directly to the data

00:12:34

sheet and this is the B-Van column. When

00:12:37

I click on the selection,

00:12:39

you will see that it has automatically

00:12:41

made it dynamic. What does it mean that yesterday if

00:12:43

you have kept this sheet like this, then he

00:12:45

said, do not touch it, the sheet is fine and you are

00:12:48

making this historical financial,

00:12:49

you have changed the sheet. By doing this, I take his sheet, you have

00:12:52

downloaded the sheet of Tata Steel,

00:12:54

here you will see automatically that

00:12:57

he has taken Tata Steel, the date is the same, don't want

00:12:59

you to change this particular sheet, he

00:13:01

also advised, brother, don't change the

00:13:03

sheet, okay nine.

00:13:07

This thing of mine has been confirmed, we will

00:13:09

set it, don't worry, now I do

00:13:11

years hardcore here, there is no years number,

00:13:14

so no color convention will be followed in this,

00:13:16

I will go on equal tu and this

00:13:19

column which is C means my oldest

00:13:22

financial statement is

00:13:25

shown here. I am getting March 30, not automatically, I

00:13:28

select it and now see

00:13:31

what number format it has come in, so I

00:13:32

will control OnePlus, I will go into date

00:13:36

and after going into date, I will go down a little bit, I will go

00:13:38

down down,

00:13:40

okay date. I am not getting it, I will shift the control,

00:13:48

what will I do,

00:13:50

you will cast

00:13:54

and make it

00:14:00

perfect and I will keep dragging it, I will keep

00:14:04

dragging, meaning I will keep moving it forward, I will keep

00:14:07

seeing where it is coming

00:14:09

March 22, March 23, you will not get this No,

00:14:12

here I will go hardcore,

00:14:15

ITM, what is the meaning of ITM and I

00:14:20

will take it as Alt H and there I will take it as

00:14:40

Alt H

00:14:43

Alt H

00:14:45

and this has to be made

00:14:47

bold,

00:14:50

here this one, select the top column in the column

00:14:53

and call it Alt

00:14:56

HMC. Make means center, let me

00:15:01

return and tell, Alt

00:15:03

Hum is visible,

00:15:08

so this data of mine has been plotted in a very good way,

00:15:14

here I write the income statement

00:15:20

and I make it bold and here

00:15:22

I put a has. I have already told you

00:15:24

why you laugh, okay, so if

00:15:27

you have not seen it yet then please

00:15:28

watch it and first of all, while taking our top, I

00:15:31

will understand each and every thing. Well, if you are

00:15:33

feeling that sir oh my lap here. So

00:15:36

look, this is just a small tap, only this item will

00:15:39

go and against that, if I

00:15:42

open this PNR for example

00:15:48

here, then see how many will be

00:15:56

required later, then we will set it.

00:15:59

Don't worry, now the first thing I want to explain.

00:16:02

And understand that how to come with the data, if I am a

00:16:04

professional man

00:16:06

then I will go into sales, I do

00:16:08

not have anything to do in sales, you have to keep one thing in mind

00:16:11

sir, this

00:16:15

number of yours should not appear anywhere in the entire model, which appears like this.

00:16:17

No,

00:16:18

this is the worst

00:16:25

formula, he has to do it, if the

00:16:28

error is what to select in the value, you have to

00:16:32

select this cell in the value,

00:16:34

if there is no value here then make it zero and

00:16:39

see, you have got the value and I want to

00:16:42

plot it till March 2020. What has to be done is that once

00:16:46

I have plotted it,

00:16:50

now you are seeing that it has been plotted, and I

00:16:54

select it, I go to the control van, I

00:16:56

go to Karanji, I go to currency symbol, I select the

00:16:58

rupee symbol

00:17:01

and I go to negative. I am okay here

00:17:05

and I do okay.

00:17:07

Need up to two decimal places please. You will go to customs. I will take

00:17:11

this in this particular. Okay,

00:17:13

so I will put this negative in parentheses.

00:17:16

Rather day putting - sin over there.

00:17:19

I want those who have this. You are not understanding, you are

00:17:23

not understanding

00:17:24

because you have not seen the last video.

00:17:32

If you look carefully, this is

00:17:35

the division of the semi column, this one reflects a positive number,

00:17:37

this one reflects a negative number

00:17:39

and so on. After which the zero

00:17:42

reflects what it is

00:17:50

doing right now, it has changed everything into currency, which is

00:17:52

exactly what I

00:17:55

wanted,

00:17:57

I will make it a little bigger so that if there is

00:18:00

any problem then it will be listed, it will look a little

00:18:02

better, look at the perfect ITM now.

00:18:05

How to do ITM, they think that there is

00:18:07

nothing to be done even in ITM. If there is an error,

00:18:13

you opened the bracket, here you have

00:18:16

put the function of SAM, I need SAM, for what thing do I

00:18:18

need SAM, below you will see that

00:18:21

quarterly data is available here,

00:18:24

this is the data of quarters. So give me the last chat,

00:18:27

if Sam does not come then give zero,

00:18:33

make the model dynamic,

00:18:37

I am doing control C and I am just

00:18:39

going with control alt V and pasting the format,

00:18:42

here

00:18:47

he is telling what he is trying to say,

00:18:49

know. He is saying that brother, this is a

00:18:50

particular formula, it is your

00:18:52

formula, all the other formulas are different from this,

00:18:54

I have to ignore one error, I have to keep doing it,

00:19:01

okay

00:19:08

sales growth will not come, it will

00:19:11

not be applicable,

00:19:29

so I will give you this 23. I

00:19:35

want the percentage in two decimals. We have

00:19:37

set the first convention number one

00:19:39

decimal percentage two decimal. I will

00:19:42

plot it completely till here

00:19:45

and I will select the entire line and

00:19:48

bring it in italics. You

00:19:58

can change it. Ho means it should not be completely

00:20:01

black rather it is so

00:20:03

here with me

00:20:05

plot my numbers over there, let me make it a little

00:20:09

bigger so that the numbers are a little

00:20:11

clearer.

00:20:16

Yes, so our sales figures are all plotted.

00:20:18

Now let us plot the cost.

00:20:21

Off Good Sold

00:20:23

Ok Error

00:20:25

[Music]

00:20:31

Always have to open Sam will open I will

00:20:35

go to you D data sheet I will link to the data sheet

00:20:37

I have to Sam I

00:20:40

mean raw material cost my earning power and

00:20:45

fuel and manufacturing expenses

00:20:48

employee cost even

00:20:50

its After this I have to

00:20:53

reduce the inventory from it but

00:20:56

when I do the inventory then I

00:20:59

will do mines van tu means

00:21:17

I will give it zero if it

00:21:19

comes here for some time then this is my inventory here

00:21:21

cost of good sold is my plot

00:21:32

from where When you picked it up, you see this, he

00:21:35

took it straight to the black column and threw it,

00:21:37

how will you see this? You know, you

00:21:40

will press control and press the bracket next to P,

00:21:45

then tell me where this formula is from. If you have

00:21:47

picked it then see it was black so it has

00:21:49

declared it an error and made it zero and

00:21:52

we had done the formatting that whenever there is a zero, there should not be a

00:21:54

zero, instead of it there should be a parentaces,

00:21:56

a hyphen should go here, okay let me go back to

00:21:58

that sheet. If yes, then I

00:22:00

will control and I will enter, then

00:22:02

the particular will stop on the same block.

00:22:04

Okay nine,

00:22:06

so this is my cost of good sold sir, one

00:22:09

thing I did not understand, I

00:22:11

compared both the sheets which was the annual financial

00:22:12

statement. The Annual Reports of

00:22:14

Financial Statement had come and

00:22:15

what is here is that there is a slight change in the numbers,

00:22:17

it will always come, okay if you

00:22:21

open the last Annual Report of Tata Motors

00:22:23

and see the numbers of 21 in it and you

00:22:27

open the current tier. And if you look at the

00:22:29

numbers of 21, you will see a little difference in that also, do

00:22:30

n't take so much tension in it, okay

00:22:33

nine, here I will do cross margin,

00:22:39

so for gross margin, okay this will be

00:22:42

your GSA, a percentage of sales,

00:22:48

we will do

00:23:05

nothing about it. Okay, let's

00:23:13

set this also, friend, why are you

00:23:16

taking tension, is the

00:23:33

data available,

00:23:42

yes,

00:23:45

and ignore this, it will be very clear to the formula,

00:24:03

what do I have to reduce to reach here,

00:24:07

I go higher and higher and higher and

00:24:10

higher. Yes, this is what I have to reduce to

00:24:12

get my income,

00:24:16

you are seeing what is the ideal income, I am

00:24:19

not even considering it,

00:24:20

what is the reason behind this, this respect, income is very fluctuating

00:24:24

right sometimes - 26000 this is in crores ok this is this. The

00:24:28

balance sheet is in Karodes, the

00:24:30

market capitalization is ₹ 150000 crores, I am

00:24:33

just avoiding this for the time being, I am proud of

00:24:35

them, so what should I do, I have

00:24:41

incorporated even this expense, now

00:24:43

this selling end expense is my

00:24:45

expense. If I will do both of these

00:24:47

then my earning before interesting

00:24:50

depression will go to OK nine What I will do is

00:24:55

Selling and

00:24:57

General Expenses

00:25:02

equal to if same

00:25:09

data sheet

00:25:12

your selling and administration

00:25:21

industry is OK iso

00:25:24

closed equal to zero iso iso closed

00:25:30

above Sorry, I have gone up here

00:25:34

and pasted the 'end welcome'

00:25:41

and I also take control alt and

00:25:44

paste the format. Do

00:25:49

n't let this problem happen. If there

00:25:56

is income, depression, interest in the quarter,

00:25:59

then what has he done here about

00:26:02

my expenditure? Have not given a breakup,

00:26:04

fine for time being it's okay, if not

00:26:07

given, can't do anything,

00:26:12

so what I will do, I do it

00:26:21

with expenses, you

00:26:25

will enjoy it brother, you will get the complete model in the last,

00:26:31

any company, any Indian listed.

00:26:34

It will take a second for the company. You will have the entire

00:26:36

financial statement plotted for you.

00:26:38

Today, I change the formatting of the percentage of sales.

00:26:42

I also change the formatting of this. I

00:26:45

select the whole

00:26:49

till here

00:26:51

and I turn it in

00:27:15

and this being done now will calculate

00:27:21

nothing. But this minus this,

00:27:32

okay,

00:27:45

I will link it directly from here. You are making an

00:27:50

error in writing, Bharat Babu,

00:27:53

how will it be less? Why is it so

00:28:18

important? I will explain it

00:28:21

in a minute. You must have

00:28:23

heard it repeated again and again. It

00:28:25

happens that I have a son, brother, why do I want a son?

00:28:29

Tell me, I have taken the entire format of the above,

00:28:33

corrected control alt and pasted it.

00:29:03

Okay, nine, what will I need you to plot? Now, I will complete this

00:29:06

interest

00:29:08

once and then I will tell you

00:29:11

what. If the interest is

00:29:13

relevant then I

00:29:16

will go to the interest data sheet.

00:29:28

Interest is visible to me,

00:29:30

check it directly, you are taking it from the right place, Han ji.

00:29:32

Interest is visible to me directly

00:29:51

[Music] If

00:30:02

you have

00:30:06

interest, I would have

00:30:07

put it in front of this. I am a function of Sam

00:30:12

and I want D number of interest of last

00:30:15

four quarters,

00:30:41

I completely copy the

00:30:58

depression

00:31:01

appreciation

00:31:19

formatting, otherwise later and

00:31:22

you also

00:31:27

paste it,

00:31:30

now I go to the formula, I go to the data sheet

00:31:33

here. I directly pick it up and

00:31:36

lift it up on the interest,

00:31:46

kh49, you k409,

00:31:53

instead of 49, h46 has to be made 46, I make it 46

00:31:59

46,

00:32:02

this is my interest,

00:32:06

something is wrong,

00:32:39

so this one has become h46, my son has become

00:33:11

45

00:33:13

hands equal.

00:33:15

Ok here's the problem

00:33:20

here you have to take this don't do

00:33:31

this

00:33:47

I go to depression as percentage of sales and I plot it till the last

00:34:06

and forming valuation and analyzing you

00:34:09

complete because Abida is your entire business

00:34:11

earning, that is your business your How

00:34:15

efficiently do you turn it on, what is the earning from it?

00:34:18

Debt, it is D Major of India and

00:34:20

it will include D difference, it has

00:34:36

got

00:34:38

loan, it has got another company which is charging very high

00:34:41

interest, so I do

00:34:43

not want to see the earnings of all of them, its earnings. It

00:34:45

is more because his interest

00:34:46

is less. No, I do not want to know how much

00:34:49

you are earning due to the efficiency of your business,

00:34:51

so the cap I put before reducing the interest and depression is

00:34:56

my

00:34:57

okay, I hope you understand this a little. It will be

00:35:05

fine, whatever is fine,

00:35:30

come on,

00:35:37

this sin was being committed, you did

00:35:46

n't even tell me, you people

00:35:59

started watching after installing the ATM on ITM, brother, don't do this,

00:36:08

otherwise after Abida, whatever will be my

00:36:11

profit. Before tax is calculated,

00:36:15

after this my earnings will be calculated.

00:36:29

Before tax,

00:36:33

say whatever you want. In

00:36:37

UK, we call it as earning. In UK, we call it

00:36:40

profit.

00:36:56

Then

00:37:16

why are you not putting it in negative for the first time. Yes,

00:37:19

let's

00:37:22

check once, everything is correct. Whether it is there or not,

00:37:27

I select this line,

00:37:31

go to the view, set it as free, let's

00:37:38

move forward quickly, I have

00:37:42

pasted its format, I have given the

00:38:00

before tax below,

00:38:04

now I calculate the tax

00:38:08

on how much tax the company actually

00:38:27

shipped. Tax

00:38:32

[Music]

00:38:46

Formatting

00:38:50

I put an error in it

00:38:53

Same

00:38:57

function

00:39:25

Effective tax rate

00:39:36

Effective tax rate

00:39:47

Something is exceptional Leave it aside

00:39:50

Now you will look at it I also samjhaunga

00:39:52

How to deal with it

00:39:55

Come on, once my effective tax rate is

00:39:58

calculated Now what is coming out of me is what is

00:40:00

coming out of me, my net profit

00:40:03

profit, net profit is

00:40:08

nothing but your dad, you are

00:40:22

feeling bored, stop learning by reading the book, do

00:40:25

n't watch the video,

00:40:28

okay

00:40:39

[music]

00:40:49

So now you will see that your net margin is a little

00:40:51

negative. The company is running well,

00:40:53

there is no problem. Okay, once

00:40:55

you have invested the net margins here, this is the

00:40:57

profit, this is the

00:40:59

profit for the equity share holders. It is also

00:41:01

called this and the earning is available for the equity

00:41:02

share holders. Gone or decreased,

00:41:04

interest has increased, interest has been distributed, depression has

00:41:07

attacked, what to do and I, whatever is left will be the

00:41:09

equity of the shareholders only, now the

00:41:11

management of the company will decide whether they

00:41:13

want distribution, 100% has a

00:41:15

dividend and they want debt. You re invest

00:41:18

in d business in this particular case after

00:41:21

2018 they are not in an opposition you

00:41:23

distribution d residential loss making

00:41:24

company but again you can see d loss is in

00:41:27

d negative trend they are trying you reuse

00:41:29

d losses understand what to do Well,

00:41:33

after this, what else is going on inside the data sheet,

00:41:36

what is the net operating profit? My net

00:41:37

profit has come out. Sorry,

00:41:40

not the operating profit, the net profit has come out.

00:41:42

I come further down, I look and

00:41:44

what material I am getting, so

00:41:45

adjusted equity. Shares are in crores,

00:41:47

price is

00:41:49

number of equity shares also

00:41:53

you can see over every see have d number of

00:41:55

equity shares

00:41:58

but what is this in absolute figure I

00:42:01

go down just now I saw na han

00:42:02

here is the

00:42:07

adjusted equity shares in crores so This is

00:42:10

this D Number of equity shares

00:42:11

outstanding Okay so what I'll do this I

00:42:14

'll just plot date particular thing

00:42:16

over her

00:42:37

[Music] So

00:42:39

what are you doing man

00:42:54

I have everything so I don't have to do anything

00:43:05

see

00:43:08

this

00:43:11

if this

00:43:26

divided Bye

00:43:42

[Music] Let's

00:43:50

set this completely, let's

00:43:53

select this,

00:44:19

okay nine, let's see how much dividend the company

00:44:23

makes. Is dividend information

00:44:25

available with me?

00:44:45

Keep this also

00:45:04

from here

00:45:10

divided by by in which the total

00:45:48

company is very thick stool. Kept it nearby, no

00:45:50

problem, it's very good,

00:46:02

there is zero zero a,

00:46:06

okay and for this you copy and

00:46:09

paste the formatting from below,

00:46:13

so it has made it blank,

00:46:47

okay

00:46:50

here you do it, it

00:47:06

looks like a little episode. Is it okay, no

00:47:08

problem, okay for now,

00:47:19

my dividend post has been shared, if you want, then

00:47:22

what can you do from this nine, you

00:47:24

can do the

00:47:28

dividend

00:47:30

payout ratio, we will analyze the ratio completely differently,

00:47:32

but right now whatever is available.

00:47:34

I can plot a plot, my friend

00:47:39

Hanji, the

00:47:45

company has given 6%,

00:48:02

now you will understand,

00:48:07

ok,

00:48:24

let's post the dividend, I have got the share, I

00:48:28

hand over whatever I

00:48:31

get, I keep getting it, I have made it

00:49:05

93% running,

00:49:35

this is it. Give more this

00:49:39

dendu

00:49:43

van mains

00:49:51

zero,

00:50:05

here the company should have

00:50:11

come zero, if I had

00:50:14

not applied the formula then here too there was 100 A

00:50:15

retained after coming. Okay I hope you must be understanding

00:50:18

why I have applied the formula.

00:50:19

Make it very meaningful. Man, this is such a thing that it will

00:50:23

not be fun, then small things

00:50:25

become one thing at such a small turn. If you

00:50:27

ask me to explain then

00:50:30

Han ji, your very beautiful size statement is

00:50:33

ready. This is your

00:50:37

income statement of Tata Motors as of now. There is

00:50:40

Tata Motors to talk about and there will be something good, we will

00:50:42

tell you in detail, now next time

00:50:45

we will go straight to the balance sheet, the balance

00:50:47

sheet is very easy, it is straight forward, it will be made quickly,

00:50:55

hey Narayan

00:51:02

Narayan, don't

00:51:09

do anything in it brother, this is a simple

00:51:11

logic here. Pick it up from here, do the

00:51:13

whole thing

00:51:17

OK,

00:51:19

go to the historical A, do control alt and

00:51:21

paste it, make it

00:51:37

one down for now, make it

00:51:39

bold, write total liability

00:51:49

as fixed asset, net block

00:51:55

and

00:51:58

capital, working progress investment,

00:52:01

respect asset, do this. Will give you total assets and

00:52:08

total non-current assets.

00:52:14

I don't have the information and I am

00:52:17

not even running after it. Right now my

00:52:18

aim is to make you automate this particular exercise.

00:52:23

Let the whole exercise be over. You can give information to any Indian of any listed financial

00:52:25

company.

00:52:28

Or complete analysis of listed company within 1 minute, people can

00:52:30

complete it with formatting and I will tell you don't

00:52:33

worry this be with me where with me okay in

00:52:38

this I do one more thing and below these

00:52:41

three are my

00:52:43

total current assets

00:52:47

and here My total

00:52:52

started immediately

00:53:03

[Music]

00:53:14

[Music]

00:53:18

Han Ji Semiya There is no harm in checking the butt

00:53:26

[Music]

00:53:37

Copy, there

00:53:52

will be some problem for the quarterly

00:54:04

[Music]

00:54:27

Okay sir, this is to move from one sheet to another seat.

00:54:29

So you can move down the control page

00:54:31

quickly

00:54:36

63 64 65 OK

00:54:57

22 Total on current 329061

00:55:02

Just check total nine

00:55:05

Perfectly going on keep

00:55:08

moving step by step Congratulations go

00:55:12

copy

00:55:19

Han ji

00:55:25

copy it friend

00:55:30

where is my receivable sitting in 67

00:55:33

So just have to do one up and down and what happened, I

00:55:40

can kill all three, so this is

00:55:50

my list, now I will do this, it is happening to Baba Ji, it is

00:56:09

happening to Baba Ji,

00:56:28

do this also properly, highlight

00:56:33

total on current asset, check. Do it,

00:56:44

now my total asset is 8351.

00:57:01

[Music]

00:57:17

[Music]

00:57:19

If you want this breakup of Non Current Asset

00:57:22

on Current Liability, it is very easy to get in 1 minute,

00:57:26

you do not have to do anything,

00:57:29

first of all you have to go to the datasheet, remove it.

00:57:33

Apply the error formula, come to Aadar Asset, do this in

00:57:41

30 ways.

00:58:28

Now do one thing here which professionals

00:58:31

do,

00:58:33

check

00:58:38

this, it is equal to library and not true.

00:58:53

We have successfully plotted our income statement and

00:58:56

our balance sheet for This

00:59:00

year is under consideration.

00:59:04

Often we talk about the

00:59:08

cash flow statement. Now see

00:59:11

how small the cash flow has been given in it. I

00:59:18

will add a column here in it and here I

00:59:21

will write that means I will name the sheet,

00:59:26

how will it be,

00:59:29

I will be the

00:59:30

screener only. I will open the

00:59:33

open screen,

00:59:45

okay, when this thing gets populated,

00:59:48

then you will select it from here like this,

00:59:51

drag the mouse completely and bring it down, you will

00:59:54

copy and unit you make sir date, you

00:59:58

always have to make a copy beat and

01:00:00

selection. Have to keep it as it is

01:00:02

because my road data will be created. Okay, this will

01:00:06

become my road data and adjust this thing a little bit,

01:00:11

also take control alt from it and

01:00:14

take paste treatment on the text.

01:00:22

Okay,

01:00:53

first of all,

01:00:56

from

01:00:59

operating activities in

01:01:04

bold, from

01:01:09

operations to

01:01:11

direct.

01:01:15

Everything is coming will

01:02:00

start with profit

01:02:03

from operations and wheel reduce in winter

01:02:10

[Music]

01:02:13

Working capital will change There will be direct taxes,

01:02:16

okay,

01:02:17

so this will come, if you

01:02:27

want, you can write it like this, but we are

01:03:37

showing it in Look Good March 2022, here there is a

01:03:46

problem in understanding

01:03:51

[Music]

01:04:23

So my March,

01:04:36

everything happens in 2013,

01:04:39

you guys, let's go.

01:04:43

My operating activities are moving ahead,

01:04:54

francising is completely set, do the investing activity, do the

01:04:56

investing activity, whatever is given earlier, do it by

01:05:03

bolding it, cash has gone into the data,

01:05:06

investing activity is starting from here,

01:05:09

okay cash from investing

01:05:11

activity. Inside this, you have to

01:05:13

start from purchase and sale from here,

01:05:17

this entire plant will be built there,

01:05:20

copy

01:05:28

sparrow

01:05:30

data from 13 column

01:05:50

[music] Are you

01:06:15

investing,

01:06:35

yes in opening activities,

01:06:57

cash flow data proceeds from shares and

01:07:02

[music]

01:07:03

March 13 This Column

01:07:08

N Procedure OK

01:07:26

[Music]

01:08:00

Let's do it

01:08:02

now, it will

01:08:07

go here

01:08:30

[Applause]

01:08:31

[Music] Whatever

01:08:45

we have done till now, what we have done, we have

01:08:48

pasted the entire finance here,

01:08:51

OK, in a

01:08:54

wonderful way, it is here. You can see a

01:08:59

very professional looking model in front of you,

01:09:10

this is my balance sheet, this is my income

01:09:12

statement, this is the balance sheet, what does it have to do with it, why did

01:09:18

I make you do this

01:09:20

automatically, okay why did we repeat it again

01:09:23

and again and again and again It's

01:09:24

okay to do it, he understands it

01:09:31

and I do it, I will do FS analysis of Tata Motors,

01:09:40

I have done this file,

01:09:50

pay some attention to this,

01:09:53

you have to

01:09:56

return to screener.in and you have to

01:10:00

excel by slashing,

01:10:05

you have to manually add skinner. .in

01:10:18

This has to be uploaded, you have uploaded it once, it is

01:10:21

reasonable for you, you must not be getting wars,

01:10:23

okay,

01:10:33

enable it,

01:10:36

what's the matter, have I received the financial statement of ITC,

01:10:42

do it only once today in my entire life.

01:10:45

You are understanding that everything is set automatically, it is from

01:10:54

Tata Motors, so you have to do one less thing, you

01:10:57

just have to do the same thing, you have to

01:11:00

go to ITC, below you have to come to the cashless statement,

01:11:02

all this is

01:11:07

fine, from here you have to click the mouse. Have to take the whole thing, have to

01:11:10

copy till the bottom, have to

01:11:13

come here, have to come here, there was control alt in B2,

01:11:15

sir, what does it mean,

01:11:21

Han Bhai Han,

01:11:23

cashless treatment has been set, Han

01:11:25

Bhai Han, okay, you will cross check once.

01:11:28

Absolutely, people, there is no problem.

01:11:31

Well, where it has not happened, it will not happen there,

01:11:33

so let me tell you how it will not happen,

01:11:36

you should take a little look, like investing in it

01:11:37

etc., if these additions come, then perhaps the cash flow may have been

01:11:40

shaken a bit, but the rest is majority

01:11:42

99.99% of D. Time is everything being set

01:11:46

over. Even if I feel a little extra effort in cash flow,

01:11:48

I will still put it. Let

01:11:51

me explain how.

01:11:53

Whoever sees the cash flow from operating

01:11:55

activity is 15776, so is it

01:11:59

not 1577, then I have to understand why

01:12:02

not. Here is the

01:12:03

direct tax

01:12:05

profit profit profit profit profit profit

01:12:07

ok direct tax all this was correct but

01:12:11

here and here there are seven items so there is one

01:12:14

thing which is missing what is missing let's

01:12:16

see the receivable inventory paper respect

01:12:19

working capital working Capital change and

01:12:21

direct tax

01:12:24

loan advance is not there, there the loan

01:12:32

capital is being treated like loan advance, there is

01:12:35

no problem, there is no loan advance,

01:12:36

so now what you have to do is simple

01:12:38

logic, do not do advance system here,

01:12:41

leave it at zero. Do

01:12:45

Respect Working Capital

01:12:55

[Music]

01:13:12

Na what, now my item tally is getting

01:13:16

checked once, now

01:13:19

they understand the

01:13:28

same old problem, they have

01:13:31

taken it from c8,

01:14:04

my 12 is taken to

01:14:42

zero, go and check it, is it

01:14:45

falling on redemption cancellation?

01:14:46

No, if

01:14:48

the redemption is not falling on cancellation,

01:14:51

then it means that the net net is a

01:15:05

small cash flow statement. Be happy with that. There is

01:15:07

no problem.

01:15:11

Okay, so how far can I take it, at least I

01:15:14

can take it till here,

01:15:24

if it is a cancellation acquisition. Not both, and

01:15:28

this is straight forward,

01:15:30

I will paste its formula, it is

01:15:44

set sir, it is completely set,

01:16:11

you will see the hardcore one by one,

01:16:18

don't worry,

01:16:19

financing activity plays the last,

01:16:22

my total items inside financing activity

01:16:24

is 12

01:16:25

and I have total items. 9 So here are

01:16:29

some substantial differences Proceed

01:16:31

from Share Proceed from Boring Ribbon

01:16:34

Share Redemption of Debenture Proceed from

01:16:37

Boring Repayment of Boring Do you understand

01:16:39

Redemption of Debenture is a new thing coming here

01:16:42

under ITC, which

01:16:44

was there in Tata but it is not an ITC.

01:16:47

Because of ITC, I

01:16:51

will make it

01:16:54

perfect

01:16:56

and e26 is the formula, I will make it

01:17:04

27,

01:17:08

35924,

01:17:31

actually, otherwise it will take so much time, it is too much to

01:17:33

watch one by one, so I will

01:17:35

drag it from the beginning,

01:17:38

let's do the

01:17:42

perfect process of sharing, it

01:17:48

is boring.

01:17:54

From here,

01:18:15

after 24 days, there is the progress of

01:18:18

wiring, then there is the interest tree, financial

01:18:22

interest, dividend of boring,

01:18:26

directly below

01:18:29

this, I directly check the deposit in one go, is

01:18:34

there the

01:18:40

progress from deposits there, I am not able to see the

01:18:44

deposit in here. ITC right nine

01:18:48

I will reduce that to zero and this I will completely

01:18:50

draw zero Is it interest paid finance

01:18:53

What is the

01:19:13

financing item

01:19:20

Here

01:19:37

check it brother check it check it brother

01:19:40

check it 2 3 4 2

01:19:56

Han ji please

01:19:58

return the check once Let's do the Proceeds

01:20:01

from Share Perfect

01:20:06

Redemption is zero

01:20:12

I had told you how to do Proceeds

01:20:14

from Repayment of Boring Repayment of

01:20:16

Boring

01:20:18

Process Not from Deposit Made it Zero

01:20:27

Dividend Tree

01:20:31

Financial Liability

01:20:34

Financial Liability

01:20:37

Income

01:20:40

Respect Finance Items Sorry there is a

01:20:57

little issue here.

01:21:00

[Music]

01:21:04

Divide this figure into a pig's stomach

01:21:12

and 32 OK

01:21:35

43 13580

01:21:45

Friend, I am telling you something which is freely

01:21:48

available, do

01:21:53

this, copy

01:22:08

2238 Investing Activities,

01:22:11

check immediately Investing Activities 2238

01:22:15

Perfect

01:22:17

15

01:22:27

My Financing Activity OK,

01:22:31

so different tree column. Whatever was mine,

01:22:34

where has it fallen now, we have to check, it is coming here,

01:22:36

okay, understand it is perfect, you have to

01:22:38

fix mine with Dividend Stomach, this will

01:22:41

give you an experience that you and this

01:22:44

Mata Patti, if you can't do it, then

01:22:45

brother. Don't study financial modelling,

01:22:47

don't join investment banking. This is

01:22:50

less daily for you. Literally means daily

01:22:52

less will be done. Do this thing

01:23:05

after different pet, take out the

01:23:09

finance activity.

01:23:29

Friend, take out the demat. Let's

01:23:34

export, open Excel,

01:23:39

enable this.

01:24:05

How to perform Puri statement of Supermart and

01:24:08

in the next session we will jump directly to DCF. The

01:24:28

file with solution is given below.

Description:

In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in FINANCIAL MODELLING as BEGINNER. It covers plotting 3 statements in financial modelling. I will guide you on how to prepare 3 statement model in excel step by step. Like our previous session in FULL COURSE on FINANCIAL MODELLING for BEGINNERS, it also breakdown everything in STEP BY STEP manner using LIVE PROJECT or EXERCISE file so you can PRACTICE it while watching this session (link below). FINANCIAL MODELLING in EXCEL is a crucial SKILL one must learn in order to make a CAREER in INVESTMENT BANKING, EQUITY RESEARCH, VALUATION, and other CORE FINANCE ROLES. By the end of this course, you will have a STRONG FOUNDATION in FINANCIAL MODELLING and be able to confidently CREATE FINANCIAL MODELS IN EXCEL to support decision-making in your professional life. Start your journey towards becoming a FINANCIAL MODELLING EXPERT now! You can connect with Parth Sir on Linkedin -https://www.linkedin.com/in/caparthverma 📥 DOWNLOAD the EXERCISE FILES - https://drive.google.com/drive/folders/1A5czajIixkn7tbp4bwnfjXf9x0_5uilF?usp=share_link 📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp community (TVS Mentoring) - https://www.facebook.com/unsupportedbrowser -------------------------- 👉JOIN: 🔥 NEXT LINKEDIN COHORT - https://rzp.io/l/uHTWYlSH 🔥 NEXT EQUITY RESEARCH COHORT -https://pages.razorpay.com/ERCohort4 -------------------------- ✅ You can connect with Parth Sir on Linkedin - https://www.linkedin.com/in/caparthverma ✅Follow The Valuation School page on Linkedin - https://www.linkedin.com/school/thevaluationschool ✅Join our Instagram handle - https://www.facebook.com/unsupportedbrowser ✅Join our Whatsapp Community - https://www.facebook.com/unsupportedbrowser

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.