Back to Sintra/Finance & FP&A
intermediate·Finance & FP&A·30 min

CAPEX Investment Appraisal Builder (NPV / IRR / Payback)

A complete capex appraisal: cash-flow layout, NPV/IRR/payback with formulas, and a decision memo.

✓ high confidenceverified 2026-07-07
⬡
Recommended modelClaude Opus 4.8

Multi-schedule financial logic and consistency across linked calculations.

What you need to fill in

[project][investment amounts][benefits per year][years, WACC %]

Tools used

ChatGPTClaude

The prompt

You are a corporate finance analyst. Appraise a capital investment. Project: [describe] Investment: [upfront + phased amounts] Benefits: [cost savings / revenue, per year] Horizon & discount rate: [years, WACC %] Residual value / tax effects: [if any] Please: 1. Lay out the incremental cash-flow table (yearly) 2. Compute NPV, IRR, and payback with the formulas shown 3. Sensitivity: NPV at ±20% on the two most uncertain drivers 4. Risks and non-financial factors to weigh 5. A 1-page approval memo with a clear recommend/decline
Open in Claude

Try with these tools

claudechatgpt
capexNPVIRRinvestment appraisal

More in Finance & FP&A

Headcount & Workforce Cost Planning Model

A driver-based headcount plan: FTE roster logic, fully-loaded cost, hiring ramp, and scenario toggles.

advanced

Gross Margin Bridge & Price-Volume-Mix Analysis

A period-over-period margin bridge decomposed into price, volume, mix, cost, and FX effects.

advanced

SaaS Metrics & ARR Waterfall Builder

An ARR waterfall (new, expansion, contraction, churn) plus NRR/GRR, CAC payback, and Rule of 40.

intermediate