Expression on interest calculation

[#1]

Dear Experts,

I have following information in my tables.

      LOAN REGISTER 

START_DATE	LOAN_NO	PRO_CODE	NAME	LOAN_AMT	STATUS	SET_DATE
01-Jan-16	RL0001	L01	AAAAAAAA	1,000,000.00	ACTIVE
01-Jan-16	RL0002	L02	BBBBBBBBB	500,000.00	ACTIVE
01-Jan-16	RL0003	L03	CCCCCCCCC	1,200,000.00	ACTIVE
01-Jan-16	RL0004	L03	DDDDDDDD	700,000.00	ACTIVE
01-Jan-16	RL0005	L02	EEEEEEEEEE	900,000.00	ACTIVE
01-Jan-16	RL0006	L01	FFFFFFFFFF	500,000.00	ACTIVE
02-Jan-16	RL0007	L02	GGGGGGGG	1,000,000.00	ACTIVE
02-Jan-16	RL0008	L02	HHHHHHHH	1,500,000.00	ACTIVE
02-Jan-16	RL0009	L01	IIIIIIIIIIIIIIIIII	100,000.00	ACTIVE
02-Jan-16	RL0010	L03	JJJJJJJJJJJJJJ	250,000.00	ACTIVE

   PRODUCT MASTER FILE

PRO_CODE	RATE
L01	5%
L02	6%
L03	7%

   COLLECTOR MASTER FILE

COLL_CODE	COL_NAME
CL001	KKKKKKKKKKKK
CL002	LLLLLLLLLLLLLLL
CL003	MMMMMMMM
MG01	NNNNNNNNN

     RECEIPT CASH BOOK

REC_DATE	REC_NO	LOAN_NO	COLL_CODE	AMOUNT
1/02/2016	R0001	RL0001	CL001	50,000.00
1/02/2016	R0002	RL0002	CL001	25,000.00
1/02/2016	R0003	RL0003	CL002	60,000.00
1/02/2016	R0004	RL0004	CL002	35,000.00
1/02/2016	R0005	RL0005	CL003	45,000.00
1/02/2016	R0006	RL0006	CL002	25,000.00
2/02/2016	R0007	RL0007	CL001	50,000.00
2/02/2016	R0008	RL0008	MG01	75,000.00
2/02/2016	R0009	RL0009	MG01	10,000.00
2/02/2016	R0010	RL0010	MG01	12,500.00

I want to calculate, 01. Daily due balance with accumulated interest.(daily basis)

                              02. The capital recovery and the interest recovery from the above details.

                              03.  How can i exclude the Saturdays from the above calculation,

                              04. If i want to exclude a specific Date from above calculation how can i do that, 

                              05. How can i use a calendar for this purpose.

thkx & rgds,

Priyantha.