Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a and b in excel pls You are the owner of the Blue Bourbon Company we went over in class, and you decided against selling
a and b in excel pls
You are the owner of the Blue Bourbon Company we went over in class, and you decided against selling your business. Luckily, you have found the Red Bourbon Company that is similar in size and you get along with their owners. But they have more efficient operations and greater sales (see parameters in template). You and the owner of the Red Bourbon Company decide to merge your businesses rather than sell to big corporates. a. Build the pro forma and free cashflow for Big Red Bourbon Company b. Build the pro forma and free cashflow for the Combined business assuming you both adopted the more efficient manufacturing processes and capabilities of Big Red Bourbon company [Hint: don't overcomplicate this] c. What is the Discounted Cashflow Value (DCF) and enterprise value (EV) of the combined businesses? d. What is the DCF and enterprise value of the combined business if mid-year cashflows are used? e. What is the change in the DCF value of the combined businesses if you changed the COGS 30% to 60% (increment by 5% ) and changed the tax rate from 30%40% (increment by 2% ) [Hint: data table] Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started