Question: Important note: Solve the following THREE questions by using the excel sheet on your computer, then copy the tables which you created and paste

Important note: Solve the following THREE questions by using the excel sheet on your computer, then copy the tables which you created and paste them on a word document. Print your word document and submit your results on the submission date. Question One: If a bond pays $1500 in one year and $2500 in two years, its present value is $2800. Find the interest rate which equates the price of the bonds with the future values discounted. Use in your experiment 10 interest rates (hint: start your calculation from interest rate =20% to 30%). (1.5 points) Question Two: Find the prices of a 10% coupon bond with a face value of $4000 on the following yield to maturities: 0.12, 0.11, 0.10, 0.09, and 0.08, and 4 years to maturity. Calculate the interest rate at each price. Further, write down the formula of the present value for this question. (1.5 points) Question Three: based on your results in questions 1 and 2 1) Write down the formula of the present value for questions 1 and 2. (2 points) 2) What is the relationship between the interest rate and the price of the bond? 3) What is the relationship between yield to maturity and interest rate in question 2?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

iNCOME STATEMENT EFFECTS March 11 Purchased inventory with cash for $6,160 (including GST)

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

You are an investment analyst. A client of yours, Mr A, owns 3.5% of the share capital of Price. Price is a listed company and prepares financial statements in accordance with International...

Important note: Solve the following TWO questions by using the excel sheet on your computer, then copy the tables which you created and paste them on a word document. Print your word document and...

I want the answer for question 3 Solve the following THREE questions by using the excel sheet on your computer, then copy the tables which you created and paste them on a word document. Print your...

Solve the following THREE questions by using the excel sheet on your computer, then copy the tables which you created and paste them on a word document. Print your word document and submit your...

Specialty Toys Specialty Toys, Inc. sells a variety of new and innovative children's toys. Management learned that the preholiday season is the best time to introduce a new toy, because many families...

How do traditional commerce and web-based commerce differ? What aspects of traditional shopping do you prefer over online shopping? How has mobile computing altered web-based commerce?

Marco, a crypto currency trader worked at Slate Financial for 5 years. Slate Financial has been in business for 25 years and registered their logo, when the company started. Their logo is SF$. He did...

( 1 + 3 x 2 s i n y ) d x + ( x 3 c o s y ) d y = 0

Figure 2 shows a cross section through a system that consists of an infinitely long charged rod centred in a thick cylindrical shell of inner radius R and outer radius 2R. The shell is made of a...

A Japanese, medium-sized outdoor sporting goods company that has been in the industry for 20 years is trying to expand its market to Northern Europe and would need a partner to help with the market...

A local Pilates studio recently began offering a monthly subscription service for its patrons. Suppose a particular patron at this studio has the following willingness-to-pay schedule, per session....

An urgent health care employs one physician, one nurse practitioner, two physician assistant, and one X-ray. The types of medical emergencies, minor procedure and health issues they provide are...

The propeller of a ship can be modelled as a device producing a stream of water of a cylindrical shape, the radius of which is Identical to that of the propeller. For simplicity, the velocity...

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

In this problem, you will process the sales and purchases transactions for the week of February 8 through February 14 for Vetter Vacuum Center. Step 1: Start Integrated Accounting 8e. Step 2: Load...

Write the answers to the following questions in the space provided. All of the following questions relate to February 8-14. Register Reports 1. What is the total amount of purchase orders for the...

Create the following 6 financial analysis reports for Kyle Corporation and provide an analysis as requested: a. Income Statement (Horizontal) report with a run date of 12/31/. Provide a narrative...

74 A sample space contains six sample points and events A , B , and C , as shown in the Venn diagram on page 146 . The probabilities of the sample points are P(1) = .20, P(2) = .05, P(3) = .30, P(4)...

78 Guilt in decision making. Refer to the Journal of Behavioral Decision Making (Jan. 2007) study of the effect of guilt emotion on how a decision maker focuses on the problem, Exercise 55 . The...

72 An experiment results in one of five sample points with the following probabilities: P(E12 = .22, P(E22 = .31, P(E32 = .15, P(E42 = .22, and P(E52 = .1. The following events have been defined:...