• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

CM2B April 2019 Q3 (vi)

A

Andrew Finn

Member
I can't see how the examiner has worked out that holding -1000 Call Options and 2296 Put Options is the portfolio that maximises the probability of repaying the loan. I can see from the spreadsheet that -1000 and 2296 give a bigger probability of repayment than in Part (v), but I'm not sure how we know this is the maximum, or how we are meant to arrive at -1000 and 2296.

Is there a Goal-seek type function that can be used to maximise Cell I6 (the probability of repayment) by changing cells D3 and E3 (subject to them summing to 10,076) ? Or are we meant to use a Lagrangian technique to maximise the probability?

At the minute, the only way I can see to get to the answer is some elaborate Trial and Error. Any help would be really appreciated!

I've attached the question paper and Q3 solution spreadsheet

Thanks
 

Attachments

  • CM2B April 2019 Q3 (solution) v2.xlsx
    65.8 KB · Views: 6
  • landF_CM2B_201904_ExamPaper.pdf
    92.3 KB · Views: 3
Yes we have got a function that minimise/maximise a certain cell in excel.
That function is known as (solver). But remember that in order to solve any optimisation problem you need constrains that are subject to the problem you are trying to minimise or maximise. This is usually found in the question. Please note that you have to see this for your self the examiners won't tell you. In the case of the April 2019 examination we want to maximise the probability cell such that
(1000*So)+(a*Co)+(b*Po)=10076(constrain which you will need when you use solver in excel).
So- initial share price
Co-value of the call option at time 0
Po-value of the put option at time zero.
Please use solver in excel and let me know if you are happy
 
Last edited by a moderator:
Hi Andrew

The examiners were happy to accept anything sensible that increased the probability of repaying the loan rather than maximising the probability persay.

Once the share price gets above $15, the 200 call options that were held originally don't really add anything to the mix, ie you could repay the loan with the shares alone above this share price. This then sows the seed of selling (writing) call options.

You can then play around with the number of call options written. For example, if we keep the 1000 shares but write 1000 call options (instead of buying/holding 200 call options), the payoff is always $15,000 when the share price is $15 or more.

Finally, as LOLGABBY says above, you have a constraint that the overall portfolio value must be $10,076 so then we can use the GOAL SEEK function in Excel to determine the number of put options.

A tough question under the pressure of the exam. I found drawing a graph of the payoffs on the three assets (share, call, put) helped me.

Anna
 
  • Like
Reactions: Tim
Back
Top