Long description
| A | B | |
| 1 | Finding the Before-Tax Cost of Debt | |
| 2 | Par value | negative 1000 dollars |
| 3 | Coupon interest rate | 6 percent |
| 4 | Interest payments per year | 1 |
| 5 | Interest payment | negative 60 dollars |
| 6 | Number of years to maturity | 20 |
| 7 | Net proceeds from sale of bond | 980.00 dollars |
| 8 | Before-tax cost of debt | 6.177 percent |
Entry in Cell B8 equal to sign RATE(B6 times B4,B5,B7,B2,0). The minus sign appears before the 1,000.00 dollars in B2 and the 60 dollars in B5 because these values are cash outflows for the corporation. |
Get Principles of Managerial Finance, 15th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
