| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Annual Percentage Interest cost of discount not taken
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Annual Percentage Interest cost of discount not taken
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Effective Annual Interest Rate | Excel Worksheet Functions | |||
| Percentage Discount | Excel Discussion (Misc queries) | |||
| formula for cost as percentage of sale price | New Users to Excel | |||
| Discount rate - what to use? | Excel Worksheet Functions | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Linear Mode
