80.2K

Verified Solution

Link Copied!

NSTRUCTIONS: Haiku Inc. issued $$600,000$ of $10-$year bonds vith a stated rate of $11\%$ when the market rate was $12\%.$ The sonds pay interest semi$-$annually. Assume that the bonds were ssued for $$565,710.$ Prepare an amortization table for the first hree payments.

$\backslash$table$[[\backslash$table$[[$Semiannual$],[$Interest$],[$Period$]],\backslash$table$[[$Semiannual$],[$Interest Expense$]],\backslash$table$[[$Semiannual$],[$Interest$],[$Payment$]],\backslash$table$[[$Amortization of$],[$Discount$]],$Enc$],[1,,,,],[2,,,,],[3,,,,]]$

'LEASE NOTE: All dollar amounts will be rounded to whole dollars vith $"$$$"$ and commas as needed $($i$.$e$.$ $$12,345).$

HINT $-$ You definitely will want to use this EXCEL spreadsheet $-$hapter $13HW-02$ #$1$ #$2$ Worksheets.xlsx darr to assist in your :alculations. In order to use the worksheet, you will also need to :alculate the Market Price of Bonds $(\%$ of Face$).]$INSTRUCTIONS: Haiku Inc. issued $$600,000$ of $10-$year bonds with a stated rate of $11\%$ when the market rate was $12\%.$ The bonds pay interest semi$-$annually. Assume that the bonds were issued for $$565,710.$ Prepare an amortization table for the first three payments.

Semiannual Interest Period Semiannual Interest Expense Semiannual Interest Payment Amortization of Discount Ending Carrying Value

$1$

$2$

$3$

PLEASE NOTE: All dollar amounts will be rounded to whole dollars with $"$$$"$ and commas as needed $($i$.$e$.$ $$12,345).$

$[$HINT $-$ You definitely will want to use this EXCEL spreadsheet Chapter$13$ HW$-02$ #$1$ #$2$ Worksheets.xlsx Download Chapter$13$ HW$-02$ #$1$ #$2$ Worksheets.xlsx to assist in your calculations. In order to use the worksheet, you will also need to calculate the Market Price of Bonds $(\%$ of Face$).]$

Answer & Explanation Solved by verified expert

See Answer