From the course: Excel for Investment Professionals
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Compute rolling P/E and P/B multiples for a stock - Microsoft Excel Tutorial
From the course: Excel for Investment Professionals
Compute rolling P/E and P/B multiples for a stock
- [Instructor] Investors often select stocks based on various valuation multiples, or metrics, like PE ratios, but you want to compute a set of historical ratios for your firm over time to give you a better sense for whether a particular stock is cheap or not. The problem is that these ratios or multiples will change over time as the company changes. Let me show you what I mean. I'm in the 02_04_Begin Excel file. Now what I've got here is data for Microsoft, and we have this data running from April 1st, 2014, through September 28th, 2018. We've got the closing price for this data. In addition, I've gone through, and gather data on Microsoft's number of shares outstanding, net income, which is essentially their profit, their total sales or revenue, and the book value of the stock, or the book value of the company for every single date here. So on March 31st, 2014, for the first quarter of 2014, Microsoft had in our parlance 8,260 shares. Now in reality, these numbers will be in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Setting up time series data on a stock2m 53s
-
(Locked)
Computing holding period returns4m 31s
-
(Locked)
Computing time series momentum: Market timing3m 45s
-
(Locked)
Compute rolling P/E and P/B multiples for a stock4m 57s
-
(Locked)
Building a discounted cash flow model4m 57s
-
(Locked)
Building a dividend discount model4m 35s
-
(Locked)
-
-
-
-