ACST2001 S2 2024 Spreadsheet

ACST2001 S2 2024 Spreadsheet Project Task

In a spreadsheet, create four separate sheets, labelled ‘Part a’, ‘Part b’, ‘Part c’ and ‘Partd’. Part a to c confirm some of the results presented to you in week 7, on slide 40-42.Then answer the following questions

1. On your sheet labelled ‘Part a’ do the following.Assume each bond has a face value of $100.Firstly, you are required to price a number of bonds (30 in all). We start byconsidering a 4% Treasury bond, maturing in 8 years. Price this bond (in 3decimal places) at yields to maturity of
   标签：15,coupon,S2,Spreadsheet,2024,Part,your,bond
   From： https://www.cnblogs.com/wx--codinghelp/p/18436984