Calculating Monthly Interest Rate Based on an Opening and Closing Balance

[PeterDavids]

Dear All

I have two parameters of an investment:
1. The opening balance on the first day of a month
2. The closing balance on the last day of the month.

How do I calculate the interest rate for the month based on these two balances?

Your help would be greatly appreciated.
Peter

 

[kevin9999]

Anything like this?

Book1
	A	B	C	D
1	Month Start	Month End	Monthly gain (loss)	Yearly %
2	$100.00	$102.25	2.25%	27.0%
3	$100.00	$100.50	0.50%	6.0%
4	$100.00	$99.50	(0.50%)	(6.0%)
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=((B2/A2)-1)
D2:D4	D2	=((B2/A2)-1)*12

 

[PeterDavids]

Thank you Kevin.

 

[kevin9999]

Happy to help Peter & thanks for the feedback