如何建立valuation model？

Daniel8013

<p><strong>那位好心人可以帮我做下关于EXCEL的valuation model，给点建议也好，小弟有份作业要做，具体要求如下：</strong></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 6pt; TEXT-INDENT: 17.85pt;"><u><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-bidi-font-family:'times new roman';;"><strong>Important Model Components <p></p></strong></span></u></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 6pt 53.85pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 53.85pt;"><strong><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-fareast-font-family:arial;;"><span style="mso-list: ignore;">-<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-bidi-font-family:'times new roman';;">Structure and stability of model, especially the determination of debt and how the model adjusts to different assumptions (we will test this). <p></p></span></strong></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 6pt 53.85pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 53.85pt;"><strong><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-fareast-font-family:arial;;"><span style="mso-list: ignore;">-<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-bidi-font-family:'times new roman';;">The use of additional modelling methods or extra analysis. We encourage and reward creativity <p></p></span></strong></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 6pt 53.85pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 53.85pt;"><strong><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-fareast-font-family:arial;;"><span style="mso-list: ignore;">-<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-bidi-font-family:'times new roman';;">Assumption relevance; you need to explain your assumptions, especially if your model has different results to expectations. <p></p></span></strong></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 6pt 53.85pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 53.85pt;"><strong><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-fareast-font-family:arial;;"><span style="mso-list: ignore;">-<span style="FONT: 7pt ';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span lang="EN-GB" style="FONT-SIZE: 11pt; FONT-FAMILY: 'mso-bidi-font-size:10.0pt;mso-bidi-font-family:'times new roman';;">Sensitivity analysis; make an appropriate choice of sensitivities to be tested. <p></p></span></strong></p><p></p>