How much loan can I afford?

Almost every business and individual has an installment loan. Mortgage, car payment or a business startup loans are a few of the common ones. 


So you have sat down and figured out what monthly payment you can afford, so now how do you figure out what your budget is for that new piece of equipment? By using a simple excel formula you can figure out the answer.


I have created a calculator so you won't have to do the math yourself.  Click below to download the interactive spreadsheet.


In the comments below, please let me know what other questions you would like to see tackled in these blog posts.


We can custom tailor financial business solutions to your needs. Contact us today and we will lend a hand!


How much loan can I afford?
This calculator allows you to determine how large of a loan you can get with a given term, interest rate, down payment and desired monthly payment.
How much loan can I afford.xlsx
Microsoft Excel Table 64.9 KB

Write a comment

Comments: 1
  • #1

    Marsha Maffei (Saturday, 04 February 2017 13:46)

    Hi, Neat post. There's a problem along with your web site in internet explorer, could check this? IE nonetheless is the market leader and a big part of other people will pass over your magnificent writing due to this problem.