Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
A C D F Time until :` PVOFOF : Column ( C ) 2 Payment : ( Discount rate =` : Period ( Years ) Cash flow: 5% per period!* Weight : Column ( F)...
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
