Please answer a the question(s) below using the attached document:
a. (15 points) In Excel, create a pro forma income statement for Green Mountain for 2012 through 2016.
b. (15 points) Refer to the pro forma income statement and excerpt from the pro forma balance sheet below. All numbers are in thousands of dollars. What are Green Mountain’s free cash flows for 2012 through 2016? You may provide your answer in Excel.
c. (10 points) Based on your previous answers and using a DCF analysis, what is Green Mountain’s current (as of September 27, 2011) enterprise value? Equity value? Price per share? Use the EBITDA multiple method to calculate the terminal value, and assume the appropriate multiple is 7x EBITDA.
d. (4 points) If you were the CEO of Green Mountain, it may be reasonable for you to expect an unsolicited offer from someone to buy your firm. Given your calculations in part (c), what is the minimum price (equity value) at which you would consider selling? Briefly explain your answer.
Alicia loses her job part way through 2019. Her employer pays her wages of $15,450 up through her date of termination. After that, she received $3,400 of unemployment com...Aug 23 2020
Hornberg Cost Accounting Ch4*Please fill in the blanks and include calculations with explanations for the calculations. Thank you.Side-by-side prints custom training mate...Aug 10 2021
Graphing Polar Equations Use a graphing utility to graph the polar equation for and for the integers to . What values of n produce the “heart” portion of the curve? Wh...Aug 15 2021
Which of the following statement(s) is/are true?an electron in a hydrogen atom is excited from the ground state to the n=4 state(a) n=4 is the first excited state.(b) It ...Jul 23 2021
Heat transfer from a wall to a falling film (short contact time limitI2 (Fig. 12B.4). A cold liquid film flowing down a vertical solid wall, as shown in the figure, has a...Aug 06 2020
What do we call a good with an income elasticity less than zero?Here is a tip:The income elasticity of demand is defined as the degree of responsiveness of the quantity d...Jul 11 2021
On November 28, 20x7, Barrett Company purchased 20,000 shares of HAL Corporation common stock for $360,000. Barrett's management intends to hold the shares for a shor...Jan 11 2020
E 16-14 Partnership retirement—Revaluation and bonus approachesThe capital account balances and profit- and loss-sharing ratios of the Byd, Box, Dar, and Fus partnership ...Sep 15 2020
A group of smokers brought suit against tobacco producer Altria, alleging that they were misled by the Altria and other cigarette producers' ads and labels on its cigaret...Aug 23 2021
You want to find out whether the log price of Money Supply (money_supply) is cointegrated with the log value of Inflation (inflation). You collected data for both variabl...Jun 07 2021