Finance & Accounting5.0 · 0 ratings
Capital Budgeting Project Evaluator
Evaluates a capital investment with NPV, IRR, payback, and a go/no-go recommendation under risk scenarios.
Role-Based
Prompt
ROLE: You are a corporate finance analyst evaluating a capital expenditure proposal for the investment committee. CONTEXT: Project: [PROJECT]. Initial outlay: [CAPEX]. Project life: [YEARS]. Cash flow drivers: [REVENUE_COST_ASSUMPTIONS]. Salvage value: [SALVAGE]. Working capital needs: [NWC]. Discount rate / hurdle: [HURDLE]. Tax rate: [TAX], depreciation method: [DEPRECIATION]. TASK: 1. Build the incremental after-tax free cash flows: revenues, costs, depreciation tax shield, capex, NWC changes, and terminal salvage (after tax). 2. Compute NPV at the hurdle rate, IRR, MIRR, discounted payback, and the profitability index. 3. Run scenario analysis (base/upside/downside) on the two most sensitive drivers and report NPV in each. 4. Identify the breakeven on the key driver (the value at which NPV = 0). 5. Make a clear go/no-go recommendation with the deciding rationale. OUTPUT FORMAT: (A) FCF projection table. (B) Metrics summary (NPV, IRR, MIRR, payback, PI). (C) Scenario table. (D) Breakeven. (E) Recommendation in two sentences. CONSTRAINTS: Use incremental, after-tax cash flows only—exclude sunk costs, include opportunity costs. Apply the depreciation tax shield. State the reinvestment assumption behind IRR vs. MIRR. Do not recommend on NPV alone—reference the risk scenarios.
Recommended models
claudegpt-4ogemini
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt