All schedules

Rate Base (Utility) Excel Template

Free Excel Financial Model Download

Regulated rate-base rollforward and allowed-return build for utilities.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this utility rate base schedule

A utility rate base schedule forecasts regulated asset base, allowed return, depreciation, capex additions, retirements, and regulatory adjustments. It converts infrastructure investment into earnings capacity under a regulated framework.

Use this free Excel rate base schedule preview to compare regulated utility model layouts for RAB rollforward, allowed return, revenue requirement, and capital investment assumptions. It is useful for power, water, transmission, and other regulated infrastructure models.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Frequently asked

What does the Rate Base (Utility) schedule do?+

A utility rate base schedule forecasts regulated asset base, allowed return, depreciation, capex additions, retirements, and regulatory adjustments. It converts infrastructure investment into earnings capacity under a regulated framework.

When should I use a Rate Base (Utility) schedule?+

Use this free Excel rate base schedule preview to compare regulated utility model layouts for RAB rollforward, allowed return, revenue requirement, and capital investment assumptions. It is useful for power, water, transmission, and other regulated infrastructure models.

What is included on this Rate Base (Utility) schedule page?+

The page includes a live Excel preview, source model examples, sheet-name variants, and related schedules for the rate base (utility) workflow.

Can I download the workbook behind this Rate Base (Utility) example?+

Yes. Use the download button or open one of the linked source models to download the full Excel workbook that contains this schedule.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview