Laserfiche WebLink
On -Bill Financing Program - Preliminary Loan Term Calculation (LTC1) <br />Completion Date /Time: 12/2312015 8:01 AM <br />Project Number: 353 -15- 0500765634 <br />Service Account: 3 -000- 8761 -23 <br />Customer Number: 1 -0- 000 -7130 <br />Customer Account Number: 2 -24- 020 -8303 <br />OBF Application Receipt Date: 9/412015 <br />Project Type(s) : <br />Customized and Deemed <br />Market Segment: <br />Government and Institutions <br />$ <br />Business Name: <br />SANTA ANA, CITY OF <br />B.2. Estimated Annual Dollar($) Savings <br />Reference Name: <br />PRP -SANTA ANA LIBRARY LT & MC <br />Address: <br />690 W CIVIC CENTER D <br />City, CA Zip: <br />SANTA ANA, CA 92701 <br />PROJECT ECONOMIC SUMMARY <br />ACTUAL TERMS WILL BE CALCULATED <br />BASED ON FINAL REVIEW AND VERIFICATION <br />OF THE PROJECT INSTALLATION REPORT <br />LTC1 Reserved Amount is $152,648.95 <br />First month payment is $585.37 <br />101 subsequent monthly payments $1,505.58 <br />EXPLANATION <br />A. AVERAGE ELECTRIC BILLING RATE -- past 12 months (Cents /kWh) <br />$ 0.12678 Based on Billing History <br />186,538.64 <br />B. ENERGY EFFICIENCY PROJECT SAVINGS <br />$ <br />B.I. Estimated Annual Kilowatt Hour Savings (kWh) <br />142,508.4 From Approved Project Application <br />B.2. Estimated Annual Dollar($) Savings <br />$ 18,066.96 Estimated Annual kWh Savings x Average Rate = $ savings (B.1 x A) <br />B.3. Estimated Monthly Dollar($) Savings <br />$ 1,505.58 Estimated Monthly $ Savings (B.2 / 12) <br />C. COSTS <br />C.I. Estimated Total Project Cost <br />$ <br />186,538.64 <br />C.2. Excess Project Cost <br />$ <br />C.3. Estimated Total Rebate /Incentive <br />$ <br />33,889.69 <br />C.4. Other <br />$ <br />C.5. Estimated Potential Loan Amount (Gross Amount) <br />$ <br />152,648.95 <br />C.6. LTC1 Reserved Amount <br />C.7. LTC2 Reserved Amount <br />D. LOAN <br />D.I. Gross Amount for Potential Financing $ 152,648.95 <br />D.2. Monthly Loan Repayment Amount $1,505.58 <br />D.3. Actual loan term (Months) 102 <br />DA. Actual loan term (Years) 8.5 <br />E. LOAN LIMIT TESTS <br />E.I. Market Segment Amount of Loan Test (Min /Max Loan Amount) <br />E,1.1. Market Segment Minimum Loan Amount $ 5,000 <br />E,1.2. Market Segment Maximum Loan Amount $ 250,000 <br />E.1.3. Within Market Segment Limit? Y <br />E.2. Customer Loan Limit Test (Previous Loans for this Service Account) <br />E,2.1. Service Account Loan Amount Limit $ 250,000 <br />From Approved Project Application <br />Based on 20% Basic Lighting Cap Rule <br />From Approved Project Application <br />(C.1) - (C.2) - (C.3) - (C.4) <br />From LTC1 calculation following Approved Project Application <br />LTC2 Loan Amount per policy cannot be greater than LTC1 amount <br />Lesser of (C.5) or (C.6) or (E.1.2) or (E.2.3) or other roles apply <br />(B.3) <br />Time required to repay loan in months (subject to <br />exception analysis below) <br />Time required to repay loan in years: (D, 3) /12 <br />Minimum Loan Amount per Service Account or Bundle <br />Com, Ind, Ag = $100,000, G &I = $250,000 <br />Is D.1 within loan amount limits Y /N? <br />(E.1.2) or $1 M for G &I Facility <br />E,2.2, Previous Loans Reserved for this Service Account $ Total of previous OBF loans + reservations <br />E.2.3. Estimated Amount Eligible for Loans $ 250,000.00 (E.2.1) - (E.2.2), If < 0, then 0. <br />E.2.4. Within Available Amount? Y Is D.1.<E.2.3. Y /N? <br />E.3. Length of Loan Test <br />E.3.1. Loan Length Limit (months) 120 CIA (lighting) = 36, CIA (non- lighting) = 60, G &I = 120 months <br />E.3.2. Within Loan Length Limit? Y Is D.3 within limit Y /N? <br />E.4. Expected Useful Life (EUL)* Loan Length Limit Test <br />E.A.I. Applicable Measure FILL (months) 144 ELL in months of measure with greatest kWh contribution <br />E.4.2. Within ELL Loan Length Limit? Y Is D.3 within limit Y /N? <br />E.S. EXCEPTION ANALYSIS (If any E1 thru E.4. yields a "No") Exception Analysis Loan Minimum Requirement Test <br />Does the loan amount from Exception Analysis meet the $5K loan <br />minimum requirement? YES <br />E.5.1. First Payment Amount $ 585.37 <br />E.5.2. Subsequent Monthly Loan Repayment Amount $ 1,505.58 Based on minimum loan requirement of $6K and supplemental <br />E.5.3. Subsequent Monthly Payments 101 Exception Analysis, this amount qualifies for an estimated OBF <br />E.5.4. Net Amount for Financing $ 152,648.95 loan. <br />-Expected Ueeful Lire (EUL) '. Eaton measure to eri to perform sarlsherodly fora period af time . An EULror <br />sear oner9y efficiency measure Is assigned by the Callfous Energy Oommission (CEC) <br />LTC ID: 9673 <br />22A -19 <br />