Scribd
Upload
63 views6 pages

Total 56,000 61,700 5,700 Total Out Balance 49,380

This document contains loan details for 5 borrowers including name, amount borrowed, interest rate, payment schedule, and balances. The total amount borrowed was 56,000 pesos with total interest of 5,700 pesos and an outstanding balance of 49,380 pesos. It provides payment amounts, dates, interest, principal applied and balances for each borrower.

Uploaded by

edison nuguid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
63 views6 pages

Total 56,000 61,700 5,700 Total Out Balance 49,380

This document contains loan details for 5 borrowers including name, amount borrowed, interest rate, payment schedule, and balances. The total amount borrowed was 56,000 pesos with total interest of 5,700 pesos and an outstanding balance of 49,380 pesos. It provides payment amounts, dates, interest, principal applied and balances for each borrower.

Uploaded by

edison nuguid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Date Amount Total Interest

Name of Borrower Released Borrowed Payable

1 Allysa Mae M. Dugay 24-Oct-16 10,000 11,500 1,500


2 Con Cantos 26-Oct-16 12,000 13,200 1,200
3 Karen Patio 25-Oct-16 19,000 19,000 0
4 Benjo 30-Oct-16 15,000 18,000 3,000
5
6
7
8
9
10
Total 56,000 61,700 5,700
Total Out Balance 49,380
Payment Number of Total Total
Amount Gives Start End Payment Balance

1,920 6 31-Oct-16 15-Jan-17 1,920 9,580


3,300 4 15-Nov-16 31-Dec-16 - 13,200
5,000 8 25-Oct-16 31-Jan-17 5,000 14,000
2,300 6 15-Nov-16 28-Feb-17 5,400 12,600

12,320
Name of Borrower Allysa Mae M. Dugay Name of Borrower
Loan Amount ₱10,000 Start Date: 30-Oct-16 Loan Amount
Monthly Interest % 5.00 End Date: 15-Jan-17 Monthly Interest %
Number of Payment 6.00 Number of Payment
Total Interest ₱1,500.00 Total Interest

Pmt No. Loan Payment Interest Principal Balance Pmt No. Loan
₱10,000 ₱1,917 ₱1,500 ₱10,000 ₱11,500 ₱12,000
1 1,920 250 1,667 9,580 1
2 - - 9,580 2
3 - - 9,580 3
4 - - 9,580 4
5 - - 9,580
6 - - 9,580
9,580
9,580
9,580
9,580
1,920 Total Balance 9,580

Name of Borrower
Loan Amount Start Date:
Monthly Interest % 5.00 End Date:
Number of Payment 6.00
Total Interest ₱0.00

Pmt No. Loan Payment Interest Principal Balance


₱0 ₱0 ₱0 ₱0 ₱0
1 - - -
2 - - -
3 - - -
4 - - -
5 - - -
6 - - -
-
-
-
-
- Total Balance -
Con Cantos Name of Borrower Karen Patio
₱12,000 Start Date: 15-Nov-16 Loan Amount ₱19,000
5.00 End Date: 30-Dec-16 Monthly Interest % 0.00
4.00 Number of Payment 5.00
₱1,200.00 Total Interest ₱0.00

Payment Interest Principal Balance Pmt No. Loan Payment


₱3,300 ₱1,200 ₱12,000 ₱13,200 ₱19,000 ₱5,000
- - 13,200 1 5,000
- - 13,200 2
- - 13,200 3
- - 13,200 4
13,200
13,200
13,200
13,200
13,200
13,200
- Total Balance 13,200 5,000
aren Patio Name of Borrower Benjo
Start Date: 25-Oct-16 Loan Amount ₱15,000
End Date: 28-Feb-17 Monthly Interest % 5.00
Number of Payment 8.00
Total Interest ₱3,000.00

Interest Principal Balance Pmt No. Loan Payment Interest


₱0 ₱19,000 ₱19,000 ₱15,000 ₱2,250 ₱3,000
- 5,000 14,000 1 2,700 451
14,000 2 2,700 451
14,000 3 -
14,000 4 -
14,000 5 -
14,000 6 -
14,000 7 -
14,000 8 -
14,000
14,000
Total Balance 14,000 5,400 Total Balance

375
0.16666667
Start Date: 15-Nov-16
End Date: 28-Feb-17

Principal Balance
₱15,000 ₱18,000
2,249 15,300
2,249 12,600
- 12,600
- 12,600
- 12,600
- 12,600
- 12,600
- 12,600
12,600
12,600
Total Balance 12,600

You might also like