Question: Find the duration in EXCEL Par Value 1000 t CF(t) PV of CF(t) t x PV of CF(t) Coupon rate 5% 1 25 $24.39 $24.39

Find the duration in EXCEL

Par Value 1000 t CF(t) PV of CF(t) t x PV of CF(t)
Coupon rate 5% 1 25 $24.39 $24.39
YTM 5% 2 25 $23.80 $47.59
Years to Maturity 3 3 25 $23.21 $69.64
4 25 $22.65 $90.60
PV $1,000.00 5 25 $22.10 $110.48
6 1025 $883.85 $5,303.13
Duration ?

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!

Q:

Please fill in the given excel file for the following bond problems 1. Given the information about Target?s bond, Symbol: TGT.IJ and CUSIP: 87612EAU0, on FINRA's website: http://www.finra.org/, what...

Q:

What is the duration of a five - year, $ 1 , 0 0 0 Treasury bond with a 1 0 percent semiannual coupon selling at par? Selling with a YTM of 1 2 percent? 1 4 percent? What can you conclude about the...

Q:

r 46 New Example: The maturity is reduced to 5 years, the coupas rate is 11%, and the required return is 8% 47 45 Solution 49 Noon Inpuis SO Par Value 1.000 51 5 52 Coupon Rue 11% 53 Required mile...

Q:

Pleasegive me detail answers (formula) for the calculating questions FINA3317-002 Homework1 Spring 2016 FINA3317-003 Homework 1 Chapter 01 Introduction True / False Questions 1 Primary markets are...

Q:

i have questions about financial market . Can somebody help me that? FINA3317-002 Homework1 Spring 2016 FINA3317-003 Homework 1 Chapter 01 Introduction True / False Questions 1 Primary markets are...

Q:

Question 1: The formula number answers for PV= and NPV = each questions: Z AD M R S T U v w X Y AC AE AF AA AB N P Q B D 152 9b. How would your answer change if you made withdrawals at the beginning...

Q:

0.5 The value and duration of a five-year, 1,000 Treasury bond with a 10 percent semiannual coupon selling at par is calculated below. Five-year Treasury Bond: Par value = $1,000 Coupon rate = 10%...

Q:

The value and duration of a five-year, $1,000 Treasury bond with a 10 percent semiannual coupon selling at par is calculated below. Five-year Treasury Bond: Par value = $1,000 Coupon rate - 10%...

Q:

Please solve for the empty highlighted boxes. Add the calculations you entered in the excel cells, to receive the answers. (#6-10 for cells F9-11, weren't able to fit in this photo.)(For cell I4, it...

Q:

please answer these question and finish them in 3 hours, give the detail andexplanation of the every step to me , thank you ! Examination Cover Page Examination Period: Academic Institution: Academic...

Q:

Assignment 03- Financial Statements, Cash Flow, and Taxes Due Tomorrow at 11 PM EDT Description Is published once a year and provides stockholders with details about the company's performance and...

Q:

Research the topic of intelligence testing in schools. Choose a stance on the topic regarding the usefulness of intelligence testing in schools to guide instruction. Write a maximum 525-word letter...

Q:

In some ownership structures, profits go straight to the owners and taxes are reported on each owner s individual tax return. This is called: a . double taxation. b . flat taxation. c . unlimited...

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

Prepare the text of a form message to be sent to the people you interviewed but will not hire.

Q:

Based on the job description you prepared, develop five traditional and five behavioral questions you can use as you conduct telephone interviews with candidates.

Q:

How would you turn into a positive the answer to the question, What do you consider your weaknesses? (Objective 3)