Capital Expenditure Planning

Finance leads and FP&A use this file when capital spend, depreciation and amortization, and net PP&E need a clear workbook—not a one-off tab buried in last year’s budget file.

Typical moments include annual capital budgeting, equipment or tooling refresh cycles, facility or IT project planning, and board or bank conversations where someone asks for a defendable view of what you plan to spend on assets and how depreciation and amortization flow from those choices.

Founders also land here when you want a credible CapEx schedule before you invest in a full three-statement forecast, or when another workbook’s instructions pointed you to this module as the right depth for asset planning alone.

If subscription economics (MRR, churn, cohorts) should drive the forecast, you will get more from the SaaS Financial Model—it includes a Capex tab inside an integrated subscription graph. If you need scenarios, breakeven, and valuation for a general operating business, use the Standard Financial Model. For a lean startup P&L and dashboard without CapEx-first depth, compare the Startup Financial Model. When department headcount and payroll-style costs are the main open question—not asset spend—compare the Workforce Planning Tool.

For vocabulary you reuse in memos, see our CapEx glossary entry.

Teams use the words interchangeably; in practice:

• A CapEx plan is the story of what you intend to buy or build, when, and why—often tied to approvals and strategic priorities.
• A CapEx budget is usually the approved envelope of spend in a period (quarter or year)—what leadership expects you to stay inside unless priorities change.
• A CapEx schedule is the time-phased grid: when cash or commitments hit, how new assets layer in, and how depreciation and amortization roll forward—so net PP&E and D&A stay coherent in one view.

This workbook gives you structured tabs to build that schedule-style clarity in Google Sheets. It does not replace your general ledger, fixed-asset register, or procurement workflow—it helps you model and explain the plan before you push numbers into accounting systems of record.

Teams ask for a capital expenditure budget template, capex tracker, or capex report when they need one coherent view of what was approved, what is committed, and how depreciation and amortization line up as periods roll—without rebuilding a grid every quarter.

This workbook is built for that planning and explanation job in Google Sheets: a time-phased structure (the capex schedule on CAPEX and D&A) plus supporting tabs so capital expenditure totals and D&A stay on the same wiring you can walk leadership through. Use it to track your modeled plan and export a reporting view—print, PDF, or Excel handoff—when stakeholders want a static pack.

It is not a substitute for procurement approvals, purchase order systems, or live ERP sync—those stay your operational systems. It is also not automatic actuals ingestion: if you reconcile to the general ledger, copy or map the agreed numbers on the cadence your team can maintain.

If your only need is a blank capex format to type into once with no logic, a simple sheet might suffice—choose this product when you want documented tabs, depreciation and amortization tied to the schedule, and headcount or onboarding inputs where the workbook connects them.

We ship a Google Sheets capital expenditure planning file with four labeled tabs so you always know where inputs live and where depreciation and amortization read from—tab names match what we show in the gallery screenshots:

1. CAPEX and D&A — The core capex schedule (time-phased capital expenditure and depreciation and amortization) as implemented and labeled on that tab. Use it to line up new investment, ongoing D&A, and the net PP&E story the sheet calculates—follow the instructions there so totals stay coherent.
2. Onboarding Costs — Planning surface for onboarding-style spend the workbook connects to your process—use it the way on-sheet labels describe when you need people-related startup costs in the same planning pass as assets, not as a substitute for your HR system.
3. Lifetime Amortization — Asset life and amortization views tied to the same structure so you can see how capitalized spend spreads over time and stress-test useful life assumptions before you lock a memo.
4. Headcount Data — People inputs where the file ties staffing to the investment story it documents—helpful when hiring plans and capital projects move together (for example tooling for a larger team).

What is not in this file: a full profit and loss, balance sheet, cash flow statement, scenario engine, or valuation tab—those ship in other products when your reviewers expect them in one integrated workbook.

This product is an analytical template, not tax or legal advice—pair numbers with your accountant or counsel when compliance matters.

Use this quick guide to pick the right depth:

• Focused CapEx, D&A, onboarding, amortization, and headcount surfaces (four tabs) → this Capital Expenditure Planning template
• Integrated operating model with linked statements, scenarios, breakeven, and valuation → Standard Financial Model
• Subscription-native forecast with a Capex tab inside the same graph as MRR and statements → SaaS Financial Model
• Lean startup P&L and dashboard without CapEx-first scaffolding → Startup Financial Model
• Headcount and department cost planning with a dashboard when assets are not the bottleneck → Workforce Planning Tool

Each listing is maintained as its own workbook—not the same file with a new cover.

No. This module helps you plan and trace CapEx, depreciation, and amortization in one structured workbook—the same economic story you will eventually tie to investing cash flows on a full model.

It does not replace a statement of cash flows or a liquidity forecast on its own. When reviewers ask for how operating, investing, and financing cash reconcile month to month—or when covenant or runway conversations require linked statements—move up to the Standard Financial Model (or the SaaS Financial Model when subscription mechanics should drive revenue in that same file).

1. Duplicate the master Google Sheet after you access it so updates from the store never overwrite your working copy—rename the duplicate with your company and planning version so shared links stay unambiguous.
2. Skim every tab once so you see how CAPEX and D&A connects to Lifetime Amortization and how Headcount Data and Onboarding Costs feed the story as labeled.
3. Enter inputs in the order the workbook recommends on-sheet—usually drivers and dates before you trust downstream totals.
4. Reconcile asset additions, depreciation and amortization, and net PP&E thinking to one narrative before you share numbers outside the company. If two tabs disagree, fix inputs and dates first—not parallel “shadow” totals off to the side.
5. Revisit on your planning cadence—annual budgets, board packs, or pre-diligence refreshes—so assumptions stay honest when projects slip or accelerate. Use comments or a short change log in the duplicate if multiple people edit the file.

We author, test, and document this template in Google Sheets: collaboration, version history, and sharing match how most teams run planning today. Gallery screenshots are Google Sheets throughout—you work from the Google account where you copy the master file.

You can often export to Excel for a stakeholder who lives in Office, or print / save as PDF from Sheets when someone wants a static handout. Treat Office export as a handoff step: re-check formulas, named ranges, and links after export—Microsoft Excel does not guarantee parity with every Sheets pattern or add-on.

We do not ship a separate native Word template: narrative memos live outside this file.

Upgrade when reviewers expect revenue, operating expenses, and capital to reconcile inside linked statements—monthly P&L, balance sheet, and cash flow—with scenarios or valuation in the same workbook. That is the Standard Financial Model bar for general businesses.

Choose the SaaS Financial Model when MRR/ARR and churn should sit on the same calculation graph as Capex and consolidated outputs.

Keep this Capital Expenditure Planning file when your bottleneck is getting the CapEx and D&A story right before you wire everything else—or when you want a free, maintained module your team can duplicate while you decide which paid workbook matches the next stage. If auditors or lenders later require policy-grade fixed-asset records, treat those systems as the system of record and use this workbook as the planning layer that fed your decisions.