Question: Please provide excel work file for this question. Here is a portion of the income statement of BuyerCo and ValueCo. These two firms are going

Please provide excel work file for this question.

Here is a portion of the income statement of BuyerCo and ValueCo. These two firms are going to merge to create a firm NewCo. Because of the merger, the sales are going to increase by 2%, the COGS are going to decrease by 10% (because of better negotiated bulk buying) and SG&A are going to increase by 5%. What is the projected EBITDA for the NewCo in 2017 (after the merger)?

Please provide excel work file for this question. Here is a portion

Income Statement BuyerCo Sales ValueCo Sales 2017 $4,771.7 2,600.0 BuyerCo COGS ValueCo COGS $3,053.9 1,612.0 BuyerCo Gross Profit Value Co Gross Profit $1,717.8 988.0 BuyerCo SG&A ValueCo SG&A $811.2 496.6 BuyerCo EBITDA ValueCo EBITDA $906.6 491.4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please provide excel answer to shivaz project question as soon as possible for question sent Saturday Thank you Sara wants to use the Regression method for the development of a regression...

3. Here is a portion of the income statement of BuyerCo and ValueCo. These two firms are going to merge to create a firm NewCo. Because of the merger, the sales are going to increase by 2%, the COGS...

Choose machine F and create tables for Sales Budget, Production Budget, Direct Materials Budget, Overhead Budget, SGA Budget, Income Statement, Cash Budget, and Balance Sheet For the six months ended...

just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question 2..BTW,please focus the every step FINANCE SPOTLIGHT...

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

can any expert help me with the below assignment just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question...

answer EA10-A1 and EA10-a2 IN EXCEL SPREAD SHEET PLEASE how is the question not clear ? i can see everything why cant the imagine description be used? Apply Your Skills If your classroom is using...

Download the most recent financial statements of Medtronic and Boston Scientific.From the attached ratio sheet pick 6 relevant ratios and compare the two companies.Then from the ratios you selected...

Please read the article and answer about questions. Why Accounting Matters to Small Business The way many people think of it, what makes a business businesslike is its focus on making money, and in...

Write an essay about Florida state's Medicaid and Childrens Health Insurance Program.

Reporting an Income Statement with Earnings per Share Romney's Marketing Company has the following adjusted trial balance at December 31, 2012. No dividends were declared. However, 500 shares issued...

When a person says, The market is up today, they are generally referring to: Their personal portfolio The Russell 2 0 0 0 Index The prices at grocery stores as measured by national supermarket...

All of the following are necessary for successful segmentation EXCEPT Groups must be heterogeneous between groups. Groups must be reachable by marketing communications. Groups must be homogeneous...

What changes should be made to the Employment Insurance program to address its present weaknesses?

Besides retirement income, what other benefits are provided through the Canada Pension Plan?

Suppose a friend of yours contracted lead poisoning on the job. What sources of income could this person rely on while recovering during the next two months? What if it took two years for your friend...