This template calculates the associated spend and depreciation for a capital budget or forecast. There are three model components:
- CapEx - Simple is where you input spend lines for various capital expenditures and calculate the depreciation and spend on that line item
- Summary shows capital spend by category and department
- Drivers manage the picklists in the CapEx Templates
So using this pro forma template is pretty intuitive:
- Select the appropriate year at the top of the template
- Add line items for new or existing capital assets
- The template will calculate the depreciation and associated spend timing for you
- View results on the summary tab if desired
Use with Cube
This is an Excel template. You don't need to be a Cube customer to use it!
But if you are a Cube user, you can start using this template in under two minutes. Here's how.
Step 1: Open the template in Excel or Sheets.
Step 2: Customize the row and column headers to match your Cube's dimensions and filters.
Step 3: Select the range where you want to fetch your data.
Step 4: Fetch your data.
All About Capital Expenditures
Capital expenses (CapEx) are investments in upgrading a company's physical assets: buildings, technology, and equipment. Since they're such a major piece of a company's overall cash flow, you need to zero in on your capital spending.
Capital expenditures are payments recorded on a balance sheet instead of expensed in an income statement. However, capital expenditures are investments, meaning that any item with a life of less than a year (an operating expense, or OpEx) isn't quality and should be expensed on the balance sheet.
In other words, CapEx is anything your company spends money on that can be considered an investment and not a simple expense.
Some examples of CapEx include office space, technology or machinery, and vehicles.