BG13 A B C 1 Name: netfix G H 1 BD BG BH BI Your score...

Transcribed Image Text:

BG13 A B C 1 Name: netfix G H 1 BD BG BH BI Your score this tab 0% The netflix Company issues 11%, 4-year bonds with a par value of $530,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 12% Enter a valid Excel formula or function in each of the yellow cells below Formulas must refer to cels addresses. Entering 4 5 a value will be marked as incorrect 7 8 Par Value 9 Term (years) 10 Annual market% 11 12 13 14 15 Annual contract % Payments per year What is the amount of each semiannual interest payment? $530,000 12% 11% 16 17 18 19 20 Complete the amortization schedule for these bonds. Semiannual Cash Interest Interest Period Paid 21 22 23 1 **RARE 24 2 25 26 04567 3 8 Bond Interest Expense Instructions Bond 1 Bond 2 Avaly Accessibility Investigate Discount Amortization Unamortized Discount Carrying Value 3 BG13 A 1 Name netflix 2 Jx C G BC BD BE N BC B Your score this tab 0% The netflix Company issues 11%, 4-year bonds with a par value of $530,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 12%. Enter a valid Excel formula or function in each of the yellow cells below Formulas must refer to cells addresses Entering a value will be marked as incorrect Par Value Term (years) 10 Annual market% 11 Annual contract% $530,000 12% 11% 12 Payments per year 13 14 15 What is the amount of each semiannual interest payment? 16 17 18 19 20 Complete the amortization schedule for these bonds Semiannual Cash Interest Interest Period Paid Bond Interest Expense Discount Amortization Unamortized Discount Carrying Value 21 27 0 23 1 24 2 25 3 26 4 27 5 28 6 7 30 B 32 33 Totals $0.00 50.00 $0.00 34 25 BG13 A B C 1 Name: netfix G H 1 BD BG BH BI Your score this tab 0% The netflix Company issues 11%, 4-year bonds with a par value of $530,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 12% Enter a valid Excel formula or function in each of the yellow cells below Formulas must refer to cels addresses. Entering 4 5 a value will be marked as incorrect 7 8 Par Value 9 Term (years) 10 Annual market% 11 12 13 14 15 Annual contract % Payments per year What is the amount of each semiannual interest payment? $530,000 12% 11% 16 17 18 19 20 Complete the amortization schedule for these bonds. Semiannual Cash Interest Interest Period Paid 21 22 23 1 **RARE 24 2 25 26 04567 3 8 Bond Interest Expense Instructions Bond 1 Bond 2 Avaly Accessibility Investigate Discount Amortization Unamortized Discount Carrying Value 3 BG13 A 1 Name netflix 2 Jx C G BC BD BE N BC B Your score this tab 0% The netflix Company issues 11%, 4-year bonds with a par value of $530,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 12%. Enter a valid Excel formula or function in each of the yellow cells below Formulas must refer to cells addresses Entering a value will be marked as incorrect Par Value Term (years) 10 Annual market% 11 Annual contract% $530,000 12% 11% 12 Payments per year 13 14 15 What is the amount of each semiannual interest payment? 16 17 18 19 20 Complete the amortization schedule for these bonds Semiannual Cash Interest Interest Period Paid Bond Interest Expense Discount Amortization Unamortized Discount Carrying Value 21 27 0 23 1 24 2 25 3 26 4 27 5 28 6 7 30 B 32 33 Totals $0.00 50.00 $0.00 34 25