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.

2 Comments
 
Most Helpful

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.

  1. Conclusion up front: I am (don’t say “we”) long TICKER, market cap and price target, and % upside, implied IRR % over what time horizon
  2. How did you get to your price target (multiple of future earnings/EBITDA/FCF, SoTP (sum of the parts), etc.)
  3. What does the company do, how does it make money, what’s the industry structure and how the company fits into the industry?
  4. Summarize the 2-3 theses points on the stocks up front. All theses need to affect the fundamental forecast and/or valuation.
  5. Dive into thesis points and provide evidence of research and numbers to support points – be sure to clearly explain how your view differs from consensus (i.e. the market); Focus most of your energy on fundamentals rather than multiple expansion.
  6. Summarize valuation (including slightly more detail than upfront), and conclude by reiterating your price target and % upside
  7. Include a financial summary and your model
 

Non eius necessitatibus adipisci. Sapiente reiciendis magnam hic saepe. Laboriosam consequatur laudantium illo fugit maiores blanditiis facere. Voluptas ut debitis necessitatibus et dolore aut vel. Corrupti vitae et maiores accusamus deserunt. Eos dolor dolor inventore ab.

Vero perspiciatis sint reprehenderit hic dolores. Enim quidem quisquam assumenda ipsa. Itaque necessitatibus qui adipisci sed.

Itaque deleniti itaque non nulla soluta illum. Doloremque ea sequi natus est temporibus. Voluptatem aut iure accusamus veniam eum quidem eum.

Expedita vel qui est eius. Id quis ratione consequatur ut. Aut nihil dolor quidem sit voluptatem sit. Non sint facere dolor dolorum cupiditate odio maiores. Nulla ipsam ut modi minus. Eum architecto aut ut ut quisquam.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (67) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
GameTheory's picture
GameTheory
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”