# Firm Synergy Valuation Worksheet Xlsx

## Guardar, completar los espacios en blanco, imprimir, listo!How to make a professional Synergy Valuation? Check out this Excel Worksheet that allows to make a Synergy Valuation of a company.

Formatos de archivo disponibles:

.xlsx

• Este documento ha sido certificado por un profesionall
• 100% personalizable

Calificación de la plantilla： 8

Malware en virus vrij：

Business Negocio Finance Financiar economy economía money dinero expense gastos investment inversión Business Economics Negocios económicos Firm Firma Market (Economics) Mercado (Economía) Financial Accounting Contabilidad financiera Economics Ciencias económicas Depreciation Depreciación Revenue Ingresos Current Corriente Financial Economics Economía Financiera Growth Crecimiento Rate Tarifa Economic Growth Crecimiento económico Present Value Valor presente Beta (Finance) Beta (Finanzas) Terminal Value (Finance) Valor Terminal (Finanzas)

How to make a professional Synergy Valuation? Check out this Excel Worksheet that allows you to make a Synergy Valuation of a company.

SYNERGY VALUATION WORKSHEET
Input: information on the bidding firm, current financial information, revenues in the current year. This ready-made calculation worksheet is well suited for any kind of personalized business matter.

(1) It is not simple to back out the growth rates for the combined firm when there is no synergy because growth rates will change.
(2) It is far simpler to remember that in the absence of synergy the cashflows, terminal value and present value of the combined firm
will always be equal to the sum of the same for the individual firms.
(3) To back out the terminal growth rate of the combined firm in the absence of synergy, use the combined terminal value estimated
in conjunction with the required rate of return to solve for the terminal growth rate.

STEPS IN VALUING SYNERGY
1. Value each firm separately, projecting out free cash flows and terminal value.
2. Value the combined firm assuming no synergy. (Add up the present values for the two firms estimated  in step 1)
3. Prepare a cash flow statement for the combined firm by just adding up the items on the individual firms' statements.
4. Evaluate where the gains from synergy are going to come from. (Higher revenue growth or lower costs)
5. Translate the synergy gain into dollars on the combined statement. If revenues are going to grow faster because of the synergy
apply a faster growth rate to revenue in the combined statement. If costs are going to be cut, show the reductions in costs on the statement.
6. Calculate the value of the combined firm with the changes made in step 5.
7. Compare to the value in step 2. The difference is the synergy gain. This is the MOST that one should as a takeover premium.

We support you by providing this template, which will save you time, cost and efforts and help you to reach the next level of success in your career and business!

Nada en este sitio se considerará asesoramiento legal y no se establece una relación abogado-cliente.

Deja una respuesta. Si tiene preguntas o comentarios, puede colocarlos a continuación.