Author: Joyce Buda


In this final week, we have one problem using the effective interest rate method.
In order to use this, we need to calculate time value of money. There are three ways
to go about this:
1.  Use a table that is an appendix in most accounting books and is easily found by
     conducting an Internet search for "amortization tables."
2.  Use a mathematical formula.
3.  Use an Excel present value formula.
Let's assume we want the present value of $5,000, which we will receive six months from now,
assuming an 8% interest rate. We know that the present value will be less than $5,000.
Using a table:
You can find a "present value of a lump sum" table by going to principlesofaccounting.com
and clicking "supplements" at the bottom-left of the screen. "Time value of money"
will be one of the supplements listed.
You will use the table called "present value of $1." Because we are interested in a payment
six months from now, we will have to divide the interest rate by 2 to represent a half-year.
 District Water Company issued 10-year bonds with a face value of $100,000 and a stated interest rate of 8.0%. 
 The bonds are dated April 1, 2016, and call for semiannual interest payments on each April 1 and October 1. 
 Due to market fluctuations, the bonds actually sold to yield 10.0% per year. 
 1.  Compute the amount received for the bonds. 
 2.  Compute the first interest and amortization amounts for the October 1, 2016, payment. 
 3.  Prepare journal entries for the issuance of the bonds and for the first interest payment. 
 4.  Compute the second interest and amortization amounts for the April 1, 2017, payment. 
 Present value of principal (principal × table factor for 10%, 10 years) 
 100,000 × .38554 = 
 Present value of 20 semiannual interest payments: 
 Use half the interest rate and twice the number of years in the table. 
 Use the present value of an ordinary annuity table here. 
 Use actual interest dollar amount × factor from table for 5% and 20 years. 
 4,000 × 12.46221 = 
 Bond value 
 Excel formula: 
 Here, we use the additional arguments in the formula. 
 It is =PV(rate, periods, payment, future value) 
 Our formula is =PV(.1,10,,100,000) 
 Notice that we have two commas together. That tells Excel that there is no periodic 
 payment, but only a future value lump sum. 
 Value of annuity formula is =PV(.05,20,4000). 
 Bond value 
 Journal entry: 
 Discount on bonds payable 
     Long-term bonds payable 
 Interest payment 1: 
 Carrying value of 88,403 × yield for half-year 
88,403 × .10 ¸ 2
 Actual cash payment  
 Amortization of discount 

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.