Mark is a CPA specializing in fixed asset accounting and corporate valuation, ensuring the accuracy of asset investment calculations.
The **Capital Expenditure Calculator** (CapEx) uses the balance sheet identity to derive the annual investment made in fixed assets (Property, Plant, and Equipment – PPE). This fundamental financial metric is critical for calculating **Free Cash Flow (FCF)** and asset growth. This versatile four-function solver allows you to determine **Capital Expenditure (C)**, **Ending PPE (E)**, **Beginning PPE (B)**, or **Depreciation Expense (D)**. Simply enter any three of the four required variables and the tool will solve for the missing one.
Capital Expenditure (CapEx) Solver
Capital Expenditure Formulas
The calculation is based on the reconciliation of the Property, Plant, and Equipment (PPE) line item on the Balance Sheet, often called the **CapEx/PPE Reconciliation** formula.
Core Relationship: Ending PPE = Beginning PPE + CapEx – Depreciation
$$ E = B + C - D $$
\text{Where PPE refers to the net balance (Cost minus Accumulated Depreciation).}
\text{Solve for CapEx (C): } $$ C = E - B + D $$
\text{Solve for Ending PPE (E): } $$ E = B + C - D $$
\text{Solve for Depreciation (D): } $$ D = B + C - E $$
Formula Source: Investopedia: Capital Expenditure
Variables
- C (Capital Expenditure – CapEx): Cash spent on acquiring or upgrading fixed assets (new investment). (In currency).
- E (Ending PPE): The net value of Property, Plant, & Equipment at the end of the period. (In currency).
- B (Beginning PPE): The net value of PPE at the start of the period. (In currency).
- D (Depreciation Expense): The non-cash expense recorded for the wear and tear of assets during the period. (In currency).
Related Valuation and Cash Flow Calculators
Analyze key metrics for free cash flow and asset valuation:
What is Capital Expenditure (CapEx)?
Capital Expenditure (CapEx) represents the funds a company uses to purchase, maintain, or upgrade its fixed assets, such as buildings, machinery, equipment, or land. These expenditures are investments in the long-term health and productive capacity of the business. CapEx is found on the Cash Flow Statement under “Investing Activities” and is reported on the Balance Sheet as an increase in the Gross Property, Plant, and Equipment (PPE) account.
CapEx is essential for analysts because it is subtracted from operating cash flow to calculate **Free Cash Flow (FCF)**, which is often considered the true cash profit available to debt and equity holders. CapEx can be classified as either **Maintenance CapEx** (money spent to keep current operations running) or **Growth CapEx** (money spent to expand the business). High CapEx signals a growing company investing heavily in its future, while low CapEx might signal a mature company with high cash flow, or one that is cutting back on investment.
How to Calculate Capital Expenditure (Example)
A manufacturing company had a Beginning PPE (B) balance of $\$1,000,000$. Depreciation Expense (D) for the year was $\$50,000$. The Ending PPE (E) balance is $\$1,050,000$. We solve for CapEx (C).
-
Step 1: Rearrange the Formula to Solve for CapEx (C)
$$ C = E – B + D $$
-
Step 2: Plug in the Variables
$$ C = \$1,050,000 – \$1,000,000 + \$50,000 $$
-
Step 3: Determine Capital Expenditure (C)
The resulting Capital Expenditure (C) is $\mathbf{\$100,000}$. This is the amount the company invested in new assets during the year.
Frequently Asked Questions (FAQ)
CapEx (C) is a **cash outflow** in the period the asset is purchased (Investing Activities). Depreciation (D) is a **non-cash expense** that slowly reduces the asset’s book value on the Income Statement and Balance Sheet over its useful life.
This formula uses **Net PPE** (Gross Cost minus Accumulated Depreciation). If you use Gross PPE, the formula simplifies to $C = E_{gross} – B_{gross}$, as Depreciation does not affect the gross cost balance.
CapEx is cash spent on buying assets, so it is usually positive. If the CapEx result is negative, it usually means the company **sold** more assets (Disposals) than it purchased during the period, effectively shrinking its asset base.
PPE represents the value of physical, tangible assets. While in specialized cases Net PPE can be zero, in this general financial model, the value of fixed assets is required to be non-negative for a meaningful calculation.