First steps: formula for Zineszins and registration of the values
The mathematical formula of compound interest Ke=Ka(1+p/100) implement the^n in Excel, you must enter the following values in your Excel table:
- The invested assets or the starting amount of "Ka" in the Euro, we are in the field A2.
- The annual rate of interest "p" in percent, we are in the field B2.
- The investment period "n" years, we are in the field C2.
- Analogously to enter in the case of a loan values for the loan amount "Ka", the credit interest rates, "p", and the term of the loan, "n".
Compound interest formula in Excel apply
- Enter the compound interest formula is now available as a command in cell D2. The command is "=A2*(1+B2/100)^C2", without the quotes.
- Note: In the case of a loan, you can calculate on the invoice, Ke - Ka, how much money you will cost of credit actually is.
For more tips for calculating with Excel, see the next tip.
