Question: PLEASE SHOW FORMULAS IN EXCEL AND USE THE PROVIDED TEMPLATE! 1. In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in

PLEASE SHOW FORMULAS IN EXCEL AND USE THE PROVIDED TEMPLATE! 1.

PLEASE SHOW FORMULAS IN EXCEL AND USE THE PROVIDED TEMPLATE!

1. In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020 and Argo just paid the June coupon on its existing bond. Rates have come down, so it is thinking of buying back the bond and issuing a 5-year, $300M bond. This bond matures in June 2025 and will pay 3.45% per year in equal coupons each June and December. a. What is the price that Argo must pay the current bond holders to buy back the bond? (Hint - the present value of the coupon payments and the final face value) b. What are the cash flows associated with the new bond? c. What are the cash flow differentials to Argo? In other words, what are the net cash flows in or out for Argo each June and December when comparing both bonds? d. What is the present value of these cash flow differentials? C D E F G H I K L 1 in M$ 2016 2017 2018 2019 2 Amt. Coupon Start June Dec. June Dec. June Dec. June Dec. 3 Existing 700.0 5.55% 4 New Bo 300.0 3.45% 5 Purchase Price of Existing Bonds Incremental Cash Flows 7 PV of Incremental CF in June 202 8 0 V M N 2020 June Dec. Q R 2022 June Dec. 2021 June Dec. S T 2023 June Dec. W X 2025 2024 June Dec. June Dec. 6 Text answers here 9 10 11 12 13

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!

PROBLEM 1. In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020 and Argo just paid the June coupon on its...

***I need help to finish this spreadsheet, please.*** 1. In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020...

PROBLEM 1 In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020 and Argo just paid the June coupon on its...

1. In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020 and Argo just paid the June coupon on its existing...

al Verizon LTE 12:45 PM 20% % chegg.com Problem 1 In May 2011, Apache issued a 10-year, $263M bond paying 8.0% annually in two equal coupons each May and November. It is now May 2015 and Apache just...

Problem 1 In May 2011, Apache issued a 10-year, $263M bond paying 8.0% annually in two equal coupons each May and November. It is now May 2015 and Apache just paid the May coupon on its existing...

In January 1, 2016, Argo issued a 10-year, $700M bond paying 5.55% annually in two equal coupons each June and December. It is now June 2020 and Argo just paid the June coupon on its existing bond....

THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2017. Since Aylmer is a publicly traded company, it follows IFRS. Aylmer posted accounting transactions throughout the year....

Fewer young people are driving. In 1983, 87% of 19-year-olds had a drivers license. Twenty-five years later that percentage had dropped to 75% (University of Michigan Transportation Research...

Fultz Company has accumulated the following budget data for the year 2017. 1. Sales: 30,000 units, unit selling price $85. 2. Cost of one unit of finished goods: direct materials 1 pound at $5 per...

3. What are the names of the two segments in the AddTwo program?

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...