How to split cells in excel 2016
3:21
Пікірлер
@Hasentora
@Hasentora 11 күн бұрын
Very nice videio
@onlineacademy4079
@onlineacademy4079 Ай бұрын
Thank you so much due to your videos i have passed my dissertation. Thank you so much again for explaining
@oualidakaaboune8327
@oualidakaaboune8327 3 ай бұрын
Thanks for thé vidéo,please Can you do the same with SPSS
@ngan1829
@ngan1829 3 ай бұрын
Hi, I have a problem with the latter command, which starts from gen Jones_1995_TAC to drop r}}, every time I executed it, it gives no observation r(2000) error. Can anyone help me figure out what I am doing wrong please gen Jones_1995_TAC=. forval y = 2009(1)2022{ forval i = 1(1)10{ display `i' display `y' reg TACC_2 term1 term2 term3 if `i'==Industry_code&`y'==year, noconstant predict r if `i'==Industry_code&`y'==year, resid replace Jones_1995_TAC2=r if `i'== Industry_code&`y'==year drop r } }
@shahbazh2530
@shahbazh2530 3 ай бұрын
walaikumAssalamWarahmatullahiWabarakatuhu
@shahbazh2530
@shahbazh2530 3 ай бұрын
Walaikum Assalam
@oluwafemisamsonbalogun9575
@oluwafemisamsonbalogun9575 4 ай бұрын
Hi, thanks for your exciting video. how can you state for this:Let's proceed with a detailed, simplified example using the Modified Jones Model to assess the financial reporting quality of a hypothetical listed deposit money bank in Nigeria. ### Simplified Example Using the Modified Jones Model #### Data for Bank ABC (Hypothetical): - **Net Income (NI):** ₦300 million - **Cash Flow from Operations (C):** ₦200 million - **Total Assets last year (\(A_{t-1}\)):** ₦2 billion - **Revenues this year (\(\text{REV}_t\)):** ₦1,500 million - **Revenues last year (\(\text{REV}_{t-1}\)):** ₦1,400 million - **Receivables this year (\(\text{REC}_t\)):** ₦100 million - **Receivables last year (\(\text{REC}_{t-1}\)):** ₦80 million - **Property, Plant, and Equipment (\(PPE_t\)):** ₦600 million ### Step-by-Step Calculation 1. **Calculate Total Accruals (TA):** \[ \text{TA}_t = \text{NI}_t - \text{CFO}_t = ₦300m - ₦200m = ₦100m \] 2. **Normalize Total Accruals by Total Assets from Last Year:** \[ \frac{\text{TA}_t}{\text{A}_{t-1}} = \frac{₦100m}{₦2,000m} = 0.05 \] 3. **Calculate Change in Revenues (ΔREV):** \[ \Delta \text{REV} = \text{REV}_t - \text{REV}_{t-1} = ₦1,500m - ₦1,400m = ₦100m \] 4. **Calculate Change in Receivables (ΔREC):** \[ \Delta \text{REC} = \text{REC}_t - \text{REC}_{t-1} = ₦100m - ₦80m = ₦20m \] 5. **Estimate Non-Discretionary Accruals (NDA):** Using simplified coefficients (\(\alpha = 0\), \(\beta_1 = 1\), \(\beta_2 = 0.1\)): \[ \text{NDA}_t = \left( \frac{\Delta \text{REV}_t - \Delta \text{REC}_t}{\text{A}_{t-1}} ight) + \beta_2 \left( \frac{\text{PPE}_t}{\text{A}_{t-1}} ight) \] Substitute the values into the equation: \[ \text{NDA}_t = \left( \frac{₦100m - ₦20m}{₦2,000m} ight) + 0.1 \left( \frac{₦600m}{₦2,000m} ight) \] \[ \text{NDA}_t = \left( \frac{₦80m}{₦2,000m} ight) + 0.1 \left( \frac{₦600m}{₦2,000m} ight) \] \[ \text{NDA}_t = 0.04 + 0.03 = 0.07 \] 6. **Calculate Discretionary Accruals (DA):** \[ \text{DA}_t = \frac{\text{TA}_t}{\text{A}_{t-1}} - \text{NDA}_t \] \[ \text{DA}_t = 0.05 - 0.07 = -0.02 \] ### Interpretation of the Results: - **Total Accruals**: The normalized total accruals are 0.05. - **Non-Discretionary Accruals**: The normalized non-discretionary accruals are 0.07. - **Discretionary Accruals**: The discretionary accruals are -0.02. A negative discretionary accrual suggests that there is a degree of earnings management, potentially indicating manipulation to understate earnings. Conversely, if the discretionary accruals were positive and significantly large, it might suggest earnings inflation. ### Conclusion: By breaking down the financial data of a hypothetical Nigerian bank into total, non-discretionary, and discretionary accruals, you can
@maleeshagimhani-wt9jt
@maleeshagimhani-wt9jt 4 ай бұрын
Can I do this calculation using E-views instead of STATA?
@purnenduMP
@purnenduMP 4 ай бұрын
very good
@HananeHanane-jw1qj
@HananeHanane-jw1qj 5 ай бұрын
فيديو فاشل
@folasadeolasehinde1245
@folasadeolasehinde1245 6 ай бұрын
Hello Mr. Abobaker, please I sent you several emails, still waiting for your response. Kindly check and revert. Its help needed on your EM videos especially the do file commands. Thank you.
@folasadeolasehinde1245
@folasadeolasehinde1245 7 ай бұрын
Thank you for this video, please can I have the files, espcially the commands to be used on Stata. Thank you
@Zaidiiiiii_7
@Zaidiiiiii_7 7 ай бұрын
In which software you are entering these commands ???
@earningsmanagementestimati6028
@earningsmanagementestimati6028 7 ай бұрын
Stata
@LujainKarim-ty2ll
@LujainKarim-ty2ll 8 ай бұрын
السلام عليكم. لو ممكن طريقة حساب نموذج جونز من اول لم اجد الفيديو. وهل يكون التحليل تسلسل زمني ام panel ؟على العلم ان بيانتي ربع سنويه كيف يمكنني التحليل? شكرا
@earningsmanagementestimati6028
@earningsmanagementestimati6028 7 ай бұрын
نعم ما في مشكلة ان شاء الله ، الفيديوهات منوفرة على القناة باللغة الإنجليزية ، لو اردت المساعدة في عملية الاحتساب ارسلي الداتا والمطلوب على الايميل ،،،
@TheFiras1974
@TheFiras1974 8 ай бұрын
روووووووعة روووووووعة روووووووعة ❤ احسنت ❤
@DjakaliaOUATTARA-s6z
@DjakaliaOUATTARA-s6z 9 ай бұрын
Hi Professor. Thank you for this interesting video. I have a question. I want to estimate a simultaneous equations model, but one dependent variable is a discrete variable with three categories. I want to applied an ordered probit to model it. How can I process to estimate this kind of model? Thanks
@sadiaislamtaspia3214
@sadiaislamtaspia3214 10 ай бұрын
Can you share the Do File please
@ankitaagarwal4855
@ankitaagarwal4855 11 ай бұрын
Hey thank you for this video, it's really helpful but you have done this analysis for cross-sectional data but I want to run it for panel data. So please can you suggest me how the code will change.
@haseenazaib9926
@haseenazaib9926 11 ай бұрын
Hello, can you send me the do file so that I can use it in my research analysis.
@hossainaisjust
@hossainaisjust 11 ай бұрын
Subscribed! Can you share the code?
@TonyFernandes17
@TonyFernandes17 Жыл бұрын
How to export all items. It only exports 3000
@باسمخلفحسينالمحمداوي
@باسمخلفحسينالمحمداوي Жыл бұрын
ارجوا المعادلة
@EasyLearningMMA
@EasyLearningMMA Жыл бұрын
Q1: How can i find out my endogenous variables? as one test is showing them as endogenous and other showing them not. how to verify it?? Q2: how to test combinely (collectively ) endogeneity in model as i have apply gmm for my analysis as other fe/re is not suitable. i have no prob of hetro and auto.
@A.H_610
@A.H_610 Жыл бұрын
Hello Dr I just wonder where can I find the video for calculating the 4 parts first as this is where I am stuck.
@renudevi327
@renudevi327 Жыл бұрын
hello sir could you please share your email id or linkedin Id ??
@renudevi327
@renudevi327 Жыл бұрын
Sir, why you have deleted earnings management videos seriously it was useful for all of us
@renudevi327
@renudevi327 Жыл бұрын
hello sir, why you have deleted your videos it was really very useful
@naveedazeem4296
@naveedazeem4296 Жыл бұрын
Hello, sir. I find it extremely valuable for comprehension. Could you kindly provide me with the DO files for calculating discretionary accruals ?
@anikachhillar4615
@anikachhillar4615 Жыл бұрын
this doesn't work when you have 40 sheets to merge
@amanspeaks8649
@amanspeaks8649 Жыл бұрын
AOA very informative lecture. Plz sir send me do file concerned theses estimation of earning management .
@BhaktiAnand
@BhaktiAnand Жыл бұрын
Thank you!!!
@phshorooqqaz6541
@phshorooqqaz6541 Жыл бұрын
شكرا 👍
@dudana53
@dudana53 Жыл бұрын
Hi how to add ,many significance star level in the table?
@nematoda4788
@nematoda4788 Жыл бұрын
it seems that asdoc cant be downloadad on my side
@sakshikhurana312
@sakshikhurana312 Жыл бұрын
Thank you so much for making this video. God bless you.
@이형권-v5p
@이형권-v5p Жыл бұрын
Hello, I have a question after watching the video. I will use the current Stata program to estimate random reserves using the Jones 1991 or 1995 model. I saw "Jones model 1991 estimation" and "Jones model 1991 estimation by industry and year" among the videos you posted." If I try to estimate discretionary accruals through cross-sectional analysis by industry-year, can I do it like a secondary video?? I wonder what you got in video 1 and what you got in video 2. Please understand that the message is weird because I am not good at English.
@이형권-v5p
@이형권-v5p Жыл бұрын
Hello, I have a question after watching the video. I will use the current Stata program to estimate random reserves using the Jones 1991 or 1995 model. I saw "Jones model 1991 estimation" and "Jones model 1991 estimation by industry and year" among the videos you posted." If I try to estimate discretionary accruals through cross-sectional analysis by industry-year, can I do it like a secondary video?? I wonder what you got in video 1 and what you got in video 2. Please understand that the message is weird because I am not good at English.
@SalehMohammedAalsharmah-vj4tz
@SalehMohammedAalsharmah-vj4tz Жыл бұрын
Dear Abo bakhir Thanks so much for your helpful videos on REM. Would you kindly share with me the stata codes. Also would record this video with your voice so that we can all understand it better. Thanks again
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
I would love to help, however I am busy at the moment. I might try in the future.
@trinhquocdat8061
@trinhquocdat8061 Жыл бұрын
If I use a different IV package, the results confirm the endogeneity problem. How would I confirm the situation?
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
If endo confirmed, you may need to run the 2SLS.
@aniruddhaghosh9823
@aniruddhaghosh9823 Жыл бұрын
Sir what is this ABS_AEM, l.ABS_AEM and l.ROA . Can you please clarify
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
ABS_AEM is the absolute value of EM
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
l.ABS_AEM is the lagged value of Em
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
Same for l.ROA, the lagged valve of returns on assets
@shayankhan1264
@shayankhan1264 Жыл бұрын
hello sir i am working on co2 emission , corporate governance and firm performance my dependent variable is co2 independent is corporate governance and firm performance is control variable ho to find out instrumental variable from my data set to solve endogenety issue
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
Use the one or two lagged value of your variables
@HarmonieYang
@HarmonieYang Жыл бұрын
Can you show lists of indexes and names of companies?
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
I think you can
@MaysamAyoub-yw5jf
@MaysamAyoub-yw5jf Жыл бұрын
Hello, thank you so much for the useful videos. I tried to the jones model as shown below but nothing is changing in my dataset: egen industry = group(SICCategory) gen Jones_1991 = . forval y = 2011(1)`2021' { forval x = 1(1)`9'{ display `i' display `y' reg Dependent beta_one One_over_TOTASS ROA_Net_IncomeLagged INFLATIONLAGGED GDPLAGGED if `i'== industry & `y'== YearEnded, noconstant predict r if `i'== industry & `y'== YearEnded, resid replace Jones_1991 = r if `i'== industry & `y'== YearEnded drop r } } Could you kindly let me know what's wrong with this code? Thank you so much in advance
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
I think you emailed me, but I am sorry couldn't get back to you as I have no free time at the moment.
@talharehman9458
@talharehman9458 Жыл бұрын
Your video is a gem.
@nourahharara9375
@nourahharara9375 Жыл бұрын
Hi sir , can we download dividend for an entire country one time ?
@AkashYadav-hc3gn
@AkashYadav-hc3gn Жыл бұрын
Is it possible to export more than 3000 observations
@user-wasswass
@user-wasswass Жыл бұрын
When i try to evaluate the impact of X(indep var) on EM, should i use the residuals as a Y (dependant) variable ?
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
Exactly, that is what you need to do.
@user-wasswass
@user-wasswass Жыл бұрын
@@earningsmanagementestimati6028 شكرااااااا بارك الله فيك
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
أجمعين يارب العالمين
@farahkhlif6610
@farahkhlif6610 Жыл бұрын
good evening sir, first of all I would like to thank you for your efforts to help us. I have a question, in my case the dependent variable is AEM and the independent variable is ESG, the exogenous variable is still AEM? I have to calculate the lagged and look in the correlation matrix to find other IVs like in the video? Thank you
@earningsmanagementestimati6028
@earningsmanagementestimati6028 Жыл бұрын
Hi AEM takes place after the end of the fiscal year. Therefore, ESG in a given year is more likely to be a reaction to the AEM of the previous year, not the same year. Therefore, in your equation ESG for a firm i in a year t should be regressed on AEM for a firm i in year t-1 and other control variables. In this case, you will avoid or fix the endogeneity issue.
@user-wasswass
@user-wasswass Жыл бұрын
thank u very much . a very helpful video