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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.