Firm Synergy Valuation Worksheet Xlsx
Save, fill-In The Blanks, Print, Done!
Download Firm Synergy Valuation Worksheet Xlsx
Microsoft Spreadsheet (.xlsx)- This Document Has Been Certified by a Professional
- 100% customizable
- This is a digital download (23.53 kB)
- Language: English
- We recommend downloading this file onto your computer.
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!
Download this Firm Synergy Valuation Worksheet Xlsx template
now and enhance your business!
Do you need
more information? AllBusinessTemplates.com provides many kinds of legal and
business templates in the range from IT, Environmental, Startups, Marketing,
Sales, Procurement, Law, Notary, Finance, HR, Auction, Logistics,
Transportation, Maintenance Services, etc. Just search on our website and have
instant access to thousands of free and premium business document templates,
forms, letters, reports, plans, resumes used by professionals in your industry.
All business templates are easy to find, crafted by professionals, ready to
use, easy to customize and intuitive.
DISCLAIMER
Nothing on this site shall be considered legal advice and no attorney-client relationship is established.
Leave a Reply. If you have any questions or remarks, feel free to post them below.
Related templates
Latest templates
Latest topics
- Christmas Templates
Christmas is coming soon... Be prepared with nice Christmas letters, invitations, social posts etc and check out these Christmas templates now! - IT Security Standards Kit
What are IT Security Standards? Check out our collection of this newly updated IT Security Kit Standard templates, including policies, controls, processes, checklists, procedures and other documents. - GDPR Compliance Templates
What do you need to become GDPR compliant? Are you looking for useful GDPR document templates to make you compliant? All these compliance documents will be available to download instantly... - Invoice Templates
What exactly is an invoice, and what is the difference between the terms “receipt” and “bill”? Check out our Invoice, Bill & Receipt templates. - Best Calendar Templates
How do you make a nice calendar? Are you looking for nice calendar templates in MS Word, Excel or PowerPoint to improve your personal efficiency and effectiveness? These easy to modify calendar templates can help you out!
cheese
