Can't get the formula working

Copper Contributor

Hi I want the following data to work;


3  Principal amount           5.000

4  Rate of Interest             10%

5  Period in days               60      (Maximum)


7  Principal + Interest      ...............

8  Total Interest per day  ...............


Can someone please help me with this formula, coz nothing I tried functioned only on monthly basis, but not on daily basis. Thank you so much.

2 Replies

@MartMach Perhaps this?

Screenshot 2023-09-06 at 06.46.14.png

Hi, the initial condition presented above is incomplete. Is the 10% interest for one period (of 60 days) or is that the annual rate? So assuming the former, and assuming the loan amount is 5000, you have
P + I = -PMT(0.1/60, 60, 5000) = 87.64
total interest paid for the period = 60 * 87.64 - 5000 = 258.33
Total interest paid will not be 500. Because some principle is being returned everyday, the loan balance diminishes and thus the interest diminishes. However if all the 5000 principle was paid back on the last day, and not a bit every day, then interest would be 500.
You can use Pn = -PPMT(0.1/60, N, 60, 5000) to find out the amount of principle returned on day N. Interest paid on day N is P + I - Pn.