Question: how to calculate the yield without face value in excel? Or in anyways? The spreadsheet provided shows a list of bonds issued by the Australian

how to calculate the yield without face value in excel? Or in anyways? anyways? The spreadsheet provided shows a list of bonds issued by the

The spreadsheet provided shows a list of bonds issued by the Australian government and their relevant characteristics as of the 27th of March 2020. Based on the information provided, complete the following calculations in excel. A. Calculate the yield of each bond as of the 28th of March. (5 Marks) Bond Number Coupon Im L Maturity date 4.50% 15/04/2020 1.75% 21/11/2020 5.75% 15/05/2021 2.00% 21/12/2021 5.75% 15/07/2022 2.25% 21/11/2022 5.50% 21/04/2023 2.75% 21/04/2024 Current Price Payment Frequer Next Payment Date Number of Bonds on Issue 102.23 2 15/04/2020 800000 101.853 2 21/05/2020 250000 108.9 2 15/05/2020 400000 103.71 2 22/06/2020 350000 113.94 2 15/07/2020 100000 106.237 2 21/05/2020 478000 118.58 2 21/04/2020 450000 110.91 2 21/04/2020 700000 N001 The spreadsheet provided shows a list of bonds issued by the Australian government and their relevant characteristics as of the 27th of March 2020. Based on the information provided, complete the following calculations in excel. A. Calculate the yield of each bond as of the 28th of March. (5 Marks) Bond Number Coupon Im L Maturity date 4.50% 15/04/2020 1.75% 21/11/2020 5.75% 15/05/2021 2.00% 21/12/2021 5.75% 15/07/2022 2.25% 21/11/2022 5.50% 21/04/2023 2.75% 21/04/2024 Current Price Payment Frequer Next Payment Date Number of Bonds on Issue 102.23 2 15/04/2020 800000 101.853 2 21/05/2020 250000 108.9 2 15/05/2020 400000 103.71 2 22/06/2020 350000 113.94 2 15/07/2020 100000 106.237 2 21/05/2020 478000 118.58 2 21/04/2020 450000 110.91 2 21/04/2020 700000 N001

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!

assuming face value =100 The spreadsheet provided shows a list of bonds issued by the Australian government and their relevant characteristics as of the 27th of March 2020. Based on the information...

Be sure to scroll down to see all of the information on this sheet . ASSETS LIABILITIES 5 S Cash and due from other institutions 2, 590 Current accounts Trading securities Interest- bearing 5, 970...

I've attached the question as a word file, thanks! JWCL165_c10_444-505.qxd 8/12/09 7:24 AM Page 444 10 Liabilities Chapter STUDY OBJECTIVES After studying this chapter, you should be able to: 1...

Please read the attachment chapters and answer the following questions with at least 50 words. Depreciation discussion What are the various methods of determining depreciation and amortization...

Hello, I 1.Research the capacity of municipalities in Bosnia and Herzegovina for issuing a bonds? 2.What are pros and cons of bond financing? Compare long-term source of financing between Bosnia and...

Hello, I have a case study need be answeredregarding pdf files questions, 1.Research the capacity of municipalities in Bosnia and Herzegovina for issuing a bonds? 2.What are pros and cons of bond...

If 15% of x is equal to three times of 10% of y, then x : y = ? 1. 1:2 2. 2:1 3. 3:2 4. 2:3

What is the difference between an account payable and a note payable?

Why is the angle of the dark blue line steeper than the angle of the light blue line? check all that apply 1 The contribution margin per unit in the salary - based compensation scheme is lower than...

lom Emory and Jim Morris strolled back to their plant from the administrative offices of Ferguson \& Son Manufacturing Company. Tom is manager of the machine shop in the company's factory; Jim is...