Commercial Loan Amortization Calculator

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

Compare Today's Mortgage Rates
Today's Home Equity Rates

Check Today's Mortgage Rates

Compare Today's Mortgage Rates
Check HELOC Rates

Amortization Schedule