Question

please show excel calculations!You should turn in your answers in ONE Excel document. Use financial formulas in Excel to show work for Requirement #1 and #5

0 0
Add a comment Improve this question Transcribed image text
Answer #1

D 1 2 A Bill Corporation Bond Discount Amortization Table-Effective Interest Method 3 Date Interest Payment @ 3% Interest Exp

D AB Bill Corporation 2 Bond Discount Amortization Table-Effective Interest Method 3 Date Interest Payment @ 3% Interest Expe

The Bonds will mature on 31 Dec 2023 but the question 2(C) mentioned maturity date of Dec 31 2024

if the question is wrong then the entry mentioned in image on 31 Dec 2023 is correct

if the question is correct then there will be no entry on Dec 31 2024

Add a comment
Know the answer?
Add Answer to:
please show excel calculations! You should turn in your answers in ONE Excel document. Use financial...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You should turn in your answers in ONE Excel document. Use financial formulas in Excel to...

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

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

  • PART B Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,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...

  • Please do Part 1&2 and include the steps with the answers (it's going to be on...

    Please do Part 1&2 and include the steps with the answers (it's going to be on excel thats why i need the steps) Part 1 -- Bonds: 1. National Company issued 6% bonds, dated January 1, with a face amount of $700,000 on January 1, 2019. The bonds are of 8-year duration and mature on December 31, 2026. The market yield for bonds of similar risk and maturity was 4.5%. Interest is made semiannually on June 30 and December 31....

  • PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on...

    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 of your text), what factor would you use to calculate the...

  • Hatch Fly-fishing Company issued $600,000 face value bonds on January 1, 2019, with semiannual interest payments...

    Hatch Fly-fishing Company issued $600,000 face value bonds on January 1, 2019, with semiannual interest payments to be made on June 30 and December 31 at a contract rate of 8%. The bonds are scheduled to mature five years after they were issued. The market rate of interest at issuance was 10%. Required: Part 1 Calculate the issue price of the bonds on January 1, 2019. Use Excel formulas. Part 2 Prepare an Effective interest schedule showing the bond interest...

  • On January 1, 2019, Schooner Corp. issued bonds having the following characteristics: Face value: Issue price:...

    On January 1, 2019, Schooner Corp. issued bonds having the following characteristics: Face value: Issue price: Stated rate: Market rate: Maturity: $400,000.00 $372,431.15 8% per year 9% per year 11 years The bonds make semiannual interest payments on June 30 and December 31 Assume that the company uses the straight-line interest method. Part (a) Prepare the journal entry for interest on June 30, 2019 When computing amounts, use Excel formulas and cell references only. Do not manually input values.) Account...

  • Please show how you got your answers! NAME ACCT 1320 - Take Home HW - Bonds...

    Please show how you got your answers! NAME ACCT 1320 - Take Home HW - Bonds - PRINT AND COMPLETE!!! On January 1, 2020, Sponsler Corporation issued $5,000,000,7%, 20-year bonds. The bonds were sold to yield an effective interest rate of 5%. Interest is paid semiannually on June 30 and December 31. The company uses the effective interest method of amortization. Use the table below to prepare a bond discount amortization schedule which shows the amortization of discount for the...

  • Please use excel and show the function inputs Using the Excel PV function, determine the proceeds...

    Please use excel and show the function inputs Using the Excel PV function, determine the proceeds of the bond issuance assuming a 6 percent effective (market) annual interest rate. (This was step 2) On January 1, 2018, the Blue Devil Corporation issued $100,000 of ten-year bonds. The bonds carried a stated annual interest rate of 5 percent, with interest payable semiannually on June 30 and December 31.

  • PLEASE SHOW WORK AND EXPLAIN HOW EACH STEP IS DONE. THANK YOU 1. Computation of Effective...

    PLEASE SHOW WORK AND EXPLAIN HOW EACH STEP IS DONE. THANK YOU 1. Computation of Effective Interest Rate On June 30, 2019, Gaston Corporation sold $780,000 of 11% face value bonds for $742,122.18. On December 31, 2019, Gaston sold $390,000 of this same bond issue for $409,302.37. The bonds were dated January 1, 2019, pay interest semiannually on each December 31 and June 30, and are due December 31, 2026. Required: Compute the effective yield rate on each issuance of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT