Question: PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS Question 3 - Calculate the price of the following discount bond with a par value of $100,000

PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS

PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS Question 3 - Calculate

Question 3 - Calculate the price of the following discount bond with a par value of $100,000 that compounds four times per year. The bond was settled on July 1, 2020 and matures on Oct 1, 2023. The current yield is 7.9%. (5 points) 7/1/20 10/1/23 Discount Bond - Price Settlement date Maturity date Coupon rate Coupons per year Face value % of par) Yield to maturity Par value $ 4 100 7.90% 100,000.00 Bond Price

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!

PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS Question 1 - Calculate the price of the following bond with a par value of $1,000 that pays a 5.1% coupon semiannually. The bond was settled on Jan 1,...

PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS Question 2 - Calculate the yield to maturity of the following bond with a par value of $1,000 that pays a 3.9% coupon semiannually. The bond was...

PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS Given the following information on two bonds (AAPL and GOOG), answer the questions below: Bond AAPL: Coupon rate Face value Coupons per year Years to...

can any expert help me with the below assignment just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question...

Attached are the two spreadsheets that I have already completed, but I can't for the life of me explain how the formula's work. I have also attached the questions that I have to answer. I have...

Could you help me solve the part2? the discount rate part. FIN322 Advanced Business Finance Major Assignment PSB 2016 Trimester 1 Due Date: 09/03/2017 at 5.00pm Place for Submission: Online...

Please show answer in excel formula. Thank you. Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

please help me fill out this excel sheet.. I dont understand. I have the solution page filled out to see if that is correct... please helppppp. Excel File Edit View Insert Format Tools Data Window...

Muji earned $10 million for the fiscal year. The firm also paid out 25 percent of its earning as dividend. This policy remains in foreseeable future. The remaining 75 percent of earnings is retained...

What impact would the following changes have on the security market line and therefore on the required return for a given level of risk? (a) An increase in inflationary expectations. (b) Investors...

24. Testing Significance in Predicting NFL Wins. The National Football League (NFL) records a variety of performance data for individuals and teams. A portion of the data showing the average number...

Examine the role of tiered pricing as a psychological pricing strategy in today s competitive online retail environment and evaluate its effectiveness in enhancing perceived value and influencing...

Explain why you agree or disagree with this statement.

4. Results. Probably most important, ask, What results did we achieve, in terms of the training objectives previously set? For example, did the number of customer complaints diminish? Reactions,...

1. In your opinion, what voluntary employer-sponsored benefits should this company maintain, and which ones should they not maintain? Why? To stay competitive, many organizations today are choos-ing...