Excel workbook previewFixed assets and capital expenditure
Capital Expenditure (Capex) Request Form
3 free downloads per account. Just your email and a 6-digit code.
About this template
A capital expenditure request form is how a department asks for money to buy or build a long-lived asset, and how finance makes sure the request is costed, justified and approved at the right level before anything is ordered. Auditors look for it when they test additions to fixed assets, and boards expect larger projects to arrive with a return on investment that someone has checked.
This Excel workbook has a four-part request form: request details, a cost breakdown that separates capital from expense items, a seven-year cash flow evaluation with NPV, IRR and payback, and an approval block that looks up the required approver from the total. A Capex Log tracks every request from submission to completion with approved versus actual spend. The capital and expense split on each line follows your written capitalization policy.
Who it is for
The plant controller or finance manager asked to put a proper approval form and log in front of capital spending before the next budget cycle.
What is inside
- Request Form sheet in four parts: request details, cost breakdown, financial evaluation and approval
- Cost breakdown with a capitalize dropdown per line, a contingency formula and live capital and expense totals
- Seven-year cash flow table with live NPV, IRR and simple payback off a hurdle rate you enter
- Required approval level looked up from the amount on an Approval Limits sheet with 4 editable levels
- Budget variance check, one extra approval level for requests outside the capex plan, and a 6-row sign-off table with decision dropdowns
- Capex Log sheet with 10 sample requests and 20 blank rows, approved versus actual spend, percent spent and overdue completion highlighting
- Worked example: a 490,925 dollar machining cell request for an invented manufacturer
How to use it
Set your approval levels on the Approval Limits sheet, then copy the Request Form for each new request.
Files
- XLSXcapital-expenditure-request-form.xlsx17 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What should a capex request include?
The asset or project, the business reason, the alternatives considered, a quoted cost breakdown, which costs are capital and which are expense, the expected in-service date and useful life, a financial evaluation such as NPV, IRR and payback, whether it was in the approved budget, and the approvals required for the amount. This form has a field for each of these.
Why split a request into capital and expense costs?
Not every cost of a project can be capitalized. Training, many service contracts and other costs that do not bring the asset to working condition are usually expensed under a capitalization policy. Splitting them on the request shows the budget holder the effect on the profit and loss account in the year of purchase and gives the fixed asset accountant the cost to record.
How is the payback period calculated here?
The form adds the net cash flows year by year, starting with the negative outlay in year 0. Payback is the last year in which the cumulative total is still negative, plus the fraction of the next year's cash flow needed to reach zero. It is a simple, undiscounted measure, so the form also shows NPV and IRR at the hurdle rate you enter.




