Simple interest rate calculation

[hpbdayananda]

Please help.

I need an excel formula for my personal interest rate calculations. Can someone please give me a formula, so that I just need to input the data in the first 4 columns

Principle amount	Interest rate	start date	maturity period (months)	Interest amount for the period ending
				31-Mar-25	31-Mar-26
1,000,000.00	10%​	1-Jun-24​	12
500,000.00	8%​	8-Aug-24​	6

 

[Joe4]

Welcome to the Board!

Watch this video here, which is a tutorial which shows you how to do this: