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