Business

FinanceQ&A Library6. 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.Start your trial now! First week only $4.99!*arrow_forward*

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.

Tagged in

Business

Finance

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...