Copy of Mortgage Amortization with Paydown

	B	C	D	E	F	G	H	M	N
1						JRsays	all rights reserved
2					Created with:		Google Docs
3					Get your own copy:		Click Here
4					Author:		JR
5						JRsays	all rights reserved
6	INPUTS:			RESULTS:		Original	with add'l payments
7	Loan Amount:		148,000.00	Final Payment:		25-Feb-2030	25-Aug-2025		tolerance
8	Term (years):		15	Loan Reduced By:		54 months			0.000005
9	Interest Rate:		4%	Total Interest Paid:		$49,052.86	$29,917.77		DefaultFirstDate
10	First Payment Date:		3/25/2015	Total Interest Saved:		$19,135.10			10/1/2023
11	Monthly Payment:		$1,094.74
12						see original annual amortization schedule
13	Monthly Amortization Schedule:							25-Aug-25
14	Payment	Date	Payment Amount	Interest Paid	Principal Paid	Additional Principal Payment	Principal Balance	126
15	1	3/25/2015	1,094.74	493.33	601.40		147,398.60	0
16	2	4/25/2015	1,094.74	491.33	603.41		146,795.19	0
17	3	5/25/2015	1,094.74	489.32	605.42		146,189.76	0
18	4	6/25/2015	1,094.74	487.30	607.44		145,582.33	0
19	5	7/25/2015	1,094.74	485.27	609.46		144,972.86	0
20	6	8/25/2015	1,094.74	483.24	611.50		144,361.37	0
21	7	9/25/2015	1,094.74	481.20	613.53		143,747.83	0
22	8	10/25/2015	1,094.74	479.16	615.58		143,132.25	0
23	9	11/25/2015	1,094.74	477.11	617.63		142,514.62	0
24	10	12/25/2015	1,094.74	475.05	619.69		141,894.93	0
25	11	1/25/2016	1,094.74	472.98	621.76		141,273.18	0
26	12	2/25/2016	1,094.74	470.91	623.83		140,649.35	0
27	13	3/25/2016	1,094.74	468.83	625.91		140,023.45	0
28	14	4/25/2016	1,094.74	466.74	627.99		139,395.45	0
29	15	5/25/2016	1,094.74	464.65	630.09		138,765.37	0
30	16	6/25/2016	1,094.74	462.55	632.19		138,133.18	0
31	17	7/25/2016	1,094.74	460.44	634.29		137,498.88	0
32	18	8/25/2016	1,094.74	458.33	636.41	10,000.00	126,862.48	0
33	19	9/25/2016	1,094.74	422.87	671.86		126,190.61	0
34	20	10/25/2016	1,094.74	420.64	674.10		125,516.51	0
35	21	11/25/2016	1,094.74	418.39	676.35		124,840.16	0
36	22	12/25/2016	1,094.74	416.13	678.60		124,161.56	0
37	23	1/25/2017	1,094.74	413.87	680.87		123,480.69	0
38	24	2/25/2017	1,094.74	411.60	683.14	5,000.00	117,797.55	0
39	25	3/25/2017	1,094.74	392.66	702.08		117,095.47	0
40	26	4/25/2017	1,094.74	390.32	704.42		116,391.05	0
41	27	5/25/2017	1,094.74	387.97	706.77		115,684.29	0
42	28	6/25/2017	1,094.74	385.61	709.12		114,975.16	0
43	29	7/25/2017	1,094.74	383.25	711.49		114,263.67	0
44	30	8/25/2017	1,094.74	380.88	713.86	5,000.00	108,549.82	0
45	31	9/25/2017	1,094.74	361.83	732.91		107,816.91	0
46	32	10/25/2017	1,094.74	359.39	735.35		107,081.56	0
47	33	11/25/2017	1,094.74	356.94	737.80		106,343.76	0
48	34	12/25/2017	1,094.74	354.48	740.26		105,603.50	0
49	35	1/25/2018	1,094.74	352.01	742.73		104,860.78	0
50	36	2/25/2018	1,094.74	349.54	745.20	5,000.00	99,115.57	0
51	37	3/25/2018	1,094.74	330.39	764.35		98,351.22	0
52	38	4/25/2018	1,094.74	327.84	766.90		97,584.32	0
53	39	5/25/2018	1,094.74	325.28	769.46		96,814.86	0
54	40	6/25/2018	1,094.74	322.72	772.02		96,042.84	0
55	41	7/25/2018	1,094.74	320.14	774.60		95,268.25	0
56	42	8/25/2018	1,094.74	317.56	777.18		94,491.07	0
57	43	9/25/2018	1,094.74	314.97	779.77		93,711.30	0
58	44	10/25/2018	1,094.74	312.37	782.37		92,928.93	0
59	45	11/25/2018	1,094.74	309.76	784.98		92,143.96	0
60	46	12/25/2018	1,094.74	307.15	787.59	5,000.00	86,356.37	0
61	47	1/25/2019	1,094.74	287.85	806.88		85,549.48	0
62	48	2/25/2019	1,094.74	285.16	809.57		84,739.91	0
63	49	3/25/2019	1,094.74	282.47	812.27		83,927.64	0
64	50	4/25/2019	1,094.74	279.76	814.98		83,112.66	0
65	51	5/25/2019	1,094.74	277.04	817.70		82,294.96	0
66	52	6/25/2019	1,094.74	274.32	820.42		81,474.54	0
67	53	7/25/2019	1,094.74	271.58	823.16		80,651.39	0
68	54	8/25/2019	1,094.74	268.84	825.90		79,825.49	0
69	55	9/25/2019	1,094.74	266.08	828.65		78,996.83	0
70	56	10/25/2019	1,094.74	263.32	831.42		78,165.42	0
71	57	11/25/2019	1,094.74	260.55	834.19		77,331.23	0
72	58	12/25/2019	1,094.74	257.77	836.97	10,000.00	66,494.26	0
73	59	1/25/2020	1,094.74	221.65	873.09		65,621.17	0
74	60	2/25/2020	1,094.74	218.74	876.00		64,745.17	0
75	61	3/25/2020	1,094.74	215.82	878.92		63,866.25	0
76	62	4/25/2020	1,094.74	212.89	881.85		62,984.40	0
77	63	5/25/2020	1,094.74	209.95	884.79		62,099.61	0
78	64	6/25/2020	1,094.74	207.00	887.74		61,211.87	0
79	65	7/25/2020	1,094.74	204.04	890.70		60,321.17	0
80	66	8/25/2020	1,094.74	201.07	893.67		59,427.50	0
81	67	9/25/2020	1,094.74	198.09	896.65		58,530.86	0
82	68	10/25/2020	1,094.74	195.10	899.64		57,631.22	0
83	69	11/25/2020	1,094.74	192.10	902.63		56,728.59	0
84	70	12/25/2020	1,094.74	189.10	905.64		55,822.95	0
85	71	1/25/2021	1,094.74	186.08	908.66		54,914.28	0
86	72	2/25/2021	1,094.74	183.05	911.69		54,002.59	0
87	73	3/25/2021	1,094.74	180.01	914.73		53,087.86	0
88	74	4/25/2021	1,094.74	176.96	917.78		52,170.09	0
89	75	5/25/2021	1,094.74	173.90	920.84		51,249.25	0
90	76	6/25/2021	1,094.74	170.83	923.91		50,325.34	0
91	77	7/25/2021	1,094.74	167.75	926.99		49,398.35	0
92	78	8/25/2021	1,094.74	164.66	930.08		48,468.28	0
93	79	9/25/2021	1,094.74	161.56	933.18		47,535.10	0
94	80	10/25/2021	1,094.74	158.45	936.29		46,598.81	0
95	81	11/25/2021	1,094.74	155.33	939.41		45,659.40	0
96	82	12/25/2021	1,094.74	152.20	942.54		44,716.86	0
97	83	1/25/2022	1,094.74	149.06	945.68		43,771.18	0
98	84	2/25/2022	1,094.74	145.90	948.83		42,822.35	0
99	85	3/25/2022	1,094.74	142.74	952.00		41,870.35	0
100	86	4/25/2022	1,094.74	139.57	955.17		40,915.18	0