Commercial Loan Amortization Calculator

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

Check Today's Mortgage Rates

Compare Today's Mortgage Rates
Check HELOC Rates

Amortization Schedule