Originally published: 21/07/2020 07:47
Last version published: 05/04/2022 10:29
Publication number: ELQ-77531-12
View all versions & Certificate
Last version published: 05/04/2022 10:29
Publication number: ELQ-77531-12
View all versions & Certificate
Fair Value Calculation On A Click (FREE VERSION) - Windows/MacOS
It enables you to do a automatic Fair-Value calculation according the DCF- and PE-Method within less than 2 minutes for
Description
It enables you to do a automatic Fair-Value calculation according the DCF- and PE-Method within less than 2 minutes for over 5000 stock titles
This Excel-Sheet / Program "for free" has full functionality with the following exceptions:
- a maximum of 3 Fair Values can be calculated per day - otherwise there is no restriction
Features:
- Flexible selection from over 5000 stock titles
- Calculation of the Fair-Value according to the DCF-method (Discounted Cash Flow)
- Calculation of the Fair-Value according to the P/E-method (Price / Earnings)
- Explanation of the calculation, key figures and basic data
- Override option for the earnings growth rate
- Override option for the free cashflow growth rate
- optionally formatted PDF output
- Selection of the stock title by ticker, title, index, sector, industry, number of employees
- Detailed description of the stocks
Stocks from:
USA, Germany, Austria, Switzerland, Canada, Australia, Japan, South Korea, Hong Kong, China, France, Italy, Great Britain, Ireland, Norway, Finland, Denmark, Netherlands, Belgium, Spain, Portugal, Czech Republic
Installation and implementation
"Unpack all file contents (program, XLSX templates, readme.txt) in a separate folder.
Control and input parameters are entered in the XLSX ""LevermannInput.xlsx"".
Output of the results in the XLSX ""LevermannScorex.xlsx"" and optionally as a PDF in the folder where the program is located."
Explanation - LevermannInput.xlsx
"The stocks for which the FairValue is calculated are selected here.
In COLUMN A, ticker symbols are given for the stocks for which the calculation should be done. For stocks <> USA
the corresponding country code with "".XY"" must always be used - for an overview of the stocks with ticker symbol see
Worksheet ""Stocks"".
In COLUMN B the earnings growth value can be overridden - e.g. in the case of acquisitions in the current year,
these values can be significantly misleading - in these cases it is better to use a manual realistic growth value
In COLUMN C, the free cash flow growth value can be overridden - the same applies as in COLUMN B.
The parameter in CELL F1 can be used to control whether the ticker symbols in COLUMN A should be deleted after processing
or not (if J / Y the ticker symbols are deleted after processing - if N the symbols remain unchanged and can be used
again in the next calculation).
The parameter in CELL F2 is used to control whether the score should be outputed as a formatted PDF - it is outputed in
the folder where the program is started (if J / Y make pdf-output - if N not output)"
Disclaimer: As the programs obtain data from online resources and if, for unlikely reasons, these online resources should no longer be available, then of course these programs can no longer be used or no longer work.
It enables you to do a automatic Fair-Value calculation according the DCF- and PE-Method within less than 2 minutes for over 5000 stock titles
This Excel-Sheet / Program "for free" has full functionality with the following exceptions:
- a maximum of 3 Fair Values can be calculated per day - otherwise there is no restriction
Features:
- Flexible selection from over 5000 stock titles
- Calculation of the Fair-Value according to the DCF-method (Discounted Cash Flow)
- Calculation of the Fair-Value according to the P/E-method (Price / Earnings)
- Explanation of the calculation, key figures and basic data
- Override option for the earnings growth rate
- Override option for the free cashflow growth rate
- optionally formatted PDF output
- Selection of the stock title by ticker, title, index, sector, industry, number of employees
- Detailed description of the stocks
Stocks from:
USA, Germany, Austria, Switzerland, Canada, Australia, Japan, South Korea, Hong Kong, China, France, Italy, Great Britain, Ireland, Norway, Finland, Denmark, Netherlands, Belgium, Spain, Portugal, Czech Republic
Installation and implementation
"Unpack all file contents (program, XLSX templates, readme.txt) in a separate folder.
Control and input parameters are entered in the XLSX ""LevermannInput.xlsx"".
Output of the results in the XLSX ""LevermannScorex.xlsx"" and optionally as a PDF in the folder where the program is located."
Explanation - LevermannInput.xlsx
"The stocks for which the FairValue is calculated are selected here.
In COLUMN A, ticker symbols are given for the stocks for which the calculation should be done. For stocks <> USA
the corresponding country code with "".XY"" must always be used - for an overview of the stocks with ticker symbol see
Worksheet ""Stocks"".
In COLUMN B the earnings growth value can be overridden - e.g. in the case of acquisitions in the current year,
these values can be significantly misleading - in these cases it is better to use a manual realistic growth value
In COLUMN C, the free cash flow growth value can be overridden - the same applies as in COLUMN B.
The parameter in CELL F1 can be used to control whether the ticker symbols in COLUMN A should be deleted after processing
or not (if J / Y the ticker symbols are deleted after processing - if N the symbols remain unchanged and can be used
again in the next calculation).
The parameter in CELL F2 is used to control whether the score should be outputed as a formatted PDF - it is outputed in
the folder where the program is started (if J / Y make pdf-output - if N not output)"
Disclaimer: As the programs obtain data from online resources and if, for unlikely reasons, these online resources should no longer be available, then of course these programs can no longer be used or no longer work.
This Best Practice includes
2 Excel-Sheets, 2 Readme.txt, 1 Program