DCF - Historicals From Felix
- 03:36
Historical figures are crucial for forecasting future DCF values. We use Felix to supply the real historical numbers for the company.
Transcript
Here we are looking at the DCF template and we can see quite a lot of this building's been done for us. It's relatively mechanical stuff here. So revenue is going to take last year plus a growth rate, but we need those last year figures. We need to go and find them from the company's real financial statements. And then the assumption, that growth assumption, we can get that on the assumptions tab. We're going to have to fill in all those figures ourselves. But let's start by trying to find those historical figures. So what I'll start by going to Felix, here I am on the front page. I'm going to click into the analyze section and type in a TI and I can find our company and it brings me to this categorized tab. That's a great place. I can find all of their financial statements here. If I click on this FY 2024, it would take me into the financial statements. I could then click on sections. I could then find the one I want, be it statement of operations or balance sheet or cash flow. I want to take a little bit of a shortcut instead of clicking on FY 2024. I'm gonna go over to the right side here, and I'm gonna just click on income statements. Here. I can see we've got their sales 4, 3, 6, 2 0.1. I'm gonna type that in 4 3 6, 2 0.1. Great. Unfortunately the company doesn't provide an EBITDA for me, but we do provide it in Felix. If I click on the valuation tab, and if I scroll down, you can see the EBITDA figure here is 7 2 9 0.1. Now remember, when you come in here at the date, you are looking at this, all of these numbers will have updated.
So it's 7 2, 9 0.1. I can go type that in.
CapEx and DNA. I want to get them from the cashflow statement. So I'm gonna go back to the categorized tab and where we're looking at financials. FY 24, I'm gonna click on the cashflow and my DN a's right there. It's 1 5, 1 0.5. Type that in. 1 5, 1 0.5. Great. Scroll down in my cashflow to cashflow from investing activities. Here we go. Purchases of PP and E 2 3, 9 0.1. That's my CapEx. 2, 3, 9 0.1. Great. Lastly, for OWC or operating working capital, I need to go to the company's balance sheet. So again, FY 2024, click on that balance sheet. Here it is. And the items I want to include, our accounts receivable, short-term contract assets, inventories, prepaid expenses, less accounts payable, and short-term contract liabilities. So really quickly if we have a quick look at these numbers. So 7 0 9 0.2 is the first number, then 75.6, we need to go put all of that into Excel.
And here it is. I've typed all those numbers in those first four numbers. 1, 2, 3, 4, and then subtracted off the accounts payable and the short term contract liabilities. And the last one to subtract off was the other current liabilities. That's the other one I included of 2 4 9 0.6 minus 2 4 9 0.6. So I've got my free cash flow in the previous year. Amazing. Now I just need to work out my free cash flows going forward, which means going to the assumptions tab.