Extend the coupon stripping model to allow for up to 20 periods and calculate the profit or
Question:
Extend the coupon stripping model to allow for up to 20 periods and calculate the profit or loss on this scenario. The model (see Figure 6.8) requires the use of dates rather than a fixed number of periods, together with IF statements to cease the coupon payments after 31 December 2027 and trigger the principal repayment.
The rates to be applied to each of the periods are as follows:
Figure 6.9 shows a portion of the answers with the individual coupons discounted at the individual rate and added together to form a profit.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Mastering Financial Mathematics In Microsoft Excel 2013 A Practical Guide To Business Calculations
ISBN: 9781292067506
3rd Edition
Authors: Alastair Day
Question Posted: