Question

Can you please show this in excel with formulas? And with showing where each # is derived from?

Ying Import has several bond issues outstanding, each making
semiannual interest payments. The bonds are listed in the table
below.

Bond | Coupon Rate | Price Quote | Maturity | Face Value | |||

1 | 8.90 | % | 105.4 | 3 | years | $ | 24,000,000 |

2 | 6.60 | 95.0 | 6 | years | 44,000,000 | ||

3 | 8.60 | 104.2 | 13.5 | years | 49,000,000 | ||

4 | 9.10 | 106.1 | 23 | years | 64,000,000 | ||

If the corporate tax rate is 35 percent, what is the aftertax cost
of the company’s debt? **(Do not round intermediate
calculations and enter your answer as a percent rounded to 2
decimal places, e.g., 32.16.)**

Aftertax cost of debt
%

Answer #1

Problem 12-22 Calculating the Cost of Debt [LO2]
Ying Import has several bond issues outstanding, each making
semiannual interest payments. The bonds are listed in the table
below.
Bond
Coupon Rate
Price Quote
Maturity
Face Value
1
8.60
%
106.1
6
years
$
20,000,000
2
6.60
94.3
9
years
38,000,000
3
8.30
104.9
16.5
years
43,000,000
4
8.80
94.7
26
years
58,000,000
If the corporate tax rate is 30 percent, what is the aftertax cost
of the company’s debt? (Do...

Ying Import has several bond issues outstanding, each making
semiannual interest payments. The bonds are listed in the table
below.
Bond
Coupon Rate
Price
Quote
Maturity
Face Value
1
8.70
%
106.2
7
years
$
21,000,000
2
6.70
94.2
10
years
37,000,000
3
8.40
105.0
17.5
years
42,000,000
4
8.90
94.8
27
years
57,000,000
If the corporate tax rate is 38 percent, what is the aftertax cost
of the company’s debt? (Do not round intermediate calculations and
enter your answer...

Ying Import has several bond issues outstanding, each making
semiannual interest payments. The bonds are listed in the following
table. If the corporate tax rate is 32 percent, what is the
aftertax cost of Ying's debt?
Bond
Coupon Rate
Price Quote
Maturity
Face Value
1
5.8%
107
7 years
$ 18,000,000
2
7.1
116
11 years
38,000,000
3
6.2
111
22 years
48,000,000
4
7.4
122...

Please show work/formulas and financial calculator steps, if
used. Answer as much as you can
(The following information applies to Problems 1-4)
The Collins Group, a leading producer of custom automobile
accessories, has hired you to estimate the firm's weighted average
cost of capital. The balance sheet and some other information are
provided below.
Assets
Current
assets
$ 38,000,000
Net plant, property, and
equipment
101,000,000
Total
assets
$139,000,000
Liabilities and Equity
Accounts
payable
$ 10,000,000
Accruals
9,000,000
Current
liabilities
$...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 17 minutes ago

asked 19 minutes ago

asked 29 minutes ago

asked 29 minutes ago

asked 29 minutes ago

asked 30 minutes ago

asked 35 minutes ago

asked 35 minutes ago

asked 39 minutes ago

asked 44 minutes ago

asked 44 minutes ago