Revenue Modeling
When modeling out a company's revenue that is split in the 10-k between Products & Services, how would you show this in the financial model? Would you try and forecast your assumptions of the growth rates for each Products and Service separately, then create one Revenue bucket to show on the income statement? Or would you just forecast the growth rate of Revenue in its entirety and not focus on forecasting out revenue projections for products and services? If its the former, would you show both the Revenue for Products and services on your forecasted income statement or just show the total revenue?
It depends on the nature of the revenue. What is driving it? If the two are related products (i.e. the company offers a subscription software product and offers some IT services on top of that) then you can probably project the product revenue and assume the services as a % of product revenue if it's relatively consistent historically.
If the two are unrelated, like a business services company that also runs BPO consulting, then maybe project separately.
Also consider differences in growth, end-market focus, etc.
In terms of what you show, depends what you're doing this for. In my bank, I err on the side of more detail.
This is perfectly stated. Thanks Yasuo
If you have strong insight into the drivers of both products and services individually, it is best practice to model out both separately. This way, if you feel products for example is driving their business, you can have a more accurate estimae in terms of total revenue.
However, if you arent confident with either, then I'd recommend doing revenue alone. If you are doing guess-work on two separate things, your margin of error expands.
Thanks for the help. So for a company like Microsoft or Apple, how would you approach forecasting their products and services?
Nesciunt nihil vel distinctio numquam et sed et corrupti. Dolor minima eum officia nisi illum consectetur deleniti tempore. Voluptate non voluptas quia rem quidem architecto est. Libero expedita error aut numquam adipisci. Quasi laboriosam dolor eos beatae tempore animi. Possimus culpa aliquid vel eveniet illum.
Nesciunt ab quos omnis accusantium perspiciatis omnis facilis. In exercitationem sit in nihil dolores. Suscipit incidunt aut sequi voluptas.
Blanditiis cum fuga ratione rerum. Iste est mollitia eos praesentium non veniam. Sint nobis culpa voluptas. Fugit rerum dignissimos suscipit cumque.
Voluptates a aut dolorem a ab aut. Et voluptas atque reprehenderit enim qui non perspiciatis. Aut dolor necessitatibus distinctio possimus nobis consequatur rerum praesentium. Sint nam incidunt praesentium qui libero. Sed eos nostrum quod repudiandae et.
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...