Excel FDS Formulas 2.

We're going to use the sidebar to complete a simple comps table for three software companies. And we've got their tickers here all ready, and we want to pull in the latest enterprise value at this date, and CY1 EBITDA, and CY2 EBITDA, and that's using the references here. Then we can use that information to calculate the multiples. So first thing I'm gonna do is to get the enterprise value, so I'm gonna open the sidebar from the FactSet menu, and I'm gonna choose Insert. Now, first we need to input the identifier, and I could choose Apple's identifier by searching for it, but if instead I click on this cell reference option, I can then select the cell reference in the sheet that shows Apple's ticker, and that's what I'm gonna do. And then I'm gonna click Okay. So that means it will actually use that cell reference in the formula. And now the data item is going to be enterprise value. So I'm gonna go to Financials, I'm gonna select FactSet Fundamentals, and I'm also gonna select FactSet Estimates for later on, and I'll deselect everything else.

So Enterprise Value, I've got up at the top here, I don't want the ratios, I just want Enterprise Value Daily. So I'm gonna select that. It then gives me some options there which aren't relevant now, but at the moment it's showing the start date as the Latest Completed Period. And I'm gonna change that, I'm gonna click on the date box, and I'm then gonna select the date from the cell reference in Excel, and then click Okay. I don't want a time series, so I'm not gonna put in an end date. And the currency at the moment is showing as Local currency, but I'm gonna specify US Dollars.

I can then specify how enterprise value is calculated. I do want it to use Diluted Shares, and I do want it to include Minority Interests. For Date Alignment, I'll just leave that as Default. And then I'm gonna choose Insert, and if I click on the formula, you can see it's referenced cell B9. Now it's unusual because it puts the B9 between ampersand and then in quotes. And the reason for that is that actually most of the formula is text, and those quotes and ampersand convert the reference into text. Now I'm gonna absolute reference that date reference because I want to be able to copy this formula down the spreadsheet.

So if I go in and then refresh the worksheet, FactSet will do its magic, and it now pulls the data down for all three companies.

Now we're going to do CY1 EBITDA. So let me just clear the sidebar. And again, for the ID, I'm going to choose a cell reference for Apple as before. Then for the data item this time I want Consensus Estimates. And I'm gonna choose the Consensus Estimates for EBITDA, and then I have to choose a fiscal year or calendar year. I want a calendar year, and I want the Latest Available, and I don't want a time series. I want US dollars, and I don't need an exchange rate there. So I'm now ready to insert that data. And then I'm just gonna close the sidebar because it does slow the machine a little. Now you can see here this is picking up the ticker in the formula, and what I want to do is now to absolute reference that ticker, but not the whole reference this time, I just want to absolute reference the column reference. So this time the dollar sign is now just gonna be in front of the column reference. Then what I'd like to do is to absolute reference 1CY from the cell above, because you can see that in the formula it's got 1CY there, and I wanna replace that with what's in the cell reference. Now, to do this properly, we have to convert that into text using quotation marks and then an ampersand, and then I'm gonna click on the reference, and then I'm gonna press F4 twice, so we now have an absolute reference just on the row reference. Then we need another ampersand, and then another quote marks, and that then converts that into text. Then if I copy this formula down into the right, what it will hopefully do is to pull in 1CY and 2CY into the formulas so that we have the CY1 EBITDA, and CY2 EBITDA for Apple there. And you can see that's now pulling in, and I know it's a bit strange that Apple's EBITDA is declining through the forecast, but that's just what FactSet has in their system at the moment. So I'm just gonna refresh that data, and you can see it's now pulling in the other information for the other companies as well. And then I can go ahead and I can then calculate the multiples. The multiples for all three companies, and for both years. And all of this data is in US dollars, and the earnings are calendarized.