Financial Modeling Question - Using TTM for latest fiscal year but not prior years?
i'm working on a financial model, dcf, and write up with the hopes of attaching it to applications in the future, however, the company i am choosing to build a model/write up on went public last year and is showing a lot of growth (i bought the stock since IPO and have done well on it - haven't built models for any of my personal investments), therefore, i do believe using the latest quarter financials (ttm/ltm) will best reflect the growth/current standing of the business.
i am not sure if it is frowned upon/bad practice to use ttm/ltm for the current year but complete year annual amounts for the last two, prior years? i know there is a seasonality component to be mindful of and i will be clearly identifying the columns/cells using ttm/ltm but is there anything else i should be aware of? what you would do in this situation?
essentially i will be projecting the next 5 years using the latest quarter's ttm/ltm and showing growth historically vs different periods.
i asked chatgpt and was advised to build both the latest annual and latest quarter ttm/ltm side by side (seems a bit excessive/tedious for applications) or just use the latest complete year (only 1Q into the current year as well so far) but i wanted to ask/confirm with the professionals/experts here, not sure if i am overthinking this. thank you.
try and always use TTM because it usually provides the most accurate data. since it is such a new public company I would forcast the first 2 years quarterly because it will probably have different growth or assumptions as it starts to settle or take off in the market. use TTM for income statement and just most current for balance sheet with calculating ratios. Also for your Write up make sure you defend the assumptions you use. also found this structure online that I like so Ill share it.
Eveniet dolor voluptas ab voluptates est aut nihil. Pariatur asperiores placeat ipsa dolorum unde qui. Ipsa dolor itaque dolores. Quasi magnam et laboriosam aut consequuntur laborum voluptatibus. Sed ut tempora quia amet odio unde id.
Excepturi et eum quia necessitatibus qui optio amet. Ipsa quaerat placeat molestias tenetur veniam odio error.
Iste laudantium mollitia repellat excepturi repellendus. Itaque autem ullam earum suscipit. Est doloremque aut possimus quibusdam dignissimos sed consectetur. Provident et beatae dolorum odio delectus et.
Perspiciatis numquam maiores voluptatum labore sunt aut. Error aliquid dicta voluptatibus adipisci perspiciatis perferendis ullam error.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...