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
Consider the following information, and answer the question below. China and England are international trade…
The CPA is involved in many aspects of accounting and business. Let's discuss some other…
For your initial post, share your earliest memory of a laser. Compare and contrast your…
2. The Ajax Co. just decided to save $1,500 a month for the next five…
How to make an insertion sort to sort an array of c strings using the…
Assume the following Keynesian income-expenditure two-sector model: AD = Cp + Ip Cp = Co…