NEED EXCEL FORMULAS FOR ANSWER NOT JUST FINAL NUMBER Question: ABC HAS A 20 YEAR BOND WITH 7% COU...

Question

Question

NEED EXCEL FORMULAS FOR ANSWER NOT JUST FINAL NUMBER

Question: ABC HAS A 20 YEAR BOND WITH 7% COUPON PAID ANNUALLY AND IS PRICED $944.00. IF ISSUANCE COSTS ARE 3%, WHAT IS COST OF BOND TO ABC?

business finance

Answer 1

Answer #1

This can be solved using financial calcultor or excel
Using financial calculator
N=20
PMT=7%*1000=70
PV=-944*(1-3%)=-915.68
FV=1000
CPT I/Y=7.85%

using excel
=RATE(20,70,-915.68,1000)
=7.85%

Answer 2

Similar Homework Help Questions

formula + answer please 1. The $1,000 face value ABC bond has a coupon rate of...

formula + answer please 1. The $1,000 face value ABC bond has a coupon rate of 6%, with interest paid semi-annually, and matures in 5 years. If the bond is priced to yield 8%, what is the bond's value today? (5 PTS) 2. The KLM bond has $80 yearly coupon (with interest paid quarterly), a maturity value of $1,000, and matures in 20 years. If the bond is priced to yield 6%, what is the maximum price a which you...
MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2) You are looking at a bond with...

MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2) You are looking at a bond with 13 years to maturity, has a coupon rate of 4% paid semi- annually, and a price of 105. What is the Yield to Maturity of the bond?
Excel Online Structured Activity: Bond valuation You are considering a 20-year, $1,000 par value bond. Its...

Excel Online Structured Activity: Bond valuation You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11% , and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" arinual interest rate (not a nominal rate) of 8.03 % , how much should you be willing to pay for the bond?...

ROESTTON 21 Myriam is considering purchasing a 20-year bond that is selling for $983. The bond...

ROESTTON 21 Myriam is considering purchasing a 20-year bond that is selling for $983. The bond can be called in 4 years at 103. What is the YTC for this bond if it has a 4 % coupon, paid semiannually? a. 5.18% b. 5.16% c. 4.99% d. 4.13% QUESTION 22 Assume that a bond has an 86 coupon, paid annually, is priced to have a YTM of 10%. What would happen to the YTM if the price and the other...
18. The $1,000 face value ABC bond has a coupon rate of 6%, with interest paid...

18. The $1,000 face value ABC bond has a coupon rate of 6%, with interest paid annually, and matures in 3 years. If the bond is priced to yield 4%, what is the bond's value today? A. $984.54 B. $989.64 C. $997.27 D. $1,055.50
What is the effective duration for a 7-year USD bond issued by ABC, a coupon of...

What is the effective duration for a 7-year USD bond issued by ABC, a coupon of 3% (semiannual) priced @ 1.90%. Shock annual yields +/- 1%? Use par value of $100

A bond has just been issued. The bond is currently selling for $900. The bond will...

A bond has just been issued. The bond is currently selling for $900. The bond will mature in 14 years. The bond’s annual coupon rate is 7% and the face value of the bond is $1,000. Coupons will be paid annually. Excel Compute the bond’s yield to maturity.
A bond has just been issued. The bond is currently selling for $1050. The bond will...

A bond has just been issued. The bond is currently selling for $1050. The bond will mature in 7 years. The bond’s annual coupon rate is 16% and the face value of the bond is $1,000. Coupons will be paid semi-annually. Excel Compute the bond’s annual yield to maturity.
Excel Online Structured Activity: Bond valuation You are considering a 25-year, $1,000 par value bond. Its...

Excel Online Structured Activity: Bond valuation You are considering a 25-year, $1,000 par value bond. Its coupon rate is 10%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.01%, how much should you be willing to pay for the bond? Do not round...

Question 1 A bond has 23 year to maturity and a coupon rate of 7%. Coupons...

Question 1 A bond has 23 year to maturity and a coupon rate of 7%. Coupons are paid semi-annually. If the YTM of the bond is 10%, what is the price of the bond today? Round your answer to dollars and cents, for example 100.12. Flag this Question Question 2 Today you purchase a 9-year bond at a YTM of 11%. The bond pays coupons annually and has a coupon rate of 9%. What is your 1-year rate of return...