| 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,761.58 | $1,696.59 | $2,686.47 | $4,383.06 | $25,017.90 |
| 6 | $2,544.17 | $1,220.85 | $ 113.54 | $ 1,107.31 | $ 276.83 | $2,153.80 | $3,761.58 | $1,607.78 | $2,686.47 | $4,294.25 | $19,400.33 |
| 7 | $2,544.17 | $ 933.44 | $ 86.81 | $ 846.63 | $ 211.66 | $2,245.70 | $3,761.58 | $1,515.88 | $2,686.47 | $4,202.36 | $13,587.25 |
| 8 | $2,544.17 | $ 636.04 | $ 59.15 | $ 576.89 | $ 144.22 | $2,340.79 | $3,761.58 | $1,420.79 | $2,686.47 | $4,107.26 | $ 7,571.86 |
| 9 | $2,544.17 | $ 328.27 | $ 30.53 | $ 297.74 | $ 74.44 | $2,439.20 | $3,761.58 | $1,322.38 | $2,686.47 | $4,008.85 | $ 1,347.12 |
| 10 | $2,544.17 | $ 21.10 | $ 1.96 | $ 19.14 | $ 4.78 | $2,537.42 | $3,761.58 | $1,224.16 | $2,686.47 | $3,910.63 | Paid off |
| 11+ | $0.00 | $0.00 | $3,761.58 | $3,761.58 | $2,686.47 | $6,448.05 | |||||
| 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. | |||||||||||