Scenario Comparison Calculator

Instructions: Complete the values in the table to the left (Only the cells in grey). The output table shows how each financing scenario compares. Graphs and Cash Flows are shown below.

Disclaimer: This calculator is solely for the purpose of providing information only. The TPA is not giving advice on any subject, and is particulary not giving legal or financial advice in any form.
Project Inputs
Financing Scenario Comparison Summary
Project Cost
Utility Savings 
Self-Funded Conventional Loan PACE
Cap Rate
Out-of-Pocket Investment $0 $0
PACE Loan Inputs
Utility Savings (First Year)
Additional PACE costs
Annual Payment $0
PACE Term - Years
Cash Flow Impact Year 1
PACE Interest Rate
Conventional Loan Inputs
Net Project Cash Flow Year 2
Conventional Loan Term - Years
Years to Positive Project Cashflow
Conventional Loan Interest Rate
Debt Service Over Finance Term
Self-Funded Inputs
Include Opportunity Cost?
yes
10-Year Project NPV
Opportunity Cost 3.00% no
Property Value Increase (20-Year NPV)
[No canvas support]
[No canvas support]
  Self Funded Option Conventional Loan Option Pace Loan Option       Self Funded Option Conventional Loan Option Pace Loan Option      
Self-Funded Option   Conventional Loan Option   PACE Loan Option  
Breakeven Point     Breakeven Point     Breakeven Point    
NPV (10 yr)     NPV (10 yr)     NPV (10 yr)  
NPV (20 yr)     NPV (20 yr)     NPV (20 yr)  
Year Yearly Cash Flow Cumulative Cash Flow   Year Yearly Cash Flow Cumulative Cash Flow   Year Yearly Cash Flow Cumulative Cash Flow  
0   0 $0   0 $0  
1   1   1  
2   2   2  
3   3   3  
4   4   4  
5   5   5  
6   6   6  
7   7   7  
8   8   8  
9   9   9  
10   10   10  
11   11   11  
12   12   12  
13   13   13  
14   14   14  
15   15   15  
16   16   16  
17   17   17  
18   18   18  
19   19   19  
20   20   20  
21   21   21  
22   22   22  
23   23   23  
24   24   24  
25   25   25  
26   26   26  
27   27   27  
28   28   28  
29   29   29  
30   30   30