|
Statistics
1. COUNT:IF(S(PERM):PERM-FACT(N)÷FACT(N-R):COMB-FACT(N)÷FACT(R)×FACT(N-R)))
2. BINO:IF(S(PBINO):PBINO-FACT(N)÷(FACT(N-S)×FACT(S))×PSUC^S×(1-PSUC)^(N-S):CBINO-Σ(J:S:N:1:FACT(N)÷
(FACT(N-J)×FACT(J))×PSUC^J×(1-PSUC)^(N-J)))
3. HYPER:IF(S(PHYP):PHYP-FACT(NP-SP)×FACT(N)×FACT(NP-N)×FACT(SP)÷FACT(NP)÷FACT(N-S)÷
FACT(NP-N-SP+S)÷FACT(S)÷FACT(SP-S):CHYP-Σ(J:S:MIN(N:SP):1:FACT(NP-SP)×FACT(N)×FACT(NP-N)×FACT(SP)÷
FACT(NP)÷FACT(N-J)÷FACT(NP-SP-N+J)÷FACT(J)÷FACT(SP-J)))
4. POISSN:IF(S(PSN):PSN-MU^X×EXP(-MU)÷FACT(X):CPSN-Σ(J:XMIN:XMAX:1:MU^J×EXP(-MU)÷FACT(J)))
5. RHSZ:RHSZ=EXP(-Z0^2÷2)×.39894×(.4361836×INV(1+.33267×Z0)-.1201676×
INV(1+.33267×Z0)^2+.9372980×INV(1+.33267×Z0)^3)
6. RHST:TO=L(B:SQURT(LN(1÷(RHST×RHST))))-G(B)+L(C:G(B)-(2.30753+.27061×G(B))÷(1+.99229×G(B)
+.04481×G(B)^2))+(G(C)^3+G(C))÷(4×DF)+(5×G(C)^5+16×G(C)^3+3×G(C))÷(96×DF^2)+(3×G(C)&7+19×G(C)^5+
17×G(C)^3-15×G(C))÷384×DF^3)+(79×G(C)^9+776×G(C)^7+1482×G(C)^5-1920×G(C)^3-945×G(C))÷92160×DF^4)
Finance
7. AF:AF=(1÷R)×(1-1÷(1+R)^T))
8. AF.G:AF=(1÷(R-G))×(1-(1+G)^T)÷((1+R)^T))
9. PERP:PV=C÷R
10. G.PERP:PV=C÷(R-G)
11. ANNUITY:PV=C×((1÷4)-1÷(R×(1+R)^T)))
12. EAY:EAY=(1+R)^N-1
13. BOND:PV=C×F×(1÷R)×(1-(1÷(1+R)^N))+(F÷(1+R)^N)
14. DUR:DUR=(((1+Y)÷Y)-(((1+Y)+(T×(C-Y))))÷(C×(((1+Y)^T)-1)+Y)))
15. PVBP:DP=-1×D×P×(DY÷(1+Y))
16. TBILL:PV=1-((DAYS÷360)×YIELD)
17. YTM:P=Σ(T:1:TT:1:C÷(1+Y)^T)+FV÷((1+Y)^TT)
18. BS.D1:D1=(LN(S÷X)+(R+.5×SIGMA^2)×T)÷(SIGMA×SQRT(T))
19. BS.D2:D2=D1-SIGMA×SQRT(T)
20. BS.CNV:CNV=(IF(X<0:1-(1-((1÷SQRT(2×PI))×EXP((-((-X)^2))÷2))×(.4361836÷(1+.33267×(-X))-.1201676×
(1÷(1+.33267×(-X)))^2+.9372980×(1+.33267×(-X)))^3):1-((1÷SQRT(2×PI))×EXP((-(X^2))÷2))×
(.4361836÷(1+.33267×X)-.120676×(1÷(1+.33267×X))^2+.9372980×(1÷(1+.33267×X))^3)))
21. BS.CALL:CALL=S×ND1-X×EXP(-R×T)×ND2
22. BS.PUT:PUT=CALL-S+X×EXP(-R×T)
23. BN.OPTION:OPTION=(P×AUP+(1-P)×AND)÷(1+R)
24. BETA:BETA=((1+U)×AND-(1+D)×AUP)÷((U-D)×(1+R))
25. HEDGE:HEDGE=(AUP-AND)÷(S×(U-D))
26. CONT.I:CONT.I=N×LN(1+R÷N)
27. CONT.U:CONT.U=EXP(STD×SQRT(T))-1
28. BINO.T:BINO.T=A×(1+%U)^#UP×(1÷%D)^#DN
29. PVA:PVA=PMT×(((1+PINT)^(N)-1)÷(PINT×(1+PINT)^(N)))
30. MORT.CONST:MC=(INT×(1+INT)^N)÷((1+INT)^N-1)
31. D.MOD:D.MOD=D.MAC÷(1+(YINT÷2))
32. D.MAC:D.MAC=(Σ(T:1:TT:1:(T×C÷(1+Y)^T))+(TT×BFV÷((1+Y)^TT)))÷FV
33. CONV:CONV=(Σ(T:1:TT:1:(T×(T+1)×C)÷(1+Y)^T)+(TT×(TT+1)×BFV÷
((1+Y)^TT)))÷FV÷(1+Y)^2
34. CONV.A:.5×CONV.M×.01^2
35. AVG.L:(1÷12)×(Σ(T:1:TT:1:(T×PRINT)))÷TPRIN
36. D.DOL:D.DOL=D.MOD×PRICE÷100
37. D.EFF:D.EFF=(PRYDXBP-PRYIXBP)÷(INTPR×2×X)
38. C.EFF:C.EFF=(PRYDXBP+PRYIXBP-2×INTPR)÷(2INTPR×X^2)
39. SMM.S:SMM.S=1-(1-CPR)^(1÷12)
40. CPR:CPR=IR(PERIOD<30:0.06×PERIOD÷30:0.06)
41. SCH.PMT:SCH.PMT=PMT((N-(PER-1)):WAC:EBAL:FV:P÷YR:M)
42. SCH.INT:SCH.INT=WAC÷12×EBAL
43. SCH.AMR:SCH.AMR=SCD.PMT-SCH.INT
44. PRE.PMT:PRE.PMT=PSA÷100×SMM×EBAL
45. NBAL:NBAL=EBAL-SCH.AMR-PRE.PMT
46. CF.POOL:CF.POOL=SCH.INT+SCH.AMR+PRE.PMT
47. T.PRIN:T.PRIN=SCH.AMR+PRE.PMT
48. OLB:OLB=PV(N-PER:WAC:SCH.CF:FV:P÷YR:0)
49. MBT:MBT=((1+I)^N-(1+I)^T)÷((1+I)^N-1)×MB0
50. MPT:MPT=(I×(1+I)^N-T+1))÷((1+I)^(N-T+1)-1×MBT~1
51. SMM:SMM=1-(1-(PSA÷100×IF(PER<30:.06×PER÷30:.06)))^(1÷12)
52. PRT:PRT=SMM×(MBT~1-SPT)
53. PMT:PMT=(I×(1+I)^N)÷((1+I)^N)÷((1+I)^N-1)×MB0
54. F0:F0=G0^(RF×T)
55. G0:G0=EGT^(-(RF+GAMMA×(ERM-RF))×T)
56. BE:BE=(POPxRRxMR)-(POPxMC)-FC
57. CI:CI=2xSIGMA÷SQRT(ITER)
58. SIGMA:SIGMA=((UCI-LCI)÷2)÷STDV
59. BETA1:BETA1=(W1xVARR1+W2xRHO12xSIG1xSIG2)÷VARRP
60. PE:TBOV=(EBITDA÷COVR)÷INTR÷(1-EQ%)
61. CMR:CMR=(REV-INCRC)÷REV
62. Z:Z=(B1-BETA1)÷S1
63. BPR:BPR=(FACE÷(1+INTR)^TT)÷(1+CONPR)
64. IRR:IRR=PRETDx(1-TAX%)
65. CONV:CONV=PRICEx(1+G)^TT
66. SQSP:P=(RxVH+VL)÷(1+R)
67. FRQH:F=(VL-CL)÷(VH-CL)
68. NI:(EBIT-INTEXP)x(1-TAXR)
69. BMI:(W÷H÷H)x703
70. F:(R÷LN(1+R))
71. FCF:FCF=EBITx(1-TAXR)+D-CAPEX
72. DIS:DIS=((SP-(((((SP-TB-AD)xER)+AD)xTRS))-D)xSH)
73. NAT:NAT=DIS-((DIS-SB)xTRG)
74. SP=(HV-(TB+AD)x((1-ER)xTR)+(ADxTR))/(1-(1-ER)xTR)
75.
|
