In 2005 Dub Tarun founded a firm using $200,000 of his own money, $200,000 in senior (bank) debt, and an additional $100,000 in subordinated debt borrowed froma family friend. The senior debt pays 10% interest, while the sub-debt pays 12% interest and is convertible into 10% of the firm's equity ownership at the option of the investor, J Martin Capital. Both debt issues have 10-year maturities. In March 2006 the firm's financial structure appears as follows: (the table is attached in the spreadsheet)
Dub has determined that he needs an additional $250,000 if he is going to continue to grow his business. To raise the necessary funds, he intends to use an 8% convertible preferred stock issue.
Dub projects that the firm's EBITDA (earnings before interest, taxes, depreciation, and amortization) in five years will be $650,000. Although Dub isn't interested in selling his firm, his banker recently told him that businesses like this
typically sell for five to seven times their EBITDA. Moreover, by March 2011 Dub expects that the firm will have $300,000 in cash and the firm's pro forma debt and equity will be as follows: (the table attached in the spreadsheet)
a. What would you estimate the enterprise value of Dub Tarun, Inc. to be on March 2011? (hint: Enterprise value is typically estimated for private companies using a multiple of EBITDA plus the firm's cash balance.) If the sub debt converts to common in 2011, what is your estimate of the value of the equity of Dub Tarun in 2011?
b. If the estimated enterprise value of the firm equals your estimate in question a, what rate of return does the sub debt holder realize if he converts in 2011? Would you expect the sub debt holder to convert to common stock?
c. If the new investor were to require a 45% rate of return on his $250,000 purchase of convertible preffered stock, what share of the company would he need, based on your estimate of the value of the firm's equity in 2011? What is your estimate of the ownership distribution of Dub Tarun's equity in 2011, assuming the new investor gets what he requires (to earn his 45% required rate of return) and the sub debt holder converts to common? What rates of return do each of the equity holders in the firm expect to realize by 2011 based on your estimate of equity value? Does the plan seem reasonable from the perspective of each of the investors?
d. What would be Dub Tarun's expected rate of return if the EBITDA multiple were five or seven?
e. What is the post-investment and pre-investment value of Dub Tarun's equity in 2006 based on the investment of the new investor?© BrainMass Inc. brainmass.com October 25, 2018, 12:50 am ad1c9bdddf
This is a financial analysis of a firm with debt issues.
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 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?
D. How is the cost of financing affected by the EBITDA multiple used to determine enterprise value? Is it in the VC's best interest to exaggerate the size of the multiple or to be conservative in his estimates? Is it in the entrepreneurs' best interest to exaggerate the estimated EBITDA levels or to be conservative? If entrepreneurs are naturally optimistic about their firm's prospects, how should the VC incorporate this into his deal-structuring considerations?
E. Discuss the pros and cons of the alternative sources of financing.View Full Posting Details