Take advantage of lockdown time to hone your Excel skills for business valuation

BVWire–UKIssue #14-1
May 5, 2020

valuation methods & approaches
statistics, cash flow projections, information technology

BVR’s Excel for Valuation E-Learning Course offers:

  • More than 100 downloadable examples including unsolved exercise worksheets with ‘solved’ counterparts so business valuers can check their work;
  • Case studies that walk through DCF calculations in Excel;
  • Step-by-step instructions on building balance sheets, multiple sheet formulas and models, and how to deploy macros for maximum efficiency;
  • Advanced tips and tricks from the experts on shortcuts, navigation tools, and more; and
  • The ability to start at ‘cell one’ or jump to the functions that will impact your analyses the most.

One example of a relatively little-known Excel function that can make changes to forecasts vastly quicker is EOMONTH. Dates are very important to forecasts business valuers use and should not just be hard-coded into a spreadsheet since the values often need to be changed. This is where the EOMONTH function in Excel can be essential. We tend to work with month end dates, and this is where this function becomes invaluable.

EOMONTH calculates the end of the month as the number of months after the specified date. For example:

  • EOMONTH(3-Apr-20,2) = 30-Jun-20; or
  • EOMONTH(28-Nov-19,-12) = 28-Nov-18.

Most analysts use the DATE function to guarantee that Excel understands the cell as a date rather than a value.

BVR’s Excel for Valuation is available on-demand for £397.

Please let us know if you have any comments about this article or enhancements you would like to see.