# Problem Worksheet Combined Description
B-13.01 pdf pdf excel Basic accounting for long-term note payable
B-13.02 pdf pdf excel Future value concepts
B-13.03 pdf pdf excel Present value concepts
B-13.04 pdf pdf excel Calculating note payments and preparing entries
B-13.05 pdf pdf excel Terminology relating to bonds
B-13.06 pdf pdf excel Bonds at par
B-13.07 pdf pdf excel Bonds at a premium, straight-line amortization
B-13.08 pdf pdf excel Bonds at a discount, straight-line amortization
B-13.09 pdf pdf excel Bonds at a premium, effective-interest amortization
B-13.10 pdf pdf excel Bonds at a discount, effective-interest amortization
B-13.11 pdf pdf excel Bonds issued between interest dates
B-13.12 pdf pdf excel Basic bond retirement
B-13.13 pdf pdf excel Debt analysis
B-13.14 pdf pdf excel Commitments and leases



# Problem Worksheet Combined Description
I-13.01 pdf pdf excel Future value and present calculations
I-13.02 pdf pdf excel Entries and calculations for notes payable
I-13.03 pdf pdf excel Bonds issued at a premium; effective interest
I-13.04 pdf pdf excel Bonds issued at a discount; effective interest
I-13.05 pdf pdf excel Team-based approach to bond pricing
I-13.06 pdf pdf excel Bond pricing, effective-interest amortization, and retirement



  Problem Description
1 excel Self-Grading Problem



Description Problem                              
Present and Future Value excel                              
Calculating a Note Payment excel                              
Notes Payable Tables and Entries excel                              
Bonds Terminology excel                              
Bond Pricing excel                              
Entries for Bonds excel                              
Financial Statement Presentation of Bonds excel                              
Effective Interest Table excel                              
Effective Interest Entry with Premium excel                              
Effective Interest Entry with Discount excel                              
Bonds Between Interest Dates excel                              
Retirement of Bond Issue excel                              
Analysis and Commitments excel                              

The preceding table includes links to “Basic” and “Involved” problems. Each excel link will download the file containing a spreadsheet for the problem and a template worksheet on which you can prepare the solution electronically. If you see a light bulb icon on a worksheet, just mouse over above the icon and a comment box will appear. The comments include useful suggestions for improving your spreadsheet skills.

You may not post or redistribute, electronically or otherwise, any solution material. Violation of this policy constitutes a copyright violation.

Alternative problems, with solutions, may be found at our partner website Bookboon. Video solutions to selected problems are available to students enrolling in the online course. The pdf version of the solutions manual also includes links to the video solutions. You can purchase the solutions manual in the bookstore.