Enter Loan Details
Example Data Table
| Scenario | Loan Amount | Rate | Term | Fee | Interest Only | Balloon | Purpose |
|---|---|---|---|---|---|---|---|
| Working capital | GBP 50,000 | 8.50% | 60 months | 1.50% | 0 months | 0% | Cash flow support |
| Equipment purchase | GBP 120,000 | 9.25% | 72 months | 2.00% | 6 months | 10% | Machinery funding |
| Expansion plan | GBP 250,000 | 7.90% | 84 months | 1.25% | 3 months | 15% | Branch opening |
Formula Used
Monthly rate: monthly rate = annual rate / 12 / 100.
Arrangement fee: arrangement fee = loan amount × arrangement fee percentage.
Total fees: total fees = arrangement fee + documentation fee.
Starting balance: starting balance = loan amount + financed fees. If fees are not financed, they are treated as upfront costs.
Amortizing payment: payment = (balance - balloon / (1 + monthly rate)months) × monthly rate / (1 - (1 + monthly rate)-months).
Interest-only payment: interest-only payment = current balance × monthly rate + admin fee + extra payment.
Cash flow cover ratio: cash flow cover ratio = available monthly business cash flow / estimated monthly obligation.
How to Use This Calculator
- Enter the loan amount your business wants to borrow.
- Add the expected annual interest rate.
- Enter the repayment term in months.
- Add arrangement, documentation, and monthly administration fees.
- Use interest-only months if the loan starts with reduced payments.
- Add a balloon percentage if part of the balance remains due later.
- Enter extra monthly payments to test faster balance reduction.
- Submit the form and review results above the form.
- Download the CSV or PDF summary for offline review.
HSBC Business Funding Planning Guide
Business borrowing should be measured before any application starts. This calculator helps owners review repayment pressure, fee load, interest cost, and cash flow cover. It does not replace an offer from a lender. It gives a structured estimate for planning.
Why Payment Detail Matters
A business loan can look affordable from its advertised rate. The real cost also includes arrangement fees, documentation charges, monthly administration costs, interest-only periods, and final balloon balances. These items affect cash flow each month. They also change the total borrowing cost over the full term. A clear estimate helps compare offers with similar conditions.
Using the Results
The monthly repayment shows the expected regular loan charge after any interest-only period. The tool also estimates early interest-only payments, final balloon exposure, total interest, total fees, and the cost including any remaining balance. These figures help managers test different terms. A longer term usually lowers the monthly repayment. It can also increase total interest. A shorter term can save interest, yet it raises monthly pressure.
Cash Flow View
The cash flow cover ratio compares available monthly operating cash with the estimated monthly obligation. Many businesses prefer a cushion above the payment. A ratio above one means the entered cash flow covers the repayment. A stronger ratio gives more room for stock, wages, tax, and seasonal slowdowns. The calculator includes an interpretation, but lenders may use different checks.
Practical Use Cases
Use this page before speaking with a banker, accountant, or finance broker. Test a base case first. Then change the rate, term, fees, and balloon amount. Compare how each adjustment changes the payment and total cost. Export the result to CSV for spreadsheets. Download the PDF summary for internal review.
Important Limitations
The estimate is only a planning model. It assumes monthly compounding and steady payments. It does not include tax treatment, missed payments, early settlement charges, rate changes, insurance, legal charges, or credit assessment conditions. Actual HSBC business loan terms can vary by country, product, security, risk profile, and approval decision. Always review official documents before signing any agreement.
Keep written assumptions with every export. This makes later comparisons clearer for board discussions. It also speeds careful follow-up questions from advisers.
FAQs
1. Is this an official HSBC calculator?
No. This is an independent planning calculator. It estimates repayment scenarios using common loan formulas. Always confirm real rates, fees, terms, and eligibility with official documents before making a funding decision.
2. Does the calculator include arrangement fees?
Yes. You can enter an arrangement fee percentage and a documentation fee. You can also choose whether those fees are paid upfront or added to the loan balance.
3. What does the balloon percentage mean?
The balloon percentage is the estimated balance left at the end of the repayment term. It may need to be paid, refinanced, or settled under the lender agreement.
4. Can I model interest-only months?
Yes. Enter the number of interest-only months. The calculator estimates lower early payments, then switches to amortizing payments for the remaining term.
5. What is the cash flow cover ratio?
It compares available monthly business cash flow with the estimated monthly payment. A higher ratio suggests more repayment comfort. It is only a planning guide.
6. Does this include variable interest rates?
No. The model assumes one annual rate for the full term. For variable loans, test several rates to understand possible payment changes.
7. Why is my total cost higher than expected?
Total cost includes interest, fees, and monthly administration charges. Longer terms, financed fees, and balloon balances can also increase the full repayment impact.
8. Can I export the result?
Yes. After calculating, use the CSV button for spreadsheet work. Use the PDF button for a simple printable summary.