Hi guys, could you please help me with these three questions, I am wondering what is the most concise way to show in an excel so I can evaluate and come to a clear conclusion:

---

Case Questions: Lovepop

(Lovepop,Robert F. White, Ramana Nanda, and Hull, HBS case 9-818-015.

Assumptions)

• The founders own 10,000,000 of shares of common stock since starting Lovepop. There was no stock option pool.

• Lovepop is raising another two rounds of funding: the seed funding & Series A.

• In the seed round: Founder.org & Techstars offer Lovepop with different terms.

• Techstars' offer: purchase 6% of common stock for $18,000 and $100,000 convertible notes that will convert at the lower of the valuation cap at $3 million or 80% discount of post money valuation (caseExhibit 6a).

• Founder.org's offer: $300,000 convertible notes that will convert at the lower of the valuation cap at $3 million or 75% discount of post money valuation (caseExhibit 6b).

• All the first seed round convertible notes of $42,500 (Dorm Room Fund, Rough Draft Ventures & Founder.org) will convert at the same term as Series A investor (either Founder.org or Techstars).

• All seed round convertible notes will convert into equitybeforeSeries A investor.

• For simplicity, we exclude accrued interests, i.e., total convertible notes are as shown in Exhibit 5 & Exhibit 6A
• ForFounder.org'scase:$342,500
• ForTechstars.org'scase:$142,500.

• The Series A round of financing: Investors offer $2 million at a $10 million post- money valuation.

• The Series A financing terms included a provision that Lovepop must decide a stock option pool that will equal 10% of the company's fully diluted shares before Series A.

Questions

1. Calculate the capital table after Series A.
2. What is the ownership of the two founders if they were to accept the offer of Techstars Boston or Founder.org? Show the capitalization tables of the two financing options. (Note: Please show the calculation method of the Capital Table in the Excel File)
3. Who would be the best financial partner for Lovepop, Techstars Boston or Founder.org, or neither of them? Why? Discuss the benefits and potential concerns of working with incubators, accelerators, angels and VCs.