Question

In: Finance

(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond...

(PLEASE SHOW WORK) - no financial calculator - no excel

2. David Hoffman purchases a bond with $1,000 principal, 20-year maturity, and 8% coupon (annual payments). Yields on comparable bonds are 10%.   Bob expects that two years from now, yields on comparable bonds will have declined to 9%. Find his expected yield, assuming the bond is sold in two years.

3. Calculate the duration of a $1,000, eight-year zero coupon bond using annual compounding and a current market rate of 7 per cent.

4. Calculate the duration for a $1000, 4-year bond with a 4.5% annual coupon, currently selling at par. Use the duration to estimate the percentage change in the bond’s price for a decrease in the market interest rate to 3.5%.

Solutions

Expert Solution

2.

Given information:

Coupon rate = 8%

Interest rate ( rate) = 10%

Years (nper) = 20

Future value (FV) = $1,000

Coupon payment (pmt) = coupon rate * FV

= 8% * $1,000 = $80

Calculations are:

Present value (PV at time 0) = $829.73

By using excel formula:

=PV(rate,nper,pmt,fv,type)

=PV(10%,20,80,1000,0)

$829.73

After 2 years interest rate = 9%, years = 18,

Then the present value = $912.44

By using excel formula

=PV(rate,nper,pmt,fv,type)

=PV(9%,18,80,1000,0)

$912.44

Expect yield = 14%

By using excel formula

=rate(nper, pmt, PV, FV, type)

=rate(2,80,-829.73,913.44,0)

14%

3.

Duration = 8 years

In zero coupon bond, the duration is Bond's time to maturity.

4.

Given information:

Coupon rate = 4.5%

Years = 4

Future value = $1,000

Coupon payment = coupon rate * future value

= 4.5% * $1,000

= $45

Present value of cash flow

= $3748.97

Duration = present value of cash flow/future value

= $3,748.97/$1,000

=3.75 Years.


Related Solutions

Please show all your work if you use the Calculator. If done in Excel, please send...
Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The following information applies to Problems 1-4) The Collins Group, a leading producer of custom automobile accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets                                        $ 38,000,000 Net plant, property, and equipment                    101,000,000 Total assets                                          $139,000,000 Liabilities and Equity Accounts payable                                      $ 10,000,000 Accruals                                                9,000,000 Current liabilities                                   $...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
For the following problems show your steps if using a financial calculator or upload the excel...
For the following problems show your steps if using a financial calculator or upload the excel spreadsheet if using excel. You just purchased a $1,000 par value bond with a 10 percent annual coupon rate and a life of 20 years. The bond has four years remaining until maturity, and the yield to maturity is 12 percent. How much did You pay for the bond? Is it a premium or discount bond? A $1,000 par value bond, paying $50 semiannually,...
how do i work out the correlation coefficient on my hp 10bii financial calculator... please show...
how do i work out the correlation coefficient on my hp 10bii financial calculator... please show steps
Essentials of Investments- Bodie, Kane and Marcus. PLEASE WITHOUT EXCEL and WITHOUT FINANCIAL CALCULATOR! And PLEASE...
Essentials of Investments- Bodie, Kane and Marcus. PLEASE WITHOUT EXCEL and WITHOUT FINANCIAL CALCULATOR! And PLEASE do not abbreviate the process! If you need to calculate the cash flows or the present value, please clarify and step by step without abbreviating the process. I mean do not write like this: "32.5 x PVIFA @ 3%, 10 years" or like this: "= 32.5 / 1.06 ^ 0.5 .... 1032.5 / 1.06 ^ 20 = 1057.79" . I NEED TO SEE THE...
14. PLEASE SHOW EXCEL WORK THANKS! Based on the following financial data, calculate the ratios requested....
14. PLEASE SHOW EXCEL WORK THANKS! Based on the following financial data, calculate the ratios requested. (Round your answers to 4 decimal places.)   Liabilities $ 7,800     Net worth $ 58,000   Liquid assets $ 4,600     Current liabilities $ 1,300   Monthly credit payments $ 640     Take-home pay $ 2,575   Monthly savings $ 130     Gross income $ 2,850 a.   Debt ratio    b.   Current ratio    c.   Debt-payments ratio    d.   Savings ratio   
PLEASE SHOW THE CALCULATOR INPUTS for the below work: Woods Company is considering the purchase of...
PLEASE SHOW THE CALCULATOR INPUTS for the below work: Woods Company is considering the purchase of some equipment. The initial investment will be $100,000. The estimated useful life of the equipment will be 5 years, at which point it will have a zero terminal salvage value. The annual savings in cash operating costs will equal $19,000, and the company has a minimum desired rate of return of 12%. Use straight-line depreciation and ignore income taxes. Compute: a. Net Present Value...
question 2 - please show your work in excel or paper. You have been hired by...
question 2 - please show your work in excel or paper. You have been hired by the CFO of Lugones Industries to help estimate its cost of common equity. You have obtained the following data: (1) rd = yield on the firm’s bonds = 7.00% and the risk premium over its own debt cost = 4.00%. (2) rRF = 5.00%, Market Risk Premium = 6.00%, and β = 1.25. (3) D1 = $1.20, P0 = $35.00, and g = 8.00%...
For the answer please show you work : please include steps/functions used on TI 84+ calculator...
For the answer please show you work : please include steps/functions used on TI 84+ calculator (mandatory). a. State the hypotheses and identify the claim. b. Find the critical value. c. Compute the test value. d. Make the decision./Summarize the results In a magazine survey, 60% of respondents said that they used reusable shopping bags, 32% asked for plastic, and 8% requested paper. A random sample of 300 shoppers revealed that 28 asked for paper, 120 requested plastic, and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT