%20Working%20Capital%20-Interest%20Calculation%20Sheet.png){kind=link}
Here is the demo sheet only for learning purpose:
|
Date |
Particulars |
Debit |
Credit |
Balance |
|
|
Balance B/F |
|
|
0.00 |
|
20/05/2024 |
PRINCIPAL **** #ABC Company LTD LTD#Asper client req.dt.20/05/2024 |
98,30,000.00 |
0.00 |
98,30,000.00 |
|
20/05/2024 |
PROFIT **** #ABC Company LTD LTD#Asper client req.dt.20/05/2024 |
15,23,650.00 |
0.00 |
1,13,53,650.00 |
|
30/09/2024 |
INVESTMENT REPAYMENT FROM A/C#002536584#**** #ABC Company LTD LTD#Adjustment Partial |
0.00 |
26,64,513.00 |
86,89,137.00 |
|
22/10/2024 |
REBATE |
0.00 |
8,87,541.00 |
78,01,596.00 |
|
22/10/2024 |
CLOSING PAYMENT |
0.00 |
78,01,596.00 |
0.00 |
Bai-Muazzal(Commercial) Working Capital -Interest Calculation Sheet
|
Opening date |
Closing date |
Loan Amount(TK.) |
Rate of Interest% |
Int for Days |
Int. Amount(Tk) |
|
20.05.2024 |
23.10.2024 |
98,30,000 |
14.838% |
157 |
6,36,109 |
|
|
|
|
|
|
|
Interest Apply = Tk.15,23,650
Interest rebate = Tk. (8,87,541)
Net Interest = Tk.6,36,109
(A) Interest as per our calculation = Tk.6,36,109
(B) Interest as per Bank calculation = Tk.6,36,109
(A-B) Difference adj with total Int = Tk.(Nil)