ACST2001 : Financial Modelling Create Three Separate Sheets - Accounting and Finance Assignment Help

Assignment Task:

Task:

The objective of this assignment is to confirm some of the results presented to you in week 07, on slides 40–42. We proceed as follows. In a spreadsheet, create three separate sheets, labelled ‘Part a’, ‘Part b’, and ‘Part c’. Then answer the following questions.

1. [3 marks] On your sheet labelled ‘Part a’ do the following. Firstly, you are required to price a number of bonds (30 in all). We start by considering a 2% Treasury bond, maturing in 7 years. Price this bond at yields to maturity of

• 47 basis points under CY20.

• 153 basis points over CY20.

• 353 basis points over CY20. . . .

• 1 753 basis points over CY20. where CY20 is the Australian 10-year government bond yield for calendar year 2020 (i.e., the 10-year government bond yield on 31 December 2020).? Next, consider a 10% Treasury bond, maturing in 7 years. Also price this bond at yields to maturity of

• 47 basis points under CY20.

• 153 basis points over CY20. • 353 basis points over CY20. . . .

• 1 753 basis points over CY20. Finally, consider a 20% Treasury bond, maturing in 7 years. Also price this bond at yields to maturity of

• 47 basis points under CY20.

• 153 basis points over CY20.

• 353 basis points over CY20. ?You will need to use FactSet to find this value.

The above  ACST2001  Accounting Assignment has been solved by our  Accounting Assignment  Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.