Thermal Power Plant Financial Model
Budget: $250 – $750 USD
Financial Modeling Assignment – Thermal Power Plant
Objective: Build a dynamic, Excel-based project finance model for a utility-scale power plant using Alan Fedvedt Cycle (AFC) thermal technology.
Scope of Work:
Develop a full cash flow model from construction through operations (~30 years)
Incorporate detailed capital cost inputs (CapEx + contingency)
Structure a debt facility using assumptions for leverage, interest, amortization, and commitment fees
Include tax treatment and depreciation (bonus + MACRS or straight-line)
Calculate post-tax project IRR, equity IRR, and DCF valuation
Output clean, structured Excel workbook:
Running off formulas (no hardcoding)
Clearly labeled inputs and assumptions
Separate tabs for assumptions, outputs, and IRR/NPV summary
Inputs Provided:
Model template with instruction notes
Key financial and technical assumptions (CapEx, PPA price, fuel costs, term, etc.)
Deliverable:
Final Excel file (.xlsx) with functional formulas
All key calculations transparent and editable
Objective: Build a dynamic, Excel-based project finance model for a utility-scale power plant using Alan Fedvedt Cycle (AFC) thermal technology.
Scope of Work:
Develop a full cash flow model from construction through operations (~30 years)
Incorporate detailed capital cost inputs (CapEx + contingency)
Structure a debt facility using assumptions for leverage, interest, amortization, and commitment fees
Include tax treatment and depreciation (bonus + MACRS or straight-line)
Calculate post-tax project IRR, equity IRR, and DCF valuation
Output clean, structured Excel workbook:
Running off formulas (no hardcoding)
Clearly labeled inputs and assumptions
Separate tabs for assumptions, outputs, and IRR/NPV summary
Inputs Provided:
Model template with instruction notes
Key financial and technical assumptions (CapEx, PPA price, fuel costs, term, etc.)
Deliverable:
Final Excel file (.xlsx) with functional formulas
All key calculations transparent and editable