Base contract prices
- Levered IRR
- 47.99%
- Unlevered IRR
- 25.32%
- Master check
- OK
Enlarge the actual dashboard ↗Look inside the financial model.
Explore the assumptions, cash-flow structure and checks in the T4 suite workbook. Start with the three-step walkthrough, then watch the full tour or download the input checklist.
From assumptions to a financial case.
Explore three parts of the actual workbook. Each view explains what to enter, what to read and what to check.
Make the financing assumptions explicit.
This view shows the loan-to-cost targets and financing rates used by the illustrative case.
- Record the amount of project cost funded with debt.
- Separate senior construction and mezzanine assumptions.
- Keep a source and status beside each input.
The workbook uses those assumptions in its funding and cash-flow calculations.
Suite T4 v3.0 · Illustrative case. Follow the documented calculation steps and review the model checks. The standalone package has its own input adapter and instructions.
One assumption changes. See the effect.
Two recorded runs of the same illustrative case in desktop Excel. Contract prices fall by 10%; the other business inputs stay the same.
Enlarge the actual dashboard ↗Contract prices −10%
- Levered IRR
- 41.82%
- Unlevered IRR
- 22.61%
- Master check
- OK
Enlarge the actual dashboard ↗These are illustrative model outputs, not forecast returns. Both runs completed native calculation and reported an OK master check. Restoring the original prices reproduced the base outputs.
How should I read this example?
This example uses the suite T4 v3.0 workbook. It compares the base contract prices with a 10% reduction while keeping the other business inputs unchanged. Values are illustrative and before corporate income tax; they are not forecasts or promised returns.
Follow the documented interest-update procedure and read the Checks sheet alongside the dashboard. The standalone package has its own input adapter and instructions. Choose the package that matches the inputs and workflow you need.
The 90-second workbook tour.
01:30 · ENGLISH CAPTIONS · T4 SUITE WORKBOOKRead the transcript
A captioned presentation of native Excel exports from the T4 suite workbook. The video presents an illustrative case calculated in desktop Excel, with values before corporate income tax. The standalone package includes its own input adapter and instructions.
Prepare your case
before opening Excel.
A two-page reference covering assumptions, sources, model requirements and the first-run sequence.
PDF · 2 pages · No email required
- Define timing and operating assumptions.
Record the project start, contract terms, capacity and recurring costs relevant to the model.
- Prepare the power and cost inputs.
Use the suite handoffs or the standalone package instructions for the capacity, energy-cost and CapEx series.
- Document funding and exit assumptions.
Keep the sources, units and dates behind the inputs visible.
- Follow the update and check sequence.
Work on a copy, refresh the interest inputs and inspect the checks before using outputs.
The workbook tour.
Use these chapters with the downloadable checklist and the manual supplied with your package.
Financing assumptions
Set the loan-to-cost targets and financing rates. Keep the source and status of each input visible.
Trace the annual cash flow
Read operating income, capital expenditure and investor cash flows together. These figures belong to an illustrative case.
Read the base case
The illustrative base case shows a base-case levered IRR of 47.99 percent, before corporate income tax. This is an illustrative model output, not a forecast or promised return.
Change one business assumption
Reducing contract prices by 10 percent lowers levered IRR to 41.82 percent. Other business inputs remain unchanged. Recalculation completes and the master check reports OK.
Review all 22 controls
All 22 controls report OK in the reviewed base case. The original prices were restored and reproduced the initial outputs.
Compare selected sensitivities
Compare the sensitivity results with your case assumptions and follow the documented calculation steps. The final model packages are available on Flevy; choose the standalone model or the five-model suite for your workflow.
