write my assignment 7310

Assume you will be paying $10,000 a year in tuition expenses at the end of the next 2 years (i.e. $10,000 at end of the year 1, $10,000 at end of the year 2). Market rate is 8%. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of your obligation? Hint: you can treat this obligation as a bond. 'use the provided spread sheets to show your work.Attachment 1Attachment 2ACDFTime until :`PVOFOF: Column ( C )2Payment: ( Discount rate =`: Period( Years )Cash flow: 5% per period!*Weight": Column ( F){`A. BYA Coupon bond0.540 :38.095:`0.03.95:`LELO'DCAT1. 036. 281:10.03TO:`1.5$34.5.54:0.01358 :0. 05.372.01040:8:55.61 1:1.77418Sum :`404. 540:1. 8$5210131 41516Semiannual int rate* :"1718 | Weight = Present value of each payment ( Column E ) divided by the bond pricePage 1

Assume you will be paying $10,000 a year in tuition expenses at the end of the next

2 years (i.e. $10,000 at end of the year 1, $10,000 at end of the year 2). Market rate

is 8%. Modify the spreadsheet 3.1 of “Duration Spreadsheet” to calculate the

duration of your obligation? Hint: you can treat this obligation as a bond.

‘use the provided spread sheets to show your work.

  • Attachment 1
  • Attachment 2

ACDFTime until :`PVOFOF: Column ( C )2Payment: ( Discount rate =`: Period( Years )Cash flow: 5% per period!*Weight": Column ( F){`A. BYA Coupon bond0.540 :38.095:`0.03.95:`LELO’DCAT1. 036. 281:10.03TO:`1.5$34.5.54:0.01358 :0. 05.372.01040:8:55.61 1:1.77418Sum :`404. 540:1. 8$5210131 41516Semiannual int rate* :"1718 | Weight = Present value of each payment ( Column E ) divided by the bond pricePage 1

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Comments are closed.

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp