Effective interest bond discount amortization in Excel will calculate the amortization of a bond discount using the effective method. A bond discount results when bonds are issued for less then the face

We will calculate the amortization of a bond premium using the effective method the preferred method under GAAP. The effective method can be compared to the straight line method. Under the straight line

Putting together a notes payable amortization schedule so that we can break out loan payments between interest and principle. Many loans we are familiar with are installment loans which have equal payments