How to Calculate Loan Amount in Excel

You are often in a dilemma of how much money you can lend. You know what kind of income you have converted in your obligation and figure out how much of the loan could you still be repaid. Find out what kind of the interest rate is possible to get for a loan in the bank.

You have data on the amount of monthly installment, the interest rate and the loan repayment period. From these data you can calculate how much loan could you get? YES. Below you can see how this can be. You can choose a variety of annuities, different interest rates and different repayment periods. In this way, you will come to that loan that suits you best.

The calculation will be made ​​to compound and the sinple (proportional) method. At the bank ask which method they used. The difference in small amounts and low interest rate is not high. More accurate is compound way, but because of a more simple calculation is using more sinple. In sinple interest is distributed evenly over the entire period, the compound is increasing over the period, as the basis for the calculation take the interest accrued in the previous period. Compound calculation is slightly more favorable to the borrower. You'll find yourself when you prepare the calculation presented here.

Let's start and much success!

You will use Excel. Do the template as you see it in the table below. Use the same rows and columns, so that you can copy the formula.

Enter all the details before you enter the formula

Information is necessary for control previously entered data.

In A7 copy =A5*B5

The formulas for calculating the amount of credit is very complex, so it is best for you to copy the formulas.

In A9 copy =A3/(1/((((1+(100*(((1+B3/100)^(B5/12))-1))/100)^A5)-1)/(((1+(100*(((1+B3/100)^(B5/12))-1))/100)^A5)*((1+(100*(((1+B3/100)^(B5/12))-1))/100)-1))))

In B9 copy =A3/((((1+(B3/(1200/B5)))^A5)*((1+(B3/(1200/B5)))-1))/(((1+(B3/(1200/B5)))^A5)-1))

Now you are done with the template. You can use it with data that are of interest for you.