Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy.
Essential reading for anyone involved in building financial models!
Valuing Assets & Cash Flows - When I do a company valuation, I've heard that I should model the value based on cash flows then add the asset values to get the total value. Is this correct?
Valuation Models
There are two main types of valuation
models: asset-based and flow based ...
If you frequently hide and unhide certain columns or rows then its time to consider using Excel's Group feature. The Group option is on the Data Menu or Ribbon depending on your version, but there is a keyboard shortcut that makes it easy to use ...
