Product Description
 
(Cash Deal Financed with Debt and Cash)
 
Algonquin Power Acquisition of Ascendant Group Limited Financial Model is a financial model of an acquisition in the North American Power industry that is ideal for investment banking, corporate finance, and Power & Utility professionals and valuation experts. The deal is a cash deal financed with debt and cash. The model includes the following features:
Mergers and Acquisition model and accretion and dilution analysis of the deal to APUC shareholders as of June 7, 2019, four 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.
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 APUC shareholders as of June 7, 2019 given a range of the % of cash consideration in the transaction financed with debt as well as 2019 and 2020 synergy values.
Impact of Target acquisition on the Acquirer as of June 7, 2019 and the value creation opportunities for Target and Acquirer given the most appropriate range of price to earnings ratios as of 2019 and 2020.
Contribution analysis of the deal as of June 7, 2019 and implied target share price (offer price) calculation given contribution percentages of revenues, EBITDAs and Net Income of the two parties.
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 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 7, 2019 along with the print ready format of the model is included with the package.