well,

i need to find a company's cost of debt , im familiar with the formula of the net proceeds but since the periods are too many (40) i cant do it by hand . do u know if there is a way i can find the result maybe using excel? and how is that possible

.....................n.....................................n
net proceeds = Σ I/(1 +rd) + par value/(1 + rd), n=40. i need to solve for rd
.....................1


thank u very much