Calculating the Constant Yield Using Excel

Posted by & filed under Debt, Derivatives.

I’ve had numerous requests to show how the constant yield rate for debt cost amortization is computed in the sample Excel effective interest method calculations. The idea is pretty simple once you have the formulas set up. The objective is to determine the rate that drives the amortization balance to zero on the maturity date… Read more »

The Effective Interest Rate Method

Posted by & filed under Debt, Equity-Linked Transactions.

The effective interest rate method, or interest method as it is referred to by the FASB in the codification, spreads the total cost of debt over the life of the debt at a constant interest rate. This constant interest rate is also referred to as the constant interest yield. The constant interest rate includes the… Read more »