In 2014, 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 from a family friend. The senior debt pays 10% interest, while the subordinated debt pays 12% interest and is convertible into 10% of the firms equity ownership at the option of the investor, J Martin Capital. Both debt issues have ten-year maturities. In March 2015, the firms financial structure appeared as follows:

Dub Tarun Inc., March 2015

Accounts payable $100,000

Short-term notes 150,000

Total short-term debt $250,000

Senior debt (10% interest rate) 200,000

Subordinated debt (12% interest rate, convertible into 10% stock) 100,000

Equity (Dub Tarun) 200,000

Total debt and equity $750,000

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 firms EBITDA will be $650,000 in five years. Although Dub isnt interested in selling his firm, his banker recently told him that businesses like his typically sell for five to seven times their EBITDA. Moreover, by March 2020, Dub expects that the firm will have $300,000 in cash and that the firms pro forma debt and equity will be as follows:

Dub Tarun Inc. Pro Forma Financial Structure, March 2020

Accounts payable $ 200,000

Short-term notes 250,000

Total short-term debt $ 450,000

Senior debt (10%) 400,000

Subordinated debt (12%, convertible into 10% of the firms stock) 100,000

Equity (Dub Tarun) 800,000

Additional financing needed 250,000

Total debt and equity $2,000,000

a. What would you estimate the enterprise value of Dub Tarun Inc. to be on March 2020? (Hint: Enterprise value is typically estimated for private companies using a multiple of EBITDA plus the firms cash balance.) If the subordinated debt converts to common in 2020, what is your estimate of the value of the equity of Dub Tarun in 2020?

b. If the estimated enterprise value of the firm equals your estimate in Problem (a), what rate of return does the subordinated debt holder realize if he converts in 2020? Would you expect the subordinated 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 preferred stock, what share of the company would he need, based on your estimate of the value of the firms equity in 2020? What is your estimate of the ownership distribution of Dub Taruns equity in 2020, assuming that the new investor gets what he requires (to earn his 45% required rate of return) and the subordinated debt holder converts to common? What rates of return do each of the equity holders in the firm expect to realize by 2020, 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 Taruns expected rate of return if the EBITDA multiple were five or seven?

e. What was the post-investment and pre-investment value of Dub Taruns equity in 2015, based on the investment of the new investor?

Please answer in excel and show how you calculated it.