Bonds - Monthly Interest Payments
This assignment will give you the opportunity to practice computing the price of a bond using the present value (PV) function in Excel. In addition, you will practice preparing an amortization table for the bond, including premium or discount bonds. Finally, you will practice preparing the journal entry for the issuance of a bond, as well as the journal entry for the periodic interest payment on a bond.
Relevant Excel Functions
This assignment will require you to be able to use some or all of the following Excel functions. Click on the hyperlinked section number next to the relevant Excel skill to be directed to a page showing how to perform the assigned task in Excel:
Want to try our built-in assessments?
Use the Request Full Access button to gain access to this assessment.