How To Calculate The Percentage Payable

Table of contents:

How To Calculate The Percentage Payable
How To Calculate The Percentage Payable

Video: How To Calculate The Percentage Payable

Video: How To Calculate The Percentage Payable
Video: How to find Interest & Principal payments on a Loan in Excel 2024, April
Anonim

Sometimes the amount of payment is indicated not in the form of a specific amount, but in the form of a certain percentage payable. This usually occurs in cases where the initial amount is not known in advance, for example, a percentage of wages or the cost of a product. To calculate the interest payable, it is enough to know the size of the interest rate and the amount from which the interest is calculated.

How to calculate interest payable
How to calculate interest payable

It is necessary

calculator, computer

Instructions

Step 1

To calculate the interest payable, multiply the original amount by the number of interest and divide the resulting product by one hundred. That is, use the formula:

Pu = C * Kp / 100, Where:

С - the amount from which the interest to be paid is calculated, Кп - interest rate, Pu - the amount of interest payable.

Example.

Calculate the percentage payable for payroll income tax of RUB 50,000.

Decision.

Since the income tax rate is (usually) 13%, we get:

Pu = 50,000 * 13/100 = 6,500 (rubles).

Step 2

If you have to count the interest payable all the time, then create a small table in Excel. To do this, write, for example, in cell A1: “Initial amount”, in cell B1 - “Number of interest”, and in C1 - “Amount of interest payable”. Then write down the following formula in cell C2 (you can copy it directly from the text):

= A2 * B2 / 100. Now it is enough to enter a known amount in cell A2, and the number of interest in B2, as a ready interest for payment will appear in cell C2.

Step 3

If you need to calculate the percentage payable for several amounts, then multiply the formula located in cell C2 down by the required number of lines. To do this, move the mouse cursor to the lower right corner of the cell until it turns into a small "plus" sign, and drag the cursor down the required number of lines.

Step 4

To calculate the interest payable on the loan, contact the bank employee where you intend to apply for the loan. Even knowing all the formulas and methods for calculating loan payments, it is almost impossible for a non-professional to take into account all the nuances when calculating interest on its repayment. If you nevertheless decide to calculate the interest payable yourself, then use one of the many online loan calculators (for example, https://credcalc.ru/). Just keep in mind that such calculations, as a rule, do not take into account additional commissions and one-time payments.

Recommended: