Financing assumptions
Set the loan-to-cost targets and financing rates. Keep the source and status of each input visible.
ExpertProA captioned tour of native Excel exports from the T4 suite workbook, using an illustrative case calculated in desktop Excel. Follow the financing inputs, the cash flows, one price sensitivity and the model checks.
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.
Use these chapters with the downloadable checklist and the manual supplied with your package.
Set the loan-to-cost targets and financing rates. Keep the source and status of each input visible.
Read operating income, capital expenditure and investor cash flows together. These figures belong to an illustrative 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.
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.
All 22 controls report OK in the reviewed base case. The original prices were restored and reproduced the initial outputs.
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.
The standalone model covers the financial case. The suite adds site screening, power, capital budget and scenario comparison.