Good day

I have two scenarios:

Scenario 1: I pay money to various inter-company BP's, as an advanced to be able to pay creditors. As they receive revenue they pay the money back. I need to calculate monthly interest based in daily balances. Is there any way to do this?

Scenario 2: I pay money to various inter-company BP's as loans, for infrastructure development. The interest is calculated daily, capitalized monthly but they pay yearly the installments. Basically an amortization schedule is needed with interest calcs.

Is there a solution for this?