Automating Partial Period Bond Valuation With Excels Day Counting Functions
An Excel model for calculating the actual price of bonds under a 30 day/month, 360 day/year day counting assumption by nesting the DAYS360 function within the PV function is developed. When programmed into an Excel spreadsheet, the model can accommodate annual and semiannual payment bonds sold on or between interest dates using six fundamental inputs, including the bond’s par value, maturity date, annual stated rate of interest, and payment frequency, the annual market rate of interest, and the settlement date. Thus, the model can be applied across the business curriculum in a variety of introductory and more advanced level courses.
Accounting for Bonds With Accrued Interest in Conformity With Brokers' Valuation Formulas
This article explains how to apply brokers' valuation methods to accounting for bonds when interest payments do not coincide with settlement or balance sheet dates. We show how to calculate a bond's present value on these dates using a simple approach that conforms with the method used by brokerage institutions to compute the bond's “actual price.” We then clarify how a broker subtracts accrued interest from this actual price to arrive at the quoted price, and how this quoted price relates to the bond's carrying amount and “fair value” (per SFAS Nos. 107, 115 and 124). We also precisely compute the change in a bond's carrying amount over fractional periods after settlement and around balance sheet dates. Finally, we demonstrate how to integrate these refinements into intermediate textbook illustrations. Throughout, we provide instructions for computing bond valuations using spreadsheet application functions.
A theoretical deficiency in accounting for bonds
Abstract Accounting for bonds payable issued at a premium or discount between interest payment dates poses some interesting theoretical problems. Nine Intermediate Accounting textbooks were examined, and only two were found to deal with the topic, neither at a theoretical level. When the theoretical value is calculated for a bond issued at a discount or premium between interest payment dates, the computed value includes the accrued interest. The usual approach is to record the collection of accrued interest separately from the bond proceeds. Unless the bond is recorded correctly the premium or discount does not amortize properly. This paper examines the recording of the accrued interest, and offers some suggestions for teaching this topic in courses beyond the introductory level.