Adjustable Rate Mortgage Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	L	M	N
1	Adjustable Rate Mortgage (ARM) Calculator
2
3
4		Loan Information
5
6			Loan amount	100,000.00
7			Term (years)	10
8			Starting interest rate	5.000%
9			First payment date	1/1/2023
10
11			Starting monthly payment	1,060.66
12				.
13
14		Summary
15
16			Total Payments	127,189.32
17			Total Interest	27,189.32
18			Total Principal	100,000.00
19			Internal Rate of Return	4.97%	{42}
20
21
22
23
24	Amortization Schedule									[42]	Payment Tracking
25	No.	Payment Date	Interest Rate	Payment Due	Extra Payment	Interest	Principal	Balance	Cumulative Interest	Cumulative Principal	Date Received	Actual PI Payment	Notes
26			5.000%	($100,000.00)				$ 100,000
27	1	1/1/2023	5.000%	1,060.66	139.34	416.67	783.33	99,216.67	416.67	783.33	5/1/2017	1,200.00
28	2	1/2/2023	5.000%	1,060.66	0.00	413.40	647.26	98,569.41	830.07	1,430.59
29	3	1/3/2023	5.000%	1,060.66	0.00	410.71	649.95	97,919.46	1,240.78	2,080.54
30	4	1/4/2023	5.000%	1,060.66	0.00	408.00	652.66	97,266.80	1,648.78	2,733.20
31	5	1/5/2023	5.000%	1,060.66	0.00	405.28	655.38	96,611.42	2,054.06	3,388.58
32	6	1/6/2023	5.000%	1,060.66	0.00	402.55	658.11	95,953.31	2,456.61	4,046.69
33	7	1/7/2023	5.000%	1,060.66	0.00	399.81	660.85	95,292.46	2,856.42	4,707.54
34	8	1/8/2023	5.000%	1,060.66	0.00	397.05	663.61	94,628.85	3,253.47	5,371.15
35	9	1/9/2023	5.000%	1,060.66	0.00	394.29	666.37	93,962.48	3,647.76	6,037.52
36	10	1/10/2023	5.000%	1,060.66	0.00	391.51	669.15	93,293.33	4,039.27	6,706.67
37	11	1/11/2023	5.000%	1,060.66	0.00	388.72	671.94	92,621.39	4,427.99	7,378.61
38	12	1/12/2023	5.000%	1,060.66	0.00	385.92	674.74	91,946.65	4,813.91	8,053.35
39	13	1/1/2024	5.000%	1,060.66	0.00	383.11	677.55	91,269.10	5,197.02	8,730.90
40	14	1/2/2024	5.000%	1,060.66	0.00	380.29	680.37	90,588.73	5,577.31	9,411.27
41	15	1/3/2024	5.000%	1,060.66	0.00	377.45	683.21	89,905.52	5,954.76	10,094.48
42	16	1/4/2024	5.000%	1,060.66	0.00	374.61	686.05	89,219.47	6,329.37	10,780.53
43	17	1/5/2024	5.000%	1,060.66	0.00	371.75	688.91	88,530.56	6,701.12	11,469.44
44	18	1/6/2024	5.000%	1,060.66	0.00	368.88	691.78	87,838.78	7,070.00	12,161.22
45	19	1/7/2024	5.000%	1,060.66	0.00	365.99	694.67	87,144.11	7,435.99	12,855.89
46	20	1/8/2024	5.000%	1,060.66	0.00	363.10	697.56	86,446.55	7,799.09	13,553.45
47	21	1/9/2024	5.000%	1,060.66	0.00	360.19	700.47	85,746.08	8,159.28	14,253.92
48	22	1/10/2024	5.000%	1,060.66	0.00	357.28	703.38	85,042.70	8,516.56	14,957.30
49	23	1/11/2024	5.000%	1,060.66	0.00	354.34	706.32	84,336.38	8,870.90	15,663.62
50	24	1/12/2024	5.000%	1,060.66	0.00	351.40	709.26	83,627.12	9,222.30	16,372.88
51	25	1/1/2025	5.000%	1,060.66	0.00	348.45	712.21	82,914.91	9,570.75	17,085.09
52	26	1/2/2025	5.000%	1,060.66	0.00	345.48	715.18	82,199.73	9,916.23	17,800.27
53	27	1/3/2025	5.000%	1,060.66	0.00	342.50	718.16	81,481.57	10,258.73	18,518.43
54	28	1/4/2025	5.000%	1,060.66	0.00	339.51	721.15	80,760.42	10,598.24	19,239.58
55	29	1/5/2025	5.000%	1,060.66	0.00	336.50	724.16	80,036.26	10,934.74	19,963.74
56	30	1/6/2025	5.000%	1,060.66	0.00	333.48	727.18	79,309.08	11,268.22	20,690.92
57	31	1/7/2025	5.000%	1,060.66	0.00	330.45	730.21	78,578.87	11,598.67	21,421.13
58	32	1/8/2025	5.000%	1,060.66	0.00	327.41	733.25	77,845.62	11,926.08	22,154.38
59	33	1/9/2025	5.000%	1,060.66	0.00	324.36	736.30	77,109.32	12,250.44	22,890.68
60	34	1/10/2025	5.000%	1,060.66	0.00	321.29	739.37	76,369.95	12,571.73	23,630.05
61	35	1/11/2025	5.000%	1,060.66	0.00	318.21	742.45	75,627.50	12,889.94	24,372.50
62	36	1/12/2025	5.000%	1,060.66	0.00	315.11	745.55	74,881.95	13,205.05	25,118.05
63	37	1/1/2026	5.000%	1,060.66	0.00	312.01	748.65	74,133.30	13,517.06	25,866.70
64	38	1/2/2026	5.000%	1,060.66	0.00	308.89	751.77	73,381.53	13,825.95	26,618.47
65	39	1/3/2026	5.000%	1,060.66	0.00	305.76	754.90	72,626.63	14,131.71	27,373.37
66	40	1/4/2026	5.000%	1,060.66	0.00	302.61	758.05	71,868.58	14,434.32	28,131.42
67	41	1/5/2026	5.000%	1,060.66	0.00	299.45	761.21	71,107.37	14,733.77	28,892.63
68	42	1/6/2026	5.000%	1,060.66	0.00	296.28	764.38	70,342.99	15,030.05	29,657.01
69	43	1/7/2026	5.000%	1,060.66	0.00	293.10	767.56	69,575.43	15,323.15	30,424.57
70	44	1/8/2026	5.000%	1,060.66	0.00	289.90	770.76	68,804.67	15,613.05	31,195.33
71	45	1/9/2026	5.000%	1,060.66	0.00	286.69	773.97	68,030.70	15,899.74	31,969.30
72	46	1/10/2026	5.000%	1,060.66	0.00	283.46	777.20	67,253.50	16,183.20	32,746.50
73	47	1/11/2026	5.000%	1,060.66	0.00	280.22	780.44	66,473.06	16,463.42	33,526.94
74	48	1/12/2026	5.000%	1,060.66	0.00	276.97	783.69	65,689.37	16,740.39	34,310.63
75	49	1/1/2027	5.000%	1,060.66	0.00	273.71	786.95	64,902.42	17,014.10	35,097.58
76	50	1/2/2027	5.000%	1,060.66	0.00	270.43	790.23	64,112.19	17,284.53	35,887.81
77	51	1/3/2027	5.000%	1,060.66	0.00	267.13	793.53	63,318.66	17,551.66	36,681.34
78	52	1/4/2027	5.000%	1,060.66	0.00	263.83	796.83	62,521.83	17,815.49	37,478.17
79	53	1/5/2027	5.000%	1,060.66	0.00	260.51	800.15	61,721.68	18,076.00	38,278.32
80	54	1/6/2027	5.000%	1,060.66	0.00	257.17	803.49	60,918.19	18,333.17	39,081.81
81	55	1/7/2027	5.000%	1,060.66	0.00	253.83	806.83	60,111.36	18,587.00	39,888.64
82	56	1/8/2027	5.000%	1,060.66	0.00	250.46	810.20	59,301.16	18,837.46	40,698.84
83	57	1/9/2027	5.000%	1,060.66	0.00	247.09	813.57	58,487.59	19,084.55	41,512.41
84	58	1/10/2027	5.000%	1,060.66	0.00	243.70	816.96	57,670.63	19,328.25	42,329.37
85	59	1/11/2027	5.000%	1,060.66	0.00	240.29	820.37	56,850.26	19,568.54	43,149.74
86	60	1/12/2027	5.000%	1,060.66	0.00	236.88	823.78	56,026.48	19,805.42	43,973.52
87	61	1/1/2028	5.000%	1,060.66	0.00	233.44	827.22	55,199.26	20,038.86	44,800.74
88	62	1/2/2028	5.000%	1,060.66	0.00	230.00	830.66	54,368.60	20,268.86	45,631.40
89	63	1/3/2028	5.000%	1,060.66	0.00	226.54	834.12	53,534.48	20,495.40	46,465.52
90	64	1/4/2028	5.000%	1,060.66	0.00	223.06	837.60	52,696.88	20,718.46	47,303.12
91	65	1/5/2028	5.000%	1,060.66	0.00	219.57	841.09	51,855.79	20,938.03	48,144.21
92	66	1/6/2028	5.000%	1,060.66	0.00	216.07	844.59	51,011.20	21,154.10	48,988.80
93	67	1/7/2028	5.000%	1,060.66	0.00	212.55	848.11	50,163.09	21,366.65	49,836.91
94	68	1/8/2028	5.000%	1,060.66	0.00	209.01	851.65	49,311.44	21,575.66	50,688.56
95	69	1/9/2028	5.000%	1,060.66	0.00	205.46	855.20	48,456.24	21,781.12	51,543.76
96	70	1/10/2028	5.000%	1,060.66	0.00	201.90	858.76	47,597.48	21,983.02	52,402.52
97	71	1/11/2028	5.000%	1,060.66	0.00	198.32	862.34	46,735.14	22,181.34	53,264.86
98	72	1/12/2028	5.000%	1,060.66	0.00	194.73	865.93	45,869.21	22,376.07	54,130.79
99	73	1/1/2029	5.000%	1,060.66	0.00	191.12	869.54	44,999.67	22,567.19	55,000.33
100	74	1/2/2029	5.000%	1,060.66	0.00	187.50	873.16	44,126.51	22,754.69	55,873.49