This Capex Module is a sub-module to be integrated into your main financial model. It includes all cash flows, depreciation, and disposal calculations.

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 and corporations’ operating business plan models.

This Capex Module is a standalone sheet that can 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.

This model’s first step is defining your main fixed asset classes. The following table will require defining your sub-classes and assigning the 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 purchase details like date and expected months to dispose of.

The detailed calculation sheets of the CAPEX module will allow you to link the outputs to your main financial model to 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.

You must log in to submit a review.