Requirement 1:
Present value of the coupon payments | $168,494 |
[$40,000 x 4.21236 present value annuity factor (6%, 5 years) | |
Present value of the face value | $373,630 |
[$500,000 x 0.74726 present value factor (6%, 5 years) | |
Proceeds of the bonds | $542,124 |
*Coupon payments = $500,000 x 8% = $40,000
Requirement 2:
Factor used for face value: Present value factor at 6% for 5 years is 0.74726
Requirement 3:
Present value annuity factor used for coupon payments: Present value annuity factor at 6% for 5 years is 4.21236
Requirement 4:
Issue price is more than the face value. So that bonds issued at premium.
Requirement 5:
Bonds Amortization Table
Year | Cash paid | Interest expense | Discount amortized | Carrying value |
1/1/2019 | $542,124 | |||
12/31/2019 | $40,000 | $32,527 | $7,473 | $534,652 |
12/31/2020 | $40,000 | $32,079 | $7,921 | $526,731 |
12/31/2021 | $40,000 | $31,604 | $8,396 | $518,335 |
12/31/2022 | $40,000 | $31,100 | $8,900 | $509,435 |
12/31/2023 | $40,000 | $30,565 | $9,435 | $500,000 |
PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on...
PART B Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10.0%. Bill uses the effective interest rate method. Required: 1. Determine the proceeds of the bond sale on 1/1/19. Explain your method of calculation. 2. Using the present value of a dollar table (found in Appendix E of your text), what factor...
You should turn in your answers in ONE Excel document. Use financial formulas in Excel to show work for Requirement #1 and #5 of each part. An assignment submitted that doesn’t demonstrate your formulas within Excel will receive an unsatisfactory grade. PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on January 1, 2019. Interest is paid annually on December 31. The market rate of interest on this date was 6%. Sparty uses the...
Use financial formulas in Excel to show work for Requirement #1 and #5 of each part Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10.0%. Bill uses the effective interest rate method. Required: Determine the proceeds of the bond sale on 1/1/19. Explain your method of calculation. Using the present value of...
Using Excel, determine the proceeds of the bond sale on 1/1/19. PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on January 1, 2019. Interest is paid annually on December 31. The market rate of interest on this date was 6%. Sparty uses the effective interest rate method. Required: 1. Using Excel, determine the proceeds of the bond sale on 1/1/19. 2. Using the present value of a dollar table (found in Appendix E...
On January 1, 2020 Wildhorse Co. issued five-year bonds with a face value of $760,000 and a stated interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% 0.62092 Present value of 1 for 5 periods at 12% 0.56743 Present value of 1 for 10 periods at 5% 0.61391 Present value of 1 for 10 periods at...
A PROBLEM D: On January 1, 2020 Lance Co. issued five-year bonds with a face value of $1,000,000 and a stated interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% 62092 Present value of 1 for 5 periods at 12% 56743 Present value of 1 for 10 periods at 5% . 61391 Present value of 1...
QUESTION 35 On January 1, 2020 Mercy Grace Hospital issued five-year bonds with a face value of $800,000 and a stated interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% 62092 Present value of 1 for 5 periods at 12% 56743 Present value of 1 for 10 periods at 5% 61391 Present value of 1 for...
Ex. 2-Calculate market price of a bond. On January 1, 2014 Lance Co. issued five-vear bonds with a face value of $700.000 and a stated Interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% .62092 Present value of 1 for 5 periods at 12% .56743 Present value of 1 for 10 periods at 5% .61391 Present...
Problem D PROBLEM D: On January 1, 2020 Lance Co. issued five-year bonds with a face value of $1,000,000 and a stated interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% Present value of 1 for 5 periods at 12% Present value of 1 for 10 periods at 5% Present value of 1 for 10 periods...
A $5 million bond was issued at face value on June 1, 2017. The bond has a twenty five year term and a fixed interest rate of 4% paid annually. At the time of issuance, the current market rate of interest is also 4%. Using the present value tables, demonstrate why the bond was issued at face value ($5 million) by calculating the present value of both the principal and interest using Table P and Table 1. Record your response...