Sounds like a homework assignment to me.
Assume the terms are 2%/10, net 30. If your invoice is $100, you can pay $98
after ten days, or $100 after 30. So you want to know: "What rate of interest
turns $98 into $100 after 20 days?" Feed those numbers into Rate, as in:
=rate(20/365,0,98,-100)
--
Regards,
Fred
"Uli Hildebrand" <Uli.Hildebrand.2bgiu3_1153756806.4971@excelforu m-nospam.com
wrote in message
news:Uli.Hildebrand.2bgiu3_1153756806.4971@excelfo rum-nospam.com...
Write a formula that calculates the Annual Percentage Interest Cost of
the Discount not taken for any set of data. Can anyone help with this
please?
Thank you
Uli
--
Uli Hildebrand
------------------------------------------------------------------------
Uli Hildebrand's Profile:
http://www.excelforum.com/member.php...o&userid=36614
View this thread: http://www.excelforum.com/showthread...hreadid=564348