how to generate loan balance sheet totalamt,paidamt,total

(R.F_Amount)As 'MonInstal',

(L.F_Loan_Amt /(L.F_No_Of_Installment) * (R.I_INSNO)) as 'PaidAmt',


(L.F_Loan_Amt - (L.F_Loan_Amt /(L.F_No_Of_Installment) * (R.I_INSNO))) as 'BalanceAmt',
--L.F_Loan_Amt-ISNULL((R.F_Amount),0) As 'Balance_Amt',
L.F_No_Of_Installment-(R.I_INSNO) As 'BalInstal'

----CEILING((L.F_No_Of_Installment-ISNULL(SUM(R.I_INSNO),0))/(L.F_No_Of_Installment*1.))'Balance.Instal'
from Loan_recovery R

join LoanAvail_Entry L On R.C_Employeecode=L.C_Employeecode
join Employee E on R.C_Employeecode=E.C_EmployeeCode
where L.C_MMYYYY<='042016' and R.C_Employeecode='50173'
GROUP BY R.C_Employeecode,E.C_EmployeeName,R.C_LoanCode,R.F_Amount,F_Loan_Amt,l.F_No_Of_Installment,I_INSNO

50173 KAVITHAMOL .S PL 20000 10 1 2000 2000 18000 9
50173 KAVITHAMOL .S PL 20000 10 2 2000 4000 16000 8
50173 KAVITHAMOL .S PL 20000 10 3 2000 6000 14000 7
50173 KAVITHAMOL .S PL 20000 10 4 2000 8000 12000 6
50173 KAVITHAMOL .S PL 20000 10 5 2000 10000 10000 5
50173 KAVITHAMOL .S PL 20000 10 6 2000 12000 8000 4
50173 KAVITHAMOL .S PL 20000 10 7 2000 14000 6000 3
50173 KAVITHAMOL .S PL 20000 10 8 2000 16000 4000 2
50173 KAVITHAMOL .S PL 20000 10 9 2000 18000 2000 1
50173 KAVITHAMOL .S PL 20000 10 10 2000 20000 0 0