Laserfiche WebLink
On -Bill Financing Program - Loan Terms Calculations 1 <br />PREPARED FOR: <br />Gary L. Levingslon <br />Offer Manager, Financial Solutions Element <br />Customer Energy Efficiency &Solar Division <br />Southem California Edison, an Edison /ntemahonal Company <br />Completion Daterrime: 2/16/11 3:48 PM <br />Universal Project Number: PSAP -10- 004891 <br />Customer Number: 1- 000 - 0071 -30 <br />Service Account Number: 3- 001 - 3272 -81 <br />OBF Application Receipt Date: 11/1/2010 <br />Project Type(s) : Customized <br />Market Segment: Govt & Inst <br />Business Name: CITY OF SANTA ANA <br />Reference Name: S. MAIN / EDINGER LED <br />Address: 1465 1/2 S MAIN ST <br />City, CA Zip: SANTA ANA, CA 92707 <br />—ESTIMATED LOAN TERMS "' I <br />ACTUAL TERMS WILL BE CALCULATED BASED ON FINAL <br />REVIEW AND VERIFICATION OF THE PROJECT INSTALLATION <br />REPORT <br />LTC1 completed as of 2116/11 due to recently collected and approved <br />tariff rate, therefore, this loan app will be not be Wait-Listed as per <br />program management. <br />PROJECT ECONOMIC SUMMARY <br />„" <br />rR . F <br />$ <br />Total electricity charges divided by the amount of electricity purchased <br />A.) AVERAGE ELECTRIC BILLING RATE •• past 12 months (Cenlsll<Wh) <br />• <br />during previous 12 months <br />B.) ENERGY EFFICIENCY PROJECT SAVINGS <br />CIA =60 G &1 =120 <br />B.1. Estimated Annual Kilowatt Hour Savings (kWh) <br />8,322.00 <br />For Customize, from OBF Application, calculated b Customer <br />For Express Pending, SCE calculations based on Mess solution code <br />B.2. Estimated Annual Dollar($) Savings (B.1 x A) $ <br />682.40 <br />no KWh savings x ave rate = $$ savings <br />B.3. Estimated Monthly Dollar($) Savings (6.2/12) $ <br />56.87 <br />Monthly $savings <br />C.) COSTS <br />Is D.3 within limit YIN? <br />C.1. Estimated Total Project Cost <br />7,350.00 <br />From OBF Application <br />C.2. Estimated Total Rebate /Incentive <br />416.10 <br />From OBF Application <br />C.3. Estimated Potential Loan Amount (Net Amount) $ <br />6,933.9 <br />1 Maximum eligible loan amount <br />D.) LOAN <br />10 <br />D.2. Monthly Loan Repayment Amount <br />D.3. Estimated loan term (Months) <br />DA. Estimated loan term (Years) <br />$ 6.933.90 C.3__ _ <br />56.87 B.3 <br />121.9 Time required to repay loan - months <br />10.2 Tme required to repay loan -years <br />E.) LOAN LIMIT TESTS <br />E.I. Market Segment Amount of Loan Test (Maximum Loan Amount per Service Account) <br />E1.1 Market Segment Minimum /Maximum Loan Amount $ 1,000,000.00 Min /Max loan amount per service account <br />E.1.2.Within Market Segment Limit? Y Is D.1 within loan amount limits Y /N? <br />E.2. Customer Loan Limit Test (Previous Loans for this Customer) <br />E.2.1. Customer Loan Amount Limit <br />E.2.2. Previous Loans Reserved for this Customer <br />E.2.3. Estimated Amount Eligible for Loans <br />E.2.4. Within Available Amount? <br />E.3. Market Seament Lenath of Loan Test <br />E.3.1.Market Segment Loan Length Limit <br />E.3.2. Within Market Segment Loan Length Limit? <br />EA. Expected Useful Life (EULI' Loan Length Limit Test <br />E.4.1. Applicable Measure EUL <br />E.4.2. Within EUL Loan Length Limit? <br />E.5. EXCEPTION ANALYSIS (If Test 1 and /or Test 2 yields a "No" t <br />E.5.1. Monthly Loan Repayment Amount <br />E.52 Net Amount for Financing <br />E.5.3. Max Allowable Loan Terms (Months) <br />E.5.4. Max Allowable Loan Terms (Years) <br />Expected Useful Life (EUL): Each measure is expected to perform satisfactorily for a period of time. An EUL for each energy efficiency measure is assigned <br />by the California Energy Commission (CEC). The EUL for the measure involved in the energy efficiency project. <br />Agreements to Provide, Install and Fund Exhibit 5 <br />LED Street Lights 25F -28 <br />Max total loans amount per customer <br />Previous loans reserved <br />$ <br />Remaining loan funds available <br />Y <br />Is 0. 1, < E.2.3. YIN? <br />120 <br />CIA =60 G &1 =120 <br />N <br />Is D.3 within limit YIN? <br />EUL of measure with greatest kWh contribution <br />144 <br />Y <br />Is D.3 within limit YIN? <br />$ <br />56.87 <br />$ <br />6,824.04 <br />20 <br />10 <br />Expected Useful Life (EUL): Each measure is expected to perform satisfactorily for a period of time. An EUL for each energy efficiency measure is assigned <br />by the California Energy Commission (CEC). The EUL for the measure involved in the energy efficiency project. <br />Agreements to Provide, Install and Fund Exhibit 5 <br />LED Street Lights 25F -28 <br />