Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation of After tax Cost of debt Plz Help
Excel Calculation of Before and After Cost of debt Bond is redeemable at premium 5% of the 1000 face value i.e 1050. I J I and J are cell name. Tax Rate 35% Coupon Rate 15% Maturity Value 1050 Face Value 1000 No of Years of Bond 7 Present Value 976 Brfore Tax Cost of Debt 16.03% After Tax Cost of Debt Missing % Here i have problem It should be 10.8%. I need after cost of debt 10.8% but its not coming *Remember:* Bond is redeemable at premium 5% of the 1000 face value i.e 1050. Thanks in advance. -- Sir ------------------------------------------------------------------------ Sir's Profile: http://www.excelforum.com/member.php...o&userid=34598 View this thread: http://www.excelforum.com/showthread...hreadid=543698 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Calculation Excel 2000 - Excel 2003 | Excel Discussion (Misc queries) | |||
How do I see the formula calculation used in Excel functions box | Excel Worksheet Functions | |||
microsoft excel does not calculate - Automatic calculation is enab | Excel Discussion (Misc queries) |