What do you do about the balance sheet and cash flow statement when you are building a 3-statement model three quarters into the year?

So to me, it doesn't make sense to forecast 2022 when I have the Q3 results. I want to keep 2022 on the historical side of my model.

I understand how to find the 2022 TTM data easily for the income statement. My problem is with how to present the 2022 balance sheet and cashflow statement. Should I just insert the last 9 months data from the Q3 8-Q Report for both of those financial statements and then forecast from there?

It would not be responsible I think to treat the model as though 2022 data does not exist.
Also, I am building this for practice (for myself) so I don't have a manager to ask or something like that.

Thanks for anyone's input on this!

416 WSO Academy Equity Research Session Reviews: 4.84/5

Class of '28 Dec 2026 Cohort

5.00/5

Equity Research Full Resume Review

“wilson was an excellent mentor throughout the entire resume review process and i genuinely appreciated the time and effort he put into helping me improve my application. what stood out most was how thorough and attentive he was in understanding my background and making sure my experiences were accurately represented. he went beyond simply editing my resume by asking thoughtful questions and helping me identify ways to better communicate my accomplishments. in particular he helped me articulate the experience of building and selling my own business to a search fund and understand how to position that experience as a differentiator when applying to investment banking and private equity roles. he also provided practical advice on how to approach interviews and communicate my experience effectively. i especially appreciated his patience, responsiveness, and willingness to go back and forth until every detail was right. he was genuinely personable throughout the process and made what could have been a fairly straightforward resume review feel like a much more valuable mentorship experience. i am very grateful for his help and would highly recommend working with him to anyone going through the wso academy program.”

Class of '18 Nov 2026 Cohort

5.00/5

Equity Research Career Roadmap (optional)

“Aditya provided a pathway very specific for my background as a consultant looking for a career change. He provided additional resources I can look into and how to build a portfolio that will leverage my experience. ”

See All 11,791 WSO Academy Reviews

2 Comments

NP

Intern in Non-profit

3y

I’d go off FY22 guidance (assuming it was updated with Q3 results). Just my preference though. I don’t know anything.

Reply

Quote

Report

Other

Equity Research Interview Process

G M A N

HF

3y

Error et et qui. Corrupti sit aut similique. Est quam ut non velit.

Totam sint dicta quaerat veritatis. Similique voluptatem et suscipit exercitationem nam. Illum laborum et nihil id accusamus nostrum. Facere repudiandae qui consequatur dignissimos necessitatibus sapiente. Ex enim molestias veritatis sit. Et et atque labore. In dolor rem aspernatur odio animi et.

Itaque consectetur beatae quod vel vero exercitationem. Enim sint qui sed harum. Quia fugiat at culpa et voluptas. Sint dolorem dolorem adipisci.

Qui nemo dolor dolores fugiat modi hic voluptates. Ex et similique ea est et unde itaque rerum. Dolore quidem voluptas porro voluptatibus enim quae modi. Qui modi neque eligendi. Consequatur architecto beatae consequuntur architecto laborum.

+14	Is Equity Research Dying - Where Are the Future Opportunites?	4	1w
+10	Detailed Revenue and Cost Builds	4	1d
+10	Associates who stuck around for > 5 years working for the same analyst. Why?	4	2w
+10	Equity Research Recruiting as a Freshman	3	1d
+7	Analyst with no coverage or ranking	5	2w
+6	Preparation for grad scheme - buyside ER	1	1w
+1	IB SA -> ER FT	4	3w
0	Equity Research Rankings	1	2w

1	redever	99.2
2	kanon	99.0
3	BankonBanking	99.0
4	Secyh62	99.0
5	GameTheory	98.9
6	CompBanker	98.9
7	dosk17	98.9
8	Betsy Massar	98.9
9	DrApeman	98.9
10	Mimbs	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

What do you do about the balance sheet and cash flow statement when you are building a 3-statement model three quarters into the year?

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

What do you do about the balance sheet and cash flow statement when you are building a 3-statement model three quarters into the year?

See All Comments - 100% Free

Trending Content - Equity Research Forum