Maybe I am confused but if I am understanding this correctly you need to take the coulumn N divide it by column D then divide by 100 to get the percent.

I think your coulmn H is the total deals on finance... =(G5/D5)/100

When I set up JD's line using =(G5/D5)/100 then I get 27% for him..