Financial Model Integration and Enhancement

About the project

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.

Skills required