Please complete this question using excel.
5. (TCO H) Your management team identifies LipLife as a business to acquire. LipLife owns the technology for a new lipstick that lasts five days and changes hues each night. The firm’s founders are out of money and want to sell their lipstick algorithm and the technologies it is based on. Because you and your team don’t have enough money to acquire the firm outright on your own, you turn to outside sources of funding. A venture bank is willing to put up a $5 million, six-year loan at 13% per year, which only has interest payments due during its life; the principal balance will be paid off at the liquidity event. Your team puts up $2 million of its own capital. One of your friends from the MBA program is a venture capitalist. His firm agrees to invest $2 million at an expected 40% annual return for six years, at which time it expects a liquidity event in order to obtain its money and return back. Include all your calculations to support each answer in order to earn full credit. Answers must be completed in sequence.
Required:
(a) Assume that in six years, LipLife will have an expected exit enterprise value of $27 million, based on an expected exit EBITDA of $2.25 million. What does this indicate the firm’s expected exit EBITDA multiple will be?
(b) Given the future value calculated in (a), what will be the equity value at that time?
(c) Because the VC firm expects a 40% compound return on its investment, what would be the dollar value of its portion of the equity value you calculated in (b)?
(d) Based on your answer in (c), what would be the amount of the equity up front that you would have to give up in order to obtain LipLife’s original venture capital investment?
(e) What will be the dollar value of the management team’s original $2 million equity investment at the time of the liquidity event? (Points : 50)
What are the key elements of an essay
You may clearly understand what an essay is and have had the experience of writing a number. However, it is […]
Feb 25th, 2022
How to write a research paper fast
The day inevitably comes; you need to submit your assignment. You have been procrastinating on writing your paper until the […]
Feb 24th, 2022
220+ best humanities research paper topics
Choosing a paper topic can be a daunting task for any assignment. A student may face agony trying to come […]
Feb 24th, 2022
How to write a media analysis essay
The media is an integral part of modern society. Think of what would happen to the world if there were […]
Feb 23rd, 2022
Great tricks on how to write a hypothesis in 2022
A hypothesis is a statement that can be proven by scientific research. It proves the theory of action and reaction, […]
Feb 22nd, 2022