Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The book value of the debt issue is $85 million. In addition, the company has a second debt issue on the market, a zero coupon bond with 12 years left to maturity, the book value of this issue is $35 million, and the bonds sell for 59 percent of par. What is the company's total book value of debt? The total market value? What is your best estimate of the aftertax cost of debt? The company's tax rate is 22 percent. First bond issue: Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Book value of debt issue Second bond issue: Settlement date Maturity date Annual coupon rate Coupons per year Bond price (% of par) Redemption value (% of par) Book value debt issue Tax rate IA S 01/01/00 01/01/27 7% 93 100 2 85,000,000 01/01/00 01/01/12 0% 2 59 100 35,000,000 22% Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the YIELD function. You must use the built-in Excel function to answer this question. Book value of debt $ Market value of first bond Market value of second bond Market value of debt Market value weight of first bond Market value weight of second bond Pretax cost of first issue Aftertax cost of first issue Pretax cost of second issue Aftertax cost of second issue Aftertax cost of debt $ 120,000,000 79,050,000 Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The book value of the debt issue is $85 million. In addition, the company has a second debt issue on the market, a zero coupon bond with 12 years left to maturity, the book value of this issue is $35 million, and the bonds sell for 59 percent of par. What is the company's total book value of debt? The total market value? What is your best estimate of the aftertax cost of debt? The company's tax rate is 22 percent. First bond issue: Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Book value of debt issue Second bond issue: Settlement date Maturity date Annual coupon rate Coupons per year Bond price (% of par) Redemption value (% of par) Book value debt issue Tax rate IA S 01/01/00 01/01/27 7% 93 100 2 85,000,000 01/01/00 01/01/12 0% 2 59 100 35,000,000 22% Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the YIELD function. You must use the built-in Excel function to answer this question. Book value of debt $ Market value of first bond Market value of second bond Market value of debt Market value weight of first bond Market value weight of second bond Pretax cost of first issue Aftertax cost of first issue Pretax cost of second issue Aftertax cost of second issue Aftertax cost of debt $ 120,000,000 79,050,000
Expert Answer:
Answer rating: 100% (QA)
To calculate the required values well use the given information and formulas Lets calculate each value step by step 1 Book value of ... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1260153590
12th edition
Authors: Stephen M. Ross, Randolph W Westerfield, Robert R. Dockson, Bradford D Jordan
Posted Date:
Students also viewed these corporate finance questions
-
2 cables, AD and CD, help support the pole BD. The tension in the cable AD and CD are 120 kN and 80 kN respectively. (a) Find the magnitude and the direction of the resultant force acting at D by...
-
Your company has just sent you to another intensive seminar on business law. the ceo asks you: now that you have attended this session, what have you learned? what measures can the company take to...
-
Jiminys Cricket Farm issued a bond with 30 years to maturity and a semiannual coupon rate of 5 percent 6 years ago. The bond currently sells for 106 percent of its face value. The companys tax rate...
-
Three balls A, B, and C, with masses of 3 kg, 1 kg, and 1 kg, respectively, are connected by massless rods. The balls are located as in Figure. What are the coordinates of the center ofmass? y. m 1...
-
P-Nitrobenzaldehyde is more reactive toward nucleophilic additions than p-methoxy-benzaldehyde. Explain
-
a. Propose a mechanism for the following reaction: b. To what class of terpene does the starting material belong? Mark off the isoprene units in the starting material. H. d H CH CH3 CH3 CH CH3 CH3...
-
Tri Tran, Van Tran, and Conrad Chu conceived and then founded Munchery in 2010. The idea was to hire a team of gourmet chefs that would cook a variety of unique meals and allow users to order the...
-
Larry Byrd, Inc., spent $68,000 in attorney fees while developing the trade name of its new product, the Mean Bean Machine. Prepare the journal entries to record the $68,000 expenditure and the first...
-
11. SO2Cl2 on reaction with excess of water results into acidic mixture SO2Cl2 + H2O H2SO4 + 2HC1 16 moles of NaOH is required for the complete neutralization of the resultant acidic mixture. The...
-
Bottle-Up, Inc., was organized on January 8, 2010, and made its S election on January 24, 2010. The necessary consents to the election were filed in a timely manner. Its address is 1234 Hill Street,...
-
A cuboid of length 12 cm and breath 9 cm has a total surface area of 426 cm2. i- Find the height of the cuboid. Find its volume. ii-
-
True Or False Common carriers and public utilities are held to a higher standard of care than the rest of the public for purposes of the tort of intentional infliction of emotional distress.
-
True Or False Under the doctrine of vicarious liability, the acts of a tortfeasor are imputed to another even though there is no special relationship between the tortfeasor and the individual held...
-
What are some of the ways a tortfeasor can commit trespass?
-
True Or False An assault is committed when a defendant intends to frighten but not to contact the plaintiff.
-
A(n) ____________ ____________ is considered their own boss and works at their own pace in their own way.
-
Given the V(E) ((e) Circuit below (i) I (s) V(s) R { R L find the laplace transform (ii) Vo(s) v(s)
-
A copper sphere of 10-mm diameter, initially at a prescribed elevated temperature T;, is quenched in a saturated (1 atm) water bath. Using the lumped capacitance method, estimate the time for the...
-
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Sales for the first quarter of the following year are projected at $180 million. Accounts receivable at the...
-
Bellwood Corp. is comparing two different capital structures. Plan I would result in 12,700 shares of stock and $109,250 in debt. Plan II would result in 9,800 shares of stock and $247,000 in debt....
-
Rackin Pinion Corporations assets are currently worth $1,065. In one year, they will be worth either $1,000 or $1,340. The risk-free interest rate is 3.9 percent. Suppose the company has an...
-
In Appendix 16A.1, we illustrate the calculation of a standard error for the marginal effect in a probit model of transportation, Example 16.4. In the appendix, the calculation is for the marginal...
-
In Examples 16.2 and 16.4, we presented the linear probability and probit model estimates using an example of transportation choice. The logit model for the same example is \(P(A U T...
-
In Example 16.3, we illustrate the calculation of the likelihood function for the probit model in a small example. a. Calculate the probability that \(y=1\) if \(x=1.5\), given the values of the...
Study smarter with the SolutionInn App