High debit balance & interest fees Model

Description
This model is used to revise the fees charged by banks in the bank statements in overdraft statement (High debit balance fees & interest fees) and ensure that all fees calculated as agreed in credit line contract.

You can input the historical transactions related to bank statements for credit lines by the transaction date and also the value date for each transaction. It calculate the high debit balance fees and the interest amount as per agreed with the bank contract.

Besides, you will put the real figures of both amounts H.D.B and interest amount and the model will calculate the difference between the amounts should be as previous contract for your credit line and the rate actual used by the bank to calculate.

However, if there is any difference you can reach the exact rate that bank calculate his amount by choose the cell of the difference and use what if analysis - goal seek section and set the difference cell to Zero by changing the rate and the model will solve it for you and determine the exact rate used by the bank.

This model can be used by treasurers, FP&As, Accountants or any Person interested in finance and accounting fields.