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