| Estimated PV payback with accelerated mortgage payoff and savings from new meter | |||||||||||
| California Income Tax Rate | Assumed Federal Tax Rate | ||||||||||
| 9.30% | 25% | ||||||||||
| Year | Regular Mortgage Payments | Interest Paid | CA tax mortgage deduction | Interest - CA deduction -15% CA tax credit | Federal Tax Deduction | Net Cost of Loan | PV Savings | Cash Flow PV | Estimated Savings from New Meter | Cash Flow PV and New Meter | End of Year Mortgage Principal |
| 1 | $3,758.27 | $3,062.85 | $ 284.85 | $ 2,778.00 | $ 694.50 | $2,778.92 | $2,009.73 | ($769.19) | $2,692.66 | $1,923.47 | $40,315.11 |
| 2 | $3,006.61 | $2,299.69 | $ 213.87 | $(5,442.18) | $(1,360.55) | $4,153.29 | $1,827.80 | ($2,325.49) | $2,439.40 | $113.91 | $39,494.27 |
| 3 | $2,544.17 | $1,961.46 | $ 182.42 | $ 1,779.04 | $ 444.76 | $1,916.99 | $2,675.01 | $758.02 | $2,460.95 | $3,218.97 | $35,692.60 |
| 4 | $2,544.17 | $1,766.99 | $ 164.33 | $ 1,602.66 | $ 400.66 | $1,979.17 | $3,761.58 | $1,782.41 | $2,686.47 | $4,468.88 | $30,446.54 |
| 5 | $2,544.17 | $1,498.59 | $ 139.37 | $ 1,359.22 | $ 339.81 | $2,064.99 | $3,742.53 | $1,677.54 | $2,211.85 | $3,889.38 | $25,511.58 |
| 6 | $2,544.17 | $1,246.12 | $ 115.89 | $ 1,130.23 | $ 282.56 | $2,145.72 | $3,742.53 | $1,596.81 | $2,211.85 | $3,808.66 | $20,404.88 |
| 7 | $2,544.17 | $ 984.83 | $ 91.59 | $ 893.24 | $ 223.31 | $2,229.27 | $3,742.53 | $1,513.26 | $2,211.85 | $3,725.11 | $15,120.43 |
| 8 | $2,544.17 | $ 714.47 | $ 66.45 | $ 648.02 | $ 162.01 | $2,315.71 | $3,742.53 | $1,426.81 | $2,211.85 | $3,638.66 | $ 9,652.08 |
| 9 | $2,544.17 | $ 434.71 | $ 40.43 | $ 394.28 | $ 98.57 | $2,405.17 | $3,742.53 | $1,337.36 | $2,211.85 | $3,549.21 | $ 3,993.41 |
| 10 | $2,544.17 | $ 145.19 | $ 13.50 | $ 131.69 | $ 32.92 | $2,497.74 | $3,742.53 | $1,244.79 | $2,211.85 | $3,456.63 | Paid off |
| 11+ | $0.00 | $0.00 | $3,742.53 | $3,742.53 | $2,211.85 | $5,954.38 | |||||
| Assumptions about mortgage amount and interest rates are detailed in the Mortgage tab. | |||||||||||
| In this analysis, the cash flow from the PV and meter is used at the end of the year to pay down the mortgage faster. | |||||||||||
| Numbers in blue represent assumption that future year savings will be same as current year savings. | |||||||||||
| Federal tax deduction in year two is negative because we had to pay Federal income tax on the 15% tax credit that we got from California. | |||||||||||
| New Meter Savings assumes that if we still had the old meter, that it would continue to read a usage of 80 KWH/day. | |||||||||||
| When the new meter was put in, the new meter read a usage 46% lower than the old meter (independent of the PV array). | |||||||||||
| We suspect the old meter read Volt-Amperes and the new meter reads Watts | |||||||||||
| and that the difference is caused by the Power Factor from the inductive loads of the computers. | |||||||||||