Amortization Schedule


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


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

Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2024 Amortization Schedule