Mario Lopez created FINERACT-2789:
-------------------------------------
Summary: Balloon loan not working as expected
Key: FINERACT-2789
URL: https://issues.apache.org/jira/browse/FINERACT-2789
Project: Apache Fineract
Issue Type: Bug
Components: Loan
Affects Versions: 1.15.0
Reporter: Mario Lopez
h1. Steps to reproduce
Fineract Version: `d563684` (Release 1.15.0)
1. Create a loan product that behaves like a Balloon (no principal repayment
until the last one) with the following features
|Feature|Value|
|-|-|
|Schedule|Progressive|
|Interest|Declining Balance|
|Repayments|8|
|Grace on Principal|7 (Balloon)|
|Repayment Frequency|Every 3 months|
[https://pastebin.com/gRskJj5t]
2. Preview the repayment schedule for that product
Request: [https://pastebin.com/ujfQLpfh]
| # |Due date|Principal|Interest|Fees|Total due|Balance|
|—|----------|-----------|----------|------|-----------|---------|
|—|2026/08/26|300,000.00|—|0.00|0.00|300,000.00|
|1|2026/11/26|37,500.00|22,500.00|0.00|60,000.00|262,500.00|
|2|2027/02/26|40,312.50|19,687.50|0.00|60,000.00|222,187.50|
|3|2027/05/26|43,335.94|16,664.06|0.00|60,000.00|178,851.56|
|4|2027/08/26|46,586.13|13,413.87|0.00|60,000.00|132,265.43|
|5|2027/11/26|50,080.09|9,919.91|0.00|60,000.00|82,185.34|
|6|2028/02/26|53,836.10|6,163.90|0.00|60,000.00|28,349.24|
|7|2028/05/26|28,349.24|2,126.19|0.00|30,475.43|0.00|
|8|2028/08/26|0.00|0.00|0.00|0.00|0.00|
- The grace on principal is not working as expected. The principal component
in tranches 1-7 is not zero.
3. Setup the grace on principal as N-2
[https://pastebin.com/rqcw57t6]
| # |Due date|Principal|Interest|Fees|Total due|Balance|
|—|----------|-----------|----------|------|-----------|---------|
|—|2026/08/26|300,000.00|—|0.00|0.00|300,000.00|
|1|2026/11/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|2|2027/02/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|3|2027/05/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|4|2027/08/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|5|2027/11/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|6|2028/02/26|0.00|22,500.00|0.00|22,500.00|300,000.00|
|7|2028/05/26|144,578.31|22,500.00|0.00|167,078.31|155,421.69|
|8|2028/08/26|155,421.69|11,656.63|0.00|167,078.32|0.00|
- Grace period on principal with N-2 works as expected.
- Something is wrong when grace on principal is N-1.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
