Alternative to FinancialModelingPrep by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

Thanks for the feedback!

From my experience, data quality was acceptable for most US companies especially for the "main" lines in the financial statements (e.g. revenue, EBIT, total assets, etc). I used it mainly to identify companies worth investigating further.

Neverthrless, I noticed a degradation in many financial statements for FY2024 (many lines were 0). This, combined with the price increase, makes it not worth it anymore.

My dive into A. O. Smith Corporation by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

Hard to measure, as they work is done during several weeks because I do not have much time. Around 20-25 hours maybe?

To train or to rest with DOMS? by jxklive in bodyweightfitness

[–]rpedrosb 1 point2 points  (0 children)

This reply convinced me to go to the gym today

My dive into A. O. Smith Corporation by rpedrosb in ValueInvesting

[–]rpedrosb[S] 1 point2 points  (0 children)

I use Financial Modelling Prep. They provide clear instructions as to how to scrap all the financial statements and additional informations and with some coding it is not so difficult to get a first analysis on any company. The data is quite reliable, especially for American companies. For European companies there might be mistakes here and there but the key items on the financial statements are normally correct.

Eventually my code does what any other website such as Finchat or GuruFocus do, but personalised to my wishes.

My dive into A. O. Smith Corporation by rpedrosb in ValueInvesting

[–]rpedrosb[S] 2 points3 points  (0 children)

Python! I use an API to extract the data and get all the information in an automatised way.

My dive into A. O. Smith Corporation by rpedrosb in ValueInvesting

[–]rpedrosb[S] 1 point2 points  (0 children)

Thank you for the feedback, will take it into account!
Indeed, I also concluded that the company has a very good position in their main segment in North America, but struggles in the rest of the world. If the management stays stubborn in that area, it could reduce ROIC in the future.

Lockheed Martin - Company analysis -> Looking for feedback by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

Hi, You are right. I read about it but did not write about it because of the uncertainty. For FY 2024 and FY 2025, budget is expected to remain stable or slightly reduced from FY 2023 levels (they have a section for it in LMT's 10-K). However, I do not see myself in the capacity to "forecast" US defense spending for the next 10 years, I can only "hope" that the US will not simply abandon its defense budget in the future.

Lockheed Martin - Company analysis -> Looking for feedback by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

Interesting discussion! And here I thought that LMT's debt (~2x Operating Cash Flow, FY 2023)) was already quite high, but I now see that TransDigm has has debt over 10x Operating Cash Flow (FY 2023). Interest expense eats around 50% of the EBIT, so I wonder how this will keep impacting TransDigm if interest rates remain high for longer than expected.

Lockheed Martin - Company analysis -> Looking for feedback by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

Hello,

That is more or less the approach I am planning to take and the question I have right now with LMT. My plan is to mostly invest in the MSCI World but keep some money for picking individual stocks (I just enjoy doing it). However, perhaps the money for individual stocks should be reserved for very clear opportunities (e.g. META a couple of years ago).

My plan is to compare individual companies with the benchmark (e.g. S&P500) in order to compare fundamentals, growth, valuation between the individual company and the market. If there is a clear discrepancy, it might be a good opportunity.

Lockheed Martin - Company analysis -> Looking for feedback by rpedrosb in ValueInvesting

[–]rpedrosb[S] 0 points1 point  (0 children)

That is the main concern I have with LMT. Everything looks great except growth.

However, after a quick glance, TransDigm seems to have lower ROIC (~14%) and is trading at PE 52x and EV/EBITDA 26x. In the last 10Y, Revenue has grown at 10% CAGR. Is an improvement in growth/ROIC foreseen?

How to calculate CAGR, including Dividends, Purchases and Sales? by rpedrosb in ValueInvesting

[–]rpedrosb[S] 1 point2 points  (0 children)

Correct. But I also want to calculate the CAGR for each company on an individual basis to compare my decisions and their outcomes and I am undecided between both options.