Publications by Nico
China Screener
1 Stock Screener 2 Risk Premium 3 Businesses 3.1 Excess Returns 3.2 Capital Structure 4 Industries 5 Data China data sets 6 References Optimal Capital Structure Risk Premium ...
206 sym
India Screener
1 Stock Screener 2 Risk Premium 3 Businesses 3.1 Excess Returns 3.2 Capital Structure 4 Industries 5 Data India data sets 6 References Optimal Capital Structure Risk Premium ...
206 sym
Brazil Excess Returns and Capital Structure Analysis
1 Stock Screener 2 Risk Premium 3 Businesses 3.1 Excess Returns 3.2 Capital Structure 4 Industries 5 Database Brazil data sets 6 References Optimal Capital Structure Risk Premium ...
212 sym
Walkthrough: Valuation - WACC DCF
1 Objective Our goal is to extract all info pertaining to calculating wacc and performing dcf analysis from each workbook and enter pulled tables and calculations into a named list. When finished it should look like the following: Our first step will be to set the dcf list up and name each element we are looking to pull from the sheet or calcula...
11286 sym R (11609 sym/35 pcs)
Walkthrough: Commentary
1 Objective Our goal is to extract the commentary from each workbook as well as valuation summary tables and enter them into a named list of values, lists, and tibbles. We will extract and clean the data for each section and, when finished, it will match the following: 2 Risk Classification, Valuation Impairment, Conclusion, and Strengths & Conc...
11731 sym R (12628 sym/33 pcs)
Walkthrough: Valuation - MA Comparables
1 Objective Our goal is to extract the M&A comparables table from each workbook and transform it into a list of vectors that each contain all the observations corresponding to a heading. When finished it should look like the following: 2 Isolating the Data To start, we need to isolate the table of cells containing the headings and corresponding ...
3467 sym R (1880 sym/6 pcs)
Walkthrough: Valuation - Public Comparables
1 Objective Our goal is to extract the public comparables table from each workbook and transform it into a list of vectors that each contain all the observations corresponding to a heading. When finished it should look like the following: 1.1 COMP1 1.1.1 Insurance Brokers 1.2 COMP2 1.2.1 Insurance Brokers 1.2.2 Asset Management / Wealth Advi...
5785 sym R (7582 sym/16 pcs)
Walkthrough: Valuation - Trading Levels
1 Objective Our goal is to extract the trading levels of company securities table from each workbook and transform it into a list containing lists that detail the properties of each security. When finished it should look like the following: 2 Isolating the Data To start, we need to isolate the table of cells containing the properties and corresp...
2350 sym R (1679 sym/4 pcs)
Walkthrough: Valuation - Financial Performance
1 Objective Our goal is to extract the Long Term Financial Performance table from each workbook and transform it into a vector of two vectors detailing financial performance and covenant ratios. When finished, our output should look like the following for COMP1 and COMP2: 2 Isolating the Data Our first step is to examine the workbook imported in...
6585 sym R (7044 sym/19 pcs)
Mexico Excess Returns and Capital Structure Analysis
1 Stock Screener 2 Risk Premium 3 Businesses 3.1 Excess Returns 3.2 Capital Structure 4 Industries 5 Data Mexico data sets 6 References Optimal Capital Structure Risk Premium ...
207 sym