Financial Model

General Assumptions

Start Year

Interval

Revenue Assumptions

IRR Calculation Method

CalculationTarget IRR

Price per Unit (R1)

Initial Units (R2)

Revenue Growth Rate (R3)

Operation Period (Yrs) (R4)

Target Equity IRR

Cost Assumptions

COGS (% of Rev) (C1)

OPEX Growth Rate (C2)

Initial Personnel (C3)

Initial Marketing (C4)

Initial Other OPEX (C5)

Capex Assumptions

Building Cost (K1)

Equipment Cost (K2)

Building Life (Yrs) (K3)

Equipment Life (Yrs) (K4)

Construction Period (Yrs) (K5)

Financing Assumptions

Leverage (F1)

Target DSCR

Min Leverage

Max Leverage

Equity Timing (F4)

Repayment Method

Loan Assumptions

Senior Loan 1

Weight

Interest Rate

Loan Term (Yrs)

Upfront Fee %

Commitment Fee %

Senior Loan 2

Weight

Interest Rate

Loan Term (Yrs)

Upfront Fee %

Commitment Fee %

ITC Facility

Weight

Interest Rate

Loan Term (Yrs)

Upfront Fee %

Commitment Fee %

Year 1 Repayment %

Tax Assumptions

CIT Rate

Loss Carry Forward (Yrs)

Tax Holiday (Yrs)

Tax Credit (ITC) Rate (% of Capex)

Click "Run Model" to generate results