PITI Mortgage Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Mortgage Calculator
2
3
4	Mortgage Information						Balance at a Specified Year
5				Loan Amount	400,000.00				Balance at Year …	14
6				Annual Interest Rate	4.00%				Date	3/1/2034
7				Term Length (in Years)	30				Interest Paid	191,314.87
8				First Payment Date	4/1/2020				Principal Paid	129,508.01
9				Compound Period	Monthly				Outstanding Balance	270,491.99
10				Payment Frequency	Monthly					[42]
11				Monthly Payment	1,909.66		Summary
12									Years Until Paid Off	30
13				Home Value or Price	500,000.00				Number of Payments	360
14				Yearly Property Taxes	425.00				Last Payment Date	3/1/2050
15				Yearly H.O. Insurance	650.00				Total Payments	687,478.42
16				Monthly PMI					Total Interest	287,478.42
17				PITI Payment	1,999.24
18							Fixed-Rate or ARM
19	Extra Payments								Variable or Fixed Rate	Fixed Rate
20				Extra Payment					Years Rate Remains Fixed	3
21				Payment Interval	1				Interest Rate Cap	12.00%
22				Extra Annual Payment	$ -				Interest Rate Minimum	4.00%
23				Payment # (1-12)	1				Periods Between Adjustments	12
24				Total Extra Payments	-				Estimated Adjustment	0.25%
25				Interest Savings	-				Highest Monthly Payment	1,910.48
26
27				[42]
28
29					Totals Assuming No Extra Payments
30				Total Payments	$687,478
31				Total Interest	$287,478
32				Periods Per Year	12
33
34
35
36												Tax Deduction
37											Tax Bracket	25.00%
38											Effective Rate	3.000%
39											Tax Returned	71,870
40
41	Payment Schedule											[42]
42	No.	Payment Date	Year	Interest Rate	Interest Due	Payment Due	Extra Payments	Additional Payment	Principal Paid	Balance	Tax Returned	Cmltv Tax Returned
43										$400,000.00
44	1	4/1/2020		4.000%	1,333.33	1,909.66	0.00		576.33	399,423.67	333.33	333.33
45	2	5/1/2020		4.000%	1,331.41	1,909.66	0.00		578.25	398,845.42	332.85	666.19
46	3	6/1/2020		4.000%	1,329.48	1,909.66	0.00		580.18	398,265.24	332.37	998.56
47	4	7/1/2020		4.000%	1,327.55	1,909.66	0.00		582.11	397,683.13	331.89	1,330.44
48	5	8/1/2020		4.000%	1,325.61	1,909.66	0.00		584.05	397,099.08	331.40	1,661.85
49	6	9/1/2020		4.000%	1,323.66	1,909.66	0.00		586.00	396,513.08	330.92	1,992.76
50	7	10/1/2020		4.000%	1,321.71	1,909.66	0.00		587.95	395,925.13	330.43	2,323.19
51	8	11/1/2020		4.000%	1,319.75	1,909.66	0.00		589.91	395,335.22	329.94	2,653.13
52	9	12/1/2020		4.000%	1,317.78	1,909.66	0.00		591.88	394,743.34	329.45	2,982.57
53	10	1/1/2021		4.000%	1,315.81	1,909.66	0.00		593.85	394,149.49	328.95	3,311.52
54	11	2/1/2021		4.000%	1,313.83	1,909.66	0.00		595.83	393,553.66	328.46	3,639.98
55	12	3/1/2021	1	4.000%	1,311.85	1,909.66	0.00		597.81	392,955.85	327.96	3,967.94
56	13	4/1/2021		4.000%	1,309.85	1,909.66	0.00		599.81	392,356.04	327.46	4,295.41
57	14	5/1/2021		4.000%	1,307.85	1,909.66	0.00		601.81	391,754.23	326.96	4,622.37
58	15	6/1/2021		4.000%	1,305.85	1,909.66	0.00		603.81	391,150.42	326.46	4,948.83
59	16	7/1/2021		4.000%	1,303.83	1,909.66	0.00		605.83	390,544.59	325.96	5,274.79
60	17	8/1/2021		4.000%	1,301.82	1,909.66	0.00		607.84	389,936.75	325.46	5,600.24
61	18	9/1/2021		4.000%	1,299.79	1,909.66	0.00		609.87	389,326.88	324.95	5,925.19
62	19	10/1/2021		4.000%	1,297.76	1,909.66	0.00		611.90	388,714.98	324.44	6,249.63
63	20	11/1/2021		4.000%	1,295.72	1,909.66	0.00		613.94	388,101.04	323.93	6,573.56
64	21	12/1/2021		4.000%	1,293.67	1,909.66	0.00		615.99	387,485.05	323.42	6,896.98
65	22	1/1/2022		4.000%	1,291.62	1,909.66	0.00		618.04	386,867.01	322.91	7,219.88
66	23	2/1/2022		4.000%	1,289.56	1,909.66	0.00		620.10	386,246.91	322.39	7,542.27
67	24	3/1/2022	2	4.000%	1,287.49	1,909.66	0.00		622.17	385,624.74	321.87	7,864.15
68	25	4/1/2022		4.000%	1,285.42	1,909.66	0.00		624.24	385,000.50	321.36	8,185.50
69	26	5/1/2022		4.000%	1,283.34	1,909.66	0.00		626.32	384,374.18	320.84	8,506.34
70	27	6/1/2022		4.000%	1,281.25	1,909.66	0.00		628.41	383,745.77	320.31	8,826.65
71	28	7/1/2022		4.000%	1,279.15	1,909.66	0.00		630.51	383,115.26	319.79	9,146.44
72	29	8/1/2022		4.000%	1,277.05	1,909.66	0.00		632.61	382,482.65	319.26	9,465.70
73	30	9/1/2022		4.000%	1,274.94	1,909.66	0.00		634.72	381,847.93	318.74	9,784.43
74	31	10/1/2022		4.000%	1,272.83	1,909.66	0.00		636.83	381,211.10	318.21	10,102.64
75	32	11/1/2022		4.000%	1,270.70	1,909.66	0.00		638.96	380,572.14	317.68	10,420.32
76	33	12/1/2022		4.000%	1,268.57	1,909.66	0.00		641.09	379,931.05	317.14	10,737.46
77	34	1/1/2023		4.000%	1,266.44	1,909.66	0.00		643.22	379,287.83	316.61	11,054.07
78	35	2/1/2023		4.000%	1,264.29	1,909.66	0.00		645.37	378,642.46	316.07	11,370.14
79	36	3/1/2023	3	4.000%	1,262.14	1,909.66	0.00		647.52	377,994.94	315.54	11,685.68
80	37	4/1/2023		4.000%	1,259.98	1,909.66	0.00		649.68	377,345.26	315.00	12,000.67
81	38	5/1/2023		4.000%	1,257.82	1,909.66	0.00		651.84	376,693.42	314.46	12,315.13
82	39	6/1/2023		4.000%	1,255.64	1,909.66	0.00		654.02	376,039.40	313.91	12,629.04
83	40	7/1/2023		4.000%	1,253.46	1,909.66	0.00		656.20	375,383.20	313.37	12,942.40
84	41	8/1/2023		4.000%	1,251.28	1,909.66	0.00		658.38	374,724.82	312.82	13,255.22
85	42	9/1/2023		4.000%	1,249.08	1,909.66	0.00		660.58	374,064.24	312.27	13,567.49
86	43	10/1/2023		4.000%	1,246.88	1,909.66	0.00		662.78	373,401.46	311.72	13,879.21
87	44	11/1/2023		4.000%	1,244.67	1,909.66	0.00		664.99	372,736.47	311.17	14,190.38
88	45	12/1/2023		4.000%	1,242.45	1,909.66	0.00		667.21	372,069.26	310.61	14,500.99
89	46	1/1/2024		4.000%	1,240.23	1,909.66	0.00		669.43	371,399.83	310.06	14,811.05
90	47	2/1/2024		4.000%	1,238.00	1,909.66	0.00		671.66	370,728.17	309.50	15,120.55
91	48	3/1/2024	4	4.000%	1,235.76	1,909.66	0.00		673.90	370,054.27	308.94	15,429.49
92	49	4/1/2024		4.000%	1,233.51	1,909.66	0.00		676.15	369,378.12	308.38	15,737.87
93	50	5/1/2024		4.000%	1,231.26	1,909.66	0.00		678.40	368,699.72	307.82	16,045.68
94	51	6/1/2024		4.000%	1,229.00	1,909.66	0.00		680.66	368,019.06	307.25	16,352.93
95	52	7/1/2024		4.000%	1,226.73	1,909.66	0.00		682.93	367,336.13	306.68	16,659.61
96	53	8/1/2024		4.000%	1,224.45	1,909.66	0.00		685.21	366,650.92	306.11	16,965.73
97	54	9/1/2024		4.000%	1,222.17	1,909.66	0.00		687.49	365,963.43	305.54	17,271.27
98	55	10/1/2024		4.000%	1,219.88	1,909.66	0.00		689.78	365,273.65	304.97	17,576.24
99	56	11/1/2024		4.000%	1,217.58	1,909.66	0.00		692.08	364,581.57	304.40	17,880.63
100	57	12/1/2024		4.000%	1,215.27	1,909.66	0.00		694.39	363,887.18	303.82	18,184.45