Budget models are created when a business wants to assess its future performance with an ideal state that includes its estimates of sales, expenses & other related factors.
While creating the estimates and projections is an easy task for individual departments of the company, the key task of this process is to create an effective financial model that can both estimate the budget as well as allow for the tracking of the budget vs actuals in the future.
In this Menternship, you are required to build a budget model. You are required to go through the past sales of the company, and build out assumptions based on your analysis. Once this is done, you are provided with the budget estimations from individual departments of the company, which need to be factored into the budget model required.