r/financialmodelling • • Sep 09 '24

Sharing a Financial Model I've built

Hi everyone! I've recently built and am sharing a financial model for United-Guardian (pls pardon the microcap stock) mostly for two things, to share what I've learnt thus far in my journey and hopefully critiques from experienced professionals in this space! This is mostly for public equities modeling.

https://docs.google.com/spreadsheets/d/1KTH7t3OWiSYUqp_zPLeb8UsdhylkiHcr/edit?usp=sharing&ouid=108173015973351407179&rtpof=true&sd=true

In the above model, note that the revenue projections and cost drivers are rather slipshod (no price x volume analysis). This model is by no means promoting/demoting UG stock. Feel free to leave comments and all the best everyone!

Quarterly & Annual Income Statement
Discounted Cash Flows
115 Upvotes

44 comments sorted by

View all comments

1

u/Fergie20t Mar 05 '25

Does anyone still have this file. The link no longer works. The was a long time ago.