How to Calculate Quarterly Compounded Interest in Excel for a 3-Year Investment?

Excel Software.

If I have invested $5000 on 13.11.2005 for 3 years, what will be the interest separately for every year (quarterly compounded)? Something I want like as below. Int for 13.11.2005 to 31.04.2006, say A plus principal say B = C. Int for 01.04.2006 to 31.04.2007, say D plus C. Thus, A, B, C, and D should reflect in different columns or rows. Thus by entering amount, value date, rate of interest, and the two dates for which interest is required, i.e., 01.04.2006 to 31.03.2007 like this. But all should come in one sequence. I hope that anyone will definitely help me in this matter. Thanking you.

Hi,

Please find attached an Excel sheet which will explain about calculating COMPOUND INTEREST in two different ways. Hope this may help you. If you require an Excel file just as quoted by you, try to create a format on your own (the best method to learn Excel) - I will help you to insert relevant formulas so that you will get exactly what you want.

Regards,
RAJA C S N, Director
GLOBALedge TRAINING ACADEMY
e-mail: geta.erode@gmail.com

Hi Satish,

When you open the file, you will be prompted with two options. One is to provide a password, and the other is to open the file in READ ONLY mode. In this mode, you can open the file, see the contents, and work on it. However, you can't save the changes made by you.

I typically provide my tutorial files in READ ONLY mode so that the contents will not be accidentally deleted. Please give it a try.

Regards,
RAJA C S N
GLOBALedge TRAINING ACADEMY