(精编)毕博-管理咨询工具方法-Business-Scenario-Software-Chinese-JM-Case

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,利润可行性分析PROFITPOSSIBILITIES,,,,,,,,,,

,,,,,,,,,,,,,

,,,,PROFITCHANGE………………,,,,,,"$2,401,920",,

,,,,利润改变,,,,,,,,61%

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,当前状况CURRENTPOSITION,,,,,可能状况POTENTIALPOSITION,,,

,,,,估计ESTIMATE,,数值AMOUNT$,,,,估计ESTIMATE,,数值AMOUNT$

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,Beginningcustomercount,,"4,000",,,,,,,,"4,000"

,,初始客户数,,,,,,,,,,

,,,,,,,,,,,,,

,,Lesscustomerdefections……………..,,20%,,,,,,18%,,

,,减客户流失率,,,,,,,,,,

,,,,,,,,,,,,,

,,Addcustomeradditions………………..,,20%,,,,,,22%,,

,,加客户增加率,,,,,,,,,,

,,净客户数Netcustomers,,,,"4,000",,,,,,"4,160"

,,,,,,,,,,,,,

,,Averagesalespercustomerperyear..,,3,,,,,,3.3,,

,,平均每客户每年的销售次数…,,,,,,,,,,

,,交易数量Numberoftransactions,,,,"12,000",,,,,,"13,728"

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,平均销售额Averagesalevalue…………,,4500.00,,,,,,5000.00,,

,,,,,,,,,,,,,

,,收入Revenue,,,,"54,000,000",,,,,,"68,640,000"

,,,,,,,,,,,,,

,,毛利润GrossProfit……….,,15%,,"8,100,000",,,,15%,,"10,501,920"

,,,,,,,,,,,,,

,,变动成本VariableCosts,,0%,,0,,,,0%,,-

,,,,,,,,,,,,,

,,GrossProfitlessVariableCosts,,,,"8,100,000",,,,,,"10,501,920"

,,毛利润减变动成本,,,,,,,,,,

,,管理费用Overheads………,,"4,147,000",,,,,,"4,147,000",,

,,净利润NetProfit,,7%,,"3,953,000",,,,9%,,"6,354,920"

,,,,,,,,,,4,x,倍数Multiple

,,,,,,,,,,,,,

,,,,,,企业价值改变BUSINESSVALUECHANGE,,,,"$9,607,680",,

,©McKessarTielemanAllrightsreserved,,,,,,,,,,,

,,,,,,,,,,,,,

,Usethisspreadsheettocalculatetheprofitchangethatoccurswhenyouchangethebusinesslevers.,,,,,,,,,,,

,Enteryourstartingpointdataintheleft-handsectionofthespreadsheet(orangecells).,,,,,,,,,,,

,Thespreadshee