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&quot;: 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* :&quot;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&quot;: 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* :&quot;1718 | Weight = Present value of each payment ( Column E ) divided by the bond pricePage 1

mortman

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