Financial Interest Calculations
Financial Interest Calculators offer flexible methods for money and interest loans, mortgages and savings. 
The Financial Compound Interest Calculator explained on this page combines flexibility, ease of usage with powerful calculations.
- The calculation is based on 5 main variables ( N, I, PV, PMT and FV).
- Given 4 of the variables the remaining can be calculated.
- Two additional variables make the calculator more flexible, the Period ( P) and After/Before ( B) payment.
- If you are not familiar with Financial Calculations please read the Detailed examples chapter first.
- the Mechanism chapter explains the relation of the variables and their meaning.
- the Main Vars chapter explains in detail all main fields of the Finance Interest Calculation Website.
- the Additional chapter explains all additional fields.
A few agreements are used to enter the correct values to the variables.
Duration - N
The duration is measured in years.
Interest - I
The Interest is always given as a percentage per Year.
Present Values - PV
The Present Value is the current or now value. Do not use valuta-sign and use a decimal point as separator. Comma fields-separators are not allowed.
Period Payment - PMT
The Period Payment is the amount of money which is received (positive value) or payed (negative value).
Future Value - FV
The Future Value is the payment which is received (positive value) or payed (negative value) at the end of the total duration of the loan/mortgage/annuity.
Period - P
The Period chosen here is used for creating multiple Period Payments per year (PMT). Valid options are Half-year, Quearter, Month, Week and Day.
Example: In case of a mortgage normally the period is a month.
After/Before - B
The value before after in combination with the Period P is used to indicate payment before or after the chosen period.
Example: In case of a mortgage the normal value is after.
Example: In case of a saving account the normal value may be before.
top The detailed examples in this chapter are in a sequential order. So the user has to start with the first Calculate Interest Percentage and follow the other examples from there. This process will make the user familiar with the simple powerful method to calculate complex financial calculation for all kind of common day to day questions on buying, lending, mortgage and saving accounts.
Calculate Interest Percentage
Example questions: "What is the interest rate I need to pay to get the money now?
Example answer: Buying a house with a mortgage of € 250,000.- (PV = 250000), a End-Monthly (B= After, P = Month) Period Payment of €1,000.- (PMT = -1000) and a duration of 30 Year (N = 30) the Interest will be 2.6245% per year.
- Set the Calculate combobox to No Calculation. This is the default value so you may not have to change anything.
- Set the Period combobox to Month.
- Set the After/Before combobox to After. This is the default value so you may not have to change anything.
- Set the Duration to 30.
- The 3rd row of the Duration will indicate 10,950, which is the number of days in 30 years (based on 365 days in a year, without leap years correction).
- Set the Present Value to 250000.
- Set the Period Payment to -1000.
- Set the Future Value to 0. This is the default value so you may not have to change anything.
- Set the Calculate combobox to i-Interest.
- The calculation will be initialized and the result will be shown very shortly.
- In the 3rd row of the Period Payment column -545.83. This is the Interest-Payment-Value for the Interest in the 1st payment. See the Mechanism part for full details.
- In the 2nd row of the Interest column 2.62. This the percentage of the interest per Year 2.62%.
- In the 3rd row of the Interest column 0.2200. This is the percentage of the interest per Month (the chosen period) 0.2200%.
- In the row Status the text: Calculated: Interest-Rate (I).
In case of Status field shows Iteration calculation error. Reached maximum number of iterations! you have made an error in filling the correct values. Review your Website Screen with image 3.
Period Payment Calculation
See the example above, but now with an Interest of 3% will yield to an Period Payment of €1,048.56 (-1048.56).
- Set the Calculate combobox to PMT - Payment Period.
- The value in the Period Payment may be changed to -999.42, because the values on the screen are rounded and the value for the PMT is instantly recalculated.
- Set the Interest to 3. Accept the entry with the tab-key or the Enter-key.
- The value for the PMT changes to -1,048.56.
- The value for the 3rd row under the column PMT (=1st Interest Payment) changes to -625.
Future Value Calculation
Suppose you did not use the payment for a mortgage but use it for a saving account.
- Do not change
- After/Before B = A
- Duration N = 30
- Interest I = 3
- Period Payment PMT = -1048.56
- Set Calculate to No Calculation. This prevents that the calculation overwrites the value for the Period Payment.
- Set PV to 0.
- Set Calculate to FV -Future Value will yield € 606,815.34 (606815.34).
What does this mean?
- You bought a house for € 250,000.00 and paid € 1,048.56 monthly over 30 years.
- When you saved the € 1,048.56 monthly over 30 years you have earned over € 600,000.00.
Is that for real. Yes, but the Bank will never pay the same Interest for borrowing and saving!
The amortization graph is only shown when you make a calculation for a period payment. An example is shown when you click on the following link https://www.harmfrielink.nl/Finance/FinCalc.php?test.
The above image shows the screen when you click on the link.
What is Amortization?
Webster's dictionary defines amortization as, "the systematic repayment of a debt". The emphasis is on the word systematic. Amortizing a loan means paying it down, bit by bit.
Usually this means making regular monthly payments, and this is what is done for mortgage, for example. But any periodic payment over time to a loan is amortization.
The great advantage of amortization is that you know how much you have to pay each month, under a fixed interest rate, to finish paying off the loan at a specific time. You can work out an amortization table to show each payment.
In the graph you see the Balance (the remaining value of the loan in time), the sum of the Period Payments, the sum of the Interest payments and the sum of the payback. If you click on the name of the items in the Legenda you can toggle the lines in the graph. If you hoover over the line you see the data.
- Financial Interest Calculator by Harm Frielink
- Pensioen, Intrawiki Pensioen van HaFr, not accessible for anybody else.
- ↑ Singapore Management University Financial Mathematics for Actuaries
- ↑ World Scientific, Financial Mathematics for Actuaries