Most often need for calculation of percent arises in relation to payments for the credits. Depending on whether single calculation is necessary or it is required to have constantly near at hand the table with calculations, different practical ways of accounting will be more convenient in use.
Instruction
1. If it is necessary to count disposable percent on the credit, then it is the simplest to use any of online calculators. For example, the calculator on the website http://calculator-credit.ru allows to consider except annual or monthly percent both the single and monthly commissions and also the payment type (fixed or charge for the rest).
2. The detailed result of calculation of percent will be presented in the table which can be kept or printed out.
3. If you need to have a possibility independently to countof percent and to have such tool constantly near at hand, irrespective of existence of connection to the Internet, then it is possible to use, for example, the tabular editor of Microsoft Excel. Start it and design simple version of the table of calculation of percent which can be complicated further.
4. Create the called cell which will contain value monthly (daily, annual - depending on your needs) of percent of payments. For this purpose click a cell, for example, E1 and in the field "Name" replace inscription E1 with own name of this cell (for example - "прВыплат") and press Enter.
5. Enter value of percent in this cell.
6. Create a similar cell and for the initial sum from which percent will be counted. For this purpose click a cell of B1 and in the same Name field set it own name - for example, "bazsumma".
7. Enter value of the basic sum of calculations in this cell.
8. Allocate the columns B and C, right-click them and select the Format of Cells item.
9. Choose the line "Monetary" in the Numerical Formats list and press the OK button.
10. Place a formula of calculation of percent in the cell (C1) following the basic sum. Completely contents of this cell have to look so: = bazSumma*prVyplat/100
11. Click to B2 yachek (under a cell with the basic sum) and enter in it such formula: =B1 - S1Eto calculation of the rest of the basic sum minus the interest paid last month.
12. Place in C2 cell (to the right of previous) this formula: = bazSumma*prVyplat/100Eto calculation of monthly payment from the basic sum this month. The formula in case of the fixed percent of payments has to be such. For use of floating percent the bazsumm variable should be replaced with designation of a cell (B1).
13. You will mark month of the first payment in the first cell of the table (A1). For example, write "July 2011".
14. Right-click heading of this column and choose the line "Format of Cells" to establish the most convenient display of dates in this column.
15. Click the line "Date" in the Numerical Formats list and choose in the list of formats that which best of all is suitable for display of maturity date. Then press the OK button.
16. Enter a formula of display of the next month of payment in A2 cell: = DATE (YEAR (A1); MESYATS (A1)+1; DAY (A1))
17. Allocate the second line of the table and copy its pressing combinations of the keys CTRL + C.
18. Allocate in the first column the range of cells, since third line and until the end of the period of repayment of percent - on one cell for every month, minus two already filled months. If you choose more - not terribly, superfluous it will be possible to remove.
19. Insert the copied line pressing of a combination of the keys CTRL + V. On it creation of the table for calculation of the fixed percentage payments is finished. In two called cells (basic sum and percent of payments) it is possible to change values and to see as table contents will change.