Model audit

From Nemo

Jump to: navigation, search

A model audit is the colloquial term for the tasks performed when conducting due diligence on a financial model, in order to eliminate spreadsheet error. (Also known as Model Review in some areas). A study in 1998 concluded that even MBA students with over 250 hours of spreadsheet development experience had a 24% chance of introducing spreadsheet error. Model audits are typically requested by banking organisations, in order to reassure lenders and investors alike that the calculations and assumptions within the model are correct, and that the results produced by the model can be relied upon. When a comprehensive review of the model is required, the scope of review is often extended to include tax and accounting, sensitivity testing and the checking of data contained within the model back to the original financing and legal documentation.


Typical scope

For a full-scope model audit, the following elements would usually be included:

  • A review of the model's logic;
  • A review of the model's consistency with financial and contractual documentation;
  • A review of the model's consistency with local GAAP and tax;
  • A sensitivity review.


References:

1.http://en.wikipedia.org/wiki/Model_audit


External Links:

/wiki/images/1/17/Fish1.png /wiki/images/e/ea/Fish2.png /wiki/images/f/fa/Fish3.png /wiki/images/f/ff/Fish4.png /wiki/images/4/40/Fish5.png /wiki/images/c/c5/Fish6.png
Personal tools