Feuil1MoisNippon Mining Holdings,
Inc.NikkeiRiRmViVmCov.12001000222010250.10000.02500.00040.0004-0.0004322010200.0000-0.00490.01460.00010.0013427010290.22730.00880.01130.00000.0003530010400.11110.01070.00010.0000-0.0000635010300.1667-0.00960.00210.0002-0.00070.06650.103E(
R)0.12100.00600.00570.00020.00010.645631068Ecart type0.075580.01227
(epsilon i) 0.0056260940.0056561637
Portef. variance min.0.645631068Coeff.
Corr0.0987166704Beta0.6078899718Caractristiques du
portefeuilleBeta0.3695302178Variance X=0,04, variance Y= 0,07,
covariance (X,Y) = 0,0035.Beta*Vm0.000055662
* La dcomposition du risque, et ** La proportion investir pour
avoir le portefeuille variance minimale.
Feuil2MoisNippon Mining Holdings,
Inc.NikkeiRiRmViVmCov.12001000222010250.10000.02500.00040.0004-0.0004322010200.0000-0.00490.01460.00010.0013427010290.22730.00880.01130.00000.0003530010400.11110.01070.00010.0000-0.0000635010300.1667-0.00960.00210.0002-0.0007E(
R)0.12100.00600.00570.00020.0001Ecart type0.07560.0123
Coeff. Corr0.0987166704Portef. variance
min.Beta0.60788997180.645631068Beta0.3695302178Beta*Vm0.00005566
Caractristiques du portefeuilleVariance X=0,04, variance Y= 0,07,
covariance (X,Y) = 0,0035.
&0.0104 (epsilon i) 0.0056260940.0056561637
Feuil3Etats de la natureProbabilitRxRmE(Rx)E(Rm)VAR (Rx)VAR
(Rm)Cov (Rx,
Rm)10.1-0.150.4-0.0150.040.008410.004-0.005820.20.050.30.010.060.001620.002-0.001830.40.150.20.060.080.000040040.20.250.10.050.020.002420.002-0.002250.10.3500.03500.004410.004-0.00420.140.20.01690.012-0.014Ecart
type0.130.11
coeff.
Corr.-0.9830917699Beta-1.1666666667Beta1.3611111111Beta*VAR(Rm)0.0163333333VAR
(Epsilon i)0.0005666667&0.4569420035
Feuil4Postes de produits ou de chargesMontant anne 1Montant anne
2Montant anne 3Montant anne 4Chiffre
d'affaires3576357635763576Achat de matires
premires674674674674Salaires753753753753Vente de matriel de
transport473473473473Produits financiers384384384384Charges non
courantes273273273273*Taux IS :33%EBE2149214921492149Dotations aux
amortissements120120120120Bnfice avant
impts2029202920292029IS669.57669.57669.57669.57Rsultat
conomique1359.431359.431359.431359.43Flux de trsorerie
final1479.431479.431479.431479.43
Flux de liquiditTIRVANProjetsDpense initialeAnne 1Anne 2%
10%N130002000200021.52%471.1N250003000350018.85%619, 8Projet
diffrentielDpense initialeAnne 1Anne 2%
10%N320001000150015.14%148.7
