Spreadsheet

next month's video and of course as always I do make that post on the community board which is where I get most of the questions from so if you want to make sure that you don't miss out on posting and leaving a comment on that post in the community board then make sure that you're subscribed but without further ado let's get straight into it and answer the first question so the first question I had here was what website do you use to find information and data about company stocks prices income and revenue So generally, if I'm just having a quick look at a company, like I just want to know what the stock price is, what the market cap is, how much revenue are they producing over the past couple of years, what's their price to earnings, that sort of thing, I'll usually just go to Yahoo Finance.

But once I start wanting to fill out all of the components in my spreadsheet, for example, so that I can calculate the long-term growth of sales and earnings and equity and that sort of thing.

Generally, what I'll do is I'll go to two places.

The first place is quickfs.net. It's a website where you can get 10 years of data for US companies.

And that means firstly, sticking to countries, economies that I understand, the United States and Australia.

The next question is, what is going on with Inogen? I have no idea what Inogen is, so I don't know what's going on with it.

The next question we've got is, do you have a spreadsheet of companies on your radar or companies that you monitor? If so, how do you keep track of them? Do I have a spreadsheet? So I have my free stock analysis spreadsheet that you guys can get access to via one of the links down in the description below.

And essentially, I will fill that out for any companies that I'm interested in.

So look at your total year to date.

Now I want you to compare those totals to what you have recorded in QuickBooks or whatever bookkeeping tool spreadsheet you use.

All right.

So do those numbers match? If the numbers are way off, that's your sign that something needs fixing before tax season rolls around this year.

So if you show up to your tax preparer and you don't have a profit and loss report, or maybe you have a profit and loss report that's kind of a total mess, and your tax preparer basically has to recreate a whole year's worth of bookkeeping from whatever you hand them.

Maybe that's bank statements, credit card statements.

a spreadsheet that's kind of mostly filled out.

And honestly, your tax preparer is probably using QuickBooks behind the scenes of everything to put all your bookkeeping together anyway.

One more plug, but this one's free.

If you want my free spreadsheet so you can do this kind of analysis yourself, it'll be linked down in the description below.

You can download it through my website.

But as you can see, the growth rates that I'm using in my models range from 4% per year over the next decade up to 12% per year for the next decade.

On your CEO numbers, the 3.2% growth matches what BLS projects for chief executives through 2035, even with that high exposure rating.

what do you think ainsley am i on the right track here i mean i'm all over the place with the numbers but essentially we'll give folks the spreadsheets my spreadsheet and uh the bls one or the link to bls which would be more accurate and you could go see it for yourself

I think you're on the right track regarding the junior squeeze, but the CEO thing is the real clue here.

If the government says the most powerful person in the company is very high exposure, it's because a huge part of a CEO's day is synthesis, reading reports, summarizing data, and drafting communications.

When I look back, you said, like, I always joke that the biggest hit consumer product Microsoft had was Excel.

Think about what, you know, Excel was the consumerization of a concept called Spreadsheet, which empowered billions of people to be able to get number sense, right? I mean, that's what we are.

And so I want to be able to do that with Copilot.

And that's our goal.

You can also find out where to order a copy of my book, The Seed Farmer, or pre-order a copy of The Profitable Farmer.

And you can support the podcast at spreadsheet.farm.com.

If you haven't already subscribed, now's the time.

You wouldn't want to miss the next episode.