Capex Module

Description
Along with other components of a financial model, the capex workflow is probably the first sub-module to build as it captures the actual investment in long term (fixed) assets.

The impact of capital expenditure is critical in cash flow projections in project finance models as well as operating business plan models of corporations.

This Capex Module, is a standalone sheet which could be copied easily and integrated into your main business plan model. By synchronizing the timeline of this module to your main model and linking the outputs to your financial statements and cash flow tables, you could save a lot of development time.

The first step in using this model is to define your main fixed asset classes. The following table will require defining your sub-classes and assigning a main class to each sub-class from the list of main classes you have already defined. Then you can start inputting your capex plan items. The module allows up to 200 assets in which you will indicate details of purchase like date and expected months to disposal.

The detailed calculation sheets of the capex module will allow you to link the outputs to your main financial model so save development time on capex cash flows, income statement depreciation figures and balance sheet carrying values of fixed assets. This will readily be available once you link the capex module to your financial model and synchronize the timeline.

The capex module also provides multi-periodicity outputs, therefore you have the option to link outputs into a monthly, quarterly or annual timeline.