simple-interest-loan-calculator.xlsx

	A	B	C	D	E	F	G	H	I	K
1	Simple Interest Loan Calculator
2
3		Borrower:							[Lender Name]	Simple Interest Loan Calculator
4			[Address, City, ST ZIP]						[Address, City, ST ZIP]	© 2008-2018 Vertex42 LLC
5			Phone: [Phone]						Phone: [Phone]
6
7	Loan Information				[42]	Summary				See the Help worksheet for instructions.
8			Loan Amount	$ 100,000.00				Daily Interest Rate	0.01643836%
9			Annual Interest Rate	6.00%				Number of Payments	180	This spreadsheet is for Personal Use Only. You may purchase a commercial license if you are a lender or are using the spreadsheet for business.
10			Term of Loan in Years	15				Total Payments	151,837.79
11			Loan Issue Date	1/1/2018				Total Interest	51,837.79
12			First Payment Date	2/1/2018				Balloon Payment	-
13			Payment Frequency	Monthly					.	Purchase the Commercial Version
14			Days in Year	365
15			Balloon Payment #
16			Rounding	On	TRUE
17
18			Est. Monthly Payment	$ 844.64	(estimate)
19			Actual Monthly Payment		FALSE
20
21	Amortization Schedule
22	Pmt No.	Date	Payment Due	Interest Accrued		Interest Balance	Principal Paid	Principal Balance	Total Owed
23		1/1/18						100,000.00	100,000.00
24	1	2/1/18	844.64	509.59		0.00	335.05	99,664.95	99,664.95
25	2	3/1/18	844.64	458.73		0.00	385.91	99,279.04	99,279.04
26	3	4/1/18	844.64	505.92		0.00	338.72	98,940.32	98,940.32
27	4	5/1/18	844.64	487.92		0.00	356.72	98,583.60	98,583.60
28	5	6/1/18	844.64	502.37		0.00	342.27	98,241.33	98,241.33
29	6	7/1/18	844.64	484.48		0.00	360.16	97,881.17	97,881.17
30	7	8/1/18	844.64	498.79		0.00	345.85	97,535.32	97,535.32
31	8	9/1/18	844.64	497.03		0.00	347.61	97,187.71	97,187.71
32	9	10/1/18	844.64	479.28		0.00	365.36	96,822.35	96,822.35
33	10	11/1/18	844.64	493.40		0.00	351.24	96,471.11	96,471.11
34	11	12/1/18	844.64	475.75		0.00	368.89	96,102.22	96,102.22
35	12	1/1/19	844.64	489.73		0.00	354.91	95,747.31	95,747.31
36	13	2/1/19	844.64	487.92		0.00	356.72	95,390.59	95,390.59
37	14	3/1/19	844.64	439.06		0.00	405.58	94,985.01	94,985.01
38	15	4/1/19	844.64	484.03		0.00	360.61	94,624.40	94,624.40
39	16	5/1/19	844.64	466.64		0.00	378.00	94,246.40	94,246.40
40	17	6/1/19	844.64	480.27		0.00	364.37	93,882.03	93,882.03
41	18	7/1/19	844.64	462.98		0.00	381.66	93,500.37	93,500.37
42	19	8/1/19	844.64	476.47		0.00	368.17	93,132.20	93,132.20
43	20	9/1/19	844.64	474.59		0.00	370.05	92,762.15	92,762.15
44	21	10/1/19	844.64	457.46		0.00	387.18	92,374.97	92,374.97
45	22	11/1/19	844.64	470.73		0.00	373.91	92,001.06	92,001.06
46	23	12/1/19	844.64	453.70		0.00	390.94	91,610.12	91,610.12
47	24	1/1/20	844.64	466.84		0.00	377.80	91,232.32	91,232.32
48	25	2/1/20	844.64	464.91		0.00	379.73	90,852.59	90,852.59
49	26	3/1/20	844.64	433.11		0.00	411.53	90,441.06	90,441.06
50	27	4/1/20	844.64	460.88		0.00	383.76	90,057.30	90,057.30
51	28	5/1/20	844.64	444.12		0.00	400.52	89,656.78	89,656.78
52	29	6/1/20	844.64	456.88		0.00	387.76	89,269.02	89,269.02
53	30	7/1/20	844.64	440.23		0.00	404.41	88,864.61	88,864.61
54	31	8/1/20	844.64	452.84		0.00	391.80	88,472.81	88,472.81
55	32	9/1/20	844.64	450.85		0.00	393.79	88,079.02	88,079.02
56	33	10/1/20	844.64	434.36		0.00	410.28	87,668.74	87,668.74
57	34	11/1/20	844.64	446.75		0.00	397.89	87,270.85	87,270.85
58	35	12/1/20	844.64	430.38		0.00	414.26	86,856.59	86,856.59
59	36	1/1/21	844.64	442.61		0.00	402.03	86,454.56	86,454.56
60	37	2/1/21	844.64	440.56		0.00	404.08	86,050.48	86,050.48
61	38	3/1/21	844.64	396.07		0.00	448.57	85,601.91	85,601.91
62	39	4/1/21	844.64	436.22		0.00	408.42	85,193.49	85,193.49
63	40	5/1/21	844.64	420.13		0.00	424.51	84,768.98	84,768.98
64	41	6/1/21	844.64	431.97		0.00	412.67	84,356.31	84,356.31
65	42	7/1/21	844.64	416.00		0.00	428.64	83,927.67	83,927.67
66	43	8/1/21	844.64	427.69		0.00	416.95	83,510.72	83,510.72
67	44	9/1/21	844.64	425.56		0.00	419.08	83,091.64	83,091.64
68	45	10/1/21	844.64	409.77		0.00	434.87	82,656.77	82,656.77
69	46	11/1/21	844.64	421.21		0.00	423.43	82,233.34	82,233.34
70	47	12/1/21	844.64	405.53		0.00	439.11	81,794.23	81,794.23
71	48	1/1/22	844.64	416.81		0.00	427.83	81,366.40	81,366.40
72	49	2/1/22	844.64	414.63		0.00	430.01	80,936.39	80,936.39
73	50	3/1/22	844.64	372.53		0.00	472.11	80,464.28	80,464.28
74	51	4/1/22	844.64	410.04		0.00	434.60	80,029.68	80,029.68
75	52	5/1/22	844.64	394.67		0.00	449.97	79,579.71	79,579.71
76	53	6/1/22	844.64	405.53		0.00	439.11	79,140.60	79,140.60
77	54	7/1/22	844.64	390.28		0.00	454.36	78,686.24	78,686.24
78	55	8/1/22	844.64	400.98		0.00	443.66	78,242.58	78,242.58
79	56	9/1/22	844.64	398.72		0.00	445.92	77,796.66	77,796.66
80	57	10/1/22	844.64	383.65		0.00	460.99	77,335.67	77,335.67
81	58	11/1/22	844.64	394.09		0.00	450.55	76,885.12	76,885.12
82	59	12/1/22	844.64	379.16		0.00	465.48	76,419.64	76,419.64
83	60	1/1/23	844.64	389.43		0.00	455.21	75,964.43	75,964.43
84	61	2/1/23	844.64	387.11		0.00	457.53	75,506.90	75,506.90
85	62	3/1/23	844.64	347.54		0.00	497.10	75,009.80	75,009.80
86	63	4/1/23	844.64	382.24		0.00	462.40	74,547.40	74,547.40
87	64	5/1/23	844.64	367.63		0.00	477.01	74,070.39	74,070.39
88	65	6/1/23	844.64	377.45		0.00	467.19	73,603.20	73,603.20
89	66	7/1/23	844.64	362.97		0.00	481.67	73,121.53	73,121.53
90	67	8/1/23	844.64	372.62		0.00	472.02	72,649.51	72,649.51
91	68	9/1/23	844.64	370.21		0.00	474.43	72,175.08	72,175.08
92	69	10/1/23	844.64	355.93		0.00	488.71	71,686.37	71,686.37
93	70	11/1/23	844.64	365.31		0.00	479.33	71,207.04	71,207.04
94	71	12/1/23	844.64	351.16		0.00	493.48	70,713.56	70,713.56
95	72	1/1/24	844.64	360.35		0.00	484.29	70,229.27	70,229.27
96	73	2/1/24	844.64	357.88		0.00	486.76	69,742.51	69,742.51
97	74	3/1/24	844.64	332.47		0.00	512.17	69,230.34	69,230.34
98	75	4/1/24	844.64	352.79		0.00	491.85	68,738.49	68,738.49
99	76	5/1/24	844.64	338.98		0.00	505.66	68,232.83	68,232.83
100	77	6/1/24	844.64	347.71		0.00	496.93	67,735.90	67,735.90