How can I calculate interest payment and issue price in Excel? Bond Discount Problem:On January 1,...
How can I calculate interest payment and issue price in Excel?
Bond Discount Problem:On January 1, 2017, Waterfall Lodge & Amusement Park issued $6,000,000 of 6% bonds, due in 10 years. The market interest rate for bonds of similar risk and maturity is 7%. Interest is paid semiannually on June 30 and December 31 each year.
| W18 | ||
| Face amount | $ 6,000,000.00 | |
| Interest payment | ||
| Market interest rate per period | 3.5% | |
| Number of periods | 20 | |
| Issue price | ||
Homework Answers
Add Answer to:
How can I calculate interest payment and issue price in
Excel?
Bond Discount Problem:On January 1,...
Face amount Interest payment Blue cells can be typed in, yellow cells...
Face amount
Interest payment
Blue cells can be typed in, yellow cells must
be formulas or functions.
Market interest rate per
period
Number of periods
Issue price
All cells in the table should be formulas or
functions
Date
Cash
Paid
for Interest
Interest Expense
Increase in Carrying Value
Carrying
Value
(End of Period)
1/1/17
-------
-------
-------
6/30/17
(18 more logs below)
Problem Data:
Bond Discount Problem: On January 1, 2017,
Waterfall...
Computing Bond Issue Price and Preparing an Amortization Table in Excel On January 1, 2017, Springfield...
Computing Bond Issue Price and Preparing an Amortization Table in Excel On January 1, 2017, Springfield Inc. issues $400,000 of 8% bonds that pay interest semiannually and mature in 10 years (December 31, 2026). a. Using the Excel PRICE function, compute the issue price assuming that the bonds’ market rate is 7% per year compounded semiannually. (Use 100 for the redemption value to get a price as a percentage of the face amount, and use 1 for the basis.) b....
Computing Bond Issue Price and Preparing an Amortization Table in Excel On January 1, 2017, Springfield...
Computing Bond Issue Price and Preparing an Amortization Table in Excel On January 1, 2017, Springfield Inc. issues $400,000 of 8% bonds that pay interest semiannually and mature in 10 years (December 31, 2026). a. Using the Excel PRICE function, compute the issue price assuming that the bonds’ market rate is 7% per year compounded semiannually. (Use 100 for the redemption value to get a price as a percentage of the face amount, and use 1 for the basis.) b....
Brief Exercise 9-18 Calculate the issue price of bonds (LO9-7) Ultimate Butter Popcorn issues 5%, 15-year...
Brief Exercise 9-18 Calculate the issue price of bonds (LO9-7) Ultimate Butter Popcorn issues 5%, 15-year bonds with a face amount of $43,000. The market interest rate for bonds of similar risk and maturity is 5%. Interest is paid semiannually. At what price will the bonds issue? (FV of $1. PV of $1. FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round Market interest rate" to 1 decimal...
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...
3-a. If the market rate is 8%, calculate the issue price. (FV of $1, PV of...
3-a. If the market rate is 8%, calculate the issue price. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round Market interest rate" to 1 decimal place. Enter your answers in dollars not in millions.) Bond Characteristics Amount 25,700,000 Face amount $ Interest payment Market interest rate Periods to maturity Issue price On January 1, 2018, Water World issues $25.7 million of...
Balance sheet Financing Options OPTION1 The company could issue $2,500,000 of long-term bonds, due in 8...
Balance sheet
Financing Options OPTION1 The company could issue $2,500,000 of long-term bonds, due in 8 years with a stated rate of interest, paid semiannually, of 4%. The market rate for similar debt is 6%. The bond issues for 85. OPTION 2 The company could issue $2,000,000 of long-term bonds, due in 7 years with a stated rate of interest, paid semiannually, of 6%. The market rate for similar debt is 4%. The bond issues for 110. OPTION 3 The...
[The following information applies to the questions displayed below.] On January 1, 2021, Frontier World issues...
[The following information applies to the questions displayed
below.] On January 1, 2021, Frontier World issues $40.1 million of
9% bonds, due in 20 years, with interest payable semiannually on
June 30 and December 31 each year. The proceeds will be used to
build a new ride that combines a roller coaster, a water ride, a
dark tunnel, and the great smell of outdoor barbeque, all in one
ride.
1-8. If the market rate is 8%, calculate the issue price....
Ultimate Butter Popcorn issues 5%, 15-year bonds with a face amount of $40,000. The market interest...
Ultimate Butter Popcorn issues 5%, 15-year bonds with a face amount of $40,000. The market interest rate for bonds of similar risk and maturity is 5%. Interest is paid semiannually. At what price will the bonds issue? (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round"Market interest rate" to 1 decimal place.) Bond Characteristics Face amount Amount | $ 40,000 $ 2,000...
Legacy issues $710,000 of 8.0%, four year bonds dated January 1, 2017, that pay interest semiannually...
Legacy issues $710,000 of 8.0%, four year bonds dated January 1, 2017, that pay interest semiannually on June 30 and December 31. They are issued at $621,812 and their market rate is 12% at the issue date. 2. Determine the total bond interest expense to be recognized over the bonds' life. Total bond interest expense over life of bonds: Amount repaid payments of Par value at maturity Total repaid Less amount borrowed Total bond interest expense Legacy issues $710,000 of...
Face amount
Interest payment
Blue cells can be typed in, yellow cells must
be formulas or functions.
Market interest rate per
period
Number of periods
Issue price
All cells in the table should be formulas or
functions
Date
Cash
Paid
for Interest
Interest Expense
Increase in Carrying Value
Carrying
Value
(End of Period)
1/1/17
-------
-------
-------
6/30/17
(18 more logs below)
Problem Data:
Bond Discount Problem: On January 1, 2017,
Waterfall...
Brief Exercise 9-18 Calculate the issue price of bonds (LO9-7) Ultimate Butter Popcorn issues 5%, 15-year bonds with a face amount of $43,000. The market interest rate for bonds of similar risk and maturity is 5%. Interest is paid semiannually. At what price will the bonds issue? (FV of $1. PV of $1. FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round Market interest rate" to 1 decimal...
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...
3-a. If the market rate is 8%, calculate the issue price. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round Market interest rate" to 1 decimal place. Enter your answers in dollars not in millions.) Bond Characteristics Amount 25,700,000 Face amount $ Interest payment Market interest rate Periods to maturity Issue price On January 1, 2018, Water World issues $25.7 million of...
Balance sheet
Financing Options OPTION1 The company could issue $2,500,000 of long-term bonds, due in 8 years with a stated rate of interest, paid semiannually, of 4%. The market rate for similar debt is 6%. The bond issues for 85. OPTION 2 The company could issue $2,000,000 of long-term bonds, due in 7 years with a stated rate of interest, paid semiannually, of 6%. The market rate for similar debt is 4%. The bond issues for 110. OPTION 3 The...
[The following information applies to the questions displayed
below.] On January 1, 2021, Frontier World issues $40.1 million of
9% bonds, due in 20 years, with interest payable semiannually on
June 30 and December 31 each year. The proceeds will be used to
build a new ride that combines a roller coaster, a water ride, a
dark tunnel, and the great smell of outdoor barbeque, all in one
ride.
1-8. If the market rate is 8%, calculate the issue price....
Ultimate Butter Popcorn issues 5%, 15-year bonds with a face amount of $40,000. The market interest rate for bonds of similar risk and maturity is 5%. Interest is paid semiannually. At what price will the bonds issue? (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round interest rate factors. Round"Market interest rate" to 1 decimal place.) Bond Characteristics Face amount Amount | $ 40,000 $ 2,000...
Legacy issues $710,000 of 8.0%, four year bonds dated January 1, 2017, that pay interest semiannually on June 30 and December 31. They are issued at $621,812 and their market rate is 12% at the issue date. 2. Determine the total bond interest expense to be recognized over the bonds' life. Total bond interest expense over life of bonds: Amount repaid payments of Par value at maturity Total repaid Less amount borrowed Total bond interest expense Legacy issues $710,000 of...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago