驱å¨æ¯ï¼å·æã æå·§æ¯ï¼å¨æé«æçãå¥å£®æ§åç¾è§çéè·¯ä¸ç²¾è¿ï¼æ¥æ±ä¸åã å£è¯æ¯ï¼å¦æç¸åæè
ç¸ä¼¼çä¸ä»¶äºæ
第ä¸æ¬¡åï¼ä¸å®è¦ä¼åç°æ解æ³ã æ»ç»èµ·æ¥å°±æ¯ï¼å¨å®è·µä¸ä¸æ寻æ±æ´å¥½ç解æ³ï¼ç¶åææ¡çç»ã解æ³åå¨äºå¿«æ·é®ãå½æ°ãé«é¶å·¥å
·åVBAä¹ä¸ã ä¸ãå¿«æ·é® å
¶å®å¿«æ·é®ä¸ç¨å»æå»è®°å¿ï¼åªè¦å¨Excelçå®æä¸åå¤éå°ä¸äºç¥å¾®å¤æçæä½ï¼ç¹å«æ¯éè¦ä½¿ç¨é¼ æ çé£äºæä½ï¼ï¼å°±å»æ¥æ¥ææ å¿«æ·é®ï¼ç¶åä¸æ使ç¨å°±èªç¶è®°ä½äºã以ä¸å举ä¸äºæå
¶å¸¸ç¨åå¿
ç¶éå°çãå¦å¤ä¸ä¸ªé¼è¿«èªå·±è®°å¿å¿«æ·é®çå¿«ç³ççåæ³å°±æ¯ææé¼ æ ã ææ常ç¨èå¿
须记ä½ç Ctrl+C/V/X/S/Fï¼ä¸æ³è§£éäºï¼èªå·±å»æ¥ï¼è¿5个å¿
é¡»å¨æå¼å§å°±çç»ææ¡ ç§»å¨ç¦ç¹ Ctr+âââ â ï¼åæ¢å°æå
容åºåçä¸ä¸å·¦å³ç尽头 Ctr+Shift+âââ â ï¼åæ¢å°æå
容åºåçä¸ä¸å·¦å³ç尽头并éä¸è¯¥åºå Ctrl+PgUp/PgDn:å¨å·¥ä½è¡¨é项å¡ä¹é´ä»å·¦è³å³ï¼ä»å³è³å·¦ï¼è¿è¡åæ¢ ç¼è¾æ ¼å¼ Alt+E+Sï¼è°åºâéæ©æ§ç²è´´âççé¢ï¼ Ctrl+Shift+%ï¼ä½¿ç¨ä¸å¸¦å°æ°ä½çâç¾åå·âæ ¼å¼ Ctrl+Shift+^ï¼ä½¿ç¨å¸¦æ两ä½å°æ°çç§å¦è®¡æ°æ ¼å¼ Ctrl+;ï¼è¾å
¥å½åæ¥æ Ctrl+Bï¼ä½¿ç¨æåæ¶å ç²æ ¼å¼è®¾ç½® Ctrl+Uï¼ä½¿ç¨æåæ¶ä¸å线 æä½ Ctr+Y/Zï¼éå¤ææ¤éä¸ä¸æ¬¡æä½ Alt+I+Wï¼æå
¥æ°çå·¥ä½è¡¨ Alt+F11ï¼æå¼VBAç¼è¾å¨ï¼VBAæ¯æç±ï¼è¯¦è§Excel å°åºæå¤åå®³ï¼ - ä½æç§çåçï¼ äºãå½æ° å½éæ±ä¸å¤æçæ¶åï¼ç¨ç¨â=âæè
âsumâçå°±å¤äºãç¶èéçéæ±å级ï¼VLookupå°±æ¥äºãç«çæ¥æ¾ä¹åï¼å°±è¦æ¨ªçæ¥æ¾ï¼HLookupï¼ä»¥ååç§è±å¼æ¥æ¾ï¼ Match/Offset/ Indirect/Addressï¼ãæ¥æ¾å®ä¹åï¼å°±æ¶åå°ç»è®¡è®¡ç®ï¼äºæ¯Sumifæè
Sumifsçéæ±å°±æ¥äºãç¶èè¿è¿ä¸å¤ï¼éæ¸ä¼ç¹è¡åºç±»ä¼¼äºæ°æ®åºçSelectçå¤éå¤ææ¡ä»¶çéæ±ï¼äºæ¯å°±ä¸å¾ä¸å¼å
¥äºæ°ç»å½æ°ã æ¯å¦ï¼è®¡ç®AA产åçæ»ä»·å¼ï¼æ¿ä»£select sum(产åæ°éx产ååä»·) from ... where 产åç¼å·=âAAâãå½ç¶ä½¿ç¨æ°ç»å½æ°å°±é常ç®ååçµæ´»ï¼{=SUM(IF(($B$4:$B$8="AA"),($C$4:$C$8)*($D$4:$D$8),0))} å¦å¤ï¼æè´¢å¡åéèçåå¦ï¼ä¸å®åè¿ä¸å¼ æ¥è¡¨ï¼ä¹è¯å®ç»åè¿æ¥è¡¨ä¹é´é
å¹³çé
¸æ¥ã为äºå·æåæé«è´¢å¡æ¨¡åçå¥å£®æ§ï¼å°ä¸é¢çå类索å¼å½æ°åæ°ç»å½æ°ç¨å°æè´ï¼äºæ¯å®ç°èªå¨é
平以åæ£æ¥ã ä¸ãé«é¶å·¥å
· Excelä¸æ许å¤é«é¶å·¥å
·ä¹è½å¤§å¹
æé«æçåç¾è§ãé¦å
æ¯å¾è¡¨ç»å¶å·¥å
·ï¼å 为ä½ä¸ºè§è§å¨ç©ç人类è¶æ¥è¶éè¦å©ç¨å¾è¡¨æ¥ç解å表达ãå¨æç« ï¼RIOæ¯å¦ä½å¸å·å¤§æ±ååçï¼ - æ°æ®å°å±± - ç¥ä¹ä¸æ ï¼ä¸ï¼ä¸ºäºè¡¨è¾¾é¸¡å°¾é
æ¶è´¹ææ¿çéå¹´å¢é¿ï¼æ½åæ°æ®åéè¦å©ç¨å¯è§åæ¥è¡¨è¾¾ãä¸å¾å·¦æ¹æ¯å©ç¨ç³»ç»é»è®¤é
ç½®ç»å¶åºçå¾è¡¨ï¼æ¯ä¸æ¯æµæµç广åºèé£æ ¼ï¼èè¦å®ç°ä¸å¾å³æ¹çè´¢ç»æå¿é£æ ¼ï¼é£å°±åªå¥½ä¸ä¸ªä¸ªåæ°çä¼åï¼ä¼åå¾è¡¨ç±»åï¼é
ç½®Titleãæ 注åæ°æ®æºï¼æ·»å è¶å¿çº¿ï¼ä¼ååä½ççã为äºè®©å¾è¡¨æ´å¥½çï¼åç§æååæ°é½ç¨äºä¸éï¼å¯¹äºExcelçå¾è¡¨å·¥å
·ï¼èªç¶å°±ææ¡äºã åæ¶ï¼å¹³æ¶æ¶éé£äºå¤§çè´¢ç»æå¿çç»å
¸è¡¨æ ¼ï¼æ¯å¦ï¼åå°è¡æ¥æ¥ãç»æµå¦äººççï¼ï¼ç¶åæ¾ææåå¹è®è¯¾ç¨æè¿äºè¡¨æ ¼å®ç°ä¸éï¼è¿æ ·å¯¹äºExcelç»å¾çåè½å°±æ´çæäºã å¦å¤ï¼Excelä¸é¢è¿æ许å¤æ°æ®æ¸
æ´ï¼æåºãçéãæ ¹æ®ç»ä¸åé符æ¥åéæ°æ®çï¼ååæå·¥å
·ï¼æäºæ¯å¾é«é¶çï¼ANOVAåå¤å
线æ§åå½ççä¸ä¸ªé½ä¸å°ï¼ï¼å¨ä½¿ç¨è¿ç¨ä¸éæ¥ä½¿ç¨åç²¾è¿ï¼ä¹å°±éæ¸ææ¡äºã åãVBA VBAå
¶å®å
ä¸ç¨ç³»ç»å¦ï¼èæ¯å
ç´æ¥ç¨ï¼ä½ä¼å°çµèæ¯äººææ´é«æçå¿«æï¼ç¶åå¨å®è·µä¸ä¸æå»æ¸ç´¢åå°è¯æ´é«é¶çæè½ï¼åªè½å°éå°ç¶é¢åï¼åæ¾æ¬ä¹¦å»ççã 第ä¸æ¬¡ä½¿ç¨VBAæ¯å 为è¦åå¤æå°æ æ°çæ件ï¼èä¸æå°é¡ºåºåååé¢çè¦æ±å¾ä¸¥æ ¼ï¼é常容æåºéãäºæ¯ä¸è½å¿ï¼ä½æ¯éäºæè½ï¼åªè½å©ç¨å®å½å¶ä¸æéå¤çè¿ç¨ï¼ç¶åç®åæ¹æ¹åæ°ï¼æåéè¿æ§è¡å®æ¥ã ç¶åä¸åä¸å¯æ¶æ¾ï¼éçæå°é®é¢ä¸æå°å¤æï¼ç¨åºéä¹å级ï¼VBAæè½ä¹çªé£çè¿ãéå°ä¸äºè¿é¶çéæ±å¦ä¸ï¼åæ¶ä¹ææ¡äºè®¸å¤å
³äºæå°æºè®¾ç½®ãWorksheetåæ¢ä»¥åè°ç¨æä½ç³»ç»APIççåç§æè½ å¦ä½é²æ¢å¡çº¸ï¼ å¦ä½åè°å¤å°æå°æºæ¥æé«éåº¦ï¼ å¦æå¨å大çåå
¬å®¤ä¸èªå¨éåæè¿çæå°æºï¼ â¦â¦ å¦å¤ä¸ä¸ªä¾åæ¯ä¸ºäºæ´ç¾è§åç«é
·ï¼å¶ä½å¾è¡¨çGIFå¨å¾ãæå¼å§å©ç¨äºç½ä¸çä¸æ®µç¨åºä¸ºä¸å½å°å¾æ¶è²ï¼ä¾¿äºä¸ºé»ç鸡米é¥æ¯æä¹ç«èµ·æ¥çï¼ - ä½æç§çåçå¶ä½ç«ç®çè¡¨æ ¼ãåæ¥ä¸ºäºå¨å¾®ä¿¡ä¸ä¼ æææ´ç«é
·çææï¼å°è¯å¶ä½GIFãäºæ¯å¼å§æ¾å¶ä½GIFçå¤é¨ç¨åºï¼æç»ä½¿ç¨VBAè°ç¨å¤é¨ç¨åºä»¥å读åç³»ç»æ件çåç§æè½ï¼å®æèªå¨çæGIFå¨ç»ã äºãæ建模åçå¥è·¯ 以ä¸é½æ¯ææ³ï¼Excelæ大çå®æä»·å¼å°±æ¯å¶ä½å类财å¡æ¨¡åæè
ç®åçæ°å¦æ¨¡åï¼ç¨æ£ç¡®çæ¹å¼æ¹æ³æ¥å模åï¼æè°çâå¥è·¯âï¼ææ¯å¿æ³ãå¨åçï¼å¨éèè¡ä¸ä¸ï¼å¸¸ç¨ç Excel åææä½æå·§æåªäºï¼ - Microsoft Excelï¼ä¸æå°æ建å类模åçå¿æ³ï¼å
¶å®æ ¸å¿ç¹å°±æ¯ä¸æç»ä¹ å ä¹ä¸æç¢ç£¨æä¹å·æã ä¸é´ä¸ç©ï¼è®¸å¤é½æ¯è§¦ç±»æéãåFinancial Modelçåºæ¬ææ³å
¶å®åç¼ç¨é常类似ï¼æ¯å¦èåèèå¥çMVCï¼ æ´ä¸ªFinancial Modelçé»è¾è¢«åæä¸å±ï¼ Modelï¼è´è´£æ°æ®ï¼ï¼Viewï¼è´è´£åç°ï¼åControllerï¼è´è´£ä¸å¡é»è¾ï¼ï¼çæ³ç¶æä¸å
¶ä¸ä¸å±çæ¹å¨ä¸ä¼å½±åå°å¦ä¸å±ãè¿äºåºæ¬ææ³å¨å®è·µä¸éæ¥å½¢æçå¨åè¿æ¯ä¸ºäºå·æï¼ çµæ´»æ§é«ï¼éè¦æçµæ´»çæ¡æ¶å¿«é满足èæ¿å客æ·å¤åçéæ± å¤ç¨æ§å¼ºï¼è¿ä¸ªé¡¹ç®åå¾Financial Modelï¼é便æ¹æ¹å°±è½æå
¥å°ä¸ä¸ä¸ªæ¯«ä¸ç¸å
³ç项ç®ä¸ä½¿ç¨ å¥å£®æ§å¼ºï¼å°½éåå°é¢ç¹çæå·¥è¾å
¥æè
æä½ï¼å°åå§æ°æ®éä¸å¨ä¸ä¸ªæ¨¡åï¼æ¹ä¸ä¸ªæ°æ®ï¼ç¸å
³çæ°æ®å模åèªå¨æ´æ¹ å¨å大é¨åFinancial Modelçæ¶ååºæ¬å°±æ¯æç
§MVCçæ¡æ¶æ¥è¦æ±èªå·±çã Financial Modelæ建çè¿ç¨å°±å¦å修建é«æ¥¼ä¸å±å±å¾ä¸ç´¯å 模å 常æ°/æ ¸å¿æ°æ®/å设æ°æ®é¨åï¼å
æ¬ï¼åä¸å¸¸æ°ï¼æ±çåç¨ççï¼ãåå²æ°æ®ï¼è¿å»çè´¢æ¥ä»¥åå¸åºè§æ¨¡çåå²æ°æ®ï¼ã认为é è°±èä¸è½æ¹å¨çé¢æµæ°æ®ãæ ¸å¿å设ï¼æ¯å¦åå®å®è§ç»æµæç
§6-7%æ¥å¢é¿ï¼ççãè¿äºæ°æ®ç¥çäºCè¯è¨çhæ件é¨åï¼å¨ä¸åèå¨å
¨èº«ï¼æ以è¦åç¬å¯¹å¾
ãå¦åç¨åºä¸æ ·ï¼Excelçå½æ°ä¸æ¯ä¸è½åºç°hard-codeçæ°åï¼æ以å¦æä¸ä¸ªè´¢å¡æ¨¡åä¸åºç°â=2*3.14*râï¼åºæ¬æ¯å¯ä»¥æåå»éåçã Scenarioåºæ¯ï¼å
æ¬ï¼æ¨¡åä¸éè¦ç»å¸¸è°èçéè¦è¾å
¥åæ°ï¼æ¯å¦ï¼å¸åºæ¸éçãExit PE ratioçï¼ãè¿äºåæ°æ好å¥ç¦»åºæ¥æ为ä¸ä¸ªåç¬ççé¢ï¼å¯ä»¥æ¯è¾æ¹ä¾¿çæ§å¶åè°æ´ï¼ä¸ºä¹åçSensitivity Analysisååå¤ï¼çè³å¯è½éå°å¨ä¸æä¸æå°ç类似äºç¨æ¢¯åº¦ä¸éæ³å¯»æ±æä¼å¼çæ
åµã åºç¡æ¨¡åãè¿ä¸æ¥çæ ¸å¿å°±æ¯ååºé¢æµçä¸å¼ è´¢å¡æ¥è¡¨ï¼æ令人çè¦çæ¯é
å¹³ãå¯ä»¥ä½¿ç¨åç±»å¤æå½æ°ï¼Indirect/Offset/VLookupçï¼æ¥è¿è¡é
å¹³èä¸ä¼åºéï¼èä¸å¤ç¨æ§æé«ã è¿é¶æ¨¡åãåºäºåå²åé¢æµçä¸å¼ æ¥è¡¨ï¼åä¸äºæ´å¤æçè´¢å¡åææè
ä¼°å¼é¢æµï¼å
æ¬ï¼DCFãComparableãæææ§åæççã åç°ãæç¨æ·ï¼å
æ¬èæ¿æè
客æ·ï¼æå
³å¿ç产åºæ¾åºæ¥ï¼ç¨æå好ççé¢å±ç°åºæ¥ãå½ç¶åå¾æè´äºï¼å¯ä»¥æè°æ´Scenario以åéè¦åæ°ççé¢ä¹æ¾åºæ¥ï¼æ¹ä¾¿ç¨æ·Manipulate Dataï¼å
¶å®ç¿»è¯æä¸ææ´æ趣ä¸äºï¼ç¥äºµæ°æ®ï¼ä»¥ä¾¿å¾å°æ满æçç»æã ä¸å¾æ¯æ¾ç»å¥æè¿çä¸ä¸ªFinancial Modelï¼åºæ¬æ¶µçäºä¸è¿°çé»è¾åæ建è¿ç¨ï¼ä¾å¤§å®¶åèã
温馨提示:答案为网友推荐,仅供参考