# Thread: Interest On a Simple Loan

1. ## Interest On a Simple Loan

If I borrow \$200 each month and the interest rate is 3.5% p.a. I owe \$2484 at the end of the year and so on. Now I am told that the interest rate is compounded daily. As I do not want 360 rows in my worksheet, is there an excel function to allow me to calculate the actual amount owing at the end of each year?

2. The way to to do it is described here: http://support.microsoft.com/kb/213907.

3. David,

This should work and only takes 12 cells.
1st Cell:=200*(1+(0.035/360))^30
2nd Cell:=(A1+200)*(1+(0.035/360))^30
Then copy 2nd cell down 10 rows.
Compound Int.JPG

Of course you might want to enclose the formulas in a =Round(formula,2) function to get even cents but that depends on your bank. Also your bank may use 365 days vs 360 {30 day months} so you need to adjust accordingly.

4. ## The Following User Says Thank You to RetiredGeek For This Useful Post:

dpollock (2012-01-25)

5. Great thanks. I assume there is a very small error if the month is not exactly 30 days and perhaps 365 should be used for the interest calculation??

6. Here is more formal month by month that takes the days in the month and days in the year into account. and compares to RetiredGeeks Calcs.

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•