Features

V4.0

Program / Systems Compatibility

Excel 2007 branding

Excel 2007

excel 2010 branding

Excel 2010

blue windows symbol

Windows Operating System

Compatibility

blue windows symbol

Windows Operating System

The FAT v4.0 is fully compatible with MS Office Excel 2007, 2010, 2013, 2016, and 365.

Apple branding

Mac Operating System

Though the FAT was made through Windows, Mac users are still able to use the software by installing the Windows OS on your Mac with Boot Camp Assistant. (For instructions, please refer to the ‘Install Windows 10 on your Mac with Boot Camp Assistant‘ guide on the Apple Website.)

Users may also use programs such as Parallels to run Windows on Mac.

Features

Valuation

Strategic Consulting

  • A specific Valuation Methodology sheet follows the ‘Assessment of Value’ sheet (MPSP Input) to highlight all methodologies, inner calculations, and theories behind them.
  • The net Working Capital Calculator which is also accessible from the ‘Assessment of Value’ (MPSP Input) sheet.
  • The ‘DealStats’ data import sheet allows for 5 separate imports of data segments, and each can be weighted to reflect the subject business model revenue category weighting and highlights the ‘number of observations’ for each, details thereof, and ‘Coefficient of Variation’ (CV) for each array of samplings and related consideration. The Output Multiple can be derived from various considerations including those of ‘Revenue’ as well as ‘Earnings’ (EBIT, EBITDA, SDE / DE). The samplings can be adjusted to relate to the subject company by up to 8 user inputs, and or suggested discounts or premiums to arrive at various ‘Adjusted Implied Multiples’ for the subject company.
  • An extended break down sheet follows allowing up to 9 category breakdowns in ‘Sales / Revenues’, ‘Cost of Sales’, ‘General and Administrative’, or ‘Operating’ expenses and more, allowing for real analysis to be performed where a business model has multiple categories of revenues or where one is comparing ‘Internal Financials’ vs. ‘Accountant Prepared’, where the need to consolidate exists.
  • A full Amortization / Depreciation calculator exists in the sheet following the ‘Extended Breakdowns’
  • The Monte Carlo Simulator tab follows and is most useful for larger transaction analytics where modeling the ‘probability of different outcomes’ is desired in a process that cannot easily be predicted due to the intervention of random variables in order to model and understand the ‘impact of risk’, and ‘uncertainty’, in predicting and forecasting models. In essence this is a ‘multiple projection probability simulator’ used in valuations where significant uncertainties exist.
  • This is then followed by a data output sheet, Cash Flow Output, Balance Sheet Output, and Summary Output tabs.
  • Additional output sheets include ‘Valuation Considered Factors’, ‘Summary of Valuation Methodologies and Outputs’, ‘Seller Closing Balance Sheet’, ‘Buyer Opening Balance Sheet’, ‘Buyer’s Projected Income Statement’, ‘Buyer Projected Earnings’, ‘Buyer’s Projected Cash Flows’ (Both FCF and FCE), ‘Schedules outlying the selected amortization’, ‘Summaries of the DMD and Deal Stats considerations’, ‘Asking Price Multiples’, and followed by the ‘Data Export Tables’ to the reports and marketing materials which are performed via the report button on the ‘Main’ sheet.
  • Additional output sheets include ‘Valuation Considered Factors’, ‘Summary of Valuation Methodologies and Outputs’, ‘Seller Closing Balance Sheet’, ‘Buyer Opening Balance Sheet’, ‘Buyer’s Projected Income Statement’, ‘Buyer Projected Earnings’, ‘Buyer’s Projected Cash Flows’ (Both FCF and FCE), ‘Schedules outlying the selected amortization’, ‘Summaries of the DMD and Deal Stats considerations’, ‘Asking Price Multiples’, and followed by the ‘Data Export Tables’ to the reports and marketing materials which are performed via the report button on the ‘Main’ sheet.

Additional Input, Output, and Analytics Sheets

  • A specific Valuation Methodology sheet follows the ‘Assessment of Value’ sheet (MPSP Input) to highlight all methodologies, inner calculations, and theories behind them
  • The net Working Capital Calculator which is also accessible from the ‘Assessment of Value’ (MPSP Input) sheet
  • The ‘DealStats’ data import sheet allows for 5 separate imports of data segments, and each can be weighted to reflect the subject business model revenue category weighting and highlights the ‘number of observations’ for each, details thereof, and ‘Coefficient of Variation’ (CV) for each array of samplings and related consideration. The Output Multiple can be derived from various considerations including those of ‘Revenue’ as well as ‘Earnings’ (EBIT, EBITDA, SDE / DE). The samplings can be adjusted to relate to the subject company by up to 8 user inputs, and or suggested discounts or premiums to arrive at various ‘Adjusted Implied Multiples’ for the subject company
  • An extended break down sheet follows allowing up to 9 category breakdowns in ‘Sales / Revenues’, ‘Cost of Sales’, ‘General and Administrative’, or ‘Operating’ expenses and more, allowing for real analysis to be performed where a business model has multiple categories of revenues or where one is comparing ‘Internal Financials’ vs. ‘Accountant Prepared’, where the need to consolidate exists.
  • A full Amortization / Depreciation calculator exists in the sheet following the ‘Extended Breakdowns’
  • The Monte Carlo Simulator tab follows and is most useful for larger transaction analytics where modeling the ‘probability of different outcomes’ is desired in a process that cannot easily be predicted due to the intervention of random variables in order to model and understand the ‘impact of risk’, and ‘uncertainty’, in predicting and forecasting models. In essence this is a ‘multiple projection probability simulator’ used in valuations where significant uncertainties exist.
  • This is then followed by a data output sheet, Cash Flow Output, Balance Sheet Output, and Summary Output tabs.
  • Additional output sheets include ‘Valuation Considered Factors’, ‘Summary of Valuation Methodologies and Outputs’, ‘Seller Closing Balance Sheet’, ‘Buyer Opening Balance Sheet’, ‘Buyer’s Projected Income Statement’, ‘Buyer Projected Earnings’, ‘Buyer’s Projected Cash Flows’ (Both FCF and FCE), ‘Schedules outlying the selected amortization’, ‘Summaries of the DMD and Deal Stats considerations’, ‘Asking Price Multiples’, and followed by the ‘Data Export Tables’ to the reports and marketing materials which are performed via the report button on the ‘Main’ sheet.
  • Included thereafter are the export property valuation tables and customizable sheets to the individual user.

Note

If the above seems overwhelming, it likely is because the subject matter can be overwhelming, and that is why we have designed this tool to be used from both a basic level, where a user will just do the recasting and MPSP, or Broker’s Opinion of Value, to an advanced assessor or valuator in the M&A world, and everyone else in between.

Once the user is familiar with using the FAT, they will wonder how they got on without it.