If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to calculate interest on payments
I need a formula/spreadsheet that will calculate 18% interest on delinquent
quarterly payments. Example: Tenant owes $100 every quarter but has not made a payment since 2006. I need to be able to plug in the "past due" payment, accumlate the balance and compute the interest due.. |
#2
|
|||
|
|||
how to calculate interest on payments
Bob
Assuming you mean 18% p.a. for whole years only from the date the rent was due this may do it for you. If it doesn't come out clearly post your email address and I'll forward the s/s 31/03/2007 100 2.682191781 2 04/12/2009 36 30/06/2007 100 2.432876712 2 04/12/2009 36 30/09/2007 100 2.180821918 2 04/12/2009 36 31/12/2007 100 1.928767123 1 04/12/2009 18 31/03/2008 100 1.679452055 1 04/12/2009 18 30/06/2008 100 1.430136986 1 04/12/2009 18 30/09/2008 100 1.178082192 1 04/12/2009 18 31/12/2008 100 0.926027397 0 04/12/2009 0 31/03/2009 100 0.679452055 0 04/12/2009 0 30/06/2009 100 0.430136986 0 04/12/2009 0 30/09/2009 100 0.178082192 0 04/12/2009 0 "=SUM(G11-A11)/365" "=ROUNDDOWN(D11,0)" "=TODAY()" "=SUM(B11*E11*18%)" Total rent 1100 Accumulated Interest 180 Grand total 1280 "Bob L" wrote: I need a formula/spreadsheet that will calculate 18% interest on delinquent quarterly payments. Example: Tenant owes $100 every quarter but has not made a payment since 2006. I need to be able to plug in the "past due" payment, accumlate the balance and compute the interest due.. |
#3
|
|||
|
|||
how to calculate interest on payments
|
Thread Tools | |
Display Modes | |
|
|