Homework Answers
Add Answer to:
On January 1, 2018, the Blue Devil Corporation issued $100,000 of ten-year bonds. The bonds carried...
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 how in excel with functions 3. Using the Excel PV function, determine the proceeds of...
Please how in excel with functions
3. Using the Excel PV function, determine the proceeds of the bond issuance assuming a 4 percent effective (market) annual interest rate. Use two present value tables to compute the price of the bonds. Show it on the Excel document 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.
On January 1, 2020, Fields Corporation issued ten-year bonds with a par value of $2,000,000. The...
On January 1, 2020, Fields Corporation issued ten-year bonds with a par value of $2,000,000. The bonds pay interest semiannually on June 30 and December 31 at an annual rate of 10%. The bonds were issued to yield 8% annually. Fields Corporation has a fiscal year that ends August 31 each year. Fields Corporation uses the effective-interest method to calculate its interest expense each period. Required: 1. Compute the issue price of the bonds and the journal entry at issuance....
Strathern Corporation issued ten-year term bonds dated January 1, 2017, with a face value of $800,000....
Strathern Corporation issued ten-year term bonds dated January 1, 2017, with a face value of $800,000. The face interest rate is 10 percent, and interest is payable annually December 31. The bonds were issued for $708,400 to yield an effective annual rate of 12 percent. Use the effective interest method of amortization. Round answers to the nearest dollar. a. Prepare entries in journal form without explanations to record the bond issue on January 1, 2017, and the payments of interest on January,...
McNeil Corporation issued $800,000 of 12%, 10-year bonds payable on January 1, 2019. The market interest...
McNeil Corporation issued $800,000 of 12%, 10-year bonds payable on January 1, 2019. The market interest rate at the date of issuance was 10%, and the bonds pay interest semiannually (on June 30 and December 31). McNeil Corporation's year-end is June 30. Read the requirements. 1. Using the PV function in Excel", calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ í Requirements 1. Using the...
February 4, 2019 1. On January 1, 2018, Piper Co. issued ten-year bonds with a face...
February 4, 2019 1. On January 1, 2018, Piper Co. issued ten-year bonds with a face value of $5,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. nstructions (a) Calculate the issue price of the bonds. Show all calculations. Also make the journal entry with an explanation. (b) Prepare the amortization table for 2018, Jan 1, June 30 and December 31. Assume that amortization is recorded...
Prescott Corporation issued ten thousand $1,000 bonds on January 1, 2021. The bonds have a 10-year...
Prescott Corporation issued ten thousand $1,000 bonds on January 1, 2021. The bonds have a 10-year term and pay interest semiannually. This is the partial bond amortization schedule for the bonds. Effective Decrease in Interest Balance Payment Cash Outstanding Balance 11,487,747 11,432,379 11,375,350 11,316,611 400,000 400,000 400,000 400,000 344,632 342,971 341,261 55,368 57,029 58,739 What is the stated annual rate of interest on the bonds? Multiple Choice o o
Brief Exercise 118 On January 1, 2018, Piper Co. issued ten-year bonds with a face value...
Brief Exercise 118 On January 1, 2018, Piper Co. issued ten-year bonds with a face value of $5,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. Table values are: 10 Pret of 10 Profor101 Pret of 20 per Pr o forper Pre of 10145 wo Calculate the issue price of the bonds. Without prejudice to your solution in part (a), assume that the issue price was...
On January 1, 2016, Gates Corporation issued $100,000 of 5-year bonds due December 31, 2020, for...
On January 1, 2016, Gates Corporation issued $100,000 of 5-year bonds due December 31, 2020, for $103,604.78 minus bond issue costs of $3,000. The bonds carry a stated rate of interest of 13% payable annually on December 31 and were issued to yield 12%. The company uses the effective interest method of amortization. Required: Prepare the journal entries to record the issuance of the bonds, all the interest payments, premium amortizations, bond issue cost amortizations, and the repayment of the...
On January 1, 2018, Bradley Recreational Products issued $100,000, 11%, four-year bonds. Interest is paid semiannually...
On January 1, 2018, Bradley Recreational Products issued $100,000, 11%, four-year bonds. Interest is paid semiannually on June 30 and December 31. The bonds were issued at $96,895 to yield an annual return of 12%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: 1. Prepare an amortization schedule that determines interest at the effective interest rate. 2. Prepare an amortization schedule by...
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 how in excel with functions
3. Using the Excel PV function, determine the proceeds of the bond issuance assuming a 4 percent effective (market) annual interest rate. Use two present value tables to compute the price of the bonds. Show it on the Excel document 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.
McNeil Corporation issued $800,000 of 12%, 10-year bonds payable on January 1, 2019. The market interest rate at the date of issuance was 10%, and the bonds pay interest semiannually (on June 30 and December 31). McNeil Corporation's year-end is June 30. Read the requirements. 1. Using the PV function in Excel", calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ í Requirements 1. Using the...
February 4, 2019 1. On January 1, 2018, Piper Co. issued ten-year bonds with a face value of $5,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. nstructions (a) Calculate the issue price of the bonds. Show all calculations. Also make the journal entry with an explanation. (b) Prepare the amortization table for 2018, Jan 1, June 30 and December 31. Assume that amortization is recorded...
Prescott Corporation issued ten thousand $1,000 bonds on January 1, 2021. The bonds have a 10-year term and pay interest semiannually. This is the partial bond amortization schedule for the bonds. Effective Decrease in Interest Balance Payment Cash Outstanding Balance 11,487,747 11,432,379 11,375,350 11,316,611 400,000 400,000 400,000 400,000 344,632 342,971 341,261 55,368 57,029 58,739 What is the stated annual rate of interest on the bonds? Multiple Choice o o
Brief Exercise 118 On January 1, 2018, Piper Co. issued ten-year bonds with a face value of $5,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. Table values are: 10 Pret of 10 Profor101 Pret of 20 per Pr o forper Pre of 10145 wo Calculate the issue price of the bonds. Without prejudice to your solution in part (a), assume that the issue price was...
Most questions answered within 3 hours.
-
Python Assignment: Write a program that uses stacks to solve
postfix equations.Read the below in a...
asked 3 minutes ago -
Q45 What do you understand by standardized tool of research? [1
Mark]
asked 6 minutes ago -
For the movie my big fat greek wedding
1. Locate and describe three instances of non-verbal...
asked 12 minutes ago -
When a bank makes its loans, if it screens its borrowers it will
collect repayment revenue...
asked 11 minutes ago -
A customer has requested that Lewelling Corporation fill a
special order for 2,400 units of product...
asked 34 minutes ago -
What are two strengths and two weaknesses of hardware,
software, and/or data?
How can the weaknesses...
asked 37 minutes ago -
A and B face the choice of working in a safe
mine at €200/wk or an...
asked 57 minutes ago -
True or false: couldnt figure out these few
- When charges are only located OUTSIDE an...
asked 1 hour ago -
Given the following function:
int fun1(int count){
int Num ;
for (i = 0; i <...
asked 1 hour ago -
Please submit your paper topic so that I can review it and make
any necessary suggestions...
asked 1 hour ago -
Why are there so many theories of addiction? (Consider the
adequacy of each theory in relation...
asked 1 hour ago -
22mL of 0.1020M Naoh is used in a titration against an unknown
1M acid (30mL). Determine...
asked 1 hour ago