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.
From India, Ahmadabad
Acknowledge(0)
Amend(0)
3If 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.
From India, Ahmadabad
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt