What are the excel formulas and answers to Part A and Part B.    Part A: (Left Side)  KIMCHI CORPORATION's capital investment bonds have a maturity of 10 years with a face value of $1,000 and a semi-annual 10% coupon.  They are callable in 3 years at $1150 and currently sell for $1,290.  What is the nominal yield to maturity and the nominal yield to call?  What return should investors expect to earn on these bonds.   Part B: (Right Side)    KIMCHI CORPORATION also has bonds with 5 years left to maturity with an annual coupon of 10%.  What would be the yield to maturity at a current market price of $850?  What would be the yield to maturity if the current market price would be $1,125? What would be the price of the bond to you if your cost of capital was 12%? What would be the price of the bond to you if your cost of capital was 8%?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter6: Fixed-income Securities: Characteristics And Valuation
Section: Chapter Questions
Problem 16P
icon
Related questions
Question

What are the excel formulas and answers to Part A and Part B. 

 

Part A: (Left Side) 

KIMCHI CORPORATION's capital investment bonds have a maturity of 10 years with a face value of $1,000 and a semi-annual 10% coupon.  They are callable in 3 years at $1150 and currently sell for $1,290.  What is the nominal yield to maturity and the nominal yield to call?  What return should investors expect to earn on these bonds.

 

Part B: (Right Side) 

 

KIMCHI CORPORATION also has bonds with 5 years left to maturity with an annual coupon of 10%.  What would be the yield to maturity at a current market price of $850?  What would be the yield to maturity if the current market price would be $1,125? What would be the price of the bond to you if your cost of capital was 12%?

What would be the price of the bond to you if your cost of capital was 8%?

KIMCHI CORPORATION's capital investment bonds have a maturity of 10 years with a face
value of $1,000 and a semi-annual 10% coupon. They are callable in 3 years at $1150 and
currently sell for $1,290. What is the nominal yield to maturity and the nominal yield to
call? What return should investors expect to earn on these bonds.
KIMCHI CORPORATION also has bonds with 5 years left to maturity with an annual coupon of 10%.
What would be the yield to maturity at a current market price of $850? What would be the yield
to maturity if the current market price would be $1,125? What would be the price of the bond to
you if your cost of capital was 12%?
What would be the price of the bond to you if your cost of capital was 8%?
Points
Points
Possible
Earned
YTM
YTC
YTM at 850
YTM at 1,125
PV @ 12% PV@ 8%
Par value
Par value
Periods to maturity
Periods to maturity
Coupon rate
Coupon rate
Coupon payment
Selling price
Cost of capital
Coupon payment
Selling price
Cell for "2"
Yield
Yield
Annualized yield
10
10
Annualized yield
10
10
Transcribed Image Text:KIMCHI CORPORATION's capital investment bonds have a maturity of 10 years with a face value of $1,000 and a semi-annual 10% coupon. They are callable in 3 years at $1150 and currently sell for $1,290. What is the nominal yield to maturity and the nominal yield to call? What return should investors expect to earn on these bonds. KIMCHI CORPORATION also has bonds with 5 years left to maturity with an annual coupon of 10%. What would be the yield to maturity at a current market price of $850? What would be the yield to maturity if the current market price would be $1,125? What would be the price of the bond to you if your cost of capital was 12%? What would be the price of the bond to you if your cost of capital was 8%? Points Points Possible Earned YTM YTC YTM at 850 YTM at 1,125 PV @ 12% PV@ 8% Par value Par value Periods to maturity Periods to maturity Coupon rate Coupon rate Coupon payment Selling price Cost of capital Coupon payment Selling price Cell for "2" Yield Yield Annualized yield 10 10 Annualized yield 10 10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Bond Valuation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,