Ways And MeansCurrent GAAP requires that any bond discount or premium be systematically amortized to income. While the APB expressed a clear preference for the effective interest method, the practitioner may use other methods if the results obtained are not materially different from those which would result from the interest method. The effective interest method enjoys the strongest theoretical foundation but is also the most computationally intensive, especially when the bondholder and issuer have different fiscal years. The program presented provides an easy method for evaluating the materiality impact using alternative methods of allocating bond discount or premium over the life of the bond. The program, which is compatible with either Lotus 1-2-3, release 4 or higher, or Microsoft Excel, employs a simple macro to prompt the user for the 5 key facts about a bond. It then automatically calculates the required amounts and produces a table that compares the income statement effects of 3 common amortization methods. The program prepares amortization schedules for a bond of virtually any duration and payment frequency; it also presents the information in the form of a graph. The spreadsheet demonstrates several techniques, such as computing a loan reduction schedule or comparing the effect of various depreciation methods. Current GAAP requires that any bond discount or premium be systematically amortized to income. While the APB expressed a clear preference for the effective interest method, the practitioner may use other methods if the results obtained are not materially different from those which would result from the interest method. The effective interest method enjoys the strongest theoretical foundation but is also the most computationally intensive, especially when the bond holder and issuer have different fiscal years. The purpose of the program presented in this article is to provide an easy method for evaluating the materiality impact using alternative methods of allocating bond discount or premium over the life of the bond. |

