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.
-
find the critical value associated with a right sided hypothesis of
the mean using a sample...
asked 54 minutes ago -
Which of the following statements is true with respect to a
simple linear regression model?
a....
asked 1 hour ago -
The energy required to remove an electron from a surface of a
solid element is called...
asked 3 hours ago -
How would you train your employees to avoid risks of using
mobile devices?
asked 3 hours ago -
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 4 hours ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 5 hours ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 5 hours ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 7 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 7 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 8 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 9 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 9 hours ago