that calculates free cash flow at the regulated legal entities that can be distributed the parent company. The model also produces consolidated, GAAP, full financial statements in driver-based fashion, allowing for different capital planning scenarios to be vetted by senior leadership. Being able to work with data, bringing in multiple sources, and standardizing the metadata surrounding the data is what made a companywide model such a challenging task. Due to the quality of data in this model numerous individuals will now use my model as their source to tie their reports too. As the administrator of the long-term planning model it also requires that I work throughout the entire organization to gather inputs from Segment leaders to budget managers, including the IT department to understand the future spend how much to capitalize, how it should depreciate and finally how the depreciation expense should be allocated to the lines of
that calculates free cash flow at the regulated legal entities that can be distributed the parent company. The model also produces consolidated, GAAP, full financial statements in driver-based fashion, allowing for different capital planning scenarios to be vetted by senior leadership. Being able to work with data, bringing in multiple sources, and standardizing the metadata surrounding the data is what made a companywide model such a challenging task. Due to the quality of data in this model numerous individuals will now use my model as their source to tie their reports too. As the administrator of the long-term planning model it also requires that I work throughout the entire organization to gather inputs from Segment leaders to budget managers, including the IT department to understand the future spend how much to capitalize, how it should depreciate and finally how the depreciation expense should be allocated to the lines of