Financial Model Integration and Enhancement

Senior Financial Modeling / Accounting Consultant – Integrated Expansion, Financing & 3-Statement Model

We are looking for an experienced finance/accounting professional to take two existing working financial models and integrate and professionalize them into one investor-, lender- and Board-ready model.

We have already completed substantial work and are not starting from a blank sheet. We need someone senior enough to review what has been built, challenge the logic and assumptions, identify any gaps, improve the accounting and financing treatment, and bring the models together using professional financial-modeling standards.

What We Have Today

We currently have two standalone working models that need to be integrated:

Expansion Model → Underlying Project Economics / IRR

Financing Model → Government Grant Bridge + Term Debt + PCH Equity

The Expansion Model includes the current project assumptions around volumes, pricing, incremental operating costs, capital expenditures, government funding, customer capital contributions, taxes and project returns.

The Financing Model has been developed separately to look at how PCH's required contribution could be financed, including government grant bridge financing, term debt, interest, principal repayments, equity requirements, DSCR and liquidity.

Immediate Scope – Integrate the Two Models

The first and immediate deliverable is to combine these two models into one professional integrated Expansion + Financing Model.

The underlying project economics should remain clearly identifiable from the financing structure so that we can separately understand the economics of the expansion and the impact of financing those economics.

The integrated model should clearly and correctly model:

Expansion revenue and operating costs
Expansion operating cash flow
Expansion capital expenditures and construction timing
Government grant funding and timing
Customer capital contributions
PCH permanent capital requirement
Construction-period cash requirements
Government grant bridge financing
Term debt draws
Interest expense and financing fees
Principal repayments and amortization
PCH equity contributions
Cash available for debt service (CFADS)
Debt service coverage ratio (DSCR)
Peak PCH cash/liquidity requirement
Underlying project IRR and NPV
Levered PCH equity IRR and cash returns
Appropriate sensitivities and downside scenarios

The financing structure needs to work properly from a cash perspective. Debt draws, construction expenditures, government reimbursements, bridge repayments, interest, fees and term-debt repayments all need to flow through the model correctly.

We expect the consultant to review and improve the existing work rather than simply combine spreadsheets or accept the existing formulas.

Next Stage – Full PCH Integration

Once the Expansion + Financing Model is complete, the model architecture needs to be set up so that we can subsequently integrate the full existing PCH business:

PCH Financials → Existing Business + Expansion + Financing

The ultimate model should integrate a complete 3-statement forecast:

Income Statement
Balance Sheet
Cash Flow Statement

The existing PCH business, expansion economics and financing should ultimately flow through these statements on a consolidated basis.

The model should therefore be built from the beginning with this future integration in mind. We do not want to have to rebuild the expansion and financing model when the existing business is added.

Covenant & Credit Analysis

The next layer will be:

Covenant Analysis → Consolidated Leverage + CFADS + DSCR + Liquidity

Once the existing business is incorporated, we need to be able to understand the impact of the expansion and financing on the entire company, including consolidated EBITDA and cash flow, total debt and net debt, debt service, CFADS, DSCR, leverage ratios, minimum liquidity, peak funding requirements, covenant compliance and headroom, debt capacity, financing requirements, and downside/stress cases.

The objective is to understand not only whether the expansion generates an acceptable return, but also how it affects the overall PCH business, balance sheet, liquidity and bank covenants.

Returns & Valuation

The integrated model should also incorporate the appropriate investment and valuation metrics, including IRR, NPV and WACC, while clearly distinguishing between:

Underlying project returns before financing
Levered PCH equity returns after financing
Consolidated company financial performance

The model should make it easy to understand how changes in financing assumptions affect equity returns without confusing financing benefits or costs with the underlying economics of the project.

Confidentiality

Confidentiality is extremely important.

For confidentiality reasons, we will not initially provide the complete existing PCH financial statements.

We can provide the GL/account structure and other information necessary to establish the appropriate 3-statement architecture. The model should be designed so that the existing PCH financials can subsequently be populated and integrated efficiently without requiring a significant rebuild.

The consultant will ultimately be working with commercially sensitive project, customer, government funding, financing and company information. We require strict confidentiality and are prepared to have an NDA in place.

What We Are Looking For

Strong finance and accounting experience is mandatory.

This is not simply an Excel assignment. We are looking for someone who understands the finance and accounting behind the formulas and can independently identify issues and improve the work.

Relevant experience would include:

Integrated 3-statement financial modeling
Project and/or infrastructure finance
Construction financing
Term debt and debt amortization
Government grants and bridge financing
Debt sizing
CFADS and DSCR
Bank covenant modeling
Corporate finance
Accounting and tax/depreciation modeling
IRR, NPV and WACC analysis
Capital-intensive businesses
Board/investor/lender financial models
Scenario and sensitivity analysis

CPA/CA, CFA, investment banking, project finance, infrastructure finance, senior FP&A or similar experience would be highly relevant.

We are not looking for someone whose primary qualification is simply advanced Excel skills. We need someone with the financial and accounting background to understand the transaction, challenge the model and build something that can withstand review by management, the Board, investors, lenders and professional advisors.

End Goal

The ultimate structure is:

Expansion Economics → Financing → Integrated 3-Statement PCH Forecast → Covenant Analysis → Valuation / Returns

The end result should be one professional, transparent and easily auditable model that can ultimately be used for Board approval, investment decisions, government funding discussions, bank and project-financing discussions, investor analysis, debt sizing and capital structure, covenant and liquidity management, scenario and sensitivity analysis, and ongoing forecasting and capital allocation.

The model needs clear assumptions, auditable formulas and the ability for management to easily update the forecast as project, financing and operating assumptions change.

Timing

We are looking for someone who can start immediately and deliver a completed first version of the integrated model within approximately one week.

I will be available throughout the process to answer questions, clarify assumptions and provide additional information as required.

Given the timeline, we need someone who can take ownership of the work, identify issues independently and move quickly rather than requiring detailed direction on every aspect of the model.

When responding, please outline your relevant finance/accounting and modeling experience, particularly with integrated 3-statement models, project/debt financing, DSCR/covenant analysis and Board/lender-grade financial models. Please also provide examples of similar assignments and confirm your ability to start immediately and work within the one-week timeframe.