Skip to main content

Fiscal Year vs Calendar Year-The importance of data consistency in Valuation

When companies report financial results, they use a calendar year or decide their own "fiscal year." Apple, for example, uses a fiscal year starting in September and ending in September next year since they usually release new iPhones or have Apple meetings in September. It is essential to make sure the data matches in valuation for consistency.

To see how significant the differences can be, I will use part of my Oracle valuation to illustrate. 

When valuing Oracle stock, I found that the company will have high growth whenever it has significant acquisitions and flat operating income when it does not. My judegemg is that this company growing mainly with M&A no matter how they advertise their technology. So you cannot do Oracle valuation without valuing each acquisition and calculating the return on capital. 

Figure 1 and 2 below shows Oracle's M&A cost and my adjusted annual operating income. But as you can see, the M&A cost does not match the active growth. With commonsense, we should expect higher operating income growth when they have significant acquisitions (of course, this is only for Oracle specifically rather than a universal rule since 60-70% of M&A lose money.) But take 2017 and 2016, for example. The company had a much larger acquisition in 2016 than in 2017 but had an 8% income decrease in 2016 but 1% positive growth in 2017.

Figure 1







Figure 2







Then I found that the company fiscal year ends May 31 every year, but the acquisition year I record is based on the calendar year. For example, Oracle bought Netsuite on July 26, 2016. I regarded it as a 2016 acquisition by calendar year, but I should categorize it as a 2017 acquisition by fiscal year. After the adjustment, you can tell that the operating income growth rate matched the acquisition. 

Figure 3






But you may wonder why Oracle did not grow well in the 2022 fiscal year when it spent $28.3 billion on Cerner. Oracle bought Cerner on June 8, 2022, while accountants prepared 10k on June 21st. It is too early to show up the revenue and income from Cerner.

So next time you see some stock has a significant decline, don't panic too early. Sometimes it may be due to the accountant's inconsistency, which can be a windfall for you.
















Comments

Post a Comment

Popular posts from this blog

Costco Stock Valuation Part 2-Growth rate, stock compensations, and Free Cash Flow

Note: I found that I made a serious mistake in estimating the cost of equity in my this valuation; Please check this Link  while reading the free cash flow part. Growth rate forecast The growth rate is among the most challenging number to calculate financial valuation. Because you always have something to base on when calculating the company’s debt, option value, cost of debt, and capital. In contrast, the growth rate is most related to the future. In addition, some startups or losing money companies do not even have historical rates. But I always estimate the growth rate first before I calculate the cost of capital for two reasons: 1. I like to finish hard work first. 2. The cost of capital can keep changing as the debt balance, stock price, and market risk premium change while you estimate the growth rate for the long term. If you value the cost of capital first, chances are you have to recalculate after you took a while to calculate the growth rate. Investment...
Post a Comment
Read more

General Electric stock valuation

Disclaimer: The page number of the 10k page is based on the PDF page number after I downloaded the 10k from SEC. The company's 10k does not include the page number on each page except at the beginning of the report. Therefore, the page number I quoted may not be identical for readers. Business model The company currently has four business segments: GE Aerospace : This sector produces commercial and military aircraft engines, engine components, aircraft systems, and aftermarket services. GE Healthcare(GEHC): This sector designs, develops, and manufactures medical products and devices for diagnosis, imaging, and ultrasound; it also offers patient care solutions, including consulting, handling devices, and software and digital solutions. While GE spun off this sector in January 2023, it still owns 13.15% of GEHC. Valuing GEHC is necessary to value GE's total operating assets and equity. I can also have the opportunity to invest in GEHC if it is undervalued. GE Power: This sector m...
Post a Comment
Read more

Costco Stock Valuation Part 1-Business model & Cost of Capital

Note: I found that I made a serious mistake in estimating the cost of equity in this valuation; Please check this Link  while reading the cost of equity and cash flow part.   Words for Readers This analysis is meant to teach those with NO investment experience or those who have attended business school but only know how to price a company rather than value a company. If you are interested in learning investment from this analysis, I recommend you pick a company and value at the same time while reading this paper. It took me several days to learn most of the knowledge I used in this paper, but it took several months when I valued the first company (My first valuation is AMD, not for this one, though). Not until you started did you realize that you always have things to figure out. Along the analysis, I will try my best to explain any financial terms you may have never heard of. If you feel confused, please be patient and follow my path. If you still cannot understand some ter...
Post a Comment
Read more