Reference no: EM133001225
Just need the Excel formula and answers thanks!
1. Hamilton, Inc. bonds have an 8 percent coupon rate. The interest is paid semiannually, and the bonds mature in 5 years. Their par value is $1,000.
a. If your required rate of return is 10 percent, what is the value of the bond?
b. If your required rate of return is 10 percent and interest is paid annually, what is the value of the bond?
2. ABC bonds have an annual coupon rate of 8 percent and a par value of $800 and will mature in 20 years. If you require a return of 7.25 percent, what price would you be willing to pay for the bond? What happens if you pay more for the bond? What happens if you pay less for the bond?
3. You own a bond that pays $55 in annual interest, with a $1,000 par value. It matures in 17 years and your required rate of return is 7 percent. What is the value of the bond?
4. XYZ Corp plans on issuing bonds that pay no interest but can be converted into $2,200 (you receive when bond matures), 12 years from their purchase. It is determined that they should yield 6.5%, compounded annually. What price should XYZ Corp sell the bonds?
|
Which portfolio fits your need and situation most
: Suppose you are a nurse and work for a hospital. You think you can tolerate relatively high risk for your investment in retirement accounts. You want to have re
|
|
Evaluate for year and two more years ahead
: The follow are questions from an ebook. What are the processes to answer the questions on Microsoft excel?
|
|
Identify the various sources of revenues in federal budget
: Identify the various sources of revenues in the federal budget
|
|
What journal entry would smith and sons make to record
: Smith & Sons Inc. is a sporting goods manufacturer. What journal entry (or entries) would Smith & Sons make to record this agreement?
|
|
What is the value of the bond
: 1. Hamilton, Inc. bonds have an 8 percent coupon rate. The interest is paid semiannually, and the bonds mature in 5 years. Their par value is $1,000.
|
|
How is your product special
: You own a Brokerage who deals with house mortgage and insurances. Who exactly is your customer? How is your product special? USP
|
|
What is the pre-tax cost of debt
: Pearce's Cricket Farm issued a 30-year, 8% semiannual bond 3 years ago. The bond currently sells for 93% of its face value. The company's tax rate is 40%.
|
|
Calculate the items after refinancing
: Spam Corp is finance entirely by common stock and has a beta of 1.0. the firm is expected to generate a level perpetual stream of earnings and dividends. The st
|
|
Calculate the unlevered npv of this investment
: Your client, a real estate company, is evaluating a real estate project of $15,000,000 that will provide them with yearly NOI of $1,950,000 for the next 10 year
|