Commercial Mortgage Calculator

Commercial Mortgage Calculator excel with balloon payment and amortization to calculate monthly mortgage payments for commercial real estate properties. The commercial loan calculator comes with an amortization schedule that is printable and exportable to excel. The commercial property mortgage calculator gives you all the necessary information such as the total payment, interest, and principal paid as well as the monthly payment breakdown.

Commercial Loan Calculator
Mortgage Amount	Loan Terms	years
Interest Rate	Balloon Payment Due	years
First Payment Date	Amortization Schedule	Show By Month Year

Payment Date	Payment #	Interest Paid	Principal Paid	Total Payment	Remaining Balance
Commercial Mortgage Calculator Results
Monthly Principal:			$360.46
Monthly Interest:			$1,250.00
Monthly Payment:			$1,610.46
Balloon payment:			$275,486.20
Commercial Mortgage Amortization Schedule
Sep, 2023	1	$1,250.00	$360.46	$1,610.46	$299,639.54
Oct, 2023	2	$1,248.50	$361.97	$1,610.46	$299,277.57
Nov, 2023	3	$1,246.99	$363.48	$1,610.46	$298,914.09
Dec, 2023	4	$1,245.48	$364.99	$1,610.46	$298,549.10
Jan, 2024	5	$1,243.95	$366.51	$1,610.46	$298,182.59
Feb, 2024	6	$1,242.43	$368.04	$1,610.46	$297,814.56
Mar, 2024	7	$1,240.89	$369.57	$1,610.46	$297,444.99
Apr, 2024	8	$1,239.35	$371.11	$1,610.46	$297,073.87
May, 2024	9	$1,237.81	$372.66	$1,610.46	$296,701.22
Jun, 2024	10	$1,236.26	$374.21	$1,610.46	$296,327.01
Jul, 2024	11	$1,234.70	$375.77	$1,610.46	$295,951.24
Aug, 2024	12	$1,233.13	$377.33	$1,610.46	$295,573.90
Sep, 2024	13	$1,231.56	$378.91	$1,610.46	$295,195.00
Oct, 2024	14	$1,229.98	$380.49	$1,610.46	$294,814.51
Nov, 2024	15	$1,228.39	$382.07	$1,610.46	$294,432.44
Dec, 2024	16	$1,226.80	$383.66	$1,610.46	$294,048.78
Jan, 2025	17	$1,225.20	$385.26	$1,610.46	$293,663.52
Feb, 2025	18	$1,223.60	$386.87	$1,610.46	$293,276.65
Mar, 2025	19	$1,221.99	$388.48	$1,610.46	$292,888.17
Apr, 2025	20	$1,220.37	$390.10	$1,610.46	$292,498.07
May, 2025	21	$1,218.74	$391.72	$1,610.46	$292,106.35
Jun, 2025	22	$1,217.11	$393.36	$1,610.46	$291,712.99
Jul, 2025	23	$1,215.47	$394.99	$1,610.46	$291,318.00
Aug, 2025	24	$1,213.83	$396.64	$1,610.46	$290,921.36
Sep, 2025	25	$1,212.17	$398.29	$1,610.46	$290,523.07
Oct, 2025	26	$1,210.51	$399.95	$1,610.46	$290,123.12
Nov, 2025	27	$1,208.85	$401.62	$1,610.46	$289,721.50
Dec, 2025	28	$1,207.17	$403.29	$1,610.46	$289,318.21
Jan, 2026	29	$1,205.49	$404.97	$1,610.46	$288,913.23
Feb, 2026	30	$1,203.81	$406.66	$1,610.46	$288,506.57
Mar, 2026	31	$1,202.11	$408.35	$1,610.46	$288,098.22
Apr, 2026	32	$1,200.41	$410.06	$1,610.46	$287,688.16
May, 2026	33	$1,198.70	$411.76	$1,610.46	$287,276.40
Jun, 2026	34	$1,196.98	$413.48	$1,610.46	$286,862.92
Jul, 2026	35	$1,195.26	$415.20	$1,610.46	$286,447.72
Aug, 2026	36	$1,193.53	$416.93	$1,610.46	$286,030.78
Sep, 2026	37	$1,191.79	$418.67	$1,610.46	$285,612.11
Oct, 2026	38	$1,190.05	$420.41	$1,610.46	$285,191.70
Nov, 2026	39	$1,188.30	$422.17	$1,610.46	$284,769.53
Dec, 2026	40	$1,186.54	$423.93	$1,610.46	$284,345.61
Jan, 2027	41	$1,184.77	$425.69	$1,610.46	$283,919.92
Feb, 2027	42	$1,183.00	$427.47	$1,610.46	$283,492.45
Mar, 2027	43	$1,181.22	$429.25	$1,610.46	$283,063.21
Apr, 2027	44	$1,179.43	$431.03	$1,610.46	$282,632.17
May, 2027	45	$1,177.63	$432.83	$1,610.46	$282,199.34
Jun, 2027	46	$1,175.83	$434.63	$1,610.46	$281,764.71
Jul, 2027	47	$1,174.02	$436.45	$1,610.46	$281,328.26
Aug, 2027	48	$1,172.20	$438.26	$1,610.46	$280,890.00
Sep, 2027	49	$1,170.37	$440.09	$1,610.46	$280,449.91
Oct, 2027	50	$1,168.54	$441.92	$1,610.46	$280,007.98
Nov, 2027	51	$1,166.70	$443.76	$1,610.46	$279,564.22
Dec, 2027	52	$1,164.85	$445.61	$1,610.46	$279,118.60
Jan, 2028	53	$1,162.99	$447.47	$1,610.46	$278,671.13
Feb, 2028	54	$1,161.13	$449.34	$1,610.46	$278,221.80
Mar, 2028	55	$1,159.26	$451.21	$1,610.46	$277,770.59
Apr, 2028	56	$1,157.38	$453.09	$1,610.46	$277,317.50
May, 2028	57	$1,155.49	$454.98	$1,610.46	$276,862.53
Jun, 2028	58	$1,153.59	$456.87	$1,610.46	$276,405.66
Jul, 2028	59	$1,151.69	$458.77	$1,610.46	$275,946.88
Aug, 2028	60	$1,149.78	$460.69	$1,610.46	$275,486.20
Sep, 2028	61	$1,147.86	$462.61	$1,610.46	$275,023.59
Oct, 2028	62	$1,145.93	$464.53	$1,610.46	$274,559.06
Nov, 2028	63	$1,144.00	$466.47	$1,610.46	$274,092.59
Dec, 2028	64	$1,142.05	$468.41	$1,610.46	$273,624.18
Jan, 2029	65	$1,140.10	$470.36	$1,610.46	$273,153.81
Feb, 2029	66	$1,138.14	$472.32	$1,610.46	$272,681.49
Mar, 2029	67	$1,136.17	$474.29	$1,610.46	$272,207.20
Apr, 2029	68	$1,134.20	$476.27	$1,610.46	$271,730.93
May, 2029	69	$1,132.21	$478.25	$1,610.46	$271,252.68
Jun, 2029	70	$1,130.22	$480.25	$1,610.46	$270,772.43
Jul, 2029	71	$1,128.22	$482.25	$1,610.46	$270,290.18
Aug, 2029	72	$1,126.21	$484.26	$1,610.46	$269,805.93
Sep, 2029	73	$1,124.19	$486.27	$1,610.46	$269,319.65
Oct, 2029	74	$1,122.17	$488.30	$1,610.46	$268,831.35
Nov, 2029	75	$1,120.13	$490.33	$1,610.46	$268,341.02
Dec, 2029	76	$1,118.09	$492.38	$1,610.46	$267,848.64
Jan, 2030	77	$1,116.04	$494.43	$1,610.46	$267,354.21
Feb, 2030	78	$1,113.98	$496.49	$1,610.46	$266,857.73
Mar, 2030	79	$1,111.91	$498.56	$1,610.46	$266,359.17
Apr, 2030	80	$1,109.83	$500.64	$1,610.46	$265,858.53
May, 2030	81	$1,107.74	$502.72	$1,610.46	$265,355.81
Jun, 2030	82	$1,105.65	$504.82	$1,610.46	$264,851.00
Jul, 2030	83	$1,103.55	$506.92	$1,610.46	$264,344.08
Aug, 2030	84	$1,101.43	$509.03	$1,610.46	$263,835.05
Sep, 2030	85	$1,099.31	$511.15	$1,610.46	$263,323.89
Oct, 2030	86	$1,097.18	$513.28	$1,610.46	$262,810.61
Nov, 2030	87	$1,095.04	$515.42	$1,610.46	$262,295.19
Dec, 2030	88	$1,092.90	$517.57	$1,610.46	$261,777.62
Jan, 2031	89	$1,090.74	$519.72	$1,610.46	$261,257.90
Feb, 2031	90	$1,088.57	$521.89	$1,610.46	$260,736.01
Mar, 2031	91	$1,086.40	$524.06	$1,610.46	$260,211.94
Apr, 2031	92	$1,084.22	$526.25	$1,610.46	$259,685.69
May, 2031	93	$1,082.02	$528.44	$1,610.46	$259,157.25
Jun, 2031	94	$1,079.82	$530.64	$1,610.46	$258,626.61
Jul, 2031	95	$1,077.61	$532.85	$1,610.46	$258,093.76
Aug, 2031	96	$1,075.39	$535.07	$1,610.46	$257,558.68
Sep, 2031	97	$1,073.16	$537.30	$1,610.46	$257,021.38
Oct, 2031	98	$1,070.92	$539.54	$1,610.46	$256,481.84
Nov, 2031	99	$1,068.67	$541.79	$1,610.46	$255,940.04
Dec, 2031	100	$1,066.42	$544.05	$1,610.46	$255,396.00
Jan, 2032	101	$1,064.15	$546.31	$1,610.46	$254,849.68
Feb, 2032	102	$1,061.87	$548.59	$1,610.46	$254,301.09
Mar, 2032	103	$1,059.59	$550.88	$1,610.46	$253,750.21
Apr, 2032	104	$1,057.29	$553.17	$1,610.46	$253,197.04
May, 2032	105	$1,054.99	$555.48	$1,610.46	$252,641.56
Jun, 2032	106	$1,052.67	$557.79	$1,610.46	$252,083.77
Jul, 2032	107	$1,050.35	$560.12	$1,610.46	$251,523.66
Aug, 2032	108	$1,048.02	$562.45	$1,610.46	$250,961.21
Sep, 2032	109	$1,045.67	$564.79	$1,610.46	$250,396.41
Oct, 2032	110	$1,043.32	$567.15	$1,610.46	$249,829.27
Nov, 2032	111	$1,040.96	$569.51	$1,610.46	$249,259.76
Dec, 2032	112	$1,038.58	$571.88	$1,610.46	$248,687.88
Jan, 2033	113	$1,036.20	$574.27	$1,610.46	$248,113.61
Feb, 2033	114	$1,033.81	$576.66	$1,610.46	$247,536.95
Mar, 2033	115	$1,031.40	$579.06	$1,610.46	$246,957.89
Apr, 2033	116	$1,028.99	$581.47	$1,610.46	$246,376.42
May, 2033	117	$1,026.57	$583.90	$1,610.46	$245,792.52
Jun, 2033	118	$1,024.14	$586.33	$1,610.46	$245,206.19
Jul, 2033	119	$1,021.69	$588.77	$1,610.46	$244,617.42
Aug, 2033	120	$1,019.24	$591.23	$1,610.46	$244,026.19
Sep, 2033	121	$1,016.78	$593.69	$1,610.46	$243,432.50
Oct, 2033	122	$1,014.30	$596.16	$1,610.46	$242,836.34
Nov, 2033	123	$1,011.82	$598.65	$1,610.46	$242,237.69
Dec, 2033	124	$1,009.32	$601.14	$1,610.46	$241,636.55
Jan, 2034	125	$1,006.82	$603.65	$1,610.46	$241,032.91
Feb, 2034	126	$1,004.30	$606.16	$1,610.46	$240,426.75
Mar, 2034	127	$1,001.78	$608.69	$1,610.46	$239,818.06
Apr, 2034	128	$999.24	$611.22	$1,610.46	$239,206.84
May, 2034	129	$996.70	$613.77	$1,610.46	$238,593.07
Jun, 2034	130	$994.14	$616.33	$1,610.46	$237,976.74
Jul, 2034	131	$991.57	$618.90	$1,610.46	$237,357.85
Aug, 2034	132	$988.99	$621.47	$1,610.46	$236,736.37
Sep, 2034	133	$986.40	$624.06	$1,610.46	$236,112.31
Oct, 2034	134	$983.80	$626.66	$1,610.46	$235,485.64
Nov, 2034	135	$981.19	$629.27	$1,610.46	$234,856.37
Dec, 2034	136	$978.57	$631.90	$1,610.46	$234,224.47
Jan, 2035	137	$975.94	$634.53	$1,610.46	$233,589.94
Feb, 2035	138	$973.29	$637.17	$1,610.46	$232,952.77
Mar, 2035	139	$970.64	$639.83	$1,610.46	$232,312.94
Apr, 2035	140	$967.97	$642.49	$1,610.46	$231,670.45
May, 2035	141	$965.29	$645.17	$1,610.46	$231,025.28
Jun, 2035	142	$962.61	$647.86	$1,610.46	$230,377.42
Jul, 2035	143	$959.91	$650.56	$1,610.46	$229,726.86
Aug, 2035	144	$957.20	$653.27	$1,610.46	$229,073.59
Sep, 2035	145	$954.47	$655.99	$1,610.46	$228,417.60
Oct, 2035	146	$951.74	$658.72	$1,610.46	$227,758.87
Nov, 2035	147	$949.00	$661.47	$1,610.46	$227,097.40
Dec, 2035	148	$946.24	$664.23	$1,610.46	$226,433.18
Jan, 2036	149	$943.47	$666.99	$1,610.46	$225,766.18
Feb, 2036	150	$940.69	$669.77	$1,610.46	$225,096.41
Mar, 2036	151	$937.90	$672.56	$1,610.46	$224,423.85
Apr, 2036	152	$935.10	$675.37	$1,610.46	$223,748.48
May, 2036	153	$932.29	$678.18	$1,610.46	$223,070.30
Jun, 2036	154	$929.46	$681.01	$1,610.46	$222,389.30
Jul, 2036	155	$926.62	$683.84	$1,610.46	$221,705.45
Aug, 2036	156	$923.77	$686.69	$1,610.46	$221,018.76
Sep, 2036	157	$920.91	$689.55	$1,610.46	$220,329.21
Oct, 2036	158	$918.04	$692.43	$1,610.46	$219,636.78
Nov, 2036	159	$915.15	$695.31	$1,610.46	$218,941.47
Dec, 2036	160	$912.26	$698.21	$1,610.46	$218,243.26
Jan, 2037	161	$909.35	$701.12	$1,610.46	$217,542.14
Feb, 2037	162	$906.43	$704.04	$1,610.46	$216,838.10
Mar, 2037	163	$903.49	$706.97	$1,610.46	$216,131.13
Apr, 2037	164	$900.55	$709.92	$1,610.46	$215,421.21
May, 2037	165	$897.59	$712.88	$1,610.46	$214,708.34
Jun, 2037	166	$894.62	$715.85	$1,610.46	$213,992.49
Jul, 2037	167	$891.64	$718.83	$1,610.46	$213,273.66
Aug, 2037	168	$888.64	$721.82	$1,610.46	$212,551.84
Sep, 2037	169	$885.63	$724.83	$1,610.46	$211,827.00
Oct, 2037	170	$882.61	$727.85	$1,610.46	$211,099.15
Nov, 2037	171	$879.58	$730.89	$1,610.46	$210,368.27
Dec, 2037	172	$876.53	$733.93	$1,610.46	$209,634.34
Jan, 2038	173	$873.48	$736.99	$1,610.46	$208,897.35
Feb, 2038	174	$870.41	$740.06	$1,610.46	$208,157.29
Mar, 2038	175	$867.32	$743.14	$1,610.46	$207,414.15
Apr, 2038	176	$864.23	$746.24	$1,610.46	$206,667.91
May, 2038	177	$861.12	$749.35	$1,610.46	$205,918.56
Jun, 2038	178	$857.99	$752.47	$1,610.46	$205,166.09
Jul, 2038	179	$854.86	$755.61	$1,610.46	$204,410.48
Aug, 2038	180	$851.71	$758.75	$1,610.46	$203,651.73
Sep, 2038	181	$848.55	$761.92	$1,610.46	$202,889.81
Oct, 2038	182	$845.37	$765.09	$1,610.46	$202,124.72
Nov, 2038	183	$842.19	$768.28	$1,610.46	$201,356.44
Dec, 2038	184	$838.99	$771.48	$1,610.46	$200,584.96
Jan, 2039	185	$835.77	$774.69	$1,610.46	$199,810.27
Feb, 2039	186	$832.54	$777.92	$1,610.46	$199,032.34
Mar, 2039	187	$829.30	$781.16	$1,610.46	$198,251.18
Apr, 2039	188	$826.05	$784.42	$1,610.46	$197,466.76
May, 2039	189	$822.78	$787.69	$1,610.46	$196,679.08
Jun, 2039	190	$819.50	$790.97	$1,610.46	$195,888.11
Jul, 2039	191	$816.20	$794.26	$1,610.46	$195,093.84
Aug, 2039	192	$812.89	$797.57	$1,610.46	$194,296.27
Sep, 2039	193	$809.57	$800.90	$1,610.46	$193,495.37
Oct, 2039	194	$806.23	$804.23	$1,610.46	$192,691.14
Nov, 2039	195	$802.88	$807.59	$1,610.46	$191,883.55
Dec, 2039	196	$799.51	$810.95	$1,610.46	$191,072.60
Jan, 2040	197	$796.14	$814.33	$1,610.46	$190,258.27
Feb, 2040	198	$792.74	$817.72	$1,610.46	$189,440.55
Mar, 2040	199	$789.34	$821.13	$1,610.46	$188,619.42
Apr, 2040	200	$785.91	$824.55	$1,610.46	$187,794.87
May, 2040	201	$782.48	$827.99	$1,610.46	$186,966.89
Jun, 2040	202	$779.03	$831.44	$1,610.46	$186,135.45
Jul, 2040	203	$775.56	$834.90	$1,610.46	$185,300.55
Aug, 2040	204	$772.09	$838.38	$1,610.46	$184,462.17
Sep, 2040	205	$768.59	$841.87	$1,610.46	$183,620.30
Oct, 2040	206	$765.08	$845.38	$1,610.46	$182,774.92
Nov, 2040	207	$761.56	$848.90	$1,610.46	$181,926.01
Dec, 2040	208	$758.03	$852.44	$1,610.46	$181,073.57
Jan, 2041	209	$754.47	$855.99	$1,610.46	$180,217.58
Feb, 2041	210	$750.91	$859.56	$1,610.46	$179,358.02
Mar, 2041	211	$747.33	$863.14	$1,610.46	$178,494.88
Apr, 2041	212	$743.73	$866.74	$1,610.46	$177,628.15
May, 2041	213	$740.12	$870.35	$1,610.46	$176,757.80
Jun, 2041	214	$736.49	$873.97	$1,610.46	$175,883.83
Jul, 2041	215	$732.85	$877.62	$1,610.46	$175,006.21
Aug, 2041	216	$729.19	$881.27	$1,610.46	$174,124.94
Sep, 2041	217	$725.52	$884.94	$1,610.46	$173,239.99
Oct, 2041	218	$721.83	$888.63	$1,610.46	$172,351.36
Nov, 2041	219	$718.13	$892.33	$1,610.46	$171,459.03
Dec, 2041	220	$714.41	$896.05	$1,610.46	$170,562.98
Jan, 2042	221	$710.68	$899.79	$1,610.46	$169,663.19
Feb, 2042	222	$706.93	$903.53	$1,610.46	$168,759.66
Mar, 2042	223	$703.17	$907.30	$1,610.46	$167,852.36
Apr, 2042	224	$699.38	$911.08	$1,610.46	$166,941.28
May, 2042	225	$695.59	$914.88	$1,610.46	$166,026.40
Jun, 2042	226	$691.78	$918.69	$1,610.46	$165,107.71
Jul, 2042	227	$687.95	$922.52	$1,610.46	$164,185.20
Aug, 2042	228	$684.10	$926.36	$1,610.46	$163,258.84
Sep, 2042	229	$680.25	$930.22	$1,610.46	$162,328.62
Oct, 2042	230	$676.37	$934.10	$1,610.46	$161,394.52
Nov, 2042	231	$672.48	$937.99	$1,610.46	$160,456.53
Dec, 2042	232	$668.57	$941.90	$1,610.46	$159,514.64
Jan, 2043	233	$664.64	$945.82	$1,610.46	$158,568.82
Feb, 2043	234	$660.70	$949.76	$1,610.46	$157,619.05
Mar, 2043	235	$656.75	$953.72	$1,610.46	$156,665.34
Apr, 2043	236	$652.77	$957.69	$1,610.46	$155,707.64
May, 2043	237	$648.78	$961.68	$1,610.46	$154,745.96
Jun, 2043	238	$644.77	$965.69	$1,610.46	$153,780.27
Jul, 2043	239	$640.75	$969.71	$1,610.46	$152,810.56
Aug, 2043	240	$636.71	$973.75	$1,610.46	$151,836.80
Sep, 2043	241	$632.65	$977.81	$1,610.46	$150,858.99
Oct, 2043	242	$628.58	$981.89	$1,610.46	$149,877.11
Nov, 2043	243	$624.49	$985.98	$1,610.46	$148,891.13
Dec, 2043	244	$620.38	$990.09	$1,610.46	$147,901.04
Jan, 2044	245	$616.25	$994.21	$1,610.46	$146,906.83
Feb, 2044	246	$612.11	$998.35	$1,610.46	$145,908.48
Mar, 2044	247	$607.95	$1,002.51	$1,610.46	$144,905.97
Apr, 2044	248	$603.77	$1,006.69	$1,610.46	$143,899.28
May, 2044	249	$599.58	$1,010.88	$1,610.46	$142,888.39
Jun, 2044	250	$595.37	$1,015.10	$1,610.46	$141,873.30
Jul, 2044	251	$591.14	$1,019.33	$1,610.46	$140,853.97
Aug, 2044	252	$586.89	$1,023.57	$1,610.46	$139,830.40
Sep, 2044	253	$582.63	$1,027.84	$1,610.46	$138,802.56
Oct, 2044	254	$578.34	$1,032.12	$1,610.46	$137,770.44
Nov, 2044	255	$574.04	$1,036.42	$1,610.46	$136,734.02
Dec, 2044	256	$569.73	$1,040.74	$1,610.46	$135,693.28
Jan, 2045	257	$565.39	$1,045.08	$1,610.46	$134,648.20
Feb, 2045	258	$561.03	$1,049.43	$1,610.46	$133,598.77
Mar, 2045	259	$556.66	$1,053.80	$1,610.46	$132,544.97
Apr, 2045	260	$552.27	$1,058.19	$1,610.46	$131,486.77
May, 2045	261	$547.86	$1,062.60	$1,610.46	$130,424.17
Jun, 2045	262	$543.43	$1,067.03	$1,610.46	$129,357.14
Jul, 2045	263	$538.99	$1,071.48	$1,610.46	$128,285.66
Aug, 2045	264	$534.52	$1,075.94	$1,610.46	$127,209.72
Sep, 2045	265	$530.04	$1,080.42	$1,610.46	$126,129.29
Oct, 2045	266	$525.54	$1,084.93	$1,610.46	$125,044.37
Nov, 2045	267	$521.02	$1,089.45	$1,610.46	$123,954.92
Dec, 2045	268	$516.48	$1,093.99	$1,610.46	$122,860.94
Jan, 2046	269	$511.92	$1,098.54	$1,610.46	$121,762.39
Feb, 2046	270	$507.34	$1,103.12	$1,610.46	$120,659.27
Mar, 2046	271	$502.75	$1,107.72	$1,610.46	$119,551.55
Apr, 2046	272	$498.13	$1,112.33	$1,610.46	$118,439.22
May, 2046	273	$493.50	$1,116.97	$1,610.46	$117,322.25
Jun, 2046	274	$488.84	$1,121.62	$1,610.46	$116,200.63
Jul, 2046	275	$484.17	$1,126.30	$1,610.46	$115,074.33
Aug, 2046	276	$479.48	$1,130.99	$1,610.46	$113,943.34
Sep, 2046	277	$474.76	$1,135.70	$1,610.46	$112,807.64
Oct, 2046	278	$470.03	$1,140.43	$1,610.46	$111,667.21
Nov, 2046	279	$465.28	$1,145.18	$1,610.46	$110,522.03
Dec, 2046	280	$460.51	$1,149.96	$1,610.46	$109,372.07
Jan, 2047	281	$455.72	$1,154.75	$1,610.46	$108,217.32
Feb, 2047	282	$450.91	$1,159.56	$1,610.46	$107,057.76
Mar, 2047	283	$446.07	$1,164.39	$1,610.46	$105,893.37
Apr, 2047	284	$441.22	$1,169.24	$1,610.46	$104,724.13
May, 2047	285	$436.35	$1,174.11	$1,610.46	$103,550.01
Jun, 2047	286	$431.46	$1,179.01	$1,610.46	$102,371.01
Jul, 2047	287	$426.55	$1,183.92	$1,610.46	$101,187.09
Aug, 2047	288	$421.61	$1,188.85	$1,610.46	$99,998.24
Sep, 2047	289	$416.66	$1,193.81	$1,610.46	$98,804.43
Oct, 2047	290	$411.69	$1,198.78	$1,610.46	$97,605.65
Nov, 2047	291	$406.69	$1,203.77	$1,610.46	$96,401.88
Dec, 2047	292	$401.67	$1,208.79	$1,610.46	$95,193.09
Jan, 2048	293	$396.64	$1,213.83	$1,610.46	$93,979.26
Feb, 2048	294	$391.58	$1,218.88	$1,610.46	$92,760.37
Mar, 2048	295	$386.50	$1,223.96	$1,610.46	$91,536.41
Apr, 2048	296	$381.40	$1,229.06	$1,610.46	$90,307.35
May, 2048	297	$376.28	$1,234.18	$1,610.46	$89,073.16
Jun, 2048	298	$371.14	$1,239.33	$1,610.46	$87,833.84
Jul, 2048	299	$365.97	$1,244.49	$1,610.46	$86,589.35
Aug, 2048	300	$360.79	$1,249.68	$1,610.46	$85,339.67
Sep, 2048	301	$355.58	$1,254.88	$1,610.46	$84,084.79
Oct, 2048	302	$350.35	$1,260.11	$1,610.46	$82,824.68
Nov, 2048	303	$345.10	$1,265.36	$1,610.46	$81,559.31
Dec, 2048	304	$339.83	$1,270.63	$1,610.46	$80,288.68
Jan, 2049	305	$334.54	$1,275.93	$1,610.46	$79,012.75
Feb, 2049	306	$329.22	$1,281.25	$1,610.46	$77,731.51
Mar, 2049	307	$323.88	$1,286.58	$1,610.46	$76,444.92
Apr, 2049	308	$318.52	$1,291.94	$1,610.46	$75,152.98
May, 2049	309	$313.14	$1,297.33	$1,610.46	$73,855.65
Jun, 2049	310	$307.73	$1,302.73	$1,610.46	$72,552.92
Jul, 2049	311	$302.30	$1,308.16	$1,610.46	$71,244.76
Aug, 2049	312	$296.85	$1,313.61	$1,610.46	$69,931.15
Sep, 2049	313	$291.38	$1,319.09	$1,610.46	$68,612.06
Oct, 2049	314	$285.88	$1,324.58	$1,610.46	$67,287.48
Nov, 2049	315	$280.36	$1,330.10	$1,610.46	$65,957.38
Dec, 2049	316	$274.82	$1,335.64	$1,610.46	$64,621.74
Jan, 2050	317	$269.26	$1,341.21	$1,610.46	$63,280.53
Feb, 2050	318	$263.67	$1,346.80	$1,610.46	$61,933.73
Mar, 2050	319	$258.06	$1,352.41	$1,610.46	$60,581.32
Apr, 2050	320	$252.42	$1,358.04	$1,610.46	$59,223.28
May, 2050	321	$246.76	$1,363.70	$1,610.46	$57,859.58
Jun, 2050	322	$241.08	$1,369.38	$1,610.46	$56,490.20
Jul, 2050	323	$235.38	$1,375.09	$1,610.46	$55,115.11
Aug, 2050	324	$229.65	$1,380.82	$1,610.46	$53,734.29
Sep, 2050	325	$223.89	$1,386.57	$1,610.46	$52,347.72
Oct, 2050	326	$218.12	$1,392.35	$1,610.46	$50,955.37
Nov, 2050	327	$212.31	$1,398.15	$1,610.46	$49,557.22
Dec, 2050	328	$206.49	$1,403.98	$1,610.46	$48,153.24
Jan, 2051	329	$200.64	$1,409.83	$1,610.46	$46,743.41
Feb, 2051	330	$194.76	$1,415.70	$1,610.46	$45,327.71
Mar, 2051	331	$188.87	$1,421.60	$1,610.46	$43,906.11
Apr, 2051	332	$182.94	$1,427.52	$1,610.46	$42,478.59
May, 2051	333	$176.99	$1,433.47	$1,610.46	$41,045.12
Jun, 2051	334	$171.02	$1,439.44	$1,610.46	$39,605.68
Jul, 2051	335	$165.02	$1,445.44	$1,610.46	$38,160.24
Aug, 2051	336	$159.00	$1,451.46	$1,610.46	$36,708.77
Sep, 2051	337	$152.95	$1,457.51	$1,610.46	$35,251.26
Oct, 2051	338	$146.88	$1,463.58	$1,610.46	$33,787.68
Nov, 2051	339	$140.78	$1,469.68	$1,610.46	$32,317.99
Dec, 2051	340	$134.66	$1,475.81	$1,610.46	$30,842.19
Jan, 2052	341	$128.51	$1,481.96	$1,610.46	$29,360.23
Feb, 2052	342	$122.33	$1,488.13	$1,610.46	$27,872.10
Mar, 2052	343	$116.13	$1,494.33	$1,610.46	$26,377.77
Apr, 2052	344	$109.91	$1,500.56	$1,610.46	$24,877.21
May, 2052	345	$103.66	$1,506.81	$1,610.46	$23,370.40
Jun, 2052	346	$97.38	$1,513.09	$1,610.46	$21,857.31
Jul, 2052	347	$91.07	$1,519.39	$1,610.46	$20,337.92
Aug, 2052	348	$84.74	$1,525.72	$1,610.46	$18,812.20
Sep, 2052	349	$78.38	$1,532.08	$1,610.46	$17,280.12
Oct, 2052	350	$72.00	$1,538.46	$1,610.46	$15,741.65
Nov, 2052	351	$65.59	$1,544.87	$1,610.46	$14,196.78
Dec, 2052	352	$59.15	$1,551.31	$1,610.46	$12,645.47
Jan, 2053	353	$52.69	$1,557.78	$1,610.46	$11,087.69
Feb, 2053	354	$46.20	$1,564.27	$1,610.46	$9,523.42
Mar, 2053	355	$39.68	$1,570.78	$1,610.46	$7,952.64
Apr, 2053	356	$33.14	$1,577.33	$1,610.46	$6,375.31
May, 2053	357	$26.56	$1,583.90	$1,610.46	$4,791.41
Jun, 2053	358	$19.96	$1,590.50	$1,610.46	$3,200.91
Jul, 2053	359	$13.34	$1,597.13	$1,610.46	$1,603.78
Aug, 2053	360	$6.68	$1,603.78	$1,610.46	$0.00

Commercial Real Estate Calculator

The Commercial real estate calculator is to be used for commercial loans only. It is a perfect calculator for real estate investors who are looking to buy commercial properties as an investment. If you are looking for a conventional mortgage calculator with taxes and insurance, please use the mortgage calculator with taxes and insurance with more options.

For commercial loans, lenders expect the borrowers to repay the loan in advance before the due date. They do this by including a balloon payment which is a lump sum of money to be paid at the end of the balloon payment due year. For example, if the balloon due year is 5 years, you will make regular monthly payments to the lender. At the end of the 5th year, you are required to pay off everything in a lump sum payment. This commercial mortgage loan calculator with balloon payment will calculate the mortgage balloon payment for you after certain years. The commercial mortgage calculator with amortization has a commercial amortization schedule that has all the details about each payment including payment date, payment number, interest paid, principal paid, total payment, and remaining balance. The commercial mortgage amortization schedule is printable and downloadable for your convenience.

If you live in the UK, you can use the Commercial Mortgage Calculator UK.

What is a commercial loan?

A commercial loan is a loan issued by a bank to a company. To get a commercial loan from a lender, businesses may need to use properties and equipment as collateral. During expansion and growth periods, companies may use commercial loans to fund capital expenditure, operational costs, hiring new employees, buy real estate as an investment or as an office. For example, a restaurant chain may use a commercial loan to buy a restaurant and the building that comes with it, a property investment company may use a commercial loan for construction and to acquire properties.

How do commercial loans work?

To apply and get approval for a commercial loan, companies need to provide financial statements, such as their income statement and balance sheet to the bank. This is necessary because this is the only way that the bank knows that the business can repay the loan. In the case of default, the bank wants to take control of a company's assets to cover their loss. Commercial loans are usually short-term, but they can be renewed and extended for a longer period. Many commercial lenders require collateral for commercial loans, whereas some lenders require a down payment. It really depends on the particular lender that you work with. Shop around and see which commercial lender suits your needs.

Types of commercial loans

There are many types of commercial loans that businesses get, here are a few of them.

Traditional Business Loans - This is a commercial loan that businesses borrow from a lender to grow their business, and they pay back the money over time with a fixed-rate interest.

Real Estate Commercial Loans - This is a real estate commercial loan used to buy commercial buildings or other real estate properties for investment purposes or as an office. The real estate commercial loans differ from the regular mortgage as these loans are generally much shorter than the standard 30-year term for residential mortgages, they usually last for 5 to 10 years.

Equipment Loans - If a business needs expensive equipment and can't afford it, they can get a commercial loan for equipment, and they can use the equipment as collateral.

Vehicle Auto Loans - If your business needs to purchase cars, vans, or trucks to get the business started, you can get a vehicle auto loan for business.

Construction Loans - A business loan that to fund the construction of a building, office, retail space, multi-family house, or an entire apartment building. The construction loan is a short-term business loan that ranges between 18 to 36 months, but they usually are extended to a longer-term mortgage.

Business Lines of Credit - This type of loan is more like a credit card than a traditional loan. A business line of credit allows a business to borrow up to a certain amount of money whenever they need, and will only charge interest on the amount that the business uses. As soon as the business repays the lender, the credit limit goes back to the original amount.

SBA loans - A business loan that is designed to help out small business owners. SBA loans are backed by the Small Business Administration or SBA. The SBA doesn't issue loans themselves, they work with banks and guarantee paybacks. SBA loans are similar to traditional business loans, but with longer terms and lower interest rates. SBA loans generally take longer to process and approve than a traditional loan.

Do I need a down payment for a commercial loan?

There is a difference between a commercial loan and a commercial real estate loan. A commercial real estate loan is just one type of commercial loan. As stated above, there are many types of commercial loans. Whether a commercial loan needs a down payment depends on the loan type. A commercial loan that to purchase commercial vehicles and trucks usually doesn't require a down payment, but a commercial real estate loan does require a significant down payment. If your business is using a commercial loan to purchase a commercial property, most lenders would require a down payment of at least 20-30%. There are mainly 5 types of commercial real estate loans, traditional commercial mortgage, SBA 7(a) loan, SBA 504 loan, hard money loan, and bridge loans. These types of loans are primarily used for real estate investing, and they usually have a higher interest rate than a conventional mortgage for residential properties.

How to get a commercial loan?

To apply for a personal loan or a mortgage for your home, the bank reviews your income history and credit score. When a business applies for a commercial loan, the bank also needs to review its income statement and credit scores.

Credit Score - As an individual, a business has a credit score too. The credit score of a business depends on many factors such as historical data, registration details, payment history and collections, and business operation data.

Company performance - To make sure that your company is able to repay the loan, lenders look at your company's performance. Be prepared to provide an income statement, balance sheet, tax statements to show the total revenue and profit of the business.

Proof of Collateral - Depending on the loan type, some commercial loans required collateral to protect the lender.

These are the three major items that lenders look at to decide whether the borrower qualifies for the loan. Some lenders will require additional documents from the business such as business plans, and how it plans to use the loan.

How to get a commercial real estate loan?

The most logical place to get a commercial real estate loan is a bank. However, keep in mind that there are other alternative lenders that a business can take advantage of. Also, there are pros and cons to applying for a commercial loan from a bank. Following is a list of lenders that you can get a commercial real estate loan to fund your next commercial investment property.

Bank - While the bank is the most convenient option and usually offers the best interest rate with the most flexible terms, the loan approval process is generally the longest, and they often require extensive documents and only issue loans to businesses with good credit scores.

Commercial Lender - These are non-bank lenders that provide commercial loans for real estate investment. While commercial lenders are not as strict as banks, and the loan approval process is often much faster, they do charge a higher interest rate. Their terms are often short-term, and not as flexible as a bank.

Crowdlending - This is a newer type of funding for commercial real estate properties. The standard is lower than a bank and a commercial lender, and the application process is usually faster. However, the downside is they have a higher interest rate and more fees, and the terms are mostly short-term.

Commercial Property Mortgage Calculator Terms

Following are the terms for the commercial real estate loan calculator.
Mortgage Amount - The amount of the loan that you want to apply for. Loan Terms - The terms in a number of years for the loan. Interest Rate - The annual interest rate that you need to pay for the loan. Balloon Payment Due - In how many years will the balloon payment be due. First Payment Date - You can set the date for the first payment date in the past, present, or some date in the future. Amortization schedule - Show the amortization schedule of each payment or on a yearly basis.

If you are working with a realtor whether you are looking to buy or sell a commercial property, you can use the commercial realtor commission calculator to calculate the cost of hiring a real estate agent.

SBA 504 Loan Calculator
SBA 7(a) Loan Calculator
SBA Loan Calculator
Business Loan Calculator
DSCR Calculator

Mortgage Calculator

Commercial Mortgage Calculator

Commercial Loan Calculator