Scroll down the list that displays and click on COUNTA. P Principal Amount. FVC6 C8 C7 C80 - C5.
Use the Interest Formula Enter the command ISPMT A2B2C2-D2 in E2.
I Annual Interest Rate in Percentage Terms. Compound Interest Formula P 1 i n 1 Where. N is the number of investment periods for example 36 months 3 years etc. The compound interest formula reduces to 10000 10044 415 10000 10160.