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%?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education