22项目风险管理,蒙特卡洛法Microsoft Office Excel 工作表_第1页
22项目风险管理,蒙特卡洛法Microsoft Office Excel 工作表_第2页
22项目风险管理,蒙特卡洛法Microsoft Office Excel 工作表_第3页
22项目风险管理,蒙特卡洛法Microsoft Office Excel 工作表_第4页
22项目风险管理,蒙特卡洛法Microsoft Office Excel 工作表_第5页
已阅读5页，还剩10页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

1、项目概率累计概率随机数范围对应的随机数码可能值投资额0.30.3 13018000系统分区 分布区间0.40.7 31703110000-5 000 -5000以下0.31 7110071120000-50000现金流量0.20.2 120120004 000 040000.60.8 21802140008 000 400080000.21 8110081600012 000 800012000前10次现金流量模拟结果16 000 1200016000投资额现金流量NPV（10%，5）20 000 16000以上随机抽取的号码可能值随机抽取的号码可能值258000604000716373120

2、003040003163180006640007163691000048400051637612000604000316328000916000147454010000324000516318800062000-418771200094600010745791200042400031636310000394000516384120006640003163571000030400051635910000152000-2418218000966000147455110000414000516344100003640005163881200031400031633110000804000516395

3、1200081600010745981200092600010745791200050400031638812000434000316373120003740003163168000192000-41875120004440003163311000082000-24186010000754000516353100005640005163601000083600012745780002240007163891200032000-441854100009260001274569100006840005163551000033400051636800092000-418168000172000-41

4、8-5000以下-500000400040008000 8000120001200016000 16000以上00.050.10.150.20.250.30.350.40.45Series1411000067400051635010000132000-2418481000073400051635610000846000127458212000474000316349100007740005163581000085600012745711200072000-4418451000058400051634310000284000516362100008860001274557100007340005

5、1637612000866000107450#N/A594000#N/A74120007040003163741200065400031637712000916000107454010000614000516388120006440003163921200071400031637812000906000107458012000906000107457612000956000107454310000202000-24186210000172000-2418411000073400051635710000846000127456810000202000-2418308000112000-41820

6、80009160001474512800054400071631580003540007163831200082000-441874120006540003163811200062400031632680002640007163961200041400031639712000244000316318000544000716327800065400071639800054400071634310000404000516381120003340003163401000012000-24187800058400071639612000244000316388000294000716373120001

7、12000-4418991200033400031635010000794000516347100004940005163601000054400051635810000976000127450#N/A264000#N/A25800027400071634910000364000516326800062400071634310000424000516337100007040005163951200084600010745321000079400051633410000152000-241896120006340003163671000045400051633210000414000516360

8、10000906000127458112000816000107452380005940007163991200025400031635710000162000-2418228000162000-4186310000334000516365100009160001274578120006740003163901200058400031639212000614000316326800072400071632180008260001474517800063400071633910000504000516398000414000716341100006840005163331000067400051

9、635810000172000-2418311000072400051630#N/A554000#N/A21800038400071634310000444000516390120003040003163228000192000-41829800067400071633310000734000516376120002240003163951200072000-4418851200052000-4418198000654000716328000142000-4185110000484000516382120008660001074514800035400071638312000574000316

10、318000202000-4184410000202000-24189812000404000316340100007440005163268000162000-4186800032000-41856100003040005163298000976000147455800094600014745941200071400031638912000986000107450#N/A224000#N/A451000023400051632080008460001474595120005140003163631000090600012745288000122000-41840100004040005163

11、91120005440003163278000182000-418441000032000-24186610000714000516342100006540005163280001006000147457912000152000-441856100007840005163681000092000-24188712000444000316331100008660001274540100003240005163421000042000-2418591000042400051638612000474000316363100008040005163258000404000716393120005740

12、00316320800069400071633910000704000516381120004440003163511000076400051636110000544000516388000112000-418691000023400051639412000664000316373120009860001074557100009760001274546100002740005163341000081600012745680008560001474592120008360001074531100002640005163851200040400031633810000404000516397120

13、007140003163671000054400051638312000754000316350100002240005163881200034400031632580006240007163911200068400031633310000192000-2418511000066400051631680003040007163601000063400051634800050400071636910000102000-24182680002340007163780005640007163341000082000-241858100006940005163591000064400051633810

14、00076400051634210000936000127454010000836000127459012000244000316325800048400071635510000684000516319800052000-4183910000142000-2418480003840007163551000070400051637512000414000316358100007140005163931200044400031632280009460001474518800027400071635510000514000516370100006240005163591000065400051635

15、910000224000516327800083600014745198000434000716382120008160001074559100004640005163441000071400051635110000484000516329800029400071638512000192000-4418861200066400031632880008160001474595120007740003163641000081600012745531000032400051638012000152000-441866100007440005163941200032400031633610000856

16、000127455610000856000127451380001006000147456310000946000127458412000956000107458812000354000316339100003340005163901200082600010745480004140007163891200091600010745841200040400031639812000794000316317800029400071637112000514000316375120003640003163691000022000-24185710000754000516342100009660001274

17、54010000876000127451680007040007163771200061400031631180005140007163991200039400031632480002940007163741200022400031637212000996000107459012000192000-4418551000062000-2418621000089600012745571000059400051633910000484000516318800055400071634110000544000516371120007140003163168000916000147455410000142

18、000-24186410000192000-24188412000112000-4418268000132000-418811200036400031636610000334000516347100009460001274579120003240003163911200042000-44184310000484000516397120009160001074543100004940005163680009060001474538100004240005163811200077400031630#N/A1006000#N/A148000384000716335100004540005163268

19、0006940007163371000052400051638512000464000316332100004240005163381000076400051636210000284000516368100007340005163681000060400051634610000112000-2418531000065400051631980007040007163128000936000147455710000344000516316800042400071634800043400071634210000384000516351100002740005163671000085600012745

20、981200048400031634210000724000516356100002940005163451000072400051634410000234000516347100009760001274518800052000-4186210000574000516348100007940005163321000044400051634800032400071634310000254000516332100003940005163681000043400051634510000836000127456210000202000-241841100006140005163880003940007

21、16373120009460001074563100009060001274525800049400071636610000564000516349100009960001274578000162000-41831100007640005163831200052000-441815800072000-4184810000374000516325800029400071634310000906000127451880003240007163711200063400031632580003840007163791200065400031636810000132000-241810800011200

22、0-4181800082000-418721200065400031636810000172000-241854100005840005163711200060400031636310000634000516344100002840005163971200092600010745980008560001474551100006340005163691000057400051638412000846000107457412000172000-441828000424000716331100008560001274531100003740005163268000234000716388000996

23、000147458112000122000-44187312000354000316399120006340003163371000082600012745561000062000-241818000152000-418841200012000-4418861200062000-4418681000057400051637712000946000107453800085600014745751200092600010745168000906000147454800093600014745641000097600012745961200078400031639212000744000316319

24、800042400071631880004440007163280003840007163681000077400051638812000724000316350100003140005163218000794000716341100008040005163881200069400031638412000152000-44187212000744000316325800051400071636110000192000-2418288000946000147459512000334000316384120004540003163451000072000-241828000744000716399

25、1200082600010745811200081600010745188000132000-418580004940007163248000936000147453910000434000516318000654000716337100004040005163268000102000-418491000032000-24180#N/A142000#N/A8512000846000107454910000132000-24189012000102000-44183800026400071636610000846000127453810000334000516324800072000-41811

26、800032400071639312000424000316314800082600014745701000082600012745631000027400051636810000504000516315800042000-418178000876000147459612000524000316348000896000147455810000524000516322800012000-4184410000896000127456610000374000516337100002540005163561000075400051635010000644000516324800027400071632

27、68000100600014745741200072400031632780003940007163128000976000147457512000734000316342100007340005163751200088600010745591000072000-2418541000082000-241834100008260001274582120008960001074515800050400071636610000644000516368000654000716318800092000-418531000041400051636110000856000127458912000634000

28、3163761200097600010745371000072000-24186710000694000516338000192000-41896120003140003163228000714000716384120006040003163480006740007163208000172000-41816800078400071633080009460001474544100004040005163611000072000-2418218000494000716318000514000716377120008260001074581120002440003163268000172000-41

29、8461000031400051637010000564000516378120005940003163751200092000-441836100004640005163391000026400051638812000314000316357100002740005163651000022000-24189112000112000-4418108000514000716312800052000-4180#N/A214000#N/A7800092000-4184310000254000516356100009760001274572120008760001074526800072000-418

30、7312000364000316335100005940005163771200082000-44188912000374000316333100006440005163188000886000147457512000414000316326800068400071633610000274000516386120008860001074529800026400071636800022400071633810000294000516395120005140003163311000072400051638412000202000-4418341000082000-24182580004740007

31、1636610000192000-2418731200068400031639512000274000316333100006640005163471000064400051639912000674000316338100008960001274519800024400071639712000584000316372120003040003163761200092000-44188512000664000316324800089600014745321000064400051634310000694000516387120006940003163721200028400031631380008

32、460001474588120008360001074562100003140005163691000043400051639212000784000316380120007540003163580005240007163611000037400051636910000574000516398000304000716333100003140005163268000234000716311800072000-4185910000644000516328000764000716368000182000-418991200048400031633210000996000127457010000916

33、00012745681000053400051637812000434000316349100003340005163218000906000147457412000254000316341100008660001274565100003440005163168000102000-41814800057400071631280009160001474522800062000-4187112000102000-441838100009060001274551100008560001274558000152000-418511000089600012745441000030400051632280

34、00434000716321800062400071633210000122000-24189212000132000-44186310000594000516358000202000-418851200062400031633110000816000127455610000364000516313800075400071631580003740007163631000022000-2418961200012000-4418621000033400051638012000142000-4418751200068400031631800040400071638800093600014745541

35、0000192000-2418180008040007163451000071400051635910000172000-2418651000094600012745651000094600012745601000074400051636710000866000127453610000554000516389120005840003163218000956000147456510000172000-24183210000172000-241838100006540005163168000504000716318000504000716365100002740005163128000394000

36、71637800058400071634410000202000-2418621000075400051639812000284000316397120002740003163661000042400051634010000534000516316800012000-41810800035400071633210000634000516368000182000-4186410000142000-2418178000404000716374120005940003163268000444000716378000284000716383120005340003163580008460001474599120007340003163511000092000-2418391000034400051639712000152000-4418431000091600012745341000049400051637912000714000316341100002340005163491000082000-2418180003540007163481000068400051631780005440007163411000041400051639912000534000316316800094600014745218000866000147459312000474

人人文库> 全部分类> 行业资料 > 信息产业

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论