Expansion Loan Payback
Calculator
Results
- Payback month
- 7 mo
- Cumulative net cash
- $130,433.27
- Monthly loan payment
- $4,055.28
- Total interest
- $43,316.73
Projected path over the horizon
- Cumulative net cash
- Extra profit
Period-by-period projection
| 1 | 4,055.28 | 1,333.33 | 1,083.33 | -2,971.95 |
| 2 | 4,055.28 | 1,315.19 | 2,166.67 | -4,860.56 |
| 3 | 4,055.28 | 1,296.92 | 3,250.00 | -5,665.84 |
| 4 | 4,055.28 | 1,278.53 | 4,333.33 | -5,387.78 |
| 5 | 4,055.28 | 1,260.02 | 5,416.67 | -4,026.39 |
| 6 | 4,055.28 | 1,241.38 | 6,500.00 | -1,581.67 |
| 7 | 4,055.28 | 1,222.62 | 6,500.00 | 863.05 |
| 8 | 4,055.28 | 1,203.74 | 6,500.00 | 3,307.77 |
| 9 | 4,055.28 | 1,184.73 | 6,500.00 | 5,752.49 |
| 10 | 4,055.28 | 1,165.59 | 6,500.00 | 8,197.21 |
| 11 | 4,055.28 | 1,146.33 | 6,500.00 | 10,641.93 |
| 12 | 4,055.28 | 1,126.94 | 6,500.00 | 13,086.65 |
| 13 | 4,055.28 | 1,107.41 | 6,500.00 | 15,531.37 |
| 14 | 4,055.28 | 1,087.76 | 6,500.00 | 17,976.10 |
| 15 | 4,055.28 | 1,067.98 | 6,500.00 | 20,420.82 |
| 16 | 4,055.28 | 1,048.06 | 6,500.00 | 22,865.54 |
| 17 | 4,055.28 | 1,028.01 | 6,500.00 | 25,310.26 |
| 18 | 4,055.28 | 1,007.83 | 6,500.00 | 27,754.98 |
| 19 | 4,055.28 | 987.52 | 6,500.00 | 30,199.70 |
| 20 | 4,055.28 | 967.06 | 6,500.00 | 32,644.42 |
| 21 | 4,055.28 | 946.48 | 6,500.00 | 35,089.14 |
| 22 | 4,055.28 | 925.75 | 6,500.00 | 37,533.87 |
| 23 | 4,055.28 | 904.89 | 6,500.00 | 39,978.59 |
| 24 | 4,055.28 | 883.88 | 6,500.00 | 42,423.31 |
| 25 | 4,055.28 | 862.74 | 6,500.00 | 44,868.03 |
| 26 | 4,055.28 | 841.46 | 6,500.00 | 47,312.75 |
| 27 | 4,055.28 | 820.03 | 6,500.00 | 49,757.47 |
| 28 | 4,055.28 | 798.46 | 6,500.00 | 52,202.19 |
| 29 | 4,055.28 | 776.75 | 6,500.00 | 54,646.91 |
| 30 | 4,055.28 | 754.90 | 6,500.00 | 57,091.63 |
| 31 | 4,055.28 | 732.89 | 6,500.00 | 59,536.36 |
| 32 | 4,055.28 | 710.74 | 6,500.00 | 61,981.08 |
| 33 | 4,055.28 | 688.45 | 6,500.00 | 64,425.80 |
| 34 | 4,055.28 | 666.00 | 6,500.00 | 66,870.52 |
| 35 | 4,055.28 | 643.41 | 6,500.00 | 69,315.24 |
| 36 | 4,055.28 | 620.66 | 6,500.00 | 71,759.96 |
| 37 | 4,055.28 | 597.76 | 6,500.00 | 74,204.68 |
| 38 | 4,055.28 | 574.71 | 6,500.00 | 76,649.40 |
| 39 | 4,055.28 | 551.51 | 6,500.00 | 79,094.12 |
| 40 | 4,055.28 | 528.15 | 6,500.00 | 81,538.85 |
| 41 | 4,055.28 | 504.64 | 6,500.00 | 83,983.57 |
| 42 | 4,055.28 | 480.97 | 6,500.00 | 86,428.29 |
| 43 | 4,055.28 | 457.14 | 6,500.00 | 88,873.01 |
| 44 | 4,055.28 | 433.15 | 6,500.00 | 91,317.73 |
| 45 | 4,055.28 | 409.00 | 6,500.00 | 93,762.45 |
| 46 | 4,055.28 | 384.69 | 6,500.00 | 96,207.17 |
| 47 | 4,055.28 | 360.22 | 6,500.00 | 98,651.89 |
| 48 | 4,055.28 | 335.59 | 6,500.00 | 101,096.61 |
| 49 | 4,055.28 | 310.79 | 6,500.00 | 103,541.34 |
| 50 | 4,055.28 | 285.83 | 6,500.00 | 105,986.06 |
| 51 | 4,055.28 | 260.70 | 6,500.00 | 108,430.78 |
| 52 | 4,055.28 | 235.40 | 6,500.00 | 110,875.50 |
| 53 | 4,055.28 | 209.93 | 6,500.00 | 113,320.22 |
| 54 | 4,055.28 | 184.30 | 6,500.00 | 115,764.94 |
| 55 | 4,055.28 | 158.49 | 6,500.00 | 118,209.66 |
| 56 | 4,055.28 | 132.51 | 6,500.00 | 120,654.38 |
| 57 | 4,055.28 | 106.36 | 6,500.00 | 123,099.11 |
| 58 | 4,055.28 | 80.04 | 6,500.00 | 125,543.83 |
| 59 | 4,055.28 | 53.53 | 6,500.00 | 127,988.55 |
| 60 | 4,055.28 | 26.86 | 6,500.00 | 130,433.27 |
Comparison
| Scenario | Cumulative net cash | Total interest |
|---|---|---|
| Doing nothing | 0.00 | 0.00 |
| Your scenario | 130,433.27 | 43,316.73 |
Formula
M = P·r(1+r)^n/((1+r)^n−1); net_t = Σ (profit_i − M)= 7.00
Note
Simplified model: this is the exact arithmetic of the stated recurrence applied to your inputs, with every rate held constant for the whole horizon. Real businesses see growth, churn, seasonality and costs move, and no projection accounts for competition, financing terms, tax or one-off events. Treat the crossing month as an order of magnitude, not a date, and check it against your own books before committing money.
More in Business projections
See all →Frequently asked questions
What does "payback" mean here versus the loan's amortization schedule?+
The loan's amortization schedule shows when the debt itself is repaid to the lender, while payback in this calculator tracks when the incremental profit generated by the expansion (the reason you took the loan) first covers the loan's total cost. Those two dates are usually different: you can finish repaying a loan on schedule while the expansion itself takes longer, or shorter, to "pay for itself."
Should I compare payback against the incremental profit or the incremental revenue from the expansion?+
Use incremental profit (revenue from the expansion minus the additional costs it creates), not just incremental revenue, because revenue alone ignores the extra costs — staff, inventory, rent — the expansion itself introduces. Comparing loan cost against gross revenue will make the payback period look misleadingly short.
How do interest payments factor into the payback calculation?+
Interest is a real cost of the expansion and should be included in what needs to be "paid back," alongside the principal, since it's cash that wouldn't have left the business without the loan. Ignoring interest and only tracking principal repayment against profit will understate the true payback period, especially on longer-term loans.
What's a reasonable payback period to consider the expansion a good decision?+
There's no universal number, but many businesses use a rule of thumb of 2-3 years for an expansion loan to pay itself back through incremental profit, adjusted for how long the loan term itself is and how much runway risk the business can tolerate. A payback period that's longer than the loan term itself is a warning sign, since you'd still be carrying debt after the expansion has stopped generating enough profit to justify it on its own.
Why might the incremental profit ramp up gradually instead of starting at full strength immediately?+
Most expansions (a new location, a new product line, added capacity) take time to reach their steady-state performance because of ramp-up effects like hiring and training staff, building local customer awareness, or working through initial operational inefficiencies. Modeling a gradual ramp rather than assuming full profit from month one gives a materially more accurate, usually longer, payback period.