Reference no: EM133174382

Question - 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

Required -

1. Create bonds analysis worksheet using Excel with your name and ID number.

2. Calculate annual interest payment.

3. Use Excel's functions feature to calculate bonds proceeds (present value) (Do not forget the minus sign in front of PV to make the proceeds positive.)

4. Calculate the bond discount or premium.

5. Create a bond amortization schedule to summarize interest payments, interest expense, bonds amortization, and remaining carrying value.

6. Prepare the Journal entry on the date of issuance the bonds.