Question

Write out the formulas, with the numbers filled in, to solve the following problems. You do...

Write out the formulas, with the numbers filled in, to solve the following problems. You do not have to do the actual calculations. Find the yield-to-maturity of a zero-coupon 10-year bond (par = $1,000) with a price of $622.44. (4 points). Find the present value of an investment that has three payments: $400 in two years, $500 in four years and $600 eight years from today. The relevant market interest rate is 4.20%. Find the future value of $100 invested today for 5 years at an annual rate of 6%, paid monthly.

Homework Answers

Answer #1

Q1

value of zero coupon bond = face value / ( 1 + yield to maturity )^ no of years to maturity

622.44= 1000 / (1 +ytm)^10

( 1+ytm)^10 = 1000 /622.44

1+ ytm = 1.0486

ytm = 4.86%

Q2.

Present value of investment = cashflow in 2 years / ( 1+int rate )^2 + cashflow in year 4 / ( 1 + int rate )^4 + cashflow in year 8 / ( 1 + intrate )^8

= 400/1.042^2 + 500/1.042^4 + 600/1.042^8

= 1224.26

Q3.

Future value = present value * ( 1 + periodic yield)^ no of periods

= 100*1.005^60

= 134.89

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. 1)     What is the price of a semiannual $1,000 par value bond with four years left until maturity that pays a coupon of 3.75% and is yielding 5.25%? What would it be yielding...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. 1. A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year for the next seven years; Project Beta requires...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. 1. A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year for the next seven years; Project Beta requires...
Please write legibly and do a step-by-step procedure to solve these problems. 1. S2,000.00 is invested...
Please write legibly and do a step-by-step procedure to solve these problems. 1. S2,000.00 is invested now and left for eight years, at which time the principal is withdrawn. The interest has accrued is left for another eight years. If the effective annual interest rate is 5%, what will be the withdrawal amount at the end of the 16th year? 2. Joanna plans to deposit S500 in the bank now and another S1,000 for the next 2 years. If she...
Please answer Questions 4 and 12 on page 89 of the textbook, and solve Problems 22...
Please answer Questions 4 and 12 on page 89 of the textbook, and solve Problems 22 and 27 on page 91 of the textbook. Complete your answer in Word, Excel, or both. 4. For each of the following situations, identify whether a bond would be considered a premium bond, a discount bond, or a par bond. A bond’s current market price is greater than its face value. A bond’s coupon rate is equal to its yield to maturity. A bond’s...
Please show the work in excel be sure to use appropriate formulas to solve each exercise...
Please show the work in excel be sure to use appropriate formulas to solve each exercise or problem. A1 If you deposit $12,000 in a bank account that pays 10% interest annually, how much will be in your account after 7 years? A2.    What is the present value of a security that will pay $10,000 in 20 years at an interest rate of 8%? A3.                 Find the future value of the following ordinary annuities: $600 per year for...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s non-callable...
How do I solve this? Need to show work. Question: XYZ currently has 21 long-term bond...
How do I solve this? Need to show work. Question: XYZ currently has 21 long-term bond issues outstanding with various times-to-maturity and coupon rates. One of these bonds matures on Dec 1, 2031, approximately 15 years from today. It has a yield to maturity of 4.8%. For simplicity, assume that coupons are paid annually. The bond is currently selling for $1,105, based on a face (par) value of $1,000.  What is the coupon rate? (Closest number) Answer: 5.78%
PLEASE SOLVE USING EXCEL AND SHOW FORMULAS  Gronseth Drywall​ Systems, Inc., is in discussions with its...
PLEASE SOLVE USING EXCEL AND SHOW FORMULAS  Gronseth Drywall​ Systems, Inc., is in discussions with its investment bankers regarding the issuance of new bonds. The investment banker has informed the firm that different maturities will carry different coupon rates and sell at different prices. The firm must choose among several alternatives. In each​ case, the bonds will have a ​$1000 par value and flotation costs will be ​$40 per bond. The company is taxed at 25​%. Use the approximation formula...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A firm has...