请问你们在工作时是如何避免financial model （或一个简单的spreadsheet）中的错误呢？
I think that the accuracy of data should rely on model design, not on person, because people can’t always be attention to detail. A good model design should follow some rules.
First of all, we need to keep clear notes & documentation about the model’s assumptions and methodology. As we all know, “Garbage in, garbage out”. We need to protect ourselves by noting down the resource of all assumptions.
Secondary, we need to make sure that model has clear structure. A typical model should have three parts: data input, calculation and output. All these three parts should be separate.
Thirdly, we need to make sure the formulas in one area should be consistent, and avoid hard-coding in the formula.
Fourthly, we need to build error-check modules in model. When we set up error-check modules, we also need to consider the allowing tolerance of error.
Last but not least, we need to do sense-checking about the model, make sure the result is reasonable. We can also get someone else check for us. 作者: AFMA 时间: 24-9-2015 20:51 本帖最后由 AFMA 于 24-9-2015 19:53 编辑
