LendingClub LC Problem
Part A
| Peer Companies: | LendingClub | Solution Legend | ||||||
| Ticker | LC | = Value given in problem | ||||||
| PERIOD ENDING | = Formula/Calculation/Analysis required | |||||||
| Relevant Items from Income Statement and Balance Sheet | = Qualitative analysis or Short answer required | |||||||
| Shares Outstanding | ||||||||
| 41982.0 | ||||||||
| Market Capitalization | ||||||||
| Calculated Multiples | ||||||||
| LendingClub | ||||||||
| Your assumptions and Sources | ||||||||
A. Choose several peer companies for LendingClub and justify your choice. Choose several valuation multiples and using comparable ratios of peer companies (as we did in Project 2 and discussed in Conferences) and LendingClub financial information from the prospectus, estimate the company’s hypothetical stock price on December 9, 2014. It is required for this question to list your major assumptions and properly reference sources of information that you used in your calculations.
Part B
| Value given in problem | |||||||
| Formula/Calculation/Analysis required | |||||||
| Qualitative analysis or Short answer required | |||||||
| Your assumptions | |||||||
| Comparable Companies Unlevered Beta | |||||||
| Company Author: Author: Please replace stabs below by real peers names. The number of peers does not have to be five | Levered Beta | Market Value of Debt | Market Value of Equity | Debt/ Equity | Equity/ Total Assets | Marginal Tax Rate | Unlevered Beta |
| Peer Company A | |||||||
| Peer Company B | |||||||
| Peer Company C | |||||||
| Peer Company D | |||||||
| Peer Company E | |||||||
| Median | |||||||
| Mean | |||||||
| Relevered Beta | Mean Unlevered Beta | Target Debt/ Equity | Target Marginal Tax Rate | Relevered Beta | |||
| LendingClub | |||||||
| WACC Calculation | |||||||
| Company's Capital Structure | |||||||
| Debt to Total Capitalization | |||||||
| Equity to Total Capitalization | |||||||
| Debt to Equity Ratio | |||||||
| Cost of Equity | |||||||
| Risk-free rate | |||||||
| Market risk Premium | |||||||
| Levered Beta | |||||||
| Cost of Equity | |||||||
| Cost of Debt | |||||||
| Cost of Debt | |||||||
| Taxes | |||||||
| After Tax Cost of Debt | |||||||
| WACC |
Using the same peers and industry data, please estimate LendingClub 's WACC. Show all your data used for calculations. Again, please state all your assumptions and sources of information.
Part C
| Your Estimated Price Range | |
| Min | |
| Max | |
| Expected | |
| IPO Price | |
| Opening Price | |
| Closing Price | |
| Your explanation | |
LendingClub went public on December 10, 2014. How do your valuations compare to the company’s IPO price? How do they compare to its first trading day opening and closing prices? If your valuations differ from observed prices, can you briefly forward any possible explanations?
Part D
| Value given in problem | ||||
| Formula/Calculation/Analysis required | ||||
| Qualitative analysis or Short answer | ||||
| Series C | ||||
| Investment date | 4/1/10 | |||
| Investment | $4,879,999 | |||
| Shares invested | 12,451,360 | |||
| Series D | ||||
| Investment date | 4/1/11 | |||
| Investment | $3,233,022 | |||
| Shares invested | 3,635,264 | |||
| IPO Date | 12/10/14 | |||
| Number of common shares | 50,822,020 | |||
| IPO Price | ||||
| Total Value | ||||
| Second Date | 4/17/15 | |||
| Price | ||||
| Total value | ||||
| Answer | ||||
| Return at IPO | ||||
| 42111.0 | ||||
| Did Norwest actually sell at IPO? Support your answer by evidence | ||||
| Solution | ||||
In April 2010 Norwest Venture Partners X acquired 12,451,360 shares of Series C preferred stock for aggregate consideration of $ $4,879,999. In April 2011 the same fund acquired 3,635,264 shares of Series D preferred stock for aggregate consideration of $ 3,233,022. The stock never paid dividend. At IPO all preferred stock was converted to common shares and in exchange for its preferred shares Norwest received 50,822,020 common shares. If Norwest sold shares at IPO, what its annualized return would be? Did Norwest actually sell at IPO (support your answer by evidence)? If Norwest sold shares at market closing on April 17, what its annualized return would be?
Part E
| Solution Legend | |||||||||||
| = Value given in problem | |||||||||||
| = Formula/Calculation/Analysis required | |||||||||||
| = Qualitative analysis or Short answer required | |||||||||||
| Part E | |||||||||||
| Given | Risk-neutral probability formula | ||||||||||
| Value Now | $ 300.00 | ||||||||||
| Value increase (%), u | 10% | ||||||||||
| Value decrease (%), d | -20% | ||||||||||
| Risk free Interest rate, r | 3% | ||||||||||
| License Fee (in $ millions) | $ 250.00 | ||||||||||
| Risk-neutral probability | |||||||||||
| Discount factor (exp(-risk free rate)) | |||||||||||
| Solution | |||||||||||
| Today | Year One | Year Two | Year Three | ||||||||
| $ 399.3000 | |||||||||||
| $ 363.0000 | |||||||||||
| $ 330.0000 | $ 290.4000 | ||||||||||
| LendingClub | $ 300.000 | $ 264.0000 | |||||||||
| Value of waiting (NPV-Waiting) | |||||||||||
| Value of Exercising Option (NPV-Exercise) | |||||||||||
| Value | $ 240.0000 | $ 211.2000 | |||||||||
| $ 192.0000 | |||||||||||
| $ 153.6000 | |||||||||||
| Your recommendation | |||||||||||
The terminal period growth rates were estimated such that the intrinsic valuation of the firm's equity would equal the current market capitalization of the firm using the "Goal Seek" function.
A. The following information is for pedagogical purposes only and unlike earlier questions does not deal with real situation. There are rumors that LendingClub is negotiating a three year agreement with WellsFargo, according to which LendingClub will have a right to sell its proprietary trading software to WellsFargo at the beginning of any year in this three-year period. Once LendingClub sells the software, it receives a one-time license fee of $ 250 M, but it cannot serve Wells Fargo clients anymore. The current value of Wells Fargo clients to LendingClub is estimated to be $60 M. Each year this value can go up 10% or down 20% in comparison with the previous year. If the risk-free rate is 3%, how much this agreement is worth to LendingClub? What should the company do over three years? Please provide as many details as possible in your explanations and support them by numbers. (Hint: think about this as an American put option)
(
)
d
u
d
rt
S
S
S
rt
p
d
u
d
-
+
-
=
-
-
=
)
1
(
exp
)
exp(
du
drt
SS
Srt
p
du
d
)1(exp
)exp(