Danat Business Management Consulting Company is a very well-known consulting company. The board of directors considered financing
Question:
Danat Business Management Consulting Company is a very well-known consulting company. The board of directors considered financing an expansion and borrows $600,000 from investors by issuing bonds, which involves a 4 years dept. period with annual payments, with initial bond stated rate of 7%, and a market interest rate of 7.5%.
You were hired as an expert in the field and the manager asked you for financial modeling and preparing a bonds amortization schedule
Instructions:
1. Create a bonds analysis worksheet using Excel with your name and ID number.
2. Save the worksheet as: Bonds Amortization schedule followed by your name and ID.
3. Identify the bonds face value.
4. Identify the stated and market interest rate.
5. Calculate annual interest payment
6. Use Excel's functions feature to calculate bonds proceeds (present value).
7. Calculate the bond discount or premium.
8. Create a bond amortization schedule to summarize interest payments, interest expense, bonds amortization, and remaining carrying value.
Auditing and Assurance services an integrated approach
ISBN: 978-0134065823
16th edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan