financial model template

Water Cooler Investing
#1

Hi guys I have a question about financial modeling. I have a simple financial model template and I want to do a quick and dirty valuation on a stock based on numbers from the financial statements. Would it be wrong to consolidate and simplify line items from the financial statements to fit the model?

is there anything fundamentally wrong about that? Or would that be alright to do?

#2

That’s what I would do lil cubby. Then onward to discounting free cash flows!

#3

quick and dirty, for sure.

Also worth having the consolidated view link to the details so you an trace back your work and make adjustments to the source data if needed.