Annual Statement of Indebtedness, Payments and Balances (SIPB) 2020.xlsx

	A	B	C	G	H	J	K
1	FDPP Form 2 - Annual Statement of Indebtedness, Payments and Balances
2	(DOF-BLGF Memorandum Circular No. 005-2018 dated January 22, 2018, Annex E)
3
4	Annual Statement of Indebtedness, Payments and Balances (SIPB)
5		CY 2020
6		Province of Misamis Oriental
7
8	Instruction: Please prepare a Statement for each kind of loan.
9	ITEM NO.	PARTICULARS	DETAILS
10	1	LGU Income Classification	1st Class Province
11	2	Date of Report	December 31, 2020
12	3	Lending Institution (Bank or Creditor)	Development Bank of the Philippines
13	4	Certificate Number - NDSC/BC	14-12-364
14	5	Date of Certification - NDSC/BC	December 02, 2014
15	6	Monetary Board (MB) Resolution Number	48
16	7	Date of MB Opinion	March 27, 2015
17	8	Date of Approval Loan	May 07, 2015
18	9	Amount Approved*	164,800,000.00
19	10	Maturity Date	November 27, 2022
20	11	Type of Indebtedness Instrument (Loan, Bond or other form of indebtedness)	Long-Term loan
21	12	Purpose of Indebtedness	Acquisition of Various Heavy Equipment
22	13	Terms and Conditions: Fixed or Variable	Variable
23	14	Terms and Conditions: No. of Years of Indebtedness	7 years	1,087,985.18	54,399.26	1,312,677.78	13,126.78
24	15	Terms and Conditions: Interest Rate	3.875%	986,725.69	49,366.28	1,596,500.00	15,965.00
25	16	Terms and Conditions: Grace Period (Number of Months or Years)	12 months	951,987.04	47,599.35	1,631,977.78	16,319.78
26	17	Frequency of Payment	Quarterly	883,987.96	44,199.40	1,631,977.78	16,319.78
27	18	Annual Amortization: Principal	27,466,666.68	3,910,685.87	195,564.29	1,631,977.78	16,319.78
28	19	Annual Amortization: Interest	2,839,700.47			1,512,979.40	15,129.79
29	20	Annual Amortization: Gross Receipt Tax (GRT)	141,985.02			1,495,979.63	14,959.80
30	21	Starting Date of Payment	February 27, 2016 (Interest); February 27, 2017 (Interest + Principal)			1,427,980.56	14,279.81
31	22	Cumulative Payment from Starting Date: Principal	109,866,666.70			1,359,981.48	67,999.07
32	23	Cumulative Payment from Starting Date: Interest	23,982,238.67			1,249,852.55	62,492.63
33	24	Cumulative Payment from Starting Date: GRT	709,429.82			1,223,983.33	61,199.17
34	25	Total Amount Released (Availment as of date)	164,800,000.00			1,155,984.26	57,799.21
35	26	Remaining Balance to Date / Undrawn Amount (Line 9-25=26)	-			1,087,985.18	54,399.26
36	27	Outstanding Loan Balance After Principal Payment (Line 9-22=27)	54,933,333.30			986,725.69	49,336.28
37	28	Arrears: Principal (if any)				951,987.04	47,599.35
38	29	Arrears: Interest (if any)				883,987.96	44,199.40
39	30	Collateral Security	Assignment of portion of IRA withhold-out deposit equivalent to 1 month quarterly amortization			21,142,538.20	567,444.89
40	31	Deposit to Bond Sinking Fund for the Year
41	32	Sinking Fund Balance to Date, if any
42	33	Breakdown of Fees and Other Related Costs (of loan)	Finance Charge- 1,312,677.78
43			Non-Finance Charge - 837,126.78
44	34	Other Relevant Terms and Conditions (of loan)
45
46	Certified Correct by:	Date Issued:
47
48
49	(Sgd.) RONALD JAME D. VIOLON, CPA, REB, REA, MDMG January 12, 2021
50	Acting Provincial Treasurer
51
52	Note:
53	*Please indicate if on a staggered basis.
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100