Question

PLEASE SHOW EXCEL FORMULAS

6. A bond has just been issued. The bond will mature in 7 years. The bond’s annual coupon rate is 8% and the face value of the bond is $1,000. The bond’s (annual) yield to maturity is 5%.

a.Compute the bond’s duration if coupons are paid semi-annually:

i. Using the VBA dduration function.

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Bond valuation model

Related Finance Q&A

Find answers to questions asked by students like you.

Q: A company borrowed $17,000 paying interest at 3% compounded semi-annually. If the loan is repaid by ...

A: The loan of $ 17000 would be amortize semi-annually by payment of $ 1900 installment at 3 % rate of ...

Q: Finance Question

A: Compound interest formula: A = P[(1+r/n)^nt] Where A is the future amount P is the principal r is th...

Q: Assume that you just inherited an annuity that Will pay you 10,000 per year, with the first payment ...

A: Present value of perpetuity = Annuity amount /rate of return  60,000 = 10,000 / rate of return  Rate...

Q: ABC Inc., isexpected to pay an annual dividend of $5.1 per share next year. The requiredreturn is 19...

A: Present value of the cash flows from the stock at the required return is value of the stock. Here, t...

Q: Ahmad earned $475 last summer. He deposited this money in an account that pays an interest rate of 3...

A: Future value = Present value * (1+rate)^n Where, n = no. of compounding period i.e. 15    

Q: Stocks A and B have the following historical returns: Year Stock A return Stock B return ...

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for you...

Q: 7. Calculating finance charges using the discount method and APRon a single-payment loan You a...

A: financial charge =p×r×tloan disbursed = principal - financial charge APR=FINANCE CHARGEPRINCIPALN

Q: A $7500 loan at 9% compounded monthly requires three payments at five month intervals after the date...

A: The loan is the borrowed money that has to return at the specified period with the given rate of int...

Q: OLA#10.4 A company is evaluating the feasibility of investing in machinery to manufacture an automot...

A: Net present value = present value of future cashflow discounted at 7% Cashflow of year 1-7 =(8900 co...

Q: how to get numbers underlined in red?

A: CCA=Capital Cost Allowance UCC= Undepreciated Capital Cost CCAt=UCC×dThe incremental UCC is calculat...

Q: A couple who borrow $70,000 for 15 years at 8.4%, compounded monthly, must make monthly payments of ...

A: formula for remaining balance: remaining balance=princial×1+rmn-pmt×1+rmn-1rm where, r = rate of int...

Q: Alexis and Will are purchasing a home. They wish to save money for 10 years and purchase a house tha...

A: formula to find future value of annuity: fva=A×1+rmm×n-1rmwhere,A= annuityr = rate of interestm = fr...

Q: How to solve this problem? The year-end operating and maintenance costs of a certain machine are est...

A: Equivalent Annual Cost (EAC) : It is a capital budgeting method, it is used where only annual cost o...

Q: ABC Pvt. Ltd. is considering two mutually exclusive capital investments. The project’s expected net ...

A: Click to see the answer

Q: Discuss the Concept of capital in terms of finance comprehensively and the ways it is raised in deta...

A: Capital is basically a term for financial assets of a company, such as funds held in deposit or fund...

Q: The semiannual tuition payment at a major university is expected to be $31,000 for the 4 years begin...

A: Semiannual Fee =$31000 Period =8 semiannual  interest rate =6% semi annnual =3% Present value FACTOR...

Q: suppose you inherited 100000 and invsted it at 7% per year what's the most you can withdraw if the e...

A: Using Excel PMT function 

Q: Time value of MoneyPart-I,  Mr. Zigong wishes to know about the future values of the single cash flo...

A: Formulas: Part 1: FV = PV(1+r)^?n Part 2: PV = FV/(1+r)^n Part 3: FV = C*[(1+i)^n - 1]              ...

Q: If a typical firm reports P20million of retained earnings on its balance sheet, could its directors ...

A: The dividend can be distributed from the profits earned by an entity during a year. An organization ...

Q: FFC is trying to establish its optimal capital structure. Its current capital structure consists of ...

A: The CAPM is a model that helps to compute the return on equity with the help of beta and risk-free r...

Q: For each of the following, compute the future value:  Present Value        Years      Interest Rate...

A: Future Value =Present Value * (1+rate)^n Where, n = no. of year rate = interest rate     

Q: Warning: Rounding in the calculation of monthly interest rates is discouraged. Such rounding can lea...

A: a) Estimated monthly payment = Borrowed amount / n   

Q: Assume that you just inherited an annuity that Will pay you 10,000 per year, with the first payment ...

A: Present value of perpetuity = Annuity amount /rate of return   

Q: The Market Cap of a company with 1,700,000 shares outstanding and a market price per share of $25 is...

A: Market capitalisation is generally referred as market cap. It represents the value of the outstandin...

Q: tion will render the M&O cost lower at $0.5 million per year. At an interest rate of 12% per year an...

A: Lined ponds  Construction costs =$11 million  MO cost=$2.3 million per year  interest rate =12% Peri...

Q: Calculate the present value of the following annuity streams: $5,000 received each year for 5 years...

A: Formula for PV of annuity: or ordinary annuity: P = PMT*1 - (1/(1+r)^n))                       r Whe...

Q: You want to buy a $212,000 home. You plan to pay 15% as a down payment, and take out a 30 year loan ...

A: a) Amount of down payment = cost of house * % of down payment 

Q: 5) see picture

A: Formula for stock value per share: Stock value per share = Market value of company/No of shares outs...

Q: 7) see pic

A: Cost of preferred stock = Dividend / Net Price  

Q: EB6. LO 11.2 The management of Ryland International is considering investing in a new facility and t...

A: Payback period is the period where the initial investment is paid back in the given time period.

Q: Year 1-Year Forward Rate 1 4.6 % 2 4.9 % 3 5.2 % 4 5.5 % 5 6.8 %       What should th...

A: GIVEN, PAR = $1000 FORWARD RATE OF ONE YEAR ZERO COUPON BOND = 4.6% PRICE =PAR1+R=$10001+4.6%=$956.0...

Q: . For each of the following, compute the future value: Present Value            Years Interest Rate ...

A: Given:

Q: Think about your investment possibilities for 3 years holding period in real investment environment....

A: Generate optimal returns Save Tax Earn regular income Capital preservation Meet short to medium term...

Q: Suppose that $2000 is placed in a savings account at an annual rate of 5.4%, compounded quarterly. A...

A: In order to find the number of years in which an amount will be equal to a specific amount can be fo...

Q: A couple purchasing a home budget $1,800 per month for their loan payment. If they have $25,000 avai...

A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two type...

Q: Calculate the future value in five years of $5,000 received today if your investments pay. 6 percent...

A: Future value =Present value *(1+rateper period)^n Where, n = no. of compounding period

Q: Master Machine Berhad is considering a four-year project to improve its production efficiency. Buyin...

A: Net present value is difference between present value of cash outflow and present value of cashinflo...

Q: Classify the following transactions as taking place in the primary or secondary markets:  IBM issues...

A: Primary market:  The primary market is a place where issue of securities at first time.  In this mar...

Q: 10) see picture

A: according to gordon's growth : Pi=Di+1r-g where, Pi= price at year i DI+1= Dividend at year i+1 r= r...

Q: 11) see picture

A: Formulas: Horizon value = FCF3(1+g)/r - g Market value = FCF/1+R + FCF2/(1+r)^2 + FCF3/(1+r)^3 + Hor...

Q: Year 1-Year Forward Rate 1 4.6 % 2 4.9 % 3 5.2 % 4 5.5 % 5 6.8 %   What is the yield ...

A: This question provides the forward rates of return on bond of future years which are differed  in al...

Q: 23. a) Answer the following regarding the major differences between common and preferred shares. Pre...

A: Common equity and preferred stock both are capital for the firm and firm pays dividend to both categ...