Question: Need help with problem please! A B C D E F G H TREASURY BOND CALCULATION Current date 20-Feb-01 Previous interest payment date 15-Oct-00 1)

Need help with problem please!

A B C D E F G H TREASURY BOND CALCULATION Current date 20-Feb-01 Previous interest payment date 15-Oct-00 1) Find the invoice price of this treasury bond. Next interest payment date 15-Apr-01 2) Create a table WITH DATES that show the relevant cash flows for Coupon 3,250.00 the bond. 10 11 Days since last coupon date 128 3) Find the YTM in two ways using IRR and YIELD functions, Days between last coupon 12 date and next coupon date 182 13 14 Accrued interest 15 Face Value 100,000 16 17 Bond price 107,152.00 18 Accrued interest 19 Invoice price 20 21 Date Cash flow 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 YTM by XIRR 37 YTM by YIELD 38

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!

Need help with problem please!. A B C D E F G H TREASURY BOND CALCULATION Current date 20-Feb-01 Previous interest payment date 15-Oct-00 1) Find the invoice price of this treasury bond. Next...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

1. Make all 16 adjustments on the "Adjusting Journal Entries" tab. Remember to include a description under each journal entry. 2. Post the adjustments to the general ledger on the "12-31-14...

There are answers with "Answer: See Chapter 9 Mini Case Show" so i need the answer for all those questions please. Thanks 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29...

11) Assume ten years have passed and the YTM in the market has risen to 5.25%. What is the price of the bonds? Are they trading at a discount or premium? 12) Using the the same information as...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

All these are in proper sequence. please solve it. I Cannot increase the Font Size more, So can you please manage to answer. Please see below for your group project variables. A B C D E F G H 1 K L M...

Could you take a look at the attached tax forms and see if I filled them out correctly. It is a group assignment, and I only have to provide IRS Forms 3800 and 5884. I'm also attaching the story...

AutoSave OF ABG ... CTA 7 (version 1).xlsb - Auto Recovered Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v y X Calibri (body) v 12 ~ A A ab Wran Text General v H LE...

I have to calculate free cash flow and had incorrect on prior assignment. The guidance I received from the professor was: FCF = Net cash flow from operations - capital expenditures - cash paid for...

A fire completely destroyed all the inventory of Glisan Lumber Yard on August 5, 20--. Fortunately, the accounting records were not destroyed in the fire. The following information is provided by...

A town is bordered by two rivers as shown in the following figure. Levees A and B were constructed to protect the town from high water in the rivers. The levees were both designed for floods with...

sam works as the manager of downtown diner a local restaurant. recently,their cheese supplier increased the price of cheese what should sam do to make sure the diner does not lose money

Discuss the relevance of the United Nations Human Rights Council in the implementation and enforcement of international human rights law in Africa.