How do you write a formula that calculates the Annual Percentage
Interest Cost of the Discount not taken for any set of data.

Annual Percentage Interest Cost of Discount Not Taken

Prompt Payment Discount Amount 2.5%

Invoice has to be paid within how many days to qualify for the discount
10
Net amount of invoice to be paid within how many days 30

Annual Percentage Interest Cost of Discount Not Taken

Please help

Grahame


--
tiger1969
------------------------------------------------------------------------
tiger1969's Profile: http://www.excelforum.com/member.php...o&userid=26435
View this thread: http://www.excelforum.com/showthread...hreadid=402069