Retail Industry Acquisition Financial Model
Originally published: 24/08/2020 09:23
Publication number: ELQ-98879-1
View all versions & Certificate
certified

Retail Industry Acquisition Financial Model

A financial model of an acquisition in the North American retail and e-commerce industry

Description
Amazon.com Inc. Acquisition of Whole Foods Market Inc. Financial Model is a financial model of an acquisition in the North American Retail and e-commerce industry that is ideal for investment banking, corporate finance, and Retail professionals and valuation experts. The model includes the following features:
- Mergers and Acquisition model and accretion and dilution analysis of the deal to Amazon shareholders as of June 30, 2017, fifteen days after the deal announcement.
- Sources and uses of funds model, purchase price allocation and calculation of goodwill in the transaction given the deal tearsheet information.
- Recalculation of Target’s earnings, earnings per share, EBITDA and revenues as of Acquirer’s December 31 fiscal year end through the process of Calendarization. The Target and the Acquirer have different fiscal year end dates.
- Recapitalized pro forma balance sheet of the combine company as well as calculation of credit statistics and leverage ratios of the Acquirer, Target and the combined company.
- Sensitivity analysis of accretion and dilution to Amazon shareholders as of June 30, 2017 given a range of the % of cash consideration in the transaction financed with debt, cost of debt and offer price.
- Impact of Target acquisition on the Acquirer as of June 30, 2017 and the value creation opportunities for Target and the Acquirer given the most appropriate range of price to earnings ratios as of 2017 and 2018.
- Contribution analysis of the deal as of June 30, 2017 and implied target share price (offer price) calculation given contribution percentages of revenues, EBITDAs and Net Income of the two parties. Appropriateness of contribution analysis given the terms of the deal and the industries the parties operate in is further examined in the model.
- Calculation of basic and diluted shares outstanding for the Acquirer and Target.
- A summary dashboard of the combined company financial report and credit statistics, market data, transaction and deal data, implied forward price to earnings multiples, sources and uses of funds, accretion and dilution analysis, and value creation opportunities for both parties.
- The tabs of the models are: Cover, Summary, Assumptions, Sources & Uses, Model, Post Transaction, Contribution, Calendarization, and Notes.
- A short report of the transaction as it pertains to the financial model describing different steps and segments of the model as of June 30, 2017 along with the print ready format of the model is included with the package.

This Best Practice includes
One PDF guideline, One PDF report, One .xlsm Financial Model

Acquire business license for $50.00

Add to cart

Add to bookmarks

Discuss

Further information

A financial model of an acquisition in the North American Retail and e-commerce industry that is ideal for investment banking, corporate finance, and Retail professionals and valuation experts.

- This financial model is a Mergers and Acquisition deal model along with many features explained in the product description. Though this is not a circular 3-statement model, 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.
- Please agree to the terms of use to be able to view the model.
- 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.


0.0 / 5 (0 votes)

please wait...