Doesn't the worksheet have a place to say for how many months each loan was outstanding?
Are you using average monthly balances? Or annual?
I think your worksheet input is incorrect/incomplete.
