Appendix B
Worksheets
Chapter 4
Chapter 5
Chapter 7
Typical Pump Operational Costs (See Table 7.4, Section 7.4, as an Example)
| Horse-Power of Pump or Circulator | Annual Operating Cost of Solar DHW at Various Electric Rates (3) | ||
| (1) kW Required | (2) Annual kWh (Based upon 8 h/day) | (3) (Annual Operating Cost at _______ ¢ per kWh Rate) Note: Multiply Column (2) by Column (3) Rate | |
| 1/25 | 0.085 | 248.2 | |
| 1/20 | 0.098 | 286.2 | |
| 1/12 | 0.185 | 540.2 | |
| 1/4 | 0.420 | 1226.4 | |
| 1/3 | 0.530 | 1547.6 | |
Chapter 7
Chapter 7
(From Table 7.5 Energy Costs & Savings Realized (System Output of _______ MBTUs at $______ per kWh)
| Years | Conventional Electrical DHW Fuel Costs at 5% per Year Inflation | Solar Operational and Maintenance Costs at 5% per Year Inflation | Savings Realized From Solar versus Conventional Electric | |||
| (1) Yearly | (2) Cumulative | (3) Yearly | (4) Cumulative | (1) − (3) Yearly | (2) − (4) Cumulative | |
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
| 12 | ||||||
| 13 | ||||||
| 14 | ||||||
| 15 | ||||||
| 16 | ||||||
| 17 | ||||||
| 18 | ||||||
| 19 | ||||||
| 20 | ||||||
| Total | Total | Total | ||||
Note: Reference Table 7.4 and include Operational and Maintenance Costs.
Chapter 8
(Developed from Table 8.3) Energy Costs at _____ cents/kWh (e.g. Table 8.2) for _________ kW and Savings Realized from electricity produced by a PV Array
| Years | Conventional Electrical Demand Costs at 5% per Year Inflation | Solar PV Module Losses at 1.0% Output Degradation per Year | Savings Realized from Solar PV versus Electric Utility | |||
| (1) Yearly | (2) Cumulative | (3) Yearly | (4) Cumulative | (5) Yearly (1) – (3) | (6) Cumulative (2) – (4) | |
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
| 12 | ||||||
| 13 | ||||||
| 14 | ||||||
| 15 | ||||||
| 16 | ||||||
| 17 | ||||||
| 18 | ||||||
| 19 | ||||||
| 20 | ||||||
| Total | Total | Total | ||||
Note: Reference Tables 8.2, Section 8.1 and 8.3, Section 8.3 as Examples and include Degradation Losses.
Chapter 9
(From Table 9.4) Visualizing the Capital Recovery Factor
| Year | (1) | (2) | (3) (1) + (2) | (4) | (5) (3) – (4) | (6) (4) – (2) |
| Money Owed at Start of Year | Interest Owed at End of Year at ___% (Insert Borrowed Interest Rate) | Principal and Interest Owed at End of Year | Series (R) of Repayments | Money Owed at End of Year after Repayment | Recovery Capital | |
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| Total | ||||||
