Estimated PV payback with accelerated loan payback.  Savings from new meter not included.
			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	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)	$43,007.77
2	$3,006.61	$2,458.66	$ 228.66	$(5,298.00)	$(1,324.50)	$4,102.46	$1,827.80	($2,274.65)	$44,734.47
3	$2,881.73	$2,221.73	$ 206.62	$ 2,015.11	$    503.78	$2,171.33	$2,675.01	$503.67	$43,570.80
4	$2,881.73	$2,162.18	$ 201.08	$ 1,961.10	$    490.27	$2,190.37	$3,761.58	$1,571.21	$41,280.04
5	$2,881.73	$2,045.01	$ 190.19	$ 1,854.82	$    463.71	$2,227.84	$3,742.53	$1,514.69	$38,928.63
6	$2,881.73	$1,924.69	$ 179.00	$ 1,745.69	$    436.42	$2,266.31	$3,742.53	$1,476.22	$36,495.37
7	$2,881.73	$1,800.20	$ 167.42	$ 1,632.78	$    408.20	$2,306.12	$3,742.53	$1,436.41	$33,977.43
8	$2,881.73	$1,671.38	$ 155.44	$ 1,515.94	$    378.99	$2,347.31	$3,742.53	$1,395.22	$31,371.86
9	$2,881.73	$1,538.06	$ 143.04	$ 1,395.02	$    348.76	$2,389.94	$3,742.53	$1,352.59	$28,675.60
10	$2,881.73	$1,400.13	$ 130.21	$ 1,269.92	$    317.48	$2,434.04	$3,742.53	$1,308.49	$25,885.51
11	$2,881.73	$1,257.40	$ 116.94	$ 1,140.46	$    285.12	$2,479.68	$3,742.53	$1,262.85	$22,998.33
12	$2,881.73	$1,109.67	$ 103.20	$ 1,006.47	$    251.62	$2,526.91	$3,742.53	$1,215.61	$20,010.65
13	$2,881.73	$   956.82	$   88.98	$    867.84	$    216.96	$2,575.79	$3,742.53	$1,166.74	$16,919.00
14	$2,881.73	$   798.66	$   74.28	$    724.38	$    181.10	$2,626.36	$3,742.53	$1,116.17	$13,719.76
15	$2,881.73	$   634.97	$   59.05	$    575.92	$    143.98	$2,678.70	$3,742.53	$1,063.83	$10,409.17
16	$2,881.73	$   465.59	$   43.30	$    422.29	$    105.57	$2,732.86	$3,742.53	$1,009.67	$  6,983.36
17	$2,881.73	$   290.32	$   27.00	$    263.32	$      65.83	$2,788.90	$3,742.53	$953.63	$  3,438.32
18	$2,881.73	$   108.96	$   10.13	$      98.83	$      24.71	$2,846.89	$3,742.53	$895.64	Paid Off
19+							$3,742.53	$3,742.53
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.
	Or in case of negative cash flow, added to the loan as if on a HELOC with the same interest rate as the main loan.
	In reality, the interest rate on our HELOC was lower than that of the main loan.
Numbers in blue represent assumption that future year savings will be same as current year savings.
Negative cash flow in the first year is caused by installation time, i.e. the couple of months after we got the loan but before the PV was online.
	Not being on the Time-of-Use billing schedule yet also had a negative effect.
Negative cash flow in the second year is caused by my not recognizing for a few months that one of our three inverters had stopped working.