Commercial Loan Amortization Calculator

Refinance Rates Home Equity Rates Mortgage Rates

Commercial Loan Amortization Calculator is used to calculate monthly payment for commercial loan payments with balloon payment. The commercial loan calculator is easy to use with a commercial loan amortization schedule excel that you can view in details.

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:			$374.13
Monthly Interest:			$416.67
Monthly Payment:			$790.79
Balloon payment:			$68,661.53
Commercial Loan Amortization Schedule
Aug, 2026	1	$416.67	$374.13	$790.79	$99,625.87
Sep, 2026	2	$415.11	$375.69	$790.79	$99,250.19
Oct, 2026	3	$413.54	$377.25	$790.79	$98,872.94
Nov, 2026	4	$411.97	$378.82	$790.79	$98,494.11
Dec, 2026	5	$410.39	$380.40	$790.79	$98,113.71
Jan, 2027	6	$408.81	$381.99	$790.79	$97,731.72
Feb, 2027	7	$407.22	$383.58	$790.79	$97,348.15
Mar, 2027	8	$405.62	$385.18	$790.79	$96,962.97
Apr, 2027	9	$404.01	$386.78	$790.79	$96,576.19
May, 2027	10	$402.40	$388.39	$790.79	$96,187.80
Jun, 2027	11	$400.78	$390.01	$790.79	$95,797.79
Jul, 2027	12	$399.16	$391.64	$790.79	$95,406.15
Aug, 2027	13	$397.53	$393.27	$790.79	$95,012.88
Sep, 2027	14	$395.89	$394.91	$790.79	$94,617.97
Oct, 2027	15	$394.24	$396.55	$790.79	$94,221.42
Nov, 2027	16	$392.59	$398.20	$790.79	$93,823.22
Dec, 2027	17	$390.93	$399.86	$790.79	$93,423.35
Jan, 2028	18	$389.26	$401.53	$790.79	$93,021.82
Feb, 2028	19	$387.59	$403.20	$790.79	$92,618.62
Mar, 2028	20	$385.91	$404.88	$790.79	$92,213.74
Apr, 2028	21	$384.22	$406.57	$790.79	$91,807.17
May, 2028	22	$382.53	$408.26	$790.79	$91,398.91
Jun, 2028	23	$380.83	$409.96	$790.79	$90,988.94
Jul, 2028	24	$379.12	$411.67	$790.79	$90,577.27
Aug, 2028	25	$377.41	$413.39	$790.79	$90,163.88
Sep, 2028	26	$375.68	$415.11	$790.79	$89,748.77
Oct, 2028	27	$373.95	$416.84	$790.79	$89,331.93
Nov, 2028	28	$372.22	$418.58	$790.79	$88,913.35
Dec, 2028	29	$370.47	$420.32	$790.79	$88,493.03
Jan, 2029	30	$368.72	$422.07	$790.79	$88,070.96
Feb, 2029	31	$366.96	$423.83	$790.79	$87,647.13
Mar, 2029	32	$365.20	$425.60	$790.79	$87,221.53
Apr, 2029	33	$363.42	$427.37	$790.79	$86,794.16
May, 2029	34	$361.64	$429.15	$790.79	$86,365.01
Jun, 2029	35	$359.85	$430.94	$790.79	$85,934.07
Jul, 2029	36	$358.06	$432.74	$790.79	$85,501.33
Aug, 2029	37	$356.26	$434.54	$790.79	$85,066.79
Sep, 2029	38	$354.44	$436.35	$790.79	$84,630.45
Oct, 2029	39	$352.63	$438.17	$790.79	$84,192.28
Nov, 2029	40	$350.80	$439.99	$790.79	$83,752.29
Dec, 2029	41	$348.97	$441.83	$790.79	$83,310.46
Jan, 2030	42	$347.13	$443.67	$790.79	$82,866.79
Feb, 2030	43	$345.28	$445.52	$790.79	$82,421.28
Mar, 2030	44	$343.42	$447.37	$790.79	$81,973.91
Apr, 2030	45	$341.56	$449.24	$790.79	$81,524.67
May, 2030	46	$339.69	$451.11	$790.79	$81,073.56
Jun, 2030	47	$337.81	$452.99	$790.79	$80,620.58
Jul, 2030	48	$335.92	$454.87	$790.79	$80,165.70
Aug, 2030	49	$334.02	$456.77	$790.79	$79,708.93
Sep, 2030	50	$332.12	$458.67	$790.79	$79,250.26
Oct, 2030	51	$330.21	$460.58	$790.79	$78,789.68
Nov, 2030	52	$328.29	$462.50	$790.79	$78,327.17
Dec, 2030	53	$326.36	$464.43	$790.79	$77,862.74
Jan, 2031	54	$324.43	$466.37	$790.79	$77,396.38
Feb, 2031	55	$322.48	$468.31	$790.79	$76,928.07
Mar, 2031	56	$320.53	$470.26	$790.79	$76,457.81
Apr, 2031	57	$318.57	$472.22	$790.79	$75,985.59
May, 2031	58	$316.61	$474.19	$790.79	$75,511.40
Jun, 2031	59	$314.63	$476.16	$790.79	$75,035.24
Jul, 2031	60	$312.65	$478.15	$790.79	$74,557.09
Aug, 2031	61	$310.65	$480.14	$790.79	$74,076.95
Sep, 2031	62	$308.65	$482.14	$790.79	$73,594.81
Oct, 2031	63	$306.65	$484.15	$790.79	$73,110.66
Nov, 2031	64	$304.63	$486.17	$790.79	$72,624.50
Dec, 2031	65	$302.60	$488.19	$790.79	$72,136.31
Jan, 2032	66	$300.57	$490.23	$790.79	$71,646.08
Feb, 2032	67	$298.53	$492.27	$790.79	$71,153.81
Mar, 2032	68	$296.47	$494.32	$790.79	$70,659.49
Apr, 2032	69	$294.41	$496.38	$790.79	$70,163.11
May, 2032	70	$292.35	$498.45	$790.79	$69,664.67
Jun, 2032	71	$290.27	$500.52	$790.79	$69,164.14
Jul, 2032	72	$288.18	$502.61	$790.79	$68,661.53
Aug, 2032	73	$286.09	$504.70	$790.79	$68,156.83
Sep, 2032	74	$283.99	$506.81	$790.79	$67,650.02
Oct, 2032	75	$281.88	$508.92	$790.79	$67,141.10
Nov, 2032	76	$279.75	$511.04	$790.79	$66,630.06
Dec, 2032	77	$277.63	$513.17	$790.79	$66,116.90
Jan, 2033	78	$275.49	$515.31	$790.79	$65,601.59
Feb, 2033	79	$273.34	$517.45	$790.79	$65,084.14
Mar, 2033	80	$271.18	$519.61	$790.79	$64,564.53
Apr, 2033	81	$269.02	$521.77	$790.79	$64,042.75
May, 2033	82	$266.84	$523.95	$790.79	$63,518.80
Jun, 2033	83	$264.66	$526.13	$790.79	$62,992.67
Jul, 2033	84	$262.47	$528.32	$790.79	$62,464.35
Aug, 2033	85	$260.27	$530.53	$790.79	$61,933.82
Sep, 2033	86	$258.06	$532.74	$790.79	$61,401.08
Oct, 2033	87	$255.84	$534.96	$790.79	$60,866.13
Nov, 2033	88	$253.61	$537.18	$790.79	$60,328.94
Dec, 2033	89	$251.37	$539.42	$790.79	$59,789.52
Jan, 2034	90	$249.12	$541.67	$790.79	$59,247.85
Feb, 2034	91	$246.87	$543.93	$790.79	$58,703.92
Mar, 2034	92	$244.60	$546.19	$790.79	$58,157.73
Apr, 2034	93	$242.32	$548.47	$790.79	$57,609.26
May, 2034	94	$240.04	$550.76	$790.79	$57,058.50
Jun, 2034	95	$237.74	$553.05	$790.79	$56,505.45
Jul, 2034	96	$235.44	$555.35	$790.79	$55,950.10
Aug, 2034	97	$233.13	$557.67	$790.79	$55,392.43
Sep, 2034	98	$230.80	$559.99	$790.79	$54,832.44
Oct, 2034	99	$228.47	$562.33	$790.79	$54,270.11
Nov, 2034	100	$226.13	$564.67	$790.79	$53,705.45
Dec, 2034	101	$223.77	$567.02	$790.79	$53,138.43
Jan, 2035	102	$221.41	$569.38	$790.79	$52,569.04
Feb, 2035	103	$219.04	$571.76	$790.79	$51,997.29
Mar, 2035	104	$216.66	$574.14	$790.79	$51,423.15
Apr, 2035	105	$214.26	$576.53	$790.79	$50,846.62
May, 2035	106	$211.86	$578.93	$790.79	$50,267.68
Jun, 2035	107	$209.45	$581.34	$790.79	$49,686.34
Jul, 2035	108	$207.03	$583.77	$790.79	$49,102.57
Aug, 2035	109	$204.59	$586.20	$790.79	$48,516.37
Sep, 2035	110	$202.15	$588.64	$790.79	$47,927.73
Oct, 2035	111	$199.70	$591.09	$790.79	$47,336.64
Nov, 2035	112	$197.24	$593.56	$790.79	$46,743.08
Dec, 2035	113	$194.76	$596.03	$790.79	$46,147.05
Jan, 2036	114	$192.28	$598.51	$790.79	$45,548.53
Feb, 2036	115	$189.79	$601.01	$790.79	$44,947.53
Mar, 2036	116	$187.28	$603.51	$790.79	$44,344.01
Apr, 2036	117	$184.77	$606.03	$790.79	$43,737.99
May, 2036	118	$182.24	$608.55	$790.79	$43,129.43
Jun, 2036	119	$179.71	$611.09	$790.79	$42,518.35
Jul, 2036	120	$177.16	$613.63	$790.79	$41,904.71
Aug, 2036	121	$174.60	$616.19	$790.79	$41,288.52
Sep, 2036	122	$172.04	$618.76	$790.79	$40,669.76
Oct, 2036	123	$169.46	$621.34	$790.79	$40,048.43
Nov, 2036	124	$166.87	$623.93	$790.79	$39,424.50
Dec, 2036	125	$164.27	$626.52	$790.79	$38,797.98
Jan, 2037	126	$161.66	$629.14	$790.79	$38,168.84
Feb, 2037	127	$159.04	$631.76	$790.79	$37,537.09
Mar, 2037	128	$156.40	$634.39	$790.79	$36,902.70
Apr, 2037	129	$153.76	$637.03	$790.79	$36,265.66
May, 2037	130	$151.11	$639.69	$790.79	$35,625.98
Jun, 2037	131	$148.44	$642.35	$790.79	$34,983.63
Jul, 2037	132	$145.77	$645.03	$790.79	$34,338.60
Aug, 2037	133	$143.08	$647.72	$790.79	$33,690.88
Sep, 2037	134	$140.38	$650.41	$790.79	$33,040.47
Oct, 2037	135	$137.67	$653.13	$790.79	$32,387.34
Nov, 2037	136	$134.95	$655.85	$790.79	$31,731.49
Dec, 2037	137	$132.21	$658.58	$790.79	$31,072.92
Jan, 2038	138	$129.47	$661.32	$790.79	$30,411.59
Feb, 2038	139	$126.71	$664.08	$790.79	$29,747.51
Mar, 2038	140	$123.95	$666.85	$790.79	$29,080.67
Apr, 2038	141	$121.17	$669.62	$790.79	$28,411.04
May, 2038	142	$118.38	$672.41	$790.79	$27,738.63
Jun, 2038	143	$115.58	$675.22	$790.79	$27,063.41
Jul, 2038	144	$112.76	$678.03	$790.79	$26,385.38
Aug, 2038	145	$109.94	$680.85	$790.79	$25,704.53
Sep, 2038	146	$107.10	$683.69	$790.79	$25,020.84
Oct, 2038	147	$104.25	$686.54	$790.79	$24,334.30
Nov, 2038	148	$101.39	$689.40	$790.79	$23,644.90
Dec, 2038	149	$98.52	$692.27	$790.79	$22,952.62
Jan, 2039	150	$95.64	$695.16	$790.79	$22,257.47
Feb, 2039	151	$92.74	$698.05	$790.79	$21,559.41
Mar, 2039	152	$89.83	$700.96	$790.79	$20,858.45
Apr, 2039	153	$86.91	$703.88	$790.79	$20,154.57
May, 2039	154	$83.98	$706.82	$790.79	$19,447.75
Jun, 2039	155	$81.03	$709.76	$790.79	$18,737.99
Jul, 2039	156	$78.07	$712.72	$790.79	$18,025.27
Aug, 2039	157	$75.11	$715.69	$790.79	$17,309.58
Sep, 2039	158	$72.12	$718.67	$790.79	$16,590.91
Oct, 2039	159	$69.13	$721.66	$790.79	$15,869.25
Nov, 2039	160	$66.12	$724.67	$790.79	$15,144.57
Dec, 2039	161	$63.10	$727.69	$790.79	$14,416.88
Jan, 2040	162	$60.07	$730.72	$790.79	$13,686.16
Feb, 2040	163	$57.03	$733.77	$790.79	$12,952.39
Mar, 2040	164	$53.97	$736.83	$790.79	$12,215.57
Apr, 2040	165	$50.90	$739.90	$790.79	$11,475.67
May, 2040	166	$47.82	$742.98	$790.79	$10,732.69
Jun, 2040	167	$44.72	$746.07	$790.79	$9,986.62
Jul, 2040	168	$41.61	$749.18	$790.79	$9,237.44
Aug, 2040	169	$38.49	$752.30	$790.79	$8,485.13
Sep, 2040	170	$35.35	$755.44	$790.79	$7,729.69
Oct, 2040	171	$32.21	$758.59	$790.79	$6,971.11
Nov, 2040	172	$29.05	$761.75	$790.79	$6,209.36
Dec, 2040	173	$25.87	$764.92	$790.79	$5,444.44
Jan, 2041	174	$22.69	$768.11	$790.79	$4,676.33
Feb, 2041	175	$19.48	$771.31	$790.79	$3,905.02
Mar, 2041	176	$16.27	$774.52	$790.79	$3,130.50
Apr, 2041	177	$13.04	$777.75	$790.79	$2,352.75
May, 2041	178	$9.80	$780.99	$790.79	$1,571.76
Jun, 2041	179	$6.55	$784.24	$790.79	$787.51
Jul, 2041	180	$3.28	$787.51	$790.79	$0.00

Business Loan Amortization Schedule

Investors or business owners can use the commercial loan calculator to generate a business loan amortization schedule for business loans.

What is a commercial loan?

A commercial loan is a loan agreement between a business and a bank. Most commercial loans are short-term loans, which can be anywhere from 3 - 7 years. There are many different types of commercial loans, such as commercial real estate loans, business lines of credit, term loans, commercial construction loans, and many others. A commercial real estate loan is used to finance the purchase of a commercial property. A business line of credit is like a credit card for business. Instead of a lump sum payment, the company can draw funds from the line of credit whenever needed. Term loans are another type of commercial loan where the business pays monthly payments just like any other loan. The business can use the loan for buying equipment or paying their staff. Commercial construction loans are used to finance the construction of a building, an apartment, or a multi-family real estate investment.

How does a commercial loan work?

There are many types of commercial loans, and various financing options are available depending on the borrower's needs. Some commercial loans are fixed-interest rate loans while others use balloon payments. Lenders also have their own rules and policies on commercial loans. Some lenders require a down payment, others may require collateral, and some may require both or neither.

How do balloon payments work in a commercial loan?

Many commercial loans use balloon payments which give borrowers the option to make interest-only payments during an initial period and then the borrower is required to pay off the remaining balance after the interest-only period is over. Balloon loans are short-term loans, but the monthly payment is amortized over a longer term, usually 30 years. For example, with a 5-year balloon loan, borrowers will make low interest-only monthly payments for the first 5 years, and then they are required to pay off the principal at the end of 5 years. The balloon payment is huge compared to the regular monthly payments. It could be tens of thousands larger than the interest-only payments.

Pros and cons of balloon payments in a real estate commercial loan?

There are pros and cons of balloon payments in a real estate commercial loan. The positive side of a balloon payment is that the monthly payments are much lower, and the overall costs of financing are lower. If the borrower is planning to move in the near future, then balloon mortgages make sense. The downside of a balloon payment is that it doesn't build equity as the borrower is making interest-only or minimum payments. If the price of the real estate falls, the borrower might even have negative equity meaning he will owe more to the bank than the property is worth. Then there is the large balloon payment when it is due. Many borrowers are just surprised by how large the balloon payment is and are not prepared for it. These borrowers who couldn't afford to pay the balloon payment are forced to refinance or sell the property.

Risks of commercial balloon mortgage?

The major risk in a commercial balloon mortgage is when the balloon payment comes due and the borrower can't afford to pay it off, the bank has the right to take the property away from the seller. The other risk is if the real estate market falls, the borrowers will owe more money to the bank than the value of the house. Even if they sell their house to pay off their balloon payment, they still have to take more money out of their own pockets to cover the difference between the size of their mortgage and the sold price.

How to pay off a commercial balloon mortgage?

There are many ways a borrower can pay off a commercial balloon mortgage before the balloon payment is due.

Cash - if the borrower can afford to pay off his commercial balloon mortgage, then that's the most convenient way to pay it off.
Refinance - if the borrower is not afforded to pay the balloon payment, he should refinance the loan before the balloon payment is due. By refinancing the loan to a fix interest mortgage, he will lower the monthly payments. The downside of refinancing is that the new loan will take longer to pay off, and there will be additional costs such as closing costs and monthly interest payments.
Extra Payment - borrowers can choose to make extra payments instead of just making minimum payments. By increasing the monthly payment amounts toward principal, borrowers are essentially reducing the size of the balloon payment when it comes due.
Sell the Property - if there is no way for the borrower to pay the balloon payment, the only option he has is to sell the house and raise cash. Selling the property prevents it from getting foreclosed.

Borrowers should plan ahead before they get a commercial balloon mortgage and factor in the various risks before they sign the final contract. Real estate beginner investors may want to stay away from a commercial balloon mortgage and stick with traditional financing. As they learn more experience on how the real estate market works, they may then use commercial balloon mortgages to their advantage.

Business Loan Calculator
DSCR Calculator

Amortization Schedule