How to Calculate How Much You Can Borrow Using Excel. How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest ...