expand icon
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
Exercise 5
PROBLEM DATA
The University Club recently issued $1,500,000 of 10-year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually.
REQUIREMENT
You have been asked to calculate the issuance price of the bonds and prepare amortization schedules for any discount or premium. The worksheet BONDS has been provided to assist you. Note that the worksheet contains a scratch pad at the bottom that has been preprogrammed to automatically compute and display the relevant cash flows needed for bond pricing.
Explanation
Verified
like image
like image

Bond:
It is a debt instrument or a debt...

close menu
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
cross icon