Laserfiche WebLink
On -Bill Financing Program - Preliminary Loan Term Calculation (LTC1) <br />Completion Date/Time: <br />12/15/2016 7:26 AM <br />Project Number: <br />353-16-0500831244 <br />Service Account: <br />3-010-7153-96 <br />Customer Number: <br />1-0-000-7130 <br />Customer Account Number: <br />2-22-264-5319 <br />OBF Application Receipt Date: 2/16/2016 <br />Project Type(s): <br />Customized <br />Market Segment: <br />Government and Institutions <br />Business Name: <br />SANTA ANA, CITY OF <br />Reference Name: <br />POLICE DEPTLED LIGHTING 2 <br />Address: <br />60 CIVIC CENTER PLZ <br />City, CA Zip: <br />SANTA ANA, CA 92701-4060 <br />ACTUAL TERMS WILL BE CALCULATED <br />BASED ON FINAL REVIEW AND VERIFICATION <br />OF THE PROJECT INSTALLATION REPORT <br />LTC1 Reserved Amount is $526,499.31 <br />First month payment is $3,354.51 <br />113 subsequent monthly payments $4,629.60 <br />PROJECT ECONOMIC SUMMARY EXPLANATION <br />A. AVERAGE ELECTRIC BILLING RATE — past 12 months (Cents/kWh) <br />$ 0.11242 <br />Based on Billing History <br />$ 641,847.51 <br />C.2. Excess Project Cost <br />B. ENERGY EFFICIENCY PROJECT SAVINGS <br />C.3. Estimated Total Rebate/Incentive <br />$ 115,348.20 <br />B.I. Estimated Annual Kilowatt Hour Savings (kWh) <br />494,175.3 <br />From Approved Project Application <br />B.2. Estimated Annual Dollar($) Savings <br />$ 55.555.19 <br />Estimated Annual kWh Savings x Average Rate = $ savings (B.1 x A) <br />B.3. Estimated Monthly Dollar($) Savings <br />$ 4,629.60 <br />Estimated Monthly $ Savings (B.2 / 12) <br />C. COSTS <br />$ 3,354.51 <br />C.1. Estimated Total Project Cost <br />$ 641,847.51 <br />C.2. Excess Project Cost <br />$ - <br />C.3. Estimated Total Rebate/Incentive <br />$ 115,348.20 <br />CA. Other <br />$ <br />C.5. Estimated Potential Loan Amount (Gross Amount) <br />$ 526.499.31 <br />C.6. LTCl Reserved Amount <br />C.7. LTC2 Reserved Amount <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 pofcy cannot be greater than LTC1 amount <br />D. LOAN <br />D.1. Gross Amount for Potential Financing $ 526.499.31 Lesser of (C.5) or (C.6) or (E.1.2) or (E.2.3) or other miss apply <br />D.2. Monthly Loan Repayment Amount $4,629.60 (B.3) <br />D.3. Actual loan term (Months) 114 Time required to repay loan in months (subject to <br />exception analysis below) <br />D.4. Actual loan tens (Years) 9.5 Time required to repay loan In years: (D.3) /12 <br />E. LOAN LIMIT TESTS <br />E.1. Market Segment Amount of Loan Test (Min/Max Loan Amount) <br />E.1.1. Market Segment Minimum Loan Amount $ 5,000 Minimum Loan Amount per Service Account or Bundle <br />E.1.2. Markel Segment Maximum Loan Amount <br />E.1.3. Within Market Segment Limit? <br />E.2. Customer Loan Limit Test (Previous Loans for this Service <br />Facility Com, Ind, Ag = $100,000, G&I = $250,000 <br />Y Is D.1 within loan amount limits Y/N? <br />E.2.1. Service Account Loan Amount Limit $ 1,000,000 (E.1.2) or $1M 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 $ 1,000.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. YM? <br />E.3. Length of Loan Test <br />E.3.1. Loan Length Limit (months) <br />E.3.2. Within Loan Length Limit? <br />120 CIA (lighting) = 36, CIA (non -lighting) = 60, G&I = 120 months <br />Y Is D.3 within limit YIN? <br />E.4. Expected Useful Life (EUL)* Loan Length Limit Test <br />E.4.1. Applicable Measure EUL (months) 144 ELL in months of measure with greatest kWh contribution <br />E.4.2. Within EUL Loan Length Limit? Y Is 0.3 within limit YM? <br />E.5. EXCEPTION ANALYSIS (If any E.1 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 <br />$ 3,354.51 <br />E.5.2. Subsequent Monthly Loan Repayment Amount <br />$ 4,629.60 <br />E.5.3. Subsequent Monthly Payments <br />113 <br />E.5.4. Net Amount for Financing <br />$ 526,499.31 <br />'EmecLtl useful Lila (EUL): Each man sum '¢ eyncard b perform mf¢IeMnly fora Possal ortime. An EUL lar <br />eaM eneyyagcienrymessum is aasgmd ayee Celfoma EnergyComm icsun (CEC). <br />LTC ID: 11172 <br />25B-13 <br />