AutoCanada Financial Model is a financial model of a Distressed Company in the North American Automotive Retail industry that is ideal for investment banking, equity research, automotive retail professionals and valuation experts. The model includes the following features:
- A 3-statement financial model of AutoCanada operation including: revenue schedule, cost schedule, working capital schedule, depreciation and amortization schedule, tax schedule (Canadian tax standards), debt and interest schedule, shareholder’s equity schedule, and covenants and credit statistics spanning across earnings quality, cash flow quality, operating efficiency, balance sheet quality and valuation risk metrics, income statement, cash flow statement and balance sheet for a five year forecast period.
- Historical financial statements for the period of four years, company specific operating metrics, covenants and credit statistics including earnings quality, cash flow quality, operating efficiency, balance sheet quality and valuation risk metrics.
- Critical Auto Retail and AutoCanada operating and profitability metrics such as Adjusted EBITDA, Adjusted free cash flow (FCF) and Non-IFRS measures among others.
- Annual financial statements built based on the quarterly actuals and forecasts of financial statements.
- Historical ratings of the Company foreign and domestic bonds.
- Valuation of the Company distressed equity based on intrinsic valuation and discounted cash flow approach.
- Valuation of the Company distressed equity based on the option valuation of distressed equity and contingent claim valuation approach.
- Probability of turn-around of distressed equity.
- Valuation of the Company based on relative valuation and comparable analysis of peer group companies.
- Calculations of predicted multiples as a function of fundamental drivers and degree of sector over or undervaluation.
- Calculation and quantification of risk measures for purposes of valuation including beta, cost of equity and cost of capital.
- Operating, valuation, profitability and performance charts of the Company operations.
- A summary dashboard of company report, market data, key financial metrics, annual figures, comps, valuation and other statistics.
- The tabs of the models are: Cover, Summary, Assumptions, Annual, Historicals, Model, Valuation, Historical Ratings, Beta, Forward Multiples, Historical Multiples, Predicted Multiples and Notes.
- The model is a rolling, valuation model that can also be used for equity research.
- The initiation report as well as 2019Q4, and 2020Q1 equity research notes are included with the package. The initiation report describes the relative as well as contingent claim valuation of the company, the operation and historical performance of the company as well as corporate governance issues in full details.
AutoCanada Financial Model
- This financial model is a circular, 3-statement model along with many other features explained in the product description. Please ensure prior to opening the excel sheet, iterative calculations within the excel workbook environment has been enabled under: File/Options/Formulas/Enable iterative calculations.
- Set the Calculation options under File/Options/Formulas to ‘Automatic except data tables’. In case of the existence of data tables in the models, press F9 to refresh and update the table calculations.
- The workbook contains a Macro in the form of the product Disclaimer which should be accepted by the user; hence, please enable macros in the workbook under File/Options/Trust Center/Trust Center Settings/Macro Settings/Enable all macros. The financial model itself contains no macros.
- Please ensure the above steps are implemented prior to opening the excel sheet.
- If at any point #Value! appears in the Model and the results, toggle the circularity switch on the Assumptions tab to ON and then OFF to address the problem. This switch sets all interest expenses to zero when turned ON.
- All blue font in the model are hardcoded inputs, black font is calculation, red font is the references to the blue inputs on the Assumptions tab, and any orange cells are values sourced from Refinitiv.