Stock Valuation (Weighted)

DB Stock Valuation Weighted

The Primary Ambition of the DB Stock Valuation Weighted is to enable the investor to access within 15min the approximate reasonable price of a particular stock.

This is accomplished by using existing procedures created by notorious investors and here used in the most automatic way attainable without subscription fees.

The models used are:

DDM (Dividend Discount Model)

PE (Price to Earning Model)

EPV (Earning Power Value Model)

Graham (Graham Number Model)

DCF (Discounted Cash Flow Model)

The above then can be weighted according to the investor preference and objectives.

The Secondary Ambition of the spreadsheet is to graphically convey the most important data rescued from the financial statement of a particular company.

This is achieved by using traditional charts summarized on a dashboard where the investor can review and analyse the financial health of the business.

The charts will convey:

Cash Flow from Operation Activities

Cash Flow from Investing Activities

Cash Flow from Financial Activities

Chance in Cash

Dividend Paid

Free Cash Flow

Stock Price

Revenue

Net Income

Margin

Total Assets

Total Liabilities

Equity

Etc.

There are also shopping carts that will light up if a positive parameter is achieved according to adjustable principles.

The data.

The data is downloaded from a specific website and adjusted to avoid 99.9% of potential errors.

However, the procedures are straightforward and that is explained in an accompanying Video Series.

Note:

The spreadsheet is not perfect, however, it is very useful to set interesting target prices for long and short portfolios.

There are stocks that do not contain all relevant data to allow calculations to be made. There are certain things that can be done to overcome this lack of data, this will be covered in the Video Series.

The spreadsheet is not a recommendation to BUY or SELL assets.

With all the above said, the investor using the DB Stock Valuation Weighted