Hello, I have attached two files; a Word document with the question and an Excel template. Thank you for your assistance!

Brazos Winery was established eight years ago by Anna and Jerry Lutz with the purchase of 200 acres of land. The purchase was followed by a period of intensive planting and development of the grape vineyard. The vineyard is now entering its second year of production. In March 2015, the Lutzes determined that they needed to raise $500,000 to purchase equipment to bottle their private-label wines. Unfortunately, they have reached the limits of what their banker can finance and have put all their personal financial resources into the business. In short, they need more equity capital, and they cannot provide it themselves. Their banker recommended that they contact a venture capital (VC) firm in New Orleans that sometimes makes investments in ventures such as the Brazos Winery. He also recommended that they prepare for the meeting by organizing their financial forecast for the next five years. The banker explained that VCs generally target a five-year term for their investments, so it was important that they provide the information needed to value the winery at the end of five years. After doing a careful analysis, the Lutzes estimate that their venture will generate earnings before interest, taxes, depreciation, and amortization (EBITDA) in five years of $1.2 million. In addition to the EBITDA forecast, the Lutzes estimate that they will need to borrow $2.4 million by 2019 to fund additional expansion of their operations. Their banker indicated that his bank could be counted on for $2 million in debt, assuming they were successful in raising the needed equity funds from the VC. Furthermore, the remaining $400,000 would be in the form of accounts payable. Finally, the Lutzes believe that their cash balance will reach $300,000 at the end of five years. The Lutzes are particularly concerned about how much of the firm's ownership they will have to give up in order to entice the VC to invest. The VC offers three alternative ways of funding the winery's $500,000 financing requirements; each alternative calls for a different ownership share: Straight common stock that pays no dividend. With this option, the VC asks for 60% of the firm's common stock in five years. Convertible debt paying 10% annual interest and 40% of the firm's common stock at conversion in year 5. Convertible preferred stock with a 10% annual dividend and the right to convert the preferred stock into 45% ownership of the firm's common stock at the end of year 5. A) If the VC estimates that the winery should have an enterprise value equal to six to seven times estimated EBITDA in five years, what do you estimate the value of the winery to be in 2019? What will the equity in the firm be worth? (Hint: Consider both the six and seven-times-EBITDA multiple). B) Based on the deal terms offered, what rate of the return does the VC require for each of the three financing alternatives? Which alternative should the Lutzes select based on the expected cost of financing? C) What is the pre and post-money value of the firm based on the three sets of deal terms offered by the VC? Why are the estimates different for each of the deal structures? PROBLEM 10-7 Given Target EBITDA sales multiples EBITDA (Year 5) Funds raised Cash (Year 5) Interest bearing debt (year 5) Investment horizon for VC Solution Legend $ $ $ $ $ 6.00 1,200,000 500,000 300,000 2,000,000 5 years 7.00 Alternative Deal Structures Stated Rate of Return Ownership % Dividend rate on common 0.00% 60.00% Coupon (convertible bonds) 10.00% 40.00% Dividend rate (convertible pfd) 10.00% 45.00% Solution a. Enterprise valuation 6 times multiple times multiple 7 EBITDA x EBITDA Multiple Plus: Cash Enterprise value Less: Interest Bearing Debt Equity Value in year 5 300,000 300,000 (2,000,000) (2,000,000) b. Analysis of alternative deal structures Common Stock $ Terminal cash flow (equity ownership) % Required Return by VC Convertible Bonds Annual interest $ Terminal cash flow (equity ownership) % Required Return by VC Preferred Stock Annual dividends $ Terminal cash flow (equity ownership) % Required Return by VC c. Analysis of pre- and post-money values of Brazos Winery's equity Common Stock Post-money value of the firm's equity Less: Invested Capital (500,000.00) Pre-money value Convertible Debt Post-money value of the firm's equity Less: Invested Capital Pre-money value Convertible Preferred Stock Post-money value of the firm's equity Less: Invested Capital Pre-money value d. e. (500,000.00) (500,000.00) = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer requ = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output