$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

MAF308 Derivatives And Fixed Income Securities

tag 0 Download1 Pages / 55 Words


Develop a spreadsheet in Excel that prices Australia Government Bond “3.25% Treasury Bonds due 21 April 2025”, the term sheet is provided at Working spreadsheet needs to include:
o Day convention
o Annual Coupon Rate
o Yield to Maturity (Annualized)
o Number of Payment per year
o Face Value (PAR)
Outputs (determined by changing inputs)
o Discount Rate per period
o Coupon Payment
o Bond price  

The yield to maturity of above particular bond is 1.858% per annum annually compounding on 11/7/2017. What is the market price of this bond on 11/7/2017 (Or equivalently to ask, how much do you need to pay to get this particular bond on 11/7/2017.
Construct a graph for the above bond showing the relationship between bond price (Yaxis or vertical axis) and yieldtomaturity (Xaxis or horizontal axis) for a range of yield maturity (annualized) of 1.0% through 3.0% with step size of 0.1%. All yields are annualized and yearly compounding. Discuss the relationship between bond price and yield.maturity.

Compute the duration of the above bond on 11/7/2017. Using duration relation, explain how sensitive the above bond is to interest rate change Explain how option prices vary with different strike price and different expiration dates.Provide your reasoning rather than simply saying, for example, strike price increases, and call option price decreases.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 1 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Derivatives And Fixed Income Securities. Retrieved from https://myassignmenthelp.com/free-samples/maf308-derivatives-and-fixed-income-securities/financial-budget.html.

My Assignment Help (2021) Derivatives And Fixed Income Securities [Online]. Available from: https://myassignmenthelp.com/free-samples/maf308-derivatives-and-fixed-income-securities/financial-budget.html
[Accessed 27 October 2021].

My Assignment Help. 'Derivatives And Fixed Income Securities' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/maf308-derivatives-and-fixed-income-securities/financial-budget.html> accessed 27 October 2021.

My Assignment Help. Derivatives And Fixed Income Securities [Internet]. My Assignment Help. 2021 [cited 27 October 2021]. Available from: https://myassignmenthelp.com/free-samples/maf308-derivatives-and-fixed-income-securities/financial-budget.html.

MyAssignmenthelp.com delivers assignment help to millions of students of USA. We have in-house teams of assignment writers who are experts on wide ranges of subjects. We have appointed teams of native writers who provide assignment help to students in New York City and all over the USA. They are skilled assignment writers who successfully cater to search terms like do my assignment in the USA

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?