Infrastructure template

Our toll road template includes operations over a 60 year timeframe.  It enables analysis for as many as seven different tranches of debt, including a TIFIA loan, an MRA and DSRA, along with a DOT revenue sharing mechanism.  This semi-annual model uses a unique linear algebraic macro to size a dividend recapitalization while maintaining a consistent debt service coverage ratio (DSRA). The model enables the synthesis of actuals into the operations timeline and provides a full three-statement analysis, including a cash waterfall, income statement, and a balance sheet.  Our Dashboard will help you tell the story of your project to all interested stakeholders.

Corporate finance template

The Orbis LBO template enables a user to input actuals and projections for two management performance cases and the finance an acquisition of the target company using first and second lien debt along with equity. Resulting acquisition statistics will let you sensitize your financing structure and view the impacts on valuation. Our clean and clear dashboard will provide one source of truth for all members of the deal team.

Battery energy storage system (BESS) with tax equity

The Orbis stand-alone battery energy storage system (BESS) model takes a streamlined best practice approach to modeling for tax equity. We start with up to three cases (base, high, and low) for the full range of project inputs, both constant inputs (Inp_C) and series inputs (Inp_S). Our lean construction finance tab includes space for sponsor equity, construction loan, and a tax equity bridge loan, with the option to move between equity first and pro-rata draws during construction. We also include network upgrade deposits and reimbursements typical for BESS bid processes. Our generation section includes both fixed and variable expenses as well as operational letters of credit required for BESS projects. We convert our sources and uses during construction into a back levered debt solution. Full 704b capital accounts are included. We size tax equity using a fair market value (FMV) approach, enabling users to switch methods between capex, income, or average of the two. We also include fully dynamic three statement financial analysis as well as a simple to use dashboard and sensitivities.

Tax equity SLB template

Sale leaseback models evaluate the economics of building a solar project, selling it to an investor, then leasing the benefits of the project back from the investor. Our model includes a comprehensive capex schedule and dynamic depreciation calculations along with best practice formatted revenue and operating expense calculations. We also include a fully dynamic set of financial statements, including a cash waterfall, income statement, and balance sheet. Our model also helps you time and size the buyback option inherent to this structure using straightforward VBA copy and past macros.

Project finance template

Orbis Consulting’s free project finance download includes robust dashboard and summaries for the operations of a basic solar company, without tax equity. We provide monthly calculations of operations, including PPA, REC, and merchant revenues, along with both fixed and variable expenses. We also provide a finance structure that includes senior debt and a reserve account, along with all the associated debt sizing statistics. Fully dynamic three-statement analysis follows. Sensitize key operational and financial levers using our sensitivity tab.

Solar project finance (with tax equity)

Start from first principals to build a fully realized solar financing. Use integrated Inputs and Scenarios tabs to control all factors in your solar deal, from timing and construction through operations and financing with either debt and/or equity.

Check your work with a fully dynamic three-statement analysis. Analyze your deal in real time with an assortment of charts and graphs. Your Summary tab will help you tell your project’s story clearly to stakeholders. Available with full tax equity modules, including inside and outside capital accounts for both tax equity and sponsor members, back leverage, equity flip, and HLBV calculations. Use our dynamic Orbis macros to adjust your project and resize to clear accounting checks and optimize your flip accordingly.