V4.5
Program / Systems Compatibility
Excel 2007
Excel 2010
Windows Operating System
Compatibility
Windows Operating System
The FAT v4.0 is fully compatible with MS Office Excel 2007, 2010, 2013, 2016, and 365.
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
MS Excel based for ultimate flexibility and most widely recognized navigation.
Intuitive
Each tab is in order of functional input and output priority. Each tab and cell are
colour-coded with specific meaning and all as reflected and instructed in the ‘Usage Notes’
section on the ‘Main’ page of the FAT.
Sheets / Tabs include
Initial Input Section
- Historical Income Statement Input
- Revenue Projections Assumptions Input
- Revenue Projections Input and Analysis
- Historical Balance Sheet Input
- Property Valuation and Assessment
- All Projection Inputs are user selectable to include:
- Steady Growth
- No Growth
- Manual Growth
- Regression by Revenue
- Regression by year or
- Manual Input
Output and Analytical Section
- Stated Balance Sheet Assessments and Analytics
- Stated Income Historical Statements Assessments and Analytics
- Schedule of Income Statement Adjustments Assessments and Analytics
- Detailed Income and adjustments Assessments and Analytics
- Normalized EBIT, EBITDA, and SDE / DE Assessments and Analytics
- Summaries of EBIT, EBITDA, and SDE / DE Assessments and Analytics
- Free Cash Flow to Firm and Free Cash Flow to Equity Assessments and Analytics
- Projected EBIT, EBITDA, and SDE / DE Assessments and Analytics
- Growth Analysis Analytics
- Financial Ratios Analytics
- Industry Benchmark Analysis and Analytics
- All assessment and analytical tables are switchable from ‘Percentage of Revenue’ or ‘Grow’
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.