Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • AI
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
    • What’s The Big Deal?
  • Pathways
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • NEW Signal AI
  • Topics
    • My List
    • Felix Guide
    • AI
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
    • What’s The Big Deal?
  • Pathways
    • Asset Management
    • CFA Institute
    • Commercial Banking
    • Credit Analysis
    • Engineering
    • Equity Research
    • Investment Banking
    • Operations
    • Private Equity
    • Restructuring
    • Sales and Trading
    • Venture Capital
  • Certified Courses
  • NEW Signal AI
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit Profile
    • Manage Account
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Glossary
    • Email Our Experts
    • Felix User Guide
    • Contact Support

AI-Powered Valuation with Rogo - Felix Live

A Felix Live webinar on AI-Powered Valuation with Rogo.

Unlock Your Certificate   
 
0% Complete

1 Lesson (60m)

Show lesson playlist
  • 1. AI-Powered Valuation with Rogo - Felix Live

    59:48

Prev: Market Series: Interest Rate Swaps - Felix Live Next: Coming Soon - Markets Series: Introduction to Corporate Bonds and CDS - Felix Live

AI-Powered Valuation with Rogo - Felix Live

  • Notes
  • Questions
  • Transcript
  • 59:48

A Felix Live webinar on AI-Powered Valuation with Rogo.

Downloads

READ ME FIRSTStudent GuideGuide-ruovzuigAI Powered Valuation SlidesLogitech Valuation Completed
Back to top
Financial Edge Training

© Financial Edge Training 2026

California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

Welcome, everybody.

We've got about an hour, and our aim today is to do a valuation. And on the webinar earlier, I did Logitech, but I actually prefer to do NVIDIA because I think it's more of an interesting case, particularly with the recent share moves.

And it's very easy to switch when you have Rogo at your disposal.

So heads up, I'm going to run through this, and it's going to be pretty much a descriptive session. You have got a student pack, which you can download from the online classroom.

I've changed the slides a bit because from this morning, I think we're going to do a lot less slides and just get into the meat of it, because I think that's actually much more useful for you to see. And the session will be recorded.

So let's get started. I'm going to share my screen first.

And you should be able to see my screen, and let me just quickly go to my slides.

One second.

There we go. Okay. So our aim today is we're going to build out a valuation for NVIDIA, and we're going to use Rogo to do that.

The two main methods we're going to use are trading comps and discounted cash flow.

I hope to be able to get to transaction comps, but I just don't think there's going to be enough time. So we'll do trading comps using the web app in Rogo, because that is easier to start off with, and I can set up a project and give it context and everything like that. But when we come down to a discounted cash flow version, what I prefer to do there is use the Excel add-in.

And the reason for that is that over time, most bankers I speak to about financial modeling in large language models like Rogo or Claude, is that actually you can't really rely on the LLM to do the modeling for you, because you just don't know what's in each line item. And as an analyst or an associate or even a vice president, you need to be able to be really sure of the formulas in each component. So as a consequence, it's much better when you're modeling to do it using the Excel add-in and then model in chunks. So you ask it to do free cash flows, for example. Check. Once it's done free cash flows, do terminal value. Check.

Once it's done terminal value, do discounting. Check.

Once it's done discounting, do the enterprise value to equity value bridge.

And if you do that, it means you can go through and you can check every single line item, adjust it without having it to do the whole DCF.

So I think the days of getting these models to do a whole DCF are just not here yet, if they ever will be, because you need to actually understand what's in the financials.

So we're going to be able to set up Rogo.

We're not just going to do it in Excel, we're also going to do it in the web app. So that's where I'm going to start, is Rogo in the web app.

So let me just go to Rogo in the web app.

And I'm just going to open a new chat initially so I get a clean screen.

Notwithstanding the issues with Microsoft today, which has been interesting.

The first thing I'll do is I'll set up a project.

So down at the bottom on the left-hand side, there's a little interface here.

Let me just walk you through some of these features. Got a search button.

You can click New Chat to generate a clean chat.

Search to be able to search your old chats.

Then you've got Chats, which will give you a history of chats.

Agents. Now in Rogo, you've got an agent, which could be, for example doing a valuation, whereas you have separately skills, which is doing a component of that.

So a skill could be building free cash flows, it could be building out a WACC or something like that.

So agents are more kind of an aggregated section of skills. Then you also have scheduled things that you can ask Rogo to do every morning. So if you're covering a company, for example, it's a really good thing for get Rogo to do a new screen every morning or a filing screen just to tell you what has changed overnight for that particular company. That's super helpful.

And then shortcuts are just where you can save things like prompts once you've created them and then pull them out.

A library gives you a list of all the things that you've created in Rogo.

And then intelligence gives you the ability...

It's kind of everything that you've done in Rogo and your ability to search it and understand what it knows about you and be able to pull the things out as a consequences of that intelligence about your work.

And then lastly, Tables. It's just like a comps grid where you type a company in and then you list, okay, these are the ratios I want for the company.

It could be valuation ratios, it could be margin ratios.

And then you type in other tickers, and it just populates out the table.

So I almost would describe it as a comps grid. Okay.

Let's jump in by going into Projects.

And if you have any questions, just put them in the chat.

I'm going to click on that just New Project here.

And for this exercise, I'm just going to call it NVIDIA Valuation.

Okay. And then you can add a deal code if you want to.

You've got different options about how you're kind of assessing this, whether it's general, sell-side, buy-side, client coverage, or equity research.

I'm going to choose General. That's fine.

And then I'm going to click Continue.

And then you can share the project. That's pretty useful.

And I'm just going to create a project. I'm not going to share it with everyone.

Now, before I go any further, one of the things I'd like to do, and something I skipped over, is the description of the project. Now, in Rogo- The description actually functions rather like the instructions in a Claude project. So I'm going to put in a prompt, and frankly, it's easiest to do a prompt for this.

So I'm going to ask it, "I am an investment banker, and I want to do a valuation," you don't actually need to worry about spelling, "for Nvidia, both trading comps and DCF. Please generate a description for this project." And when you do that, if you want to improve it, there's a few things you've got down at the bottom here.

You can use an agent, so you can actually just, for example, build a three-set model. There is a DCF agent, so we could've used a DCF agent. In fact, I may do that just in the background so you can see how that works. Then you can attach files, and you can attach files to the project as well. And then you can choose which sources it uses.

So if you wanted to literally just nail down one particular source, like for example, the SEC filings, you can do that. You can choose your internal sources, your projects.

Down here, you've got the ability to change the different models, and you've got the most main choices of Claude or Gemini.

And then here, this is pretty useful.

This is like the Harry Potter wand.

So if you click that, what will happen is it will just improve the prompt for you. So it looks at the prompt, and it should give us an improvement, and usually it makes it quite a bit longer.

And so there we go. You can see it's made it really significantly longer there.

So, in fact, that may have actually been the instructions or the descriptions. Let me just run that prompt.

While this is going on, I'm going to do a new chat here, and then I'm going to just do a DCF valuation because I just want you to see the difference.

So I'm going to ask it, "Build a DCF model for Nvidia." In fact, we can do trading comps as well. Let me just do trading comps.

If I do transaction trading comps, I'm sure they should have trading comps here. ST.

They don't. They have comps, is the problem. They often...

I can search agents, images, comps.

Public comps, there we go. Such an annoying name.

Oh, I only can use one agent. That's really annoying.

Let me do trading comps for Nvidia. There we go.

So I'm just going to run that because I just want to see it against what we're doing separately.

Yeah. It's taking long. There we go. Description. There we go.

So this you can see is quite detailed.

So I would always get the model to do that. So someone just asking, they can't locate projects in Rogo. It should be on the left-hand side of your screen.

It may be that your corporation hasn't got the full version of Rogo, and that's usually because of InfoSec compliance issues. Because what happens is not everybody has the latest. I've got the latest version of Rogo, so I have things that you may not have in. So if you can't see, the project should be on the left-hand side under those items here. You should have projects.

If you don't have it, it may well be that it's not set up in your version of Rogo, because not everybody's Rogo is the same, because banks like to have some control.

So I've just clicked Copy there, and then I'm going to go back to the project, and then I'm going to go to Project Settings, and then I'm just going to paste it in the description.

There we go. I'm just going to save that. So that is the same as instructions in Claude, the description. So I'm just saving that, and it says project updated. So just to be clear, everybody may not have projects just because of the setup for your internal version. Okay, so now we've got this set up, and I'm going to ask it to do trading comps first.

So I want to... And I didn't say I'm an investment banker because that's all in the description. It should already know that.

So develop a trading comps sheet for Nvidia and its peers.

Okay. And then if you just do want a soft return, Shift + Enter.

If you hit Enter, it will prompt. If you want a soft return, Shift + Enter.

Really good to know. Because although you can actually just write a stream of consciousness, it's much better for you to be able to mentally, and when you're doing prompting, literally do one after the other, after the other. So the thing is, I want to put in, "Use the following multiples," and we're going to do EV over CY 2 revenue. The reason I'm using CY 2 revenue is that we're in November already, and that means CY 1, which is 2026, we're pretty much through.

So the market won't use CY 1. It will look to CY 2 for valuation. And then I'll do the same thing But rather than use revenues, I'm going to do EBITDA.

Okay.

And then I also want some context here, and then also include CY2 EBITDA margins, because I kind of want to be able to see why one company's trading more than another.

And then a two-year forward-looking revenue growth CAGR. Okay? Because, and if you don't say things like forward-looking, it'll give you a historical-looking CAGR, and that's not going to drive the multiple historical growth, it's going to be the forward growth. Okay? So those are the things that we want. I'm just thinking if there's anything else.

I may say to it, if you want to have two groups of peers, that's fine.

Okay. So I'm going to do that. So Harry Potter wand, let's see if we can improve it, see how Rogo improves it.

And again, once you have finessed this, so my strong advice to you is that when you first start using things like Rogo and you are building out the ... And you build it out, the prompt, and you get the result and think, "Oh, that's not quite right," and you go back and you iterate back and forth, back and forth, back and forth, back and forth, back and forth, until you get something right. Once you've got something right, then at the very end say, "Okay, can you create a skill using this chat?" And that means you can always come back to this and it will create something that is kind of in your style and your methodology. So let's take a look at this.

That all looks good. Yeah, that's fine.

So they're doing direct AI and accelerated computing peers, brilliant, and then broader semiconductor peers. That's good.

And it's got our list there.

That's good. Oh, I should actually also put in here enterprise value, good. And the reason I want the enterprise value is I want to be able to see how large the companies are, okay, because that will affect how the multiple. So that all looks pretty good, so I'm going to run that.

Okay. And let's just see if the prior item I did, let me just see if that's ... Oh no, that was just the instructions, so let me go back to my chats.

Here. Let me just see if I can see it.

That NVIDIA trading comparables is still cracking on.

So very, very useful projects because you can give it context, you can upload files.

My sweet spot here is having a saved skill from when you've done this before and you've iterated and got the really fine-tuned skill, number one. Number two, if you want really good control, upload a template, and if you upload a template, it means it's going to look almost exactly how you want it.

Really, really helpful to do that, upload a template, because it really gives you control. So this stuff is going to keep cooking, so I'm now going to go back ... Well, not go back, go to Excel.

Now, I have done this before, but, so let me, this is for Logitech.

Let me just open a new blank classroom styles. And I'm just going to save as. Thank goodness my ... I'm going to just call this NVIDIA DCF valuation.

And I'm going to do this from scratch mostly because if I just did it using an existing skill, it would be pretty boring for you. So if you can see here, I've gone into Excel. If you don't have the Rogo add-in, it's pretty easy to add. You just go to the Home button, the home ribbon, and then you should see an item called Add-ins.

If you click Add-ins, you should be able to search add-ins.

Maybe a bit slow today because of what's going on with Microsoft, but you should be able to just, if I click on that, you should be able to type Rogo, and there we go. It should, and then you can just add it there.

So if you haven't got the Rogo add-in, just go to Add-ins and add it here.

Again, you may find that your corporate setup Rogo may be slightly different from the version I have.

I've got the latest version because this comes directly from Rogo.

But you can kind of, if you don't have it, don't worry, you will get it.

You're just seeing a little bit of the future. Yeah.

I've already added Rogo in here, so it is in my add-ins and I just can't see it now. Why are my add-ins gone? That's annoying.

Let me just come out of this menu and come back in.

Oh, this is annoying. May have just lost it.

Let me just put it in again. Sometimes when you first use the Rogo add-in ... Oh.

That is, I literally just had it. Let me just close this down.

That's very frustrating. Let me just quickly ... If this is the case, then unfortunately we may have to go back to the ... That's really, really annoying. Oh my gosh.

Okay.

I have just had a, because of the Microsoft issues, that is very frustrating.

Let me just see if I can search for it again.

Okay, let me just...

Oh, that's very frustrating. I'm so sorry.

Okay, so we're going to have to do this using the chat window.

Ideally, I would do it in Excel because it means I can see Rogo working. That is... I'm really sorry.

This is just because we had some issues because of the Microsoft outage earlier. I apologize for that. But let me...

I can work with the chat window. That's not a big deal.

It's just a shame because you can actually see it change.

So I'm going to go back to my project, NVIDIA valuation project, and then I'm going to start a new chat here.

So I'm going to ask it, I want to build a DCF in stages, starting with the free cash flows.

Okay? So the first steps that I'm going to do, number one, is forecast out the key line items for NVIDIA.

And the key line items that I'm going to use are going to be, firstly, revenues.

And I don't just want revenues, I want a bottom-up breakdown of the revenue forecast, okay? Because I want to be able to see actually how that's built up.

Particularly something like NVIDIA, you really want to see the underlying details of that. Then I'm going to do EBITDA, and then we're going to have to depreciation and amortization.

Then we've got working capital, the tax rate, CapEx, and that's most of what I need for NVIDIA. There may be other items like long-term deferred taxes, other items like that, but you need to choose what you want to put in there. But that's the most of it.

However, I'm not quite finished there.

And just by what I'm doing there, you don't need to do this in order.

The LLM, you can just write it in a long list of words.

But just when you're constructing it in your head, it's good visually to see.

And you can just do Shift+Tab to do those indents.

Or sorry, Tab to do those indents, and then Shift+Tab to go back out from an indent. So I want it to use consensus estimates for revenues and EBITDA for the first three years. Just be careful. Don't take the difference between the consensus EBITDA and EBIT to get your depreciation and amortization, because you'll get something that will move around too much. And I actually prefer either to take EBITDA or EBIT. I actually prefer to take EBITDA because it's more like, it's not cash, but it's closer to cash as those two metrics. And then I'm going to get Rogo to forecast depreciation and amortization, be able to get EBIT, and then go down through your free cash flows. So don't ever take consensus EBIT and consensus EBITDA and then take the delta.

The reason for that is that you will have different mixes and different numbers of analysts doing EBITDA in year one versus year three and EBITDA versus EBIT. So you just won't get something that is very consistent.

But generally, if you do revenue and EBITDA, that should be good. Okay ? And then forecast, make your own assumptions.

Then I'm also going to say, do a 10-year forecast, because this is all things that you want to put in.

Then, trend revenue growth down to 4% over the 10-year period. And what Rogo will do here, typically, is it will use a formula to do that, and sometimes that's a bit messy when it does that.

And then the other thing that Rogo will often do is it will put your free cash flows first, and then it'll put the assumptions below the free cash flows, which I find really irritating.

So put the assumptions above the free cash flows. Now, if you're thinking, "God, this is a bit laborious having to write all this in," it is a bit, frankly.

But once you've done this and you've got an output you really like, that's when you create the skill that you can come back to and apply again and again and again. And then, again, what I would do is use that Harry Potter magic wand just to improve this, because Rogo will look at it. And you can always put at the end of it, "If there's anything else you want to ask me, please ask me before you do the work." And that's a good thing to do before you do the work, because once you've hit go and it's prompting, it will take quite a long time to do.

Okay, so there we go. It's again with calculation, CapEx. There we go.

In capital. So it's got a lot more detail, as you can see.

So I've done that, and then I'm just going to press go there. Now, once it's finished here, what will happen is we'll be able to look at the result on the visualizer within Rogo without having to go to Excel. I don't really like the visualizer that much because it's more difficult to use. It's not Excel.

And I find it's better to be in Excel, and that's why I would have preferred to use the Excel add-in for Rogo.

But unfortunately, that has just been blocked because my computer had to be reset because of the Microsoft issues. So, the trading comps is still cooking there, and the DCF valuation that we set it up is cooking there as well.

So this will take some time To do here.

And so ideally, we could have gone to Excel and worked on it there.

But this is all we're doing in this step, is we're doing it the free cash flows. Because what I want to avoid happening is to build out the whole DCF.

And I know I've set a prompt up to do that, but if you do that, what will happen is you'll spend 20 minutes waiting for the output, and then you think, "Oh, that's wrong. I don't like that," or, "I want that moved." And then you've got to go through the whole rigmarole again.

So it's much better to do it step by step by step, and it's even better if you're doing it inside Excel.

Unfortunately, we can't do that. Let me just double-check.

Let me just quickly see if I can find in my 365 whether I can get Rogo in 365. I don't think I can do.

This is the online version of Excel, and I just want to see if I can get Rogo in the online version of Excel.

So let me just go in a blank workbook and see if I can get the add-ins here.

All the stuff with Microsoft today has been really crazy, right? So let me just Rogo. There we go. Let me see if...

Oh, okay. No. It's all been locked down for me.

That's very upsetting. Never mind. Okay.

So, we're still waiting for that.

Let me just show you while I'm waiting for this, because I don't want to waste any time. I'm going to go and open a new prompt, and I'm going to go and give me a detailed breakdown of NVIDIA's LTM EBITDA. Okay? And let me just improve that if I can. Sometimes you improve it, the prompts will take longer.

Because what I want to show you here is how you can see the audit trail, and there's something very good, and the visualizer is very good for the audit trail. But when you get the Excel version, it's less good because you can't click through an Excel version.

But in the visualizer, you can do. So that's something that is pretty useful for when you're doing that, is to build out, is to use the visualizer because you can then check, do an audit trail in the visualizer. Let's just see how these things are doing. Let me just see what's happening here.

Okay, this is being done.

So this is giving us information.

So NVIDIA's no valuation premium.

It trades at a discount to both peer groups, kind of what I expected, even though its growth margins are near the top of the set.

Trades at 6.9 times 2028 EBITDA, so that's 55%. And I always think when there's been something like the scandal, the CEO Jensen has just been fired, I guess, and the market has really reacted badly, and that's usually an overreaction.

Now, I'm not giving any investment advice here, but to me, this is a fast-growing company that is underpinning this huge investment, and it's only being valued at less than seven times 2028 EBITDA. Now, I know that's two years ahead, right? But still, that's pretty darn low.

So that seems to me... And if you look, there's some nice charts here.

The revenue CAGR and the multiples, so you've got NVIDIA down there.

And what it hasn't done here, it hasn't given us...

Oh, it has given a checking account. Brilliant. So I'm just going to open that.

And in this visualizer, you should, if I just come to the right here, let me just see if I've got...

Go to the inputs. And here, if I jump into one of these items here, let's say this NVIDIA, I should, if I click on this, be able to jump to the source.

Oh, it's just come from Broadcom. That's annoying.

So I could've said use actual sources, okay? If you'd asked it to use SEC, the prompt will have taken longer, but if you go to the visualizer and you click on Inputs, then you should be able to click on these items.

Let me just see if there's any other things.

This is all coming from Standard and Poor's.

Yeah, it's all going to be Standard and Poor's, which has been annoying.

But you can set it, if when you're doing a prompt, I'll show you in a moment, you can set the source so it's only SEC filings. In which case, you can have something much more reliable.

Then they've got the consensus, and then they've got the scatter diagrams there.

Let's open this. If I just click on that and open it, and then it will open it in Excel.

I might just choose Download. There we go.

And we can open in Excel. What you'll see in Excel, the audit trail is not quite as good, okay? So the audit trail in Excel will just be a comment. So if I go to Inputs here and I click on this cell and just do Shift + F2, enable editing first.

I'll do Shift + F2. It will give me the URL, but there's nothing I can click on. So it's actually you have to use the visualizer if you want to be able to click. But if you take a look at this, let's take a look at the- Multiples. Let me just freeze my pane. So the freeze panes is done.

So these are the revenue multiples and then the EBITDA multiples. You can see it's really...

Look at this, it's higher.

NVIDIA is lower than everybody, including Broadcom.

AMD is 20 times versus NVIDIA's 6.9 times.

Let's look at the fundamentals. NVIDIA's margin is 64.

I was kind of astounded when it's 64%.

That's extraordinary margin.

And Broadcom's got pretty good margins.

And the revenue CAGR, 51%. It's not the lowest there, but it's not the highest. But nevertheless, the valuation is so, so low.

AMD is about 61%.

Marvell Technology is higher.

Broadcom's higher, but Astrolabs and Credo Technology are lower.

So I do think that this looks pretty undervalued relatively when you're looking at trading comps. Now, what I haven't done is I haven't checked any of this. So if you're an analyst, you need to go through every single number, and that's why that issue of being able to click through is more challenging.

And ideally, I would have set it to SEC filings rather than S&P, because otherwise then I've got to go and check S&P.

So just watch that when you're doing a prompt about the sources you want it to use. But based on the trading comps, it definitely looks as though NVIDIA is undervalued.

Now, I hope if we go back, we should be able to see our other work if I go to the project here.

And we've got a 10-year DCF free cash flow. That's still working.

So while we're waiting on that, let's go to NVIDIA's LTM EBITDA and see what items they've got here.

So they've got the add back DNA, and then they've got the EBITDA margin.

And it doesn't say anything about the...

It doesn't actually have this. It's annoying.

But this is another good thing you can see.

This, you can actually see if I go to GAAP operating income here and I click on this, it takes me to 10-K. Unfortunately, it doesn't take me to the place in the 10-Q.

Let me just go to the calculated EBITDA, see if they've got a breakdown in their 10-K for EBITDA.

Now, see, it's not taking me to the place.

Let me just see if I can search EBITDA here.

Let me just see if they have an EBITDA.

No, it's not coming up with EBITDA. That's annoying.

But what you want to be careful with, if they're doing any other add backs here.

So what I'm going to do is do a double check. In fact, I'm actually going to check.

Let me ask it to put up. Please pull up the 8-K filing, 8-K press release related to the 10-K filing. Let me just, while it's waiting there, I'm actually going to go to our Felix platform because this should be in here.

No, that's the wrong one. That's not Felix. Let me quickly open Felix for you.

Because what I want to see, one of the really things you want to be careful about is stock-based compensation, because you don't want to add that back in a discounted cash flow because it's the cost of not existing dilution, but future dilution.

So if I just go to the latest 10-K filing and the press release for this.

I'm just going to go to the back of the press release because normally they have the non-GAAP earnings there. I just want to see if they give us non-GAAP numbers, free cash flow.

Let's just see if they do reconciliation revenue.

And then let me just see what they're adjusting for.

Stock-based compensation expense, GAAP operating expenses.

Yeah, so they are deducting this. Can you see that? So the non-GAAP operating income is 46,107 in 2026. Let me just see what they've done here. In fact, it may not be obvious.

If I go to the LTM 2026, they don't have the breakdown. That's really annoying.

So 201, what did we have previously? We had...

Is that the EBITDA? So that's 46,107.

These seem to be completely different numbers.

July. Oh, this is the LTM. That's why. We don't have a year-end.

Let me just ask it. Are you adding back stock-based comp to get EBITDA? Because that's something you want to really watch out for.

And this is the problem when you're doing this in the browser because you can't see the breakdown.

We could have asked it to actually give us a breakdown.

No, which is good news. Okay.

Retains. Okay, it's an expense. That's really good because we want to make sure our valuation methodology is consistent, and that would not be something we should add back. The reason it does get added back, in the credit markets, it is a reasonable thing to add back to EBITDA because you don't care about the dilution if you're a lender to the business.

Okay. Let's go back to the projects, and I hope that DCF boom free cash flow workbook. Wow, this is taking a long time to do. So we can just take a look at it once it's done.

And then once I've done this, I will review it. If this was in Excel, we'd actually be able to be seeing it build out the free cash flows.

And then because it's so visual in Excel, you can ask it to adjust, but it's just building it out here. And this has taken 13 minutes to do.

So it does take quite a long time to do it.

While we're doing this, because it's taking so much time, I'm just going to add another chat, and I'm going to ask it, in fact, hold the phones. If I go to the trading comps, I'm going to go here in the trading comps and I'm going to ask it, please build a WACC calculation for NVIDIA using the trading comps to get a sense of long-term leverage.

And use a predicted beta, probably from App IQ, and then use a risk premium from Demodron.

Okay. So we're going to do that and hopefully, and then ask it to add it to the spreadsheet.

Okay. So I'm just going to add that.

There we go.

Now, I could have asked it to glam up that prompt. Okay? Because you need often...

It will do funny things when it comes to WACC.

So I could have asked it to glam up that prompt.

What I probably should have also asked it is to ask me any methodology questions before it went off and did that. But I hope it shouldn't be too much of a heavy lift in this, and then we'll add it to that.

Now, ideally, if we were in Excel, you'd actually, again, you'd be able to see it making the adjustments there. So that would've been really good to do.

Let's just see how far we're getting with the DCF now.

Looks as though we're getting pretty close here because it's telling us what we're doing. That's 15 minutes, though.

That's a long time to do this. I'll go back.

Let me just see how this is working. Applying four bank standards.

Okay, this should be pretty quick now.

Should be running through this.

And then once we've done the free cash flows, then I'm going to prompt it to do the terminal value calculation. Now, in the terminal value calculation, I want it to use the Gordon growth model.

When I've asked it to do the terminal using terminal value, using both methodologies, Gordon growth model and multiple method, what it's done, it's just taken comparable companies today as the terminal value multiple.

But of course, if you're trending the growth down from much higher rates down to, say, 4%, your multiple will contract. So your terminal value multiple needs to be a good deal smaller than what the current comparables are trading at because your growth is slowing.

And as growth slows, your multiples will contract.

And that's why people don't like using terminal value multiples because it's really hard to assess what type of multiple a company should have in 10 years' time when its growth has slowed to about a 4% rate.

That is why in the industry, people prefer generally to use the Gordon growth model because then you can make some explicit assumptions about WACC and long-term growth rate, and then you can reverse engineer what the implied multiple will be.

So it has given us a little forecast here, and there we go. Some revenue growth.

It's broken down some of this, which is nice.

And then we've got EBITDA, EBITDA margin. This all looks good.

And tax, it's used cash taxes, and then it's done the free cash flow.

That all looks good.

And let me just see, is this... Doesn't look as though it's an Excel. Let me see if I can download that as Excel. Let me just have a look.

I'm going to keep it in here because I'm going to ask it to do some more work on this. Let me just open this now.

But if I'm modeling, I would always use the Rogo add-in to Excel.

Now you can see here this is some of the... Someone's going to do enable editing.

That may correct, but this has got some really long references in here. Can you see that? So that's not great, is it? That's really not great.

So I probably should've asked it to have done a, without this in Excel. That's actually really irritating for that.

And it's not done it here, so I don't know why it's done that, but it has forecasted out. This is actually not great.

If it was in Excel, it would look much, much better than this.

And I can show you an example. Let me show you in fact what I did before this session. If I open up, the DCF valuation in video when I was doing it in Excel, literally just minutes before this, so I'm very annoyed. So this is my previous example.

I asked it to do a detailed revenue build here.

So my add-in is working here. Isn't that weird? So the Rogo add-in is here. But I got it to do a bottom-up revenue breakdown, and you can see it's given the hyperscale revenue there, ACIE revenue, edge computing revenue. So there's a lot of detail there.

And then that's the revenue build, but in the forecast, you can see it's built out. And this is, I did step by step by step.

I did the free cash flows first. And then this is what it looks like. I did ask it to move the assumptions above the forecasts, and so it's come up to, it estimates by 2036 the revenue will be $2.4 trillion.

You can see why these companies are valued, but whether that will actually happen or not is another issue. But that is underpinning this current share price. So this is what has this ROGO built for me, before I did the terminal value calculation.

So I'm now going to go back to the...

Wonder if I can see if I can, let me see if I can fool Microsoft. May not work if I open the new template styles.

Yeah, it's not working. Is that me? Actually, what I'm going to do, I'm going to go back to that other file and let me add a new tab here. Okay. Let's see if I can continue working in here. Fingers crossed.

And if I do-- So I'm going to assume that we've got our forecast out already. So I'm actually going to copy this forecast sheet.

Let me just do that.

And I'm going to get rid of everything below here.

Okay.

So I'm just going to get rid of all this because we're going to rebuild this.

Okay. So we've got the valuation date here, and we're going to do it as of the 13th. We just do it yesterday. Then discount and convention. One is mid-year. Want mid-year.

Timing adjustment, WACC calculation. WACC's already been done, so let's go to WACC.

Let me show you the WACC that it built.

So it's got a risk-free rate here, and that's using the spot rate rather than constant compounding.

Then the equity risk premium, that's Kroll-recommended.

I actually asked previously for Dimodrom.

And it has given me different answers there.

Then the beta selector is using the provider beta or the regression from the share price data which I put into this spreadsheet.

Then the provider beta was Yahoo. Let me just see.

It's actually using the regression beta, which I'm comfortable with.

And then the cost of equity is 15.54%, which is pretty high, driven by the beta. And if you think about it, what that means is investors are expecting a 15% return on NVIDIA, which is pretty large amount. Then the cost of debt, 10-year treasury, and then we've got a credit spread, judgment on the high-grade issue.

So I guess that's going to be A rating, maybe even higher than maybe AA rating.

Then we've got the marginal tax rate and the after-tax cost of debt.

And then we've given it the weighting here, and it's actually got a pretty high weighting.

This has not been done using the comps.

So that's the equity being about 99% of the capital structure. I think that's probably a little high.

If I go to the comp set, let me just see if they have the...

No, they don't have the multiples.

Ideally, we would look at the comp set leverage there.

I do think that's a little bit high, but I'm going to leave it for now.

Okay, so I've got my forecast two here, and I've got a ref error. Why have I got a ref error? That's really annoying.

Let me just go and pick that up in the forecast. Why is that giving me a ref error? That's really irritating.

Just do that.

It's 2027. There we go.

I think that my, this Microsoft thing, maybe. There we go, that's done.

So we've got our unlevered free cash flow. We've got a forecast.

And if I look at the revenue growth, you can see you've got the consensus estimates. And then this is a long formula that is trending the growth down from the prior year of 31.4% down to the 3%. And this is a good example of where the AI tools will give you quite detailed, sometimes really complex Excel formulas, and that can be really challenging. But we've got a forecast there of 3%. Now, let's see if I can do this.

Please build in a terminal value on the forecast two sheet. And I'm going to give it some instructions.

Use the Gordon Growth Model with a long-term growth rate of 2%, of 3% in this case.

Okay.

And then also calculate an implied LTM EBITDA multiple for the terminal.

Yeah. And do this at the end of the forecast.

Now, a lot of times, if you don't tell it to do the end of the forecast, what it will do is it will do the beginning of the forecast, which I have a little personal bugbear. Ah, it is working.

I think this could be the whole Microsoft thing blowing everything up, earlier today, because I was working on this this morning.

Now, the nice thing about doing it within Excel- ... is it'll take a while, but you'll see it actually build this out, and you can actually see it moving.

Sometimes it will put in the numbers first, so just reading the stuff here. But this is the little add-in that we've got in Excel, the Rogo add-in.

Don't know why it's being so difficult.

You have to sometimes log in here. You have to log in, and then you go to the browser, and then you have to activate the login.

But it's something that I much prefer if I'm modeling to use the add-in to Excel rather than the prompt because you've got much more control. And once it's done the forecast cash flows, you can go through and you can say, "Yeah, I can check every single line item," and therefore I can be responsible for line item.

Notice also here, it's done a 10-year forecast to 2036, but then it's done an extra year. But actually, this is 2037, and it's based on a steady state. So what that's doing is kind of fixing all the ratios. You've got two years of constant asset efficiency ratios. Okay? And so this means that this is a better reflection.

It hasn't actually changed it very much.

But in some cases, you may want to create artificial steady state.

Yeah, and I have seen a number of banks do this. Okay.

Let me just see. It's having a bit of an issue here.

Okay, let me ask it to answer. So you see, I asked it not to do this, and it's done it. Ah, Rogo. So it's done it in the...

Oh, that's annoying. So I'm going to move this.

I did tell it to do it at the end of the forecast, so I'll move it to the last year.

And let me just check my turn freeze panes on, so I can kind of see what's going on.

That's annoying. So it does sometimes do things of its own volition, which is kind of annoying, but that's life, isn't it? So it's 2037 is our steady state. We've got the WACC from the other sheet, long-term growth rate. That's good. And then the Gordon growth method. So it's taken the P40, which is WACC less... Oh, this is a really good example of the garbage that sometimes you get.

Okay. This is not how you'd normally build it, because what it's done, it's got a line which is WACC minus G. Who would do that, right? That's a really good example of where this is why you want to iterate through this and change all this, say, "No, I don't want a line called WACC minus G." Just do it in the formula, because you then can create a skill, and it will always use the methodology that you like. So then we've got the roll forward, and let's just check that has...

Yeah, so that's correct. And the roll-forward factor and the term of value at year-end. And then to get the correct LTME EBITDA multiple, that is correct because it's used a year-end enterprise value, and we're using mid-year discounting.

And then there's some other, so that all looks okay.

Next, I'm going to ask it, so once you've checked that, now build a discount factor, a discount model, discounting the value of the firm to, we want yesterday's date. It's the 13th today, so we'll do the 12th of November 2026. So use a stub period and a discount factor line so I can understand your discounting.

So this is much better way of modeling, literally prompting as you go here. So what will happen once we've done the free cash flows, then it does the terminal value, and then it will do the discounting.

It means we can check everything at time.

We've only got seven minutes left to get this done. Oh my gosh.

Hopefully, this would've been quicker if we'd done it in Excel.

This isn't a big ask, so fingers crossed, Rogo, you'll be able to do this. We've done the trading comps, and NVIDIA does look undervalued based on the trading comps, but it'll be quite interesting to see whether it's undervalued, which I suspect it will be.

And then you can start to see here, it can sometimes do really complex calculation.

The other thing that you will find here, it will do one way when you prompt it in a chat once, and then when you do another DCF, if you're not using the same skill or a template, and templates are very good to use, then it will sometimes do a different way. So I did a valuation previously, and in this case, it's done days and year, days and discount period here.

But if I go to my other forecast, you can see that it hasn't done days, it's done years from the valuation date.

So it's actually done a different way in the same file just because maybe the prompt is slightly different, or remember, it's a probability-based model.

So let's just go through one of these. If I go to the beginning.

So we've got our 31st of Jan 2027. So days in fiscal year, 371.

It's obviously a bit longer than normal.

And days in the discount period, only 80 days.

So the period length fraction of fiscal year is just 80 divided by 371. Let's check. And then the unlevered free cash flow for the full year, but we only get a stub, remember, we don't get the full fiscal year. So then years from the valuation date to the period end. So now this is not correct. So what that's done, it's said period length fraction of fiscal year, but actually we receive...

It has made an adjustment. I tell a lie.

So that's as though it was year-end cash flows.

Then it's made an adjustment for mid-period here to multiply by 0.5, and that's mid-period, so that is now correct.

And then it's the discount factor.

But again, this is not very normal in a layout.

And then it's done the enterprise value of about six trillion. So then lastly, I'm going to ask it to now do a bridge from EV to implied share price.

Include the dilution of options and RSUs and converts. Because there's lots of weird stuff going on with Nvidia.

So I'm just going to ask it to do that and then, but can you see how if you break this down step by step, you can check it, and then if you don't like it, like I don't particularly like this little section of the discounting. I think it's a bit cumbersome, and it's not what I would normally do. So you can actually ask it to adjust this.

Then once you've got something that you really like, save it as a skill.

And all you need to do is to save it as a skill just in the chat window, say, "Based on the methodology that we've used in this model, create a skill that I can reuse to get the same type of output." And that means you won't need to go and iterate through back and forth, back and forth, back and forth with this.

So you can see there, it will just hopefully then do the bridge, and then we're nearly at time.

Three more minutes. Let's go to see how far.

Remember, we could have actually calculated, we could have asked Rogo to calculate if it was fairly valued using comps, what the share price should be. But, I don't think we've got time for that, but I'd just be interested to see. Let's go back to our comps, actually. Let's see.

It's at 6.3 trillion, and let's see what the current enterprise value is. Wow, it's 4 trillion.

So that definitely from a DCF methodology, there definitely seems to be upside.

But you do have to put this in context of in our forecast period.

There we go. There's all the adjustment there.

Basic shares outstanding, and then RSUs, PSUs, no stock options.

Got little notes.

It's all done it. So it's come up with $265 per share, and I think it's about 150 now. And it'd be interesting to see what it was trading at. Yeah, it's about $166.

But this is assuming that this business grows from the... It's trending to about 410 billion.

We're expecting it, based on this valuation, to reach about 2.4 trillion by 2037. So there's still a lot of uncertainty going forward. So that was just a little bit of a summary. Sorry, the sun's in my face. Let me just turn over, turn around.

The key issues here is once you've got something that you really like, save it as a skill. If you're modeling, I'd advise you not to use the browser and just get the whole model done.

I would advise you to go into Excel and build it step by step by step. And that means you can check, you can look at every single line item, and you get a much greater level of confidence. And it's almost like you're building it yourself.

Obviously, they're not quite the same, but it's much closer to building it yourself than if you just get it to build a DCF from scratch.

And I think you'll find most people in the industry will much prefer either building it yourself or like this.

It's a halfway house step by step. Thank you so much for your time today. I hope that was useful. A glimpse into AI, and these tools are getting better and better.

But I really appreciate your time today, and I hope that's been useful.

AI for Analysts Series - Accelerate your workflows with Claude, ChatGPT, Endex and more. Watch the recordings!

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

Name(Required)
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.