Q1 - Danat Business Management Consulting Company is a very well-known consulting company. The board of directors considered financing an expansion and borrows $400,000 from investors by issuing bonds, which involves a 4 years dept period with annual payments, with initial bond stated rate of 8%, and a market interest rate of 8.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 Excels functions feature to calculate bonds proceeds (present value) (Do not forget the minus sign in front of PV to make the proceeds positive.)

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.

Q2 - Prepare the Journal entry on the date of issuance the bonds.