Overview

 Any company which uses fixed assets in its operations needs to know: 

  • Investment cash flow related to new fixed assets
  • Future book value of fixed assets
  • Residual value
  • Future depreciation expense

 

This template built to the highest financial modelling standards will help you calculate these parameters. It analyzes capex in two major categories

 

  1. Existing capex which your company already has on its balance sheet. Having its net book value, useful life period and other parameters you will be able to calculate its net book value and depreciation expense going forward
  2. New capex which will be acquired in the future. The template will calculate the amount of cash by month required for such capex, its net book value and depreciation going forward.

 

The template is very detailed, user-friendly, features a convenient input section, clear calculation blocks and includes an overall summary.

 

The template is very flexible and you can adjust the forecast period (currently five years), forecasting interval (currently one month), the number of capex items and other parameters. Due to its flexible nature the template can be used on a stand-alone basis (just for future capex analysis) or incorporated into larger budgeting packs or financial models.

 

The template is accompanied by a text guide with detailed explanations.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Hotel Acquisition Financial Model
349
0
This is a detailed, well-structured and transparent cash flow model for an acquisition of a hotel. The model includes the…
Hotel Development Financial Model
361
1
This is a detailed, well-structured and transparent cash flow model for the development of a hotel. The model includes the…
Rent Roll Analysis and Stacking Plan
1,939
2
I. RENT ROLLA rent roll is a table listing the tenants of a real estate asset, showing how much area…
Complete Three-Statement Quarterly Budget
2,016
1
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Quarterly Budget with Scenarios
1,741
4
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Monthly Budget
1,691
0
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
See All