I want to deduct loan from the salary but this loan must no be deducted wiwth rent i want to be like this as follows:

I want to deduct loan from the salary but this loan must no be deducted wiwth rent i want to be like this as follows:loan taken is 200,000 and loan deduct per month is 30,000 so can i show this in a salary sleep and also must show loan balance so how can i do this caluculation by the help of excel formula because i plan payroll but this is one of the caluculation which i facing problem.if is possible can you send me excell file as an examlpe that perform this caluculationthanks,