100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Risk Management Formula Excel $13.73   Add to cart

Other

Risk Management Formula Excel

 0 view  0 purchase
  • Course
  • Institution

I have created an Excel spreadsheet specifically designed to assist you in solving any question related to Risk Management. This spreadsheet is user-friendly and can be easily customized to meet your specific requirements. Its simplicity ensures that you can navigate and utilize it effectively.

Preview 4 out of 37  pages

  • June 2, 2023
  • 37
  • 2022/2023
  • Other
  • Unknown
  • Unknown
avatar-seller
Long Call
Strike Price 50
Premium 2
Terminal price 40 50 60
Payoff = Max (S-K, 0 ) 0 0 10
Profit/(loss) = -P + max (S-K, 0) -2 -2 8




Short Call
Strike Price 64
Premium 3
Terminal price 40 50 60
Payoff = - Max (S-K, 0 ) 0 0 0
Profit/(loss) = +P - max (S-K, 0) 3 3 3




long put
Strike Price 72
Premium 3
Terminal price 40 50 60
Payoff = Max (K-S, 0 ) 32 22 12
Profit/(loss) = -P + max (K-S, 0) 29 19 9




short put
Strike Price 60
Premium 2
Terminal price 40 50 60
Payoff = Max (K-S, 0 ) 32 22 12
Profit/(loss) = -P + max (S-K, 0) 29 19 9




Swaps, Bonds and Credit risk
Unconditional probability of default (PD = Cumulative unconditional PD up to the end of ye
= 0.00477
CDt 1.36%
CDt-1 0.88%

probability of default

, 0.004812494


Calculation of CDS Payoff on Default
Payoff = (1 - Recovery Rate) x Notional Principal - Premiums Paid
Payoff 179700000
Recovery Rate 40.00 Premium Paid = Notional P
Notional Principal 300000000 CDS premium payment = C
Premiums paid 300000 Net payoff = (1 - recovery r
CDS Spread 60.00 Recovery rate = market pri
Time to Maturity 2


Expected loss 120
PD is the probability of default
LGD is the loss given default 0.7
Recovery Rate 30%
Expected loss % = PD x LGD 0
PD = Expected loss / (1 - LGD) 1.714285714
LGD is the loss given default 70%
Period 5
Cumilative PD 8.571428571
Cumilative P D 0

BOND PRICE
Period 4 Time
YTM 9.75% 1
Coupon rate 8.50% 2
Bond Price 100 3
4
Bond Price 87.17948718 96.01613
0.310741891
68.92581092

Liquidity Risk
Calculating the Cost of Liquidation Todays Price

Bid 25.67
Offer 25.75
µ is the mean bid-offer spread 25.71
σ is the standard deviation of the bid-offer spread 0.00624
Mean spread 0.08
α is the number of shares held 200000
s = (offer-bid)/mid 0.00311163
Cost of liquidation = ½ x (µ + λ σ) x α 8000
Total Cost of Liquidation
Bid 22.6
Offer 22.8
µ is the mean bid-offer spread 22.7
σ is the standard deviation of the bid-offer spread 0.5
λ is the confidence level 0.2

, α is the number of shares held 150000
s = (offer-bid)/mid 0.008810573
Cost of liquidation = ½ x (µ + λ σ) x α 15000

Cost of Liquidation at Stressed Market

Cost of Liquidation in Stressed MArket= (µ + (λ * σ)) / 2 * α 9453.92 N 10
mean bid-offer spread 25.71 N day Var 29895.92
σ is the standard deviation of the bid-offer spread 0.000242707
µ mean 0.00311163
λ is the confidence level 2.33
α iValue of Shares 5142000
Total cost of Liquidation
Cost of Liquidation in Stressed MArket= (µ + (λ * σ)) / 2 * α 102375
mean bid-offer spread 22.7
σ is the standard deviation of the bid-offer spread 0.022026432
µ mean 0.008810573
λ is the confidence level 2.33
α iValue of Shares 3405000


NSFR( Net Stable Funding Ratio)


RSF = Required amount of stable funding 100 Cash 15
Mortgage
RSF Factor 0.05 65
sFixed
ASF = Amount of stable funding 85 20
assets
ASF Factor 0.50 TOTAL 100
33.33333333



NSFR = ASF/RSF >100% NSFR satisfied

, Long Call - P/L

70 80
20 30




P/L
8
18 28
-2
40 -2
50 60
Strike Price



Short Call P/l
3 3 3


70 80
-6 -16
-3 -13 40 50 60
Terminal price


Profit/(loss) = +P - max (S-K, 0)



Long Put-P/L
29
70 80 19
2 0 9

-1 -3
40 50 60
Terminal price


Profit/(loss) = -P + max (K-S, 0)


Short Put P/L
29
70 80 19
2 0 9
-1 -3
40 50 60
Terminal price


Profit/(loss) = -P + max (S-K, 0)




onal PD up to the end of year 4
- Cumulative unconditional PD up to the end of year 3

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller linolawrence. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.73. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

64438 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$13.73
  • (0)
  Add to cart