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. |
|
|
|
|
|
|
|
|
|
|
|
|
|