LendingClub LC Problem

profileOliviaSmart
lendingclub_lc.xlsx

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(