Zoom Logo

How to value a business? - Shared screen with speaker view
Ketaki Kulkarni
04:58
received the excel sheet. thank you
Ketaki Kulkarni
21:44
is there any widely accepted pattern for highlighting input cells in yellow?
Ketaki Kulkarni
22:14
ok thanks
Harsh Manu Jindal
43:27
Yes Mam
Harsh Manu Jindal
59:27
We are removing the financial risk part from the beta and get the beta that covers business risk only
Ketaki Kulkarni
01:01:15
helpful model and nice excel sheet. yesterday, my question was 'if we take out the impact of debt, the unlevered beta will give us unlevered WACC. is it of a significant use for the company to analyse? or is it choice based for the analyst- that he can choose to look at either of them'.
Ketaki Kulkarni
01:01:20
yes. clear
Ketaki Kulkarni
01:03:41
so we should go by the situation, looking at the debt level, and decide equity or asset beta. thanks
Ketaki Kulkarni
01:03:50
thanks a lot
Harsh Manu Jindal
01:20:54
We check credit rating of the company and corresponding credit spread?
Harsh Manu Jindal
01:21:27
okay mam
Harsh Manu Jindal
01:23:56
portion of cheaper capital is increasing
Harsh Manu Jindal
01:25:09
yes
Harsh Manu Jindal
01:26:54
bcz we will discount the cashflow using wacc
Harsh Manu Jindal
01:29:27
okay
Prof. Prachi Ganu
01:46:56
hi all!
Ketaki Kulkarni
01:55:26
11.55%
Ketaki Kulkarni
01:56:21
10.90
Prof. Prachi Ganu
02:12:22
FnF4
Prof. Prachi Ganu
02:13:40
FnF4 = lock cell
Ketaki Kulkarni
02:49:09
EV yes
Ketaki Kulkarni
02:50:01
clear. thanks
Ketaki Kulkarni
02:54:55
yes
Ketaki Kulkarni
03:01:30
yes
Ketaki Kulkarni
03:04:08
same
Prof. Prachi Ganu
03:09:46
1/(1+r)^(t-0.5)
Ketaki Kulkarni
03:14:24
yes
Harsh Manu Jindal
03:27:23
YES
Ketaki Kulkarni
03:33:05
very useful excel model. benefitted from this weekend course. is risk return matrix also calculated in excel using a same method, like this sensitivity table? and also could you please state if we can make the use of this sensitivity table to make a plot like the variance- covariance matrix is used to make a plot? I don't know what would a scatterplot with WACC on one axis and terminal growth rate on the other axis would denote? do any analysts make such a line or scatter plot?
Harsh Manu Jindal
03:39:44
mam do we have a website where we can find analyst call minutes
Harsh Manu Jindal
03:39:56
or something like that
Harsh Manu Jindal
03:40:10
okay mam
Prof. Prachi Ganu
03:40:44
screener.in
Prof. Prachi Ganu
03:40:51
IBEF - Industry reports
Prof. Prachi Ganu
03:42:51
thank you everyone!!