Amortization Speadsheet with a Difference
 

Hi Guys and Gals (?)

This is my first post here ... so be gentle ... I am looking for a Guru
to solve a problem ... I am a debt collector (ewwww!!!) and a couple of
new client have asked that I confirm the calculations of the debts
being claimed as accurate - this doesnt ordinarily present a problem
.... but when there are multiple defaults problems come in ...

Looking at the attached Client Debt Statement (inside the zip file) I
want to change the sheet, so it calcates interest at the default rate
of 24% if the loan payment is not made by the due date - the default
rate only applies to the amount not paid, and until an arrears have
been brought into line

The spreadsheet I am using would well be modified to suit .. ??

Looking for some hand holding here ....

MTIA

Darrin


+-------------------------------------------------------------------+
|Filename: Debt Amortisation.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3891 |
+-------------------------------------------------------------------+

--
dwe
------------------------------------------------------------------------
dwe's Profile: http://www.excelforum.com/member.php...o&userid=27914
View this thread: http://www.excelforum.com/showthread...hreadid=474119

Amortization Speadsheet with a Difference
 

Hi Darrin,

The attachment URL doesn't work...I get this:

"Invalid Attachment specified. If you followed a valid link, please notify
the webmaster"

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

dwe wrote:
Hi Guys and Gals (?)

This is my first post here ... so be gentle ... I am looking for a
Guru to solve a problem ... I am a debt collector (ewwww!!!) and a
couple of new client have asked that I confirm the calculations of
the debts being claimed as accurate - this doesnt ordinarily present
a problem .. but when there are multiple defaults problems come in ...

Looking at the attached Client Debt Statement (inside the zip file) I
want to change the sheet, so it calcates interest at the default rate
of 24% if the loan payment is not made by the due date - the default
rate only applies to the amount not paid, and until an arrears have
been brought into line

The spreadsheet I am using would well be modified to suit .. ??

Looking for some hand holding here ....

MTIA

Darrin


+-------------------------------------------------------------------+
Filename: Debt Amortisation.zip |
Download: http://www.excelforum.com/attachment.php?postid=3891 |
+-------------------------------------------------------------------+