In this assignment you will be working with bonds. You will compute bond issue price, then make an amortization table. You will then do a few select journal entries using your amortization table. Here is the data: Bond issue principal amount: 500,000 Semi-annual interest payments at the end of every six months Term = 5 years Stated rate = 6% Interest payment = ? Scenarios: 1. Market rate = 4% 2. Market rate = 6% 3. Market rate = 8% Requirements: For each of the three scenarios, complete a separate tab in Excel. Include the data for your problem in each sheet. Compute the interest payment. It is the same amount in each scenario. Then: 1. Compute bond issue price 2. Create an amortization table using the effective interest method for all 10 payment periods. 3. Below your amortization table show journal entries for: a. Bond Issue b. First two payments (periods 1 and 2) c. Payment at the end of the 6th period. d. Settlement of the bond after last payment. Note: do not include the final payment journal entry; only include the entry for the settlement of bond. 4. Below your journal entries, create an amortization table using the same bond issue price as above. Use the straight-line method of amortization for this second table.