Hey guys,

Need some help with excel. I want to work out interest i earn on one of my accounts on a daily basis. I figured it would be much quicker to use excel to display and calculate those figures. Interest is compounded daily at 6.75%p.a. In column A i want to show the balance of each day and column B to show the interest made on that day.

Can anyone tell me how i can do this?

Thanks

i dont have a template for this, but im sure theres some good ones floating around on the net?

__________________
[S]kid[S]

Enter current account balance into cell A1.
Enter the formula (A1 * 0.0675) / 365 into cell B1
Copy and paste that formula down the entire B column
Enter formula A2 = A1 + B1, and copy that formula down the rest of the A column.